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..

User Account

All Pages