Good Morning, I am hoping I can get help with the following.
Pro Forma Budget & Business Plan Project: THIS WOULD BE NEEDED BY 10/21/20
Based on the following information and the data included in the Excel worksheet:
1.Using Excel, Prepare Pro Forma Financial Budget for the Next Fiscal Year, and
2. Construct the Business Plan in the “Lean Format” utilizing the template provided.
You were just hired as the new Chief Financial Officer (CFO) for an Arena Football 2 team (af2), the Columbia Destroyers. The previous CFO, who has recently left the organization, was not good at his job, unfortunately. The financials are a mess. In addition, the president of the club is asking you to create pro forma financials for the next fiscal year. The information is not altogether good, but you know how to create financial statements for the club. The facts you do know regarding the financial operation of the club are as follows:
1.You have a copy of last year’s financials (balance sheet and income statement)
2.The club was purchased last year for $1 million and uses the accrual basis of accounting.
3.The club was capitalized as follows:
Borrowed $1,000,000 at 7% interest for seven years (PMT = $185,553; I1 = $70,000; I2 = $61,911)
4.It is forecasted that costs and expenditures will change as follows:
Player compensation—increase 3.5%
Football operations—remain the same
Business operations—decrease 1.5%
Rent—increase by $10,000
1.The team is expected to generate cash receipts as follows:
Ticket sales—37,500 fans at $16.25 per ticket
Concessions—37,500 fans at $3.50 per fan
Parking—$48,000 per year
Merchandise—37,500 fans at $2.10 per fan
All short-term fixed assets depreciated over a 5-year life using the straight line method
The football team pays the City 10% for each ticket sold. This is an expense.
Accounts receivable for ticket sales will increase by $5,000 next year.
Accounts payable for business operations will increase by $180,000 next year.
Franchise value is amortized over a 15-year period.
Don’t forget the depreciation, amortization and interest expenses.
Tax Rate: 40%
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
PLACE THIS ORDER OR A SIMILAR ORDER WITH USA ELITE WRITERS TODAY AND GET AN AMAZING DISCOUNT