Business Plan – Final
marketing budget
| jan | feb | march | april | may | june | july | aug | sept | oct | nov | Dec | TOTAL | ||
| Advertising Agencies | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 80 | 80 | 80 | ||
| Social Media Specialists | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 40 | 40 | 40 | 570 | |
| SEO Specialist | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 120 | |
| Graphic/Web Design | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 300 | |||
| Brochures/Leaflets/Flyers | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 180 | |
| Signs/Billboards | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | |
| Merchandising Displays | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 105 | ||||||
| Media Advertising | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 200 | |||
| Print (newspaper, etc.) | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 165 | ||
| Website | 0 | |||||||||||||
| Development/Programming | 300 | 300 | ||||||||||||
| Maintenance and Hosting | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | |
| total | 640 | 355 | 355 | 340 | 340 | 355 | 355 | 355 | 355 | 310 | 260 | 260 | 4280 |
Sheet1
IncSt
| Income Statements Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies. | 2015 | 2016 | 2017 | 2018 | 2019 | |||||||||||||||||||||||||||||||||||||
| January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | TOTAL | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | TOTAL | |||||||
| INCOME | ||||||||||||||||||||||||||||||||||||||||||
| Gross Sales | $2,000 | $2,400 | $2,880 | $3,456 | $4,147 | $4,977 | $5,972 | $7,166 | $8,600 | $10,320 | $12,383 | $14,860 | $79,161 | $18,724 | $22,468.57 | $26,962 | $32,355 | $38,826 | $46,591 | $55,909 | $67,091 | $80,509 | $96,611 | $115,933 | $139,119 | $741,098 | $638,058 | $1,102,564 | $1,905,230 | $3,292,237 | $6,938,088 | $5,973,435 | $10,322,095 | $17,836,581 | $30,821,612 | $64,953,723 | $608,090,618 | |||||
| (Commissions) | $30 | $36 | $43 | $52 | $62 | $75 | $90 | $107 | $129 | $155 | $186 | $223 | $1,187 | $281 | $337.03 | $404 | $485 | $582 | $699 | $839 | $1,006 | $1,208 | $1,449 | $1,739 | $2,087 | $11,116 | $9,571 | $16,538 | $28,578 | $49,384 | $104,071 | $89,602 | $154,831 | $267,549 | $462,324 | $974,306 | $9,121,359 | |||||
| (Returns and allowances) | $60 | $72 | $86 | $104 | $124 | $149 | $179 | $215 | $258 | $310 | $372 | $446 | $2,375 | $562 | $674.06 | $809 | $971 | $1,165 | $1,398 | $1,677 | $2,013 | $2,415 | $2,898 | $3,478 | $4,174 | $22,233 | $19,142 | $33,077 | $57,157 | $98,767 | $208,143 | $179,203 | $309,663 | $535,097 | $924,648 | $1,948,612 | $18,242,719 | |||||
| Net Sales | $1,910 | $2,292 | $2,750 | $3,300 | $3,961 | $4,753 | $5,703 | $6,844 | $8,213 | $9,855 | $11,826 | $14,191 | $75,599 | $17,881 | $21,457.49 | $25,749 | $30,899 | $37,079 | $44,494 | $53,393 | $64,072 | $76,886 | $92,263 | $110,716 | $132,859 | $707,748 | $609,345 | $1,052,948 | $1,819,494 | $3,144,086 | $6,625,874 | $5,704,630 | $9,857,601 | $17,033,935 | $29,434,639 | $62,030,806 | $580,726,540 | |||||
| (Cost of Goods) | $980 | $1,176 | $1,411 | $1,693 | $2,032 | $2,439 | $2,926 | $3,512 | $4,214 | $5,057 | $6,068 | $7,281 | $38,789 | $9,175 | $11,009.60 | $13,212 | $15,854 | $19,025 | $22,830 | $27,395 | $32,874 | $39,449 | $47,339 | $56,807 | $68,169 | $363,138 | $312,648 | $540,256 | $933,563 | $1,613,196 | $3,399,663 | $2,926,983 | $5,057,827 | $8,739,925 | $15,102,590 | $31,827,324 | $297,964,403 | |||||
| GROSS PROFIT | $930 | $1,116 | $1,339 | $1,607 | $1,928 | $2,314 | $2,777 | $3,332 | $3,999 | $4,799 | $5,758 | $6,910 | $36,810 | $8,707 | $10,447.89 | $12,537 | $15,045 | $18,054 | $21,665 | $25,998 | $31,197 | $37,437 | $44,924 | $53,909 | $64,691 | $344,610 | $296,697 | $512,692 | $885,932 | $1,530,890 | $3,226,211 | $2,777,647 | $4,799,774 | $8,294,010 | $14,332,050 | $30,203,481 | $282,762,137 | |||||
| EXPENSES - General and Administrative | ||||||||||||||||||||||||||||||||||||||||||
| Salaries and wages | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $1,350 | $16,200 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $1,384 | $16,605 | $4,255 | $4,255 | $4,255 | $4,255 | $17,020 | $4,361 | $4,361 | $4,361 | $4,361 | $17,446 | $17,882 | |||||
| Employee benefits | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $1,500 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $128 | $1,530 | $390 | $390 | $390 | $390 | $1,561 | $398 | $398 | $398 | $398 | $1,592 | $1,624 | |||||
| Payroll taxes | $203 | $203 | $203 | $203 | $203 | $203 | $203 | $203 | $203 | $203 | $203 | $203 | $2,430 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $208 | $2,491 | $638 | $638 | $638 | $638 | $2,553 | $654 | $654 | $654 | $654 | $2,617 | $2,682 | |||||
| Professional services | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Marketing and advertising | $640 | $355 | $355 | $340 | $340 | $355 | $355 | $355 | $355 | $310 | $260 | $260 | $4,280 | $260 | $260 | $260 | $260 | $260 | $260 | $260 | $260 | $260 | $260 | $260 | $260 | $3,120 | $780 | $780 | $780 | $780 | $3,120 | $780 | $780 | $780 | $780 | $3,120 | $3,120 | |||||
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Equipment rental | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Maintenance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Telephone service | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Office supplies | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Postage and shipping | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Travel | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Entertainment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Interest on loans | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| Other (change title here) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Other (change title here) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| TOTAL EXPENSES | $2,318 | $2,033 | $2,033 | $2,018 | $2,018 | $2,033 | $2,033 | $2,033 | $2,033 | $1,988 | $1,938 | $1,938 | $24,410 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $23,746 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| Net income before taxes | -$1,388 | -$917 | -$693 | -$410 | -$89 | $282 | $744 | $1,300 | $1,966 | $2,811 | $3,821 | $4,972 | $12,400 | $6,728 | $8,469 | $10,559 | $13,066 | $16,075 | $19,686 | $24,019 | $29,218 | $35,458 | $42,945 | $51,930 | $62,712 | $320,865 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| Provision for taxes on income | $0 | $0 | $0 | $0 | $0 | $42 | $112 | $195 | $295 | $422 | $573 | $746 | $1,860 | $1,009 | $1,270 | $1,584 | $1,960 | $2,411 | $2,953 | $3,603 | $4,383 | $5,319 | $6,442 | $7,789 | $9,407 | $48,130 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |||||
| NET PROFIT | -$1,388 | -$917 | -$693 | -$410 | -$89 | $239 | $633 | $1,105 | $1,671 | $2,389 | $3,248 | $4,227 | $10,540 | $5,719 | $7,199 | $8,975 | $11,106 | $13,664 | $16,733 | $20,416 | $24,836 | $30,139 | $36,503 | $44,140 | $53,305 | $272,735 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
Income Statements
CshFlw
| Cash Flow Author: For information about this worksheet, see "Cash-Flow Projections" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies. | 2015 | 2016 | 2017 | 2018 | 2019 | ||||||||||||||||||||||||||||||||||||||
| January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | TOTAL | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | TOTAL | ||||||||
| CASH RECEIPTS | |||||||||||||||||||||||||||||||||||||||||||
| Income from Sales | |||||||||||||||||||||||||||||||||||||||||||
| Cash Sales | $1,900 | $2,280 | $2,736 | $3,283 | $3,940 | $4,728 | $5,673 | $6,808 | $8,170 | $9,804 | $11,764 | $14,117 | $75,203 | $17,788 | $21,345 | $25,614 | $30,737 | $36,884 | $44,261 | $53,114 | $63,736 | $76,484 | $91,780 | $110,136 | $132,164 | $704,043 | $606,155 | $1,047,435 | $1,809,968 | $3,127,625 | $6,591,184 | $5,674,763 | $9,805,991 | $16,944,752 | $29,280,531 | $61,706,037 | $577,686,087 | ||||||
| Collections | $67 | $113 | $136 | $163 | $196 | $235 | $282 | $338 | $406 | $487 | $585 | $702 | $3,710 | $872 | $1,061 | $1,273 | $1,528 | $1,833 | $2,200 | $2,640 | $3,168 | $3,802 | $4,562 | $5,475 | $6,570 | $34,984 | $30,677 | $52,548 | $90,802 | $156,906 | $330,933 | $283,776 | $491,946 | $850,082 | $1,468,942 | $3,094,745 | $29,731,192 | ||||||
| Total Cash from Sales | $1,967 | $2,393 | $2,872 | $3,446 | $4,136 | $4,963 | $5,955 | $7,146 | $8,576 | $10,291 | $12,349 | $14,819 | $78,913 | $18,659 | $22,406 | $26,887 | $32,265 | $38,718 | $46,461 | $55,754 | $66,904 | $80,285 | $96,342 | $115,611 | $138,733 | $739,027 | $636,831 | $1,099,983 | $1,900,771 | $3,284,531 | $6,922,116 | $5,958,539 | $10,297,936 | $17,794,834 | $30,749,473 | $64,800,782 | $607,417,279 | ||||||
| Income from Financing | |||||||||||||||||||||||||||||||||||||||||||
| Interest Income | $8 Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. | $8 | $9 | $10 | $11 | $14 | $17 | $21 | $26 | $32 | $41 | $51 | $248 | $64 | $80 | $100 | $124 | $154 | $189 | $232 | $284 | $346 | $421 | $512 | $621 | $3,129 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| Loan Proceeds | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Equity Capital Investments | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Total Cash from Financing | $8 | $8 | $9 | $10 | $11 | $14 | $17 | $21 | $26 | $32 | $41 | $51 | $248 | $64 | $80 | $100 | $124 | $154 | $189 | $232 | $284 | $346 | $421 | $512 | $621 | $3,129 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| Other Cash Receipts | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| TOTAL CASH RECEIPTS | $1,975 | $2,402 | $2,881 | $3,456 | $4,147 | $4,977 | $5,972 | $7,167 | $8,602 | $10,323 | $12,390 | $14,870 | $79,161 | $18,724 | $22,487 | $26,988 | $32,389 | $38,871 | $46,650 | $55,986 | $67,188 | $80,632 | $96,764 | $116,123 | $139,354 | $742,156 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| CASH DISBURSEMENTS | |||||||||||||||||||||||||||||||||||||||||||
| Inventory | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Operating Expenses | $2,318 | $2,033 | $2,033 | $2,018 | $2,018 | $2,033 | $2,033 | $2,033 | $2,033 | $1,988 | $1,938 | $1,938 | $24,410 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $1,979 | $23,746 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| Commissions/Returns & Allowances | $90 | $108 | $130 | $156 | $187 | $224 | $269 | $322 | $387 | $464 | $557 | $669 | $3,562 | $843 | $1,011 | $1,213 | $1,456 | $1,747 | $2,097 | $2,516 | $3,019 | $3,623 | $4,347 | $5,217 | $6,260 | $33,349 | $28,713 | $49,615 | $85,735 | $148,151 | $312,214 | $268,805 | $464,494 | $802,646 | $1,386,973 | $2,922,918 | $27,364,078 | ||||||
| Capital Purchases | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Loan Payments | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Income Tax Payments | $0 Author: Note that on your Income Statements, we've generated an estimate for income taxes. This line on the Cash Flow statement is where you should reflect the actual payments you intend to make on a regular basis (probably quarterly). |
Author: This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Investor Dividend Payments | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Owner's Draw | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| TOTAL CASH DISBURSEMENTS | $2,408 | $2,141 | $2,162 | $2,173 | $2,204 | $2,256 | $2,301 | $2,355 | $2,419 | $2,452 | $2,495 | $2,606 | $27,972 | $2,821 | $2,990 | $3,192 | $3,435 | $3,726 | $4,075 | $4,495 | $4,998 | $5,602 | $6,326 | $7,196 | $8,239 | $57,095 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| NET CASH FLOW | -$433 | $261 | $719 | $1,283 | $1,943 | $2,720 | $3,671 | $4,812 | $6,182 | $7,872 | $9,895 | $12,264 | $51,189 | $15,902 | $19,497 | $23,796 | $28,954 | $35,145 | $42,575 | $51,491 | $62,190 | $75,030 | $90,438 | $108,927 | $131,115 | $685,060 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||
| Opening Cash Balance | $10,000 | $9,567 | $9,828 | $10,547 | $11,830 | $13,773 | $16,493 | $20,164 | $24,976 | $31,159 | $39,030 | $48,925 | $61,189 | $77,091 | $96,588 | $120,383 | $149,338 | $184,483 | $227,058 | $278,549 | $340,739 | $415,769 | $506,207 | $615,134 | $746,249 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||||
| Cash Receipts | $1,975 | $2,402 | $2,881 | $3,456 | $4,147 | $4,977 | $5,972 | $7,167 | $8,602 | $10,323 | $12,390 | $14,870 | $18,724 | $22,487 | $26,988 | $32,389 | $38,871 | $46,650 | $55,986 | $67,188 | $80,632 | $96,764 | $116,123 | $139,354 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||||
| Cash Disbursements | $2,408 | $2,141 | $2,162 | $2,173 | $2,204 | $2,256 | $2,301 | $2,355 | $2,419 | $2,452 | $2,495 | $2,606 | $2,821 | $2,990 | $3,192 | $3,435 | $3,726 | $4,075 | $4,495 | $4,998 | $5,602 | $6,326 | $7,196 | $8,239 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ||||||||||
| ENDING CASH BALANCE | $9,567 | $9,828 | $10,547 | $11,830 | $13,773 | $16,493 | $20,164 | $24,976 | $31,159 | $39,030 | $48,925 | $61,189 | $61,189 | $77,091 | $96,588 | $120,383 | $149,338 | $184,483 | $227,058 | $278,549 | $340,739 | $415,769 | $506,207 | $615,134 | $746,249 | $746,249 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
Cash Flow Statements
BalSht
| Balance Sheet Author: For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies. | Balance Sheet | Balance Sheet | Balance Sheet | Balance Sheet | Balance Sheet | Balance Sheet | Balance Sheet | |||||||||||||||||||||||||||||||||||||||
| Happy Day wines | Happy Day wines | Happy Day wines | Happy Day wines | Happy Day wines | Happy Day wines | Happy Day wines | Happy Day wines | |||||||||||||||||||||||||||||||||||||||
| First Quarter | Second Quarter | Third Quarter | Fourth Quarter | 2016 | 2017 | 2018 | 2019 | |||||||||||||||||||||||||||||||||||||||
| 2015 | 2015 | 2015 | 2015 | |||||||||||||||||||||||||||||||||||||||||||
| ASSETS | ASSETS | ASSETS | ASSETS | ASSETS | ASSETS | ASSETS | ASSETS | |||||||||||||||||||||||||||||||||||||||
| Current Assets | Current Assets | Current Assets | Current Assets | Current Assets | Current Assets | Current Assets | Current Assets | |||||||||||||||||||||||||||||||||||||||
| Cash | $10,547 | Cash | $16,493 | Cash | $31,159 | Cash | $61,189 | Cash | $746,249 | Cash | ERROR:#REF! | Cash | ERROR:#REF! | Cash | ERROR:#REF! | |||||||||||||||||||||||||||||||
| Accounts Receivable | $48 | Accounts Receivable | $83 | Accounts Receivable | $143 | Accounts Receivable | $248 | Accounts Receivable | $2,319 | Accounts Receivable | $18,290 | Accounts Receivable | $171,231 | Accounts Receivable | $844,570 | |||||||||||||||||||||||||||||||
| Inventory | -$3,567 | Inventory | -$9,731 | Inventory | -$20,383 | Inventory | -$38,789 | Inventory | -$401,927 | Inventory | -$3,801,590 | Inventory | -$35,628,914 | Inventory | -$333,593,317 | |||||||||||||||||||||||||||||||
| Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | |||||||||||||||||||||||||||||||
| Total Current Assets | $7,028 | Total Current Assets | $6,845 | Total Current Assets | $10,919 | Total Current Assets | $22,648 | Total Current Assets | $346,641 | Total Current Assets | ERROR:#REF! | Total Current Assets | ERROR:#REF! | Total Current Assets | ERROR:#REF! | |||||||||||||||||||||||||||||||
| Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | |||||||||||||||||||||||||||||||||||||||
| Land | $0 | Land | $0 | Land | $0 | Land | $0 | Land | $0 | Land | $0 | Land | $0 | Land | $0 | |||||||||||||||||||||||||||||||
| Facilities | $0 | Facilities | $0 | Facilities | $0 | Facilities | $0 | Facilities | $0 | Facilities | $0 | Facilities | $0 | Facilities | $0 | |||||||||||||||||||||||||||||||
| Equipment | $0 | Equipment | $0 | Equipment | $0 | Equipment | $0 | Equipment | $0 | Equipment | $0 | Equipment | $0 | Equipment | $0 | |||||||||||||||||||||||||||||||
| Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | Computers & Telecommunications | $0 | |||||||||||||||||||||||||||||||
| (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | (Less Accumlated Depreciation) | $0 | |||||||||||||||||||||||||||||||
| Total Fixed Assets | $0 | Total Fixed Assets | $0 | Total Fixed Assets | $0 | Total Fixed Assets | $0 | Total Fixed Assets | $0 | Total Fixed Assets | $0 | Total Fixed Assets | $0 | Total Fixed Assets | $0 | |||||||||||||||||||||||||||||||
| Other Assets | $0 | Other Assets | $0 | Other Assets | $0 | Other Assets | $0 | Other Assets | $0 | Other Assets | $0 | Other Assets | $0 | Other Assets | $0 | |||||||||||||||||||||||||||||||
| TOTAL ASSETS | $7,028 | TOTAL ASSETS | $6,845 | TOTAL ASSETS | $10,919 | TOTAL ASSETS | $22,648 | TOTAL ASSETS | $346,641 | TOTAL ASSETS | ERROR:#REF! | TOTAL ASSETS | ERROR:#REF! | TOTAL ASSETS | ERROR:#REF! | |||||||||||||||||||||||||||||||
| LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | |||||||||||||||||||||||||||||||||||||||
| Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | |||||||||||||||||||||||||||||||||||||||
| Short-Term Notes Payable | $0 Sure Product Consulting: Short-Term Notes Payable: loan payments to be made within one year | Short-Term Notes Payable | $0 | Short-Term Notes Payable | $0 | Short-Term Notes Payable | $0 | Short-Term Notes Payable | $0 | Short-Term Notes Payable | $0 | Short-Term Notes Payable | $0 | Short-Term Notes Payable | $0 | |||||||||||||||||||||||||||||||
| Income Taxes Due | $0 Author: If you see a number here, it reflects the difference between the projected income taxes owed (as calculated on your Income Statements) and what you've said you will actually pay (as entered on your Cash Flow statements). | Income Taxes Due | $42 | Income Taxes Due | $644 | Income Taxes Due | $1,860 | Income Taxes Due | $49,990 | Income Taxes Due | ERROR:#REF! | Income Taxes Due | ERROR:#REF! | Income Taxes Due | ERROR:#REF! | |||||||||||||||||||||||||||||||
| Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | |||||||||||||||||||||||||||||||
| Total Current Liabilities | $0 | Total Current Liabilities | $42 | Total Current Liabilities | $644 | Total Current Liabilities | $1,860 | Total Current Liabilities | $49,990 | Total Current Liabilities | ERROR:#REF! | Total Current Liabilities | ERROR:#REF! | Total Current Liabilities | ERROR:#REF! | |||||||||||||||||||||||||||||||
| Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | |||||||||||||||||||||||||||||||||||||||
| Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | Long-Term Notes Payable | $0 | |||||||||||||||||||||||||||||||
| Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | Other Long-Term Liabilities | $0 | |||||||||||||||||||||||||||||||
| Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | Total Long-Term Liabilities | $0 | |||||||||||||||||||||||||||||||
| NET WORTH | NET WORTH | NET WORTH | NET WORTH | NET WORTH | NET WORTH | NET WORTH | NET WORTH | |||||||||||||||||||||||||||||||||||||||
| Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | Paid-In Capital | $10,000 | |||||||||||||||||||||||||||||||
| Retained Earnings | -$2,972 | Retained Earnings | -$3,197 | Retained Earnings | $275 | Retained Earnings | $10,788 | Retained Earnings | $286,651 | Retained Earnings | ERROR:#REF! | Retained Earnings | ERROR:#REF! | Retained Earnings | ERROR:#REF! | |||||||||||||||||||||||||||||||
| Total Net Worth | $7,028 | Total Net Worth | $6,803 | Total Net Worth | $10,275 | Total Net Worth | $20,788 | Total Net Worth | $296,651 | Total Net Worth | ERROR:#REF! | Total Net Worth | ERROR:#REF! | Total Net Worth | ERROR:#REF! | |||||||||||||||||||||||||||||||
| TOTAL LIABILITIES AND NET WORTH | $7,028 | TOTAL LIABILITIES AND NET WORTH | $6,845 | TOTAL LIABILITIES AND NET WORTH | $10,919 | TOTAL LIABILITIES AND NET WORTH | $22,648 | TOTAL LIABILITIES AND NET WORTH | $346,641 | TOTAL LIABILITIES AND NET WORTH | ERROR:#REF! | TOTAL LIABILITIES AND NET WORTH | ERROR:#REF! | TOTAL LIABILITIES AND NET WORTH | ERROR:#REF! | |||||||||||||||||||||||||||||||
Balance Sheet