St Cloud Projected Budget- 2018 (2).xlsx - St. Cloud...

This preview shows page 1 - 2 out of 2 pages.

The preview shows page 1 - 2 out of 2 pages.
St. Cloud Theatre Company, Inc.Pro Forma Cash BudgetYear Ended December 31, 200X---------- Year 1 -----------Year 1 TotalYear 2Year 3Three-YearPeriodCash, Beginning Balance$-$21,580 $20,985CASH RECEIPTS:Ticket Sales32,00032,00045,00052,000129,000Ticket Price (avg)$7.007.00 $7.00 $8.00Revenue$224,000 $224,000 $315,000 $416,000$955,000Concession SalesVolume (.6 ticket vol)24,00024,00027,00031,20082,200Candy Price (avg)$2.50 $2.50 $2.50 $2.75Revenue$60,000 $60,000 $67,500 $85,800$213,300Total cash from customers$284,000 $284,000 $382,500 $501,800$1,168,300TOTAL CASH AVAILABLE$284,000 $284,000 $404,080 $522,785$1,210,865CASH PAYMENTS:Rent: Theatre$30,000 $90,000 $120,000 $120,000 $130,000$370,000Equipment Purchase/LeaseProjector Lease$5,000 $5,000 $5,000 $5,000$15,000Concession Machines$15,000$15,000Seats/Screen$10,000$10,000Computer-Register$5,000$5,000$2,500$7,500Sign$2,000$2,000Office [fax,copy,computerdesk, files, chairs]$10,000$10,000Carpet$25,000$25,000Movie Leasing (40% of gate)$89,600 $89,600 $126,000 $166,400$382,000SalariesManager$10,000 $30,000 $40,000 $42,000 $44,000$126,0002 employees$30,000 $30,000 $42,000 $44,000$116,000Merchandise (25% of conc sales)$15,000 $15,000 $16,875 $21,450$53,325OtherUtilities$4,000 $11,000 $15,000 $15,500 $16,000$46,500Insurance$500 $1,500 $2,000 $2,100 $2,200$6,300Professional$5,000 $5,000 $5,000 $5,250$15,250Startup Costs$3,500$3,500$3,500Advertising$5,000 $12,000 $17,000 $16,000 $17,000$50,000Cleaning$10,000 $10,000 $10,000 $10,000$30,000Security$2,500 $2,500 $2,500 $2,500$7,500Maintenance$5,000 $5,000 $5,000 $5,000$15,000Miscellaneous$2,000 $3,000 $5,000 $5,000 $5,000$15,000Interest Expense$6,716 $8,375$15,091TOTAL CASH PAYMENTS:$122,000$309,600 $431,600 $419,691 $484,675$1,767,566Excess or (Deficit)($122,000)($25,600)($147,600)($15,611)$38,110$(125,101)Cash needed and raised to fund Deficit$122,000 $25,600 $147,600 $15,611$163,211$

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
RobertPritchard
Tags
Economics, Debt, Interest, Generally Accepted Accounting Principles, Ownership equity

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture