Explore BrainMass

Capital Planning

The director of finance has discovered an error in his WACC calculation. He did not factor in the tax rate when determining the cost of debt. UPC has a line of credit at 4% interest, and the company is taxed at 30%. Further, assume that UPC's required rate of return on equity is 14%, and its capital structure is 40% debt and 60% equity. Additionally, the budget committee question and answer session revealed that UPC has discovered a technology that will increase its product life span by 1 year. The new technology will add $120,000 and $130,000 to projects A and B's initial capital outlay, respectively. Further, the finance department has determined that cash flows for years 1, 2, and 3 will be unchanged. However, net cash flows for year 4 will be $300,000 and $150,000 for projects A and B, respectively.

With the information provided in the Excel document attached and above information I need help with the following:

1) Calculating the NPV, IRR, MIRR, and payback periods from projects A and B. (Help with putting data into an Excel spreadsheet and showing all formulas.)

2) Explain the risk factors inherent in the budgeting for the 2 projects.


Solution Summary

The following posting helps with various problems involving capital planning. It helps calculate NPV, IRR and MIRR and payback periods. It also explains the risk factors inherent in budgeting for projects.