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).

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
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).

 

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)
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE 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