Please fill in for Unit price down to payback...with cell referencs. Please

Insert Draw Page Layout Formulas Data Review View Help Home s Cut e Copy " Courier Merge & Center Format Painter Clipboard Font Alignment KEY OUTPUT INPUT DATA Initia1 Investment Equipnent cost $700,000 Freight Installation NPV IRR MIRR ARR Payback $35.000 $70,000 Change in NUC 30,000 years Operating Flows and Inflation Rates Unit sales t-o sales price $200 Fixed oper cost $190. 000 t-0 VC per unit 700,000 $1.25 4 0% 2.0% 0 Price inflatior Cost inflation Cannibalization of Other Projects 31sv Taxes, and Cof C 4 Salvage value87.500 Revenue Loss Cost Reduction Net Cannibalization 5 Useful life (va 6Tax rate 7 Cost of capital 40% 50 HODEL-GENERATED DATA TASTY FOODS CORPORATION (PART II) 52 Net Investnent835000Depreciation Schedule: Bas:$805.000 53 Equipient cost $700.000 54 Freight MACRS Dep End of Year Factor Expense Book Value 35 000Year 55 , Installation 56Change in NUC 57 58 59 33% 45% % 7% $265,650 s362, 250 $120,750 $56,350 $539,350 177,100 56 350 30.000 61 TASTY Insert Draw Page Layout Formulas Data Review View Help Home s Cut e Copy " Courier Merge & Center Format Painter Clipboard Font Alignment KEY OUTPUT INPUT DATA Initia1 Investment Equipnent cost $700,000 Freight Installation NPV IRR MIRR ARR Payback $35.000 $70,000 Change in NUC 30,000 years Operating Flows and Inflation Rates Unit sales t-o sales price $200 Fixed oper cost $190. 000 t-0 VC per unit 700,000 $1.25 4 0% 2.0% 0 Price inflatior Cost inflation Cannibalization of Other Projects 31sv Taxes, and Cof C 4 Salvage value87.500 Revenue Loss Cost Reduction Net Cannibalization 5 Useful life (va 6Tax rate 7 Cost of capital 40% 50 HODEL-GENERATED DATA TASTY FOODS CORPORATION (PART II) 52 Net Investnent835000Depreciation Schedule: Bas:$805.000 53 Equipient cost $700.000 54 Freight MACRS Dep End of Year Factor Expense Book Value 35 000Year 55 , Installation 56Change in NUC 57 58 59 33% 45% % 7% $265,650 s362, 250 $120,750 $56,350 $539,350 177,100 56 350 30.000 61 TASTY