Empire_Students_F23 (2)
xlsx
keyboard_arrow_up
School
University of Waterloo *
*We aren’t endorsed by this school
Course
373
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
22
Uploaded by BrigadierTitaniumTrout16
EXHIBIT 1 - EMPIRE COMPANY LTD. FINANCIAL STATEMENTS
Empire Company Ltd.
Consolidated Balance Sheet
April 30
(in thousands of dollars)
1998
1997
Assets
Current Assets
Cash
$ 28,268 $ 32,185 Receivables
89,153 78,701 Inventories
197,650 194,126 Prepaid Expenses
15,319 14,100 Investments, at cost (quoted market value $246,418; 1997 $211,468)
156,388 148,746 486,778 467,858 Investments, at equity (quoted market value $800,436; 1997 $575,133)
325,579 300,447 Current assets and marketable investments
812,357 768,305 Fixed assets
1,069,026 1,001,873 Other assets
25,850 27,193 $ 1,907,233 $ 1,797,371 Liabilities and Shareholders' Equity
Current Liabilities
Bank loans and notes payable
$ 286,532 $ 239,757 Payables and accruals
338,774 298,550 Income taxes payable
9,712 11,462 Long term debts due within one year
24,222 89,702 659,240 639,471 Long term debt
616,571 606,843 Minority interest
- 171 Deferred income taxes
73,083 71,336 1,348,894 1,317,821 Shareholders' Equity
Capital stock
229,889 234,130 Retained earnings
305,422 228,254 Foreign currency translation
23,028 17,166 558,339 479,550 $ 1,907,233 $ 1,797,371 Source: Empire Company Limited Annual Report, 1998
EXHIBIT 1 - EMPIRE COMPANY LTD. FINANCIAL STATEMENTS
Empire Company Ltd.
Consolidated Income Statement
April 30
(in thousands of dollars)
1998
1997
Revenue
$ 3,320,000 $ 3,149,773 Cost of sales, selling and administrative expenses
3,127,112 2,971,925 192,888 177,848 Depreciation
70,404 65,433 122,484 112,415 Investment income
41,253 35,568 Operating income
163,737 147,983 Interest expense
Long term debt
64,340 70,512 Short term debt
12,328 8,746 76,668 79,258 87,069 68,725 Gain on sale of investments and properties
6,524 1,447 93,593 70,172 Gain on sale of investment in Jannock Limited
35,868 - Share of asset impairment provision by equity accounted investment (8,788)
- 120,673 70,172 Income taxes
Sale of investment in Jannock Limited
7,792 - Other operations
25,092 16,930 32,884 16,930 Minority interest
7 363 $ 32,891 $ 17,293 Net earnings
$ 87,782 $ 52,879 Source: Empire Company Limited Annual Report, 1998
EXHIBIT 3 - OSHAWA GROUP LTD. FINANCIAL STATEMENTS
Oshawa Group Limited
Consolidated Balance Sheets
January 24, 1998 and January 25, 1997
(in millions of dollars)
1998
1997
Assets
Current Assets
Cash and short-term invetments
$ 65.0 $ 20.1 Accounts receivable
318.5 294.8 Income taxes receivable
5.6 0.8 Inventories
302.6 274.2 Prepaid expenses
17.4 16.9 Net assets of discontinued operations
- 99.7 709.1 706.5 Fixed assets
501.8 509.7 Other assets
294.7 219.2 $ 1,505.6 $ 1,435.4 Liabilities and Shareholders' Equity
Current Liabilities
Bank indebtedness
$ 17.1 $ 36.0 Accounts payable and accrued liabilities
429.5 379.0 446.6 415.0 Long-term debt
128.6 120.0 Deferred income taxes
36.2 53.9 Unearned revenue
36.4 24.6 647.8 613.5 Shareholders' equity
Capital stock
255.9 252.9 Retained earnings
601.9 569.0 857.8 821.9 $ 1,505.6 $ 1,435.4 Source: Oshawa Group Limited Annual Report, 1998
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
EXHIBIT 3 - OSHAWA GROUP LTD. FINANCIAL STATEMENTS
Oshawa Group Limited
Consolidated Statements of Earnings
January 24, 1998 and January 25, 1997
(in millions of dollars)
1998
1997
Sales and other revenues - continuing operations
$ 6,813.1 $ 5,987.6 Cost of sales and expenses
6,651.7 5,837.5 Depreciation and amortization
66.2 59.7 Earnings from continuing operations
95.2 90.4 Interest
(7.9)
(6.5)
Unusual items
(20.3)
8.8 Earnings before income taxes
67.0 92.7 Income taxes
(26.9)
(38.1)
Net earnings from continuing operations
40.1 54.6 Discontinued operations
13.9 0.6 Net earnings
$ 54.0 $ 55.2 Source: Oshawa Group Limited Annual Report, 1998
EXHIBIT 6 - SHARE PRICE APPRECIATION OF CANADIAN GROCERY COMPANIES
1997
Two Year
Three Year
Five Year
TSE Food Stores Index
63.2%
32.6%
31.3%
17.6%
Empire
64.2%
29.4%
16.5%
15.7%
Loblaws
83.0%
58.6%
48.2%
31.9%
Metro-Richelieu
42.9%
26.5%
38.7%
26.2%
Provigo
55.9%
2.4%
20.1%
2.2%
Average
61.8%
29.9%
30.6%
18.7%
Oshawa
23.5%
2.1%
10.3%
1.9%
Source: Scotia Capital Markets
as of December 31, 1997
EXHIBIT 9 - CANADIAN FOOD STORE COMPANY COMPARISON
(in millions of dollars)
Empire
Oshawa
Loblaws
Provigo
Market Value of Equity (as of 2/13/98)
776 951 6,735 850 990 Total Debt
918 135 876 77 327 Enterprise Value*
1,695 1,086 7,629 927 1,317 Revenues
3,208 7,052 10,554 3,432 5,859 EBITDA
219 165 534 155 232 EBITDA Margin
6.8%
2.4%
5.1%
4.5%
4.0%
Net Income
59 49 199 66 90 Net Margin
1.8%
0.7%
1.9%
1.9%
1.5%
Beta**
0.74 0.77 0.55 0.59 1.20 Credit Rating***
A
AA
A
n/a
BBB
Source: Bloomberg, Scotia Capital Markets
All information based on latest twelve months
* Market value of equity, plus market value of debt, less cash
** Beta based on weekly returns over two years
*** Canadian Bond Rating Service Rating of Senior Unsecured Debt
Risk premiums over government yields were currently around 75 basis points for AAA-rated firms, 100 for AA and 125 for A, and 150 for BBB
Metro-
Richelieu
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
EXHIBIT 10 - HISTORICAL TRANSACTION DATA
Target
Acquiror
Announcement
Transaction Size
Premium to
Enterprise Value to
Price to
Date
Equity
Enterprise
Consideration
20 Day Avg
Revenue
EBITDA
EBIT
Earnings
Book
(Latest twelve months)
(LTM)
Carr-Gottstein
Safeway Inc.
6-Aug-98
$ 113 $ 319 cash
56.3%
0.55x
6.9x
10.8x
n/a
4.4x
American Stores Co.
Albertson's
3-Aug-98
$ 8,939 $ 11,930 shares
25.8%
0.62x
9.5x
15.4x
26.8x
3.8x
Delchamps Inc.
Jitney-Jungle Stores
8-Jul-97
$ 227 $ 240 cash
0.4%
0.22x
5.8x
13.5x
26.8x
3.1x
Riser Foods
Giant Eagle
14-May-97
$ 426 $ 480 cash
15.3%
0.36x
8.5x
13.0x
17.2x
4.9x
Vons Companies
Safeway Inc.
30-Oct-96
$ 2,498 $ 3,025 shares
25.1%
0.56x
8.8x
13.7x
26.9x
0.9x
Kash 'n' Karry Food Stores
Food Lion
31-Oct-96
$ 126 $ 347 cash
14.5%
0.34x
6.3x
11.7x
n/a
6.5x
Stop & Shop
Royal Ahold NV
28-Mar-96
$ 1,682 $ 2,795 cash
20.6%
0.68x
8.9x
12.4x
22.3x
1.2x
National Convenience Stores
Diamond Shamrock
8-Nov-95
$ 186 $ 250 cash
9.9%
0.28x
6.8x
10.9x
19.6x
3.8x
Super Rite
Richfood Holdings
26-Jun-95
$ 212 $ 327 shares
29.4%
0.22x
6.6x
8.9x
15.9x
5.3x
Bruno's
KKR
20-Apr-95
$ 947 $ 1,167 97% cash, 3% shares
29.7%
0.41x
9.3x
15.9x
27.9x
2.2x
Source: Scotia Capital Markets
EXHIBIT 11 - TRADING RATIOS OF SELECTED CANADIAN GROCERY RETAILERS
Year End
Enterprise Value to EBITDA
Price to Earnings
1997
1998E
1999E
1998E
1999E
Empire
April
9.5x
7.8x
7.1x
14.6x
11.8x
Loblaws
December
15.9x
13.6x
11.4x
31.4x
27.0x
Metro-Richelieu
September
6.5x
6.0x
5.5x
12.4x
11.4x
Provigo
January
6.0x
5.8x
5.5x
14.8x
12.3x
Oshawa
January
6.8x
6.7x
5.7x
17.9x
14.6x
Source: Scotia Capital Markets
EXHIBIT 12 - 5 YEAR SELECTED HISTORICAL FINANCIAL INFORMATION
1998
1997
1996
1995
1994
1993
Empire
Sales
3,320.0 3,149.7 2,915.2 2,699.5 2,577.4 Dep. & Amort.
70.4 65.4 60.0 57.5 50.7 Working Capital
153.1 128.8 178.5 183.6 204.3 Capital Expend.
137.5 82.7 125.7 120.1 98.1 Oshawa
Sales
6,813.0 5,988.0 5,765.0 5,650.0 5,305.0 Dep. & Amort.
66.0 60.0 57.0 55.0 50.0 Working Capital
262.0 292.0 193.0 223.0 201.0 Capital Expend.
130.0 135.0 106.0 60.0 59.0 Loblaws
Sales
11,008.0 9,848.0 9,854.0 10,000.0 9,356.0 Dep. & Amort.
147.0 122.0 129.0 138.0 126.0 Working Capital
202.0 154.0 179.0 29.0 148.0 Capital Expend.
517.0 389.0 302.0 339.0 315.0 Metro-Richelieu
Sales
3,432.3 3,266.0 3,145.6 2,909.0 2,772.7 Dep. & Amort.
39.2 37.0 38.7 40.4 37.1 Working Capital
4.6 1.0 3.8 (4.7) (8.7)
Capital Expend.
79.1 57.1 38.0 40.5 19.5 Provigo
Sales
5,956.2 5,832.5 5,725.2 5,542.5 5,433.4 Dep. & Amort.
77.6 70.9 62.1 61.0 59.7 Working Capital
(45.0) (104.9) (104.3) (24.5) (209.9)
Capital Expend.
184.0 171.4 95.3 37.5 41.9 Safeway
Sales
22,483.8 17,269.0 16,397.5 15,626.6 15,214.5 Dep. & Amort.
455.8 338.5 329.7 326.4 330.2 Working Capital
n/a n/a n/a n/a n/a Capex
829.4 620.3 503.2 352.2 290.2 A&P
Sales
10,179.4 10,262.2 10,089.0 10,101.4 10,332.0 Dep. & Amort.
233.7 234.2 230.7 225.4 235.4 Working Capital
90.0 262.1 215.4 191.0 92.3 Capex
438.3 267.6 296.9 236.1 214.9 Source: Annual reports of listed companies
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
WACC (Kc) assumptions:
Target
Current
Weight of debt -- Wd
12.40%
Exh.9
Weight of equity -- We
87.60%
Risk-free rate -- Rf
10-yr Gov Bond
Debt premium
exhibit
Cost of debt -- Kd (before-tax)
Cost of debt -- Kd (after-tax)
Kd (before-tax) * (1-t)
Beta of equity (levered)
0.77
unlevered Market risk premium (MRP)
5.0%
5.0%assumed
Cost of equity -- Ke
Rf + B*MRP
WACC (Kc)
Wd*Kd(after-tax) + We*Ke
WACC INPUT BELOW
Exh.9 at current
D/(D+E)
VALUING OSHAWA
1998
1999
2000
2001
2002
Cash flow assumptions:
0
1
2
3
4
Sales (last 12 months)
7000
$ 7,000 Sales growth for next 5 years (per annum)
EBITDA margin (% of sales)
-D & A (% of sales)
Exh. 12
EBIT
-ebit*tax rate est.
EBIT*(1-t)
+D&A
Capital exp year 1 (% of sales)
Incremental cap ex years 2-5 (% of sales)
-Working capital increase (% of sales change)
Exh. 12 FCFF each year (1,2,3,4,5)
Terminal value@Time=5 (assume g = 5%!)
PV_TerminalValue(5)
Tl Ent Value (TEV) = PV_FCFF
Less: Debt
$ (135)Exh.9
PV of Oshawa Equity (DCF method)
shares o/s (millions)
38.6 combine common and class A (assume they have the same valu
approx Price/share (DCF method)
$ - PV_FCFF_(,1,2,..5)
per share (A and
common)
Multiples Analysis
Oshawa
Empire Food
appropriate EBITDA
x appropriate TEV/EBITDA Multiple TEV estimate
Less: debt
$ (135)
Equity value est.(Multiples method) OSHAWA's EQUITY VALUE:
Best estimate, stand alone value
judgement call, based on combined DCF and Multples estimate
Estimated synergy value cell B21 from synergies template
Estimated value of Oshawa if acquired
Current market value (price*shares o/s)
Total value (NPV) created if acquired
How much to offer/bid for Oshawa? Decide how to split the Total NPV between Empire and Oshwa,
RESTRUCTURING AND FORM OF PAYMENT:
Valuing New Sobeys
$million Estimated TEV of Oshawa if acquired
similar to Oshawa's equity value in B53, bu
from D44
NewCo TEV
Less:
Debt adopted from Oshawa (assume none from Empire)
$ 135 New Debt issued by NewCo (per recommendation)
? Experiment with differing amounts of debt
Total NewCo debt
Estimated Empire Food
TEV
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
NewCo Equity value =TEV-Debt
Market D/(D+E) = #DIV/0!
Bid Composition (cash + shares of Newco)
Total Bid Value for Oshawa Equity
$ - Above
Cash offered from NewCo new debt proceeds ? Experiment with differing amounts of debt
Extra Cash offered from Empire HQ $ 200 Given
Total cash consideration
#VALUE!
$ value of NewCo Equity offered
#VALUE! Follows from debt issuance choice
#VALUE!
% cash =
#VALUE!
Summary:
Empire's percentage ownership of NewCo
#VALUE!
NPV of deal to Oshawa (premium to market)
?
NPV of deal to Empire (total NPV - Oshawa NPV)
?
% of NewCo Equity value
offered
..
.
beta =
?
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
2003
5
ue)
es above
, i.e., how much to offer Oshawa in your bid. Use precedent transactions, and judgement from your assessment of the situ
ut add debt to get TEV, i.e., B53 + 135 debt since TEV=EQUITY + DEBT values)
t issued by New Sobeys, and implication for bid composition below
t issued by NewCo (NewSobeys)
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
uation.
WACC assumption
FCF terminal growth in synergies
0.0% assume no growth, just perpetuity of savings
1998
1999
2000
2001
2002
Cash flow assumptions:
0
1
2
3
4
Sales (last 12 months)
7000
$ 7,000 Sales growth for next 5 years (per annum)
EBITDA marg. IMPROVE % (versus 1998)
EBITDA marg. IMPROVE $
Cost Synergies Potential
EBIT synergy increase
-ebit*tax rate EBIT synergy increase*(1-t)
FCFF synergy increase
Terminal value@Time=5
PV_TV(5)
PV_FCFF synergy increases
Merger costs upfront (after 40% tax)
PV_FCFF synergy increases (net of merger costs)
divided by #million shares
38.6
synergy per share
$ - Return to DCF base template…
Partially
realised:
PV_FCFF_(,1,2,..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
2003
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
Related Documents
Related Questions
PNG Company
Comparative Balance Sheets
For the year ended December 31
20X1
20X0
Current assets
Cash
$157,000
$105,000
Accounts receivable
49,000
62,000
Inventory
53,700
36,100
Prepaid rent
11,400
8,300
Total current assets
$271,100
$211,400
Long-term assets
Investment in bonds
$30,000
$14,800
Land
216,300
184,200
Equipment (net)
114,500
137,900
Total long-term assets
$360,800
$336,900
Total assets
$631,900
$548,300
Current liabilities
Accounts payable
$61,300
$52,700
Interest payable
4,900
8,500
Income tax payable
15,400
12,600
Total current liabilities
$81,600
$73,800
Long-term liabilities
Bonds payable
$173,800
$205,400
Stockholders' equity
Common stock…
arrow_forward
Title
INGRAM INDUSTRIES Balance Sheet June 30, 2008 Assets Current assets: Cash (including $13,000 in...
Description
INGRAM INDUSTRIES
Balance Sheet
June 30, 2008
Assets
Current assets:
Cash (including $13,000 in sinking fund for bonds payable) $ 70,000
Marketable securities 23,400
Investment in subsidiary company 23,000
Accounts receivable 21,000
Inventories (lower-of-cost-or-market) 117,00 $254,400
Plant assets:
Land and buildings $160,000
Less: Accumulated depreciation 100,000 60,000
Investments:
Treasury stock 4,000
Deferred charges:
Discount on bonds payable $ 6,000
Prepaid expenses 2,000 8,000
Total Assets $326,400
Liabilities and Stockholders’
Equity Liabilities:
Notes payable to bank $ 60,000
Accounts payable 18,000
Bonds payable 61,000
Total liabilities $139,000
Stockholders’ equity:
Preferred and common
(each $10 par, 5,000 shares preferred and 6,000 shares common) $110,000
Capital in excess of par 61,000
Retained earnings 16,400 187,400
Total liabilities and…
arrow_forward
Marshall Inc.
Comparative Balance Sheet
December 31, 20Y2 and 20Y1
20Y2
20Y1
Assets
Current assets
Cash
$1,013,530
$917,700
Marketable securities
1,533,990
1,520,760
Accounts receivable (net)
978,200
919,800
Inventories
730,000
569,400
Prepaid expenses
191,756
183,540
Total current assets
$4,447,476
$4,111,200
Long-term investments
2,479,894
1,119,115
Property, plant, and equipment (net)
5,330,000
4,797,000
Total assets
$12,257,370
$10,027,315
Liabilities
Current liabilities
$1,347,720
$1,776,965
Long-term liabilities:
Mortgage note payable, 8%
$1,840,000
$0
Bonds payable, 8%
2,260,000
2,260,000
Total long-term liabilities
$4,100,000
$2,260,000
Total liabilities
$5,447,720
$4,036,965
Stockholders' Equity
Preferred $0.70 stock, $50 par
$850,000
$850,000
Common stock, $10 par
970,000
970,000
Retained earnings
4,989,650…
arrow_forward
MONTGOMERY INC.Comparative Balance SheetsDecember 31
Current Year
Prior Year
Assets
Cash
$
30,800
$
31,000
Accounts receivable, net
8,900
10,900
Inventory
79,800
63,000
Total current assets
119,500
104,900
Equipment
44,200
37,300
Accum. depreciation—Equipment
(19,900
)
(13,800
)
Total assets
$
143,800
$
128,400
Liabilities and Equity
Accounts payable
$
21,200
$
22,900
Salaries payable
400
500
Total current liabilities
21,600
23,400
Equity
Common stock, no par value
102,400
94,100
Retained earnings
19,800
10,900
Total liabilities and equity
$
143,800
$
128,400
MONTGOMERY INC.Income StatementFor Current Year Ended December 31…
arrow_forward
SNIDER CORPORATIONBalance SheetDecember 31, 20X1
Assets
Current assets:
Cash
$
52,200
Marketable securities
24,400
Accounts receivable (net)
222,000
Inventory
238,000
Total current assets
$
536,600
Investments
65,900
Plant and equipment.
$615,000
Less: Accumulated depreciation
271,000
Net plant and equipment
344,000
Total assets
$
946,500
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable
$
93,400
Notes payable
70,600
Accrued taxes
17,000
Total current liabilities
$
181,000
Long-term liabilities:
Bonds payable
153,200
Total liabilities
$
334,200
Stockholders' equity
Preferred stock, $50 par value
$
100,000
Common stock, $1 par value
80,000
Capital paid in excess of par
190,000
Retained earnings
242,300
Total stockholders' equity
$
612,300
Total liabilities and stockholders' equity
$
946,500…
arrow_forward
Assets
Cash
FORTEN COMPANY
Comparative Balance Sheets
December 31
Current Year
$ 49,800
65,810
275,656
Prior Year
$ 73,500
50,625
251,800
Accounts receivable
Inventory
Prepaid expenses
Total current assets
Equipment
Accumulated depreciation-Equipment
Total assets
Liabilities and Equity
Accounts payable
Short-term notes payable
Total current liabilities
Long-term notes payable
Total liabilities
Equity
Common stock, $5 par value
Paid-in capital in excess of par, common stock
Retained earnings
Total liabilities and equity
1,250
392,516
157,500
1,875
377,800
108,000
(46,000)
(36,625)
$ 513,391
$ 53,141
10,000
63,141
$ 439,800
$ 114,675
6,000
120,675
65,000
48,750
128,141
169,425
162,750
150,250
120,125
,391
$ 439,800
37,500
185,000
$ 513,5
FORTEN COMPANY
Income Statement
For Current Year Ended December 31
Sales
Cost of goods sold
Gross profit
Operating expenses
Depreciation expense
Other expenses
Other gains (losses)
Loss on sale of equipment
Income before taxes
Income taxes expense
Net…
arrow_forward
Category
Prior Year
Current Year
Accounts payable
???
???
Accounts receivable
320,715
397,400
Accruals
40,500
33,750
Additional paid in capital
500,000
541,650
Cash
17,500
47,500
Common Stock
94,000
105,000
COGS
328,500
428,571.00
Current portion long-term debt
33,750
35,000
Depreciation expense
54,000
54,035.00
Interest expense
40,500
42,155.00
Inventories
279,000
288,000
Long-term debt
339,577.00
401,377.00
Net fixed assets
946,535
999,000
Notes payable
148,500
162,000
Operating expenses (excl. depr.)
126,000
162,171.00
Retained earnings
306,000
342,000
Sales
639,000
849,094.00
Taxes
24,750
47,192.00
What is the current year's entry for long-term debt on a common-sized balance sheet?
(ROUND TO 4 DECIMAL PLACES.)
arrow_forward
Lydex Company
Comparative Balance Sheet
Assets
Current assets:
Cash
Marketable securities
Accounts receivable, net
Inventory
Prepaid expenses
Total current assets
Plant and equipment, net
Total assets
Liabilities and Stockholders' Equity
Liabilities:
Current liabilities
Note payable, 10%
Total liabilities
Stockholders' equity:
$ 1,260,000
This Year
Last Year
$960,000
0
2,700,000
3,900,000
240,000
7,800,000
9,300,000
$ 17,100,000
300,000
1,800,000
2,400,000
180,000
5,940,000
8,940,000
$ 14,880,000
$ 3,900,000
3,600,000
7,500,000
7,800,000
1,800,000
9,600,000
$ 2,760,000
3,000,000
5,760,000
7,800,000
1,320,000
9,120,000
Common stock, $ 78 par value
Retained earnings
Total stockholders' equity
Total liabilities and stockholders' equity
Lydex Company
$ 17,100,000
$ 14,880,000
Comparative Income Statement and Reconciliation
Sales (all on account)
Cost of goods sold
Gross margin
Selling and administrative expenses
Net operating income
Interest expense
Net income before taxes
Income taxes…
arrow_forward
CABOT CORPORATIONBalance SheetDecember 31
Assets
Liabilities and Equity
Cash
$
10,000
Accounts payable
$
19,500
Short-term investments
8,000
Accrued wages payable
3,400
Accounts receivable, net
33,600
Income taxes payable
2,900
Merchandise inventory
42,150
Long-term note payable, secured by mortgage on plant assets
66,400
Prepaid expenses
2,800
Common stock
83,000
Plant assets, net
147,300
Retained earnings
68,650
Total assets
$
243,850
Total liabilities and equity
$
243,850
Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)
arrow_forward
CABOT CORPORATIONBalance SheetDecember 31
Assets
Liabilities and Equity
Cash
$
10,000
Accounts payable
$
19,500
Short-term investments
8,000
Accrued wages payable
3,400
Accounts receivable, net
33,600
Income taxes payable
2,900
Merchandise inventory
42,150
Long-term note payable, secured by mortgage on plant assets
66,400
Prepaid expenses
2,800
Common stock
83,000
Plant assets, net
147,300
Retained earnings
68,650
Total assets
$
243,850
Total liabilities and equity
$
243,850
Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)
arrow_forward
CABOT CORPORATIONBalance SheetDecember 31
Assets
Liabilities and Equity
Cash
$
10,000
Accounts payable
$
19,500
Short-term investments
8,000
Accrued wages payable
3,400
Accounts receivable, net
33,600
Income taxes payable
2,900
Merchandise inventory
42,150
Long-term note payable, secured by mortgage on plant assets
66,400
Prepaid expenses
2,800
Common stock
83,000
Plant assets, net
147,300
Retained earnings
68,650
Total assets
$
243,850
Total liabilities and equity
$
243,850
Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)
arrow_forward
CABOT CORPORATIONBalance SheetDecember 31
Assets
Liabilities and Equity
Cash
$
10,000
Accounts payable
$
19,500
Short-term investments
8,000
Accrued wages payable
3,400
Accounts receivable, net
33,600
Income taxes payable
2,900
Merchandise inventory
42,150
Long-term note payable, secured by mortgage on plant assets
66,400
Prepaid expenses
2,800
Common stock
83,000
Plant assets, net
147,300
Retained earnings
68,650
Total assets
$
243,850
Total liabilities and equity
$
243,850
Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)
arrow_forward
Category
Prior Year Current Year
Accounts payable
???
Accounts receivable
320,715
397,400
Accruals
40,500
33,750
Additional paid in capital
500,000
541,650
Cash
17,500
47,500
Common Stock
94,000 105,000
COGS
328,500 431,516.41
Current portion long-term debt
33,750
35,000
Depreciation expense
54,000
55,946.66
Interest expense
40,500 41,874.31
Inventories
279,000
288,000
Long-term debt
336,467.85 401,942.46
Net fixed assets
946,535
999,000
Notes payable
148,500
162,000
Operating expenses (excl. depr.) 126,000
161,499.58
Retained earnings
306,000
342,000
Sales
639,000 854,554.01
Taxes
24,750 48,384.56
???
What is the current year's return on equity (ROE)?
Submit
Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign re
rounded to 4 decimal places (ex: 0.0924))
arrow_forward
The most recent financial statements for Crosby, Incorporated, appear below. Sales for
2022 are projected to grow by 20 percent. Interest expense will remain constant, the tax
rate and the dividend payout rate also will remain constant. Costs, other expenses,
current assets, fixed assets, and accounts payable increase spontaneously with sales.
Sales
Costs
Other expenses
Earnings before interest and taxes
Interest expense
Taxable income
Taxes (24%)
CROSBY, INCORPORATED
2021 Income Statement
Net income
Dividends
Addition to retained earnings
Current assets
Cash
Accounts receivable
Inventory
$31,335
69,745
$ 20,640
43,580
91,960
$747,000
582,000
18,000
FA
$147,000
14,000
$ 133,000
31,920
$ 101,080
CROSBY, INCORPORATED
Balance Sheet as of December 31, 2021
Assets
Seved
Liabilities and Owners' Equity
Current liabilities
Accounts payable
Notes payable
Total
$ 54,800
14,000
$ 68,800
MA000
arrow_forward
Current Year
Previous Year
Current assets:
Cash
$532,000
$439,200
Marketable securities
616,000
494,100
Accounts and notes receivable (net)
252,000
164,700
Inventories
554,400
297,700
Prepaid expenses
285,600
190,300
Total current assets
$2,240,000
$1,586,000
Current liabilities:
Accounts and notes payable
(short-term)
$406,000
$427,000
Accrued liabilities
294,000
183,000
Total current liabilities
$700,000
$610,000
a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal
place.
Current Year
Previous Year
1. Working capital
$
2. Current ratio
3. Quick ratio
arrow_forward
Category
Prior Year
Current Year
Accounts payable
???
???
Accounts receivable
320,715
397,400
Accruals
40,500
33,750
Additional paid in capital
500,000
541,650
Cash
17,500
47,500
Common Stock
94,000
105,000
COGS
328,500
431,139.00
Current portion long-term debt
33,750
35,000
Depreciation expense
54,000
54,349.00
Interest expense
40,500
41,741.00
Inventories
279,000
288,000
Long-term debt
337,728.00
398,725.00
Net fixed assets
946,535
999,000
Notes payable
148,500
162,000
Operating expenses (excl. depr.)
126,000
162,280.00
Retained earnings
306,000
342,000
Sales
639,000
847,106.00
Taxes
24,750
48,618.00
What is the current year's return on assets (ROA)?
(Round to 4 decimal places.)
arrow_forward
Sh19
arrow_forward
Privett Company
Line Item Description
Amount
Accounts payable
$27,815
Accounts receivable
70,978
Accrued liabilities
6,525
Cash
22,970
Intangible assets
43,640
Inventory
74,446
Long-term investments
100,209
Long-term liabilities
78,528
Marketable securities
34,768
Notes payable (short-term)
25,264
Prepaid expenses
2,065
Property, plant, and equipment
646,687
Based on the data for Privett Company, what is the amount of working capital?
a. $205,227
b. $995,763
c. $128,716
d. $145,623
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- PNG Company Comparative Balance Sheets For the year ended December 31 20X1 20X0 Current assets Cash $157,000 $105,000 Accounts receivable 49,000 62,000 Inventory 53,700 36,100 Prepaid rent 11,400 8,300 Total current assets $271,100 $211,400 Long-term assets Investment in bonds $30,000 $14,800 Land 216,300 184,200 Equipment (net) 114,500 137,900 Total long-term assets $360,800 $336,900 Total assets $631,900 $548,300 Current liabilities Accounts payable $61,300 $52,700 Interest payable 4,900 8,500 Income tax payable 15,400 12,600 Total current liabilities $81,600 $73,800 Long-term liabilities Bonds payable $173,800 $205,400 Stockholders' equity Common stock…arrow_forwardTitle INGRAM INDUSTRIES Balance Sheet June 30, 2008 Assets Current assets: Cash (including $13,000 in... Description INGRAM INDUSTRIES Balance Sheet June 30, 2008 Assets Current assets: Cash (including $13,000 in sinking fund for bonds payable) $ 70,000 Marketable securities 23,400 Investment in subsidiary company 23,000 Accounts receivable 21,000 Inventories (lower-of-cost-or-market) 117,00 $254,400 Plant assets: Land and buildings $160,000 Less: Accumulated depreciation 100,000 60,000 Investments: Treasury stock 4,000 Deferred charges: Discount on bonds payable $ 6,000 Prepaid expenses 2,000 8,000 Total Assets $326,400 Liabilities and Stockholders’ Equity Liabilities: Notes payable to bank $ 60,000 Accounts payable 18,000 Bonds payable 61,000 Total liabilities $139,000 Stockholders’ equity: Preferred and common (each $10 par, 5,000 shares preferred and 6,000 shares common) $110,000 Capital in excess of par 61,000 Retained earnings 16,400 187,400 Total liabilities and…arrow_forwardMarshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 20Y1 Assets Current assets Cash $1,013,530 $917,700 Marketable securities 1,533,990 1,520,760 Accounts receivable (net) 978,200 919,800 Inventories 730,000 569,400 Prepaid expenses 191,756 183,540 Total current assets $4,447,476 $4,111,200 Long-term investments 2,479,894 1,119,115 Property, plant, and equipment (net) 5,330,000 4,797,000 Total assets $12,257,370 $10,027,315 Liabilities Current liabilities $1,347,720 $1,776,965 Long-term liabilities: Mortgage note payable, 8% $1,840,000 $0 Bonds payable, 8% 2,260,000 2,260,000 Total long-term liabilities $4,100,000 $2,260,000 Total liabilities $5,447,720 $4,036,965 Stockholders' Equity Preferred $0.70 stock, $50 par $850,000 $850,000 Common stock, $10 par 970,000 970,000 Retained earnings 4,989,650…arrow_forward
- MONTGOMERY INC.Comparative Balance SheetsDecember 31 Current Year Prior Year Assets Cash $ 30,800 $ 31,000 Accounts receivable, net 8,900 10,900 Inventory 79,800 63,000 Total current assets 119,500 104,900 Equipment 44,200 37,300 Accum. depreciation—Equipment (19,900 ) (13,800 ) Total assets $ 143,800 $ 128,400 Liabilities and Equity Accounts payable $ 21,200 $ 22,900 Salaries payable 400 500 Total current liabilities 21,600 23,400 Equity Common stock, no par value 102,400 94,100 Retained earnings 19,800 10,900 Total liabilities and equity $ 143,800 $ 128,400 MONTGOMERY INC.Income StatementFor Current Year Ended December 31…arrow_forwardSNIDER CORPORATIONBalance SheetDecember 31, 20X1 Assets Current assets: Cash $ 52,200 Marketable securities 24,400 Accounts receivable (net) 222,000 Inventory 238,000 Total current assets $ 536,600 Investments 65,900 Plant and equipment. $615,000 Less: Accumulated depreciation 271,000 Net plant and equipment 344,000 Total assets $ 946,500 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 93,400 Notes payable 70,600 Accrued taxes 17,000 Total current liabilities $ 181,000 Long-term liabilities: Bonds payable 153,200 Total liabilities $ 334,200 Stockholders' equity Preferred stock, $50 par value $ 100,000 Common stock, $1 par value 80,000 Capital paid in excess of par 190,000 Retained earnings 242,300 Total stockholders' equity $ 612,300 Total liabilities and stockholders' equity $ 946,500…arrow_forwardAssets Cash FORTEN COMPANY Comparative Balance Sheets December 31 Current Year $ 49,800 65,810 275,656 Prior Year $ 73,500 50,625 251,800 Accounts receivable Inventory Prepaid expenses Total current assets Equipment Accumulated depreciation-Equipment Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term notes payable Total liabilities Equity Common stock, $5 par value Paid-in capital in excess of par, common stock Retained earnings Total liabilities and equity 1,250 392,516 157,500 1,875 377,800 108,000 (46,000) (36,625) $ 513,391 $ 53,141 10,000 63,141 $ 439,800 $ 114,675 6,000 120,675 65,000 48,750 128,141 169,425 162,750 150,250 120,125 ,391 $ 439,800 37,500 185,000 $ 513,5 FORTEN COMPANY Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit Operating expenses Depreciation expense Other expenses Other gains (losses) Loss on sale of equipment Income before taxes Income taxes expense Net…arrow_forward
- Category Prior Year Current Year Accounts payable ??? ??? Accounts receivable 320,715 397,400 Accruals 40,500 33,750 Additional paid in capital 500,000 541,650 Cash 17,500 47,500 Common Stock 94,000 105,000 COGS 328,500 428,571.00 Current portion long-term debt 33,750 35,000 Depreciation expense 54,000 54,035.00 Interest expense 40,500 42,155.00 Inventories 279,000 288,000 Long-term debt 339,577.00 401,377.00 Net fixed assets 946,535 999,000 Notes payable 148,500 162,000 Operating expenses (excl. depr.) 126,000 162,171.00 Retained earnings 306,000 342,000 Sales 639,000 849,094.00 Taxes 24,750 47,192.00 What is the current year's entry for long-term debt on a common-sized balance sheet? (ROUND TO 4 DECIMAL PLACES.)arrow_forwardLydex Company Comparative Balance Sheet Assets Current assets: Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets Liabilities and Stockholders' Equity Liabilities: Current liabilities Note payable, 10% Total liabilities Stockholders' equity: $ 1,260,000 This Year Last Year $960,000 0 2,700,000 3,900,000 240,000 7,800,000 9,300,000 $ 17,100,000 300,000 1,800,000 2,400,000 180,000 5,940,000 8,940,000 $ 14,880,000 $ 3,900,000 3,600,000 7,500,000 7,800,000 1,800,000 9,600,000 $ 2,760,000 3,000,000 5,760,000 7,800,000 1,320,000 9,120,000 Common stock, $ 78 par value Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Lydex Company $ 17,100,000 $ 14,880,000 Comparative Income Statement and Reconciliation Sales (all on account) Cost of goods sold Gross margin Selling and administrative expenses Net operating income Interest expense Net income before taxes Income taxes…arrow_forwardCABOT CORPORATIONBalance SheetDecember 31 Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 19,500 Short-term investments 8,000 Accrued wages payable 3,400 Accounts receivable, net 33,600 Income taxes payable 2,900 Merchandise inventory 42,150 Long-term note payable, secured by mortgage on plant assets 66,400 Prepaid expenses 2,800 Common stock 83,000 Plant assets, net 147,300 Retained earnings 68,650 Total assets $ 243,850 Total liabilities and equity $ 243,850 Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)arrow_forward
- CABOT CORPORATIONBalance SheetDecember 31 Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 19,500 Short-term investments 8,000 Accrued wages payable 3,400 Accounts receivable, net 33,600 Income taxes payable 2,900 Merchandise inventory 42,150 Long-term note payable, secured by mortgage on plant assets 66,400 Prepaid expenses 2,800 Common stock 83,000 Plant assets, net 147,300 Retained earnings 68,650 Total assets $ 243,850 Total liabilities and equity $ 243,850 Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)arrow_forwardCABOT CORPORATIONBalance SheetDecember 31 Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 19,500 Short-term investments 8,000 Accrued wages payable 3,400 Accounts receivable, net 33,600 Income taxes payable 2,900 Merchandise inventory 42,150 Long-term note payable, secured by mortgage on plant assets 66,400 Prepaid expenses 2,800 Common stock 83,000 Plant assets, net 147,300 Retained earnings 68,650 Total assets $ 243,850 Total liabilities and equity $ 243,850 Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)arrow_forwardCABOT CORPORATIONBalance SheetDecember 31 Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 19,500 Short-term investments 8,000 Accrued wages payable 3,400 Accounts receivable, net 33,600 Income taxes payable 2,900 Merchandise inventory 42,150 Long-term note payable, secured by mortgage on plant assets 66,400 Prepaid expenses 2,800 Common stock 83,000 Plant assets, net 147,300 Retained earnings 68,650 Total assets $ 243,850 Total liabilities and equity $ 243,850 Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education