Concept explainers
a.
To compute: The income statement and
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
a.
Explanation of Solution
The income statement for the company has been prepared:
Working note: Preparation of income statement and computation of net income has been shown below:
The balance sheet for the company has been prepared:
Working note: Preparation of balance sheet has been shown below:
b.
To compute: Create a statement of cash flows for 2016.
Introduction: A cash flow statement shows the aggregate data regarding all the
b.
Explanation of Solution
The cash flow statement for the company has been prepared:
Working note: Preparation of cash flow statement and computation of net cash flow has been shown below:
c.
To show: Cash flow statement using outline feature.
Introduction: A cash flow statement shows the aggregate data regarding all the cash inflows and outflows of a company. It considers only cash transactions, any non-cash transaction is mentioned as a footnote.
c.
Explanation of Solution
Cash flow statement can be shown using outline feature as:
Steps to perform outline:
- Select the entire particulars column.
- Go to ‘Data’ tab.
- Click on sub-total.
- Select ‘Count’ as ‘Use function’.
- Click on ok.
Working note: The cash flow statement for the company has been prepared.
d.
To compute: If sales were $400000 instead of $3,69,300 in 2016 then compute the net income & retained earnings
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
d.
Explanation of Solution
The revised net income could be calculated by changing the net sales figure for 2016:
Retained earnings would change automatically as shown below:
Working notes:
Calculation of net income:
Computation of retained earnings:
If sales were $400000 instead of $3,69,300 in 2016 then net income is $33,405& retained earnings is $68,605.
e.
To compute: If tax rate was 35% instead of 40% in 2016 then compute the net income & retained earnings.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
e.
Explanation of Solution
The revised net income could be calculated by changing tax rate figure for 2016:
Calculated revised retained earnings:
Computation of revised net income:
Computation of retained earnings:
Want to see more full solutions like this?
Chapter 2 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- Show complete solution and formula used. Provide cash flow diagram. Calculate it manually, not in excel. Thank youu!arrow_forwardCan someone please help me to solve the following question showing all work and formulas neatly. And please show the cash flow diagram as well. PLEASE ANS THANK YOU!!!!!arrow_forwardWhy might a spreadsheet be helpful when completing the statement of cash flows?arrow_forward
- Prepare an Income Statement and Cash Flow Statement. In excel form pls. Thank u!arrow_forwardCreate a cashflow statement with the followingarrow_forwardPlease be fast.i uploaded an image of information and one where you have to answer, it's a cash flow statement. please do the cash flow statementarrow_forward
- A worksheet approach to preparing the statement of cash flows a. is a useful aid. b. uses a spreadsheet format. c. offers an efficient and logical way of organizing the data. d. allows an easy extraction of the needed data. e. All of these.arrow_forwardTo produce a cash flow statement, why do you need an income statement, a balance sheet, and extra information?arrow_forwardPlease help create a statement of cash flows using the direct method with the attached pictures!arrow_forward
- 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.arrow_forwardFill out this cashflow statement with the followingarrow_forwardExplain how a worksheet may be helpful in preparing a statement of cash flows.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning