MoustafaYoussef_1002519.xlsx

xlsx

School

Fanshawe College *

*We aren’t endorsed by this school

Course

1031

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

31

Uploaded by SuperHumanOstrichMaster911

Report
Do the work IN THIS ORDER !!! Marks 1) Do income statements for 2021 6 2) Do Balance Sheets for 2021 6 3) Do a pro forma Income Statement for 2022 8 4) Do a pro forma Balance Sheet for 2022 8 5) Do Cash Flow Statement for 2021 10 6) Do ratios for 2020 2021 10 7) Do pro forma Ratios for 2022 5 8) Do a pro forma cash budget for 2022 18 9) Do breakeven questions for 2021 2022 8 10) Do the theory problem below 20 Total 99 Theory Problem 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. This is worth 20 marks which means you should be comparing 10 sets of numbers and explaining why the numbers are different and whether they are better or worse.
MoustafaYoussef1002519
2021 Data MoustafaYoussef1002519 2021 Accounts payable $ 1,030,085 Accounts receivable $ 483,637 Amortization expense $ 38,000 Beginning Inventory $ 760,000 Cash $ 196,837 Common stock $ 100,000 Ending Inventory $ 1,014,034 Freight In $ 39,660 Interest expense $ 63,401 GIC's $ 250,000 Mortgage payable $ 911,115 Net Purchases $ 2,993,557 Net Sales $ 5,253,140 Notes payable $ 150,000 Prepaid expenses $ 42,089 Plant and Equipment $ 3,900,000 Salaries $ 688,452 Utilities $ 2,883 Insurance $ 2,791 Transport $ 20,698 Repairs & Maintenance $ 9,589 Advertising $ 26,814 Misc. Expense $ 49,705 Direct Wages and Expenses $ 1,185,500 Comon Stock Dividends $ 50,000 1002519 2020 MoustafaYoussef1002519
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Other Info 2021 2020 2022 Common Stock 400000 shares 400000 shares 400000 shares Notes Payable current Sales on Credit 90% percent of net sales Share Price 2020 $ 1.60 per share Share Prices based on accounting department's esti Share Price 2021 $ 2.75 per share The directors have decided that no new shares will be issued/sold in 2022 Tax rate 40% Of Net Income Taxes on the year's profits are paid in December Amortization Expense 4% declining balance
imates.
Accounts payable 1030085 Accounts receivable 483637.15 Amortization expense 38000 Beginning Inventory 760000 Cash 196837.15 Common stock 100000 Ending Inventory 1014034 Freight In 39660 Interest expense 63401 GIC's 250000 Mortgage payable 911115 Net Purchases 2993557 Net Sales 5253140 Notes payable 150000 Prepaid expenses 42089 Plant and Equipment 3900000 Salaries 688451.92 Utilities 2883.1 Insurance 2790.64 Transport 20698.36 Repairs & Maintenance 9588.55 Advertising 26814.34 Misc. Expense 49705.26 Direct Wages and Expenses 1185500 Comon Stock Dividends 50000 1002519 2020 MoustafaYoussef1002519
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2022 Projected Data Net Sales 12% increase Direct Wages & Expenses 11% increase Salaries 3.00% increase Utilities 2.50% increase Insurance 3.00% increase Transport 6.00% increase Repairs & Maintenance 2.00% increase Advertising $ 4,000 decrease Misc 2.00% decrease Freight-in 10.00% increase Net Purchases 10% increase Common Stock Dividends $ 20,000 increase Depreciation Expense 4.00% declining balance Capital purchases $ 30,000 new roof in June to be added to p Cash to be calculated on balance sheet GIC's Same as 2021 Accounts receivable 12% increase Ending Inventory 950000 Prepaid expenses Same as 2021 Accounts payable 914000 Notes payable Same as 2021 Income Tax on Profits 40% Annual Interest on Note Payable 8% paid quarterly on the balance at th Quarterly = March, June, September, Decem All increases effective Jan 1 2022 GIC's, Prepaids, and Notes payable need not be accounted for in cash budget For the Cash Budget: A/P and A/R payments are calculated as per bottom left of Cash Budget 20 per cent of your sales come in each of the following months: August, Septem 8% of sales are in November. For the rest of the year, the sales are divided even Direct wages & expenses fluctuate in the same proportion as your sales, in the s Your purchases and freight in fluctuate in the same proportion as your sales, BU Remember: The numbers you use will be unique to you based on your student n Dividends are paid in December, Income tax is paid in December. Unless otherwise indicated, operating expenses are the same each month.
Mortgage payments for the year: 2021 2022 2023 Interest Interest Interest 4,499.65 1,989.21 4,378.51 2,110.35 4,250.79 2,238.07 4,489.83 1,999.03 4,368.09 2,120.77 4,240.11 2,248.75 4,479.96 2,008.90 4,357.61 2,131.25 4,229.43 2,259.43 4,470.04 2,018.82 4,347.09 2,141.77 4,218.74 2,270.12 4,460.06 2,028.80 4,336.51 2,152.35 4,208.06 2,280.80 4,450.05 2,038.81 4,325.88 2,162.98 4,197.38 2,291.48 4,439.98 2,048.88 4,315.20 2,173.66 4,186.70 2,302.16 4,429.86 2,059.00 4,304.46 2,184.40 4,176.01 2,312.85 4,419.69 2,069.17 4,293.68 2,195.18 4,165.33 2,323.53 4,409.47 2,079.39 4,282.84 2,206.02 4,154.65 2,334.21 4,399.20 2,089.66 4,271.94 2,216.92 4,143.96 2,344.90 4,388.88 2,099.98 4,260.99 2,227.87 4,133.28 2,355.58 plant & equipment 53,336.67 24,529.65 51,842.80 26,023.52 50,304.45 27,561.87 he beginning of the year (ie on last year's closing balance) mber mber, October nly among the months same month as the sales UT one month before. number ! Principa l Principa l Principa l
1002519 Fanshawe Furniture Manufacturing Comparative Income Statements 2021 2020 2022 1002519 Net Sales $ 5,253,140 $ 4,321,090 $ 5,883,517 Less: Cost of Sales $ 3,964,683 75% $ 3,338,881 77% $ 4,716,478 Gross profit $ 1,288,457 25% $ 982,209 23% $ 1,167,039 Salaries $ 688,452 13% $ 562,752 13% $ 709,105 Utilities $ 2,883 0.1% $ 2,805 0.1% $ 2,955 Insurance $ 2,791 0.1% $ 2,688 0.1% $ 2,874 Transport $ 20,698 0.4% $ 19,506 0.5% $ 21,940 Repairs & Maintenance $ 9,589 0.2% $ 9,111 0.2% $ 9,780 Advertising $ 26,814 0.5% $ 26,267 0.6% $ 22,814 Misc. Expense $ 49,705 0.9% $ 46,871 1.1% $ 48,711 Depreciation Expense $ 38,000 0.7% $ 50,000 1.2% $ 37,080 Total Operating Expenses: $ 838,932 16% $ 720,000 17% $ 855,261 Operating profit (EBIT) $ 449,525 8.6% $ 262,209 6.1% $ 311,778 Interest expense $ 63,401 1.2% $ 65,954 1.5% $ 36,530 Earnings before taxes $ 386,124 7.4% $ 196,255 4.5% $ 275,248 Income Tax $ 154,450 2.9% $ 78,502 1.8% $ 110,099 Earnings After Taxes $ 231,674 4.4% $ 117,753 2.7% $ 165,149 Common stock dividends $ 50,000 1.0% $ 40,000 0.9% $ 70,000 Change in Retained Earnings $ 181,674 3.5% $ 77,753 1.8% $ 95,149 1002519 ### Cost of Sales Calculation 1002519 ### 2021 2020 2022 Beginning Inventory $ 760,000 14% $ 625,000 14% $ 1,014,034 Net Purchases $ 2,993,557 57% $ 2,305,267 53% $ 3,292,913 Freight In $ 39,660 0.8% $ 33,114 1% $ 43,626 Direct Wages & Expenses $ 1,185,500 23% $ 1,135,500 26% $ 1,315,905 Cost of Goods Available for Sale $ 4,978,717 95% $ 4,098,881 95% $ 5,666,478 Ending Inventory $ 1,014,034 19% $ 760,000 18% $ 950,000 Cost of Sales $ 3,964,683 75% $ 3,338,881 77% $ 4,716,478 Common Shares Outstanding 400,000 400,000 400,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
80.2% 19.8% 12.1% 0.1% 0.0% 0.4% 0.2% 0.4% 0.8% 0.6% 14.5% 5.3% 0.6% 4.7% 1.9% 2.8% 1.2% 1.6% 17% 56% 1% 22% 96% 16% 80%
Fanshawe Furniture Manufacturing Comparative Balance Sheets 1002519 2021 2020 2022 Current Assets 1002519 Cash $ 196,837 7% $ 235,000 9.1% 117,688 4% GIC's $ 250,000 9% $ 250,000 9.6% 250,000 9% Accounts receivable $ 483,637 17% $ 372,800 14.4% 541,674 19% Ending Inventory $ 1,014,034 35% $ 760,000 29.3% 950,000 34% Prepaid expenses $ 42,089 1% $ 28,000 1.1% 42,089 1% Total Current Assets $ 1,986,597 69% $ 1,645,800 63.4% 1,901,451 68% Capital Assets Plant and equipment $ 3,900,000 135% $ 3,900,000 150% 3,930,000 140% Less: Accum. Depreciation $ 2,988,000 103% $ 2,950,000 114% 3,025,080 108% Net plant and equipment $ 912,000 31% $ 950,000 37% 904,920 32% 1002519 1002519 Total assets $ 2,898,597 $ 2,595,800 2,806,371 Liabilities and Owner's Equity 1002519 Current Liabilities Accounts payable $ 1,030,085 36% $ 776,051 26.8% 914,000 33% Notes payable $ 150,000 5% $ 250,000 8.6% 150,000 5% Long Term Liabilities Mortgage payable $ 911,115 31% $ 944,026 32.6% 859,272 31% Total Liabilities $ 2,091,200 72% $ 1,970,077 68.0% 1,923,272 69% Shareholders' Equity 1002519 Common stock $ 100,000 3% $ 100,000 3.4% 120,000 4% Retained earnings $ 707,397 24% $ 525,723 18.1% 802,546 29% Total shareholders' equity $ 807,397 28% $ 625,723 21.6% 922,546 33% Total liabilities and shareholders' equity $ 2,898,597 $ 2,595,800 2,845,819
117688 Cash Plug
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1002519 Fanshawe Furniture Manufacturing Cash Flow Statement For the Year Ended December 31, 2021 Operating Activities Net Income (earnings after taxes) $231,674 Add Amortization $38,000 Cash Flow from operations $269,674 Changes in non cash working capital 1002519 Increase in Accounts Receivable -$110,837 Increase in GIC's $0 Increase in Inventory -$254,034 Increase in Prepaid Expenses -$14,089 Decrease in Notes Payable -$100,000 Increase in Accounts Payable $254,034 Net Change in non cash working capital -$224,926 Cash provided by (used in) operating activities $44,748 Investing Activities 1002519 Increase in plant and equipment $0 Cash provided by (used in) investing activities $0 Financing Activities 1002519 Decrease in Mortgage Payable -$32,911 Common Stock Dividends paid -$50,000 Cash provided by (used in) financing activities -$82,911 Net increase (decrease) in cash during the year: 1002519 -$38,163 Plus: Cash Beginning of year $235,000 Cash end of year $196,837 Cash As per Balance Sheet $196,837
1002519 2021 Current Ratio Current Assets 1.68 Current Liabilities Quick Ratio Current Assets-Inventory 0.82 Current Liabilities Inventory Turns CoS 4.47 Avg Inventory Gross Margin % Net Sales-CoS 24.5% Net Sales Net Profit Margin % Net Profit 4% Net Sales Return on Equity Net Profit 29% Shareholder's Equity Accounts Payable Period Accounts Payable 125.60 Average daily purchases Average Collection Period Accounts Receivable 37.3 Average daily credit sales 1002519 Interest Coverage EBIT 7.1 Interest Debt Coverage EBIT + Current portion of LTD 4.3 Interest + Current portion of LTD 1002519 1002519
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3
2020 2022 1.60 1.79 0.86 0.89 4.07 4.80 22.7% 19.8% 3% 3% 19% 18% 122.87 101.31 35.0 37.3 4.0 8.5 2.7 4.2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1002519 Fanshawe Furniture Manufacturing Breakeven Calculations 2021 2022 Gross Margin 25% 23% Fixed Expenses $800,932 $818,181 Annual Breakeven Sales $3,265,463.12 $3,599,472.35 Monthly Breakeven Sales $272,121.93 $299,956.03 Sales Required for a profit of: $ 1,000,000 $7,342,541 $7,998,831.34 Complete the Theory Problem in space below The current Ratio of Fanshawe is better than the benchmark in the past three years. Fansh a better position paying its short term debts when due using its current assets. In terms o margin , the benchmark is performing better than Fanshawe . This could be because to the cost of sales over the cost of sales for past three years. Interest cover ratio for the benchm higher compared to fanshawe, this means Fanshawe will have more difficult time in paying However people who invested in Fanshawe will get better return on equity as to Benchm Overall Fanshwe is doing good for itself and fanshawe is doing better than benchmar
hawe is in of gross e rise in mark is Interest. mark. rk.
MoustafaYoussef1002519 Fanshawe Furniture Manufa Nov Dec January February March April May June July Inflows 8% 4% 4% 4% 4% 4% 4% 4% 4% Total Sales 420,251 210,126 210,126 210,126 210,126 210,126 210,126 210,126 210,126 Credit Sales 378,226 189,113 189,113 189,113 189,113 189,113 189,113 189,113 189,113 Cash Sales 42,025 21,013 21,013 21,013 21,013 21,013 21,013 21,013 21,013 Collections Current month 18,911.30 18,911.30 18,911.30 18,911.30 18,911.30 18,911.30 18,911.30 Collections First month 75,645.22 75,645.22 75,645.22 75,645.22 75,645.22 75,645.22 75,645.22 Collections Second month Insurance Insurance 189113.04 94,556.52 94,556.52 94,556.52 94,556.52 94,556.52 94,556.52 Total Inflows 304,682 210,126 210,126 210,126 210,126 210,126 210,126 Outflows Purchases 119,742 119,742 131,717 131,717 131,717 131,717 131,717 131,717 658,583 Cash Purchases Paid 1st month Paid 2nd Month 119,742 119,742 131,717 131,717 131,717 131,717 131,717 Direct Wages & Exp 52,636 52,636 52,636 52,636 52,636 52,636 52,636 Freight-in $ 43,626 1,745 1,745 1,745 1,745 1,745 1,745 1,745 Mortgage Principal 51,832 4,379 4,368 4,347 4,347 4,337 4,326 4,315 Mortgage Interest 24,530 1,989 1,999 2,009 2,019 2,029 2,039 2,049 Notes Interest 12000 3,000 3,000 Utilities 2955 246 246 246 246 246 246 246 Insurance 2874 Insurance Insurance 240 240 240 240 240 240 240 Transport 21940 1,828 1,828 1,828 1,828 1,828 1,828 1,828 Repairs and Maint 9780 815 815 815 815 815 815 815 Advertising 22814 1,901 1,901 1,901 1,901 1,901 1,901 1,901 Misc Expense 48711 4,059 4,059 4,059 4,059 4,059 4,059 4,059 Salaries 688452 57,371 57,371 57,371 57,371 57,371 57,371 57,371 Taxes 110099 154,450 Dividends 70000 71069 71069 Capital Investments 30,000 Total Outflows 246,952 246,951 261,914 258,924 258,924 291,923 258,922 Net Cash Flow 57,730 - 36,826 - 51,789 - 48,799 - 48,798 - 81,797 - 48,797 Cash Balance $196,837 $254,567 $217,742 $165,953 $117,154 $68,356 -$13,441 -$62,238 Net Sales: $ 5,883,517 2022 Sales on Credit 90% A/P outstanding 0.0 days
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
### A/R Collected 10% current A/R Collected 40% 1 month A/R Collected 50% 2 months Cash Purchases 0% current A/P Paid 0% 1 month A/P Paid 100% 2 months Net Purchases $ 2,993,557 2021 Net Purchases $ 3,292,913 2022 Freight in $ 43,626 2022 paid current
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
acturing Cash Budget August Sept Oct Nov Dec Total 20% 20% 20% 8% 4% 100% 1,050,628 1,050,628 1,050,628 420,251 210,126 $ 5,253,140 945,565 945,565 945,565 378,226 189,113 $ 4,727,826 105,063 105,063 105,063 42,025 21,013 $ 525,314 94,556.52 94,556.52 94,556.52 37,822.61 18,911.30 $ 472,782.60 75,645.22 378,226.08 378,226.08 378,226.08 151,290.43 $ 75,645 94,556.52 94,556.52 472,782.60 472,782.60 472,782.60 $ 189,113 369,821 672,402 1,050,628 930,856 663,997 $ 5,253,140 658,583 658,583 263,433 131,717 3,292,913 $ 6,693,593 131,717 658,583 658,583 658,583 263,433 $ 3,268,964 263,181 263,181 263,181 105,272 52,636 $ 1,315,905 8,725 8,725 8,725 3,490 1,745 $ 43,626 4,304 4,294 4,283 4,272 4,261 $ 51,832 2,059 2,069 2,079 2,090 2,100 $ 24,530 3,000 3,000 $ 12,000 246 246 246 246 246 $ 2,955 240 240 240 240 240 $ 2,874 1,828 1,828 1,828 1,828 815 $ 20,927 815 815 815 815 1,901 $ 10,866 1,901 1,901 1,901 1,901 4,059 $ 24,972 4,059 4,059 4,059 4,059 4,059 $ 48,711 57,371 57,371 57,371 57,371 57,371 $ 688,452 110,099 $ 110,099 70,000 $ 70,000 $ 30,000 476,447 1,006,312 1,003,312 840,167 575,966 $ 5,726,715 - 106,626 - 333,910 47,316 90,689 88,031 -$ 473,575 -$168,864 -$502,774 -$455,458 -$364,769 -$276,738
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Number of Businesses Revenue Range: Low Value ($000) 30 110 High Value ($000) 110 368 REVENUES AND EXPENSES Total revenue 100.00 100.00 Sales of goods and services 98.10 85.30 All other revenues 1.90 14.70 Cost of sales (direct expenses) 37.30 47.60 Wages and benefits 0.30 11.60 Purchases, materials and sub-contracts 36.70 36.10 Opening Inventory 3.50 3.40 Closing inventory 3.20 3.50 Operating expenses (indirect expenses) 66.10 49.40 Labour and commissions 21.00 16.10 Amortization and depletion 6.70 3.90 Repairs and maintenance 1.20 1.20 Utilities and telephone/telecommunication 3.50 3.10 Rent 11.10 9.10 Interest and bank charges 1.60 0.10 Professional and business fees 3.40 2.00 Advertising and promotion 0.60 1.90 Delivery, shipping and warehouse expenses 0.00 0.10 Insurance 2.20 2.20 Other expenses 14.80 9.70 Total expenses 103.40 97.10 Net profit/loss -3.40 2.90 BALANCE SHEET Total assets 52.60 166.70 Total current assets 28.70 49.60 Accounts receivable 7.20 13.70 Closing inventory 2.50 6.00 Other current assets 19.00 29.90 Net tangible and intangible assets 23.90 114.70 All other assets and adjustments 0.00 2.40 Total liabilities 67.00 188.70 Total current liabilities 42.50 80.30 Current bank loans 0.00 18.90 Other current liabilities 42.50 61.30 Long term liabilities 24.50 108.40 Industry Canada | Industrie Canada Government of Canada | Gouvernement du Canada Bottom Quartile (25%) Lower Middle (25%)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total equity -14.50 -22.00 FINANCIAL RATIOS Current ratio 0.70 0.60 Debt to equity ratio -4.60 -8.60 Interest coverage ratio -1.10 43.80 Debt ratio 1.30 1.10 Revenue to equity ratio -4.60 -9.90 Revenue to closing inventory ratio 26.00 36.10 Current debt to equity (%) -293.30 -364.70 Net profit to equity (%) 15.50 -29.30 Net fixed assets to equity (%) -164.80 -521.00 Gross margin (%) 62.00 44.20 Return on total assets (%) -2.20 4.00 Collection period for accounts receivable (days) 39.50 23.00 Profile Provinces/Territory/Canada Ontario Incorporation Status Incorporated Businesses Distribution by Total revenue Value in Percentage Industry NAICS 337213 - Wood Office Furniture, including C Comparison Groups Upper Middle; Top Quartile Size of Firms Annual Revenues $30,000 - $5,000,000 Note Balance sheet information is only available for Inco Source: Statistics Canada - Small Business Profiles
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
368 1423 1423 5000 100.00 100.00 89.90 99.90 10.10 0.10 56.60 74.20 22.10 28.50 35.50 46.70 9.70 11.90 10.70 12.90 28.70 25.60 13.70 10.50 1.90 1.30 0.30 0.60 1.90 1.00 4.30 3.40 0.20 0.30 1.50 1.90 0.50 1.00 0.30 0.70 0.70 0.70 3.40 4.20 85.30 99.80 14.70 0.20 917.90 1683.10 819.50 1368.60 134.00 423.60 79.20 323.50 606.30 621.50 73.80 222.80 24.60 91.70 621.90 970.60 469.10 639.40 1.80 0.40 467.20 639.10 152.80 331.20 Upper Middle (25%) Top Quartile (25%) This is the percentages printout from the SME benchmarking. Also known as COMMON SIZE.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
296.00 712.50 1.70 2.10 2.10 1.40 60.70 1.60 0.70 0.60 2.50 3.40 9.20 7.50 158.50 89.70 36.20 0.70 24.90 31.30 37.10 25.70 11.90 0.80 67.10 63.40 Custom Architectural Woodwork, Manufacturing orporated Status.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Number of Businesses Revenue Range: Low Value ($000) 30 110 High Value ($000) 110 368 REVENUES AND EXPENSES Total revenue 66.10 218.40 Sales of goods and services 64.90 186.40 All other revenues 1.20 32.10 Cost of sales (direct expenses) 24.70 104.00 Wages and benefits 0.20 25.30 Purchases, materials and sub-contracts 24.20 78.90 Opening Inventory 2.30 7.40 Closing inventory 2.10 7.60 Operating expenses (indirect expenses) 43.70 108.00 Labour and commissions 13.90 35.10 Amortization and depletion 4.40 8.60 Repairs and maintenance 0.80 2.60 Utilities and telephone/telecommunication 2.30 6.80 Rent 7.30 19.90 Interest and bank charges 1.10 0.20 Professional and business fees 2.20 4.40 Advertising and promotion 0.40 4.20 Delivery, shipping and warehouse expenses 0.00 0.20 Insurance 1.50 4.80 Other expenses 9.80 21.10 Total expenses 68.40 212.00 Net profit/loss -2.20 6.40 BALANCE SHEET Total assets 52.60 166.70 Total current assets 28.70 49.60 Accounts receivable 7.20 13.70 Closing inventory 2.50 6.00 Other current assets 19.00 29.90 Net tangible and intangible assets 23.90 114.70 All other assets and adjustments 0.00 2.40 Total liabilities 67.00 188.70 Total current liabilities 42.50 80.30 Current bank loans 0.00 18.90 Other current liabilities 42.50 61.30 Long term liabilities 24.50 108.40 Industry Canada | Industrie Canada Government of Canada | Gouvernement du Canada Bottom Quartile (25%) Lower Middle (25%)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total equity -14.50 -22.00 FINANCIAL RATIOS Current ratio 0.70 0.60 Debt to equity ratio -4.60 -8.60 Interest coverage ratio -1.10 43.80 Debt ratio 1.30 1.10 Revenue to equity ratio -4.60 -9.90 Revenue to closing inventory ratio 26.00 36.10 Current debt to equity (%) -293.30 -364.70 Net profit to equity (%) 15.50 -29.30 Net fixed assets to equity (%) -164.80 -521.00 Gross margin (%) 62.00 44.20 Return on total assets (%) -2.20 4.00 Collection period for accounts receivable (days) 39.50 23.00 Profile Provinces/Territory/Canada Ontario Incorporation Status Incorporated Businesses Distribution by Total revenue Value in Thousands of dollars Industry NAICS 337213 - Wood Office Furniture, including C Comparison Groups Upper Middle; Top Quartile Size of Firms Annual Revenues $30,000 - $5,000,000 Note Balance sheet information is only available for Inco Source: Statistics Canada - Small Business Profiles
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
368 1423 1423 5000 729.00 2438.00 655.40 2435.50 73.60 2.40 412.50 1809.80 161.30 695.90 259.00 1139.50 70.40 290.10 78.30 315.70 209.50 622.90 100.10 255.50 13.90 30.90 2.10 15.10 13.70 24.00 31.50 83.80 1.80 8.50 10.90 47.50 3.50 24.10 2.50 15.90 4.80 16.20 24.60 101.50 621.90 2432.80 107.10 5.20 917.90 1683.10 819.50 1368.60 134.00 423.60 79.20 323.50 606.30 621.50 73.80 222.80 24.60 91.70 621.90 970.60 469.10 639.40 1.80 0.40 467.20 639.10 152.80 331.20 Upper Middle (25%) Top Quartile (25%)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
296.00 712.50 1.70 2.10 2.10 1.40 60.70 1.60 0.70 0.60 2.50 3.40 9.20 7.50 158.50 89.70 36.20 0.70 24.90 31.30 37.10 25.70 11.90 0.80 67.10 63.40 Custom Architectural Woodwork, Manufacturing orporated Status.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Discussion 7 (CH).docx
Chapter Eight Quiz.docx
Discussion 2 (CH).docx
CJ 310 Module Three Practice Activity.docx
CJ 310 Project One Course Hero Upload.docx
BasaulaBigyan1174967.xlsx
finaproject.xlsx
case study.xlsx
ACC 410 Critical Assignment(1).xlsx
Treas K Communications Case.docx
ACCT3708 - Tutorial Questions Week 7 - Term One 2024 (1).docx
FNSACC414 Prepare financial statements for non reporting entities.pdf
Related Questions
A cash flow budget can be used to   A.    estimate when and how much money will need to be borrowed                   during the year     B.    estimate when and how much debt can be repaid during the year   C.    estimate when excess cash may be available so plans can be made to           invest it    D.   all of the above
Order the following terms and operations to create the formula for the combined cash budget (before any financing is considered). E Beginning Cash Balance | Cash Payments 4 : Cash Collections Ending Cash Balance (before Financing) :::: ::::
1. What items are typically submitted as part of the budget or annual plan?  Marketing plan  Capital plan  Employee plan  Both A & B
I have a finance team at work. As the year progresses, they need to maintain a record of cash flow and expenditure. What will they be required to do as a first step to building a budget? Question 1Select one: A. Find out the balance sheet of the company B. Find the profit and loss for the previous year C. Identify the expenditure and demand along with the cash flow of the company D. Build an income and expenditure statement Incorrect
1. What do you understand by a project budget? Please outline the steps needed to prepare a project budget and indicate the types of costs associated with budgets.  2. Prepare a multi-year budget for a project for a period of 3 years (2020-2022) in an Excel worksheet incorporating the following information.  Please upload your excel document. 3. Please prepare a consolidated budget pivot table in Excel by budget class and year.  Please upload your excel document. Budget Class – Staff Costs • Salary of the Project Manager @ USD 5,000 per month. • Salary of the Admin Finance Officer @ USD 3,500 per month. • Salary of Admin. & Finance Assistant @USD 1,000 per month • Salary of Driver @USD 500 per month Budget Class – Equipment & Furniture Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project. Budget Class – Operating Costs (training) Two trainers are required for each training. Each…
7. Consider the following table for the cash flows of an investment account: Time mm/dd/yy 01/01/2015 04/01/2015 08/01/2015 12/31/2015 Contribution -300 +2,000 (a) Calculate the TWRR and the DWRR of the fund. (b) Comment on the results. Fund value before contribution 1,000 500 250 2,800
Ma  Please answer fast
Explain why it would be beneficial to prepare a cash forecast, or a cash budget, for an organization. (4 sentences)
Which of the following accounts would appear on a budgeted balance sheet? Multiple Cholce All of the choices are correct. Income tax expense. Accounts receivable. Sales commissions. Depreciation expense.
4
What is the total amount of additional funding which the firm plans to take on in the year 2020? FIN401 - Ch.12 Problems Problem 12-9: Garlington Tech S24 Variant Balance Sheet Cash Receivables Inventory Total Current Assets Net Fixed Assets Total Assets Accounts Payable Line of Credit Accruals Total Current Liabilities Long-term Bonds Common Stock Retained Earnings Total Liabilities & Equity AFN (external) Cumulative AFN Income Statement Final Projection 12/31/2019 12/31/2020 160,000.00 184,000 360,000.00 387,000 720,000.00 828,000 1,240,000.00 1,399,000 4,000,000.00 4,600,000 5,240,000.00 5,999,000 360,000.00 414,000 148,954.27 200,000.00 230,000 560,000.00 792,954 1,000,000.00 1,000,000 1,100,000.00 1,248,954 2,580,000.00 2,957,091 5,240,000.00 5,999,000 0.00 297,908.55 Final Projection 12/31/2019 12/31/2020 Sales Operating Costs 4,000,000.00 4,600,000.00 3,200,000.00 3,680,000.00 EBIT Interest EBT 800,000.00 920,000.00 120,000.00 137,874.51 680,000.00 782,125.49 Taxes (25) Net…
KA. Please answer fast
Item 1 Which of the following is a budget used to project cash flow and likely cash shortfalls and/or surpluses? Multiple Choice Financing budget Master budget Rolling budget Operational budget Capital budget
Only use Excel please and take a screenshot
Haha
A plan that shows the expected cash inflows and cash outflows during the budget period, including receipts from loans needed to maintain a minimum cash balance and repayments of such loans, is called a. A rolling budget. d. A cash budget. b. An income statement. e. An operating budget. c. A balance sheet.
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Entrepreneurial Finance
Finance
ISBN:9781337635653
Author:Leach
Publisher:Cengage
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
SEE MORE TEXTBOOKS
Related Questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Entrepreneurial Finance
Finance
ISBN:9781337635653
Author:Leach
Publisher:Cengage
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
SEE MORE TEXTBOOKS