L2
xlsx
keyboard_arrow_up
School
Temple University *
*We aren’t endorsed by this school
Course
3901
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
9
Uploaded by joeyleone
ADVANCED PROBLEM 2-2 FOR SPREADSHEET APPLICATIO
Solution
Balance Sheet as
ASSETS
2014
2013
Current assets
Cash
$ 26,000 $ 23,000 Marketable securities
$ 58,000 Accounts receivable
$ 518,000 Inventory
$ 910,000 $ 639,000 Total current assets
$ 994,000 $ 1,242,000 Fixed assets
$ 4,975,000 $ 4,387,000 Accumulated depreciation
$ -1,364,000 Intangible assets
$ 431,000 $ 465,000 Total long-term assets
$ 4,042,000 TOTAL ASSETS
$ 5,036,000 $ 5,085,000 Does the change in the total assets equal the change in the total liabiliti
Balance sheet. Reach Manufacturing has lost its computer systems and
information out of its crashed computer:
a.
Reconstruct the balance sheets for 2013 and 2014 using a spreadshee
assets, current liabilities, total liabilities, total owners' equity, and total years. Verify that the changes in the total assets equal the changes in th
b.
Find the cash flow from assets for the year 2013 if the OCF for 2013
a.
Reconstruct the balance sheets for 2013 and 2014 using a spreadshee
assets, current liabilities, total liabilities, total owners' equity, and total years. Verify that the changes in the total assets equal the changes in th
b. Find the cash flow from assets for the year 2013 if the OCF for 2013
Operating cash flow (OCF)
Net working capital (NWC) for 2013
Net working capital (NWC) for 2014
Change in fixed assets from 2013 to 2014
Change in intangible assets from 2013 to 2014
Requirements
1.
Start Excel.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
-
Change in NWC
- Capital spending
= Cash flow from assets
In cell D22
, by using cell references, calculate the total long-term
sheet.
In cell D23
, by using a cell reference, calculate the total assets for
Note:
The total assets must equal the total liabilities and owners' e
In cell D18
, by using cell references, calculate the total current as
In cell D16
, by using cell references, calculate the accounts receiv
In cell H14
, by using cell references, calculate the accounts payab
In cell H22
, by using cell references, calculate the total owners' eq
sheet.
In cell H18
, by using cell references, calculate the total liabilities In cell H17
, by using cell references, calculate the long-term debt
In cell E15
, by using cell references, calculate the marketable sec
sheet.
In cell E22
, by using cell references, calculate the total long-term
sheet.
In cell E20
, by using cell references, calculate the accumulated de
In cell I16
, by using cell references, calculate the total current liab
sheet.
In cell I18
, by using cell references, calculate the total liabilities f
In cell I23
, by using a cell reference, calculate the total liabilites a
the balance sheet.
In cell I22
, by using cell references, calculate the total owners' eq
In cell I21
, by using cell references, calculate the retained earning
In cell F14
, by using cell references, calculate the change in the c
In cell range F15:F23
, by using cell references, calculate the chan
from cell F14
and paste it to cell range F15:F23
.
20.
21.
22.
23.
24.
25.
26.
27.
28.
Save the workbook. Close the workbook and then exit Excel. Sub
In cell J14
, by using cell references, calculate the change in the ac
In cell ranges J15:J18 and
J20:J23
, by using cell references, calc
2013 to 2014. Copy the content from cell J14
and paste it to cell r
In cell H25
, type either Yes
or No
depending on whether the chan
In cell F30
, by using cell references, calculate the net working cap
In cell F31
, by using cell references, calculate the net working cap
In cell F32
, by using cell references, calculate the change in NWC
to 2014. Use cells F33
and F34
.
In cell F36
, by using cell references, calculate the cash flow from
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
ON
Reach Manufacturing
s of December 31, 2014, and December 31, 2013 Change
LIABILITIES
2014
2013
Current liabilities
$ 0 Accounts payable
$ 419,000 #DIV/0!
Notes payable
$ 210,000 $ 390,000 $ -1 Total current liabilities
$ 889,000 $ 0 Long-term debt
$ 3,540,000 $ -0 Total liabilities
$ 1,099,000 $ 4,349,000 $ 0 OWNERS' EQUITY
#DIV/0!
Common stock
$ 330,000 $ 330,000 $ -0 Retained earnings
$ 701,000 #DIV/0!
Total owners' equity
$ 1,031,000 $ 330,000 $ -0 $ 5,832,000 $ 4,679,000 ies and owners' equity?
Yes
d must reconstruct the last two years of its balance sheet. The company has been ab
et, and find the change in each account and each category balance (current assets, lo
liabilities and owners' equity) from 2013 to 2014. The balance sheet has the same a
he total liabilities and owners' equity.
3 is $389,000. Note
: Treat intangible assets as a capital spending item.
et, and find the change in each account and each category balance (current assets, lo
liabilities and owners' equity) from 2013 to 2014. The balance sheet has the same a
he total liabilities and owners' equity.
TOTAL LIABILITIES AND
OWNERS' EQUITY
3 is $389,000.
$ 389,000 $ 406,000 $ -796,000 $ -2 $ 0 $ -0 m assets for year 2014. Use the relevant cells from the given data in the balance r year 2014. Refer to the relevant cell from the given data in the balance sheet.
equity.
ssets for year 2014. Use the relevant cells in the balance sheet.
vable for year 2014. Use the relevant cells in the balance sheet.
ble for year 2014. Use the relevant cells from the given data in the balance sheet.
quity for year 2014. Use the relevant cells from the given data in the balance for year 2014. Use the relevant cells in the balance sheet.
t for year 2014. Use the relevant cells in the balance sheet.
curities for year 2013. Use the relevant cells from the given data in the balance m assets for year 2013. Use the relevant cells from the given data in the balance epreciation for year 2013. Use the relevant cells in the balance sheet.
bilities for year 2013. Use the relevant cells from the given data in the balance for year 2013. Use the relevant cells in the balance sheet.
and owners' equity for year 2013. Refer to the relevant cell from the given data in quity for year 2013. Use the relevant cells in the balance sheet.
gs for year 2013. Use the relevant cells in the balance sheet.
cash from 2013 to 2014.
nge in other accounts of the firm's assets from 2013 to 2014. Copy the content
bmit the workbook as directed.
ccounts payable from 2013 to 2014.
culate the change in other accounts of the firm's liabilities and owners' equity from ranges J15:FJ18 and
J20:J23
.
nges in the total assets equal the changes in the total liabilities and owners' equity.
pital (NWC) for year 2013. Use the relevant cells from the balance sheet in part a
.
pital (NWC) for year 2014. Use the relevant cells from the balance sheet in part a
.
C from 2013 to 2014. Use cells F30
and F31
.
m assets. Use cells F29
, F32
, and F35
.
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
Change
$ -1 $ -0 #DIV/0!
$ -1 $ -1 #DIV/0!
$ - #DIV/0!
$ 2 $ 0 ble to get some ong-term assets, total accounts in both ong-term assets, total accounts in both
Points
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
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
Hcs/380 Calculate the 2022 return on assets ratio
arrow_forward
Pls stepwise with explanation and correct only.
arrow_forward
perform a DuPont analysis?
arrow_forward
Required:
• Vertical analysis
• Descriptive Analysi
arrow_forward
Condensed financial data of Crane Inc. follow.
CRANE INC.Comparative Balance SheetsDecember 31
Assets
2022
2021
Cash
$117,100
$47,400
Accounts receivable
93,000
32,700
Inventory
111,400
102,700
Prepaid expenses
30,000
25,300
Long-term investments
141,000
113,100
Plant assets
274,700
241,500
Accumulated depreciation
(46,100)
(51,500)
Total
$721,100
$511,200
Liabilities and Stockholders’ Equity
Accounts payable
$111,300
$67,100
Accrued expenses payable
16,100
17,400
Bonds payable
118,400
149,600
Common stock
220,900
174,000
Retained earnings
254,400
103,100
Total
$721,100
$511,200
CRANE INC.Income StatementFor the Year Ended December 31, 2022…
arrow_forward
Condensed financial data of Crane Inc. follow.
CRANE INC.Comparative Balance SheetsDecember 31
Assets
2022
2021
Cash
$117,100
$47,400
Accounts receivable
93,000
32,700
Inventory
111,400
102,700
Prepaid expenses
30,000
25,300
Long-term investments
141,000
113,100
Plant assets
274,700
241,500
Accumulated depreciation
(46,100)
(51,500)
Total
$721,100
$511,200
Liabilities and Stockholders’ Equity
Accounts payable
$111,300
$67,100
Accrued expenses payable
16,100
17,400
Bonds payable
118,400
149,600
Common stock
220,900
174,000
Retained earnings
254,400
103,100
Total
$721,100
$511,200
CRANE INC.Income StatementFor the Year Ended December 31, 2022…
arrow_forward
Problem #1
The following balance sheet and income statement data is given:
31-Dec
Yr 2021
Yr 2020
Cash
$4,300
$3,700
Accounts receivable (net)
22,000
23,400
Inventories
10,000
7,000
Plant assets (net)
75,000
86,000
Total assets
111,300
120,100
Accounts payable
12,370
11,100
Bonds payable
70,000
70,000
Total liabilities
82,370
81,100
Common stock, $10 par
65,000
59,000
Paid-in capital
10,000
10,000
Retained earnings
24,300
20,600
Total stockholders’ equity
99,300
89,600
Net credit sales
100,000
Cost of goods sold
60,350
Gross profit
39,650
Net income
14,000
REQUIRED:
Compute the following ratios for 2021.
NOTE: Copy and paste the information below into the answer box first and then show your calculation steps for this problem to receive credits.
(1) Accounts receivable turnover=____________________
(2) Inventory turnover=__________________
(3) Accounts payable…
arrow_forward
exercise 12-7
Shown below are comparative balance sheets for Sandhill Company.
Sandhill CompanyComparative Balance SheetsDecember 31
Assets
2017
2016
Cash
$ 211,208
$ 68,332
Accounts receivable
273,328
236,056
Inventory
518,702
587,034
Land
248,480
310,600
Equipment
807,560
621,200
Accumulated depreciation—equipment
(204,996
)
(99,392
)
Total
$1,854,282
$1,723,830
Liabilities and Stockholders’ Equity
Accounts payable
$ 121,134
$ 133,558
Bonds payable
465,900
621,200
Common stock ($1 par)
670,896
540,444
Retained earnings
596,352
428,628
Total
$1,854,282
$1,723,830
Additional information:
1.
Net income for 2017 was $288,858.
2.
Depreciation expense was $105,604.
3.
Cash dividends of $121,134 were declared and paid.
4.
Bonds…
arrow_forward
How to calculate Net Operating Asset from this balance sheet for fiscal year-end 2015 .
arrow_forward
answer please?
arrow_forward
Condensed financial data of Coronado Inc. follow.
CORONADO INC.Comparative Balance SheetsDecember 31
Assets
2022
2021
Cash
$81,100
$49,000
Accounts receivable
87,700
38,100
Inventory
111,200
102,100
Prepaid expenses
29,000
27,500
Long-term investments
140,900
113,300
Plant assets
285,000
242,400
Accumulated depreciation
(46,800)
(48,400)
Total
$688,100
$524,000
Liabilities and Stockholders’ Equity
Accounts payable
$110,000
$67,400
Accrued expenses payable
16,500
21,500
Bonds payable
119,300
149,300
Common stock
219,900
174,600
Retained earnings
222,400
111,200
Total
$688,100
$524,000
CORONADO INC.Income StatementFor the Year Ended December 31, 2022
Sales revenue
$376,500
Less:…
arrow_forward
Condensed financial data of Coronado Inc. follow.
CORONADO INC.Comparative Balance SheetsDecember 31
Assets
2022
2021
Cash
$81,100
$49,000
Accounts receivable
87,700
38,100
Inventory
111,200
102,100
Prepaid expenses
29,000
27,500
Long-term investments
140,900
113,300
Plant assets
285,000
242,400
Accumulated depreciation
(46,800)
(48,400)
Total
$688,100
$524,000
Liabilities and Stockholders’ Equity
Accounts payable
$110,000
$67,400
Accrued expenses payable
16,500
21,500
Bonds payable
119,300
149,300
Common stock
219,900
174,600
Retained earnings
222,400
111,200
Total
$688,100
$524,000
CORONADO INC.Income StatementFor the Year Ended December 31, 2022
Sales revenue
$376,500
Less:…
arrow_forward
Assets
Current assets
Net fixed assets
INCOME STATEMENT, 2022
(Figures in $ millions)
Revenue
Cost of goods sold
Depreciation
Interest expense
2021
$ 101
2022
$ 195
910 1,010
$ 2,005
1,085
405
251
Req A and B Req C and D
BALANCE SHEET AT END OF YEAR
(Figures in $ millions)
Liabilities and Shareholders' Equity
Current liabilities
Long-term debt
Req E
Complete this question by entering your answers in the tabs below.
a&b. What is shareholders' equity in 2021 and 2022?
c&d. What is net working capital in 2021 and 2022?
e. What are taxes paid in 2022? Assume the firm pays taxes equal to 21% of taxable income.
f. What is cash provided by operations during 2022?
g.Net fixed assets increased from $910 million to $1,010 million during 2022. What must have been South Sea's gross investment in
fixed assets during 2022?
Answer is complete but not entirely correct.
h. If South Sea reduced its outstanding accounts payable by $46 million during the year, what must have happened to its other current…
arrow_forward
Balance Sheet for Bearcat Hathaway, 2022
2021
2022
Cash
Accounts
Receivable
Inventory
Current Assets
Accum.Depreciation
Net Fixed Assets
Gross Fixed Assets $16,251,665 $20,567,330
Less
$7,460,897 $10,117,819
Total Assets
O 11.58%
O 44.90%
O 8.37%
$5,268,485 $10,268,485
O 4.35%
$2,574,230 $2,314,672
O 6.02%
$529,062 $696,685
$8,371,777 $13,279,842
Total Liabilities
and Equity
What is the common size value for 2022 Notes Payable?
$8,790,768 $10,449,511
$17,162,545 $23,729,353
Current
Liabilities
2021
Accounts
Payable
Notes Payable $1,033,110 $1,987,233
2022
$1,673,992 $2,438,271
$2,707,102 $4,425,504
Long Term Debt $9,242,830 $11,468,302
Total Liabilities $11,949,932 $15,893,806
Common Stock
($0.50 par)
$1,300,000 $1,600,000
Capital Surplus $1,148,120 $1,800,969
Retained
$2,764,493 $4,434,578
Earnings
$17,162,545 $23,729,353
arrow_forward
LOGIC COMPANY
Comparative Income Statement
For Years Ended December 31, 2017 and 2018
2018
2017
$20,600 $16,200
800
Gross sales
100
Sales returns and allowances
$19,800 $16,100
11,600
$ 8,200 $ 7,500
Net sales
8,600
Cost of merchandise (goods) sold
Gross profit
Operating expenses:
Depreciation
Selling and administrative
Research
$
3,400
860 $
680
2,800
710
580
Miscellaneous
520
380
$ 5,490 $ 4,440
$ 2,710 $ 3,060
Total operating expenses
Income before interest and taxes
Interest expense
720
580
$ 1,990 $ 2,480
796
Income before taxes
Provision for taxes
992
Net income
$ 1,194 $ 1,488
LOGIC COMPANY
Comparative Balance Sheet
December 31, 2017 and 2018
2018
2017
Assets
Current assets:
Cash
$12,800 $ 9,800
13,300
14,800
10.800
Accounts receivable
17,300
9,300
Merchandise inventory
Prepaid expenses
24.800
Prou
arrow_forward
Question:
Bethesda Mining Company
Balance Sheets as of December 31, 2015 and 2016
2015
2016
2015
2016
Assets
Liabilities and Owners' Equity
Current assets
Current liabilities
Cash
$65,470 $82,487 Accounts payable
Accounts receivable
65,281 85,639
Notes payable
$186,922 $194,611
82,020 133,588
Inventory
Total
116,676 181,549 Total
$247,427 $349,675 Long-term debt
Owners' equity
Common stock and paid-in surplus $224,000 $224,000
$268,942 $328,199
$231,000 $167,750
Fixed assets
Accumulated retained earnings
Net plant and equipment $658,747 $589,978 Total
Total assets
182,232 219,704
$406,232 $443,704
$906,174 $939,653 Total liabilities and owners' equity $906,174 $939,653
Suppose that the Bethesda Mining Company had sales of $2,316,873 and net income of $93,381 for the year ending December 31, 2016.
Calculate ROE using the DuPont identity.
arrow_forward
2018
2017
Assets
Cash
90,800
48,400
Accounts receivable
92,800
33,000
Inventories
112,500
102,850
Prepaid expenses
28,400
26,000
Supplies
138,000
114,000
Machine
270,000
242,500
Less: Accumulated depreciation
-50,000
-52,000
Total
682,500
514,750
Liabilities and Shareholder’s equities
Accounts payable
112,000
67,300
Other payable
16,500
17,000
Notes payable
110,000
150,000
Total paid-in capital
220,000
175,000
Retained earnings
224,000
105,450
Total
682,500
514,750
Income statement for the year ended 31 Dec 2018
Sales revenue
392,780
Cost of goods sold
135,460
Gross profit
257,320
Adverting expense
12,410
Depreciation expense
46,500
Income taxes expense
27,280
Interest expense
4,730
Loss on sale of machine
7,500
Net income
158,900
Please prepare cash flow statement for the year ended 31 Dec 2018, show T-Account of Retain earning at 31 Dec 2018
arrow_forward
prepeare cash flow statememt
arrow_forward
Solving pls
arrow_forward
Loans and
borrowings
Deferred taxek
liability
14,130
10,220-
1,010
960-
15,140
11,180
Current
Liabilities
Trade
payable
Current tax
1,260
1,140
1,040
920
payable
Interest
payable
980-
740k
3,280
40,190
2,800
32,960
Total Equity
and
Liabilities
2019
£'000
2018
£'000
Sales
Cost of sales
Distribution costse
Administration expenses
Gain on disposal of PPE
22,000
(11,800)
(3,100)
(1,630)
280
16,000
(8,200)
(2,600)
(1,420)
Interest expensee a
Тах еexpensee
(1,140)
(1,820)
(760)
(1,240)
Net profit
2,790
1,780
1.
The company disposal of PPE during the year with a book value of £1,000,000.
2. Depreciation of property, plant and equipment for the year was £650,000.4
The intangibles were acquired for cash towards the end of the year and were not sub ject to
any amortisation in the current period.e
3.
Prepare the statement of cash flows using the indirect method.
arrow_forward
Condensed financial data of Concord Inc. follow.
CONCORD INC.Comparative Balance SheetsDecember 31
Assets
2022
2021
Cash
$80,500
$48,700
Accounts receivable
87,900
38,600
Inventory
111,900
102,100
Prepaid expenses
29,400
27,900
Long-term investments
139,800
113,700
Plant assets
284,200
241,900
Accumulated depreciation
(47,700)
(49,100)
Total
$686,000
$523,800
Liabilities and Stockholders’ Equity
Accounts payable
$106,000
$63,700
Accrued expenses payable
16,500
21,200
Bonds payable
117,100
149,500
Common stock
219,000
175,100
Retained earnings
227,400
114,300
Total
$686,000
$523,800
CONCORD INC.Income StatementFor the Year Ended December 31, 2022
Sales revenue
$382,500
Less:
Cost of goods sold…
arrow_forward
Question 10 of 25
Based on the following data, what is the amount of working capital?
Accounts payable
Accounts receivable
Cash
Intangible assets
Inventory
Long-term investments
Long-term liabilities
Short-term investments
Notes payable (short-term)
Property, plant, and equipment
Prepaid insurance
$404240
O $411680
>
O $458800
$79360
141360
86800
124000
171120
198400
248000
99200
69440
1661600
2480
arrow_forward
Problem: Apple Tree Factory
Statement of Comprehensive Income
For the Year-ended December 31
2014
2013
Sales
10,040,000
8,760,000
Cost of Goods Sold
5,680,000
5,860,000
Gross Profit
4,360,000
2,800,000
Operating Expenses
1,160,000
1,680,000
Operating Income
3,200,000
1,220,000
Interest Expense
100,000
28,000
Net Income
3,1000,000
1,192,000
arrow_forward
PLASMA SCREENS CORPORATION
Balance Sheets
December 31, 2021 and 2020
2021
2020
Assets
Current assets:
Cash
$ 155,100
74,800
87,000
2,400
171,800
88,000
72,800
1,200
Accounts receivable
Inventory
Prepaid rent
Long-term assets:
Land
440,000
732,00ө
(406, ө00)
$1,085,300
440, ө0ө
630,000
252,000)
$1,151,800
Equipment
Accumulated depreciation
Total assets
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable
Interest payable
Income tax payable
Long-term liabilities:
Notes payable
Stockholders' equity:
91,000
6,900
6,400
$ 77,800
13,800
4, 200
115,000
230,000
Common stock
660,000
206,000
$1,085,300
660,000
166,000
$1,151,800
Retained earnings
Total liabilities and stockholders' equity
Additional Information for 2021:
1. Net income is $61,000.
2. The company purchases $102,000 in equipment.
3. Depreciation expense is $154,000.
4. The company repays $115,000 in notes payable.
5. The company declares and pays a cash dividend of $21,000.
%24
%24
%24
arrow_forward
Keurig Green Mountain's Current Liabilities
Following is the current assets and current liabilities portion of the balance sheet of Keurig Green Mountain for the years ended September 26, 2015, and September 27, 2014:
(Dollars in thousands)
September 26, 2015
September 27, 2014
Current assets:
Cash and cash equivalents
$59,334
$761,214
Restricted cash and cash equivalents
30,460
378
Short-term investment
—
100,000
Receivables, less uncollectible accounts and return allowances of $35,459 and $66,120 at September 26, 2015 and September 27, 2014, respectively
517,936
621,451
Inventories
691,980
835,167
Income taxes receivable
51,786
—
Other current assets
95,526
69,272
Deferred income taxes, net
70,181
58,038
Total current assets
$1,517,203
$2,445,520
Current liabilities:
Current portion of long-term debt…
arrow_forward
Keurig Green Mountain's Current Liabilities
Following is the current assets and current liabilities portion of the balance sheet of Keurig Green Mountain for the years ended September 26, 2015, and September 27, 2014:
(Dollars in thousands)
September 26, 2015
September 27, 2014
Current assets:
Cash and cash equivalents
$59,334
$761,214
Restricted cash and cash equivalents
30,460
378
Short-term investment
—
100,000
Receivables, less uncollectible accounts and return allowances of $35,459 and $66,120 at September 26, 2015 and September 27, 2014, respectively
517,936
621,451
Inventories
691,980
835,167
Income taxes receivable
51,786
—
Other current assets
95,526
69,272
Deferred income taxes, net
70,181
58,038
Total current assets
$1,517,203
$2,445,520
Current liabilities:
Current portion of long-term debt…
arrow_forward
How to conver a balance sheet to a common size balance sheet
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Related Questions
- Required: • Vertical analysis • Descriptive Analysiarrow_forwardCondensed financial data of Crane Inc. follow. CRANE INC.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $117,100 $47,400 Accounts receivable 93,000 32,700 Inventory 111,400 102,700 Prepaid expenses 30,000 25,300 Long-term investments 141,000 113,100 Plant assets 274,700 241,500 Accumulated depreciation (46,100) (51,500) Total $721,100 $511,200 Liabilities and Stockholders’ Equity Accounts payable $111,300 $67,100 Accrued expenses payable 16,100 17,400 Bonds payable 118,400 149,600 Common stock 220,900 174,000 Retained earnings 254,400 103,100 Total $721,100 $511,200 CRANE INC.Income StatementFor the Year Ended December 31, 2022…arrow_forwardCondensed financial data of Crane Inc. follow. CRANE INC.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $117,100 $47,400 Accounts receivable 93,000 32,700 Inventory 111,400 102,700 Prepaid expenses 30,000 25,300 Long-term investments 141,000 113,100 Plant assets 274,700 241,500 Accumulated depreciation (46,100) (51,500) Total $721,100 $511,200 Liabilities and Stockholders’ Equity Accounts payable $111,300 $67,100 Accrued expenses payable 16,100 17,400 Bonds payable 118,400 149,600 Common stock 220,900 174,000 Retained earnings 254,400 103,100 Total $721,100 $511,200 CRANE INC.Income StatementFor the Year Ended December 31, 2022…arrow_forward
- Problem #1 The following balance sheet and income statement data is given: 31-Dec Yr 2021 Yr 2020 Cash $4,300 $3,700 Accounts receivable (net) 22,000 23,400 Inventories 10,000 7,000 Plant assets (net) 75,000 86,000 Total assets 111,300 120,100 Accounts payable 12,370 11,100 Bonds payable 70,000 70,000 Total liabilities 82,370 81,100 Common stock, $10 par 65,000 59,000 Paid-in capital 10,000 10,000 Retained earnings 24,300 20,600 Total stockholders’ equity 99,300 89,600 Net credit sales 100,000 Cost of goods sold 60,350 Gross profit 39,650 Net income 14,000 REQUIRED: Compute the following ratios for 2021. NOTE: Copy and paste the information below into the answer box first and then show your calculation steps for this problem to receive credits. (1) Accounts receivable turnover=____________________ (2) Inventory turnover=__________________ (3) Accounts payable…arrow_forwardexercise 12-7 Shown below are comparative balance sheets for Sandhill Company. Sandhill CompanyComparative Balance SheetsDecember 31 Assets 2017 2016 Cash $ 211,208 $ 68,332 Accounts receivable 273,328 236,056 Inventory 518,702 587,034 Land 248,480 310,600 Equipment 807,560 621,200 Accumulated depreciation—equipment (204,996 ) (99,392 ) Total $1,854,282 $1,723,830 Liabilities and Stockholders’ Equity Accounts payable $ 121,134 $ 133,558 Bonds payable 465,900 621,200 Common stock ($1 par) 670,896 540,444 Retained earnings 596,352 428,628 Total $1,854,282 $1,723,830 Additional information: 1. Net income for 2017 was $288,858. 2. Depreciation expense was $105,604. 3. Cash dividends of $121,134 were declared and paid. 4. Bonds…arrow_forwardHow to calculate Net Operating Asset from this balance sheet for fiscal year-end 2015 .arrow_forward
- answer please?arrow_forwardCondensed financial data of Coronado Inc. follow. CORONADO INC.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $81,100 $49,000 Accounts receivable 87,700 38,100 Inventory 111,200 102,100 Prepaid expenses 29,000 27,500 Long-term investments 140,900 113,300 Plant assets 285,000 242,400 Accumulated depreciation (46,800) (48,400) Total $688,100 $524,000 Liabilities and Stockholders’ Equity Accounts payable $110,000 $67,400 Accrued expenses payable 16,500 21,500 Bonds payable 119,300 149,300 Common stock 219,900 174,600 Retained earnings 222,400 111,200 Total $688,100 $524,000 CORONADO INC.Income StatementFor the Year Ended December 31, 2022 Sales revenue $376,500 Less:…arrow_forwardCondensed financial data of Coronado Inc. follow. CORONADO INC.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $81,100 $49,000 Accounts receivable 87,700 38,100 Inventory 111,200 102,100 Prepaid expenses 29,000 27,500 Long-term investments 140,900 113,300 Plant assets 285,000 242,400 Accumulated depreciation (46,800) (48,400) Total $688,100 $524,000 Liabilities and Stockholders’ Equity Accounts payable $110,000 $67,400 Accrued expenses payable 16,500 21,500 Bonds payable 119,300 149,300 Common stock 219,900 174,600 Retained earnings 222,400 111,200 Total $688,100 $524,000 CORONADO INC.Income StatementFor the Year Ended December 31, 2022 Sales revenue $376,500 Less:…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education