Profitability Ratios
What is the Net profit margin for FML?
What is the Gross profit margin for FML?
What is the Return on assets for FML?
What is the return on equity for FML?
What is the Total asset turnover for FM?
Liquidity Ratios
What is the Current Ratio?
What is Working Captial?
What is the Cash ratio?
What is the Acid Test Ratio?
FML Restaurant Monthly cash budget For the 6 months ended 30th June 2020 February March Cash Receipts Cash Sales (Burgers) Credit Sales (Burgers) Cash Sales (Fresh Salad) Credit Sales (Fresh Salad) Government Wage Subsidy Total Cash Receipts January $ 116,252.50 45,635.10 25,207.00 9,895.50 108,054.80 49,822.50 23.432.50 10.803.00 2,881.20 46,309.20 1,543.50 10,042.50 6,000.00 66,776.40 April $ 3,026.24 1,234.80 1,621.20 661.50 6,000.00 12,543.74 May $ 2,881.20 1,296.96 1,543.50 694.80 6,000.00 12,416.46 June $ 3,171.28 1,234.80 1.698.90 661.50 6,000.00 12,766.48 Total $ 236,267.22 145,533.36 55,046.60 32,758.80 24,000.00 493,605.98 196,990.10 192,112.80 Cash Payments Food Purchases (Burgers) Food Purchases (Fresh Salad) Returns and Refunds Rent Expense Utilities Expense Insurance Expense Marketing Expense Salaries Expense: Shop manager (fixed cost) Wages Expense: Loan Repayment (Interest and Principle) Equipment Purchase Franchising Cost 46,613.50 14,150.50 693.00 7,000.00 4,000.00 300.00 50.00 6,800.00 33,600.00 16,569.21 33,445.50 10,410.00 644.00 7,000.00 4,000.00 300.00 50.00 6,800.00 33,600.00 16,569.21 17,000.00 4,500.00 1.488.50 1,488.50 16.00 7,000.00 5,000.00 300.00 50.00 6,800.00 6,000.00 16,569.21 1,525.50 1,525.50 17.00 7,000.00 4,000.00 300.00 50.00 6,800.00 6,000.00 16,569.21 1,507.00 1,507.00 16.00 7,000.00 4,000.00 300.00 50.00 6,800.00 6,000.00 16,569.21 1,581.00 1,581.00 18.00 7,000.00 4,000.00 300.00 50.00 6,800.00 6,000.00 16,569.21 86,161.00 30,662.50 1,404.00 42,000.00 25,000.00 1,800.00 300.00 40,800.00 91,200.00 99,415.26 17,000.00 27,000.00 4,500.00 4,500.00 4,500.00 4,500.00 4,500.00 Total Cash Payments 134,276.21 134,318.71 49,212.21 48,287.21 48,249.21 48,399.21 462,742.76 Deficit / Surplus 62,713.89 57,794.09 17,564.19 (35,743.47 (35,832.75 (35,632.73) 30,863.22 Opening Balance 378,856.38 441,570.27 499,364.36 516,928.55 481,185.08 445,352.33 378,856.38 Closing Balance 441,570.27 499,364.36 516,928.55 481 185.08 445,352.33 409,719.60 409,719.60 Opening Inventory Purchases Cost of Sales End of Month Closing Invento Jan $ 11,862.50 46,613.50 47.450.00 11.026.00 Feb $ 11,026.00 33.445.50 44.104.00 367.50 Mar $ 367.50 1.488.50 1,470.00 386.00 Apr $ 386.00 1,525.50 1,544.00 367.50 May $ 367.50 1,507.00 1,470.00 404.50 Jun $ 404.50 1,581.00 1,618.00 TOTALS $ 11,862.50 86,161.00 97,656.00 367.50 367.50 Average Burgers Inventory $ 2,153.17 FML Restaurant Fresh Salad Monthly Inventory Report For the 6 months ended 30th June 2020 Feb Mar Apr $ $ $ 3,347.50 367.50 386.00 10,410.00 1.488.50 1,525.50 13,390.00 1.470.00 1,544.00 367.50 386.00 367.50 Jan $ 3,601.00 14. 150.50 14.404.00 3,347.50 Opening Inventory Purchases Cost of Sales End of Month Closing Inventa May $ 367.50 1,507.00 1.470.00 404.50 Jun $ 404.50 1,581.00 1,618.00 367.50 TOTALS $ 3,601.00 30,662.50 33,896.00 367.50 Average Fresh Salad Inventory $ 873.42 Jan $ 15,463.50 60,764.00 61,854.00 14,373.50 UNNAMED Combined Monthly Inventory Report For the 6 months ended 30th June 2020 Feb Mar Apr $ $ $ 14,373.50 735.00 772.00 43,855.50 2,977.00 3.051.00 57,494.00 2,940.00 3,088.00 735.00 772.00 735.00 Opening Inventory Purchases Cost of Sales End of Month Closing Invento May $ 735.00 3,014.00 2,940.00 809.00 Jun $ 809.00 3,162.00 3,236.00 735.00 TOTALS $ 15,463.50 116,823.50 131,552.00 735.00 Average Combined Inventory $ 3,026.58 FML Restaurant Income Statement For the 6 months ended 30th June 2020 $ 416,162.60 1,404.00 Revenue Gross Sales Revenue Less: Returns and Refunds Net Sales Less: Cost of Sales Gross Profit 414,758.60 131,552.00 283,206.60 Other Revenue Government Wage Subsidy 24,000.00 Less: Expenses Rent Expense Utilities Expense Insurance Expense Marketing Expense Salaries Expense Wages Expense Interest Expense Depreciation Expense Franchising Expense 42,000.00 25,000.00 1.800.00 300.00 40,800.00 91,200.00 8,360.00 6,091.67 27,000.00 Total Expenses 242,551.67 Net Profit 64,654.93 Investors share of profits Owners share of profits 64,654.93 For the 6 months ended 30th June 2020 $ Assets Current Assets Cash Accounts Receivable Inventories Total Current Assets 409,719.60 2,087.22 735.00 412,541.82 Non-Current Assets Equipment Less: Accumulated Depreciation 85,000.00 (12,891.67) Total Non-Current Assets Total Assets 72,108.33 484,650.15 Liabilities Current Liabilities Accounts Payable Total Current Liabilities 4,000.00 4,000.00 106,834.22 Non-Current Liabilities Loan Payable Total Non-Current Liabilities Total Liabilities 106,834.22 110,834.22 Net Assets 373,815.93 200,000.00 109,161.00 Equity Capital - Owner Capital - Investors Retained Earnings 2019 - Owner Retained Earnings 2019 - Investors Retained Earnings 2020 - Owner Retained Earnings 2020 - Investors Total Equity 64,654.93 373,815.93 Accounts Receivable Turnover As this is the first year of business, please use an assumed amount of $50,000 for the 2018 Account Receivable amount. Average account receivable = ([2018 Account Receivable + 2019 Account Receivable] /2) Inventory Turnover (Combined Products) NOTE: Please use the combined inventory values from Tab 2019 Inventory Reports" Financial Stability Ratios Debt Ratio Debt/Equity Ratio Equity Ratio Degree of Financial Leverage
