President Theater First Cut First Cut Second Second Cut Enter Your Name Right Here, in Cell B3 - NOW Two Years Last Year % Next Year Cut % Next Year Ago Actual Actual Change Budget Change Budget Revenue Development # Number of Movies Shown 500 500 ----- 500 0.0% 500 X Average Number of Tickets/Movie 98.0 97.0 ----- 97.0 0.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.0% 71.0% ----- 71.0% 0.0% 71.0% = # 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 ----- $4.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 0.0% 24.0 = Total Number of Employee Hours 12,000 12,000 12,000 12,000 X Rate of Pay per Cost per Hour $8.00 $8.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 0.0% $45,000 0.0% $45,000 # Balance of Loan $600,000 $700,000 ----- $700,000 ----- $700,000 X# Interest Rate 9.0% 9.0% ----- 9.0% ----- 9.0% = 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 % Next Year Financial Summary Ago Actual Actual Change Budget Change Budget Movie Ticket Sales -Total $325,622 $323,222 0.0% $323,222 0.0% $323,222 Junk Food Revenue - Total $126,947 $130,876 0.0% $130,876 0.0% $130,876 Total Revenue $452,569 $454,098 0.0% $454,098 0.0% $454,098 Total Cost for Movie Tickets $213,000 $231,000 0.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 0.0% $105,000 0.0% $105,000 Your Salary - You Live on This $45,000 $45,000 0.0% $45,000 0.0% $45,000 Total Interest Expense $54,000 $63,000 0.0% $63,000 0.0% $63,000 Total Expenses $458,100 $504,300 0.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

HERE'S THE LINK FOR YOU TO UNDERSTAND CLEARLY.