Shopping Cart
Your shopping cart is empty!
FIN 571 Wk 5 Apply Wk 5 Quiz (with Excel File)
$12.00

FIN 571 Wk 5 Apply Wk 5 Quiz (with Excel File)

This Tutorial was purchased 3 times & rated No rating by student like you.

 

This Tutorial contains following Attachments

  • FIN 571 NJ Wk 5 Apply Wk 5 Quiz.xlsx

This Tutorial contains Excel file which can be used for any values 1 Top hedge fund manager Sally Buffit believes that a stock with the same market risk as the S&P 500 will sell at year-end at a price of $41. The stock will pay a dividend at year-end of $2.00. Assume that risk-free Treasury securities currently offer an interest rate of 1.6%. Average rates of return on Treasury bills, government bonds, and common stocks, 1900–2017 (figures in percent per year) are as follows. Portfolio Average Annual Rate of Return (%) Average Premium (Extra return versus Treasury bills) (%) Treasury bills 3.8 Treasury bonds 5.3 1.5 Common stocks 11.5 7.7 ________________________________________ a. What is the discount rate on the stock? (Enter your answer as a percent rounded to 2 decimal places.) Discount Rate: 10% b. What price should she be willing to pay for the stock today? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Stock Price: 51.82 2 Assume these are the stock market and Treasury bill returns for a 5-year period: Year Stock Market Return (%) T-Bill Return (%) 2013 33.20 0.11 2014 12.70 0.11 2015 −3.20 0.11 2016 14.40 0.06 2017 23.50 0.08 ________________________________________ Required: a. What was the risk premium on common stock in each year? b. What was the average risk premium? c. What was the standard deviation of the risk premium? (Ignore that the estimation is from a sample of data.) What was the risk premium on common stock in each year? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Year Risk Premium 2013 % 2014 % 2015 % 2016 % 2017 What was the average risk premium? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Average risk premium % What was the standard deviation of the risk premium? (Ignore that the estimation is from a sample of data.) (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Standard deviation 3 A stock is selling today for $75 per share. At the end of the year, it pays a dividend of $3 per share and sells for $84. Required: a. What is the total rate of return on the stock? b. What are the dividend yield and percentage capital gain? c. Now suppose the year-end stock price after the dividend is paid is $69. What are the dividend yield and percentage capital gain in this case? What is the total rate of return on the stock? (Enter your answer as a whole percent.) Rate of return What are the dividend yield and percentage capital gain? (Enter your answers as a whole percent.) Dividend yield % Capital gains yield % Now suppose the year-end stock price after the dividend is paid is $69. What are the dividend yield and percentage capital gain in this case? (Negative amounts should be indicated by a minus sign. Enter your answers as a whole percent.) Dividend yield % Capital gains yield % 4 You purchase 100 shares of stock for $50 a share. The stock pays a $2 per share dividend at year-end. a. What is the rate of return on your investment if the end-of-year stock price is (i) $48; (ii) $50; (iii) $55? (Leave no cells blank - be certain to enter "0" wherever required. Enter your answers as a whole percent.) Stock Price Rate of Return 48 % 50 % 55 % b. What is your real (inflation-adjusted) rate of return if the inflation rate is 3%? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Negative amounts should be indicated by a minus sign.) Stock Price Real Rate of Return 48 % 50 % 55 % 5 Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.20 −4 % 19 % Normal economy 0.40 20 % 9 % Boom 0.40 26 % 8 % ________________________________________ a. Is it reasonable to assume that Treasury bonds will provide higher returns in recessions than in booms? • No • Yes b. Calculate the expected rate of return and standard deviation for each investment. (Do not round intermediate calculations. Enter your answers as a percent rounded to 1 decimal place.) Expected Rate of Return Standard Deviation Stocks % % Bonds % % c. Which investment would you prefer? Stock Bond Which investment would you prefer? 6 In a recent 5-year period, mutual fund manager Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the market index are given for comparison. 1 2 3 4 5 Fund −1.3 +25.0 +41.0 +12.0 +0.4 Market index −1.0 +17.0 +32.0 +11.3 −0.8 ________________________________________ a. Calculate (a) the average return on both the Fund and the index, and (b) the standard deviation of the returns on each. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. Did Ms. Sauros do better or worse than the market index on these measures? Mesozoic Fund Return Market Portfolio Return a. Average return Standard deviation b. Did Ms. Sauros do better or worse than the market index on these measures? 7 Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -5 % 13 % Normal economy 0.5 14 9 Boom 0.3 23 4 ________________________________________ Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. a. What is the rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.) Rate of Return Recession % Normal economy % Boom % b. What are the expected rate of return and standard deviation of the portfolio? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Expected return % Standard deviation % c. Would you prefer to invest in the portfolio, in stocks only, or in bonds only? Explain the benefit of diversification. Invest in 8 Here are the returns on two stocks. Digital Cheese Executive Fruit January +17 +9 February −2 +1 March +4 +5 April +6 +15 May −3 +2 June +2 +5 July −1 −2 August −7 −1 ________________________________________ Required: a-1. Calculate the variance and standard deviation of each stock. a-2. Which stock is riskier if held on its own? b. Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks. c. Is the variance more or less than halfway between the variance of the two individual stocks? Complete this question by entering your answers in the tabs below. • Req A1 • Req A2 • Req B • Req C Calculate the variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Digital Cheese Retum Executive Fruit Return Variance % % Standard deviation A2 Which stock is riskier if held on its own? Which stock is riskier if held on its own? B Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Month Portfolio Return January February March April May June C Is the variance more or less than halfway between the variance of the two individual stocks? Is the variance more or less than halfway between the variance of the two individual stocks? 9 A stock with a beta of 0.9 has an expected rate of return of 10%. If the market return this year turns out to be 8 percentage points below expectations, what is your best guess as to the rate of return on the stock? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal place.) Stock return 10 The risk-free rate is 7% and the expected rate of return on the market portfolio is 14%. a. Calculate the required rate of return on a security with a beta of 2.45. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Required return b. If the security is expected to return 16%, is it overpriced or underpriced? • Overpriced • Underpriced 11 Consider the following two scenarios for the economy and the expected returns in each scenario for the market portfolio, an aggressive stock A, and a defensive stock D. Rate of Return Scenario Market Aggressive Stock A Defensive Stock D Bust –5 % –7 % –3 % Boom 27 35 19 ________________________________________ Required: a. Find the beta of each stock. b. If each scenario is equally likely, find the expected rate of return on the market portfolio and on each stock. c. If the T-bill rate is 4%, what does the CAPM say about the fair expected rate of return on the two stocks? d. Which stock seems to be a better buy on the basis of your answers to (a) through (c)? Complete this question by entering your answers in the tabs below. • Required A • Required B • Required C • Required D Find the beta of each stock. (Round your answers to 2 decimal places.) Beta Stock A Stock D B If each scenario is equally likely, find the expected rate of return on the market portfolio and on each stock. (Enter your answers as a whole percent.) Expected Rate of Return Market portfolio % Stock A % Stock D C If the T-bill rate is 4%, what does the CAPM say about the fair expected rate of return on the two stocks? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Expected Rate of Return Stock A % Stock D % D Which stock seems to be a better buy on the basis of your answers to (a) through (c)? Better buy 12 A share of stock with a beta of 0.67 now sells for $42. Investors expect the stock to pay a year-end dividend of $3. The T-bill rate is 4%, and the market risk premium is 7%. If the stock is perceived to be fairly priced today, what must be investors’ expectation of the price of the stock at the end of the year? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Stock price 13 Suppose that the S&P 500, with a beta of 1.0, has an expected return of 14% and T-bills provide a risk-free return of 5%. a. What would be the expected return and beta of portfolios constructed from these two assets with weights in the S&P 500 of (i) 0; (ii) 0.25; (iii) 0.50; (iv) 0.75; (v) 1.0? (Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter the value of Expected return as a percentage rounded to 2 decimal places and value of Beta rounded to 2 decimal places.) Expected Return Beta (i) 0 % (ii) 0.25 % (iii) 0.50 % (iv) 0.75 % (v) 1.0 % b. How does expected return vary with beta? (Do not round intermediate calculations.) The expected return by % for a one unit increase in beta. 14 The Treasury bill rate is 4%, and the expected return on the market portfolio is 13%. According to the capital asset pricing model: a. What is the risk premium on the market? b. What is the required return on an investment with a beta of 1.8? (Do not round intermediate calculations. Enter your answer as a percent rounded to 1 decimal place.) c. If an investment with a beta of 0.9 offers an expected return of 8.3%, does it have a positive or negative NPV? d. If the market expects a return of 11.2% from stock X, what is its beta? (Do not round intermediate calculations. Round your answer to 2 decimal places.) a. Market risk premium % b. Return on investment % c. NPV d. Beta 15 A project under consideration has an internal rate of return of 18% and a beta of 0.5. The risk-free rate is 6%, and the expected rate of return on the market portfolio is 18%. a. What is the required rate of return on the project? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. Should the project be accepted? c. What is the required rate of return on the project if its beta is 1.50? (Do not round intermediate calculations. Enter your answer as a whole percent.) d. If project's beta is 1.50, should the project be accepted? a. Required rate of return % b. Accept the project c. Required rate of return % d. Accept the project 16 The Treasury bill rate is 5% and the market risk premium is 8%. Project Beta Internal Rate of Return, % P 0.70 12 Q 0.00 8 R 1.00 13 S 0.10 9 T 1.10 15 ________________________________________ a. What are the project costs of capital for new ventures with betas of 0.45 and 1.45? (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Beta Cost of Capital 0.45 % 1.45 % b. Which of the capital investments shown above have positive (non-zero) NPV's? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.) • Project P unanswered Incorrect • Project Q unanswered Incorrect • Project S unanswered Incorrect • Project T unanswered Incorrect • Project R 17 You are considering the purchase of real estate that will provide perpetual income that should average $60,000 per year. How much will you pay for the property if you believe its market risk is the same as the market portfolio’s? The T-bill rate is 5%, and the expected market return is 7.5%. Property value

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$40.00

This Tutorial was purchased 2 times & rated No rating by student like you.

The development of the new issue junk bond market had important implications for capital structure choice. The existence of a viable junk bond market means that firms can comfortably maintain higher degrees of leverage than they could prior to the development of this market. Do you agree or disag..
$10.00

This Tutorial was purchased 26 times & rated A+ by student like you.

The executive team of New Heritage Doll has completed the decision making for capital budgeting for the firm. Now the team must decide which decisions and approach were the best for the company. The executive team must create a presentation to be given to the board members of New Heritage Doll Comp..
$3.00

This Tutorial was purchased 8 times & rated B+ by student like you.

Because the weighted average is always a correct measure of a required return, why do firms not create securities to finance each project and offer them in the capital market in order to accurately determine the required return for the project? ..
$10.00

This Tutorial was purchased 19 times & rated A by student like you.

Acting as the executive team for a small company, your team will apply the principles of capital budgeting to invest in growth and cash flow improvement opportunities in three phases over 10 simulated years. Each opportunity has a unique financial profile and you must analyze the effects on working ..
$3.00

This Tutorial was purchased 2 times & rated No rating by student like you.

Phyllis believes that the firm should use straight-line depreciation for a capital project because it results in higher net income during the early years of the project’s life. Joanna believes that the firm should use the modified accelerated cost recovery system depreciation because it reduces t..
$3.00

This Tutorial was purchased 4 times & rated B+ by student like you.

A firm uses a single discount rate to compute the NPV of all its potential capital budgeting projects, even though the projects have a wide range of nondiversifiable risk. The firm then undertakes all those projects that appear to have positive NPVs. Briefly explain why such a firm would tend to ..
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

Optical Supply Company offers credit terms of 2/10, net 60. If Optical Supply is considering a change in its credit terms to one of those indicated, explain whether the change should increase   or decrease sales. (a) 2/10, net 30, (b) net 60, (c) 3/15, net 60, (d) 2/10, net 30, 30 extra..
$3.00

This Tutorial was purchased 6 times & rated A by student like you.

Why are interest rates on short-term loans not necessarily comparable to each other? Give three possible reasons. ..
$3.00

This Tutorial was purchased 4 times & rated B+ by student like you.

Suppose rf is 5% and rM is 10%. According to the SML and the CAPM, an asset with a beta of −2.0  has a required return of negative 5% [= 5 − 2(10 − 5)]. Can this be possible? Does this mean that  the asset has negative risk? Why would anyone ever invest in an asset that has an e..
$3.00

This Tutorial was purchased 1 times & rated No rating by student like you.

In order to receive proper credit, please reply to this message when posting your answers to WK2 DQ1.            Suppose you own $1 million worth of 30-year Treasury bonds. Is this asset riskless?        ..
$3.00

This Tutorial was purchased 0 times & rated No rating by student like you.

Assume that interest rates have increased substantially. Would this tend to increase or decrease      the market value (meaning the price an investor in the firm's paper is willing to pay) of a firm’s liabilities (relative to the book value of liabilities)?  ..
$3.00

This Tutorial was purchased 4 times & rated B+ by student like you.

What is ethics? If you follow all applicable rules and regulations, are you an ethical person? ..
$12.00

This Tutorial was purchased 44 times & rated B+ by student like you.

Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: • Pharmaceutical • Energy • Retail • Automotive • Computer Hardware • Manufacturing • Mining Access Yahoo Finance and enter the company name. Review the financial information an..
$10.00

This Tutorial was purchased 243 times & rated A+ by student like you.

The purpose of this assignment is to allow the student an opportunity to calculate the rate of return of equity and debt instruments. It allows the student to understand the effects of dividends; capital gains; inflation rates; and how the nominal rate of return affects valuation and pricing. The as..
$9.00

This Tutorial was purchased 129 times & rated No rating by student like you.

Purpose of Assignment The purpose of this assignment is to allow the student an opportunity to explain what it means to have an efficient capital market. Students will gain an understanding of the different levels of market efficiency and how behavioral finance can inhibit reaching market transpar..
$15.00

This Tutorial was purchased 105 times & rated B+ by student like you.

Purpose of Assignment The purpose of this assignment is to demonstrate to students how the issuance of debt to purchase outstanding common stock could affect the value of the company's equity and redefine the capital structure. The problem will also allow students to explore the effect of corporate..
$12.00

This Tutorial was purchased 191 times & rated A by student like you.

The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods. Assignment Steps Resources: Corporate Finance Create a 350-word memo to management including the following: • Describ..
$7.00

This Tutorial was purchased 69 times & rated A+ by student like you.

Resources: Harvard Business Publishing: Working Capital Simulation: Managing Growth Assignment Ch. 1 - 21 ofFundamentals of Corporate Finance WileyPLUS Assignments All additional resources from each week  Review the following scenario:  Acting as the CEO of a sm..
$8.00

This Tutorial was purchased 26 times & rated A by student like you.

Decide upon an initiative you want to implement that would increase sales over the next five years, (for example, market another product, corporate expansion, and so on). Using the sample financial statements, create pro forma statements of five year projections that are clear, concise, and e..
$10.00

This Tutorial was purchased 9 times & rated A+ by student like you.

Acting as the executive team for a small company, your team will apply the principles of capital budgeting to invest in growth and cash flow improvement opportunities in three phases over 10 simulated years. Each opportunity has a unique financial profile and you must analyze the effects on working ..
$8.00

This Tutorial was purchased 26 times & rated A by student like you.

Resource:  Financial Statements for the company assigned by your instructor in Week 2. Review the assigned company's financial statements from the past three years. Calculate the financial ratios for the assigned company's financial statements, and then interpret those results agains..
$10.00

This Tutorial was purchased 7 times & rated B+ by student like you.

The executive team of New Heritage Doll has completed the decision making for capital budgeting for the firm. Now the team must decide which decisions and approach were the best for the company. The executive team must create a presentation to be given to the board members of SNC. Compare the decis..
$8.00

This Tutorial was purchased 22 times & rated A by student like you.

Write a 350 to 700 word response to the following e-mail: Dear Consultant, I am currently starting a business and developing my business plan. I'm in need of some advice on how to start forming my business. I am not sure exactly how it will be financed and whether or not I want to take on..
$7.00

This Tutorial was purchased 12 times & rated A by student like you.

Watch the "Your Business Structure" and "Corporate Business Structures" videos on the Electronics Reserve Readings page. Identify the different business structures. Write a 350 to 700 word explanation of how each business structure might and might not be advantageous. Click the Assign..
$12.00

This Tutorial was purchased 220 times & rated A+ by student like you.

About Your Signature Assignment: This signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The sig..
$10.00

This Tutorial was purchased 22 times & rated A+ by student like you.

Select three publicly traded companies. Choose one each from the following sectors: manufacturing, service, and retail. At least one of the three companies should be foreign. If possible, choose from among the team members' places of business or similar industries. Calculate the following: • Curr..
$8.00

This Tutorial was purchased 9 times & rated A by student like you.

Discounted Cash Flows and WACC Homework Problems   Please post the answers (and show your work) in the assignments section by midnight the last day of the week assigned.     Calculate the future value of 1,535 invested today for 8 years at 6 percent. (..
$7.00

This Tutorial was purchased 3 times & rated No rating by student like you.

Operating Leverage and Forecasting Problems Team Assignment Please complete the following problems.  When calculating earnings per share and PE ratios, please show your work.  This problem is similar to the examples shown in the lecture. You manufacture hunting pack systems ..
$8.00

This Tutorial was purchased 12 times & rated A+ by student like you.

Ratio Analysis Problems Ratio Analysis (Individual Assignment)  You may use excel or word.doc format for this assignment. Please post your homework as a word.doc or excel file in the class discussion section below by the due date. 1.  Analysis of cost of goods sol..
$10.00

This Tutorial was purchased 27 times & rated A+ by student like you.

The Sarbanes-Oxley Act of 2002 (SOX) was passed as the result of the Enron scandal and other instances of accounting fraud. This act was passed to strengthen the role of the Securities and Exchange Commission (SEC). Research a case of corporate financial abuse related to the Sarbanes-Oxley Act o..
$10.00

This Tutorial was purchased 153 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following ind..
$10.00

This Tutorial was purchased 43 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to allow the students an opportunity to complete their financial evaluation of a company using the financial research database Plunkett Research Online. Plunkett Research Online provides in-depth analysis of a company's financials, comparisons..
$20.00

This Tutorial was purchased 133 times & rated A by student like you.

Question 1 The underlying assumption of the dividend growth model is that a stock is worth: A. An amount computed as the next annual dividend divided by the required rate of return. B. An amount computed as the next annual dividend divided by the market rate of return. C. The same amount compu..
$12.00

This Tutorial was purchased 15 times & rated A by student like you.

Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the..
$12.00

This Tutorial was purchased 14 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the..
$12.00

This Tutorial was purchased 17 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the..
$12.00

This Tutorial was purchased 11 times & rated A by student like you.

Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the..
$10.00

This Tutorial was purchased 21 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following ind..
$10.00

This Tutorial was purchased 7 times & rated A by student like you.

Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following ind..
$10.00

This Tutorial was purchased 29 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following ind..
$55.00

This Tutorial was purchased 37 times & rated A+ by student like you.

FIN 571 Week 1 Financial Ratio Analysis (Walmart) FIN 571 Week 1 Financial Ratio Analysis (General Motors) FIN 571 Week 2 Stock Valuation and Analysis (Apple) FIN 571 Week 2 Stock Valuation and Analysis (Amazon) FIN 571 Week 2 Stock Valuation and Analysis (Target) FIN 571 Week 2 Stock V..
$12.00

This Tutorial was purchased 5 times & rated A+ by student like you.

Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the..
$9.00

This Tutorial was purchased 2 times & rated A+ by student like you.

Assignment Content 1. Research how financial markets and institutions influence the US and global economies. Create an 8- to 12-slide presentation or 350- to 575-word summary to present your research. Choose 4 financial markets or institutions. Briefly explain what each specializes in (mo..