Please answer questions D and E shown in the excel sheet, please add formula's for answer. Thank you.

Inputs Actual Projected Projected Projected Projected

$12/31/202312/31/2412/31/2512/31/2612/31/27$

Sales Growth Rate $7\%5\%3\%2\%$

Costs$/$Sales $72\%73\%74\%75\%77\%$

Depreciation$/($Net PPE$)10\%10\%10\%10\%10\%$

Cash$/$Sales $1\%1\%1\%1\%1\%$

$($Acct$.$ Rec.$)/$Sales $10\%10\%10\%11\%11\%$

Inventories$/$Sales $20\%21\%23\%25\%27\%$

$($Net PPE$)/$Sales $75\%75\%75\%75\%75\%$

$($Acct$.$ Pay.$)/$Sales $2\%2\%2\%2\%2\%$

Accruals$/$Sales $5\%5\%5\%5\%5\%$

Tax rate $40\%21\%21\%21\%21\%$

Weighted average cost of capital $($WACC$)8\mathrm{.}5\%8\mathrm{.}5\%8\mathrm{.}5\%8\mathrm{.}5\%8\mathrm{.}5\%$

Actual Projected Projected Projected Projected

Income Statement Items $12/31/202312/31/2412/31/2512/31/2612/31/27$

Net Sales $$800\mathrm{.}0$ $$856\mathrm{.}0$ $$840\mathrm{.}0$ $$824\mathrm{.}0$ $$816\mathrm{.}0$

Costs $($except depreciation$)$ $$576\mathrm{.}0$ $$624\mathrm{.}9$ $$621\mathrm{.}6$ $$618\mathrm{.}0$ $$628\mathrm{.}3$

Depreciation $$60\mathrm{.}0$ $$64\mathrm{.}20$ $$63\mathrm{.}00$ $$61\mathrm{.}80$ $$61\mathrm{.}20$

Total operating costs $$636\mathrm{.}0$ $$689\mathrm{.}1$ $$684\mathrm{.}6$ $$679\mathrm{.}8$ $$689\mathrm{.}5$

Earning before int. & tax $$164\mathrm{.}0$ $$166\mathrm{.}9$ $$155\mathrm{.}4$ $$144\mathrm{.}2$ $$126\mathrm{.}5$

Operating Assets $12/31/202312/31/2412/31/2512/31/2612/31/27$

Cash $$8\mathrm{.}0$ $$8\mathrm{.}0$ $$8\mathrm{.}0$ $$8\mathrm{.}0$ $$8\mathrm{.}0$

Accounts receivable $$80\mathrm{.}0$ $$85\mathrm{.}6$ $$84\mathrm{.}0$ $$90\mathrm{.}6$ $$89\mathrm{.}8$

Inventories $$160\mathrm{.}0$ $$179\mathrm{.}8$ $$193\mathrm{.}2$ $$206\mathrm{.}0$ $$220\mathrm{.}3$

Net plant and equipment $$600\mathrm{.}0$ $$642\mathrm{.}0$ $$630\mathrm{.}0$ $$618\mathrm{.}0$ $$612\mathrm{.}0$

Operating Liabilities

Accounts Payable $$16\mathrm{.}0$ $$17\mathrm{.}1$ $$16\mathrm{.}8$ $$16\mathrm{.}5$ $$16\mathrm{.}3$

Accruals $$40\mathrm{.}0$ $$42\mathrm{.}8$ $$42\mathrm{.}0$ $$41\mathrm{.}2$ $$40\mathrm{.}8$

Actual Projected Projected Projected Projected

Calculation of FCF $12/31/202312/31/2412/31/2512/31/2612/31/27$

Operating current assets $$248\mathrm{.}0$ $$273\mathrm{.}4$ $$285\mathrm{.}2$ $$304\mathrm{.}6$ $$318\mathrm{.}1$

Operating current liabilities $$56\mathrm{.}0$ $$59\mathrm{.}9$ $$58\mathrm{.}8$ $$57\mathrm{.}7$ $$57\mathrm{.}1$

Net operating working capital $$192\mathrm{.}0$ $$213\mathrm{.}4$ $$226\mathrm{.}4$ $$247\mathrm{.}0$ $$261\mathrm{.}0$

Net PPE $$600\mathrm{.}0$ $$642\mathrm{.}0$ $$630\mathrm{.}0$ $$618\mathrm{.}0$ $$612\mathrm{.}0$

Total net operating capital $$792\mathrm{.}0$ $$855\mathrm{.}4$ $$856\mathrm{.}4$ $$865\mathrm{.}0$ $$873\mathrm{.}0$

NOPAT $$98\mathrm{.}4$ $$131\mathrm{.}9$ $$122\mathrm{.}8$ $$113\mathrm{.}9$ $$99\mathrm{.}9$

Investment in total net operating capital na $$63\mathrm{.}4$ $$1\mathrm{.}0$ $$8\mathrm{.}6$ $$8\mathrm{.}0$

Free cash flow na $$68\mathrm{.}5$ $$121\mathrm{.}8$ $$105\mathrm{.}3$ $$91\mathrm{.}9$

Growth in FCF na na $756\mathrm{.}25\%77\mathrm{.}82\%-13\mathrm{.}55\%$

Growth in sales $7\mathrm{.}0\%5\mathrm{.}0\%3\mathrm{.}0\%2\mathrm{.}0\%$