Period Starting: Sales Sales by Product Line 1 Budget Over / (Under Budget) Sales by Product Line 2 Budget Over / (Under Budget) Sales by Product Line 3 Budget Over / (Under Budget) Sales by Product Line 4 Budget Over / (Under Budget) Sales by Product Line 5 Budget Over / (Under Budget) Sales by Product Line 6 Budget Over / (Under Budget) Total Sales Total Sales Budget Total Over / (Under Budget) Less Cost of Goods Sold Materials Budget Over / (Under Budget) Labor Budget Over / (Under Budget) Overhead Budget Over / (Under Budget) Other Budget Over / (Under Budget) Total Cost of Goods Sold Total COG Budget Total Over / (Under Budget)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Totals
1,600 595 1,005 2,600 1,595 1,005 1,600 1,895 (295) 1,600 2,895 (1,295) 1,600 595 1,005 16,000 1,595 14,405 25,000 9,170 15,830
3,350 1,678 1,672 3,350 1,678 1,672 3,350 3,678 (328) 3,350 4,678 (1,328) 3,350 1,678 1,672 13,350 1,678 11,672 30,100 15,068 15,032
5,100 4,754 346 4,100 2,754 1,346 5,100 5,754 (654) 5,100 7,754 (2,654) 5,100 4,754 346 15,100 4,754 10,346 39,600 30,524 9,076
6,850 6,501 349 4,850 3,168 1,682 6,850 7,501 (651) 6,850 6,501 349 6,850 6,501 349 16,850 6,501 10,349 49,100 36,673 12,427
8,600 7,744 856 5,600 3,748 1,853 8,600 9,431 (831) 12,600 9,431 3,169 8,600 7,744 856 16,400 8,081 8,320 60,400 46,177 14,223
10,350 9,845 505 6,350 4,327 2,023 10,350 11,320 (970) 10,350 11,320 (970) 10,350 9,845 505 16,830 9,860 6,970 64,580 56,517 8,063
12,100 10,976 1,124 7,100 4,907 2,194 12,100 13,209 (1,109) 15,100 13,209 1,891 12,100 10,976 1,124 17,260 11,639 5,621 75,760 64,916 10,844
13,850 11,232 2,618 7,850 5,486 2,364 13,850 15,099 (1,249) 15,183 15,099 85 13,850 11,232 2,618 17,690 13,419 4,271 82,273 71,566 10,707
15,600 14,323 1,277 8,600 6,066 2,535 15,600 16,988 (1,388) 16,433 16,988 (555) 15,600 14,323 1,277 15,600 14,323 1,277 87,433 83,011 4,423
17,350 15,434 1,916 9,350 6,645 2,705 17,350 18,878 (1,528) 17,683 18,878 (1,194) 17,350 15,434 1,916 17,350 15,434 1,916 96,433 90,702 5,731
19,100 16,543 2,557 10,100 7,225 2,876 19,100 20,767 (1,667) 18,933 20,767 (1,834) 19,100 16,543 2,557 19,100 16,543 2,557 105,433 98,387 7,046
20,850 17,896 2,954 10,850 7,804 3,046 20,850 22,656 (1,806) 20,183 22,656 (2,473) 20,850 17,896 2,954 20,850 17,896 2,954 114,433 106,805 7,629
134,700 117,521 (17,179) 80,700 55,401 25,299 134,700 147,175 (12,475) 143,367 150,175 (6,809) 134,700 117,521 17,179 202,380 121,722 80,658 830,547 709,516 121,031
1,600 595 1,005 1,600 595 1,005 1,600 595 1,005 1,600 595 1,005 6,400 2,380 4,020
3,350 1,678 1,672 3,350 1,678 1,672 3,350 1,678 1,672 3,350 1,678 1,672 13,400 6,712 6,688
5,100 4,754 346 5,100 4,754 346 5,100 4,754 346 5,100 4,754 346 20,400 19,016 1,384
6,850 6,501 349 6,850 6,501 349 6,850 6,501 349 6,850 6,501 349 27,400 26,004 1,396
8,600 7,744 856 8,600 7,744 856 8,600 7,744 856 8,600 7,744 856 34,400 30,976 3,424
10,350 9,845 505 10,350 9,845 505 10,350 9,845 505 10,350 9,845 505 41,400 39,380 2,020
12,100 10,976 1,124 12,100 10,976 1,124 12,100 10,976 1,124 12,100 10,976 1,124 48,400 43,904 4,496
13,850 11,232 2,618 13,850 11,232 2,618 13,850 11,232 2,618 13,850 11,232 2,618 55,400 44,928 10,472
15,600 14,323 1,277 15,600 14,323 1,277 15,600 14,323 1,277 15,600 14,323 1,277 62,400 57,292 5,108
17,350 15,434 1,916 17,350 15,434 1,916 17,350 15,434 1,916 17,350 15,434 1,916 69,400 61,736 7,664
19,100 16,543 2,557 19,100 16,543 2,557 19,100 16,543 2,557 19,100 16,543 2,557 76,400 66,172 10,228
20,850 17,896 2,954 20,850 17,896 2,954 20,850 17,896 2,954 20,850 17,896 2,954 83,400 71,584 11,816
134,700 117,521 17,179 134,700 117,521 17,179 134,700 117,521 17,179 134,700 117,521 17,179 538,800 470,084 68,716
Operating Expenses G&A Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total G&A Expenses Total G&A Budget Total Over / (Under Budget)
1,600 595 1,005 1,600 595 1,005 3,200 1,190 2,010
3,350 1,678 1,672 3,350 1,678 1,672 6,700 3,356 3,344
5,100 4,754 346 5,100 4,754 346 10,200 9,508 692
6,850 6,501 349 6,850 6,501 349 13,700 13,002 698
8,600 7,744 856 8,600 7,744 856 17,200 15,488 1,712
10,350 9,845 505 10,350 9,845 505 20,700 19,690 1,010
12,100 10,976 1,124 12,100 10,976 1,124 24,200 21,952 2,248
13,850 11,232 2,618 13,850 11,232 2,618 27,700 22,464 5,236
15,600 14,323 1,277 15,600 14,323 1,277 31,200 28,646 2,554
17,350 15,434 1,916 17,350 15,434 1,916 34,700 30,868 3,832
19,100 16,543 2,557 19,100 16,543 2,557 38,200 33,086 5,114
20,850 17,896 2,954 20,850 17,896 2,954 41,700 35,792 5,908
134,700 117,521 252,221 134,700 117,521 252,221 269,400 235,042 34,358
Sales Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Sales Expenses Total Sales Expense Budget Total Over / (Under Budget)
1,600 595 1,005 1,600 595 1,005 3,200 1,190 2,010
3,350 1,678 1,672 3,350 1,678 1,672 6,700 3,356 3,344
5,100 4,754 346 5,100 4,754 346 10,200 9,508 692
6,850 6,501 349 6,850 6,501 349 13,700 13,002 698
8,600 7,744 856 8,600 7,744 856 17,200 15,488 1,712
10,350 9,845 505 10,350 9,845 505 20,700 19,690 1,010
12,100 10,976 1,124 12,100 10,976 1,124 24,200 21,952 2,248
13,850 11,232 2,618 13,850 11,232 2,618 27,700 22,464 5,236
15,600 14,323 1,277 15,600 14,323 1,277 31,200 28,646 2,554
17,350 15,434 1,916 17,350 15,434 1,916 34,700 30,868 3,832
19,100 16,543 2,557 19,100 16,543 2,557 38,200 33,086 5,114
20,850 17,896 2,954 20,850 17,896 2,954 41,700 35,792 5,908
134,700 117,521 252,221 134,700 117,521 252,221 269,400 235,042 34,358
Marketing Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Marketing Expenses Total Maeketing Expense Budget Total Over / (Under Budget)
1,600 595 1,005 1,600 595 1,005 3,200 1,190 2,010
3,350 1,678 1,672 3,350 1,678 1,672 6,700 3,356 3,344
5,100 4,754 346 5,100 4,754 346 10,200 9,508 692
6,850 6,501 349 6,850 6,501 349 13,700 13,002 698
8,600 7,744 856 8,600 7,744 856 17,200 15,488 1,712
10,350 9,845 505 10,350 9,845 505 20,700 19,690 1,010
12,100 10,976 1,124 12,100 10,976 1,124 24,200 21,952 2,248
13,850 11,232 2,618 13,850 11,232 2,618 27,700 22,464 5,236
15,600 14,323 1,277 15,600 14,323 1,277 31,200 28,646 2,554
17,350 15,434 1,916 17,350 15,434 1,916 34,700 30,868 3,832
19,100 16,543 2,557 19,100 16,543 2,557 38,200 33,086 5,114
20,850 17,896 2,954 20,850 17,896 2,954 41,700 35,792 5,908
134,700 117,521 252,221 134,700 117,521 252,221 269,400 235,042 34,358
Research & Development Expenses Operating Expenses Budget Over / (Under Budget) Payroll Salaries Budget Over / (Under Budget) Total Research & Development Expenses Total R&D Expenses Budget Total Over / (Under Budget)
1,600 595 1,005 1,600 595 1,005 3,200 1,190 2,010
3,350 1,678 1,672 3,350 1,678 1,672 6,700 3,356 3,344
5,100 4,754 346 5,100 4,754 346 10,200 9,508 692
6,850 6,501 349 6,850 6,501 349 13,700 13,002 698
8,600 7,744 856 8,600 7,744 856 17,200 15,488 1,712
10,350 9,845 505 10,350 9,845 505 20,700 19,690 1,010
12,100 10,976 1,124 12,100 10,976 1,124 24,200 21,952 2,248
13,850 11,232 2,618 13,850 11,232 2,618 27,700 22,464 5,236
15,600 14,323 1,277 15,600 14,323 1,277 31,200 28,646 2,554
17,350 15,434 1,916 17,350 15,434 1,916 34,700 30,868 3,832
19,100 16,543 2,557 19,100 16,543 2,557 38,200 33,086 5,114
20,850 17,896 2,954 20,850 17,896 2,954 41,700 35,792 5,908
134,700 117,521 252,221 134,700 117,521 252,221 269,400 235,042 34,358
Total Operating Expenses Total Payroll Salaries Total All Operating Expenses EBIT Interest income (expense) Other income (expense) Total Nonoperating Income (expense)
12,800 6,400 19,200 5,800 10,000 20,000 30,000
26,800 13,400 40,200 (10,100) 10,300 20,600 30,900
40,800 20,400 61,200 (21,600) 10,609 21,218 31,827
54,800 27,400 82,200 (33,100) 10,912 21,824 32,736
68,800 34,400 103,200 (42,800) 11,217 22,433 33,650
82,800 41,400 124,200 (59,620) 11,521 23,042 34,563
96,800 48,400 145,200 (69,440) 11,826 23,651 35,477
110,800 55,400 166,200 (83,927) 12,130 24,260 36,390
124,800 62,400 187,200 (99,767) 12,435 24,869 37,304
138,800 69,400 208,200 (111,767) 12,739 25,478 38,217
152,800 76,400 229,200 (123,767) 13,044 26,087 39,131
166,800 83,400 250,200 (135,767) 13,348 26,696 40,044
1,077,600 538,800 1,616,400 (785,853) 140,079 280,158 420,237
© Copyright, 2006, Jaxworks, All Rights Reserved.
Financial Summary
Financial Summary
300,000 250,000 200,000
150,000
100,000 50,000 (50,000) (100,000) (150,000) (200,000)
J F M A M J J A S O N D
Total Sales
Total All Operating Expenses
EBIT
© Copyright, 2006, Jaxworks, All Rights Reserved.
Financial Summary
300,000 250,000 200,000 150,000 100,000
50,000 -
(50,000) (100,000) (150,000) (200,000)
J
F
M
A
M
J
J
A
S
O
N
D
Total Sales
Total All Operating Expenses
EBIT
© Copyright, 2009, Jaxworks, All Rights Reserved.
© Copyright, 2006, Jaxworks, All Rights Reserved.
Total Sales vs. Total Budget
140,000 120,000
100,000 80,000 60,000 40,000 20,000 J F M A M J J A S O N D
Total Sales
Total Sales Budget
Total Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Sales Product 1
25,000 20,000 15,000 10,000
5,000
J F M A M J J A S O N D
Sales by Product Line 1
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Sales Product 2
12,000 10,000
8,000
6,000 4,000
2,000
J F M A M J J A S O N D
Sales by Product Line 2
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Sales Product 3
25,000
20,000
15,000
10,000
5,000 J F M A M J J A S O N D
(5,000)
Sales by Product Line 3
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Sales Product 4
25,000 20,000 15,000 10,000 5,000 J F M A M J J A S O N D
(5,000)
Sales by Product Line 4
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Sales Product 5
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Sales by Product Line 5
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Sales Product 6
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Sales by Product Line 6
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Total COG vs. Total COG Budget
90,000
80,000
70,000 60,000 50,000
40,000
30,000 20,000
10,000
J F M A M J J A S O N D
Total Cost of Goods Sold
Total COG Budget
Total Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Materials
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Materials
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Labor
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Labor
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Overhead
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Overhead
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Total G&A vs. Total G&A Budget
45,000 40,000 35,000 30,000 25,000 20,000
15,000 10,000 5,000 J F M A M J J A S O N D
Total G&A Expenses
Total G&A Budget
Total Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Operating Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Operating Expenses
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Payroll Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Payroll Salaries
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Total Sales vs. Total Budget
45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 5,000 0
J J J J J J J J J J J J
Total Sales Expenses
Total Sales Expense Budget
Total Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Operating Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Operating Expenses
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Payroll Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Payroll Salaries
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Total Marketing Expenses vs. Total Marketing Expense Budget
45,000
40,000
35,000 30,000
25,000
20,000 15,000 10,000
5,000
0
J F M A M J J A S O N D
Total Marketing Expenses
Total Maeketing Expense Budget
Total Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Operating Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Operating Expenses
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Payroll Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Payroll Salaries
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
© Copyright, 2009, Jaxworks, All Rights Reserved.
Total R&D Expenses vs. Total R&D Expenses Budget
45,000 40,000
35,000
30,000 25,000 20,000
15,000
10,000 5,000
J F M A M J J A S O N D
Total Research & Development Expenses
Total R&D Expenses Budget
Total Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Operating Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Operating Expenses
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Payroll Expenses
25,000 20,000 15,000
10,000 5,000
J F M A M J J A S O N D
Payroll Salaries
Budget
Over / (Under Budget)
© Copyright, 2006, Jaxworks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass documents, that cover a number of financial, accounting and sales functions. These are invalua Also included Free are: - business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books! - comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - Altman Z-Score (covering publicly and privately held firms, and small businesses); - and payroll analysis. If you are involved in financial analysis at any level, or want to learn more about MS Excel and suite this site is invaluable.
JaxWorks Small Business Spreadsheet Factory
spreadsheets, and associated MS Word, PDF and HTML ons. These are invaluable small business tools.
ides are in
y analysis,
about MS Excel and other applications in the Office
sheet Factory
Copyright Notice
© 2009, JaxWorks All rights reserved. Specifications are subject to change without notice.
NeoCalc™ is a registered trademark of Jaxworks. All other brands or products are trademarks or registered trademarks of their respective holders a treated as such. NOTICES REGARDING SOFTWARE, DOCUMENTS AND SERVICES.
IN NO EVENT SHALL JAXWORKS BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSO RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS AC OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILURE TO PROVID OR INFORMATION AVAILABLE FROM THIS PROGRAM.
© Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Copyright Notice
rands or products are trademarks or registered trademarks of their respective holders and should be
SERVICES.
PECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING RMANCE OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILURE TO PROVIDE SERVICES,
© Copyright, 1996-2004, JaxWorks, All Rights Reserved.