Need Excel functions with answers

blank cells hilighted cells are part of the information needed to do rest of document.

TASTY FOOOS COKPORATHON (PAKT 1) Copital Bodecting Mcthods and Caht Fiow Extimution This case focuses en capital budgeting decisine criteria and cash fles: esimation. It hegies with such bacic eonceper at inctemental calk foos, sunk costs, oppontunity costs, and cesernalities, and it than moves to inflation adjuatments. The model develops incremental cash few esimates, then exleolntes NPV, IRR, MIRK, ARR, and Payback for the High Encrp-lite projoct. The model includes data tables which can be used for sensitiviry asalysik. We created a grapb which shows how NPV varies with chanps in influtige Press CTRL-A to view the graph. A noee elensive ridk malysis is conducted in the model for Cave IM. If you are using the student versiot of the model, wome of the cells have been blanked ouf. Hefore esing the model, it is necenary to fill in the empty cells with the apptopriate formalas. Onee this is done, the model is ready for use. Oaly labels have been kept; all formulas have been delefed. INPUT DATA: Initial Investment: Equipesent cost $700,000 Freight $35,000 Imsallation $70,000 Change in NWC 530,000 Operating Flows asd Intlation Rases: Unit sales 700,000 1-0 sales price Fired oper costs to VC per unit Prec inflation Cost inflation SV. Tases, and C of C. Salvage value Useful hife (yra) Tax rate Cost of capital 5200 5190,000 $125 a.046 0.05 587,500 4 40% 12% test KEY OUTHT. Cannibaliation of Other Prejects: Revenue Lass swa.000 Cost Redoction S3s,ono Net Canabaliration 545,000 Sensitivity Analysis: Changes in NPV due to Price and Cost Inflation Assuming Constant Output at 700,000 Units (Use Data Table 2 with NPV as Output Variable) Price Cost Inflation: Inflation: Sensitivity Analysis: Changes in NPV Due to Changes in Price Inflation and Unit Sales (Uses Data Table 2 to perform the calculations) Price Unit Sales Inflation: TASTY FOOOS COKPORATHON (PAKT 1) Copital Bodecting Mcthods and Caht Fiow Extimution This case focuses en capital budgeting decisine criteria and cash fles: esimation. It hegies with such bacic eonceper at inctemental calk foos, sunk costs, oppontunity costs, and cesernalities, and it than moves to inflation adjuatments. The model develops incremental cash few esimates, then exleolntes NPV, IRR, MIRK, ARR, and Payback for the High Encrp-lite projoct. The model includes data tables which can be used for sensitiviry asalysik. We created a grapb which shows how NPV varies with chanps in influtige Press CTRL-A to view the graph. A noee elensive ridk malysis is conducted in the model for Cave IM. If you are using the student versiot of the model, wome of the cells have been blanked ouf. Hefore esing the model, it is necenary to fill in the empty cells with the apptopriate formalas. Onee this is done, the model is ready for use. Oaly labels have been kept; all formulas have been delefed. INPUT DATA: Initial Investment: Equipesent cost $700,000 Freight $35,000 Imsallation $70,000 Change in NWC 530,000 Operating Flows asd Intlation Rases: Unit sales 700,000 1-0 sales price Fired oper costs to VC per unit Prec inflation Cost inflation SV. Tases, and C of C. Salvage value Useful hife (yra) Tax rate Cost of capital 5200 5190,000 $125 a.046 0.05 587,500 4 40% 12% test KEY OUTHT. Cannibaliation of Other Prejects: Revenue Lass swa.000 Cost Redoction S3s,ono Net Canabaliration 545,000 Sensitivity Analysis: Changes in NPV due to Price and Cost Inflation Assuming Constant Output at 700,000 Units (Use Data Table 2 with NPV as Output Variable) Price Cost Inflation: Inflation: Sensitivity Analysis: Changes in NPV Due to Changes in Price Inflation and Unit Sales (Uses Data Table 2 to perform the calculations) Price Unit Sales Inflation