2024 – Based on the inputs below prepare a capital budget analysis using the Net PresentValue Internal

Based on the inputs below prepare a capital budget analysis using the Net PresentValue, Internal Rate of Return and Payback in years methods of determiningwhether the project is feasible. Please show your spreadsheet calculations and yourfinal determinations of “go” or “no go” on the project.Project Inputs:WACC – the cost of capital is 10.0%Project Investment Outlay, Year 0 – $200,000Project Investment Life – 10 yearsProject Depreciation – $20,000 / yearProject Salvage Value – $10,000Working Capital Base of Annual Sales – 10%Expected inflation rate per year – 5%Project Tax Rate – 30%Bus500DAssignment3:Hasse2Inputs continued:Units sold per year – 25,000Selling Price per Unit, Year 1 – $35Fixed operating costs per yearexcluding depreciation – $150,000Manufacturing costs per unit, Year 1 – $25.20