Income Statements and Member Renewals Regular Golfers Members Members General Club Membership $99 $5,900 Ave. Rounds 13/5 140/24 Total Rounds of Golf Played 2021 8,500 3,240 10,660 Green/cart fees (100% gross profit) $ 340,000 $ 240 Guest Green Fees (100% gross profit) $ 120 $975 $ 34,000 $ 50 $600 Food and Beverage (est) (50% gross profit) Pro Shop $ (est) (50% gross profit) $ 42,500 $ 30 $500 Events (est) (50% gross profit) $ 10,000 $ 20 $90 Total Revenues $ 50.18 $559 $8,065 Total Profits $509 $7,470 2019 members (Year End) 200 68 2020 members (Year End) 170 58 2021 members (Year End) 180 65 2019 $ (est.) Revenues $111,800 $548,420 2020 $ (est.) Revenues $95,030 $467,770 2021 $ (est.) Revenues $ 426,550 $100,620 $524,225 2019 membership fees (est.) $ 19,800 $ 401,200 2020 membership fees (est.) $ 16,830 $ 342,200 2021 membership fees (est.) $ 17,820 $ 383,500 2019 $ (est.) Profits $101,800 $ 507,960 2020 $ (est.) Profits $ 86,530 $ 433,260 2021 $ (est.) Profits $ 383,250 $ 91,620 $ 485,550 % of Profits 40.0% 9.5% 50.5% Total Profits 2021 $ 960,420 2020 Regular Club 2021 Regular Club 200 68 170 58 Beginning # of players card members (from 2019) Beginning # of players card members (from 2020) Retained members 115 55 Retained members 108 47 New members 55 3 New members 72 18 Year end # of members 170 58 Year end # of members 180 65 Retention rate 58% 81% Retention rate 64% 81% First, review the financial data and make a report. Include all of the following: Total annual Revenues and Gross Profit, Number and Percentage of rounds, revenues and profits from the membership program (5 pts) Calculate the current LTVs for Regular and Club Members You will need to determine the most logical number of years and justify it. (Provide the LTV tables) (10 pts) Calculate the changes in LTV (Include the LTV tables) if: (1.) Spending goes up by 10% and retention goes up by 5% (2.) Spending goes up by 20% and retention goes up by 10% Leaky Bucket - How many new Regular and Club Members are needed each year to maintain the current number of members for each group. (3 pts) Summarize the current financial situation. (2 pts) Income Statements and Member Renewals Regular Golfers Members Members General Club Membership $99 $5,900 Ave. Rounds 13/5 140/24 Total Rounds of Golf Played 2021 8,500 3,240 10,660 Green/cart fees (100% gross profit) $ 340,000 $ 240 Guest Green Fees (100% gross profit) $ 120 $975 $ 34,000 $ 50 $600 Food and Beverage (est) (50% gross profit) Pro Shop $ (est) (50% gross profit) $ 42,500 $ 30 $500 Events (est) (50% gross profit) $ 10,000 $ 20 $90 Total Revenues $ 50.18 $559 $8,065 Total Profits $509 $7,470 2019 members (Year End) 200 68 2020 members (Year End) 170 58 2021 members (Year End) 180 65 2019 $ (est.) Revenues $111,800 $548,420 2020 $ (est.) Revenues $95,030 $467,770 2021 $ (est.) Revenues $ 426,550 $100,620 $524,225 2019 membership fees (est.) $ 19,800 $ 401,200 2020 membership fees (est.) $ 16,830 $ 342,200 2021 membership fees (est.) $ 17,820 $ 383,500 2019 $ (est.) Profits $101,800 $ 507,960 2020 $ (est.) Profits $ 86,530 $ 433,260 2021 $ (est.) Profits $ 383,250 $ 91,620 $ 485,550 % of Profits 40.0% 9.5% 50.5% Total Profits 2021 $ 960,420 2020 Regular Club 2021 Regular Club 200 68 170 58 Beginning # of players card members (from 2019) Beginning # of players card members (from 2020) Retained members 115 55 Retained members 108 47 New members 55 3 New members 72 18 Year end # of members 170 58 Year end # of members 180 65 Retention rate 58% 81% Retention rate 64% 81% First, review the financial data and make a report. Include all of the following: Total annual Revenues and Gross Profit, Number and Percentage of rounds, revenues and profits from the membership program (5 pts) Calculate the current LTVs for Regular and Club Members You will need to determine the most logical number of years and justify it. (Provide the LTV tables) (10 pts) Calculate the changes in LTV (Include the LTV tables) if: (1.) Spending goes up by 10% and retention goes up by 5% (2.) Spending goes up by 20% and retention goes up by 10% Leaky Bucket - How many new Regular and Club Members are needed each year to maintain the current number of members for each group. (3 pts) Summarize the current financial situation. (2 pts)