Arbbot FoodInc., is considering an investment in a new organic juice in response to the growing demand for healthy drink.

Initial investment is $450$K PPE with a life of $5$ years.

Straight$-$line depreciation with zero salvage value.

$21\%$ tax rate.

WACC for the project is $13\mathrm{.}25\%$

The initial investment should be invested at the end of $2023$ and the first year of revenues will be realized at the end of $2024.$

Arbbot Food. Inc. is financed from internally generated cash flowsproject is all$-$equity$-$ financed.

The expected price for the juice is $5$ per bottle and the company expects to sell $200,000$ bottles in $2024.$ The number of bottles sold is expected to grow $10\%$ annually throughout the $5-$year planning period.

COGS margin $67\mathrm{.}4\%($COGS marginCost of goods sold$/$sales$).$

Operating expenses before depreciation are $10\%$ of sales plus an annual fixed cost of $$115$K

QUESTION: please use the above information and replace $"$X$"$ in the excel file with a correct accounting value. $($Hint: please try to compute all numbers by using Excel formulas$)$