In: Accounting
| Moore's Family Restaurant | ||||||
| Assets & Liabilities as of 12/31/17 | Assets & Liabilities projected to 12/31/18 | |||||
| ASSETS | ASSETS | |||||
| Cash | $492,118.00 | Cash | $589,118.00 | |||
| Accounts Receivable | $29,000.00 | Accounts Receivable | $49,095.00 | |||
| Inventories | $30,000.00 | Inventories | $30,000.00 | |||
| Prepaid Expenses | $2,000.00 | Prepaid Expenses | $11,000.00 | |||
| Total Current Assets | $553,118.00 | Total Current Assets | $679,213.00 | |||
| Building | $727,460.97 | Building | $760,000.00 | |||
| Equipment | $14,500.00 | Equipment | $18,000.00 | |||
| Fixtures | $33,320.00 | Fixtures | $35,500.00 | |||
| Total Fixed Assets | $775,280.97 | Total Fixed Assets | $813,500.00 | |||
| Total Assets | $1,328,398.97 | Total Assets | $1,492,713.00 | |||
| LIABILITIES | LIABILITIES | |||||
| Accounts Payable | $57,432.00 | Accounts Payable | $137,566.00 | |||
| Wages and Benefits Due | $16,516.59 | Wages and Benefits Due | $29,543.00 | |||
| Estimated Taxes and Fees | $6,013.00 | Estimated Taxes and Fees | $8,013.00 | |||
| Total Current Liabilities | $79,961.59 | Total Current Liabilities | $175,122.00 | |||
| Long Term Loan | $70,000.00 | Long Term Loan | $70,000.00 | |||
| Total Long-Term Liabilities | $70,000.00 | Total Long-Term Liabilities | $70,000.00 | |||
| Owner Equity | $1,178,437.38 | Owner Equity | $1,247,591.00 | |||
| Total Liabilities and Owner Equity | $1,328,398.97 | Total Liabilities and Owner Equity | $1,492,713.00 | |||
| Moores Familay Restaurant Financial Data | 2017 | 2018 (Present Day) | 2019 Budget Forecast | |
| Budget Worksgheet | ||||
| Sales | $1,642,896 | $1,766,296 | $2,002,978 | |
| Cost of Product | $697,211 | $597,211 | 701,042 | |
| Labor | $330,772 | $340,695 | 349,212 | |
| Benefits | $79,872 | $114,519 | 122,224 | |
| Utilities | $54,340 | $50,644 | $58,241 | |
| Loan Principle Repayments | $0 | $0 | $0 | |
| Insurance & Property Taxes | $110,000 | $110,000 | $110,000 | |
| Services (accounting, trash, cleaning, etc.) | $41,051 | $43,908 | $105,494 | |
| Other: SG&A, advertising, promostions | $77,629 | $84,771 | $93,248 | |
| Total Costs | $1,390,875 | $1,341,748 | $1,539,462 | |
| Earnings Before Interest, Income Taxes, & Depreciation (EBITD) | $252,021 | $424,548 | $463,516 | |
| Interest on loan | $3,500 | $3,000 | $3,000 | |
| Income Taxes | $70,566 | $118,873 | $129,784 | |
| Depreciation on values | $71,176 | $61,777 | $61,177 | |
| Earnings After Interest, Income Taxes, & Depreciation | $106,779 | $240,897 | $269,555 | |
| Meals Sold | 243,392 | 252,328 | 272,514 | |
| Average Meal Value | 6.75 | 7.00 | 7.35 | |
| Please give positive ratings so I can keep answering. If you have any queries please comment. Thanks! I really need your feedback. Please upvote. |
| Moore's Family Restaurant | Workings | Amount $ | ||
| Cashflow statement as on 31.12.2018 | Increase in Accounts Receivable | |||
| Indirect Method | Amount $ | Amount $ | Closing Balance | 49,095.00 |
| Particulars | Less: Opening Balance | 29,000.00 | ||
| Net Income | 240,897.00 | Increase in Accounts Receivable | 20,095.00 | |
| Adjustment to reconcile Net Income to Net Cash | ||||
| Add: | Increase in Prepaid Expenses | |||
| Depreciation Expense | 61,777.00 | Closing Balance | 11,000.00 | |
| Income Taxes | 118,783.00 | Less: Opening Balance | 2,000.00 | |
| Cash flow from Operations | 421,457.00 | Increase in Prepaid Expenses | 9,000.00 | |
| Changes in Current Assets/Current Liabilities | ||||
| Increase in Accounts Receivable | (20,095.00) | Increase in Accounts Payable | ||
| Increase in Prepaid Expenses | (9,000.00) | Closing Balance | 137,566.00 | |
| Increase in Accounts Payable | 80,134.00 | Less: Opening Balance | 57,432.00 | |
| Increase in Wages and Benefits Due | 13,026.41 | 64,065.41 | Increase in Accounts Payable | 80,134.00 |
| Taxes and Fees paid | (116,783.00) | |||
| Net cash provided by (Used for) operating activities | 368,739.41 | Increase in Wages and Benefits Due | ||
| Closing Balance | 29,543.00 | |||
| Cash flow from investing activities | Less: Opening Balance | 16,516.59 | ||
| Addition in Fixed Assets | (99,996.03) | Increase in Wages and Benefits Due | 13,026.41 | |
| Net cash provided by (Used for) investing activities | (99,996.03) | |||
| Taxes and Fees paid | ||||
| Cash flow from financing activities | Opening Balance | 6,013.00 | ||
| Changes in Equity | (171,743.38) | Add: Income Taxes for 2018 | 118,783.00 | |
| Net cash provided by (Used for) financing activities | (171,743.38) | Less: Closing Balance | 8,013.00 | |
| Taxes and Fees paid | 116,783.00 | |||
| Net Increase/(Decrease) in cash | 97,000.00 | |||
| Cash Balance, December 31, 2017 | 492,118.00 | Addition in Fixed Assets | ||
| Cash Balance, December 31, 2018 | 589,118.00 | Closing balances of | ||
| Building | 760,000.00 | |||
| Equipment | 18,000.00 | |||
| Fixtures | 35,500.00 | |||
| Add: Depreciation | 61,777.00 | |||
| Less: Opening balances of | ||||
| Building | 727,460.97 | |||
| Equipment | 14,500.00 | |||
| Fixtures | 33,320.00 | |||
| Addition in Fixed Assets | 99,996.03 | |||
| Changes in Equity | ||||
| Opening balance | 1,178,437.38 | |||
| Add- Net Income | 240,897.00 | |||
| Less- Closing balance | 1,247,591.00 | |||
| Changes in Equity | 171,743.38 | |||