EBK FINANCIAL ANALYSIS WITH MICROSOFT E
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
8th Edition
ISBN: 9781337515528
Author: Mayes
Publisher: CENGAGE LEARNING - CONSIGNMENT
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 2, Problem 1P

a.

Summary Introduction

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.

Expert Solution
Check Mark

Explanation of Solution

The income statement for the company has been prepared:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  1

Working note: Preparation of income statement and computation of net income has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  2

The balance sheet for the company has been prepared:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  3

Working note: Preparation of balance sheet has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  4

b.

Summary Introduction

To compute: Create a statement of cash flows for 2016.

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.

b.

Expert Solution
Check Mark

Explanation of Solution

The cash flow statement for the company has been prepared:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  5

Working note: Preparation of cash flow statement and computation of net cash flow has been shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  6

c.

Summary Introduction

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.

Expert Solution
Check Mark

Explanation of Solution

Cash flow statement can be shown using outline feature as:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  7

Steps to perform outline:

  1. Select the entire particulars column.
  2. Go to ‘Data’ tab.
  3. Click on sub-total.
  4. Select ‘Count’ as ‘Use function’.
  5. Click on ok.

Working note: The cash flow statement for the company has been prepared.

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  8

d.

Summary Introduction

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.

Expert Solution
Check Mark

Explanation of Solution

The revised net income could be calculated by changing the net sales figure for 2016:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  9

Retained earnings would change automatically as shown below:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  10

Working notes:

Calculation of net income:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  11

Computation of retained earnings:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  12

Conclusion

If sales were $400000 instead of $3,69,300 in 2016 then net income is $33,405& retained earnings is $68,605.

e.

Summary Introduction

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.

Expert Solution
Check Mark

Explanation of Solution

The revised net income could be calculated by changing tax rate figure for 2016:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  13

Calculated revised retained earnings:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  14

Computation of revised net income:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  15

Computation of retained earnings:

  EBK FINANCIAL ANALYSIS WITH MICROSOFT E, Chapter 2, Problem 1P , additional homework tip  16

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Ch 26: Assignment - Mergers and Corporate Control Widget Corp., which is considering the acquisition of Exteter Enterprise Inc., estimates that acquiring Exteter will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company: Data Collected (in millions of dollars) Year 1 Year 2 Year 3 EBIT $13.0 $15.6 $19.5 Interest expense 5.0 5.5 6.0 Debt 35.2 41.6 44.8 Total net operating capital 107.1 109.2 111.3 Exteter Enterprise Inc. is a publicly traded company, and its market-determined pre-merger beta is 1.00. You also have the following information about the company and the projected statements: •Exteter currently has a $38.00 million market value of equity and $24.70 million in debt. The risk-free rate is 3.5%, there is a 5.60% market risk premium, and the Capital Asset Pricing Model produces a pre-merger required rate of return on equity ISL of 9.10%. •Exteter's cost…
3. Problem 30-03 (Plan Funding) Plan Funding eBook Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations: Year 11-15 16-20 21-25 Annual Total Payment $3,480,000 2,980,000 26-30 31-35 2,480,000 1,980,000 1,480,000 The current value of the firm's pension fund is $5.6 million. Assume that all cash flows occur at year-end. a. Consolidated's expected return on pension assets is 11%, and it uses 11% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round intermediate calculations. Round your answer to the nearest dollar. $ b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places. Funding ratio= which means the assets are select than the PV of benefits and the plan is select Less or greater Select underfunded overfunded
Plan Funding Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations: Year 11-15 16-20 21-25 Annual Total Payment $3,500,000 3,000,000 2,500,000 26-30 31-35 2,000,000 1,500,000 The current value of the firm's pension fund is $6.1 million. Assume that all cash flows occur at year-end. a. Consolidated's expected return on pension assets is 12%, and it uses 12% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round intermediate calculations. Round your answer to the nearest dollar. $ b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places. Funding ratio = which means the assets are -Select- than the PV of benefits and the plan is -Select- ☑. Less or Greater Overfunded or Underfunded

Chapter 2 Solutions

EBK FINANCIAL ANALYSIS WITH MICROSOFT E

Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Text book image
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:9781285595047
Author:Weil
Publisher:Cengage
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License