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. The Weighted Average Cost of Capital also needs to be determined to complete the analysis

Spreadsheet template is provided, you need to fill in and complete the calculations.

Project Inputs:

Cost of Capital:

U.S. Treasury 10-year yield = 4.31%

S&P 500 Return = 12.5%

Capital Structure = Liabilities (55%), Equity (45%)

Firm's Cost of Debt = Prime Interest Rate plus 3%

Company's Beta = 1.40

Project Investment Outlay, Year 0 - $750,000

Project Investment Life - 5 years

Project Depreciation - $150,000 / year

Project Salvage Value - $25,000

Working Capital Base of Annual Sales - 10%

Project Tax Rate - 22%

Inflation Rate for Selling Price/unit, Variable Cost/unit, and Fixed Costs = 4.0% after Year 1

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

4 Fies 204PM. Wed oct 4 Assignment ua Ssriedshoot Terotate(2) (1) Home 100%4 Calibxi (Body) 11 B fx. Fixed Cost (FC). Year 1 A. E E b. E F E H Capital Budget Analysis Assignment at4 Workshect Inputs Base Case Equipment Cost Salvage Value, Year 5 Depreciation Per Year Units Sold Every Year Sales price per unit, Year 1 Expected inflation rate per year after year 1 Variable cost per unit (vC), Year 1 Expected inflation rate per year after year 1 Fired Cost (FC), Year 1 Expected inflation rate per year after year 1 Project Cost of Capital Tax Rate Working Capital as % of next year's sales Year: 0 1 2 3 Imvestment: Sales Expenses: Variable Costs Fixed Costs Depreciation EAT Tax Net income Salvage value Depreciation nowC Net Cash Flow Discounted Cash Flow DCF NPV IRR Profitability index PI Payback 4 $+$+$+$+$ 5+5+5 $+$+$ 55+5s+5+5+5+5 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & & & & & & & & 5 \\ \hline & & s &. & $ & . & $ & = & s & . & $ & = & $ \\ \hline$ & - & 5 & - & $ & - & $ & - & 5 & - & $ & - & $ \\ \hline$ &. & $ &. & $ & . & $ & . & $ &. & $ & . & $ \\ \hline \end{tabular} so $0 0.00% o WAEE Capital Eudget Anal