Complete the income statements by using excel formulas

Assignment Help Accounting Basics
Reference no: EM13914534

At the end of 2013, the following information is available for Short and Wise Companies:

960_264-B-A-M-B (1317).png

Required 

a. Set up the spreadsheet shown here. Complete the income statements by using Excel formulas. 

b. Prepare a common size income statement for each company by completing the % Sales columns. 

c. One company is a high-end retailer, and the other operates a discount store. Which is the discounter? Support your selection by referring to the common size statements. 

d. Compute the return on assets and return on equity for each company. 

e. Which company is more profitable from the stockholders' perspective? 

f. Assume that a shortage of goods from suppliers is causing cost of goods sold to increase 10 percent for each company. Change the respective cost of goods sold balances in the Actual income statement column for each company. Note the new calculated amounts on the income statement and in the ratios. Which company's profits and returns are more sensitive to inventory pricehikes?

Reference no: EM13914534

Questions Cloud

Compute overhead applied and the under : Pilgrim Company applies overhead on the basis of machine hours. Given the following data, compute overhead applied and the under- or overapplication of overhead for the period:
Susceptible to interest rate risk from investors perspective : If the United States announces that it will borrow an additional $10 billion, this announcement will normally cause the bond traders to expect. Which of the following bonds is most susceptible to interest rate risk from an investor's perspective?  __..
Find the area bounded by the graphs : Find the area bounded by the graphs-  f(x) = x2 and g(x) = x3
Open markets and closed borders : Respond to the following short essay questions based on the course materials presented for weeks 1-4. You are to prepare and submit your midterm assessment in a Microsoft word document and attach to the "Assignments". Additionally, I want you to "..
Complete the income statements by using excel formulas : Assume that a shortage of goods from suppliers is causing cost of goods sold to increase 10 percent for each company. Change the respective cost of goods sold balances in the Actual income statement column for each company. Note the new calculated am..
Presentation on the health risks : Pretend that you are participating in a public safety awareness forum and that you have been selected to deliver a presentation on the health risks of one of the toxic substance categories that we have covered in this unit.
What is the maximum sales growth rate north : North Construction had $850 million of sales last year, and it had $425 million of fixed assets that were used at only 80% of capacity. What is the maximum sales growth rate North could achieve before it had to increase its fixed assets?
New system to streamline the process : Joan, a new manager, must enforce sales report deadlines, but her team is struggling. She creates a new system to streamline the process and helps everyone understand why the deadlines are important. This is an example of which force for change?
What is the projects net cash flow : Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $1.4 million. The fixed asset falls into the three-year MACRS class. The tax rate is 35 percent and the required return i..

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd