14.6 The director of capital budgeting for Big Sky Health Systems Inc. has estimated the following cash flows in thousands of dollars for a proposed new service:
Year Expected Net Cash Flow
The project’s cost of capital is 10%.
a. What is the project’s payback period?
b. What is the project’s NPV?
c. What is the project’s IRR?
d. What is the project’s MIRR?
14.5. 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 cost of capital for each project is 12%. The project’s expected net cash flows are as follows:
Year Project X Project Y
0 ($10,000) ($10,000)
1 $6,500 $3,000
2 $3,000 $3,000
3 $3,000 $3,000
4 $1,000 $3,000
a. Calculate each project’s payback period?
b. Calculate net present value (NPV)?
c. Calculate internal rate of return (IRR)?
d. Which project (or projects is financially acceptable?
e. Explain your answer.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
Can these calculation be put on an excel spreadsheet? I need this by 5:00pm Anchorage, Alaska time. Is this possible???
Business & Finance homework help