Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Columbia Arena Company formed in 2021 and uses the accrual basis of accounting. Using the company's 2021 budget provided on the separate Excel

image text in transcribedimage text in transcribed

The Columbia Arena Company formed in 2021 and uses the accrual basis of accounting. Using the company's 2021 budget provided on the separate Excel file, develop a pro forma operating budget for 2022 based on the following revenue and expense estimates: a. It is forecasted that costs and expenditures will change in 2022 as follows: i. Merchandise COGS, G&A, Event Costs, and Maintenance will increase by 4.7%. ii. Concessions COGS will increase by 7.5%. iii. Utilities will increase by 8.0%. iv. Personnel will increase by 1.5%. v. Insurance, Contract Services, Marketing, Management Fee, and Reserve are forecasted to remain the same. b. The Arena is expected to generate cash receipts in 2022 as follows: i. All rent will increase by 4.7%. ii. Concessions Gross will increase by 5.0%. iii. Merchandise Gross, Suite Revenue, Club Seating Revenue, Advertising Revenue, and Naming Rights are forecasted to remain the same. iv. Box Office, Parking, and Ticket Fee revenues will decrease by 2.7%.

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

Financial Management In The Sport Industry

Authors: Brown T Matthew

2nd Edition

041579000X, 9780415790000

More Books

Students also viewed these Accounting questions