Mortonson Company has not yet prepared a statement of cash flows for the 2020 fiscal year. Comparative balance sheets as of December 31, 2019 and 2020, and a statement of income and retained earnings for the year ended December 31, 2020, are presented as follows. Mortonson Company Statement of Income and Retained Earnings For the Year Ended December 31, 2020 ($000 omitted) Sales revenue   $3,800 Expenses     Cost of goods sold $1,200   Salaries and benefits 725   Heat, light, and power 75   Depreciation 80   Property taxes 19   Patent amortization 25   Miscellaneous expenses 10   Interest 30 2,164 Income before income taxes   1,636 Income taxes   818 Net income   818 Retained earnings—Jan. 1, 2020   310     1,128 Stock dividend declared and issued   600 Retained earnings—Dec. 31, 2020   $ 528 Mortonson Company Comparative Balance Sheets As of December 31 ($000 omitted) Assets 2020 2019 Current assets     Cash $  333 $  100 U.S. Treasury notes (available-for-sale) 10 50 Accounts receivable 780 500 Inventory    720    560 Total current assets  1,843  1,210 Long-term assets     Land 150 70 Buildings and equipment 910 600 Accumulated depreciation—buildings and equipment (200) (120) Patents (less amortization)    105    130 Total long-term assets    965    680 Total assets $2,808 $1,890 Liabilities and Stockholders' Equity     Current liabilities     Accounts payable $  420 $  330 Income taxes payable 40 30 Notes payable    320    320 Total current liabilities 780 680 Long-term notes payable—due 2022    200    200 Total liabilities    980    880 Stockholders' equity     Common stock 1,300 700 Retained earnings    528    310 Total stockholders' equity  1,828  1,010 Total liabilities and stockholders' equity $2,808 $1,890 Instructions Prepare a statement of cash flows using the direct method. Changes in accounts receivable and accounts payable relate to sales and cost of goods sold. Do not prepare a reconciliation schedule. (CMA adapted)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%
 (SCF—Direct Method) Mortonson Company has not yet prepared a statement of cash flows for the 2020 fiscal year. Comparative balance sheets as of December 31, 2019 and 2020, and a statement of income and retained earnings for the year ended December 31, 2020, are presented as follows.
Mortonson Company
Statement of Income and Retained Earnings
For the Year Ended December 31, 2020
($000 omitted)
Sales revenue
 
$3,800
Expenses
 
 
Cost of goods sold
$1,200
 
Salaries and benefits
725
 
Heat, light, and power
75
 
Depreciation
80
 
Property taxes
19
 
Patent amortization
25
 
Miscellaneous expenses
10
 
Interest
30
2,164
Income before income taxes
 
1,636
Income taxes
 
818
Net income
 
818
Retained earnings—Jan. 1, 2020
 
310
 
 
1,128
Stock dividend declared and issued
 
600
Retained earnings—Dec. 31, 2020
 
$ 528
Mortonson Company
Comparative Balance Sheets
As of December 31
($000 omitted)
Assets
2020
2019
Current assets
 
 
Cash
$  333
$  100
U.S. Treasury notes (available-for-sale)
10
50
Accounts receivable
780
500
Inventory
   720
   560
Total current assets
 1,843
 1,210
Long-term assets
 
 
Land
150
70
Buildings and equipment
910
600
Accumulated depreciation—buildings and equipment
(200)
(120)
Patents (less amortization)
   105
   130
Total long-term assets
   965
   680
Total assets
$2,808
$1,890
Liabilities and Stockholders' Equity
 
 
Current liabilities
 
 
Accounts payable
$  420
$  330
Income taxes payable
40
30
Notes payable
   320
   320
Total current liabilities
780
680
Long-term notes payable—due 2022
   200
   200
Total liabilities
   980
   880
Stockholders' equity
 
 
Common stock
1,300
700
Retained earnings
   528
   310
Total stockholders' equity
 1,828
 1,010
Total liabilities and stockholders' equity
$2,808
$1,890
Instructions
Prepare a statement of cash flows using the direct method. Changes in accounts receivable and accounts payable relate to sales and cost of goods sold. Do not prepare a reconciliation schedule.
(CMA adapted)
 
Extra instructions :
Make sure to show you increases and decreases in the cell next to each account when including your comparative balance sheet etc. And set up your solutions as follows 
a)Sales
$3,810
Deduct ending accounts receivable
780
3,030
Add beginning accounts receivable
480
   Cash receipts (collections from customers)
$3,510
 (b)Cost of goods sold
$1,200
Add ending inventory
740
   Goods available for sale
1,940
Deduct beginning inventory
550
   Purchases
1,390
Deduct ending accounts payable
384
1,006
Add beginning accounts payable
350
    Cash purchases (payments for merchandise)
$1,356
 (c)Income taxes
$830
Deduct ending income taxes payable
37
793
Add beginning income taxes payable
30
   Income taxes paid
$823
 
In an excel format, please. Thank you!!!
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education