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 FINANCIAL ANALYSIS WITH MICROSOFT E
- Benefits and Contributions The Certainty Company (CC) operates in a world of certainty. It has just hired Mr. Jones, age 27, who will retire at age 65, draw retirement benefits for 14 years, and die at age 79. Mr. Jones' salary is $21,000 per year, but wages are expected to increase at the 6% annual rate of inflation. CC has a defined benefit plan in which workers receive 1% of the final year's wage for each year employed. The retirement benefit, once started, does not have a cost-of-living adjustment. CC earns 12% annually on its pension fund assets and uses a 10% rate to discount its expected future benefit payments. Assume that pension contribution and benefit cash flows occur at year-end. Do not round intermediate calculations. Round your answers to the nearest dollar. a. How much will Mr. Jones receive in annual retirement benefits? $ b. What is CC's required annual contribution to fully fund Mr. Jones' retirement benefits? $ c. Assume now that CC hires Mr. Smith at the same…arrow_forwardlab.infoseclearning.com/console/5061763/3047 310-win10 Project Three Milestone - GNS3 File Edit View Control Node Annotate Tools Help e 41 Sales_PC1 0000 Sales_PC2 Sales_PC3 Enforce US Keyboard Layout View Fullscreen Send Ctrl+Alt+Delete Reboot To exit full screen, press and hold esc ■C00/6@ Q Sales_Switch Human Resources_Switch Office_Router Sales PC4 Customer_Service_Switch X: -299.0 Y: -136.0 Z: 1.0 H Type here to search CS_FTP_Server HR_PC2 HR_PC1 7:19 PM 12/14/2024 Barrow_forwardAGG is a US multinational that manufactures specialist high tech parts in the airline engine industry. AGG is an established company with steady growth in turnover and dividends over the last 10 years. The company is undertaking a projected titled Project Big as a strategic response to the changing market scene. AGG will develop a new state of the art highly automated plant located in Cambodia which is expected to result in cost advantages if it is implemented. The details about the project are below • Initital investment has been estimated at $500m • • The annual pre tax savings in operating costs at current exchange rates has been calculated at $150m for the first four years (starting in the first year) The residual value of the project at the end of the four years is estimated to be $250m The initial investment, net of residual value, qualifies for capital allowance and can be claimed back on a straight line basis over the four years of the project. Current AGG's cost of capital is…arrow_forward
- You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in twenty-six equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. Calculate the present value of the payments you will receive. Show your calculations using formulas in your paper or provide how to do the calculations in Excel. Explain why there is a difference between the present value of the Strayer lottery jackpot and the future value of the twenty-six annual payments based on your calculations and the information provided.arrow_forwardYou have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in twenty-six equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. Calculate the present value of the payments you will receive. Show your calculations using formulas in your paper or in an attached spreadsheet file.arrow_forwardThe approach uses a weighted average cost of capital that is unique to a particular project while determining the appropriate discount rate.arrow_forward
- An all-equity firm faces a risk-free rate of 4%, a beta of 2, and a market risk premium of 6%. What is its cost of capital? Multiple choice question. 18% 12% 14% 16%arrow_forwardcreated or destroyed. uses the weighted average cost of capital to determine if value is beingarrow_forwardUnder the subjective approach for project evaluation, all proposed projects are placed into several Blank______ categories. Multiple choice question. risk cost revenue returnarrow_forward
- Using the WACC as the discount rate for future cash flows is appropriate only when the proposed investment is Blank______ the firm's existing activities. Multiple choice question. riskier than different from less risky than similar toarrow_forwardSuppose a project has a cost of $20 million and expected cash flows of 10 million per year for two years. If the WACC is 10%, what is the NPV of this project? Multiple choice question. $17.4 million –$2.6 million $2.6 million 0 millionarrow_forwardAlpha Corporation consists of two divisions, X and Y. Division X is riskier than Division Y. If Alpha Corporation uses the firm's overall weighted average cost of capital to evaluate both divisions' projects, which division(s) will tend to be awarded greater funds for investment? Multiple choice question. Only division X Neither division Both divisions Only division Yarrow_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