Objective: create an excel financial model for Apple associated with formulas from accounting to cash flow to Valuate the company.$|$ Step $1$: add all your assumptions: growth$/$decline rates of Revenues and Expenditures and other various inputs you will use in the financial model. Fill in all the green color cells below Inputs of Apple $($amounts in thousands$)$ Key Assumptions Sales increase$/$Decrease in $\backslash \%$ COGS increase$/$Decrease in $\backslash \%$ Income tax in $\backslash \%$ Interest rate Loan financing in $\backslash \%$ Coupon rate Bond financing in $\backslash \%$ Dividends Pay$\_$out ratio in $\backslash \%$ Noober of years of Capex project Growth rate of dividends forever Total Revenues in last realized year COGS in last realized year General and Administrative costs Net Income$/$Loss in last realized year Current Stock price Current Number of stocks New Capex as $\backslash \%$ of Total Revenues Cash balance in last realized year Cash Increase$/$Decrease in $\backslash \%$ Receivables $(\backslash \%$ of sales$)$ Stocks $(\backslash \%$ of COGS$)$ Accumulated amortization in last realized year Payables $(\backslash \%$ of COGS$)$ Other liabilities $(\backslash \%$ of COGS$)$ Shareholders Equity inlast, realized year Retained Earnings$/$Deferred Losses in last year Tangible $($Net Fixed$)$ Assets$)$ in last year Cash Flows resulting from new CAPEX in $\backslash \%$ CAPEX increase in Worst case scenario $2$ in $\backslash \%$ CF$\text{'}$s reduction in Worst case scenario $2$ in $\backslash \%$ CAPEX reduction in Rest case scenario $3$ in $\backslash \%$ CF$\text{'}$s increase in Best case scenario $3$ in $\backslash \%$ Growth rate of FCF forever.