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
- Can 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_forwardCompare and contrast the Balance Sheet, Income Statement, and Statement of Cash Flows. Make sure to spend some time defining each financial statement and describing the formula that the statement follows.arrow_forwardWhy might a spreadsheet be helpful when completing the statement of cash flows?arrow_forward
- Create 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_forwardPrepare an Income Statement and Cash Flow Statement. In excel form pls. Thank u!arrow_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_forwardUsing 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_forward
- Please help create a statement of cash flows using the direct method with the attached pictures!arrow_forwardGarage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 Required return SSSSS A (43,500) 21,400 18,500 13,800 7,600 $ ESSASALA $ $ $ $ B (43,500) 6,400 14,700 22,800 25,200 11% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question.arrow_forwardthis is an IFRS cash flow statement, please find all the error inside the statement. thanksarrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning