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 &
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 3N3-EBK: FINANCIAL ANALYSIS WITH MI
- Which of the following would be expected to hold its value best during a time of inflation? A certificate of deposit. A corporate bond. A house.arrow_forwardWhat is a budget? A spending plan showing sources and uses of income. A limit on spending that cannot be exceeded. The amount of money that a credit card will let youarrow_forwardThe Pan American Bottling Co. is considering the purchase of a new machine that would increase the speed of bottling and save money. The net cost of this machine is $60,000. The annual cash flows have the following projections: Year 1 ........... 2 ........... 3 ........... 4 ........... 5 ........... Cash Flow $23,000 26,000 29,000 15,000 8,000 a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine? I need to see the work. I can't use Excel to solve the problem. Excel doesn't help me solve Part a.arrow_forward
- Pat and Chris have identical interest-bearing bank accounts that pay them $15 interest per year. Pat leaves the $15 in the account each year, while Chris takes the $15 home to a jar and never spends any of it. After five years, who has more money? Pat. Chris. They both have the same amount. Don’t knowarrow_forwardAssume a firm has earnings before depreciation and taxes of $200,000 and no depreciation. It is in a 25 percent tax bracket. a. Compute its cash flow using the following format: Earnings before depreciation and taxes _____Depreciation _____Earnings before taxes _____Taxes @ 25% _____Earnings after taxes _____Depreciation _____Cash Flow _____ b. Compute the cash flow for the company if depreciation is $200,000. Earnings before depreciation and taxes _____Depreciation _____Earnings before taxes _____Taxes @ 25% _____Earnings after taxes _____Depreciation _____Cash Flow _____ c. How large a cash flow benefit did the depreciation provide?arrow_forwardAssume a $40,000 investment and the following cash flows for two alternatives. Year Investment X Investment Y 1 $6,000 $15,000 2 8,000 20,000 3 9,000 10,000 4 17,000 — 5 20,000 — Which of the alternatives would you select under the payback method?arrow_forward
- The Short-Line Railroad is considering a $140,000 investment in either of two companies. The cashflows are as follows:Year Electric Co. Water Works1.................. $85,000 $30,0002.................. 25,000 25,0003.................. 30,000 85,0004–10............ 10,000 10,000a. Using the payback method, what will the decision be?b. Using the Net Present Value method, which is the better project? The discount rate is 10%.arrow_forwardWhat is corporate finance explain its important?arrow_forwardWhat is corporate finance? can you explain more?arrow_forward
- General accounting problem.arrow_forwardWhat do you know about corporate finance? tell me about thisarrow_forwardWhich of the following is the primary function of insurance? Making risk disappear. Pooling and sharing risk among the insured. Making someone else pay for an accident or loss. Don’t know.arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
