solve the spreadsheet

Format PainterClipboardEquipment CostSalvage Value, Year $5$Depreciation Per YearUnits Sold Every YearSales price per unit, Year $1$Expected inflation rate per year after year $1$Variable cost per unit $($VC$),$ Year $1$Expected inflation rate per year after year $16|$Tax Rate$8$Fixed Cost $($FC$),$ Year $1$Expected inflation rate per year after year $15$Project Cost of Capital $($WACC$)9$BIU AInputs$7$ Working Capital as $\%$ of next year's sales$2021222324$Font$252671$WACC Canital Budoet AnalvsiE Merge & CenterBBase CaseAlignment$750,00025,000150,00040,00040\mathrm{.}004\mathrm{.}0\%30\mathrm{.}004\mathrm{.}0\%175,0004\mathrm{.}0\%7\mathrm{.}81\%22\mathrm{.}0\%10\mathrm{.}0\%$Profitability IndexInvestment:SalesExpenses:Variable CostsFixed CostsDepreciationEBTDTax $(22\%)$Net IncomeSalvage ValueDepreciationNOWCDiscounted Cash Flow DCFNet Cash FlowNPVIRRPIPayback$\%0$NumberE$750,000$$o$$00\mathrm{.}00\%$$ConditIonal Format as CellFormatting Table Styles vFStylesInsert Delete POrmatCellsH$ClearFilter SelectEditing$Add$-$iSAdd$-$insSK

Format PainterClipboardEquipment CostSalvage Value, Year $5$Depreciation Per YearUnits Sold Every YearSales price per unit, Year $1$Expected inflation rate per year after year $1$Variable cost per unit $($VC$),$ Year $1$Expected inflation rate per year after year $16|$Tax Rate$8$Fixed Cost $($FC$),$ Year $1$Expected inflation rate per year after year $15$Project Cost of Capital $($WACC$)9$BIU AInputs$7$ Working Capital as $\%$ of next year's sales$2021222324$Font$252671$WACC Canital Budoet AnalvsiE Merge & CenterBBase CaseAlignment$750,00025,000150,00040,00040\mathrm{.}004\mathrm{.}0\%30\mathrm{.}004\mathrm{.}0\%175,0004\mathrm{.}0\%7\mathrm{.}81\%22\mathrm{.}0\%10\mathrm{.}0\%$Profitability IndexInvestment:SalesExpenses:Variable CostsFixed CostsDepreciationEBTDTax $(22\%)$Net IncomeSalvage ValueDepreciationNOWCDiscounted Cash Flow DCFNet Cash FlowNPVIRRPIPayback$\%0$NumberE$750,000$$o$$00\mathrm{.}00\%$$ConditIonal Format as CellFormatting Table Styles vFStylesInsert Delete POrmatCellsH$ClearFilter SelectEditing$Add$-$iSAdd$-$insSK