Ch07 P15 Build a Model-913649
xlsx
keyboard_arrow_up
School
National Open and Distance University *
*We aren’t endorsed by this school
Course
122
Subject
Finance
Date
Nov 24, 2024
Type
xlsx
Pages
15
Uploaded by jacque84
Ratio Analysis
Joshua & White Technologies: December 31 Balance Sheets
(Thousands of Dollars)
2021
2020
Assets
Cash
$21,525
$20,500
Short-term investments
4,195
2,980
Accounts receivable
52,500
49,000
Inventories
88,000
56,000
Total current assets
$166,220
$128,480
Net fixed assets
231,951
210,000
Total assets
$398,171
$338,480
Liabilities & Equity
Accounts payable
$30,975
$29,500
Accruals
10,500
10,000
Notes payable
19,414
5,620
Total current liabilities
$60,889
$45,120
Long-term debt
73,032
62,260
Total liabilities
$133,921
$107,380
Common stock
182,000
182,000
Retained earnings
82,250
49,100
Total common equity
$264,250
$231,100
Total liabilities & equity
$398,171
$338,480
Joshua & White Technology: Income Statements for Year
Ending on December 31 (Thousands of Dollars)
2021
2020
Sales
$430,500
$410,000
COGS excluding depreciation and amortization
308,500
307,500
Depreciation and amortization
20,420
18,900
Other operating expenses
26,500
20,500
EBIT
$75,080
$63,100
Interest expense
6,040
4,660
EBT
$69,040
$58,440
Taxes (25%)
17,260
14,610
Net income
$51,780
$43,830
Common dividends
$18,630
$17,532
Additions to retained earnings
$33,150
$26,298
Other Data
2021
2020
Year-end stock price
$88.00
$96.00
Number of shares (Thousands)
4,046
4,000
Lease payment (Thousands of Dollars)
$20,000
$20,000
Sinking fund payment (Thousands of Dollars)
$5,000
$5,000
a. Determining whether J&W’s liquidity position has improved or worsened
2021
2020
Current ratio
2.73
2.85
Quick ratio
1.28
1.61
b. Determining whether J&W's ability to manage its assets has improved or worsened
Days in a year
365
2021
2020
Inventory turnover
3.74
5.83
Days sales outstanding (days)
44.51
43.62
Fixed assets turnover
1.86
1.95
Total assets turnover
1.08
1.21
c. Determining how J&W's profitability has changed during the last year
2021
2020
Profit margin
12.03%
10.69%
Basic earning power
18.86%
18.64%
Return on assets
13.00%
12.95%
Return on equity
19.60%
18.97%
d. Performing an extended DuPont analysis for J&W for 2020 and 2021
Profit margin
TA turnover
Equity multiplier
2021
12.03%
1.08
1.51
2020
10.69%
1.21
1.46
e. Performing a common size analysis
Common Size Balance Sheets
2021
2020
Assets
Cash
5.41%
6.06%
Short-term investments
1.05%
0.88%
Accounts receivable
13.19%
14.48%
Inventories
22.10%
16.54%
Total current assets
41.75%
37.96%
Net fixed assets
58.25%
62.04%
Total assets
100.00%
100.00%
Liabilities & Equity
Accounts payable
7.78%
8.72%
Accruals
2.64%
2.95%
Notes payable
4.88%
1.66%
Total current liabilities
15.29%
13.33%
Long-term debt
18.34%
18.39%
Total liabilities
33.63%
31.72%
Common stock
45.71%
53.77%
Retained earnings
20.66%
14.51%
Total common equity
66.37%
68.28%
Total liabilities & equity
100.00%
100.00%
Common Size Income Statements
2021
2020
Sales
100.00%
100.00%
COGS excluding depreciation and amortization
71.66%
75.00%
Depreciation and amortization
4.74%
4.61%
Other operating expenses
6.16%
5.00%
EBIT
17.44%
15.39%
Interest expense
1.40%
1.14%
EBT
16.04%
14.25%
Taxes (25%)
4.01%
3.56%
Net income
12.03%
10.69%
f. Performing a percentage change analysis
Percent Change Balance Sheet
Formulas
Assets
Cash
5.00% =(C7-D7)/D7
Short-term investments
40.77% =(C8-D8)/D8
Accounts receivable
7.14% =(C9-D9)/D9
Inventories
57.14% =(C10-D10)/D10
Total current assets
29.37% =(C11-D11)/D11
Net fixed assets
10.45% =(C12-D12)/D12
Total assets
17.64% =(C13-D13)/D13
Liabilities & Equity
Accounts payable
5.00% =(C16-D16)/D16
Accruals
5.00% =(C17-D17)/D17
Notes payable
245.44% =(C18-D18)/D18
Total current liabilities
34.95% =(C19-D19)/D19
Long-term debt
17.30% =(C20-D20)/D20
Total liabilities
24.72% =(C21-D21)/D21
Common stock
0.00% =(C22-D22)/D22
Retained earnings
67.52% =(C23-D23)/D23
Total common equity
14.34% =(C24-D24)/D24
Total liabilities & equity
17.64% =(C25-D25)/D25
Percent Change Income Statement
Formulas
Sales
5.00% =(C30-D30)/D30
COGS excluding depreciation and amortization
0.33% =(C31-D31)/D31
Depreciation and amortization
8.04% =(C32-D32)/D32
Other operating expenses
29.27% =(C33-D33)/D33
EBIT
18.99% =(C34-D34)/D34
Interest expense
29.61% =(C35-D35)/D35
EBT
18.14% =(C36-D36)/D36
Taxes (25%)
18.14% =(C37-D37)/D37
Net income
18.14% =(C38-D38)/D38
Percent Change in 2021
Percent Change in 2021
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
ROE
19.60%
18.97%
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
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
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
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
Seminole Corporation reported the following items at December 31, 2021, and 2020:
(Click the icon to view the comparative financial information.)
Read the requirements.
Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio
value as strong or weak. All sales are on account with terms of net 30 days.
(a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents.
Round your final answer to two decimal places.)
Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio
$
Seminole's quick (acid-test) ratio is considered fairly weak.
(b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal
places, XX.XX. Round the days' sales outstanding up to the next whole day.)
Accounts receivable turnover =
+
Days' sales outstanding
Seminole's days'…
arrow_forward
-Equity Ratio-Debt to equity ratio-Times interest earned-Return on common stockholders equity
Figure each ratio out
arrow_forward
Ratio Analysis
Consider the following information taken from GER's financial statements:
September 30(in thousands)
2020
2019
Current assets:
Cash and cash equivalents
$1,274
$6,450
Receivables
30,071
16,548
Inventories
31,796
14,072
Other current assets
4,818
2,620
Total current assets
$67,959
$39,690
Current liabilities:
Current portion of long-term debt
$97
$3,530
Accounts payable
23,124
11,228
Accrued compensation costs
5,606
1,929
Accrued expenses
9,108
5,054
Other current liabilities
874
777
Total current liabilities
$38,809
$22,518
Also, GER's operating cash flows were $11,255 and $13,736 in 2020 and 2019, respectively.
4. Calculate the operating cash flow ratios for 2020 and 2019.
Operating Cash Flow Ratio
2020
fill in the blank 7
2019
fill in the blank 8
arrow_forward
Liquidity Ratios:
2022
2021
Current ratio
Working capital
I need help finding liquidity ratios. Could you explain why you got that? Thanks.
arrow_forward
What is Ratio Corporation's Fiscal 2021 Times Interest Earned Ratio?
1.41
2.57
4.5
1.63
arrow_forward
Calculate the leverage ratio which includes total debt to total assets ratio, equity multiplier, debt to equity ratio, current liabilities to total debt ratio, interest coverage, and fixed charges coverage.
arrow_forward
Solar Electric Inc. Balance Sheet 32 Marks ACB As at December 31, 2023 Account Title Debit Credit Assets Current Assets Cash 100,649 Accounts Receivable 35,860 Interest Rceivable 9,113 Prepaid Insurance 7,370 Short-Term Investment- Citi Inc 237,000 Short-Term Investment- Bonds 135,000 Inventory 90,640 Valuation Allowance for Fair Value Adjustment 50,700 Total Current Assets 666,332 Non-current Assets Investment in HSBC Inc. Common Shares 503,840 Long-Term Investment- Bond 145,000 Property, Plant & Equipment 280,000 Accumulated Depreciation 86,000 Total Non-Current Assets 842,840 Total Assets 1,509,172 Liabilities Current Liabilities Accounts Payable 212,400 Interest Payable 31,167 Unearned Revenue 21,000 Total Current Liabilities 264,567 Long-Term Liabilities Bonds Payable 340,000 Discount on Bonds Payable 15,741 Bank Loan 225,000 Total-Long Term Liabilities 549,259 Total Liabilities 813,826 Shareholders Equity Common Shares 362,000 Preferred Shares 80,000 Retained Earnings 348,385…
arrow_forward
Pharoah Corporation’s comparative balance sheet is presented below.
PHAROAH CORPORATIONBalance SheetDecember 31
Assets
2021
2020
Cash
$12,010
$8,980
Accounts receivable
17,810
19,660
Land
16,800
21,840
Buildings
58,800
58,800
Accumulated depreciation—buildings
(12,600
)
(8,400
)
Total
$92,820
$100,880
Liabilities and Shareholders’ Equity
Accounts payable
$10,390
$26,120
Common shares
63,000
57,960
Retained earnings
19,430
16,800
Total
$92,820
$100,880
Additional information:
1.
Profit was $19,010. Dividends declared and paid were $16,380.
2.
No noncash investing and financing activities occurred during 2021.
3.
The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land.
Prepare a cash flow statement for 2021 using the indirect method. Lu…
arrow_forward
Please input numbers in boxes below based on data provided for year 2018.
Current assets - current liabilities = net working capital
arrow_forward
Cullumber Company has these comparative balance sheet data:
CULLUMBER COMPANYBalance SheetsDecember 31
2020
2019
Cash
$ 16,350
$ 32,700
Accounts receivable (net)
76,300
65,400
Inventory
65,400
54,500
Plant assets (net)
218,000
196,200
$376,050
$348,800
Accounts payable
$ 54,500
$ 65,400
Mortgage payable (15%)
109,000
109,000
Common stock, $10 par
152,600
130,800
Retained earnings
59,950
43,600
$376,050
$348,800
Additional information for 2020:
1.
Net income was $34,000.
2.
Sales on account were $383,300. Sales returns and allowances amounted to $26,600.
3.
Cost of goods sold was $200,600.
4.
Net cash provided by operating activities was $59,000.
5.
Capital expenditures were $26,400, and cash dividends were $16,500.
Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g.…
arrow_forward
Carla Vista Co. has these comparative balance sheet data:
CARLA VISTA CO.Balance SheetsDecember 31
2020
2019
Cash
$ 16,140
$ 32,280
Accounts receivable (net)
75,320
64,560
Inventory
64,560
53,800
Plant assets (net)
215,200
193,680
$371,220
$344,320
Accounts payable
$ 53,800
$ 64,560
Mortgage payable (15%)
107,600
107,600
Common stock, $10 par
150,640
129,120
Retained earnings
59,180
43,040
$371,220
$344,320
Additional information for 2020:
1.
Net income was $32,500.
2.
Sales on account were $392,900. Sales returns and allowances amounted to $27,300.
3.
Cost of goods sold was $217,300.
4.
Net cash provided by operating activities was $57,200.
5.
Capital expenditures were $30,000, and cash dividends were $19,000.
Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…
arrow_forward
Marina Company Statement of Financial Position June 30, 2020
AssetsCurrent Assets Cash P 21,000.00 Accounts Receivables 160,000.00 Merchandise Inventory 300,000.00 Prepaid Expenses 9,000.00Total Current Assets P 490,000.00Property, Plant and Equipment 810,000.00Total Assets P 1,300,000.00
Liabilities and EquityLiabilities: Current Liabilities P 200,000.00 Bonds Payable, 10% 300,000.00Total Liabilities P 500,000.00Equity:…
arrow_forward
Calculate
Debt-to-equity
Times interest earned
Return on Financial leverage
arrow_forward
The comparative balance sheets for Metlock Corporation show the following information.
December 312020 2019Cash $33,500 $12,900Accounts receivable 12,400 10,000Inventory 12,100 9,000Available-for-sale debt investments –0– 3,000Buildings –0– 29,800Equipment 44,800 19,900Patents 5,000 6,300 $107,800 $90,900Allowance for doubtful accounts $3,100 $4,500Accumulated depreciation—equipment 2,000 4,500Accumulated depreciation—building –0– 6,000Accounts payable 5,000 3,000Dividends payable –0– 4,900Notes payable, short-term (nontrade) 3,000 4,100Long-term notes payable 31,000 25,000Common stock 43,000 33,000Retained earnings 20,700 5,900 $107,800 $90,900
Additional data related to 2020 are as follows.
1. Equipment that had cost $11,000 and was 40% depreciated at time of disposal was sold for $2,500.2. $10,000 of the long-term note payable was paid by issuing common stock.3. Cash dividends paid were $4,900.4. On January…
arrow_forward
Condensed balance sheet and income statement data for Coronado Corporation are presented here.
Coronado CorporationBalance SheetsDecember 31
2022
2021
2020
Cash
$ 29,700
$ 17,300
$ 17,100
Accounts receivable (net)
49,500
45,800
49,000
Other current assets
89,800
95,700
63,900
Investments
55,100
69,300
45,600
Property, plant, and equipment (net)
500,800
369,900
358,000
$724,900
$598,000
$533,600
Current liabilities
$84,500
$80,200
$69,100
Long-term debt
145,100
84,100
49,100
Common stock, $10 par
354,000
321,000
308,000
Retained earnings
141,300
112,700
107,400
$724,900
$598,000
$533,600
Coronado CorporationIncome StatementsFor the Years Ended December 31
2022
2021
Sales
$744,500
$606,300
Less: Sales returns and allowances
40,900
29,700
Net…
arrow_forward
Calculate total debt ratio and long term debt ratio for each year.
arrow_forward
The comparative Statements of Financial Position for Mason Company are presented below.
MASON COMPANY
Comparative Balance Sheet
December 31,
2020
Assets
Cash.
RM 30,000
10,000
60,000
2019
RM 45,000
25,000
Short-term investments.
Accounts receivable (net)
Inventory....
Property, plant, and equipment (net).
Total assets...
50,000
200,000
RM350,000
40,000
50,000
160,000
RM320,000
Liabilities and stockholders' equity
Accounts payable
Short-term notes payable
Bonds payable
RM 10,000
40,000
RM 30,000
35,000
20,000
20,000
220,000
60,000
RM350,000
Common stock
Retained earnings
Total liabilities and stockholders' equity
200,000
35,000
RM320,000
Prepare a horizontal analysis of the Statements of Financial Position data for Manson
Company using 2019 as a base.
а.
b.
Prepare a vertical analysis of the Statements of Financial Position data for Manson
Company for 2020.
с.
Explain whether the trends are favorable or unfavorable as computed in (a) & (b) above.
arrow_forward
Sandhill Co. has these comparative balance sheet data:
SANDHILL CO.Balance SheetsDecember 31
2020
2019
Cash
$ 29,205
$ 58,410
Accounts receivable (net)
136,290
116,820
Inventory
116,820
97,350
Plant assets (net)
389,400
350,460
$671,715
$623,040
Accounts payable
$ 97,350
$ 116,820
Mortgage payable (15%)
194,700
194,700
Common stock, $10 par
272,580
233,640
Retained earnings
107,085
77,880
$671,715
$623,040
Additional information for 2020:
1.
Net income was $34,900.
2.
Sales on account were $378,200. Sales returns and allowances amounted to $29,600.
3.
Cost of goods sold was $204,700.
4.
Net cash provided by operating activities was $57,300.
5.
Capital expenditures were $28,200, and cash dividends were $13,800.
Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…
arrow_forward
Sandhill Co. has these comparative balance sheet data:
SANDHILL CO.Balance SheetsDecember 31
2020
2019
Cash
$ 29,205
$ 58,410
Accounts receivable (net)
136,290
116,820
Inventory
116,820
97,350
Plant assets (net)
389,400
350,460
$671,715
$623,040
Accounts payable
$ 97,350
$ 116,820
Mortgage payable (15%)
194,700
194,700
Common stock, $10 par
272,580
233,640
Retained earnings
107,085
77,880
$671,715
$623,040
Additional information for 2020:
1.
Net income was $34,900.
2.
Sales on account were $378,200. Sales returns and allowances amounted to $29,600.
3.
Cost of goods sold was $204,700.
4.
Net cash provided by operating activities was $57,300.
5.
Capital expenditures were $28,200, and cash dividends were $13,800.
Only the first 3 were answered the last time, I need all of these answered now.
Compute the following ratios at December 31,…
arrow_forward
24.
Condensed financial data of Sheffield Company for 2020 and 2019 are presented below.
SHEFFIELD COMPANYCOMPARATIVE BALANCE SHEETAS OF DECEMBER 31, 2020 AND 2019
2020
2019
Cash
$1,800
$1,130
Receivables
1,770
1,320
Inventory
1,560
1,890
Plant assets
1,900
1,700
Accumulated depreciation
(1,220
)
(1,180
)
Long-term investments (held-to-maturity)
1,300
1,430
$7,110
$6,290
Accounts payable
$1,220
$890
Accrued liabilities
190
250
Bonds payable
1,410
1,520
Common stock
1,870
1,730
Retained earnings
2,420
1,900
$7,110
$6,290
SHEFFIELD COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020
Sales revenue
$6,860
Cost of goods sold
4,710
Gross margin
2,150
Selling and administrative expenses
920
Income…
arrow_forward
Additional information: 2018
current ratio: 1.4:1
debt to total assets: 61.1%
Question: find working capital for 2018
Additional information: 2017
current ratio 1.5:1
working capital: 214,500
Question find debt to total assets for 2017
arrow_forward
nterpret the results of the debt to equity ratio and how the company has managed debt over the last two years.
Balance Sheet
2018
2019
Cash
$63,000
$201,000
Accounts Receivable
199,000
305,000
Marketable Securities
81,000
42,000
Inventories
441,000
455,000
Prepaids
5,000
9,000
Total Current Assets
789,000
1,012,000
Property, Plant, and Equipment, net
858,000
858,000
Total Assets
$1,647,000
$1,870,000
Account Payable
$150,000
$100,000
Accruals
101,000
95,000
Total Current Liabilities
$251,000
$195,000
Bonds Payable
405,000
575,000
Total Liabilities
656,000
770,000
Common Stocks
700,000
700,000
Retained Earnings
291,000
400,000
Total Stockholders’ Equity
991,000
1,100,000
Total Liabilities & Equity
$1,647,000
$1,870,000
Income Statement…
arrow_forward
Lendell Company has these comparative balance sheet data:
Lendell CompanyBalance SheetsDecember 31
2020
2019
Cash
$ 16,000
$ 31,000
Accounts receivable (net)
69,000
60,000
Inventory
59,000
51,000
Plant assets (net)
198,000
179,000
$342,000
$321,000
Accounts payable
$50,000
$60,700
Mortgage payable (15%)
107,500
107,500
Common stock, $10 par
136,500
121,000
Retained earnings
48,000
31,800
$342,000
$321,000
Additional information for 2020:
1.
Net income was $24,700.
2.
Sales on account were $414,050. Sales returns and allowances amounted to $20,600.
3.
Cost of goods sold was $198,000.
4.
Net cash provided by operating activities was $44,300.
5.
Capital expenditures were $26,400, and cash dividends were $8,800.
Compute the following ratios at December 31, 2020. (Round current ratio to 2 decimal places, e.g. 1.67. Round…
arrow_forward
Just Dew It Corporation reports the following balance sheet information for 2020 and
2021.
Assets
Current assets
Cash
Accounts receivable
Inventory
Total
Total assets
2020
Net plant and equipment $240,750 $310,600
a. Current ratio
b. Quick ratio
c. Cash ratio
d. NWC ratio
e. Debt-equity ratio
e. Equity multiplier
f. Total debt ratio
f. Long-term debt ratio
$8,850 $14,200
15,750 23,000
34,650 52,200
$ 59,250 $89,400
JUST DEW IT CORPORATION
2020 and 2021 Balance Sheets
2021
300,000 400,000
2020
times
times
times
%
times
times
times
times
Liabilities and Owners' Equity
Current liabilities
2021
Accounts payable
Notes payable
Based on the balance sheets given for Just Dew It:
a. Calculate the current ratio for each year. (Do not round intermediate calculations
and round your answers to 2 decimal places, e.g., 32.16.)
b. Calculate the quick ratio for each year. (Do not round intermediate calculations and
round your answers to 2 decimal places, e.g., 32.16.)
c. Calculate the cash ratio for…
arrow_forward
Cullumber Company has these comparative balance sheet data:
CULLUMBER COMPANYBalance SheetsDecember 31
2022
2021
Cash
$ 16,350
$ 32,700
Accounts receivable (net)
76,300
65,400
Inventory
65,400
54,500
Plant assets (net)
218,000
196,200
$376,050
$348,800
Accounts payable
$ 54,500
$ 65,400
Mortgage payable (15%)
109,000
109,000
Common stock, $10 par
152,600
130,800
Retained earnings
59,950
43,600
$376,050
$348,800
Additional information for 2022:
1.
Net income was $34,000.
2.
Sales on account were $383,300. Sales returns and allowances amounted to $26,600.
3.
Cost of goods sold was $200,600.
4.
Net cash provided by operating activities was $59,000.
5.
Capital expenditures were $26,400, and cash dividends were $16,500.
(d)
Inventory turnover.
enter inventory turnover in times rounded to 2 decimal places
times
(e)…
arrow_forward
Cullumber Company has these comparative balance sheet data:
CULLUMBER COMPANYBalance SheetsDecember 31
2022
2021
Cash
$ 16,350
$ 32,700
Accounts receivable (net)
76,300
65,400
Inventory
65,400
54,500
Plant assets (net)
218,000
196,200
$376,050
$348,800
Accounts payable
$ 54,500
$ 65,400
Mortgage payable (15%)
109,000
109,000
Common stock, $10 par
152,600
130,800
Retained earnings
59,950
43,600
$376,050
$348,800
Additional information for 2022:
1.
Net income was $34,000.
2.
Sales on account were $383,300. Sales returns and allowances amounted to $26,600.
3.
Cost of goods sold was $200,600.
4.
Net cash provided by operating activities was $59,000.
5.
Capital expenditures were $26,400, and cash dividends were $16,500.
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
arrow_forward
Total fixed assets
31420 OMR
Total long term liabilities
9970 OMR
Total current assets
18930 OMR
Total current liabilities
4765 OMR
Shareholders’ funds
35615 OMR
Capital employed
45585 OMR
Gross profit
175000 OMR
Net profit
113950 OMR
Return on capital employed
25%
Current ratio
3.97
Liquid ratio
3.34
Return on Equity
3.191
Gross Profit Margin
53,03%
Net Profit Margin
34.53%
Q/Give a brief report on the financial position of the company based on the above figures?
arrow_forward
Comparative balance sheet accounts of Riverbed Company are presented below.
RIVERBED COMPANYCOMPARATIVE BALANCE SHEET ACCOUNTSAS OF DECEMBER 31
Debit Balances
2020
2019
Cash
$69,300
$51,100
Accounts Receivable
154,900
130,000
Inventory
75,600
60,700
Debt investments (available-for-sale)
54,500
85,100
Equipment
70,600
48,100
Buildings
146,000
146,000
Land
40,200
24,700
Totals
$611,100
$545,700
Credit Balances
Allowance for Doubtful Accounts
$10,100
$7,900
Accumulated Depreciation—Equipment
20,900
13,900
Accumulated Depreciation—Buildings
37,300
28,200
Accounts Payable
66,100
60,600
Income Taxes Payable
12,100
10,000
Long-Term Notes Payable
62,000
70,000
Common Stock
310,000
260,000
Retained Earnings
92,600
95,100
Totals
$611,100
$545,700
Additional data:
1.…
arrow_forward
Lendell Company has these comparative balance sheet data:
Lendell CompanyBalance SheetsDecember 31
2020
2019
Cash
$ 16,000
$ 30,000
Accounts receivable (net)
70,000
59,000
Inventory
59,000
49,000
Plant assets (net)
200,000
179,000
$345,000
$317,000
Accounts payable
$50,000
$59,000
Mortgage payable (15%)
106,500
106,500
Common stock, $10 par
142,000
125,000
Retained earnings
46,500
26,500
$345,000
$317,000
Additional information for 2020:
1.
Net income was $25,600.
2.
Sales on account were $406,800. Sales returns and allowances amounted to $19,800.
3.
Cost of goods sold was $199,800.
4.
Net cash provided by operating activities was $45,700.
5.
Capital expenditures were $23,600, and cash dividends were $10,200.
Compute the following ratios at December 31, 2020. (Round current ratio to 2 decimal places, e.g. 1.67. Round Accounts receivable…
arrow_forward
View Policies
Current Attempt in Progress
The comparative statement of financial position for Sunland Corporation shows the following noncash current asset and liability
accounts at March 31:
2021
2020
Accounts receivable
$65,000
$42,000
Inventory
80,000
63,500
Accounts payable
35,000
44,000
Dividends payable
1,400
2,400
Sunland's statement of income reported the following selected information for the year ended March31, 2021: net income was
$270,000, depreciation expense was $65,000, and a loss on the disposal of land was $15,000. Sunland uses a perpetual inventory
system. Calculate net cash provided (used) by operating activities using the indirect method. (Show amounts that decrease cash flow with
either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)
SUNLAND CORPORATION
Statement of Cash Flows (Partial)
Operating activities
Adjustments to reconcile net income to
arrow_forward
Daidnice oneels as of December
2021
2020
Assets
Cash and equivalents
$ 14,000
$ 12,000
Accounts receivable
Inventories
35,000
30,000
34,845
29,000
Total current assets
$ 83,845
$ 71,000
Net plant and equipment
49,000
46,000
Total assets
$132,845
$117,000
Liabilities and Equity
Accounts payable
$10,500
$9,500
Accruals
8,000
5,000
Notes payable
6,600
5,300
Total current liabilities
$ 25,100
$ 19,800
Long-term bonds
20,000
20,000
Total liabilities
$ 45,100
$ 39,800
Common stock (4,000 shares)
60,000
60.000
Retained earnings
Common equity
Total liabilities and equity
27,745
17,200
$ 87,745
$ 77,200
$132,845
$117,000
Income Statement for Year Ending December 31, 2021
Sales
$215,000
Operating costs excluding depreciation and amortization
EBITDA
170,000
$ 45,000
Depreciation & amortization
7,000
EBIT
Interest
$ 38,000
EBT
Taxes (25%)
Net income
Dividends paid
700
$ 37,300
9,325.00
$27.975.00
$17,430.00
Enter your answers in millions. For example, an answer of $25,000,000,000 should be entered…
arrow_forward
Condensed balance sheet and income statement data for Jergan Corporation are presented here.
Jergan CorporationBalance SheetsDecember 31
2020
2019
2018
Cash
$ 30,800
$ 17,600
$ 18,700
Accounts receivable (net)
50,500
44,200
47,100
Other current assets
89,600
94,900
63,900
Investments
55,300
71,000
45,100
Plant and equipment (net)
500,500
370,000
358,500
$726,700
$597,700
$533,300
Current liabilities
$85,500
$79,800
$69,400
Long-term debt
144,300
84,100
50,300
Common stock, $10 par
348,000
316,000
304,000
Retained earnings
148,900
117,800
109,600
$726,700
$597,700
$533,300
Jergan CorporationIncome StatementFor the Years Ended December 31
2020
2019
Sales revenue
$738,000
$605,500
Less: Sales returns and allowances
39,100
29,900
Net sales…
arrow_forward
Carla Vista Co. has these comparative balance sheet data:
CARLA VISTA CO.Balance SheetsDecember 31
2022
2021
Cash
$ 16,140
$ 32,280
Accounts receivable (net)
75,320
64,560
Inventory
64,560
53,800
Plant assets (net)
215,200
193,680
$371,220
$344,320
Accounts payable
$ 53,800
$ 64,560
Mortgage payable (15%)
107,600
107,600
Common stock, $10 par
150,640
129,120
Retained earnings
59,180
43,040
$371,220
$344,320
Additional information for 2022:
1.
Net income was $32,500.
2.
Sales on account were $392,900. Sales returns and allowances amounted to $27,300.
3.
Cost of goods sold was $217,300.
4.
Net cash provided by operating activities was $57,200.
5.
Capital expenditures were $30,000, and cash dividends were $19,000.
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
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
- Seminole Corporation reported the following items at December 31, 2021, and 2020: (Click the icon to view the comparative financial information.) Read the requirements. Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio value as strong or weak. All sales are on account with terms of net 30 days. (a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents. Round your final answer to two decimal places.) Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio $ Seminole's quick (acid-test) ratio is considered fairly weak. (b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal places, XX.XX. Round the days' sales outstanding up to the next whole day.) Accounts receivable turnover = + Days' sales outstanding Seminole's days'…arrow_forward-Equity Ratio-Debt to equity ratio-Times interest earned-Return on common stockholders equity Figure each ratio outarrow_forwardRatio Analysis Consider the following information taken from GER's financial statements: September 30(in thousands) 2020 2019 Current assets: Cash and cash equivalents $1,274 $6,450 Receivables 30,071 16,548 Inventories 31,796 14,072 Other current assets 4,818 2,620 Total current assets $67,959 $39,690 Current liabilities: Current portion of long-term debt $97 $3,530 Accounts payable 23,124 11,228 Accrued compensation costs 5,606 1,929 Accrued expenses 9,108 5,054 Other current liabilities 874 777 Total current liabilities $38,809 $22,518 Also, GER's operating cash flows were $11,255 and $13,736 in 2020 and 2019, respectively. 4. Calculate the operating cash flow ratios for 2020 and 2019. Operating Cash Flow Ratio 2020 fill in the blank 7 2019 fill in the blank 8arrow_forward
- Liquidity Ratios: 2022 2021 Current ratio Working capital I need help finding liquidity ratios. Could you explain why you got that? Thanks.arrow_forwardWhat is Ratio Corporation's Fiscal 2021 Times Interest Earned Ratio? 1.41 2.57 4.5 1.63arrow_forwardCalculate the leverage ratio which includes total debt to total assets ratio, equity multiplier, debt to equity ratio, current liabilities to total debt ratio, interest coverage, and fixed charges coverage.arrow_forward
- Solar Electric Inc. Balance Sheet 32 Marks ACB As at December 31, 2023 Account Title Debit Credit Assets Current Assets Cash 100,649 Accounts Receivable 35,860 Interest Rceivable 9,113 Prepaid Insurance 7,370 Short-Term Investment- Citi Inc 237,000 Short-Term Investment- Bonds 135,000 Inventory 90,640 Valuation Allowance for Fair Value Adjustment 50,700 Total Current Assets 666,332 Non-current Assets Investment in HSBC Inc. Common Shares 503,840 Long-Term Investment- Bond 145,000 Property, Plant & Equipment 280,000 Accumulated Depreciation 86,000 Total Non-Current Assets 842,840 Total Assets 1,509,172 Liabilities Current Liabilities Accounts Payable 212,400 Interest Payable 31,167 Unearned Revenue 21,000 Total Current Liabilities 264,567 Long-Term Liabilities Bonds Payable 340,000 Discount on Bonds Payable 15,741 Bank Loan 225,000 Total-Long Term Liabilities 549,259 Total Liabilities 813,826 Shareholders Equity Common Shares 362,000 Preferred Shares 80,000 Retained Earnings 348,385…arrow_forwardPharoah Corporation’s comparative balance sheet is presented below. PHAROAH CORPORATIONBalance SheetDecember 31 Assets 2021 2020 Cash $12,010 $8,980 Accounts receivable 17,810 19,660 Land 16,800 21,840 Buildings 58,800 58,800 Accumulated depreciation—buildings (12,600 ) (8,400 ) Total $92,820 $100,880 Liabilities and Shareholders’ Equity Accounts payable $10,390 $26,120 Common shares 63,000 57,960 Retained earnings 19,430 16,800 Total $92,820 $100,880 Additional information: 1. Profit was $19,010. Dividends declared and paid were $16,380. 2. No noncash investing and financing activities occurred during 2021. 3. The land was sold for cash of $4,120 resulting in a loss of $920 on the sale of the land. Prepare a cash flow statement for 2021 using the indirect method. Lu…arrow_forwardPlease input numbers in boxes below based on data provided for year 2018. Current assets - current liabilities = net working capitalarrow_forward
- Cullumber Company has these comparative balance sheet data: CULLUMBER COMPANYBalance SheetsDecember 31 2020 2019 Cash $ 16,350 $ 32,700 Accounts receivable (net) 76,300 65,400 Inventory 65,400 54,500 Plant assets (net) 218,000 196,200 $376,050 $348,800 Accounts payable $ 54,500 $ 65,400 Mortgage payable (15%) 109,000 109,000 Common stock, $10 par 152,600 130,800 Retained earnings 59,950 43,600 $376,050 $348,800 Additional information for 2020: 1. Net income was $34,000. 2. Sales on account were $383,300. Sales returns and allowances amounted to $26,600. 3. Cost of goods sold was $200,600. 4. Net cash provided by operating activities was $59,000. 5. Capital expenditures were $26,400, and cash dividends were $16,500. Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g.…arrow_forwardCarla Vista Co. has these comparative balance sheet data: CARLA VISTA CO.Balance SheetsDecember 31 2020 2019 Cash $ 16,140 $ 32,280 Accounts receivable (net) 75,320 64,560 Inventory 64,560 53,800 Plant assets (net) 215,200 193,680 $371,220 $344,320 Accounts payable $ 53,800 $ 64,560 Mortgage payable (15%) 107,600 107,600 Common stock, $10 par 150,640 129,120 Retained earnings 59,180 43,040 $371,220 $344,320 Additional information for 2020: 1. Net income was $32,500. 2. Sales on account were $392,900. Sales returns and allowances amounted to $27,300. 3. Cost of goods sold was $217,300. 4. Net cash provided by operating activities was $57,200. 5. Capital expenditures were $30,000, and cash dividends were $19,000. Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…arrow_forwardMarina Company Statement of Financial Position June 30, 2020 AssetsCurrent Assets Cash P 21,000.00 Accounts Receivables 160,000.00 Merchandise Inventory 300,000.00 Prepaid Expenses 9,000.00Total Current Assets P 490,000.00Property, Plant and Equipment 810,000.00Total Assets P 1,300,000.00 Liabilities and EquityLiabilities: Current Liabilities P 200,000.00 Bonds Payable, 10% 300,000.00Total Liabilities P 500,000.00Equity:…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
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
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