Question

In: Finance

1. An expansion project being considered by your firm has an initial cost of $8,000,000 and...

1. An expansion project being considered by your firm has an initial cost of $8,000,000 and expected net cash flows of $1,500,000 per year for the first 2 years, 1,800,000 for the third and fourth years, and $1,900,000 per year for the fifth and sixth years. All cash flows will occur at the end of each year. Assume that the project will be terminated at the end of the sixth year. Your firm’s cost of capital is 11%. Calculate the Net Present Value (NPV), the Modified Internal Rate of Return (MIRR), the Discounted Payback Period, and the Equivalent Annual Annuity for this project. Should the project be accepted? Why or why not? Give an interpretation for each of the four methods and indicate how they are used.

Solutions

Expert Solution

1. NPV = -$785,979.65

NPV Calculation:

Formula Year (n) 0 1 2 3 4 5 6
Initial investment           -80,00,000
Cash flow          15,00,000          15,00,000          18,00,000          18,00,000          19,00,000        19,00,000
(Initial investment + cash flow) Net cash flow           -80,00,000          15,00,000          15,00,000          18,00,000          18,00,000          19,00,000        19,00,000
1/(1+d)^n Discount factor @ 11%                     1.000                   0.901                   0.812                   0.731                   0.659                   0.593                 0.535
(Net cash flow*Discount factor) Discount cash flow     -80,00,000.00    13,51,351.35    12,17,433.65    13,16,144.49    11,85,715.75    11,27,557.52 10,15,817.59
Sum of all discounted cash flows NPV       -7,85,979.65

2. MIRR = 9.10%

MIRR Calculation:

Formula Year (n) 0 1 2 3 4 5 6
Net cash flow           -80,00,000          15,00,000          15,00,000          18,00,000          18,00,000          19,00,000        19,00,000
1/(1+d)^n where d = 11% Discount factor @11%                     1.000
Present value of cash outflow     -80,00,000.00
(1+c)^n where c = 11% Compounding factor @11%                   1.685                   1.518                   1.368                   1.232                   1.110                 1.000
Future value of cash in flows    25,27,587.23    22,77,105.62    24,61,735.80    22,17,780.00    21,09,000.00 19,00,000.00
Total FV of cash inflows 1,34,93,208.65

Now, in order to find MIRR,

PV of cash outflow = PV of FV of cash inflow

800,000 = 13,493,208.65 /(1+MIRR)^6

(1+MIRR)^6 = 1.6867

MIRR = (1.867)^(1/6) - 1

MIRR = 9.10%

3. Discounted Payback Period is more then the life of the project ie. beyond 6 years.

Formula Year (n) 0 1 2 3 4 5 6
Discount cash flow     -80,00,000.00    13,51,351.35    12,17,433.65    13,16,144.49    11,85,715.75    11,27,557.52 10,15,817.59
Cumulative cash flow     -80,00,000.00 -66,48,648.65 -54,31,215.00 -41,15,070.51 -29,29,354.76 -18,01,797.24 -7,85,979.65

As can be seen, the cumulative cash flow never becomes positive during the life of the project.

4. Equivalent Annual Annuity C = r*NPV/[(1 - (1+r)^-n]

However, given that the NPV is negative, C will also be negative.

EAA is useful when deciding between projects with differing lives. In this case, since only one project is being evaluated, it is not of much use.

This project should not be accepted because it has a negative NPV, its MIRR is less than the cost of capital and the discounted payback period exceeds the life of the project.


Related Solutions

An expansion project being considered by your firm has an initial cost of $8,000,000 and expected...
An expansion project being considered by your firm has an initial cost of $8,000,000 and expected net cash flows of $1,500,000 per year for the first 2 years, 1,800,000 for the third and fourth years, and $1,900,000 per year for the fifth and sixth years. All cash flows will occur at the end of each year. Assume that the project will be terminated at the end of the sixth year. Your firm’s cost of capital is 11%. Calculate the Net...
Your firm is considering a project that will cost $3 million in initial investments. The project...
Your firm is considering a project that will cost $3 million in initial investments. The project will earn cash flows of $750,000 for 6 years then terminate with no salvage value. If the WACC is 8%, what is the Net Present Value of the investment? $467,160 $487,993 $472,627 $503,679 A project calls for $5.5 million in initial investments. The project will return the following cash flows. What is the modified IRR if the WACC of 7% is applied as the...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost of the project is $300,000 with an additional installment cost of $80,000. The project life is four years, during it’s life the project will depreciate based on the following rates: • 1st year 33% • 2nd year 45% • 3rd year 15% • 4th year 7% Management has also decided that an additional of $45,000 in inventories and $12,000 in accounts payable needed if...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost of the project is $300,000 with an additional installment cost of $80,000 and a $30,000 cost for research purposes related to the project. The project’s life is four years with a salvage value of $60,000 and it will be depreciated over four years using the straight-line method. Management has also decided that $45,000 in inventories and $12,000 in accounts payable are needed if the...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost of the project is $300,000 with an additional installment cost of $80,000 and a $30,000 cost for research purposes related to the project. The project’s life is four years with a salvage value of $60,000 and it will be depreciated over four years using the straight-line method. Management has also decided that $45,000 in inventories and $12,000 in accounts payable are needed if the...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost...
Data Mining is considering an expansion project. The company’s management has decided that the initial cost of the project is $300,000 with an additional installment cost of $80,000 and a $30,000 cost for research purposes related to the project. The project’s life is four years with a salvage value of $60,000 and it will be depreciated over four years using the straight-line method. Management has also decided that $45,000 in inventories and $12,000 in accounts payable are needed if the...
A new computer network system is being considered for an organization. The initial cost of the...
A new computer network system is being considered for an organization. The initial cost of the system is $400,000. Annual maintenance and operating costs would be $25,000 per year. After 6 years, the system is expected to be worth $65,000. The desired ROI is 15% for it's projects. Determine the equivalent annual cost of the system.
A project is being considered for upgrading inventory storage facility where the cost of the project...
A project is being considered for upgrading inventory storage facility where the cost of the project would be $120,000.00. This four-year long project is expected to generate future cash flow of $45,000.00 in each year. Considering the risk associated with the project, the required rate of return should be 12%. Find Net Present Value = Internal Rate of Return = Present Value Index = Payback Period = Discounted Payback Period =
1. A project with an up-front cost at t=0 of $1500 is being considered by Nationwide...
1. A project with an up-front cost at t=0 of $1500 is being considered by Nationwide Pharmaceutical Corporation (NPC). (All dollars in this problem are in thousands.) The project’s subsequent cash flows are critically dependent on whether a competitor’s product is approved by the Food and Drug Administration. If the FDA rejects the competitive product, NPC’s product will have high sales and cash flows, but if the competitive product is approved, that will negatively impact NPC. There is a 75%...
1. A project with an up-front cost at t=0 of $1500 is being considered by Nationwide...
1. A project with an up-front cost at t=0 of $1500 is being considered by Nationwide Pharmaceutical Corporation (NPC). (All dollars in this problem are in thousands.) The project’s subsequent cash flows are critically dependent on whether a competitor’s product is approved by the Food and Drug Administration. If the FDA rejects the competitive product, NPC’s product will have high sales and cash flows, but if the competitive product is approved, that will negatively impact NPC. There is a 75%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT