CONSTANTS A TAX RATE CASH NEEDED TO START NEXT YEAR INTERFET RATE ON DEBI DALY LFT TICKET PROCE ANILALLIFT IICKLI PRKCE AVERACF DAL Y MONEY SPENT ON FOOD AVERAEE SNI SCHOOL DALY PFICE AVIFAGE LNILY FENIAL PRECE NJMEER OF SK DAYG PER YEAF OTHER DALLY REVENUE GUAMLR POTENTVL REVENLE OPERATING COST'S SNOW MNHAG CPERATIRSE COSTS - SLMMER DAI Y OTHFR WIUTFR OFFRATING COSTS FXED COSTS \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline B & \multicolumn{3}{|c|}{ C } & \multicolumn{2}{|r|}{ D } & \multicolumn{2}{|r|}{ E } \\ \hline 2019 & \multicolumn{3}{|c|}{2020} & \multicolumn{2}{|r|}{2021} & \multicolumn{2}{|r|}{2022} \\ \hline NA & & & 02 & & 02 & & 02 \\ \hline NA & \multicolumn{3}{|c|}{$4,000,000.00} & $ & 4,000,000.00 & 5 & 4,000,000,00 \\ \hline NA & & & 0.03 & & 003 & & 003 \\ \hline NA & $ & & 100 & 5 & 100 & 3 & 100 \\ \hline Na & 5 & & 700 & $ & 700 & $ & 700 \\ \hline NA & $ & & 25 & s & 25 & $ & 25 \\ \hline NA & $ & & 45 & $ & 45 & $ & 45 \\ \hline \multirow[t]{2}{*}{ NA } & 5 & & 25 & 5 & 27 & 5 & 30 \\ \hline & $ & & 100 & 3 & 100 & 5 & 100 \\ \hline \multirow[t]{7}{*}{ NA } & $ & & 15 & $ & 15 & 5 & 15 \\ \hline & 4 & & & 5 & 1,000,000 & $ & 1,000.000 \\ \hline & 5 & \multicolumn{2}{|c|}{2000,000} & 3 & 1,000,000 & s & 1,800,000 \\ \hline & $ & \multicolumn{2}{|c|}{350,000} & $ & 350,000 & 8 & 400,000 \\ \hline & 5 & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{r} 15,000 \\ 35,000,000 \end{tabular}}} & $ & 15,000 & $ & 15,000 \\ \hline & 5 & & & $ & 35,000,000 & $ & 35,000,000] \\ \hline & 11 & + & & & & & \\ \hline AL YRE & \multicolumn{3}{|c|}{2020} & \multicolumn{2}{|r|}{2021} & \multicolumn{2}{|r|}{2022} \\ \hline 4% & \multicolumn{3}{|c|}{ NA } & \multicolumn{2}{|r|}{ NA. } & \multicolumn{2}{|r|}{ NA } \\ \hlineP & \multicolumn{3}{|c|}{Na} & & NA & \multicolumn{2}{|r|}{ NA } \\ \hline NA & & + & 0% & & 3% & & 5% \\ \hline NA & r & & & r & & N & \\ \hline \end{tabular} NPUTS RATE OF CHANCE IN SKERSS LCONOMC OUTLOOK [GoOd, PGOI] CUINATE CHANGE FACTOR SUMMLR OPLRATONS CY OR ND \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} SUMIMARY OF KEY RESULTS NET IROCME AFTER TANOES END-CF-THE-YEAR CASH ON HAND END-OF-THF-YFAR DFAT CWFD FHOHII MARGN CALCULATTONS 2018 2029 2021 2022 PERCENTAGE CHWUEE IN DWLY SKCRE AI MAFER CF RAII Y SKIFRS MUUEER OF SEASCW SHCFRS 3000 VEALY TOTAL SFEP FEVENUE D.ALY SKI SCHOOL ATTENDEES YEARLY SXI SCHODL REVENLE DNLY EOUIPMENI RENIML USERS YEARLY RENIAL REVEULE YEAVLY FOOD CCHKEESBION REVEVLE OTIER YEARI Y ACVENUE \begin{tabular}{|c|c|c|c|c|c|} \hline 4 & A & B & C & D & E \\ \hline 44 & & & & & \\ \hline 45 & & & & & \\ \hline & \begin{tabular}{l} INCOME STATEMENT \& CASH FLOW \\ STATEMENT \end{tabular} & 2019 & 2020 & 2021 & 2022 \\ \hline 46 & & & & & \\ \hline 47 & BEGINNING OF-THE-YEAR CASH ON HAND & NA & & & \\ \hline 48 & 5 & & & & \\ \hline 49 & REVENUE - SKIERS & NA & & & \\ \hline 50 & REVENUE-SKISCHOOL & NA & & & \\ \hline 51 & REVENUE - EQUIPMENI RENTAL & NA & & & \\ \hline 52 & REVENUE-FOOD CONCESSION & NA & & & \\ \hline 53 & RFVENUE-OTHER & NA & & & \\ \hline 54 & REVENUE - POTENTLLL SUMMER & NA & & & \\ \hline 55 & IOTAL REVENUE & NA & & & \\ \hline 56 & OPERAING COSTS - SNOW MAKING & NA & & & \\ \hline 57 & SUMMFR OPERATING COSTS & NA & & & \\ \hline 58 & YEARLY WINTER OPERATING COSTS & NA & & & \\ \hline 59 & FXXED COSTS & NA & & & \\ \hline 60 & TOTAL COSTS & NA & & & \\ \hline 61 & INCOME BEFORE INTEREST AND TAXES & NA & & & \\ \hline 62 & INTEREST EXPENSE & NA & & & \\ \hline 63 & INCOME BEFORE TAXES & NA & & & \\ \hline 64 & INCOME TAXEXPENSE & NA & & & \\ \hline 65 & NET INCOME AFTER TAXES & NA & & & \\ \hline \end{tabular} Income Statement and Cash Flow Statement Section (Figure 6-5 and 6-6) Read the bullets and complete formulas on pp 117-118. - Change the formatting of all your cells to Accounting with 0 decimal places - Row 70 - Less: Repayment to Bank is a triple nested IF function (similar to the end of the Tutorial C assignment)