Req A Year 1 Req A Year 2 Req A Year 3 Event Year 3 Balance 1. 2. Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of cash flows. Mo amounts of the events into the model. Also, in the Statement of Cash Flows column, classify the cash flows as operating activities (OA), investing a activities (FA). Note: Enter any decreases to account balances or cash outflows with a minus sign. Leave cells blank if no input is needed. Assets Cashi + 106,470 + (2,700) + (980)+ 34,790 3. 4. Balance 137,580 + NC Net change in cash + Req B1 Income Statement Book Value of Equipment Balance Sheet 9,360= 2,700 = 0 = 0 = 0 = 12,060 = ACCOUNTING SOLUTIONS INCORPORATED Horizontal Statements Model - Year 3 Stockholders' Equity Common Stock 55,000+ 0+ 0 + Req B2 Statement of Changes 0+ + 55,000+ Req 83 Balance Sheet Retained Revenue Earnings 60,830 0 (980) 34,790 94,640 0 0 0 34,790 34,790 Req B4 Statement of Cash Flows Income Statement I Expenses 0= 0= (980) 0= (980)= Net Income 0 0 (980) 34,790 Statement of Cash Flows (2,700) IA (980) OA OA 34,790 33,810 31,110 NC
Req A Year 1 Req A Year 2 Req A Year 3 Event Year 3 Balance 1. 2. Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of cash flows. Mo amounts of the events into the model. Also, in the Statement of Cash Flows column, classify the cash flows as operating activities (OA), investing a activities (FA). Note: Enter any decreases to account balances or cash outflows with a minus sign. Leave cells blank if no input is needed. Assets Cashi + 106,470 + (2,700) + (980)+ 34,790 3. 4. Balance 137,580 + NC Net change in cash + Req B1 Income Statement Book Value of Equipment Balance Sheet 9,360= 2,700 = 0 = 0 = 0 = 12,060 = ACCOUNTING SOLUTIONS INCORPORATED Horizontal Statements Model - Year 3 Stockholders' Equity Common Stock 55,000+ 0+ 0 + Req B2 Statement of Changes 0+ + 55,000+ Req 83 Balance Sheet Retained Revenue Earnings 60,830 0 (980) 34,790 94,640 0 0 0 34,790 34,790 Req B4 Statement of Cash Flows Income Statement I Expenses 0= 0= (980) 0= (980)= Net Income 0 0 (980) 34,790 Statement of Cash Flows (2,700) IA (980) OA OA 34,790 33,810 31,110 NC
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Year 3
1. Pald $2,700 to upgrade the computer system, which extended the total life of the system to six years. The salvage value did not
change.
2. Pald $980 In fees to service the computers.
3. Collected $34,790 In fees from clients.
4. Recorded double-declining-balance depreciation for Year 3.
Required
a. Use a horizontal financial statements model to show how each event affects the balance sheet, Income statement, and statement of
cash flows. More specifically, record the amounts of the events into the model. Also, in the Statement of Cash Flows column,
classify the cash flows as operating activities (OA), Investing activities (IA), or financing activities (FA).
b-1. Prepare Income statements for Year 1, Year 2, and Year 3.
b-2. Prepare statements of changes in stockholders' equity for Year 1, Year 2, and Year 3.
b-3. Prepare balance sheets for Year 1, Year 2, and Year 3.
b-4. Prepare statements of cash flows for Year 1, Year 2, and Year 3.
Req A Year 1 Req A Year 2 Req A Year 3
Event
Year 3
Balance
1.
2.
3.
4.
Balance
Cash
Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of cash flows. Mor
amounts of the events into the model. Also, in the Statement of Cash Flows column, classify the cash flows as operating activities (OA), investing a
activities (FA).
Note: Enter any decreases to account balances or cash outflows with a minus sign. Leave cells blank if no input is needed.
Assets
108,470 +
(2,700) +
(980) +
34,790+
+
137,580 +
NC Net change in cash
Reg B1
Income
Statement
Book Value of
Equipment
Balance Sheet
9,360=
2,700 =
0 =
0 =
0 =
12,060 =
ACCOUNTING SOLUTIONS INCORPORATED
Horizontal Statements Model - Year 3
Stockholders' Equity
Retained
Earnings
Common
Stock
+
Req B2
Statement of
Changes
55,000 +
0 +
0 +
0 +
+
55,000 +
Req B3
Balance Sheet
60,830
0
(980)
34,790
94,640
Revenue
34,790
Req B4
Statement of
Cash Flows
01-1
01-1
01-1
34,790
Income Statement
Expenses = Net Income
0 =
0 =
(980)=
0 =
|=
(980)=
0
0
(980)
34,790
Statement of
Cash Flows
0
(2,700) IA
(980) OA
34,790 OA
33,810 31,110 NC*](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8e471a5e-2c1f-43a0-a51a-181260b6660a%2Ffc3a6574-c8d4-4df1-93aa-ef79ab258364%2Fbmsahkc_processed.png&w=3840&q=75)
Transcribed Image Text:Year 3
1. Pald $2,700 to upgrade the computer system, which extended the total life of the system to six years. The salvage value did not
change.
2. Pald $980 In fees to service the computers.
3. Collected $34,790 In fees from clients.
4. Recorded double-declining-balance depreciation for Year 3.
Required
a. Use a horizontal financial statements model to show how each event affects the balance sheet, Income statement, and statement of
cash flows. More specifically, record the amounts of the events into the model. Also, in the Statement of Cash Flows column,
classify the cash flows as operating activities (OA), Investing activities (IA), or financing activities (FA).
b-1. Prepare Income statements for Year 1, Year 2, and Year 3.
b-2. Prepare statements of changes in stockholders' equity for Year 1, Year 2, and Year 3.
b-3. Prepare balance sheets for Year 1, Year 2, and Year 3.
b-4. Prepare statements of cash flows for Year 1, Year 2, and Year 3.
Req A Year 1 Req A Year 2 Req A Year 3
Event
Year 3
Balance
1.
2.
3.
4.
Balance
Cash
Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of cash flows. Mor
amounts of the events into the model. Also, in the Statement of Cash Flows column, classify the cash flows as operating activities (OA), investing a
activities (FA).
Note: Enter any decreases to account balances or cash outflows with a minus sign. Leave cells blank if no input is needed.
Assets
108,470 +
(2,700) +
(980) +
34,790+
+
137,580 +
NC Net change in cash
Reg B1
Income
Statement
Book Value of
Equipment
Balance Sheet
9,360=
2,700 =
0 =
0 =
0 =
12,060 =
ACCOUNTING SOLUTIONS INCORPORATED
Horizontal Statements Model - Year 3
Stockholders' Equity
Retained
Earnings
Common
Stock
+
Req B2
Statement of
Changes
55,000 +
0 +
0 +
0 +
+
55,000 +
Req B3
Balance Sheet
60,830
0
(980)
34,790
94,640
Revenue
34,790
Req B4
Statement of
Cash Flows
01-1
01-1
01-1
34,790
Income Statement
Expenses = Net Income
0 =
0 =
(980)=
0 =
|=
(980)=
0
0
(980)
34,790
Statement of
Cash Flows
0
(2,700) IA
(980) OA
34,790 OA
33,810 31,110 NC*
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education