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} Percentage Change in Daily Skiers - This in an IF function and the resulting value will appear as a percentage value. Format as Percentage with 0 decimal places i. The climate change factor will always be 0 or a negative value. Remember in math that minus minus is converted to a positive value ( --4 changes to +4 ) This calculation cannot allow that to happen, you need to add the negative value instead of subtracting it ( +-3 is -3 ) ii. Refer to the check figure below to see the final values for C33:E33 when the input cells match those listed in step 4 of these directions