The following tables show the budget forecast Excel files for San Francisco, Beijing, and Corporate Headquarters of Fabrikam, Inc. The row definition excerpt that is shown after the Excel files shows the link to the Excel files to report total compensation expenses.
Example for San Francisco
Budget forecast for San Francisco.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
1 |
Fabrikam Works, Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
Budget - San Francisco |
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Total |
5 |
Sales |
202,941 |
207,000 |
211,140 |
215,363 |
219,670 |
224,063 |
228,545 |
233,115 |
237,778 |
242,533 |
247,384 |
252,332 |
2,721,864 |
6 |
Sales Returns |
(3,521) |
(3,591) |
(3,663) |
(3,737) |
(3,811) |
(3,887) |
(3,965) |
(4,045) |
(4,125) |
(4,208) |
(4,292) |
(4,378) |
(47,223) |
7 |
Sales Discounts |
(11,737) |
(11,972) |
(12,211) |
(12,455) |
(12,705) |
(12,959) |
(13,218) |
(13,482) |
(13,752) |
(14,027) |
(14,307) |
(14,593) |
(157,418) |
8 |
Total Sales |
187,683 |
191,437 |
195,265 |
199,171 |
203,154 |
207,217 |
211,362 |
215,589 |
219,901 |
224,299 |
228,785 |
233,360 |
2,517,223 |
9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
Cost of Goods Sold |
116,500 |
118,830 |
121,207 |
123,631 |
126,103 |
128,625 |
131,198 |
133,822 |
136,498 |
139,228 |
142,013 |
144,853 |
1,562,508 |
11 |
Gross Profit |
71,183 |
72,607 |
74,059 |
75,540 |
77,051 |
78,592 |
80,164 |
81,767 |
83,402 |
85,070 |
86,772 |
88,507 |
954,714 |
12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13 |
Salary Expense |
30,910 |
31,528 |
30,000 |
30,000 |
30,000 |
30,000 |
30,000 |
30,000 |
31,000 |
31,000 |
31,000 |
31,000 |
366,438 |
14 |
Commissions Expense |
11,524 |
11,754 |
10,000 |
10,000 |
10,000 |
10,000 |
10,000 |
10,000 |
11,000 |
11,000 |
11,000 |
11,000 |
127,278 |
15 |
Total Compensation |
42,434 |
43,282 |
40,000 |
40,000 |
40,000 |
40,000 |
40,000 |
40,000 |
42,000 |
42,000 |
42,000 |
42,000 |
493,716 |
16 |
|
|
|
|
|
|
|
|
|
|
||||
17 |
Depreciation |
2,500 |
2,550 |
2,601 |
2,653 |
2,706 |
2,760 |
2,815 |
2,872 |
2,929 |
2,988 |
3,047 |
3,108 |
33,529 |
18 |
Office Expense |
1,841 |
1,878 |
1,915 |
1,954 |
1,993 |
2,033 |
2,073 |
2,115 |
2,157 |
2,200 |
2,244 |
2,289 |
24,692 |
19 |
Supplies |
315 |
321 |
328 |
334 |
341 |
348 |
355 |
362 |
369 |
376 |
384 |
392 |
4,225 |
20 |
Maintenance |
620 |
632 |
645 |
658 |
671 |
685 |
698 |
712 |
726 |
741 |
756 |
771 |
8,315 |
21 |
Rent |
4,500 |
4,590 |
4,682 |
4,775 |
4,871 |
4,968 |
5,068 |
5,169 |
5,272 |
5,378 |
5,485 |
5,595 |
60,353 |
22 |
Travel |
4,075 |
4,157 |
4,240 |
4,324 |
4,411 |
4,499 |
4,589 |
4,681 |
4,775 |
4,870 |
4,967 |
5,067 |
54,655 |
23 |
Advertising |
3,359 |
3,426 |
3,495 |
3,565 |
3,636 |
3,709 |
3,783 |
3,858 |
3,936 |
4,014 |
4,095 |
4,176 |
45,052 |
24 |
Total Other G&A |
17,210 |
17,554 |
17,906 |
18,263 |
18,629 |
19,002 |
19,381 |
19,769 |
20,164 |
20,567 |
20,978 |
21,398 |
230,821 |
25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26 |
Before Tax Income |
11,539 |
11,770 |
12,005 |
12,245 |
12,490 |
12,740 |
12,995 |
13,255 |
13,520 |
13,790 |
14,066 |
14,347 |
143,223 |
Example for Beijing
Budget forecast for Beijing.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
1 |
Fabrikam Works, Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
Budget - Beijing |
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Total |
5 |
Sales |
230,008 |
234,608 |
239,300 |
244,086 |
248,968 |
253,947 |
259,026 |
264,207 |
269,491 |
274,881 |
280,378 |
285,986 |
3,084,886 |
6 |
Sales Returns |
(3,850) |
(3,927) |
(4,006) |
(4,086) |
(4,167) |
(4,251) |
(4,336) |
(4,422) |
(4,511) |
(4,601) |
(4,693) |
(4,787) |
(51,637) |
7 |
Sales Discounts |
(12,832) |
(13,089) |
(13,350) |
(13,617) |
(13,890) |
(14,168) |
(14,451) |
(14,740) |
(15,035) |
(15,335) |
(15,642) |
(15,955) |
(172,104) |
8 |
Total Sales |
213,326 |
217,593 |
221,944 |
226,383 |
230,911 |
235,529 |
240,240 |
245,045 |
249,945 |
254,944 |
260,043 |
265,244 |
2,861,147 |
9 |
|
|
|
|
|
|
|
|
|
|
|
|
||
10 |
Cost of Goods Sold |
123,700 |
126,174 |
128,697 |
131,271 |
133,897 |
136,575 |
139,306 |
142,092 |
144,934 |
147,833 |
150,790 |
153,805 |
1,659,075 |
11 |
Gross Profit |
89,626 |
91,419 |
93,247 |
95,112 |
97,014 |
98,954 |
100,934 |
102,953 |
105,011 |
107,111 |
109,253 |
111,439 |
1,202,073 |
12 |
|
|
|
|
|
|
|
|
|
|
|
|
||
13 |
Salary Expense |
35,800 |
36,516 |
35,000 |
35,000 |
35,000 |
35,000 |
35,000 |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
427,316 |
14 |
Commissions Expense |
13,972 |
14,251 |
12,000 |
12,000 |
12,000 |
12,000 |
12,000 |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
153,223 |
15 |
Total Compensation |
49,772 |
50,767 |
47,000 |
47,000 |
47,000 |
47,000 |
47,000 |
49,000 |
49,000 |
49,000 |
49,000 |
49,000 |
580,539 |
16 |
|
|
|
|
|
|
|
|
|
|
|
|
||
17 |
Depreciation |
2,355 |
2,402 |
2,450 |
2,499 |
2,549 |
2,600 |
2,652 |
2,705 |
2,759 |
2,814 |
2,871 |
2,928 |
31,584 |
18 |
Office Expense |
1,782 |
1,818 |
1,854 |
1,891 |
1,929 |
1,967 |
2,007 |
2,047 |
2,088 |
2,130 |
2,172 |
2,216 |
23,901 |
19 |
Supplies |
350 |
357 |
364 |
371 |
379 |
386 |
394 |
402 |
410 |
418 |
427 |
435 |
4,693 |
20 |
Maintenance |
550 |
561 |
572 |
584 |
595 |
607 |
619 |
632 |
644 |
657 |
670 |
684 |
7,375 |
21 |
Rent |
4,675 |
4,769 |
4,864 |
4,961 |
5,060 |
5,162 |
5,265 |
5,370 |
5,478 |
5,587 |
5,699 |
5,813 |
62,703 |
22 |
Travel |
3,700 |
3,774 |
3,849 |
3,926 |
4,005 |
4,085 |
4,167 |
4,250 |
4,335 |
4,422 |
4,510 |
4,600 |
49,623 |
23 |
Advertising |
3,666 |
3,739 |
3,814 |
3,890 |
3,968 |
4,048 |
4,129 |
4,211 |
4,295 |
4,381 |
4,469 |
4,558 |
49,168 |
24 |
Total Other G&A |
17,078 |
17,420 |
17,767 |
18,122 |
18,485 |
18,855 |
19,233 |
19,617 |
20,009 |
20,409 |
20,818 |
21,234 |
229,047 |
25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
26 |
Before Tax Income |
22,776 |
23,231 |
23,696 |
24,170 |
24,653 |
25,146 |
25,649 |
26,162 |
26,686 |
27,219 |
27,764 |
28,320 |
305,472 |
Example for Corporate Headquarters
Budget forecast for Corporate Headquarters.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
1 |
Fabrikam Works, Inc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
Budget - Beijing |
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4 |
|
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
Total |
5 |
Officers' Compensation |
25,000 |
25,250 |
25,503 |
25,758 |
26,015 |
26,275 |
26,538 |
26,803 |
27,071 |
27,342 |
27,616 |
27,892 |
317,063 |
6 |
||||||||||||||
7 |
Other G&A Expense |
2,000 |
2,020 |
2,040 |
2,061 |
2,081 |
2,102 |
2,123 |
2,144 |
2,166 |
2,187 |
2,209 |
2,231 |
25,364 |
8 |
|
|
|
|
|
|
|
|
|
|
|
|
||
9 |
Interest Income |
228 |
230 |
233 |
235 |
237 |
240 |
242 |
244 |
247 |
249 |
252 |
254 |
2,891 |
10 |
Interest Expense |
1,125 |
1,136 |
1,148 |
1,159 |
1,171 |
1,182 |
1,194 |
1,206 |
1,218 |
1,230 |
1,243 |
1,255 |
14,267 |
11 |
Total Other Income/(Expense) |
(897) |
(906) |
(915) |
(924) |
(934) |
(942) |
(952) |
(962) |
(971) |
(981) |
(991) |
(1,001) |
(11,376) |
12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13 |
Net Income Before Tax |
(27,897) |
(28,176) |
(28,458) |
(28,742) |
(29,030) |
(29,320) |
(29,613) |
(29,909) |
(30,208) |
(30,511) |
(30,816) |
(31,124) |
(353,804) |
Example of worksheet links to Excel files
The following table shows example rows from the row definition that links the San Francisco, Beijing, and Corporate Headquarters external worksheet files.
Description |
Normal Balance |
Link to Financial Dimensions |
Link to External Worksheet Req Link |
Link to External Worksheet HQ Link |
---|---|---|---|---|
Gross Sales |
C |
(410?-4109) |
A5/CPO |
|
Returns |
C |
4110 |
A6/CPO |
|
Discounts |
C |
4250 |
A7/CPO |
|
Compensation Expense |
|
5000+(5050)+(5400) |
A15/CPO |
A5/CPO |
In this row definition, the Link to External Worksheet Req Linkcolumn links with the San Francisco and Beijing external worksheet files, and the Link to External Worksheet HQ Linkcolumn links with the Corporate Headquarters external worksheet file. In the previous tables, row 14 (the Compensation Expenserow) in the row definition links to row 15 (the Total Comprow) in the San Francisco and Beijing external worksheet files and row 5 (the Officers' Comprow) in the Corporate Headquarters external worksheet file. The San Francisco and Beijing spreadsheets each require only one link, because they have identical external worksheet files. The Corporate Headquarters spreadsheet requires a separate Linkcolumn because it has a different external worksheet file.