Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here are records of a sports team to help with the question. 1. Are there any revenue items that the team might be missing? How

Here are records of a sports team to help with the question.

image text in transcribedimage text in transcribedimage text in transcribed

1. Are there any revenue items that the team might be missing? How would you think these would affect the results?

2. What current revenue items may be realistically increased to help balance the budget? How would you achieve that, and what might the financial effects of these decisions be?

3. Are there any expense items that the team might be missing? How would you think these would affect the results?

4. What current expense items may be realistically decreased to help balance the budget? What might the financial effects of these decisions be?

5. Are there any revenue items that you might drop to help also lessen expenses? What would the effect of these change be?

6. Could you possible increase any expenses to help drive increased revenues? What would you expect from these decisions?

REVENUE Advertising and Sponsorship 1,900,000.00 1,613,435.00 350,000.00 1,000,000.00 1,200,000.00 351,116.00 981,759.00 1,200,163.00 Ticket Sales Season Ticket Sales Group Sales Individual Ticket Sales All Star Game Ticket Sales Play-off Game Ticket Sales Upper Deck Ticket Sales Total Ticket Sales 0.00 15,000.00 213,000.00 2,778,000.00 209,269.00 2,742,307.00 Concession Sales Concession Stand Sales Catering Outside Event Concession Sales Vouchers Subcontractor Sales Subcontractor Rent Total Concession Sales 2,039,113.00 834,548.00 80,000.00 25,000.00 118,833.00 79,819.00 3,177,313.00 1,789,113.00 840,796.00 80,239.00 16,568.00 125,226.00 67,594.33 2,919,536.33 Souvenir and Merchandise Sales 237,671.00 237,966.00 60,000.00 64,520.00 Other Revenue Parking Revenue Other Event Rental Revenue Miscellaneous Revenue Upper Deck Revenue Naming Rights Revenue Total Other Revenue 216,761.00 140,527.00 175,000.00 161,000.00 260,000.00 656,000.00 421,808.00 Total Revenue 8,748,984.00 7,935,052.33 -200,000.00 -148,500.00 -147,000.00 -55,000.00 -41,000.00 -25,000.00 -81,000.00 -50,500.00 -58,000.00 -23,000.00 -300,000.00 -481,750.00 -204,682.00 -173,094.00 -116,631.00 -60,330.00 -30,956.00 -31,148.00 -81,522.00 -48,956.00 -63,906.00 -23,334.00 -280,751.00 -436,695.00 -3.177.00 -8,688.00 -18,778.00 -157,249.00 -13,000.00 -128,000.00 -1,751,750.00 -1,739,897.00 -682,369.00 -8,027.00 -106,952.00 -112,391.00 -2,500.00 -661,749.00 -7.798.00 -107,297.00 -70,885.00 -3,237.00 -19,846.00 -870,812.00 -912,239.00 Cost of Goods Sold Payroll and Related Expenses Salaries - Salesmen Salaries - Ticket Sellers Salaries - Group Sales Salaries - Operations Salaries - Groundskeepers Salaries - Parking Salaries - Security Salaries - Ushers Salaries - Maintenance Salaries - Interns Salaries - Concession Mgmt Salaries - Concession Salaries - Temps Salaries - NPG's Salaries - Souvenir Payroll Taxes Bonuses Total Payroll Related Expenses Concession and Souvenir Cost Concession Product Concession Supplies Souvenir Product Nonfood Supplies Freight Other Cost of Product Total Conc and Souvenir Cost Park Rent and Related Expenses Park Rent Stadium Utilities Field Maintenance Stadium Maintenance Total Park Expenses Promotion Expense Merchandise Giveaways Entertainment Fireworks Fence Sign Costs All Star Game Promotions Playoff Game Promotions Player of the Month Promotions Other Events Total Promotion Expense Other Cost of Sales Team Expenses Team Equipment Team Meal Money Team Lodging Team Travel Team Uniforms Player Development Costs Total Team Expenses Ticket Assessment Fee Broadcasting Stadium Security Employee Uniforms Ticket Printing Publications Expense Parking Lot Shuttle Tent Maintenance Publication Expense Equipment Repair and Maint. Miscellaneous Cost of Sales Total Other Cost of Sales Total Cost of Sale -1,245,000.00 -90,000.00 -36,000.00 -100,000.00 -1,471,000.00 -1,245,000.00 -78,049.00 -24,278.00 -109,629.00 -1,456,956.00 -232,000.00 -76,200.00 -175,000.00 -28,000.00 -171,528.00 -48,780.00 -143,043.00 -24,702.00 -125.00 -7,860.10 -396,038.10 -511,200.00 -10,000.00 -68,750.00 -55,000.00 -8,000.00 -141,750.00 -187,515.00 -40,000.00 -5,000.00 -14,000.00 -6,800.00 -6,190.00 -4,266.00 -54,949.00 -50,964.00 -5,158.00 -9,402.00 -130,929.00 -184,962.00 -40,500.00 -5,001.00 -6,553.00 -6,369.00 -32,000.00 -27,000.00 -13,924.00 -31,348.00 -28,518.00 -19,288.00 -467,392.00 -4,931,095.10 -454,065.00 -5,100,254.00 Gross Profit 3,648,730.00 3,003,957.23 -199,200.00 -180,000.00 -180,000.00 -40,000.00 -191,672.00 -154,321.00 -204,633.00 -56,129.00 -599,200.00 -360,000.00 -48,000.00 -48,000.00 -20,000.00 -9,000.00 -32,000.00 -157,000.00 -120,000.00 -40,000.00 -20,000.00 -13,000.00 -10,000.00 -5,100.00 -10,000.00 -2,900.00 -221,000.00 -232,957.00 -606,755.00 -299,961.00 -52,596.00 -51,559.00 -15,636.00 -1,965.00 -29,850.00 -151,606.00 -96,827.00 -23,021.00 -8,496.00 -11,871.00 3,483.00 3,845.00 -7,977.00 0.00 -155,520.00 -208,000.00 Expenses Salaries and Related Expenses Salaries - Executive Salaries - Media Salaries - Office Payroll Taxes Bonuses Total Salaries and Related Exp Advertising Expense Utilities Telephone and Internet Expense Repairs Expense Equipment Rental Expense Equipment Leasing Total Utilities and Related Group Health Insurance Workers Compensation Insurance Disability Insurance 401k Expenses Meals and Entertainment Exp Travel Automobile Expenses Seminars Employee Related Expense Sales Tax Other General and Admin Exp Insurance Expense Printing Expense Postage Expense Office Supplies Other Supplies League Dues Dues and Subscriptions ADP Processing Fees Bank Fees Credit Card Fees Loss on NSF Checks Late Fees License Fees Bad Debt Expense Winter Banquet Expense Other Miscellanous Total Other General and Admin Professional Fees Management Fee Accounting Fees Legal Fees MIS Support Public Relations Total Professional Fees Depreciation Expense Total Gen. & Admin. Expenses Income From Operations Interest - Revolver Interest - Term Loan Interest - Term Note Interest - Def Charges Interest - Capital Lease Obl. Total Interest Expense Loss on Disposal of Assets Total Other Exp (Income) Net Income -100,000.00 -50,000.00 -50,000.00 -15,000.00 - 15,000.00 -56,000.00 -15,000.00 -14,000.00 -18,000.00 -70,000.00 -1,500.00 -24,000.00 -8,000.00 -24,000.00 -600.00 -6,000.00 -467,100.00 -78,932.00 -39,645.00 -16,353.00 -11,752.00 -14,275.00 -55,982.00 -15,867.00 -13,224.00 -27,334.00 -68,646.00 -396.00 -25,440.00 -7,387.00 -80,678.00 -21,150.00 -477,061.00 -720,000.00 -42,000.00 -12,000.00 -9,000.00 -720,000.00 -24,000.00 -8,035.00 -4,476.00 -783,000.00 -360,000.00 3,180,257.00 468,473.00 -50,000.00 -200,000.00 -756,511.00 -346,732.00 -3,002,146.00 1,811.23 -47,006.00 -232,378.00 -7,685.00 -35,675.00 -36,000.00 -286,000.00 -322,744.00 -286,000.00 182,473.00 -322,744.00 -320,932.77 REVENUE Advertising and Sponsorship 1,900,000.00 1,613,435.00 350,000.00 1,000,000.00 1,200,000.00 351,116.00 981,759.00 1,200,163.00 Ticket Sales Season Ticket Sales Group Sales Individual Ticket Sales All Star Game Ticket Sales Play-off Game Ticket Sales Upper Deck Ticket Sales Total Ticket Sales 0.00 15,000.00 213,000.00 2,778,000.00 209,269.00 2,742,307.00 Concession Sales Concession Stand Sales Catering Outside Event Concession Sales Vouchers Subcontractor Sales Subcontractor Rent Total Concession Sales 2,039,113.00 834,548.00 80,000.00 25,000.00 118,833.00 79,819.00 3,177,313.00 1,789,113.00 840,796.00 80,239.00 16,568.00 125,226.00 67,594.33 2,919,536.33 Souvenir and Merchandise Sales 237,671.00 237,966.00 60,000.00 64,520.00 Other Revenue Parking Revenue Other Event Rental Revenue Miscellaneous Revenue Upper Deck Revenue Naming Rights Revenue Total Other Revenue 216,761.00 140,527.00 175,000.00 161,000.00 260,000.00 656,000.00 421,808.00 Total Revenue 8,748,984.00 7,935,052.33 -200,000.00 -148,500.00 -147,000.00 -55,000.00 -41,000.00 -25,000.00 -81,000.00 -50,500.00 -58,000.00 -23,000.00 -300,000.00 -481,750.00 -204,682.00 -173,094.00 -116,631.00 -60,330.00 -30,956.00 -31,148.00 -81,522.00 -48,956.00 -63,906.00 -23,334.00 -280,751.00 -436,695.00 -3.177.00 -8,688.00 -18,778.00 -157,249.00 -13,000.00 -128,000.00 -1,751,750.00 -1,739,897.00 -682,369.00 -8,027.00 -106,952.00 -112,391.00 -2,500.00 -661,749.00 -7.798.00 -107,297.00 -70,885.00 -3,237.00 -19,846.00 -870,812.00 -912,239.00 Cost of Goods Sold Payroll and Related Expenses Salaries - Salesmen Salaries - Ticket Sellers Salaries - Group Sales Salaries - Operations Salaries - Groundskeepers Salaries - Parking Salaries - Security Salaries - Ushers Salaries - Maintenance Salaries - Interns Salaries - Concession Mgmt Salaries - Concession Salaries - Temps Salaries - NPG's Salaries - Souvenir Payroll Taxes Bonuses Total Payroll Related Expenses Concession and Souvenir Cost Concession Product Concession Supplies Souvenir Product Nonfood Supplies Freight Other Cost of Product Total Conc and Souvenir Cost Park Rent and Related Expenses Park Rent Stadium Utilities Field Maintenance Stadium Maintenance Total Park Expenses Promotion Expense Merchandise Giveaways Entertainment Fireworks Fence Sign Costs All Star Game Promotions Playoff Game Promotions Player of the Month Promotions Other Events Total Promotion Expense Other Cost of Sales Team Expenses Team Equipment Team Meal Money Team Lodging Team Travel Team Uniforms Player Development Costs Total Team Expenses Ticket Assessment Fee Broadcasting Stadium Security Employee Uniforms Ticket Printing Publications Expense Parking Lot Shuttle Tent Maintenance Publication Expense Equipment Repair and Maint. Miscellaneous Cost of Sales Total Other Cost of Sales Total Cost of Sale -1,245,000.00 -90,000.00 -36,000.00 -100,000.00 -1,471,000.00 -1,245,000.00 -78,049.00 -24,278.00 -109,629.00 -1,456,956.00 -232,000.00 -76,200.00 -175,000.00 -28,000.00 -171,528.00 -48,780.00 -143,043.00 -24,702.00 -125.00 -7,860.10 -396,038.10 -511,200.00 -10,000.00 -68,750.00 -55,000.00 -8,000.00 -141,750.00 -187,515.00 -40,000.00 -5,000.00 -14,000.00 -6,800.00 -6,190.00 -4,266.00 -54,949.00 -50,964.00 -5,158.00 -9,402.00 -130,929.00 -184,962.00 -40,500.00 -5,001.00 -6,553.00 -6,369.00 -32,000.00 -27,000.00 -13,924.00 -31,348.00 -28,518.00 -19,288.00 -467,392.00 -4,931,095.10 -454,065.00 -5,100,254.00 Gross Profit 3,648,730.00 3,003,957.23 -199,200.00 -180,000.00 -180,000.00 -40,000.00 -191,672.00 -154,321.00 -204,633.00 -56,129.00 -599,200.00 -360,000.00 -48,000.00 -48,000.00 -20,000.00 -9,000.00 -32,000.00 -157,000.00 -120,000.00 -40,000.00 -20,000.00 -13,000.00 -10,000.00 -5,100.00 -10,000.00 -2,900.00 -221,000.00 -232,957.00 -606,755.00 -299,961.00 -52,596.00 -51,559.00 -15,636.00 -1,965.00 -29,850.00 -151,606.00 -96,827.00 -23,021.00 -8,496.00 -11,871.00 3,483.00 3,845.00 -7,977.00 0.00 -155,520.00 -208,000.00 Expenses Salaries and Related Expenses Salaries - Executive Salaries - Media Salaries - Office Payroll Taxes Bonuses Total Salaries and Related Exp Advertising Expense Utilities Telephone and Internet Expense Repairs Expense Equipment Rental Expense Equipment Leasing Total Utilities and Related Group Health Insurance Workers Compensation Insurance Disability Insurance 401k Expenses Meals and Entertainment Exp Travel Automobile Expenses Seminars Employee Related Expense Sales Tax Other General and Admin Exp Insurance Expense Printing Expense Postage Expense Office Supplies Other Supplies League Dues Dues and Subscriptions ADP Processing Fees Bank Fees Credit Card Fees Loss on NSF Checks Late Fees License Fees Bad Debt Expense Winter Banquet Expense Other Miscellanous Total Other General and Admin Professional Fees Management Fee Accounting Fees Legal Fees MIS Support Public Relations Total Professional Fees Depreciation Expense Total Gen. & Admin. Expenses Income From Operations Interest - Revolver Interest - Term Loan Interest - Term Note Interest - Def Charges Interest - Capital Lease Obl. Total Interest Expense Loss on Disposal of Assets Total Other Exp (Income) Net Income -100,000.00 -50,000.00 -50,000.00 -15,000.00 - 15,000.00 -56,000.00 -15,000.00 -14,000.00 -18,000.00 -70,000.00 -1,500.00 -24,000.00 -8,000.00 -24,000.00 -600.00 -6,000.00 -467,100.00 -78,932.00 -39,645.00 -16,353.00 -11,752.00 -14,275.00 -55,982.00 -15,867.00 -13,224.00 -27,334.00 -68,646.00 -396.00 -25,440.00 -7,387.00 -80,678.00 -21,150.00 -477,061.00 -720,000.00 -42,000.00 -12,000.00 -9,000.00 -720,000.00 -24,000.00 -8,035.00 -4,476.00 -783,000.00 -360,000.00 3,180,257.00 468,473.00 -50,000.00 -200,000.00 -756,511.00 -346,732.00 -3,002,146.00 1,811.23 -47,006.00 -232,378.00 -7,685.00 -35,675.00 -36,000.00 -286,000.00 -322,744.00 -286,000.00 182,473.00 -322,744.00 -320,932.77

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Quantitative Corporate Finance

Authors: John B. Guerard Jr. Anureet Saxena, Mustafa Gultekin

2nd Edition

3030435466, 978-3030435462

More Books

Students also viewed these Finance questions

Question

Describe what a one-minute self-sell is and what it contains.

Answered: 1 week ago

Question

List and explain the steps in the negotiating process.

Answered: 1 week ago