Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SEA 1 4 5 WINTER 2 0 2 1 EVENT FINANCIAL MANAGEMENT ASSIGNMENT # 4 : SEE INSTRUCTIONS AT THE BOTTOM OF PAGE YORK REGION

SEA 145 WINTER 2021 EVENT FINANCIAL MANAGEMENT
ASSIGNMENT #4: SEE INSTRUCTIONS AT THE BOTTOM OF PAGE
YORK REGION INTERNATIONAL CRICKET TOURNAMENT
2018 CASH FLOW BUDGET - First Quarter
Allocations Q1 Cash Flow Budget Assumptions Q1
CASH IN
Earned Income
Ticket sales $110,000 Budget to receive 50% Feb; 50% March
Tickets Handling Fees $6,600 Allocate 6% of ticket sales
Gate Entertainment day n/a n/a
Concessions n/a n/a
Merchandising n/a n/a
Contributed Income
Advertising sales $5,000 Budget to receive 50% March
Sponsorships $40,000 Budget to receive 20% Feb; 80% March
Grants $65,000 Budget to receive 25% Jan; 75% March
Major Gift $300,000 Budget to receive 100% Jan
Small Gifts $10,000 Q1 Equal montly allocations
Other Income
Interest Income $2,000 Q1 Equal monthly allocation
CASH OUT
Tournament production/presentation
Production tournament $50,000 Deposit due March 1-100%
Entertainment $20,000 Deposit due March 15-100%
Teams travel costs $20,000 Deposit due Feb 15-100%
Teams hotel costs $25,000 Deposit due Jan 15-100%
Venue and hospitality $30,000 Deposit due on April 1st -100%
Marketing and promotion
Marketing costs $35,000 Budget 35% in January; 25% in February; balance in March
Concession costs n/a n/a
Merchandising costs $27,500 Deposit due Jan 31-100%
Small gift Campaign $10,000 Budget 20% Feb; 80% March
Operations
Operations and Administration $50,000 Q1 Equal montly allocations
Salaries $125,000 Q1 Equal montly allocations
ASSIGNMENT #4 INSTRUCTIONS:
Develop the 2018 Q1 Cash Flow Budget for YRICT - including the cash flow budget FY2017 as baseline
Your format must include a 15-month Cash Flow Budget
Q1- January, February, March
A. Complete the cash flow budget using the budget allocations and assumptions on this sheet - columns D and E
B. Include the following additional cash transactions for your 2018 Cash Flow Budget for Q1:
Accounts Receivable $50,000 Budget to receive payments as such: 50% Jan, 50% March
Accounts Payable $60,000 Budget to pay equal amounts from January to March 2018
Loans payments $125,000 Plan to allocate equal amounts every other month from January to December 2018
Cash-in of short term investments $30,000 Budget to receive 100% in March
Notes to budget:
The Tournament will be held in August
Starting Cash: as per cash flow already completed YRICT CF Budget FY 2017

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