Need assistance
Ent141The 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.
Using the attached Excel file, the UPC scenario, and the new information above, calculate the NPV, IRR, MIRR, and payback periods from projects A and B. You
must input all of your data into an Excel spreadsheet and show all formulas.
Using MS Word, explain any risk factors inherent in the budgeting for the 2 projects.
- 9 years ago
- 20
Purchase the answer to view it
- excell.xlsx
- inherent_risk_on_the_two_projects.docx
- Management thought leaders regularly consider the future of the field
- ETH 125 Week 8 DQ 2
- ECO 205 Week 9 Capstone Discussion Question
- due in 3 hours ..500 words business risk management .the attachment is the PowerPoint for the operationall risk management
- Visual Basic Random Quiz App
- communication major paper
- CRT 205 Week 3 CheckPoint Argument Credibility Part I
- Statistics (2 assignment)
- computer architucture
- quantitative assignment