Strategic Management 3 : Operating Technology and Management Plan
TonKung
ExampleAssignment3ExOperationTechnologyandManagementPlan.xlsBalSht
| Balance Sheet | Balance Sheet | Balance Sheet | Balance Sheet | |||||||||||||||||||
| The Frank Beverage Group | The Frank Beverage Group | The Frank Beverage Group | The Frank Beverage Group | |||||||||||||||||||
| First Quarter | Second Quarter | Third Quarter | Fourth Quarter | |||||||||||||||||||
| 2019-2020 | 2019-2020 | 2019-2020 | 2019-2020 | |||||||||||||||||||
| ASSETS | ASSETS | ASSETS | ASSETS | |||||||||||||||||||
| Current Assets | Current Assets | Current Assets | Current Assets | |||||||||||||||||||
| Cash | $110,102 | Cash | $161,052 | Cash | $186,936 | Cash | $219,214 | |||||||||||||||
| Accounts Receivable | $35,569 | Accounts Receivable | $37,746 | Accounts Receivable | $40,057 | Accounts Receivable | $42,508 | |||||||||||||||
| Inventory | -$1,887 | Inventory | $14,313 | Inventory | $31,504 | Inventory | $50,300 | |||||||||||||||
| Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | Other Current Assets | $0 | |||||||||||||||
| Total Current Assets | $143,784 | Total Current Assets | $213,111 | Total Current Assets | $258,497 | Total Current Assets | $312,022 | |||||||||||||||
| Fixed Assets | Fixed Assets | Fixed Assets | Fixed Assets | |||||||||||||||||||
| Land | $0 | Land | $0 | Land | $0 | Land | $0 | |||||||||||||||
| Facilities | $0 | Facilities | $0 | Facilities | $0 | Facilities | $0 | |||||||||||||||
| Equipment | $0 | Equipment | $0 | Equipment | $0 | Equipment | $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 | |||||||||||||||
| 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 | |||||||||||||||
| TOTAL ASSETS | $143,784 | TOTAL ASSETS | $213,111 | TOTAL ASSETS | $258,497 | TOTAL ASSETS | $312,022 | |||||||||||||||
| LIABILITIES | LIABILITIES | LIABILITIES | LIABILITIES | |||||||||||||||||||
| Current Liabilities | Current Liabilities | Current Liabilities | Current Liabilities | |||||||||||||||||||
| Short-Term Notes Payable | $9,873 | Short-Term Notes Payable | $9,997 | Short-Term Notes Payable | $10,122 | Short-Term Notes Payable | $10,249 | |||||||||||||||
| Income Taxes Due | $16,109 | Income Taxes Due | $34,046 | Income Taxes Due | $46,006 | Income Taxes Due | $59,618 | |||||||||||||||
| Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | Other Current Liabilities | $0 | |||||||||||||||
| Total Current Liabilities | $25,982 | Total Current Liabilities | $44,043 | Total Current Liabilities | $56,128 | Total Current Liabilities | $69,868 | |||||||||||||||
| Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | Long-Term Liabilities | |||||||||||||||||||
| Long-Term Notes Payable | $7,735 | Long-Term Notes Payable | $5,189 | Long-Term Notes Payable | $2,610 | 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 | |||||||||||||||
| Total Long-Term Liabilities | $7,735 | Total Long-Term Liabilities | $5,189 | Total Long-Term Liabilities | $2,610 | Total Long-Term Liabilities | -$0 | |||||||||||||||
| NET WORTH | NET WORTH | NET WORTH | NET WORTH | |||||||||||||||||||
| Paid-In Capital | $61,740 | Paid-In Capital | $61,740 | Paid-In Capital | $61,740 | Paid-In Capital | $61,740 | |||||||||||||||
| Retained Earnings | $48,327 | Retained Earnings | $102,139 | Retained Earnings | $138,018 | Retained Earnings | $180,414 | |||||||||||||||
| Total Net Worth | $110,067 | Total Net Worth | $163,879 | Total Net Worth | $199,758 | Total Net Worth | $242,154 | |||||||||||||||
| TOTAL LIABILITIES AND NET WORTH | $143,784 | TOTAL LIABILITIES AND NET WORTH | $213,111 | TOTAL LIABILITIES AND NET WORTH | $258,497 | TOTAL LIABILITIES AND NET WORTH | $312,022 |
For information about this worksheet, see "Balance Sheet" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.
Short-Term Notes Payable: loan payments to be made within one year
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).
CshFlw
| Cash Flow | 2019-2020 | ||||||||||||
| October | November | December | January | February | March | April | May | June | July | August | September | TOTAL | |
| CASH RECEIPTS | |||||||||||||
| Income from Sales | |||||||||||||
| Cash Sales | $27,972 | $28,531 | $29,102 | $29,684 | $30,278 | $30,883 | $31,501 | $32,131 | $32,774 | $33,429 | $34,098 | $34,780 | $375,163 |
| Collections | $0 | $34,188 | $34,872 | $35,569 | $36,281 | $37,006 | $37,746 | $38,501 | $39,271 | $40,057 | $40,858 | $41,675 | $416,024 |
| Total Cash from Sales | $27,972 | $62,719 | $63,974 | $65,253 | $66,558 | $67,890 | $69,247 | $70,632 | $72,045 | $73,486 | $74,956 | $76,455 | $791,187 |
| Income from Financing | |||||||||||||
| Interest Income | $66 | $79 | $92 | $105 | $119 | $134 | $141 | $148 | $156 | $164 | $173 | $183 | $1,559 |
| Loan Proceeds | $20,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $20,000 |
| Equity Capital Investments | $45,240 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $45,240 |
| Total Cash from Financing | $65,306 | $79 | $92 | $105 | $119 | $134 | $141 | $148 | $156 | $164 | $173 | $183 | $66,799 |
| Other Cash Receipts | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| TOTAL CASH RECEIPTS | $93,278 | $62,798 | $64,066 | $65,359 | $66,678 | $68,024 | $69,388 | $70,780 | $72,201 | $73,650 | $75,129 | $76,637 | $857,986 |
| CASH DISBURSEMENTS | |||||||||||||
| Inventory | $5,240 | $22,841 | $23,298 | $23,764 | $24,239 | $24,724 | $25,218 | $25,722 | $26,237 | $26,762 | $27,297 | $28,395 | $283,734 |
| Operating Expenses | $17,518 | $17,518 | $17,518 | $17,518 | $17,518 | $17,518 | $28,060 | $28,060 | $28,060 | $28,060 | $28,060 | $28,060 | $273,471 |
| Commissions/Returns & Allowances | $6,527 | $6,657 | $6,790 | $6,926 | $7,065 | $7,206 | $7,350 | $7,497 | $7,647 | $7,800 | $7,956 | $8,115 | $87,538 |
| Capital Purchases | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Loan Payments | $877 | $877 | $877 | $877 | $877 | $877 | $877 | $877 | $877 | $877 | $877 | $877 | $10,529 |
| Income Tax Payments | $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 |
| Owner's Draw | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| TOTAL CASH DISBURSEMENTS | $30,162 | $47,894 | $48,484 | $49,085 | $49,699 | $50,325 | $61,506 | $62,157 | $62,822 | $63,499 | $64,191 | $65,448 | $655,272 |
| NET CASH FLOW | $63,116 | $14,904 | $15,582 | $16,273 | $16,978 | $17,698 | $7,882 | $8,623 | $9,379 | $10,151 | $10,938 | $11,190 | $202,714 |
| Opening Cash Balance | $16,500 | $79,616 | $94,520 | $110,102 | $126,375 | $143,354 | $161,052 | $168,934 | $177,557 | $186,936 | $197,086 | $208,024 | |
| Cash Receipts | $93,278 | $62,798 | $64,066 | $65,359 | $66,678 | $68,024 | $69,388 | $70,780 | $72,201 | $73,650 | $75,129 | $76,637 | |
| Cash Disbursements | $30,162 | $47,894 | $48,484 | $49,085 | $49,699 | $50,325 | $61,506 | $62,157 | $62,822 | $63,499 | $64,191 | $65,448 | |
| ENDING CASH BALANCE | $79,616 | $94,520 | $110,102 | $126,375 | $143,354 | $161,052 | $168,934 | $177,557 | $186,936 | $197,086 | $208,024 | $219,214 | $219,214 |
For information about this worksheet, see "Cash-Flow Projections" in "The Financials" chapter of Successful Business Plan: Secrets & Strategies.
This line item is automatically calculated for you based on the interest rate you entered on the "Setup and Assumptions" sheet.
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).
IncSht
| Income Statements | 2019-2020 | ||||||||||||
| October | November | December | January | February | March | April | May | June | July | August | September | TOTAL | |
| INCOME | |||||||||||||
| Gross Sales | $62,160 | $63,403 | $64,671 | $65,965 | $67,284 | $68,630 | $70,002 | $71,402 | $72,830 | $74,287 | $75,773 | $77,288 | $833,695 |
| (Commissions) | $4,662 | $4,755 | $4,850 | $4,947 | $5,046 | $5,147 | $5,250 | $5,355 | $5,462 | $5,572 | $5,683 | $5,797 | $62,527 |
| (Returns and allowances) | $1,865 | $1,902 | $1,940 | $1,979 | $2,019 | $2,059 | $2,100 | $2,142 | $2,185 | $2,229 | $2,273 | $2,319 | $25,011 |
| Net Sales | $55,633 | $56,746 | $57,881 | $59,038 | $60,219 | $61,424 | $62,652 | $63,905 | $65,183 | $66,487 | $67,817 | $69,173 | $746,157 |
| (Cost of Goods) | $17,405 | $17,753 | $18,108 | $18,470 | $18,840 | $19,216 | $19,601 | $19,993 | $20,392 | $20,800 | $21,216 | $21,641 | $233,435 |
| GROSS PROFIT | $38,228 | $38,993 | $39,773 | $40,568 | $41,380 | $42,207 | $43,051 | $43,912 | $44,791 | $45,686 | $46,600 | $47,532 | $512,723 |
| EXPENSES - General and Administrative | |||||||||||||
| Salaries and wages | $9,948 | $9,948 | $9,948 | $9,948 | $9,948 | $9,948 | $19,115 | $19,115 | $19,115 | $19,115 | $19,115 | $19,115 | $174,378 |
| Employee benefits | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $2,086 | $25,036 |
| Payroll taxes | $1,492 | $1,492 | $1,492 | $1,492 | $1,492 | $1,492 | $2,867 | $2,867 | $2,867 | $2,867 | $2,867 | $2,867 | $26,157 |
| Professional services | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $1,292 | $15,500 |
| Marketing and advertising | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $20,400 |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Equipment rental | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 |
| Maintenance | $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 |
| Insurance | $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 |
| Utilities | $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 |
| Postage and shipping | $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 |
| Entertainment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Interest on loans | $83 | $80 | $77 | $73 | $70 | $67 | $63 | $60 | $56 | $53 | $50 | $46 | $779 |
| Other (change title here) | $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 |
| TOTAL EXPENSES | $17,602 | $17,598 | $17,595 | $17,592 | $17,588 | $17,585 | $28,124 | $28,120 | $28,117 | $28,113 | $28,110 | $28,106 | $274,249 |
| Net income before taxes and interest | $20,627 | $21,395 | $22,178 | $22,977 | $23,791 | $24,622 | $14,928 | $15,792 | $16,674 | $17,573 | $18,490 | $19,426 | $238,473 |
| Interest Income | $66 | $79 | $92 | $105 | $119 | $134 | $141 | $148 | $156 | $164 | $173 | $183 | $1,559 |
| Provision for taxes on income | $5,173 | $5,368 | $5,567 | $5,770 | $5,978 | $6,189 | $3,767 | $3,985 | $4,207 | $4,434 | $4,666 | $4,902 | $59,618 |
| NET PROFIT | $15,520 | $16,105 | $16,702 | $17,311 | $17,933 | $18,567 | $11,301 | $11,955 | $12,622 | $13,303 | $13,998 | $14,706 | $180,414 |
For information about this worksheet, see "Income Statements" in Successful Business Plan: Secrets & Strategies.
