Question

In: Finance

Cox Healthcare Clinic is evaluating a Capital Budgeting project that costs $52,125 and has expected net...

Cox Healthcare Clinic is evaluating a Capital Budgeting project that costs $52,125 and has expected net cash flows of $12,000 per year for eight years. The first inflows occur one year after the cost outflow and the project has a cost of capital of 12 percent.

Below is a table of cash flows for the Capital Budget project:

Year Annual Cash Flow Cumulative Cash Flow
0 -$52,125 -$52,125
1 $12,000 -$40,125
2 $12,000 -$28,125
3 $12,000 -$16,125
4 $12,000 -$4,125
5 $12,000 $7,875
6 $12,000 $19,875
7 $12,000 $31,875
8 $12,000 $43,875

QUESTIONS: Answer and Respond to the Following. Please show your work.

  1. What is the project's payback?
  2. What is the project's NPV?
  3. What is the IRR?
  4. Is the project financially acceptable? Explain your answer.

Solutions

Expert Solution

Project
Year Cash flow stream Cumulative cash flow
0 -52125 -52125
1 12000 -40125
2 12000 -28125
3 12000 -16125
4 12000 -4125
5 12000 7875
6 12000 19875
7 12000 31875
8 12000 43875
Payback period is the time by which undiscounted cashflow cover the intial investment outlay
this is happening between year 4 and 5
therefore by interpolation payback period = 4 + (0-(-4125))/(7875-(-4125))
4.34 Years
Accept project as payback period is less than last project cashflow
Project
Discount rate 0.12
Year 0 1 2 3 4 5 6 7 8
Cash flow stream -52125 12000 12000 12000 12000 12000 12000 12000 12000
Discounting factor 1 1.12 1.2544 1.404928 1.5735194 1.762342 1.973823 2.210681 2.475963
Discounted cash flows project -52125 10714.29 9566.327 8541.363 7626.2169 6809.122 6079.573 5428.191 4846.599
NPV = Sum of discounted cash flows
NPV Project = 7486.68
Where
Discounting factor = (1 + discount rate)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
Accept project as NPV is positive
Project
IRR is the rate at which NPV =0
IRR 0.159988635
Year 0 1 2 3 4 5 6 7 8
Cash flow stream -52125 12000 12000 12000 12000 12000 12000 12000 12000
Discounting factor 1 1.159989 1.345574 1.56085 1.8105684 2.100239 2.436253 2.826026 3.278158
Discounted cash flows project -52125 10344.93 8918.13 7688.118 6627.7529 5713.636 4925.597 4246.246 3660.592
NPV = Sum of discounted cash flows
NPV Project = 6.17392E-05
Where
Discounting factor = (1 + IRR)^(Corresponding period in years)
Discounted Cashflow= Cash flow stream/discounting factor
IRR= 16%
Accept project as IRR is more than discount rate

jeff jeffy answered 4 weeks ago
Next > < Previous

Related Solutions

Winston Clinic is evaluating a project that costs $52,125 and has expected net cash inflows of...
Winston Clinic is evaluating a project that costs $52,125 and has expected net cash inflows of $12,000 per year for eight years. The first inflow occurs one year after the cost outflow, and the project has a cost of capital of 12 percent. a. What is the project’s payback? b. What is the project’s NPV? Its IRR? Its MIRR? c. Is the project financially acceptable? Explain your answer.
Winston Clinic is evaluating a project that costs $50,000 and has expected net cash inflows of...
Winston Clinic is evaluating a project that costs $50,000 and has expected net cash inflows of $12,000 per year for eight years. The first inflow occurs one year after the cost outflow, and the project has a cost of capital of 12%. 1. What is the project’s NPV? 2. What is the project’s IRR? 3. What is the project’s MIRR? The director of capital budgeting for Big Sky Health System, Inc. has estimated the following cash flows for a new...
Winston Clinic is evaluating a project that costs $50,000 and has expected net cash inflows of...
Winston Clinic is evaluating a project that costs $50,000 and has expected net cash inflows of $12,000 per year for eight years. The first inflow occurs one year after the cost outflow, and the project has a cost of capital of 12%. What is the project’s MIRR? (hint: remember to put the answer as a percentage). Choice: 13.9% Choice: 14.5% Choice: 5.80% Choice: 22.1%
Evaluating a capital budgeting project that costs $40,000 that is expected to generate after-tax cash flows...
Evaluating a capital budgeting project that costs $40,000 that is expected to generate after-tax cash flows of $15,000 per year for three years. If the required rate of return is 10 percent calculate the project’s (a) NPV and (b) IRR. Should the project be purchased? This is for a review Please show steps and rationale for project purchase.
You are evaluating a capital budgeting project for your company that is expected to last for...
You are evaluating a capital budgeting project for your company that is expected to last for six years. The project begins with the purchase of a $1,200,000 investment in equipment. You are unsure what method of depreciation to use in your analysis, straight-line depreciation or the 5-year MACRS accelerated method. Straight-line depreciation results in the cost of the equipment depreciated evenly over its life. The 5-year MACRS depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. Your company's WACC...
If Company XYZ plans to invest in a project with initial capital outlay $52,125, annual net...
If Company XYZ plans to invest in a project with initial capital outlay $52,125, annual net cash inflow $12,000 for 8 years, and discount rate 12%, what is the Company XYZ’s NPA, IRR, MIRR, Payback period, and Discounted Payback Period?
Project B costs $52,125. The project’s cash revenues are expected to be $12,000 per year for...
Project B costs $52,125. The project’s cash revenues are expected to be $12,000 per year for 5 years. If the WACC is 12%, what is the project's simple payback period? 0.23 years 2.22 years 4.34 years 5.94 years 10.01 years
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,500 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $8,000 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 14%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $   Project L: $   Which project would be selected, assuming they...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 12%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $   Project L: $   Which project would be selected, assuming they...
Capital Budgeting Methods Project S has a cost of $9,000 and is expected to produce benefits...
Capital Budgeting Methods Project S has a cost of $9,000 and is expected to produce benefits (cash flows) of $2,700 per year for 5 years. Project L costs $26,000 and is expected to produce cash flows of $7,100 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 10%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $    Project L: $    Which project would be selected, assuming they...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT