1000 ACC 1. Given the following data on proposed capital budgeting project. (Numerical loputs Expected from you are highlighted in yellow and Formula/Function Inputs are highlighted in blue) Parameters Le feel prejext is year Market Sale of its 5 20,408.00000 of Shares Outstanding Pre of New Yeart 5 145.00.00 Market Value of Debt 331,012.000.00f Bouds Outstanding Change in NWC 5 TOLDO Total Market Val $ 151,900,000.00 Market Price of ions 5 16.00 Fixed Cat 5 107, 7400 Weight of it 19 Market Price of Stack 5 79.00 Variable Costs of Reves Wacht of Debt 53.6196 Salvage value of New Fiat 3 167,200 . Marginal Tax Rate 11.09 R 1.94 Bon Info Previded for your orience First Year Uni Sales 3600 1. Ynar Mauri Sales Growth Rate 2100 Custofqilya 142 PMT Unit Sale Price 5 101.00 Ce of the fra 42 SL.000 Pirst Year RA 5 576.00.00 Cheras Cab Before YTM 3390 RefM Sallate the Church Spreadsheet for determining Cash Flows Ghost Timeline Year 3 II. Net Investment Outlay Initial C Price of Equipment Change in NWC $17.91000 TIL. Cash Flows from Operations Revenue Generation Unit Sales 600 Un Sale Price 10.00 Remus Costs Variable Costa Fixed Costs Depreciation Bains Before To Taxes Net Income Depreciation Net Operatings IV. Terminal Cash Flows Salve Value Taxon Salvage Value Return of NWC v. Vimal Cash Flow Cash Flows Print Value of NPV of Project NPV Accept? Summarize Answers for NPV under three cases in area below Sales Growth Rate Best Case 31.0% Most Likely 21.00% Worst Case 2.1% 1000 ACC 1. Given the following data on proposed capital budgeting project. (Numerical loputs Expected from you are highlighted in yellow and Formula/Function Inputs are highlighted in blue) Parameters Le feel prejext is year Market Sale of its 5 20,408.00000 of Shares Outstanding Pre of New Yeart 5 145.00.00 Market Value of Debt 331,012.000.00f Bouds Outstanding Change in NWC 5 TOLDO Total Market Val $ 151,900,000.00 Market Price of ions 5 16.00 Fixed Cat 5 107, 7400 Weight of it 19 Market Price of Stack 5 79.00 Variable Costs of Reves Wacht of Debt 53.6196 Salvage value of New Fiat 3 167,200 . Marginal Tax Rate 11.09 R 1.94 Bon Info Previded for your orience First Year Uni Sales 3600 1. Ynar Mauri Sales Growth Rate 2100 Custofqilya 142 PMT Unit Sale Price 5 101.00 Ce of the fra 42 SL.000 Pirst Year RA 5 576.00.00 Cheras Cab Before YTM 3390 RefM Sallate the Church Spreadsheet for determining Cash Flows Ghost Timeline Year 3 II. Net Investment Outlay Initial C Price of Equipment Change in NWC $17.91000 TIL. Cash Flows from Operations Revenue Generation Unit Sales 600 Un Sale Price 10.00 Remus Costs Variable Costa Fixed Costs Depreciation Bains Before To Taxes Net Income Depreciation Net Operatings IV. Terminal Cash Flows Salve Value Taxon Salvage Value Return of NWC v. Vimal Cash Flow Cash Flows Print Value of NPV of Project NPV Accept? Summarize Answers for NPV under three cases in area below Sales Growth Rate Best Case 31.0% Most Likely 21.00% Worst Case 2.1%