St Cloud Projected Money Stuff .xlsx - St Cloud Theatre...

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

St. Cloud Theatre Company, Inc. Pro Forma Cash Budget Year Ended December 31, 200X ---------- Year 1 ----------- Year 2 Year 3 Three-Year Period Cash, Beginning Balance$ 6,100 $ 15,480 $ 20,954 CASH RECEIPTS:Ticket Sales32,000 45,000 52,000 $ 129,000 Ticket Price (avg)$ 7.00 $ 7.00 $ 8.00 Revenue$ 224,000 $ 315,000 $ 416,000 $ 955,000 Concession SalesVolume (.6 ticket vol)24,000 27,000 31,200 $ 82,200 Candy Price (avg)$ 2.50 $ 2.50 $ 2.75 Revenue$ 60,000 $ 67,500 $ 85,800 $ 213,300 Total cash from customers$ 284,000 $ 382,500 $ 501,800 $ 1,168,300 TOTAL CASH AVAILABLE$ 290,100 $ 397,980 $ 522,754 $ 1,210,834 CASH PAYMENTS:Rent: Theatre$ 30,000 $ 90,000 $ 120,000 $ 130,000 $ 370,000 Equipment Purchase/LeaseProjector Lease$ 5,000 $ 5,000 $ 5,000 $ 15,000 Concession Machines$ 15,000 $ 15,000 Seats/Screen$ 10,000 $ 10,000 Computer-Register$ 5,000 $ 2,500 $ 7,500 Sign$ 2,000 $ 2,000 Office [fax,copy,computerdesk, files, chairs]$ 10,000 $ 10,000 Carpet$ 25,000 $ 25,000 Movie Leasing (40% of gate)$ 89,600 $ 126,000 $ 166,400 $ 382,000 SalariesManager$ 10,000 $ 30,000 $ 42,000 $ 44,000 $ 126,000 2 employees$ 30,000 $ 42,000 $ 44,000 $ 116,000 Merchandise (25% of conc sales)$ 15,000 $ 16,875 $ 21,450 $ 53,325 OtherUtilities$ 4,000 $ 11,000 $ 15,500 $ 16,000 $ 46,500 Insurance$ 500 $ 1,500 $ 2,100 $ 2,200 $ 6,300 Professional $ 5,000 $ 5,000 $ 5,250 $ 15,250 Startup Costs$ 3,500 $ 3,500 Advertising$ 5,000 $ 12,000 $ 16,000 $ 17,000 $ 50,000 Cleaning$ 10,000 $ 10,000 $ 10,000 $ 30,000 Security$ 2,500 $ 2,500 $ 2,500 $ 7,500 Maintenance$ 5,000 $ 5,000 $ 5,000 $ 15,000 Miscellaneous$ 2,000 $ 3,000 $ 5,000 $ 5,000 $ 15,000 Interest Expense$ 6,106 $ 8,311 $ 14,416 TOTAL CASH PAYMENTS:$ 122,000 $ 309,600 $ 419,081 $ 484,611 $ 1,335,291 Pre opening 3 Months Post opening

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture