Assignment 5: Business Plan – Final
zhalink.ravenell
budgetexcel.xlsxMktbudj
| Marketing Budget | 2018 | ||||||||||||
| January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | |
| Professional Assistance | |||||||||||||
| Marketing/PR Consultants | $40 | $30 | $40 | $35 | $40 | $30 | $40 | $45 | $40 | $50 | $40 | $60 | $490 |
| Advertising Agencies | $20 | $30 | $20 | $30 | $20 | $25 | $20 | $25 | $20 | $30 | $20 | $20 | $280 |
| Social Media Specialists | $30 | $50 | $40 | $50 | $60 | $50 | $50 | $40 | $50 | $45 | $50 | $50 | $565 |
| SEO Specialist | $100 | $80 | $100 | $100 | $95 | $100 | $80 | $100 | $70 | $100 | $100 | $100 | $1,125 |
| Graphic/Web Design | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $48 | $576 |
| Brochures/Leaflets/Flyers | $110 | $115 | $110 | $120 | $150 | $100 | $110 | $120 | $115 | $110 | $120 | $110 | $1,390 |
| Signs/Billboards | $160 | $140 | $160 | $135 | $160 | $140 | $160 | $150 | $160 | $150 | $160 | $160 | $1,835 |
| Merchandising Displays | $29 | $27 | $29 | $25 | $29 | $29 | $30 | $29 | $29 | $29 | $29 | $29 | $343 |
| Sampling/Premiums | $10 | $15 | $15 | $10 | $15 | $15 | $10 | $10 | $15 | $10 | $20 | $10 | $155 |
| Media Advertising | |||||||||||||
| Print (newspaper, etc.) | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $360 |
| Television and Radio | $120 | $130 | $125 | $120 | $140 | $135 | $100 | $110 | $150 | $130 | $125 | $120 | $1,505 |
| Online | $200 | $150 | $160 | $200 | $170 | $200 | $200 | $180 | $170 | $200 | $190 | $200 | $2,220 |
| Other Media | $100 | $80 | $60 | $100 | $75 | $80 | $100 | $100 | $90 | $100 | $100 | $100 | $1,085 |
| Phone Directories | $80 | $100 | $85 | $100 | $90 | $75 | $100 | $90 | $90 | $100 | $80 | $100 | $1,090 |
| Advertising Specialties | $150 | $140 | $150 | $160 | $160 | $155 | $160 | $170 | $165 | $150 | $160 | $160 | $1,880 |
| Direct Mail | $35 | $25 | $20 | $25 | $15 | $20 | $30 | $20 | $25 | $20 | $30 | $20 | $285 |
| Website | |||||||||||||
| Development/Programming | $80 | $75 | $85 | $80 | $75 | $70 | $85 | $90 | $90 | $100 | $90 | $120 | $1,040 |
| Maintenance and Hosting | $120 | $125 | $130 | $130 | $125 | $123 | $125 | $120 | $140 | $130 | $130 | $140 | $1,538 |
| Trade Shows | |||||||||||||
| Fees and Setup | $45 | $25 | $15 | $15 | $30 | $15 | $15 | $10 | $10 | $20 | $10 | $15 | $225 |
| Travel/Shipping | $39 | $39 | $39 | $39 | $39 | $39 | $39 | $39 | $39 | $39 | $39 | $39 | $468 |
| Exhibits/Signs | $100 | $80 | $100 | $100 | $95 | $100 | $80 | $100 | $70 | $100 | $100 | $100 | $1,125 |
| Public Relations/Materials | $80 | $100 | $85 | $100 | $90 | $75 | $100 | $90 | $90 | $100 | $80 | $100 | $1,090 |
| Informal Marketing / Networking | |||||||||||||
| Memberships/Meetings | $35 | $25 | $20 | $25 | $15 | $20 | $30 | $20 | $25 | $20 | $30 | $20 | $285 |
| Entertainment | $200 | $150 | $160 | $200 | $170 | $200 | $200 | $180 | $170 | $200 | $190 | $200 | $2,220 |
| Other | $120 | $130 | $125 | $120 | $140 | $135 | $100 | $110 | $150 | $130 | $125 | $120 | $1,505 |
| GRAND TOTAL COSTS | $2,081 | $1,939 | $1,951 | $2,097 | $2,076 | $2,009 | $2,042 | $2,026 | $2,051 | $2,141 | $2,096 | $2,171 | $24,680 |
CshFlw
| Cash Flow | 2018 | ||||||||||||
| January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | |
| CASH RECEIPTS | |||||||||||||
| Income from Sales | |||||||||||||
| Cash Sales | $1,697,835 | $1,731,792 | $1,766,428 | $1,801,756 | $1,837,791 | $1,874,547 | $1,912,038 | $1,950,279 | $1,989,284 | $2,029,070 | $2,069,651 | $2,111,044 | $22,771,515 |
| Collections | $0 | $565,945 | $577,264 | $588,809 | $600,585 | $612,597 | $624,849 | $637,346 | $650,093 | $663,095 | $676,357 | $689,884 | $6,886,824 |
| Total Cash from Sales | $1,697,835 | $2,297,737 | $2,343,691 | $2,390,565 | $2,438,377 | $2,487,144 | $2,536,887 | $2,587,625 | $2,639,377 | $2,692,165 | $2,746,008 | $2,800,928 | $29,658,339 |
| Income from Financing | |||||||||||||
| Interest Income | $11,121 | $11,350 | $11,885 | $11,181 | $10,485 | $13,965 | $13,291 | $12,626 | $11,970 | $11,325 | $10,690 | $10,065 | $139,955 |
| Loan Proceeds | $16,500,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $16,500,000 |
| Equity Capital Investments | $1,140,000 | $1,500,000 | $0 | $0 | $5,000,000 | $0 | $0 | $0 | $0 | $0 | $0 | $2,000,000 | $9,640,000 |
| Total Cash from Financing | $17,651,121 | $1,511,350 | $11,885 | $11,181 | $5,010,485 | $13,965 | $13,291 | $12,626 | $11,970 | $11,325 | $10,690 | $2,010,065 | $26,279,955 |
| Other Cash Receipts | $3,000 | $3,500 | $250 | $500 | $1,000 | $1,300 | $450 | $1,200 | $400 | $1,300 | $1,200 | $1,300 | $15,400 |
| TOTAL CASH RECEIPTS | $19,351,956 | $3,812,587 | $2,355,827 | $2,402,246 | $7,449,862 | $2,502,409 | $2,550,628 | $2,601,451 | $2,651,748 | $2,704,790 | $2,757,898 | $4,812,293 | $55,953,694 |
| CASH DISBURSEMENTS | |||||||||||||
| Inventory | $1,486,445 | $1,516,174 | $1,546,497 | $1,577,427 | $1,608,976 | $1,641,155 | $1,673,978 | $1,707,458 | $1,741,607 | $1,776,439 | $1,811,968 | $1,848,208 | $19,936,334 |
| Operating Expenses | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $233,480 | $2,801,760 |
| Commissions/Returns & Allowances | $237,697 | $242,451 | $247,300 | $252,246 | $257,291 | $262,437 | $267,685 | $273,039 | $278,500 | $284,070 | $289,751 | $295,546 | $3,188,012 |
| Capital Purchases | $1,717,048 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,717,048 |
| Loan Payments | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $555,616 | $6,667,393 |
| Income Tax Payments | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $1,680,000 |
| Investor Dividend Payments | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $1,080,000 |
| Owner's Draw | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $400,000 | $4,800,000 |
| TOTAL CASH DISBURSEMENTS | $4,860,286 | $3,177,721 | $3,212,893 | $3,248,769 | $3,285,363 | $3,322,688 | $3,360,760 | $3,399,593 | $3,439,203 | $3,479,605 | $3,520,815 | $3,562,850 | $41,870,547 |
| NET CASH FLOW | $14,491,670 | $634,866 | -$857,066 | -$846,523 | $4,164,499 | -$820,279 | -$810,132 | -$798,142 | -$787,456 | -$774,815 | -$762,917 | $1,249,443 | $14,083,147 |
| Opening Cash Balance | $5,000 | $14,496,670 | $15,131,536 | $14,274,470 | $13,427,946 | $17,592,445 | $16,772,166 | $15,962,034 | $15,163,892 | $14,376,436 | $13,601,621 | $12,838,703 | |
| Cash Receipts | $19,351,956 | $3,812,587 | $2,355,827 | $2,402,246 | $7,449,862 | $2,502,409 | $2,550,628 | $2,601,451 | $2,651,748 | $2,704,790 | $2,757,898 | $4,812,293 | |
| Cash Disbursements | $4,860,286 | $3,177,721 | $3,212,893 | $3,248,769 | $3,285,363 | $3,322,688 | $3,360,760 | $3,399,593 | $3,439,203 | $3,479,605 | $3,520,815 | $3,562,850 | |
| ENDING CASH BALANCE | $14,496,670 | $15,131,536 | $14,274,470 | $13,427,946 | $17,592,445 | $16,772,166 | $15,962,034 | $15,163,892 | $14,376,436 | $13,601,621 | $12,838,703 | $14,088,147 | $14,088,147 |
IncSt
| Income Statements Author: For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies. | 2013 | ||||||||||||
| January | February | March | April | May | June | July | August | September | October | November | December | TOTAL | |
| INCOME | |||||||||||||
| Gross Sales | $2,263,780 | $2,309,056 | $2,355,237 | $2,402,341 | $2,450,388 | $2,499,396 | $2,549,384 | $2,600,372 | $2,652,379 | $2,705,427 | $2,759,535 | $2,814,726 | $30,362,020 |
| (Commissions) | $169,784 | $173,179 | $176,643 | $180,176 | $183,779 | $187,455 | $191,204 | $195,028 | $198,928 | $202,907 | $206,965 | $211,104 | $2,277,152 |
| (Returns and allowances) | $67,913 | $69,272 | $70,657 | $72,070 | $73,512 | $74,982 | $76,482 | $78,011 | $79,571 | $81,163 | $82,786 | $84,442 | $910,861 |
| Net Sales | $2,026,083 | $2,066,605 | $2,107,937 | $2,150,096 | $2,193,098 | $2,236,959 | $2,281,699 | $2,327,333 | $2,373,879 | $2,421,357 | $2,469,784 | $2,519,180 | $27,174,008 |
| (Cost of Goods) | $1,131,890 | $1,154,528 | $1,177,618 | $1,201,171 | $1,225,194 | $1,249,698 | $1,274,692 | $1,300,186 | $1,326,190 | $1,352,713 | $1,379,768 | $1,407,363 | $15,181,010 |
| GROSS PROFIT | $894,193 | $912,077 | $930,319 | $948,925 | $967,903 | $987,261 | $1,007,007 | $1,027,147 | $1,047,690 | $1,068,644 | $1,090,016 | $1,111,817 | $11,992,998 |
| EXPENSES - General and Administrative | |||||||||||||
| Salaries and wages | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $49,700 | $596,400 |
| Employee benefits | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $135,777 | $1,629,320 |
| Payroll taxes | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $7,455 | $89,460 |
| Professional services | $673 | $673 | $673 | $673 | $673 | $673 | $673 | $673 | $673 | $673 | $673 | $673 | $8,080 |
| Marketing and advertising | $2,081 | $1,939 | $1,951 | $2,097 | $2,076 | $2,009 | $2,042 | $2,026 | $2,051 | $2,141 | $2,096 | $2,171 | $24,680 |
| Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
| Equipment rental | $500 | $2,500 | $1,000 | $2,500 | $2,500 | $2,500 | $3,000 | $3,500 | $2,500 | $2,500 | $3,000 | $4,000 | $30,000 |
| Maintenance | $1,000 | $1,500 | $200 | $1,000 | $1,500 | $1,000 | $1,500 | $1,000 | $2,500 | $1,000 | $1,200 | $300 | $13,700 |
| Depreciation | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $16,186 | $194,237 |
| Insurance | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $1,020 | $12,240 |
| Telephone service | $500 | $550 | $600 | $500 | $650 | $500 | $550 | $300 | $450 | $400 | $600 | $700 | $6,300 |
| Utilities | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $2,300 | $27,600 |
| Office supplies | $500 | $500 | $200 | $500 | $600 | $500 | $700 | $750 | $650 | $500 | $450 | $500 | $6,350 |
| Postage and shipping | $7,800 | $6,500 | $6,750 | $7,200 | $7,800 | $7,000 | $7,800 | $8,000 | $6,800 | $7,800 | $7,500 | $7,800 | $88,750 |
| Travel | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $4,600 | $55,200 |
| Entertainment | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $15,500 | $186,000 |
| Interest on loans | $140,417 | $136,710 | $132,969 | $129,195 | $125,387 | $121,545 | $117,668 | $113,756 | $109,809 | $105,826 | $101,807 | $97,753 | $1,432,843 |
| TOTAL EXPENSES | $388,009 | $385,410 | $378,882 | $378,204 | $375,725 | $370,265 | $368,471 | $364,544 | $359,971 | $355,379 | $351,865 | $348,435 | $4,425,160 |
| Net income before taxes | $504,110 | $525,701 | $547,683 | $570,063 | $592,850 | $616,050 | $639,672 | $663,724 | $688,214 | $713,151 | $738,542 | $764,398 | $7,564,158 |
| Provision for taxes on income | $126,028 | $131,425 | $136,921 | $142,516 | $148,212 | $154,012 | $159,918 | $165,931 | $172,054 | $178,288 | $184,636 | $191,099 | $1,891,039 |
| NET PROFIT | $378,083 | $394,276 | $410,762 | $427,547 | $444,637 | $462,037 | $479,754 | $497,793 | $516,161 | $534,863 | $553,907 | $573,298 | $5,673,118 |
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 | ||||||||||||||||||
| Twilight Organic Beverage Inc. | Twilight Organic Beverage Inc. | Twilight Organic Beverage Inc. | Twilight Organic Beverage Inc. | ||||||||||||||||||
| First Quarter | Second Quarter | Third Quarter | Fourth Quarter | ||||||||||||||||||
| 2018 | 2018 | 2018 | 2018 | ||||||||||||||||||
| ASSETS | ASSETS | ASSETS | ASSETS | ||||||||||||||||||
| Current Assets | Current Assets | Current Assets | Current Assets | ||||||||||||||||||
| Cash | $14,274,470 | Cash | $16,772,166 | Cash | $14,376,436 | Cash | $14,088,147 | ||||||||||||||
| Accounts Receivable | $588,809 | Accounts Receivable | $624,849 | Accounts Receivable | $663,095 | Accounts Receivable | $703,681 | ||||||||||||||
| Inventory | $1,085,080 | Inventory | $2,236,576 | Inventory | $3,458,552 | Inventory | $4,755,323 | ||||||||||||||
| Other Current Assets | $10,000 | Other Current Assets | $4,000 | Other Current Assets | $6,500 | Other Current Assets | $7,500 | ||||||||||||||
| Total Current Assets | $15,958,359 | Total Current Assets | $19,637,591 | Total Current Assets | $18,504,583 | Total Current Assets | $19,554,651 | ||||||||||||||
| Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | ||||||||||||||||||
| Land | $21,600 | Land | $21,600 | Land | $21,600 | Land | $21,600 | ||||||||||||||
| Facilities | $1,032,000 | Facilities | $1,032,000 | Facilities | $1,032,000 | Facilities | $1,032,000 | ||||||||||||||
| Equipment | $205,609 | Equipment | $205,609 | Equipment | $205,609 | Equipment | $205,609 | ||||||||||||||
| Computers & Telecommunications | $457,839 | Computers & Telecommunications | $457,839 | Computers & Telecommunications | $457,839 | Computers & Telecommunications | $457,839 | ||||||||||||||
| (Less Accumlated Depreciation) | $48,559 | (Less Accumlated Depreciation) | $97,119 | (Less Accumlated Depreciation) | $145,678 | (Less Accumlated Depreciation) | $194,237 | ||||||||||||||
| Total Fixed Assets | $1,668,489 | Total Fixed Assets | $1,619,929 | Total Fixed Assets | $1,571,370 | Total Fixed Assets | $1,522,811 | ||||||||||||||
| Other Assets | $1,400,000 | Other Assets | $410,000 | Other Assets | $410,000 | Other Assets | $410,000 | ||||||||||||||
| TOTAL ASSETS | $19,026,848 | TOTAL ASSETS | $21,667,521 | TOTAL ASSETS | $20,485,953 | TOTAL ASSETS | $21,487,462 | ||||||||||||||
| LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | ||||||||||||||||||
| Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | ||||||||||||||||||
| Short-Term Notes Payable | $4,837,644 | Short-Term Notes Payable | $4,428,285 | Short-Term Notes Payable | $4,006,085 | Short-Term Notes Payable | $3,570,646 | ||||||||||||||
| Income Taxes Due | $25,627 | Income Taxes Due | $886 | Income Taxes Due | $77,017 | Income Taxes Due | $211,039 | ||||||||||||||
| Other Current Liabilities | $4,000 | Other Current Liabilities | $3,400 | Other Current Liabilities | $2,500 | Other Current Liabilities | $3,500 | ||||||||||||||
| Total Current Liabilities | $4,867,271 | Total Current Liabilities | $4,432,571 | Total Current Liabilities | $4,085,602 | Total Current Liabilities | $3,785,185 | ||||||||||||||
| Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | ||||||||||||||||||
| Long-Term Notes Payable | $10,405,604 | Long-Term Notes Payable | $9,524,242 | Long-Term Notes Payable | $8,620,826 | Long-Term Notes Payable | $7,694,804 | ||||||||||||||
| Other Long-Term Liabilities | Other Long-Term Liabilities | $100 | Other Long-Term Liabilities | $200 | Other Long-Term Liabilities | $600 | |||||||||||||||
| Total Long-Term Liabilities | $10,405,604 | Total Long-Term Liabilities | $9,524,342 | Total Long-Term Liabilities | $8,621,026 | Total Long-Term Liabilities | $7,695,404 | ||||||||||||||
| NET WORTH | NET WORTH | NET WORTH | NET WORTH | ||||||||||||||||||
| Paid-In Capital | $2,645,000 | Paid-In Capital | $7,645,000 | Paid-In Capital | $7,645,000 | Paid-In Capital | $7,645,000 | ||||||||||||||
| Retained Earnings | $1,108,973 | Retained Earnings | $65,608 | Retained Earnings | $134,325 | Retained Earnings | $2,361,873 | ||||||||||||||
| Total Net Worth | $3,753,973 | Total Net Worth | $7,710,608 | Total Net Worth | $7,779,325 | Total Net Worth | $10,006,873 | ||||||||||||||
| TOTAL LIABILITIES AND NET WORTH | $19,026,848 | TOTAL LIABILITIES AND NET WORTH | $21,667,521 | TOTAL LIABILITIES AND NET WORTH | $20,485,953 | TOTAL LIABILITIES AND NET WORTH | $21,487,462 | ||||||||||||||
