Consider how the food outlet business that you are developing a business plan for will manage cash-flow,
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider how the food outlet business that you are developing a business plan for will manage cash-flow, financial controls, and financial planning. Post your plans on the discussion board and respond to at least two others' results.
Balance Sheet | ||||||||||||||
Assets | Dec-24 | 31Dec2023 or 1Jan2024 | Fixed assets and accounts payable to drive the rest of the Balance sheet | |||||||||||
Current Assets | ||||||||||||||
Cash in Bank | $32,163 | $21,443 | ||||||||||||
Investments in liquid funds | $25,023 | $0 | ||||||||||||
Cash Value of Inventory | $37,382 | $19,114 | ||||||||||||
Prepaid insurance | $12,000 | $24,000 | ||||||||||||
Total Current Assets | $106,568 | $64,557 | ||||||||||||
Fixed Assets | DDB; 10 years life; half year rule; NBV*2/n | Machinery and equipment | ||||||||||||
Machinery & Equipment | $81,000 | $90,000 | 2023 | 2024 | 0.2 | |||||||||
Acc dep, machinery and equipment | $16,200 | $9,000 | 9000 | 16200 | ||||||||||
Furniture & Fixtures | $54,000 | $60,000 | Furniture and fixture | |||||||||||
Acc dep, furniture & fixtures | $10,800 | $6,000 | 6000 | 10800 | 0.2 | |||||||||
Total Fixed Assets | $108,000 | $135,000 | ||||||||||||
Total Assets | $214,568 | $199,557 | ||||||||||||
Liabilities & Net Worth | ||||||||||||||
Current Liabilities | ||||||||||||||
Accounts Payable | $18,692 | $9,557 | ||||||||||||
Taxes Payable | $568 | $0 | 9% pa taxes | |||||||||||
Revolving credit facility | $30,000 | $30,000 | 12% per annum rate of interest, if utilized | |||||||||||
Total Current Liabilities | $49,260 | $39,557 | ||||||||||||
Long-Term Liabilities | ||||||||||||||
Bank Loans Payable (greater than 12 months) | $98,996 | $100,000 | 15% rate of int per annum considered to be repaid in 10 years or 120 instalments starting 31Jan2024 | |||||||||||
Less: Short-Term Portion | $10,000 | $10,000 | ||||||||||||
Total Long-Term Liabilities | $108,996 | $110,000 | ||||||||||||
Total Liabilities | $158,256 | $149,557 | ||||||||||||
Owners' Equity (Net Worth) | ||||||||||||||
Shareholders' equity | $50,000 | $50,000 | ||||||||||||
Net income for the year | $6,312 | $0 | ||||||||||||
Less: Dividends for the year | $0 | $0 | ||||||||||||
Total equity | $56,312 | $50,000 | ||||||||||||
Total Liabilities & Net Worth | $214,568 | $199,557 | ||||||||||||
January | February | March | April | May | June | July | August | September | October | November | December | YEARLY | |
Revenue (Sales) | |||||||||||||
Beverages | 6,600 | 7,700 | 8,360 | 11,000 | 4,400 | 3,300 | 3,300 | 3,740 | 11,000 | 10,450 | 12,100 | 13,200 | 95,150 |
Main Course | 21,780 | 24,750 | 32,175 | 37,125 | 11,880 | 9,900 | 9,900 | 10,890 | 36,630 | 35,640 | 39,600 | 49,500 | 319,770 |
Snacks | 9,680 | 11,000 | 13,200 | 15,400 | 8,800 | 7,480 | 7,040 | 7,920 | 17,600 | 17,600 | 13,200 | 13,200 | 142,120 |
Total Revenue (Sales) | 38,060 | 43,450 | 53,735 | 63,525 | 25,080 | 20,680 | 20,240 | 22,550 | 65,230 | 63,690 | 64,900 | 75,900 | 557,040 |
Cost of Goods Sold | |||||||||||||
Beverages | 6,947 | 7,343 | 7,581 | 8,531 | 4,832 | 4,436 | 4,436 | 4,594 | 8,531 | 8,333 | 8,927 | 9,323 | 83,814 |
Main Course | 22,424 | 23,612 | 26,582 | 28,562 | 14,493 | 13,701 | 13,701 | 18,068 | 28,364 | 27,968 | 29,552 | 33,512 | 280,539 |
Snacks | 9,411 | 10,071 | 11,171 | 12,271 | 7,648 | 6,988 | 6,768 | 7,208 | 13,371 | 13,371 | 11,171 | 11,171 | 120,620 |
Total Cost of Goods Sold | 38,782 | 41,026 | 45,334 | 49,364 | 26,973 | 25,125 | 24,905 | 29,870 | 50,266 | 49,672 | 49,650 | 54,006 | 484,973 |
Gross Profit | -722 | 2,424 | 8,401 | 14,161 | -1,893 | -4,445 | -4,665 | -7,320 | 14,964 | 14,018 | 15,250 | 21,894 | 72,067 |
Operating Expenses | |||||||||||||
Rent Expense | 188 | 188 | 188 | 188 | 188 | 188 | 188 | 188 | 188 | 188 | 188 | 188 | 2,256 |
Salary/Wage Expenses | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 36,000 |
Supplies Expense | 200 | 200 | 200 | 200 | 150 | 150 | 150 | 150 | 200 | 200 | 200 | 200 | 2,200 |
Advertising Expense | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1,200 |
Utilities Expense | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1,200 |
Telephone/Internet Expense | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 1,800 |
Insurance Expense | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4,800 |
Interest from Loans (if applicable) | 1,375 | 1,364 | 1,352 | 1,341 | 1,329 | 1,318 | 1,306 | 1,295 | 1,283 | 1,272 | 1,260 | 1,249 | 15,744 |
Other Expenses (Miscellaneous) | 50 | 55 | 65 | 65 | 30 | 30 | 30 | 30 | 50 | 50 | 50 | 50 | 555 |
Total Expenses | 5,563 | 5,557 | 5,555 | 5,544 | 5,447 | 5,436 | 5,424 | 5,413 | 5,471 | 5,460 | 5,448 | 5,437 | 65,755 |
Net Profit | -6,285 | -3,133 | 2,846 | 8,617 | -7,340 | -9,881 | -10,089 | -12,733 | 9,493 | 8,558 | 9,802 | 16,457 | 6,312 |
Related Book For
E Business and E Commerce Management Strategy Implementation and Practice
ISBN: 978-0273719601
4th edition
Authors: Dave Chaffey
Posted Date: