President Theater First Cut First Cut Second Second Cut Enter Your Name Right Here, in Cell 83 - No Two Years Last Year Next Year Cut 9% Next Year Ago Actual Actual Change Budget Change Budget Revenue Development # Number of Movies Shown 500 500 500 D.0% 500 Average Number of Tickets/Movie 98.0 97.0 97.0 D.0% 97.0 Number of Tickets Sold 49,000 48,500 48,500 48.500 X Average Price per Ticket 6.65 $ 6.66 6.66 0.0% $ 6.66 Movie Ticket Sales -Total 325,622 $ 323,222 323,222 $ 323,222 B4 Number of Tickets Sold 49,000 48.500 48.500 48.500 X Percent Tickets who Buy Junk Food 70.09% 71.0% 71.09% 0.0% 71.09% = # of Ticket holders Buying Junk Food 34,300 34,435 34,435 34,435 X Average Price per Junk Food 3.70 $ 3.80 3.80 0.0% $ 3.80 Junk Food Revenue - Total 126,947 $ 130,876 130,876 130,876 Cost Development B4 Number of Tickets Sold 49,000 48.500 48.500 48.500 X Avg. Cost /Ticket to Movie Producers 4.35 $ 4.76 0.0% $ 4.76 1.76 Total Cost for Movie Tickets 213,000 $ 231,000 231,000 231,000 B4 # of Ticket holders Buying Junk Food 34,300 34,435 34,435 34,435 X Avg. Cost per Junk Food Sold 1.46 $ 1.75 0.0% $ 1.75 1.75 Total Cost for Junk Food 50,100 $ 60.300 60,300 60.300 B4 Number of Movies Shown 500 500 500 500 X Number of Employee Hours per Show 24.0 24.0 24.0 D.0% 24.0 Total Number of Employee Hours 12,000 12,000 12,000 12,000 Rate of Pay per Cost per Hour B.00 $ 3.75 0.0% $ 8.75 0.0% $ 8.75 Total Cost of Employees 96,000 $ 105,000 105,000 105,000 # Your Salary - You Live on This 45,000 45.000 D.09% $ 45,000 0.09% $ 45.000 # Balance of Loan 600,000 $ 700,000 TH 700,000 700,000 X# Interest Rate 9.0% 9.09% 9.09% 9.09% = Total Interest Expense $ 54,000 $ 63,000 63.000 63,000 First Cut First Cut Second Second Cut Two Years Last Year Next Year Cut 9% Next Year Financial Summary Ago Actual Actual Change Budget Change Budget Movie Ticket Sales -Total 325,622 $ 323,222 D.0% $ 323,222 D.0% $ 323,222 Junk Food Revenue - Total 126,947 $ 130,876 D.0% $ 130,876 0.0% $ 130,876 Total Revenue 452,569 $ 454,098 D.0% $ 454,098 0.0% $ 454,098 Total Cost for Movie Tickets $ 213,000 $ 231,000 D.0% $ 231,000 0.0% $ 231,000 Total Cost for Junk Food 50,100 60,300 0.0% $ 60.300 0.0% $ 60.300 Total Cost of Employees 96,000 105,000 D.0% $ 105,000 0.0% $ 105,000 Your Salary - You Live on This $ 45,000 45,000 D.0% $ 45,000 D.0% $ 45,000 Total Interest Expense $ 54,000 $ 63,000 0.0% $ 63,000 0.0% $ 63,000 Total Expenses 458,100 $ 504,300 D.0% $ 504,300 0.0% $ 504,300 Total Profit (Loss) (5,531) $ (50,202) (50,202) (50,202) Capital Investment Projects (Enter as Negative Numbers) 1) Fix Roof 2) New Ticket System to Cut Employees Ending Cash Balance 5,123 $ 54,921 $ 4,719 4,719