$1$ of $3$

Module $2$ Assignment $($Individual Assignment$)$

Chapter $3-$ Indirect Cash Flow Statements

If you have questions regarding this assignment, they must be sent at least $24$ hours prior to the deadline. Questions sent within $24$ hours will not be accepted.

In this assignment you will have the opportunity to demonstrate your ability to

Construct an indirect cash flow statement by deconstructing the other financial statements.

Statement formatting is key here. Your intended audience is a client, so please ensure that your spreadsheet is professional and easy to navigate and understand.

Instructions

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.

$\backslash$table$[[$Exhibit $3\mathrm{.}27],[$Nojiri Pharmaceutical Industries Income Statements $($amounts in millions$)($Problem $3\mathrm{.}28)],[$Year Ended March $31$:$,$Year $4,$Year $3,$Year $2],[$Sales$,*41,352,*41,926,*44,226],[$Cost of goods sold,$(27,667),(27,850),(28,966)$

Cha

pter $3-$ Indirect Cash Flow Statements

If you have questions regarding this assignment, they must be sent at least $24$ hours prior to the deadline. Questions sent within $24$ hours will not be accepted.

In this assignment you will have the opportunity to demonstrate your ability to

Construct an indirect cash flow statement by deconstructing the other financial statements.

Statement formatting is key here. Your intended audience is a client, so please ensure that your spreadsheet is professional and easy to navigate and understand.

Instructions

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.

$\backslash$table$[[$Exhibit $3\mathrm{.}27],[\backslash$table$[[$Nojiri Pharmaceutical Industries Income Statements $($amounts in millions$)],[($Problem $3\mathrm{.}28)]]],[$Year Ended March $31$:$,$Year $4,$Year $3,$Year $2],[$Sales$,*41,352,*41,926,*44,226],[$Cost of goods sold,$(27,667),(27,850),(28,966)$