THIS IS AN ACCOUNTING (EXCEL) PRACTICE PROBLEM! Please read the instructions carefully. Please construct an indirect cash flow statement in Excel for year 4 (the information for year 4 can be found in the images (Exhibit 3.27) that I attached to this question).
THIS IS AN ACCOUNTING (EXCEL) PRACTICE PROBLEM! Please read the instructions carefully. Please construct an indirect cash flow statement in Excel for year 4 (the information for year 4 can be found in the images (Exhibit 3.27) that I attached to this question).
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
THIS IS AN ACCOUNTING (EXCEL) PRACTICE PROBLEM!
Please read the instructions carefully.
Please construct an indirect
![Module 2 Practice Assignment (Not Graded)
In this practice assignment you will have the opportunity to demonstrate your ability to
1) Construct an indirect cash flow statement by deconstructing the other financial
statements
Instructions
1) Using the financial statements and additional information below, construct an
indirect cash flow statement in Excel for year 4. As long as you are following general
cash flow formatting rules (e.g. operating section, investing section, financing section),
you can format it as you see fit. Remember that these reports should be clean, easy to
read and understand, and useful for decision-making purposes.
Exhibit 3.27
Nojiri Pharmaceutical Industries
Income Statements
(amounts in millions)
(Problem 3.28)
Year Ended March 31:
Year 4
Year 3
Year 2
Sales
¥41,352
Cost of goods sold
Selling and administrative expenses
Interest expensé
(27,667)
(13,396)
(338)
(1,823)
¥ (1,872)
¥41,926
(27,850)
(15,243)
(364)
¥ 44,226
(28,966)
(15,283)
(368)
Income tax expense
443
34
Net Income
¥(1,088)
(357)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe1336aa0-e91b-4a1a-a973-d70bd54c1ee9%2Ff61d5bfd-6759-40d1-96cb-decb67ab87f7%2Fb4qxtye_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Module 2 Practice Assignment (Not Graded)
In this practice assignment you will have the opportunity to demonstrate your ability to
1) Construct an indirect cash flow statement by deconstructing the other financial
statements
Instructions
1) Using the financial statements and additional information below, construct an
indirect cash flow statement in Excel for year 4. As long as you are following general
cash flow formatting rules (e.g. operating section, investing section, financing section),
you can format it as you see fit. Remember that these reports should be clean, easy to
read and understand, and useful for decision-making purposes.
Exhibit 3.27
Nojiri Pharmaceutical Industries
Income Statements
(amounts in millions)
(Problem 3.28)
Year Ended March 31:
Year 4
Year 3
Year 2
Sales
¥41,352
Cost of goods sold
Selling and administrative expenses
Interest expensé
(27,667)
(13,396)
(338)
(1,823)
¥ (1,872)
¥41,926
(27,850)
(15,243)
(364)
¥ 44,226
(28,966)
(15,283)
(368)
Income tax expense
443
34
Net Income
¥(1,088)
(357)
![Exhibit 3.26
Nojiri Pharmaceutical Industries
Balance Sheets
(amounts in millions)
(Problem 3.28)
March 31:
Year 4
Year 3
Year 2
Year 1
ASSETS
Cash
Accounts and notes recelvable--Trade
Inventorles
Deferred income taxes
Prepayments
Total Current Assets
Investments
Property, plant, and equipment, at cost
Less accumulated depreciation
Deferred income taxes
¥6,233
¥4,569
¥4,513
19,003
7,693
1,355
17,628
7,948
1,192
325
¥31862
2,356
19,703
8,706
948
640
¥5,008
19457
8,607
824
634
432
¥ 34,716
3,309
71,792
(40,689)
¥34,510
3,204
71,326
(36,854]
1,481
3,312
¥76,979
¥34,530
4,997
71,018
(35,797)
494
3,463
* 78,705
71,510
(38.912)
236
4,551
¥73,915
1,608
Other assets
Total Assets
3,904
¥72.328
LIABILITIES AND SHAREHOLDERS EQUITY
Accounts and notes payable-Trade
¥ 10,087
10,360
100
7,200
¥ 27,747
8,140
3.361
¥9,629
10,328
10,851
9,779
¥ 10,804
10023
Current portion of long-term debt
Other current liabilities
Total Current Llabilitles
Long-term debt
Deferred income taxes
200
6,170
¥ 26,327
7,889
9,779
¥30,409
6,487
7565
¥28,392
8,147
Employee retirement benefits
Other noncurrent liabilities
Total Llabilities
Common stock,
Additional paid-in capital
Retained earnings.
Accumulated other comprehensive income
Treasury stock
Total Shareholders Equity
Total Liabilities and Shareholders' Equity
809
175
905
174
¥35,295
1,087
200
1,166
216
40,232
¥10,758
¥38,183
10,758 ¥ 10,758
15,012
13,697
(659)
(12)
¥38,796
76,979
¥37,921
¥ 10.758
15,012,
15.014
15,012
11,838
(490)
(85)
¥37,033
72,328
15,012
9,179
(342]
(924)
33,683
73.915
¥ 40,784
¥78,705
Additional information:
• The changes in Accumulated Other Comprehensive Income relate to revaluations of
Investments in Securities to market value. The remaining changes in Investments in
Securities result from purchases and sales. Assume that the sales occurred at no gain or
loss.
No sales of property, plant, and equipment took place during the three-year period.
The changes in Other Noncurrent Assets are investing activities.
The changes in Employee Retirement Benefits relate to provisions made for retirement
benefits net of payments made to retired employees, both of which the statement of
cash flows classifies as operating activities.
The changes in Other Noncurrent Liabilities are financing activities.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe1336aa0-e91b-4a1a-a973-d70bd54c1ee9%2Ff61d5bfd-6759-40d1-96cb-decb67ab87f7%2Fbcwx1k_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Exhibit 3.26
Nojiri Pharmaceutical Industries
Balance Sheets
(amounts in millions)
(Problem 3.28)
March 31:
Year 4
Year 3
Year 2
Year 1
ASSETS
Cash
Accounts and notes recelvable--Trade
Inventorles
Deferred income taxes
Prepayments
Total Current Assets
Investments
Property, plant, and equipment, at cost
Less accumulated depreciation
Deferred income taxes
¥6,233
¥4,569
¥4,513
19,003
7,693
1,355
17,628
7,948
1,192
325
¥31862
2,356
19,703
8,706
948
640
¥5,008
19457
8,607
824
634
432
¥ 34,716
3,309
71,792
(40,689)
¥34,510
3,204
71,326
(36,854]
1,481
3,312
¥76,979
¥34,530
4,997
71,018
(35,797)
494
3,463
* 78,705
71,510
(38.912)
236
4,551
¥73,915
1,608
Other assets
Total Assets
3,904
¥72.328
LIABILITIES AND SHAREHOLDERS EQUITY
Accounts and notes payable-Trade
¥ 10,087
10,360
100
7,200
¥ 27,747
8,140
3.361
¥9,629
10,328
10,851
9,779
¥ 10,804
10023
Current portion of long-term debt
Other current liabilities
Total Current Llabilitles
Long-term debt
Deferred income taxes
200
6,170
¥ 26,327
7,889
9,779
¥30,409
6,487
7565
¥28,392
8,147
Employee retirement benefits
Other noncurrent liabilities
Total Llabilities
Common stock,
Additional paid-in capital
Retained earnings.
Accumulated other comprehensive income
Treasury stock
Total Shareholders Equity
Total Liabilities and Shareholders' Equity
809
175
905
174
¥35,295
1,087
200
1,166
216
40,232
¥10,758
¥38,183
10,758 ¥ 10,758
15,012
13,697
(659)
(12)
¥38,796
76,979
¥37,921
¥ 10.758
15,012,
15.014
15,012
11,838
(490)
(85)
¥37,033
72,328
15,012
9,179
(342]
(924)
33,683
73.915
¥ 40,784
¥78,705
Additional information:
• The changes in Accumulated Other Comprehensive Income relate to revaluations of
Investments in Securities to market value. The remaining changes in Investments in
Securities result from purchases and sales. Assume that the sales occurred at no gain or
loss.
No sales of property, plant, and equipment took place during the three-year period.
The changes in Other Noncurrent Assets are investing activities.
The changes in Employee Retirement Benefits relate to provisions made for retirement
benefits net of payments made to retired employees, both of which the statement of
cash flows classifies as operating activities.
The changes in Other Noncurrent Liabilities are financing activities.
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 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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