Microschool Revolution Financial Projection Template

	B	C	D	E
1	Financial projection template
2	The goal of this template is to give you an example of what a school's first year budget might look like. Your income, expenses, and specific dollar amounts will be different than what is shown here. This template is built with simple formulas that will likely apply to your school. When you change the values in the green cells on the "Budget" tab/sheet, monthly values for the whole year will be changed. The sections below give more specific guidance.
3
4	How to use
5	In the top menu, click File > Make a Copy. An editable version of this file will be created in your personal Google Drive. All information below references the tables in the "Budget" tab of this Google sheet.
6
7		Cell	Information	Instructions
8	Assumptions	B2	Number of students	Change the number in cell B2 to reflect the number of students in your school. This will automatically change the amount of income you receive through tuition and other items that occur on a per-student basis.
9	Assumptions	B3	Number of months tuition will be charged	Change the number in cell B3 to match your billing cycle, specifically how many months you plan to charge tuition for each family.
10	Income	B8	Annual tuition per student	Enter the annual amount of tuition charged per student in cell B8. It will be divided by the number of months tuition is charged.
11		B9	Deposit per student	Enter the deposit per student in cell B9. This money will show up in the "opening" column because you'll have it before the first month your school is open. Since the money goes toward the tuition bill for the first month, it will also reduce the tuition received in month 1 (presumably August).
12		B10	Registration fee per student	Enter the registration fee per student in cell B10. This is a non-refundable fee, so it affects nothing other than the available funds for your opening. This fee mainly helps buy laptops for new students.
13		line 12	Available funds	The sum of available funds for each month is given on line 12. This is calculated by the spreadsheet.
14	Expenses	B18 - B20	Annual salary of each teacher	Enter the annual salary of each teacher in cells B18, B19, and B20. You can duplicate or delete rows as needed for the number of teachers you'll have, but make sure new rows are included in total expenses on line 35. The salary expense will be split evenly across the 12 months. Don't forget to include employer matching taxes here.
15		D21	Monthly rent	Enter the monthly rent cost in cell D21. This model assumes that you'll need to pay the first month's rent as a deposit, but it can easily be set up to match whatever rent model your landlord requires. Currently, cells F21 through P21 match cell D21 or the cell immediately preceeding it.
16		D22	Monthly utilites	Enter the monthly utilities cost in D22. Again, this can be set up to include an up-front deposit if necessary.
17		D23 - D25	Monthly insurance, software, classroom materials	Enter monthly insurance, software, and classroom materials costs in cells D23, D24, and D25, respectively. Changing the value in the D cell will change the value for each subsequent month.
18		D26-E26	Advertising	Enter the cost of any advertising in cell D26. You'll likely spend money on this for the opening and possibly in the spring when families are looking around for the next year. Optionally, you can put a monthly spend in E26.
19		D29 - D31	Computers, desks, books	One-time costs such as computers, desks, and books are shown in cells D29 - D31. Computers are calculated per student.
20		New rows	Additional expenses	If there are additional expenses, duplicate a row that most closely matches the type of expense you're adding. Rename the item in column A and make sure the sum formula in total expenses includes the new row.
21		line 35	Total expenses	The sum of expenses for each month is given on line 35. This is calculated by the spreadsheet.
22	Profit or Loss	line 35	Profit or loss	The difference between the available funds and the expenses is given in line 35. Negative numbers reflect insufficent funds for the month's expenses, while positive numbers reflect a surplus. This is calculated by the spreadsheet.
23		line 37	Running balance	Line 37 gives the running balance, or the amount of money that would be in your school's bank account. This is calculated by the spreadsheet.
24				The first few months will likely be the most difficult because of start-up expenses. It's not unusual to have loss in the first few months followed by profit, but it does mean you'll need an external source of money (such as a seed loan) to make it through the first few months.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100