Calculate each project payback-npv and irr

Assignment Help Financial Management
Reference no: EM131317815

Using an EXCEL spreadsheet and showing formulas***

Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments—Project X and Project Y. Each project requires a net investment outlay of $10,000, and the opportunity cost of capital for each project is 12 percent. The projects’ expected net cash flows are as follows:

Year Project X Project Y

0 $10,000 $10,000

1 6,500 6,500

2 3,000 3,000

3 3,000 3,000

4 1,000 3,000

a. Calculate each project’s payback, NPV, and IRR. b. Which project (or projects) is financially acceptable? Explain your answer.

Reference no: EM131317815

Questions Cloud

What is the accounting break-even level of sales in terms : Dime a Dozen Diamonds makes synthetic diamonds by treating carbon. Each diamond can be sold for $120. The materials cost for a standard diamond is $60. The fixed costs incurred each year for factory upkeep and administrative expenses are $211,000. Wh..
Raises from debt holders vs equity holders : Under the assumptions of Modigliani and Miller, a firm’s average discount rate does not depend on the fraction of its financing that it raises from debt holders vs. equity holders. True or False? Why?
Why is deutsche bank the next lehman brothers : I need help in making a reaction paper on "Why is Deutsche Bank the next Lehman Brothers"
Discount the projects free cash flows : Exxon-Mobil has 50% debt and 50% equity, a WACC of 10% and a tax rate of 30%. You are evaluating a joint venture in Kuwait. This joint venture would be financed entirely with debt. You should use the company’s WACC of 10% to discount the project’s fr..
Calculate each project payback-npv and irr : Assume that you are the chief financial officer at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments—Project X and Project Y. Calculate each project’s payback, NPV, and IRR. b. Which project (or projects) is ..
What is the maximum price you will pay for bond : What is the maximum price you will pay for a bond with a face value of $1000 and a coupon rate of 14%, paid annually, if you want a yield of 10%. Assume that bond will mature in 10 years and the first payment will be received in one year
Discount the projects free cash flows : You are a financial manager at Apple, which has two divisions. One division produces phones and has an asset beta of 2.5; the other division produces cars and has an asset beta of 1.5. Apple finances itself with 100% equity. You are evaluating a new ..
What is beta of your portfolio : Portfolio Beta You own $1,300 of City Steel stock that has a beta of 1.56. You also own $5,600 of Rent-N-Co (beta = 1.86) and $4,600 of Lincoln Corporation (beta = .96). What is the beta of your portfolio (closest to)?
What is the present value of your prize at discount rate : You just won the magazine sweepstakes and opted to take unending payments. The first payment will be $21,500 and will be paid one year from today. Every year thereafter, the payments will increase by 2.5 percent annually. What is the present value of..

Reviews

Write a Review

Financial Management Questions & Answers

  What is the firms net operating working capital

The assets of Dallas & Associates consist entirely of current assets and net plant and equipment. The firm has total assets of $3 million and net plant and equipment equals $2.7 million. It has notes payable of $150,000, long-term debt of $750,000, a..

  Used when evaluating the addition of the lower-priced shoes

Walks Softly sells customized shoes. Currently, it sells 16,000 pairs of shoes annually at an average price of $68 a pair. The company is considering adding a lower-priced line of shoes that will sell for $39 a pair. Walks Softly estimates it can sel..

  Cost of common stock

Miron’s Copper Corp. management expects its common stock dividends to grow 1.77 percent per year for the indefinite future. The firm’s shares are currently selling for $21.60, and the firm just paid a dividend of $3.00 yesterday. What is the cost of ..

  What percentage of the loans could go sour

If 60 percent of its assets were loans, what percentage of the loans could go sour before the bank would lose all of its capital?

  Compute the irr for project

Compute the IRR for Project F. The appropriate cost of capital is 11 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Project F Time: 0 1 2 3 4 Cash flow –$10,400 $4,000 $4,830 $2,170 $2,800 IRR % Sho..

  Evaluate the proposed acquisition of new computer

The president of Lowell Inc. has asked you to evaluate the proposed acquisition of a new computer. The computer’s price is $60,000 and it falls into the MACRS 3-year class (33% in year 1, 45% in year 2, 15% in year 3, and 7% in year 4). Purchase of t..

  Binomial model to estimate the current value of put option

Suppose that firm Ds shares are currently selling for $38. After six months it is estimated that the share price will either rise to $43.32 or fall to $33.82. Suppose that a European put option with an exercise price of $41 is written today and will ..

  Best describes the risk measure known as beta

Which of the following best describes the risk measure known as beta? Western Electric has 23,000 shares of common stock outstanding at a price per share of $57 and a rate of return of 14.2 percent. What is the firm's weighted average cost of capital..

  What must coupon rate be on the bonds

Barnes Enterprises has bonds on the market making annual payments, with 14 years to maturity, a par value of $1,000, and a price of $953. At this price, the bonds yield 9.4 percent. What must the coupon rate be on the bonds?

  What is the required rate of return on the new portfolio

You manage a $20M mutual fund that has a beta of 1.40 and a 10.30% required return. The risk-free rate is 3.30%. You now receive an additional $5M, which you invest in stocks with an average beta of 0.80. What is the required rate of return on the ne..

  Explain what backdating stock options entails

Explain what backdating stock options entails. - Is backdating consistent with rewarding executives who help to maximize shareholder wealth?

  What is its projected available funds gap

Time bank of New York expects new deposit inflows next month of $265 million and deposit with straws of $425 million. The banks economics department has projected that new loan demand will reach $400 million and customers with approved credit lines w..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd