Recent Question/Assignment
Sunnyhill Health & Racquet Club (SHRC)
PART 1: Excel/Quantitative Inputs
T accompanying excel file has 7 corresponding spreadsheets and one instructional. Each tab is numbered (1-6) corresponding to the following questions. Input data in yellow highlighted cells and the main dashboard (“master” spreadsheet) will auto-populate. Rationalize your inputs.
1. “Goal and Capital Raised” (5 points)
a. How much money (goal/objective) do you think the club’s board should look to achieve (i.e., $2,000,000 for new building; $800,000 for full renovation; $143,000 to make just the necessary improvements)?
b. Do you think selling a lot (or both) is a good financial strategy? Why/Why not?
2. “Membership Prices & Numbers” (8 points)
a. Do you propose an increase in membership fees? How much?
b. Do you think any “new” category of membership should exist? Why? Why not?
c. How might price increases affect membership numbers?
d. Is it possible that price increases could lead to higher membership numbers?
3. “Revenue Special Events” (8 points)
a. Do you foresee any changes to this revenue category?
b. What additional events could be added?
c. How much revenue could be generated?
d. Are there any limitations to new/existing events?
4. “Revenue Outside Rentals” (5 points)
a. How many “outside” rentals would you propose each year?
b. Is the pricing associated with current rentals appropriate? Would you change the fee schedule? To what? Why?
5. “Projected Expenses” (6 points)
a. When implementing a budget for expenses for the next five years, does anything stand out?
b. How does the depreciation expense affect the club’s operations?
6. “Loan Financing Schedule” (8 points)
a. What interest rate did you choose on any debt? Why?
b. How much are you proposing to repay each year?
c. Do you have any “caution” signs on your Excel spreadsheet? Why?
d. Are you proposing to make anniversary or pre payments? What do these accomplish?
PART 2: Discussion/Qualitative Questions
7. Discuss the role of “debt” as a form of leverage for a business (most strategies in the current case will require the use of debt). (5 points)
a. What are the biggest risks to the club taking on debt?
b. Is debt inherently bad?
8. How might you prioritize the list of offerings the club is considering in its potential renovation plans? (5 points)
PART 1: Excel/Quantitative Inputs
T accompanying excel file has 7 corresponding spreadsheets and one instructional. Each tab is numbered (1-6) corresponding to the following questions. Input data in yellow highlighted cells and the main dashboard (“master” spreadsheet) will auto-populate. Rationalize your inputs.
1. “Goal and Capital Raised” (5 points)
a. How much money (goal/objective) do you think the club’s board should look to achieve (i.e., $2,000,000 for new building; $800,000 for full renovation; $143,000 to make just the necessary improvements)?
b. Do you think selling a lot (or both) is a good financial strategy? Why/Why not?
2. “Membership Prices & Numbers” (8 points)
a. Do you propose an increase in membership fees? How much?
b. Do you think any “new” category of membership should exist? Why? Why not?
c. How might price increases affect membership numbers?
d. Is it possible that price increases could lead to higher membership numbers?
3. “Revenue Special Events” (8 points)
a. Do you foresee any changes to this revenue category?
b. What additional events could be added?
c. How much revenue could be generated?
d. Are there any limitations to new/existing events?
4. “Revenue Outside Rentals” (5 points)
a. How many “outside” rentals would you propose each year?
b. Is the pricing associated with current rentals appropriate? Would you change the fee schedule? To what? Why?
5. “Projected Expenses” (6 points)
a. When implementing a budget for expenses for the next five years, does anything stand out?
b. How does the depreciation expense affect the club’s operations?
6. “Loan Financing Schedule” (8 points)
a. What interest rate did you choose on any debt? Why?
b. How much are you proposing to repay each year?
c. Do you have any “caution” signs on your Excel spreadsheet? Why?
d. Are you proposing to make anniversary or pre payments? What do these accomplish?
PART 2: Discussion/Qualitative Questions
7. Discuss the role of “debt” as a form of leverage for a business (most strategies in the current case will require the use of debt). (5 points)
a. What are the biggest risks to the club taking on debt?
b. Is debt inherently bad?
8. How might you prioritize the list of offerings the club is considering in its potential renovation plans? (5 points)
Editable Microsoft Word Document
Word Count: 2361 words including Tables, Images and References
Title: SUNNYHILL HEALTH & RACQUET CLUB
Editable Microsoft Excel Workbook
Worksheet Count: 3 worksheets
Buy Now at $19.99 USD
This above price is for already used answers. Please do not submit them directly as it may lead to plagiarism. Once paid, the deal will be non-refundable and there is no after-sale support for the quality or modification of the contents. Either use them for learning purpose or re-write them in your own language. If you are looking for new unused assignment, please use live chat to discuss and get best possible quote.
Looking for answers ?
Recent Questions
Assessment 2: (20%) Case Study Presentation Due Date weeks 10This assessment builds on your theoretical knowledge and tests your ability to apply this knowledge to practice.you are required to formulate...Assessment 2Assessment 2Report: 30%Word count: 1400 – 1600 wordsDue date: Sunday of Week 8DescriptionYou are playing the role of a community service worker supporting a young adult son who is 18 years...1500-1800 wordsInstructions From TutorPlease download the eTask3 spreadsheet from Canvas and save the eTask spread as an Excel file. The main content of the force method is taught in Lectures 6,7&8.eTask3.1 is a...ASSIGNMENT INSTRUCTIONSAssessment Practical assessmentAssessment code: 011Academic Year: 2023/2024Trimester: 2Module Title: Critical Perspectives on Cross-Border BusinessModule Code: MOD009194Level: 6Module...Information Systems Analysis & DesignAssignmentDue date: Week 5 Friday (5 Apr 2024) 11:59 pm AESTWeighting: 30%Length: 1,200 to 1,500 words (penalty will apply if the length is outside this limit)Assessment...Problem:University of Technology Sydney 48353: CONCRETE DESIGN Autumn 2024 - Assignment 2 (13 Marks)The figure illustrates the cross-section of a reinforced concrete column with a hexagonal shape (equal...Show All Questions