Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of âgoâ or âno goâ on the project. Use your Investment Return Analysis as an example for this capital budget analysis.
Project Inputs:
WACC â Debt is 75% and Equity is 25% of this firmâs capital structure. Interest rate on the debt is 7.5%, firmâs tax rate is 30%. Firmâs beta is 1.25, Risk Free Rate is 2.0%, Market Return Rate is 11.0%.
Project Investment Outlay, Year 0 - $1,000,000
Project Investment Life â 10 years
Project Depreciation - $100,000 / year
Project Salvage Value - $30,000
Working Capital Base of Annual Sales â 10%
Expected inflation rate per year â 3.0%
Project Tax Rate â 30%
Units sold per year â 40,000
Selling Price per Unit, Year 1 - $40.00
Fixed operating costs per year excluding depreciation - $175,000
Manufacturing (Variable) costs per unit, Year 1 - $30.00
Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of âgoâ or âno goâ on the project. Use your Investment Return Analysis as an example for this capital budget analysis.
Project Inputs:
WACC â Debt is 75% and Equity is 25% of this firmâs capital structure. Interest rate on the debt is 7.5%, firmâs tax rate is 30%. Firmâs beta is 1.25, Risk Free Rate is 2.0%, Market Return Rate is 11.0%.
Project Investment Outlay, Year 0 - $1,000,000
Project Investment Life â 10 years
Project Depreciation - $100,000 / year
Project Salvage Value - $30,000
Working Capital Base of Annual Sales â 10%
Expected inflation rate per year â 3.0%
Project Tax Rate â 30%
Units sold per year â 40,000
Selling Price per Unit, Year 1 - $40.00
Fixed operating costs per year excluding depreciation - $175,000
Manufacturing (Variable) costs per unit, Year 1 - $30.00