For more small business templates visit:

5-Year Financial (Business) Plan—Manufacturing

Model inputs and investor scenario

Company Name:

Year 1 model inputs

1. Year-one forecasted revenue

<Product 1> <Product 2>
Number of units sold annually 250 430
Average sales price per unit $125.00 $100.00
Annual revenue per product $31,250.00 $43,000.00

Total year 1 revenue $101,400.00

2. Year 1 cost of goods sold

<Product 1> <Product 2>
Expected gross margin per product 30% 25%
Annual cost of goods sold per product $9,375.00 $10,750.00

Total year 1 cost of goods sold $27,587.50

3. Annual maintenance, repair, and overhaul

Factor (%) on capital equipment 15%

4. Number of years for straight-line depreciation 5

5. Annual tax rate 30%

6. If long-term debt is being used to finance $5,000

operations, enter the total loan value.
l business templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com

lan—Manufacturing
or scenario

Help

<Product 3> <Product 4>

210 540
$65.00 $25.00
$13,650.00 $13,500.00

<Product 3> <Product 4>

25% 30%
$3,412.50 $4,050.00
 For more small business templates visit:

5-Year Financial (Business) Plan—Manufacturi

Profit and loss projections
Company Name:

Year-by-year profit and loss assumptions

Year 1 Year 2
Annual cumulative price (revenue) increase - 2.00%
Annual cumulative inflation (expense) increase - 2.00%
Interest rate on ending cash balance 0.50% 0.50%

Year 1 Year 2
Revenue
Gross revenue $101,400 $103,428
Cost of goods sold $27,588 $28,139
Gross margin $73,813 $75,289

Other revenue [source] $0 $0

Interest income $0 $0
Total revenue $73,813 $75,289

Operating expenses
Sales and marketing $15,000 $15,300
Payroll and payroll taxes $21,000 $21,420
Depreciation $6,000 $6,120
Insurance $7,500 $7,650
Maintenance, repair, and overhaul $1,500 $1,530
Utilities $5,000 $5,100
Property taxes $2,500 $2,550
Administrative fees $300 $306
Other $1,000 $1,020
Total operating expenses $59,800 $60,996

Operating income $14,013 $14,293

Interest expense on long-term debt $224 $179

Operating income before other items $13,788 $14,114

Loss (gain) on sale of assets $0 $0

Other unusual expenses (income) $0 $0

Earnings before taxes $13,788 $14,114

Taxes on income 30% $4,136 $4,234

Net income (loss) $17,925 $18,348

l business templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com

n—Manufacturing
ons
Help

Year 3 Year 4 Year 5

4.00% 6.00% 8.00%
4.00% 6.00% 8.00%
0.50% 0.50% 0.50%

Year 3 Year 4 Year 5

$107,565 $114,019 $123,141

$29,265 $31,021 $33,502
$78,300 $82,998 $89,638

$0 $0 $0
$0 $0 $0
$78,300 $82,998 $89,638

$15,912 $16,867 $18,216

$22,277 $23,613 $25,502
$6,240 $6,360 $6,480
$7,956 $8,433 $9,108
$1,560 $1,590 $1,620
$5,304 $5,622 $6,072
$2,652 $2,811 $3,036
$318 $337 $364
$1,061 $1,124 $1,214
$63,280 $66,759 $71,613

$15,020 $16,240 $18,025

$132 $82 $29

$14,889 $16,158 $17,996

$1,000 $0 $0
$0 $0 $0

$15,889 $16,158 $17,996

 $4,767 $4,847 $5,399

$20,656 $21,005 $23,394

 For more small business temp

5-Year Financial (Business) Plan—Manufac

Balance sheet projections
Company Name:

Assets Initial balance Year 1

Cash and short-term investments $50,000 $173,020
Accounts receivable $3,000 $3,000
Total inventory $25,000 $25,000
Prepaid expenses $0 $0
Deferred income tax $0 $0
Other current assets $5,000 $5,000
Total current assets $83,000 $206,020

Buildings $20,000 $20,000

Land $10,000 $10,000
Capital improvements $0 $0
Machinery and equipment $10,000 $10,000
Less: Accumulated depreciation expense $0 $6,000
Net property/equipment $40,000 $34,000

Goodwill $0 $0
Deferred income tax $0 $0
Long-term investments $0 $0
Deposits $0 $0
Other long-term assets $0 $0
Total assets $123,000 $240,020

Liabilities Initial balance Year 1

Accounts payable $2,000 $2,000
Accrued expenses $0 $0
Notes payable/short-term debt $0 $0
Capital leases $0 $0
Other current liabilities $100 $100
Total current liabilities $2,100 $2,100

Long-term debt from loan payment calculator $5,000 $4,095

Other long-term debt $100,000 $200,000
Total debt $107,100 $206,195

Other liabilities $0 $0

Total liabilities $7,100 $6,195

Equity Initial balance Year 1

Owner's equity (common) $50,000 $50,000
Paid-in capital $250,000 $250,000
Preferred equity $0 $0
Retained earnings $0 $17,925
Total equity $300,000 $317,925

Total liabilities and equity $307,100 $324,120

For more small business templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com

Plan—Manufacturing
ojections
Help

Year 2 Year 3 Year 4 Year 5

$146,537 $196,435 $272,753 $226,527
$3,000 $3,000 $3,000 $3,000
$25,000 $25,000 $25,000 $25,000
$0 $0 $0 $0
$0 $0 $0 $0
$5,000 $5,000 $5,000 $5,000
$179,537 $229,435 $305,753 $259,527

$20,000 $20,000 $20,000 $20,000

$10,000 $10,000 $10,000 $10,000
$0 $0 $0 $0
$10,000 $10,000 $10,000 $10,000
$12,120 $18,360 $24,720 $31,200
$27,880 $21,640 $15,280 $8,800

$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$207,417 $251,075 $321,033 $268,327

Year 2 Year 3 Year 4 Year 5

$2,000 $2,000 $2,000 $2,000
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$100 $100 $100 $100
$2,100 $2,100 $2,100 $2,100

$3,145 $2,147 $1,100 $0

$150,000 $175,000 $225,000 $150,000
$155,245 $179,247 $228,200 $152,100

$0 $0 $0 $0

$5,245 $4,247 $3,200 $2,100

Year 2 Year 3 Year 4 Year 5

 $50,000 $50,000 $50,000 $50,000
$250,000 $250,000 $250,000 $250,000
$0 $0 $0 $0
$36,272 $56,928 $77,933 $101,327
$336,272 $356,928 $377,933 $401,327

$341,517 $361,175 $381,133 $403,427

 For more small business temp

5-Year Financial (Business) Plan—Manufac

Balance sheet projections
Company Name:

Year 1 Year 2
Operating activities
Net income $17,925 $18,348
Depreciation $6,000 $6,120
Accounts receivable $0 $0
Inventories $0 $0
Accounts payable $0 $0
Amortization $0 $0
Other liabilities $0 $0
Other operating cash flow items $0 $0
Total operating activities $23,925 $24,468

Investing activities
Capital expenditures $0 $0
Acquisition of business $0 $0
Sale of fixed assets $0 $0
Other investing cash flow items $0 $0
Total investing activities $0 $0

Financing activities
Long-term debt/financing $99,095 -$50,950
Preferred stock $0 $0
Total cash dividends paid $0 $0
Common stock $0 $0
Other financing cash flow items $0 $0
Total financing activities $99,095 -$50,950

Cumulative cash flow $123,020 -$26,482

Beginning cash balance $50,000 $173,020

Ending cash balance $173,020 $146,537
For more small business templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com

) Plan—Manufacturing
ojections
Help

Year 3 Year 4 Year 5 Total

$20,656 $21,005 $23,394 $101,327

$6,240 $6,360 $6,480 $31,200
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$26,896 $27,365 $29,874 $132,527

$0 $0 $0 $0
$0 $0 $0 $0
-$1,000 $0 $0 -$1,000
$0 $0 $0 $0
-$1,000 $0 $0 -$1,000

$24,002 $48,952 -$76,100 $45,000

$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$24,002 $48,952 -$76,100 $45,000

$49,898 $76,318 -$46,226 $176,527

$146,537 $196,435 $272,753

$196,435 $272,753 $226,527
 For more small business templates visit:

5-Year Financial (Business) Plan—Manufactur

Loan payment calculator
Company Name:

Annual interest rate 5.0% Note: This calculator can generate principal and
Monthly rate 0.41% interest payments for a period of up to 30 years (360
Loan amount $5,000 months).
Term of loan (months) 60
Payment ($94.10)

Month Principal balance Principal payment Interest

1 $5,000 ($74) ($20)
2 $4,926 ($74) ($20)
3 $4,852 ($74) ($20)
4 $4,778 ($75) ($19)
5 $4,703 ($75) ($19)
6 $4,628 ($75) ($19)
7 $4,553 ($76) ($19)
8 $4,478 ($76) ($18)
9 $4,402 ($76) ($18)
10 $4,326 ($76) ($18)
11 $4,249 ($77) ($17)
12 $4,172 ($77) ($17)
13 $4,095 ($77) ($17)
14 $4,018 ($78) ($16)
15 $3,940 ($78) ($16)
16 $3,862 ($78) ($16)
17 $3,784 ($79) ($15)
18 $3,705 ($79) ($15)
19 $3,626 ($79) ($15)
20 $3,547 ($80) ($14)
21 $3,467 ($80) ($14)
22 $3,387 ($80) ($14)
23 $3,307 ($81) ($13)
24 $3,226 ($81) ($13)
25 $3,145 ($81) ($13)
26 $3,064 ($82) ($12)
27 $2,982 ($82) ($12)
28 $2,900 ($82) ($12)
29 $2,818 ($83) ($11)
30 $2,735 ($83) ($11)
31 $2,652 ($83) ($11)
32 $2,569 ($84) ($10)
33 $2,485 ($84) ($10)
34 $2,401 ($84) ($10)
35 $2,317 ($85) ($9)
36 $2,232 ($85) ($9)
37 $2,147 ($85) ($9)
38 $2,062 ($86) ($8)
39 $1,976 ($86) ($8)
40 $1,890 ($86) ($8)
41 $1,804 ($87) ($7)
42 $1,717 ($87) ($7)
43 $1,630 ($87) ($7)
44 $1,543 ($88) ($6)
45 $1,455 ($88) ($6)
46 $1,367 ($89) ($6)
47 $1,278 ($89) ($5)
48 $1,189 ($89) ($5)
49 $1,100 ($90) ($4)
50 $1,010 ($90) ($4)
51 $920 ($90) ($4)
52 $830 ($91) ($3)
53 $739 ($91) ($3)
54 $648 ($91) ($3)
55 $557 ($92) ($2)
56 $465 ($92) ($2)
57 $373 ($93) ($2)
58 $280 ($93) ($1)
59 $187 ($93) ($1)
60 $94 ($94) ($0)
61 ($0) ($0) $0
62 ($0) ($0) $0
63 ($0) ($0) $0
64 ($0) ($0) $0
65 ($0) ($0) $0
66 ($0) ($0) $0
67 ($0) ($0) $0
68 ($0) ($0) $0
69 ($0) ($0) $0
70 ($0) ($0) $0
71 ($0) ($0) $0
72 ($0) ($0) $0
73 ($0) ($0) $0
74 ($0) ($0) $0
75 ($0) ($0) $0
76 ($0) ($0) $0
77 ($0) ($0) $0
78 ($0) ($0) $0
79 ($0) ($0) $0
80 ($0) ($0) $0
81 ($0) ($0) $0
82 ($0) ($0) $0
83 ($0) ($0) $0
 84 ($0) ($0) $0
85 ($0) ($0) $0
86 ($0) ($0) $0
87 ($0) ($0) $0
88 ($0) ($0) $0
89 ($0) ($0) $0
90 ($0) ($0) $0
91 ($0) ($0) $0
92 ($0) ($0) $0
93 ($0) ($0) $0
94 ($0) ($0) $0
95 ($0) ($0) $0
96 ($0) ($0) $0
97 ($0) ($0) $0
98 ($0) ($0) $0
99 ($0) ($0) $0
100 ($0) ($0) $0
101 ($0) ($0) $0
102 ($0) ($0) $0
103 ($0) ($0) $0
104 ($0) ($0) $0
105 ($0) ($0) $0
106 ($0) ($0) $0
107 ($0) ($0) $0
108 ($0) ($0) $0
109 ($0) ($0) $0
110 ($0) ($0) $0
111 ($0) ($0) $0
112 ($0) ($0) $0
113 ($0) ($0) $0
114 ($0) ($0) $0
115 ($0) ($0) $0
116 ($0) ($0) $0
117 ($0) ($0) $0
118 ($0) ($0) $0
119 ($0) ($0) $0
120 ($0) ($0) $0
121 ($0) ($0) $0
122 ($0) ($0) $0
123 ($0) ($0) $0
124 ($0) ($0) $0
125 ($0) ($0) $0
126 ($0) ($0) $0
127 ($0) ($0) $0
128 ($0) ($0) $0
129 ($0) ($0) $0
130 ($0) ($0) $0
131 ($0) ($0) $0
132 ($0) ($0) $0
133 ($0) ($0) $0
134 ($0) ($0) $0
135 ($0) ($0) $0
136 ($0) ($0) $0
137 ($0) ($0) $0
138 ($0) ($0) $0
139 ($0) ($0) $0
140 ($0) ($0) $0
141 ($0) ($0) $0
142 ($0) ($0) $0
143 ($0) ($0) $0
144 ($0) ($0) $0
145 ($0) ($0) $0
146 ($0) ($0) $0
147 ($0) ($0) $0
148 ($0) ($0) $0
149 ($0) ($0) $0
150 ($0) ($0) $0
151 ($0) ($0) $0
152 ($0) ($0) $0
153 ($0) ($0) $0
154 ($0) ($0) $0
155 ($0) ($0) $0
156 ($0) ($0) $0
157 ($0) ($0) $0
158 ($0) ($0) $0
159 ($0) ($0) $0
160 ($0) ($0) $0
161 ($0) ($0) $0
162 ($0) ($0) $0
163 ($0) ($0) $0
164 ($0) ($0) $0
165 ($0) ($0) $0
166 ($0) ($0) $0
167 ($0) ($0) $0
168 ($0) ($0) $0
169 ($0) ($0) $0
170 ($0) ($0) $0
171 ($0) ($0) $0
172 ($0) ($0) $0
173 ($0) ($0) $0
174 ($0) ($0) $0
175 ($0) ($0) $0
176 ($0) ($0) $0
177 ($0) ($0) $0
178 ($0) ($0) $0
179 ($0) ($0) $0
180 ($0) ($0) $0
181 ($0) ($0) $0
182 ($0) ($0) $0
183 ($0) ($0) $0
184 ($0) ($0) $0
185 ($0) ($0) $0
186 ($0) ($0) $0
187 ($0) ($0) $0
188 ($0) ($0) $0
189 ($0) ($0) $0
190 ($0) ($0) $0
191 ($0) ($0) $0
192 ($0) ($0) $0
193 ($0) ($0) $0
194 ($0) ($0) $0
195 ($0) ($0) $0
196 ($0) ($0) $0
197 ($0) ($0) $0
198 ($0) ($0) $0
199 ($0) ($0) $0
200 ($0) ($0) $0
201 ($0) ($0) $0
202 ($0) ($0) $0
203 ($0) ($0) $0
204 ($0) ($0) $0
205 ($0) ($0) $0
206 ($0) ($0) $0
207 ($0) ($0) $0
208 ($0) ($0) $0
209 ($0) ($0) $0
210 ($0) ($0) $0
211 ($0) ($0) $0
212 ($0) ($0) $0
213 ($0) ($0) $0
214 ($0) ($0) $0
215 ($0) ($0) $0
216 ($0) ($0) $0
217 ($0) ($0) $0
218 ($0) ($0) $0
219 ($0) ($0) $0
220 ($0) ($0) $0
221 ($0) ($0) $0
222 ($0) ($0) $0
223 ($0) ($0) $0
224 ($0) ($0) $0
225 ($0) ($0) $0
226 ($0) ($0) $0
227 ($0) ($0) $0
228 ($0) ($0) $0
229 ($0) ($0) $0
230 ($0) ($0) $0
231 ($0) ($0) $0
232 ($0) ($0) $0
233 ($0) ($0) $0
234 ($0) ($0) $0
235 ($0) ($0) $0
236 ($0) ($0) $0
237 ($0) ($0) $0
238 ($0) ($0) $0
239 ($0) ($0) $0
240 ($0) ($0) $0
241 ($0) ($0) $0
242 ($0) ($0) $0
243 ($0) ($0) $0
244 ($0) ($0) $0
245 ($0) ($0) $0
246 ($0) ($0) $0
247 ($0) ($0) $0
248 ($0) ($0) $0
249 ($0) ($0) $0
250 ($0) ($0) $0
251 ($0) ($0) $0
252 ($0) ($0) $0
253 ($0) ($0) $0
254 ($0) ($0) $0
255 ($0) ($0) $0
256 ($0) ($0) $0
257 ($0) ($0) $0
258 ($0) ($0) $0
259 ($0) ($0) $0
260 ($0) ($0) $0
261 ($0) ($0) $0
262 ($0) ($0) $0
263 ($0) ($0) $0
264 ($0) ($0) $0
265 ($0) ($0) $0
266 ($0) ($0) $0
267 ($0) ($0) $0
268 ($0) ($0) $0
269 ($0) ($0) $0
270 ($0) ($0) $0
271 ($0) ($0) $0
272 ($0) ($0) $0
273 ($0) ($0) $0
274 ($0) ($0) $0
275 ($0) ($0) $0
276 ($0) ($0) $0
277 ($0) ($0) $0
278 ($0) ($0) $0
279 ($0) ($0) $0
280 ($0) ($0) $0
281 ($0) ($0) $0
282 ($0) ($0) $0
283 ($0) ($0) $0
284 ($0) ($0) $0
285 ($0) ($0) $0
286 ($0) ($0) $0
287 ($0) ($0) $0
288 ($0) ($0) $0
289 ($0) ($0) $0
290 ($0) ($0) $0
291 ($0) ($0) $0
292 ($0) ($0) $0
293 ($0) ($0) $0
294 ($0) ($0) $0
295 ($0) ($0) $0
296 ($0) ($0) $0
297 ($0) ($0) $0
298 ($0) ($0) $0
299 ($0) ($0) $0
300 ($0) ($0) $0
301 ($0) ($0) $0
302 ($0) ($0) $0
303 ($0) ($0) $0
304 ($0) ($0) $0
305 ($0) ($0) $0
306 ($0) ($0) $0
307 ($0) ($0) $0
308 ($0) ($0) $0
309 ($0) ($0) $0
310 ($0) ($0) $0
311 ($0) ($0) $0
312 ($0) ($0) $0
313 ($0) ($0) $0
314 ($0) ($0) $0
315 ($0) ($0) $0
316 ($0) ($0) $0
317 ($0) ($0) $0
318 ($0) ($0) $0
319 ($0) ($0) $0
320 ($0) ($0) $0
321 ($0) ($0) $0
322 ($0) ($0) $0
323 ($0) ($0) $0
324 ($0) ($0) $0
325 ($0) ($0) $0
326 ($0) ($0) $0
327 ($0) ($0) $0
328 ($0) ($0) $0
329 ($0) ($0) $0
330 ($0) ($0) $0
331 ($0) ($0) $0
332 ($0) ($0) $0
333 ($0) ($0) $0
334 ($0) ($0) $0
335 ($0) ($0) $0
336 ($0) ($0) $0
337 ($0) ($0) $0
338 ($0) ($0) $0
339 ($0) ($0) $0
340 ($0) ($0) $0
341 ($0) ($0) $0
342 ($0) ($0) $0
343 ($0) ($0) $0
344 ($0) ($0) $0
345 ($0) ($0) $0
346 ($0) ($0) $0
347 ($0) ($0) $0
348 ($0) ($0) $0
349 ($0) ($0) $0
350 ($0) ($0) $0
351 ($0) ($0) $0
352 ($0) ($0) $0
353 ($0) ($0) $0
354 ($0) ($0) $0
355 ($0) ($0) $0
356 ($0) ($0) $0
357 ($0) ($0) $0
358 ($0) ($0) $0
359 ($0) ($0) $0
360 ($0) ($0) $0
l business templates visit: Spreadsheet123.com
© 2009 Spreadsheet123.com

—Manufacturing
or
Help

n generate principal and

riod of up to 30 years (360
ths).

Payment
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
($94)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
 For more small business templates visit: Spreadsheet12
© 2009 Spreadsheet12

5-Year Financial (Business) Plan—Manufacturing

General notes and assumptions
Company Name:

[Document key financial planning assumptions here.]

 Spreadsheet123.com
© 2009 Spreadsheet123.com

ufacturing