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

  What is effect on the karls individual income tax

what is effect on the Karl's individual income tax with the following conditions?( tax year 2011)

  A study indicates that 372000 of the fixed expenses being

boyles home center a retailing company has two departments bath and kitchen. the companys most recent monthly

  Large firms operating globally develop strategies based on

large firms operating globally develop strategies based on the type of industries and businesses in which they compete.

  The st augustine corporation originally budgeted for 360000

the st. augustine corporation originally budgeted for 360000 of fixed overhead. production was budgeted to be 12000

  The management of therriault corp is considering dropping

the management of therriault corp. is considering dropping product u51y. data from the accounting system appear below

  What was the carrying value book value of fedexs debt

note the locations of the following page numbers are the ones printed on the pages not the page numbers of the .pdf

  Tax consequences of the partnership

Justin and Tiffany form the equal TJ Partnership, Justin contributes cash of $20,000 and land (fair market value of $80,000, adjusted basis of $65,000), and Tiffany contributes the assets of her sole proprietorship (value of $100,000, adjusted bas..

  Determine the amount of money in a savings account at the

determine the amount of money in a savings account at the end of one year given an initial deposit of 4500 and an 12

  Finding useful life of equipment

Werner Chemical, Inc., leased a protein analyzer on September 30, 2013-Depreciation is recorded on a straight-line basis at the end of each fiscal year. The useful life of the equipment is five years.

  What is the materials price and quantity variance

High Sounds manufactures wind chimes that have a standard material cost of 2 pounds of raw materials at $1.50 per pound. During March, 10,000 pounds of raw materials costing $1.55 per pound were used in making 4,800 wind chimes. What is the (1) ma..

  At a total cost of 2000000 stieg corporation acquired

at a total cost of 2000000 stieg corporation acquired 160000 shares of larson corp. common stock as a long-term

  Amount of the distribution-taxed as dividend to shareholder

A calendar year corporation in its first year of operations reports earnings and profits of $50,000. In December of that year, it distributes land worth $40,000 to one of its shareholders. The corporation's basis in the land was $35,000, and the l..

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