Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help solving the following formulas for the Calculation section: Number of Season Skiers This number is a function of the rate of change

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I need help solving the following formulas for the Calculation section:

  • Number of Season Skiers This number is a function of the rate of change in skiers. The rate of change in skiers is applied to the prior year.
  • Yearly Total Skier Revenue This number is a function of the number of daily skiers, the average lift ticket price, and the number of ski days per year, plus a function of the number of annual-pass skiers and the annual lift ticket price.
  • Daily Ski School AttendeesThis number is a function of the number of daily skiers. Assume that 10 percent of the daily skiers will take ski school lessons.
  • Yearly Ski School RevenueThis number is a function of the daily ski school attendees, the aver-age ski school daily price, and the number of ski days per year.
  • Daily Equipment Rental UsersThis number is 75 percent of the daily number of skiers.
  • Yearly Rental RevenueThis number is a function of the daily equipment rental users, the aver-age daily rental price, and the number of ski days per year.
  • Yearly Food Concession RevenueThis number is a function of the total number of skiers per year and the average daily money spent on food. Assume that 90 percent of skiers buy food.
  • Other Yearly RevenueThis number is a function of the other daily revenue and the number of ski days per year.
SKI RESORT INVESTMENT DECISION \\begin{tabular}{|r|r|r|r|r|} \\hline & 2019 & 2021 & 2022 \\\\ \\hline Net Cash Position Before Borrowing \\& Repayment of Debt & NA & & \\\\ \\hline Add: Borrowing from Bank & NA & & \\\\ \\hline Less: Payment to Bank & NA & & \\\\ \\hline Equals: Repayment to Bank & 4000000 & & \\\\ \\hline Debt Owed & 2019 & 2020 & 2021 & \\\\ \\hline Add: Borrowing from Bank & NA & & \\\\ \\hline Less: Repayment to Bank & NA & & \\\\ \\hline Equals: End of Year Debt Owed & 200000 & & \\\\ \\hline \\end{tabular} SKI RESORT INVESTMENT DECISION \\begin{tabular}{|r|r|r|r|r|} \\hline & 2019 & 2021 & 2022 \\\\ \\hline Net Cash Position Before Borrowing \\& Repayment of Debt & NA & & \\\\ \\hline Add: Borrowing from Bank & NA & & \\\\ \\hline Less: Payment to Bank & NA & & \\\\ \\hline Equals: Repayment to Bank & 4000000 & & \\\\ \\hline Debt Owed & 2019 & 2020 & 2021 & \\\\ \\hline Add: Borrowing from Bank & NA & & \\\\ \\hline Less: Repayment to Bank & NA & & \\\\ \\hline Equals: End of Year Debt Owed & 200000 & & \\\\ \\hline \\end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions