SME Report 337213 per cent

SME Report 337213 dollars

Based on the ratios AND common size calculations compare how Fanshawe Furniture is doing compared to the benchmark. Is it doing better or worse? Be specific.

Fanshawe Furniture Manufacturing Breakeven Calculations 2021 2020 25% Gross Margin 20% Fixed Expenses $840,874 $857,262 Annual Breakeven Sales $3,411,352 $4,308,865 Monthly Breakeven Sales $284,279| $359,072 Sales Required for a profit of $ EA 1,000,000 $7,468,2621 $9,335,178 Complete the Theory Problem in space below 2020 2019 2021 Current Ratio Current Assets Current Liabilities 1.66 1.60 1.78 Quick Ratio Current Assets-Inventory_ Current Liabilities 0.83 0.86 0.93 Inventory Turns COS Avg Inventory 4.47 4.82 4.81 Gross Margin % Net Sales-Cos Net Sales 24.6% 22.7% 19.9% Net Profit Margin % Net Profit Net Sales 4.5% 2.7% 2.5% Return on Equity Net Profit Shareholder's Equity 29% 19% 17% Accounts Payable Period Accounts Payable Average daily purchases 125.57 122.87 101.08 Average Collection Period Accounts Receivable Average daily credit sales 37.4 35.0 37.4 Interest Coverage EBIT Interest 7.2 4.0 4.7 Debt Coverage EBIT + Current portion of LTD Interest + Current portion of LTD 5.5 3.1 3.6 Bottom Quartile (25%) Lower Middle (25%) Upper Middle (25%) Top Quartile (25%) Number of Businesses Revenue Range: Low Value (5000) High Value (5000) 30 110 110 368 368 1423 1423 5000 100.00 98.10 1.90 37.30 0.30 36.70 3.50 3.20 66.10 21.00 6.70 1.20 3.50 11.10 1.60 3.40 0.60 0.00 2.20 14.80 103.40 -3.40 100.00 85.30 14,70 47.60 11.60 36.10 3.40 3.50 49.40 16.10 3.90 1.20 3.10 9.10 0.10 2.00 1.90 0.10 2.20 9.70 97.10 2.90 100.00 89.90 10.10 56.60 22.10 35.50 9.70 10.70 28.70 13.70 1.90 0.30 1.90 4.30 0.20 1.50 0.50 0.30 0.70 3.40 85.30 14.70 100.00 99.90 0.10 74.20 28.50 46.70 11.90 12.90 25.60 10.50 1.30 0.60 1.00 3.40 0.30 1.90 1.00 0.70 0.70 4.20 99.80 0.20 REVENUES AND EXPENSES Total revenue Sales of goods and services All other revenues Cost of sales (direct expenses) Wages and benefits Purchases, materials and sub-contracts Opening Inventory Closing inventory Operating expenses (indirect expenses) Labour and commissions Amortization and depletion Repairs and maintenance Utilities and telephone/telecommunication Rent Interest and bank charges Professional and business fees Advertising and promotion Delivery, shipping and warehouse expenses Insurance Other expenses Total expenses Net profit/loss BALANCE SHEET Total assets Total current assets Accounts receivable Closing inventory Other current assets Net tangible and intangible assets All other assets and adjustments Total liabilities Total current liabilities Current bank loans Other current liabilities Long term liabilities Total equity FINANCIAL RATIOS Current ratio Debt to equity ratio Interest coverage ratio Debt ratio Revenue to equity ratio Revenue to closing inventory ratio Current debt to equity (%) Net profit to equity (%) Net fixed assets to equity (%) Gross margin (%) Return on total assets (%) Collection period for accounts receivable (days) 52.60 28.70 7.20 2.50 19.00 23.90 0.00 67.00 42.50 0.00 42.50 24.50 -14.50 166.70 49.60 13.70 6.00 29.90 114.70 2.40 188.70 80.30 18.90 61.30 108.40 -22.00 917.90 819.50 134.00 79.20 606.30 73.80 24.60 621.90 469.10 1.80 467.20 152.80 296.00 1683.10 1368.60 423.60 323.50 621.50 222.80 91.70 970.60 639.40 0.40 639.10 331.20 712.50 0.70 -4.60 -1.10 1.30 -4.60 26.00 -293.30 15.50 -164.80 62.00 -2.20 39.50 0.60 -8.60 43.80 1.10 -9.90 36.10 -364,70 -29.30 -521.00 44.20 4.00 23.00 1.70 2.10 60.70 0.70 2.50 9.20 158.50 36.20 24.90 37.10 11.90 67.10 2.10 1.40 1.60 0.60 3.40 7.50 89.70 0.70 31.30 25.70 0.80 63.40 Bottom Quartile (25%) Lower Middle (25%) Upper Middle (25%) Top Quartile (25%) Number of Businesses Revenue Range: Low Value (5000) High Value (5000) 30 110 110 368 368 1423 1423 5000 66.10 64.90 1.20 24.70 0.20 24.20 2.30 2.10 43.70 13.90 4.40 0.80 2.30 7.30 1.10 2.20 0.40 0.00 1.50 9.80 68.40 -2.20 218.40 186.40 32.10 104.00 25.30 78.90 7.40 7.60 108.00 35.10 8.60 2.60 6.80 19.90 0.20 4.40 4.20 0.20 4.80 21.10 212.00 6.40 729.00 655.40 73.60 412.50 161.30 259.00 70.40 78.30 209.50 100.10 13.90 2.10 13.70 31.50 1.80 10.90 3.50 2.50 4.80 24.60 621.90 107.10 2438.00 2435.50 2.40 1809.80 695.90 1139.50 290.10 315.70 622.90 255.50 30.90 15.10 24.00 83.80 8.50 47.50 24.10 15.90 16.20 101.50 2432.80 5.20 REVENUES AND EXPENSES Total revenue Sales of goods and services All other revenues Cost of sales (direct expenses) Wages and benefits Purchases, materials and sub-contracts Opening Inventory Closing inventory Operating expenses (indirect expenses) Labour and commissions Amortization and depletion Repairs and maintenance Utilities and telephone/telecommunication Rent Interest and bank charges Professional and business fees Advertising and promotion Delivery, shipping and warehouse expenses Insurance Other expenses Total expenses Net profit/loss BALANCE SHEET Total assets Total current assets Accounts receivable Closing inventory Other current assets Net tangible and intangible assets All other assets and adjustments Total liabilities Total current liabilities Current bank loans Other current liabilities Long term liabilities Total equity FINANCIAL RATIOS Current ratio Debt to equity ratio Interest coverage ratio Debt ratio Revenue to equity ratio Revenue to closing inventory ratio Current debt to equity (%) Net profit to equity (%) Net fixed assets to equity (%) Gross margin (%) Return on total assets (%) Collection period for accounts receivable (days) 52.60 28.70 7.20 2.50 19.00 23.90 0.00 67.00 42.50 0.00 42.50 24.50 -14.50 166.70 49.60 13.70 6.00 29.90 114.70 2.40 188.70 80.30 18.90 61.30 108.40 -22.00 917.90 819.50 134.00 79.20 606.30 73.80 24.60 621.90 469.10 1.80 467.20 152.80 296.00 1683.10 1368.60 423.60 323.50 621.50 222.80 91.70 970.60 639.40 0.40 639.10 331.20 712.50 0.70 -4.60 -1.10 1.30 -4.60 26.00 -293.30 15.50 -164.80 62.00 -2.20 39.50 0.60 -8.60 43.80 1.10 -9.90 36.10 -364.70 -29.30 -521.00 44.20 4.00 23.00 1.70 2.10 60.70 0.70 2.50 9.20 158.50 36.20 24.90 37.10 11.90 67.10 2.10 1.40 1.60 0.60 3.40 7.50 89.70 0.70 31.30 25.70 0.80 63.40 Fanshawe Furniture Manufacturing Breakeven Calculations 2021 2020 25% Gross Margin 20% Fixed Expenses $840,874 $857,262 Annual Breakeven Sales $3,411,352 $4,308,865 Monthly Breakeven Sales $284,279| $359,072 Sales Required for a profit of $ EA 1,000,000 $7,468,2621 $9,335,178 Complete the Theory Problem in space below 2020 2019 2021 Current Ratio Current Assets Current Liabilities 1.66 1.60 1.78 Quick Ratio Current Assets-Inventory_ Current Liabilities 0.83 0.86 0.93 Inventory Turns COS Avg Inventory 4.47 4.82 4.81 Gross Margin % Net Sales-Cos Net Sales 24.6% 22.7% 19.9% Net Profit Margin % Net Profit Net Sales 4.5% 2.7% 2.5% Return on Equity Net Profit Shareholder's Equity 29% 19% 17% Accounts Payable Period Accounts Payable Average daily purchases 125.57 122.87 101.08 Average Collection Period Accounts Receivable Average daily credit sales 37.4 35.0 37.4 Interest Coverage EBIT Interest 7.2 4.0 4.7 Debt Coverage EBIT + Current portion of LTD Interest + Current portion of LTD 5.5 3.1 3.6 Bottom Quartile (25%) Lower Middle (25%) Upper Middle (25%) Top Quartile (25%) Number of Businesses Revenue Range: Low Value (5000) High Value (5000) 30 110 110 368 368 1423 1423 5000 100.00 98.10 1.90 37.30 0.30 36.70 3.50 3.20 66.10 21.00 6.70 1.20 3.50 11.10 1.60 3.40 0.60 0.00 2.20 14.80 103.40 -3.40 100.00 85.30 14,70 47.60 11.60 36.10 3.40 3.50 49.40 16.10 3.90 1.20 3.10 9.10 0.10 2.00 1.90 0.10 2.20 9.70 97.10 2.90 100.00 89.90 10.10 56.60 22.10 35.50 9.70 10.70 28.70 13.70 1.90 0.30 1.90 4.30 0.20 1.50 0.50 0.30 0.70 3.40 85.30 14.70 100.00 99.90 0.10 74.20 28.50 46.70 11.90 12.90 25.60 10.50 1.30 0.60 1.00 3.40 0.30 1.90 1.00 0.70 0.70 4.20 99.80 0.20 REVENUES AND EXPENSES Total revenue Sales of goods and services All other revenues Cost of sales (direct expenses) Wages and benefits Purchases, materials and sub-contracts Opening Inventory Closing inventory Operating expenses (indirect expenses) Labour and commissions Amortization and depletion Repairs and maintenance Utilities and telephone/telecommunication Rent Interest and bank charges Professional and business fees Advertising and promotion Delivery, shipping and warehouse expenses Insurance Other expenses Total expenses Net profit/loss BALANCE SHEET Total assets Total current assets Accounts receivable Closing inventory Other current assets Net tangible and intangible assets All other assets and adjustments Total liabilities Total current liabilities Current bank loans Other current liabilities Long term liabilities Total equity FINANCIAL RATIOS Current ratio Debt to equity ratio Interest coverage ratio Debt ratio Revenue to equity ratio Revenue to closing inventory ratio Current debt to equity (%) Net profit to equity (%) Net fixed assets to equity (%) Gross margin (%) Return on total assets (%) Collection period for accounts receivable (days) 52.60 28.70 7.20 2.50 19.00 23.90 0.00 67.00 42.50 0.00 42.50 24.50 -14.50 166.70 49.60 13.70 6.00 29.90 114.70 2.40 188.70 80.30 18.90 61.30 108.40 -22.00 917.90 819.50 134.00 79.20 606.30 73.80 24.60 621.90 469.10 1.80 467.20 152.80 296.00 1683.10 1368.60 423.60 323.50 621.50 222.80 91.70 970.60 639.40 0.40 639.10 331.20 712.50 0.70 -4.60 -1.10 1.30 -4.60 26.00 -293.30 15.50 -164.80 62.00 -2.20 39.50 0.60 -8.60 43.80 1.10 -9.90 36.10 -364,70 -29.30 -521.00 44.20 4.00 23.00 1.70 2.10 60.70 0.70 2.50 9.20 158.50 36.20 24.90 37.10 11.90 67.10 2.10 1.40 1.60 0.60 3.40 7.50 89.70 0.70 31.30 25.70 0.80 63.40 Bottom Quartile (25%) Lower Middle (25%) Upper Middle (25%) Top Quartile (25%) Number of Businesses Revenue Range: Low Value (5000) High Value (5000) 30 110 110 368 368 1423 1423 5000 66.10 64.90 1.20 24.70 0.20 24.20 2.30 2.10 43.70 13.90 4.40 0.80 2.30 7.30 1.10 2.20 0.40 0.00 1.50 9.80 68.40 -2.20 218.40 186.40 32.10 104.00 25.30 78.90 7.40 7.60 108.00 35.10 8.60 2.60 6.80 19.90 0.20 4.40 4.20 0.20 4.80 21.10 212.00 6.40 729.00 655.40 73.60 412.50 161.30 259.00 70.40 78.30 209.50 100.10 13.90 2.10 13.70 31.50 1.80 10.90 3.50 2.50 4.80 24.60 621.90 107.10 2438.00 2435.50 2.40 1809.80 695.90 1139.50 290.10 315.70 622.90 255.50 30.90 15.10 24.00 83.80 8.50 47.50 24.10 15.90 16.20 101.50 2432.80 5.20 REVENUES AND EXPENSES Total revenue Sales of goods and services All other revenues Cost of sales (direct expenses) Wages and benefits Purchases, materials and sub-contracts Opening Inventory Closing inventory Operating expenses (indirect expenses) Labour and commissions Amortization and depletion Repairs and maintenance Utilities and telephone/telecommunication Rent Interest and bank charges Professional and business fees Advertising and promotion Delivery, shipping and warehouse expenses Insurance Other expenses Total expenses Net profit/loss BALANCE SHEET Total assets Total current assets Accounts receivable Closing inventory Other current assets Net tangible and intangible assets All other assets and adjustments Total liabilities Total current liabilities Current bank loans Other current liabilities Long term liabilities Total equity FINANCIAL RATIOS Current ratio Debt to equity ratio Interest coverage ratio Debt ratio Revenue to equity ratio Revenue to closing inventory ratio Current debt to equity (%) Net profit to equity (%) Net fixed assets to equity (%) Gross margin (%) Return on total assets (%) Collection period for accounts receivable (days) 52.60 28.70 7.20 2.50 19.00 23.90 0.00 67.00 42.50 0.00 42.50 24.50 -14.50 166.70 49.60 13.70 6.00 29.90 114.70 2.40 188.70 80.30 18.90 61.30 108.40 -22.00 917.90 819.50 134.00 79.20 606.30 73.80 24.60 621.90 469.10 1.80 467.20 152.80 296.00 1683.10 1368.60 423.60 323.50 621.50 222.80 91.70 970.60 639.40 0.40 639.10 331.20 712.50 0.70 -4.60 -1.10 1.30 -4.60 26.00 -293.30 15.50 -164.80 62.00 -2.20 39.50 0.60 -8.60 43.80 1.10 -9.90 36.10 -364.70 -29.30 -521.00 44.20 4.00 23.00 1.70 2.10 60.70 0.70 2.50 9.20 158.50 36.20 24.90 37.10 11.90 67.10 2.10 1.40 1.60 0.60 3.40 7.50 89.70 0.70 31.30 25.70 0.80 63.40