Need help with the above, thank you! See below for information, please show excel sheet formulas

PVCF) PVCF) PV(CE) PVCF) Most-Likely Case - NPV Profile Year CF PV(CF) 0 1 2 3 4 NPV Discount Rate Economic life of project in years. Price of New Equipment $ Change in NWC $ Fixed Costs $ Variable Costs (% of Revenue) Salvage value of New Equipment $ Marginal Tax Rate First Year Unit Sales Sales Growth Rate Unit Sale Price $ First Year Revenue $ 243,840.00 217,018.00 237,154.00 9% 145,042.00 30.0% 5900 Parameters Market Value of Equity Market Value of Debt Total Market Value Weight of Equity Weight of Debt E(R) RE B Cost of Equity (r.) Cost of Debt (1) After-Tax Cost of Debt WACC $ 70,500,000.00 # of Shares Outstanding 940000 $ 113,400,000.00 # of Bonds Outstanding 120000 $ 183,900,000.00 Market Price of Bonds $ 945.00 38.34% Market Price of Stock $ 75.00 61.66% 9.50% 2.0% Bond Info Provided for your convenience 1.38 Years to Maturity 12 12.35% PMT $45.00 8.46% FV $1,000 5.92% Before tax YTM 4.23% 8.93% Before tax YTM * 2 8.46% 21.00% 105.00 629,500.00 $ $ (958,000.00) (217,018.00) 5900 105.00 $ 619,500.00 $ 7139 105.00 $ 749,595.00 $ 8638.19 105.00 907,009.95 10452.2099 $ 105.00 $ 1,097,482.04 $ $ $ II. Net Investment Outlay = Initial CFS Price of Equipment Change in NWC III. Cash Flows from Operations Revenue Generation Unit Sales Unit Sale Price Revenues Costs Variable Costs Fixed Costs Depreciation Earnings Before Taxes Taxes Net Income Depreciation Net operating CFS IV. Terminal Cash Flows Salvage Value Tax on Salvage Value Return of NWC V. Final Cash Flow Cash Flows Present Value of CFS $ lalalalalalalala 55,755.00 $ 237,154.00 $ 203,239.50 $ 123,351.50 $ 37,005.45 $ 86,346.05 $ 203,239.50 $ 289,585.55 $ 67,463.55 $ 237,154.00 $ 203,239.50 $ 241,737.95 $ 72,521.39 $ 169,216.57 $ 203,239.50 $ 372,456.07 $ 81.630.90 237,154.00 203.239.50 384,985.55 115,495.67 269,489.89 203.239.50 472,729.39 98,773.38 237,154.00 203,239.50 558,315.16 167,494.55 390,820.61 203.239.50 594,060.11 $ $ $ $ $ $ 145,042.00 $ $ $ $ $ $ $ $ $ $ 217,018.00 $ $ (1,175,018.00 $ $ 289,585.55 267,169.99 $ $ 372,456.07 317,027.27 $ $ 472,729.39 $ 371.231.61 $ 956,120.11 692.716.59 NPV of Project $ 473,127.46 PVCF) PVCF) PV(CE) PVCF) Most-Likely Case - NPV Profile Year CF PV(CF) 0 1 2 3 4 NPV Discount Rate Economic life of project in years. Price of New Equipment $ Change in NWC $ Fixed Costs $ Variable Costs (% of Revenue) Salvage value of New Equipment $ Marginal Tax Rate First Year Unit Sales Sales Growth Rate Unit Sale Price $ First Year Revenue $ 243,840.00 217,018.00 237,154.00 9% 145,042.00 30.0% 5900 Parameters Market Value of Equity Market Value of Debt Total Market Value Weight of Equity Weight of Debt E(R) RE B Cost of Equity (r.) Cost of Debt (1) After-Tax Cost of Debt WACC $ 70,500,000.00 # of Shares Outstanding 940000 $ 113,400,000.00 # of Bonds Outstanding 120000 $ 183,900,000.00 Market Price of Bonds $ 945.00 38.34% Market Price of Stock $ 75.00 61.66% 9.50% 2.0% Bond Info Provided for your convenience 1.38 Years to Maturity 12 12.35% PMT $45.00 8.46% FV $1,000 5.92% Before tax YTM 4.23% 8.93% Before tax YTM * 2 8.46% 21.00% 105.00 629,500.00 $ $ (958,000.00) (217,018.00) 5900 105.00 $ 619,500.00 $ 7139 105.00 $ 749,595.00 $ 8638.19 105.00 907,009.95 10452.2099 $ 105.00 $ 1,097,482.04 $ $ $ II. Net Investment Outlay = Initial CFS Price of Equipment Change in NWC III. Cash Flows from Operations Revenue Generation Unit Sales Unit Sale Price Revenues Costs Variable Costs Fixed Costs Depreciation Earnings Before Taxes Taxes Net Income Depreciation Net operating CFS IV. Terminal Cash Flows Salvage Value Tax on Salvage Value Return of NWC V. Final Cash Flow Cash Flows Present Value of CFS $ lalalalalalalala 55,755.00 $ 237,154.00 $ 203,239.50 $ 123,351.50 $ 37,005.45 $ 86,346.05 $ 203,239.50 $ 289,585.55 $ 67,463.55 $ 237,154.00 $ 203,239.50 $ 241,737.95 $ 72,521.39 $ 169,216.57 $ 203,239.50 $ 372,456.07 $ 81.630.90 237,154.00 203.239.50 384,985.55 115,495.67 269,489.89 203.239.50 472,729.39 98,773.38 237,154.00 203,239.50 558,315.16 167,494.55 390,820.61 203.239.50 594,060.11 $ $ $ $ $ $ 145,042.00 $ $ $ $ $ $ $ $ $ $ 217,018.00 $ $ (1,175,018.00 $ $ 289,585.55 267,169.99 $ $ 372,456.07 317,027.27 $ $ 472,729.39 $ 371.231.61 $ 956,120.11 692.716.59 NPV of Project $ 473,127.46