Concept explainers
a.
To compute: The income statement and balance sheet of BRCMM Co using formulas.
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 &
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
- 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_forwardUse the following excerpts from OpenAir Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forwardUse the following excerpts from Yardley Companys financial information to prepare a statement of cash flows (indirect method) for the year 2018.arrow_forward
- Which of the following is the final step in preparing a spreadsheet (work sheet) for the statement of cash flows using the indirect method? Add the Debit and Credit Transactions columns and verify that the totals are equal. Analyze all noncash accounts and enter the net increase (decrease) in cash during the period. Add the Balance column totals, which should total to zero. After all noncash accounts have been analyzed, enter the net increase (decrease) in cash during the period.arrow_forwardPlease help create a statement of cash flows using the direct method with the attached pictures!arrow_forwardPlease use excel, need help with functions and setting up cash flows in Excel. May youplease explain where/how you are getting the numbers through providing explanation and show the formulas. Thank you!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_forwardPrepare a statement of cash flows with the data. Thank youarrow_forwardPlease Solve the attached Cash flow statment problem by indirect way by using excel sheet in order to have readable answer.arrow_forward
- Which of the following statements concerning the entries made on the spreadsheet used to prepare the statement of cash flows is true? a.The entries are not posted to the ledger. b.The entries are used in preparing the data on the spreadsheet. c.The entries are used in summarizing the data on the spreadsheet. d.All of these choices are correct.arrow_forwardHow would I input the formulas into excel to get those numbers for the statement of cash flowsarrow_forwardComplete each of the columns on the table below, indicating in which section each item would be reported on the statement of cash flows (operating, investing, or financing), amount to be reported, and whether the item would create an increase or decrease in cash. For items that affect more than one section of the statement, indicate all affected. Assume the indirect method of reporting cash flows from operating activities. The first item has been completed as an example. Some items may have more than 1 answer for each column (you can attach Excel or Word rather than typing in answer box). Statement Amount +/– Effect Item Section to Report on Cash Depreciation of $15K for the period Operating $15K Increase 1. Issue common stock for $35K 2. Increase in accounts payable of $7K 3. Retirement of $100K bonds payable at 97 4. Purchase of long-term investments for $94,500 5. Dividends…arrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning