case study
xlsx
keyboard_arrow_up
School
Fanshawe College *
*We aren’t endorsed by this school
Course
1031
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
32
Uploaded by SuperHumanOstrichMaster911
Do the work IN THIS ORDER !!!
Marks
1) Do income statements for
2020
6
2) Do Balance Sheets for
2020
6
3) Do a pro forma Income Statement for
2021
8
4) Do a pro forma Balance Sheet for
2021
8
5) Do Cash Flow Statement for
2020
10
6) Do ratios for
2019
2020
10
7) Do pro forma Ratios for
2021
5
8) Do a pro forma cash budget for
2021
18
9) Do breakeven questions for 2020
2021
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.
2020 Data
YilmazDavid1019715
2020
Accounts payable
$ 1,032,252 Accounts receivable
$ 486,069 Amortization expense
$ 38,000 Beginning Inventory
$ 760,000 Cash
$ 199,269 Common stock
$ 100,000 Ending Inventory
$ 1,016,201 Freight In
$ 39,660 Interest expense
$ 63,401 GIC's
$ 300,000 Mortgage payable
$ 911,115 Net Purchases
$ 3,000,452 Net Sales
$ 5,267,915 Notes payable
$ 200,000 Prepaid expenses
$ 42,089 Plant and Equipment
$ 3,900,000 Salaries
$ 690,418 Utilities
$ 2,879 Insurance
$ 2,787 Transport
$ 20,694 Repairs & Maintenance
$ 9,585 Advertising
$ 26,810 Misc. Expense
$ 49,701 Direct Wages and Expenses
$ 1,185,500 Comon Stock Dividends
$ 50,000 1019715
2019
YilmazDavid1019715
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
2020
2019
2021
Common Stock
400000 shares
400000 shares
400000 shares
Notes Payable
current
Sales on Credit
90% percent of net sales
Share Price
2019
$ 1.60 per share
Share Prices based on accounting department's esti
Share Price
2020
$ 2.75 per share
The directors have decided that no new shares will be issued/sold in 2021
Tax rate
40% Of Net Income
Taxes on the year's profits are paid in December
Amortization Expense
4% declining balance
imates.
Accounts payable
1032252
Accounts receivable
486068.65
Amortization expense
38000
Beginning Inventory
760000
Cash
199268.65
Common stock
100000
Ending Inventory
1016201
Freight In
39660
Interest expense
63401
GIC's
300000
Mortgage payable
911115
Net Purchases
3000452
Net Sales
5267915
Notes payable
200000
Prepaid expenses
42089
Plant and Equipment
3900000
Salaries
690417.92
Utilities
2879.1
Insurance
2786.64
Transport
20694.36
Repairs & Maintenance
9584.55
Advertising
26810.34
Misc. Expense
49701.26
Direct Wages and Expenses
1185500
Comon Stock Dividends
50000
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
2021 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 2020
Accounts receivable
12% increase
Ending Inventory
950000
Prepaid expenses
Same as 2020
Accounts payable
914000
Notes payable
Same as 2020
Income Tax on Profits
40%
Annual Interest on Note Payable
8% paid quarterly on the balance at t
Quarterly = March, June, September, Decem
All increases effective Jan 1 2021
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 eve
Direct wages & expenses fluctuate in the same proportion as your sales, in the 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 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:
2020
2021
2022
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
the beginning of the year (ie on last year's closing balance)
mber
mber, October
enly among the months
same month as the sales
UT one month before.
number !
Principa
l
Principa
l
Principa
l
Fanshawe Furniture Manufactur
Comparative Income Statemen
2020
2019
1019715
Net Sales
$ 5,267,915 $ 4,321,090 Less: Cost of Sales
$ 3,969,411 75.4%
$ 3,338,881 77.3%
Gross profit
$ 1,298,504 24.6%
$ 982,209 22.7%
Salaries
$ 690,418 13.1%
$ 562,752 13.0%
Utilities
$ 2,879 0.1%
$ 2,805 0.1%
Insurance
$ 2,787 0.1%
$ 2,688 0.1%
Transport
$ 20,694 0.4%
$ 19,506 0.5%
Repairs & Maintenance
$ 9,585 0.2%
$ 9,111 0.2%
Advertising
$ 26,810 0.5%
$ 26,267 0.6%
Misc. Expense
$ 49,701 0.9%
$ 46,871 1.1%
Depreciation Expense
$ 38,000 0.7%
$ 50,000 1.2%
Total Operating Expenses:
$ 840,874 16.0%
$ 720,000 16.7%
Operating profit (EBIT)
$ 457,630 8.7%
$ 262,209 6.1%
Interest expense
$ 63,401 1.2%
$ 65,954 1.5%
Earnings before taxes
$ 394,229 7.5%
$ 196,255 4.5%
Income Tax
$ 157,692 3.0%
$ 78,502 1.8%
Earnings After Taxes
$ 236,537 4.5%
$ 117,753 2.7%
Common stock dividends
$ 50,000 0.9%
$ 40,000 0.9%
Change in Retained Earnings
$ 186,537 3.5%
$ 77,753 1.8%
1019715
1019715
Cost of Sales Calculation
1019715
1019715
2020
2019
Beginning Inventory
$ 760,000 14.4%
$ 625,000 14.5%
Net Purchases
$ 3,000,452 57.0%
$ 2,305,267 53.3%
Freight In
$ 39,660 0.8%
$ 33,114 0.8%
Direct Wages & Expenses
$ 1,185,500 22.5%
$ 1,135,500 26.3%
Cost of Goods Available for Sale
$ 4,985,612 94.6%
$ 4,098,881 94.9%
Ending Inventory
$ 1,016,201 19.3%
$ 760,000 17.6%
Cost of Sales
$ 3,969,411 75.4%
$ 3,338,881 77.3%
Common Shares Outstanding
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
ring
nts
2021
$ 5,900,065 $ 4,726,229 80.1%
$ 1,173,836 19.9%
$ 711,130 12.1%
$ 2,951 0.1%
$ 2,870 0.0%
$ 21,936 0.4%
$ 9,776 0.2%
$ 22,810 0.4%
$ 48,707 0.8%
$ 37,080 0.6%
$ 857,262 14.5%
$ 316,574 5.4%
$ 67,843 1.1%
$ 248,731 4.2%
$ 99,492 1.7%
$ 149,239 2.5%
$ 70,000 1.2%
$ 79,239 1.3%
2021
$ 1,016,201 17.2%
$ 3,300,497 55.9%
$ 43,626 0.7%
$ 1,315,905 22.3%
$ 5,676,229 96.2%
$ 950,000 16.1%
$ 4,726,229 80.1%
400,000
Fanshawe Furniture Manufacturing
Comparative Balance Sheets
2020
2019
2021
Current Assets
1019715
Cash
$ 199,269 6.7% $ 235,000 9.1%
GIC's
$ 300,000 10.2% $ 250,000 9.6%
300,000
Accounts receivable
$ 486,069 16.4% $ 372,800 14.4%
544,397
Ending Inventory
$ 1,016,201 34.4% $ 760,000 29.3%
950,000
Prepaid expenses
$ 42,089 1.4% $ 28,000 1.1%
42,089
Total Current Assets
$ 2,043,627 69.1% $ 1,645,800 63.4%
1,836,486
Capital Assets
Plant and equipment $ 3,900,000 132.0% $ 3,900,000 150.2%
3,930,000
Less: Accum. Depreciation
$ 2,988,000 101.1% $ 2,950,000 113.6%
3,025,080
Net plant and equipment
$ 912,000 30.9% $ 950,000 36.6%
904,920
1019715
###
1019715
Total assets
$ 2,955,627 $ 2,595,800 2,741,406
Liabilities and Owner's Equity
1019715
Current Liabilities
Accounts payable
$ 1,032,252 34.9% $ 776,051 29.9%
914,000
Notes payable
$ 200,000 6.8% $ 250,000 9.6%
200,000
Long Term Liabilities
Mortgage payable
$ 911,115 30.8% $ 944,026 36.4%
885,091
Total Liabilities
$ 2,143,367 72.5% $ 1,970,077 75.9%
1,999,091
Shareholders' Equity
1019715
Common stock
$ 100,000 3.4% $ 100,000 3.9%
100,000
Retained earnings
$ 712,260 24.1% $ 525,723 20.3%
791,499
Total shareholders' equity
$ 812,260 27.5% $ 625,723 24.1%
891,499
Total liabilities and
shareholders' equity
$ 2,955,627 $ 2,595,800 2,890,590
149,185 Cash Plug
10.9%
19.9%
34.7%
1.5%
67.0%
143.4%
110.3%
33.0%
33.3%
7.3%
32.3%
72.9%
3.6%
28.9%
32.5%
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
Fanshawe Furniture Manufacturing
Cash Flow Statement
For the Year Ended December 31, 2020
Operating Activities
Net Income (earnings after taxes)
$236,537
Add Amortization
$38,000
Cash Flow from operations
$274,537
Changes in non cash working capital
1019715
Increase in Accounts Receivable
(113,269)
Increase in GIC's
(50,000)
Increase in Inventory
(256,201)
Increase in Prepaid Expenses
(14,089)
Decrease in Notes Payable
(50,000)
Increase in Accounts Payable
256,201 Net Change in non cash working capital
(227,358)
Cash provided by (used in) operating activities
$47,180
Investing Activities
1019715
Increase in plant and equipment
$0
Cash provided by (used in) investing activities
$0
Financing Activities
1019715
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:
1019715
(35,731)
Plus: Cash Beginning of year
$235,000
Cash end of year
$199,269
Cash As per Balance Sheet
$199,269
2020
Current Ratio
Current Assets
1.66
Current Liabilities
Quick Ratio
Current Assets-Inventory
0.83
Current Liabilities
Inventory Turns
CoS
4.47
Avg Inventory
Gross Margin %
Net Sales-CoS
24.6%
Net Sales Net Profit Margin %
Net Profit
4.5%
Net Sales
Return on Equity
Net Profit
29%
Shareholder's Equity
Accounts Payable Period
Accounts Payable
125.57 Average daily purchases
Average Collection Period
Accounts Receivable
37.4
Average daily credit sales
1019715
Interest Coverage
EBIT
7.2
Interest
Debt Coverage
EBIT + Current portion of LTD
5.5
Interest + Current portion of LTD
1019715
1019715
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
2019
2021
1.60
1.78
0.86
0.93
4.82
4.81
22.7%
19.9%
2.7%
2.5%
19%
17%
122.87
101.08 35.0
37.4
4.0
4.7
3.1
3.6
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
Fanshawe Furniture Manufacturing
Breakeven Calculations
2020
2021
Gross Margin
25%
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:
$ 1,000,000 $7,468,262
$9,335,178
Complete the Theory Problem in space below
For a company to profit, they need to pass the point where their income is higher than expenses. The point when these two are equal is called Breakeven. This tells the compan
many units or dollars should be sold to make a profit. Breakeven is calculated by dividing
Cost by Gross Margin. The lower a Breakeven point is, the easier it is for the company to pr
is an easier target to reach. Therefore, to get the lowest Breakeven value, a low Fixed Co
high Gross Margin are preferred. Using Fixed Costs and Gross Margin given in SME Re
337213 dollars, we can calculate the Breakeven of Wood Office Furniture. Until Upper M
Wood Office had a lower monthly Breakeven value. Once the values of Upper Middle com
play, the companies Breakeven starts going up significantly as Gross margin drops and Costs increase. Therefore, when we compare the Breakeven values for Fanshawe Furnitu
Wood Office Furniture, Fanshawe is in a better condition. The reason is being that Fans
Furniture can reach its Breakeven point faster and start making a profit before Wood O
Furniture. On the other hand, just because Fanshawe is doing better regarding Breakeve
does not mean that they are doing good as a company. During their transaction from the 20
year to 2020, they have a dramatic increase in their Net Profit Margin and Return of Eq
Unfortunately, during the transition to 2021, these values dropped to even lower than wha
were in 2019. On top of it, their Debt Coverage is getting close to 1.5, which is a really bad the future, if Fanshawe Furniture does not want its values to go up to be the same as Offic
Furniture, they could increase the price of products or decrease variable costs.
62.00
44.20
37.10
$ 68.40 $ 212.00 $ 621.90 quarterly breakeven
$ 110.32 $ 479.64 $ 1,676.28 monthly breakeven
$ 36.77 $ 159.88 $ 558.76 Annual breakeven
$ 11,732.39 Bottom
Quartile
(25%)
Lower
Middle
(25%)
Upper
Middle
(25%)
their ny how g Fixed rofit, as it ost and eport Middle, me into Fixed ure and shawe Office en point 019 fiscal quity. hat they value. In ce Wood
25.70
$ 2,432.80 $ 9,466.15 $ 3,155.38 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
Fanshawe Furniture Manufac
Nov
Dec
January
February
March
April
May
June
July
Inflows
8.0%
4.0%
4.0%
4.0%
4.0%
4.0%
4.0%
4.0%
4.0%
Total Sales
$ 421,433 $ 210,717 $ 236,003 $ 236,003 $ 236,003 $ 236,003 $ 236,003 $ 236,003 $ 236,003 Credit Sales
$ 379,290 $ 189,645 $ 212,402 $ 212,402 $ 212,402 $ 212,402 $ 212,402 $ 212,402 $ 212,402 Cash Sales
$ 42,143 $ 21,072 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 $ 23,600 Collections Current month
$ 21,240 $ 21,240 $ 21,240 $ 21,240 $ 21,240 $ 21,240 $ 21,240 Collections 2nd month
$ 75,858 $ 84,961 $ 84,961 $ 84,961 $ 84,961 $ 84,961 $ 84,961 Collections 3rd month
Insurance Insurance $ 189,645 $ 94,822 $ 106,201 $ 106,201 $ 106,201 $ 106,201 $ 106,201 Total Inflows
$ 310,343 $ 224,624 $ 236,003 $ 236,003 $ 236,003 $ 236,003 $ 236,003 Outflows
Purchases
$ 120,018 $ 132,020 $ 132,020 $ 132,020 $ 132,020 $ 132,020 $ 132,020 $ 132,020 $ 660,099 Cash Purchases
Paid 1st month
Paid 2nd Month
$ 120,018 $ 132,020 $ 132,020 $ 132,020 $ 132,020 $ 132,020 $ 132,020 Direct Wages & Exp $ 1,185,500 $ 52,636 $ 52,636 $ 52,636 $ 52,636 $ 52,636 $ 52,636 $ 52,636 Freight-in
$ 39,660 $ 1,745 $ 1,745 $ 1,745 $ 1,745 $ 1,745 $ 1,745 $ 8,725 Mortgage Principal
$ 26,024 $ 2,110 $ 2,121 $ 2,131 $ 2,142 $ 2,152 $ 2,163 $ 2,174 Mortgage Interest
$ 51,843 $ 4,379 $ 4,368 $ 4,358 $ 4,347 $ 4,337 $ 4,326 $ 4,315 Notes Interest
$ 16,000 $ 4,000 $ 4,000 Utilities
$ 2,951 $ 246 $ 246 $ 246 $ 246 $ 246 $ 246 $ 246 Insurance
$ 2,870 Insurance
Insurance
$ 239 $ 239 $ 239 $ 239 $ 239 $ 239 $ 239 Transport
$ 21,936 $ 1,828 $ 1,828 $ 1,828 $ 1,828 $ 1,828 $ 1,828 $ 1,828 Repairs and Maint
$ 9,776 $ 815 $ 815 $ 815 $ 815 $ 815 $ 815 $ 815 Advertising
$ 22,810 $ 1,901 $ 1,901 $ 1,901 $ 1,901 $ 1,901 $ 1,901 $ 1,901 Misc Expense
$ 48,707 $ 4,059 $ 4,059 $ 4,059 $ 4,059 $ 4,059 $ 4,059 $ 4,059 Salaries
$ 711,130 $ 59,261 $ 59,261 $ 59,261 $ 59,261 $ 59,261 $ 59,261 $ 59,261 Taxes
$ 99,492 $ 157,692 Dividends
$ 70,000 71069
71069
Capital Investments
$ 30,000 Total Outflows
$ 249,237 $ 261,238 $ 265,238 $ 261,238 $ 261,238 $ 295,238 $ 268,219 Net Cash Flow
$ 61,107 (36,615) (29,236) (25,236) (25,236) (59,236) (32,216)
Cash Balance
$199,269
$ 260,375 $ 223,761 $ 194,525 $ 169,289 $ 144,053 $ 84,817 $ 52,601 Net Sales:
$ 5,900,065 2021
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% collections current month
A/R Collected
40% collections 2nd month
A/R Collected
50% collections 3rd month
Cash Purchases
0% Cash purchases
A/P Paid
0% Paid 1st month
A/P Paid
100% Paid 2nd month
Net Purchases
$ 3,000,452 2020
Net Purchases
$ 3,300,497 2021
Freight in $ 43,626 2021
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
cturing Cash Budget
August
Sept
Oct
Nov
Dec
Total
20.0%
20.0%
20.0%
8.0%
4.0%
100.0%
$ 1,180,013 $ 1,180,013 $ 1,180,013 $ 472,005 $ 236,003 $ 5,900,065 $ 1,062,012 $ 1,062,012 $ 1,062,012 $ 424,805 $ 212,402 $ 5,310,058 $ 118,001 $ 118,001 $ 118,001 $ 47,201 $ 23,600 $ 590,006 $ 106,201 $ 106,201 $ 106,201 $ 42,480 $ 21,240 $ 531,006 $ 84,961 $ 424,805 $ 424,805 $ 424,805 $ 169,922 $ 2,114,920 $ 106,201 $ 106,201 $ 531,006 $ 531,006 $ 531,006 $ 2,620,893 $ 415,365 $ 755,208 $ 1,180,013 $ 1,045,491 $ 745,768 $ 5,856,826 $ 660,099 $ 660,099 $ 264,040 $ 132,020 $ 132,020 $ 3,552,535 $ 132,020 $ 660,099 $ 660,099 $ 660,099 $ 264,040 $ 3,288,495 $ 263,181 $ 263,181 $ 263,181 $ 105,272 $ 52,636 $ 1,315,905 $ 8,725 $ 8,725 $ 3,490 $ 1,745 $ 1,745 $ 43,626 $ 2,184 $ 2,195 $ 2,206 $ 2,217 $ 2,228 $ 26,024 $ 4,304 $ 4,294 $ 4,283 $ 4,272 $ 4,261 $ 51,843 $ 4,000 $ 4,000 $ 16,000 $ 246 $ 246 $ 246 $ 246 $ 246 $ 2,951 $ 239 $ 239 $ 239 $ 239 $ 239 $ 2,870 $ 1,828 $ 1,828 $ 1,828 $ 1,828 $ 1,828 $ 21,936 $ 815 $ 815 $ 815 $ 815 $ 815 $ 9,776 $ 1,901 $ 1,901 $ 1,901 $ 1,901 $ 1,901 $ 22,810 $ 4,059 $ 4,059 $ 4,059 $ 4,059 $ 4,059 $ 48,707 $ 59,261 $ 59,261 $ 59,261 $ 59,261 $ 59,261 $ 711,130 $ 99,492 $ 99,492 $ 70,000 $ 70,000 $ 30,000 $ 478,763 $ 1,010,843 $ 1,001,608 $ 841,954 $ 566,751 $ 5,761,567 (63,399) (255,635)
$ 178,405 $ 203,537 $ 179,017 $ 95,259 (10,797) (266,432) (88,027)
$ 115,510 $ 294,528
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
Related Questions
1. What items are typically submitted as part of the budget or annual plan?
Marketing plan
Capital plan
Employee plan
Both A & B
arrow_forward
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
arrow_forward
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…
arrow_forward
Q10) Capital budgeting involves ____________ decisions in purchasing ____________ assets.
Group of answer choices
a) investment; current
b) investment; fixed
c) financing; current
d) financing; fixed
arrow_forward
A company is planning to prepare Budget for the year 2022. In the budgeting and planning process, which one of the following should be completed first?
a. Cost management plan
b. Financial budget
C.Sales budget
d. Strategic plan
arrow_forward
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
arrow_forward
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)
::::
::::
arrow_forward
Briefly (5-10) lines) give a written amswer to the following question:
What function does an annual budget serve as a part of a company's performance measurement system and how can a budget be used to encourage goal congruence (or 'alignment')?
arrow_forward
Select each of the terms with the best description of its purpose.
Definitions
Terms
1.
Planning future business actions and expressing them as formal plans.
2.
A comprehensive business plan that includes operating, investing, and financing budgets.
3.
Employees who will be evaluated by a budget help prepare it.
4.
Shows expected cash inflows and outflows and helps determine financing needs.
5.
An approach that requires all expenses to be justified for each new budget.
6.
A formal statement of future plans, usually expressed in monetary terms.
7.
Approach in which top management passes down a budget without employee input.
8.
Management's use of budgets to see that planned objectives are met.
arrow_forward
The "Cash Budget"
a)is used to predict future surpluses & shortages of cash, allowing the organization to plan ahead for such occurrences
b)differs from the Master Budget due to the accrual concept
c)uses the Master & Capital budgets for input
d)all of the listed answers are correct
arrow_forward
When preparing the cash budget,the repayment of loans would be found in which section?
A.financing activitiesB.operating activitiesC.investing activitiesD.cash flow statementE.liability statement
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- 1. What items are typically submitted as part of the budget or annual plan? Marketing plan Capital plan Employee plan Both A & Barrow_forwardA 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 abovearrow_forward1. 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…arrow_forward
- Q10) Capital budgeting involves ____________ decisions in purchasing ____________ assets. Group of answer choices a) investment; current b) investment; fixed c) financing; current d) financing; fixedarrow_forwardA company is planning to prepare Budget for the year 2022. In the budgeting and planning process, which one of the following should be completed first? a. Cost management plan b. Financial budget C.Sales budget d. Strategic planarrow_forwardI 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 Incorrectarrow_forward
- 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) :::: ::::arrow_forwardBriefly (5-10) lines) give a written amswer to the following question: What function does an annual budget serve as a part of a company's performance measurement system and how can a budget be used to encourage goal congruence (or 'alignment')?arrow_forwardSelect each of the terms with the best description of its purpose. Definitions Terms 1. Planning future business actions and expressing them as formal plans. 2. A comprehensive business plan that includes operating, investing, and financing budgets. 3. Employees who will be evaluated by a budget help prepare it. 4. Shows expected cash inflows and outflows and helps determine financing needs. 5. An approach that requires all expenses to be justified for each new budget. 6. A formal statement of future plans, usually expressed in monetary terms. 7. Approach in which top management passes down a budget without employee input. 8. Management's use of budgets to see that planned objectives are met.arrow_forward
- The "Cash Budget" a)is used to predict future surpluses & shortages of cash, allowing the organization to plan ahead for such occurrences b)differs from the Master Budget due to the accrual concept c)uses the Master & Capital budgets for input d)all of the listed answers are correctarrow_forwardWhen preparing the cash budget,the repayment of loans would be found in which section? A.financing activitiesB.operating activitiesC.investing activitiesD.cash flow statementE.liability statementarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you