Compute the following ratios for year 1 year 2 and year 3

Assignment Help Finance Basics
Reference no: EM13575966

Compute the following ratios for Year 1, Year 2, and Year 3 for Company A:

1. Debt ratio

2. Debt-to-equity ratio

1) Preparing a Common-Size Income Statement

Company A reported the following income statement data for the most recent three years:

 

Year 3

Year 2

Year 1

Sales                                                   

$120,000

$90,000

$100,000

Cost of goods sold                                        

(55,000)

(47,000)

(48,000)

Operating expenses:

 

 

 

Marketing expense                                       

(7,000)

(7,000)

(6,000)

R&D expense                                          

(15,000)

(4,000)

(10,000)

Administrative expense                                   

(20,000)

(22,000)

(20,000)

Operating income                                         

 $ 23,000

 $10,000

 $ 16,000

Interest expense                                          

(3,000)

(5,000)

(3,000)

Income before income taxes                                 

 $ 20,000

 $ 5,000

 $ 13,000

Income tax expense                                       

(8,000)

(2,000)

(5,000)

Net income                                        

 $ 12,000

 $ 3,000

 $ 8,000

Prepare a common-size income statement for each year.

2) Preparing a Common-Size Balance Sheet

Company A reported the following balance sheet data for the most recent three years:

 

Year 3

Year 2

Year 1

Cash                                                 

$ 2,000

$ 2,000

$ 1,000

Accounts receivable                                       

5,000

11,000

5,000

Inventory                                              

10,000

16,000

10,000

Current assets                                          

 $17,000

 $29,000

 $16,000

Property, plant, and equipment (net)                           

50,000

45,000

40,000

Total assets                                           

 $67,000

 $74,000

 $56,000

Accounts payable                                        

$ 9,000

$14,000

$ 7,000

Short-term debt                                         

5,000

9,000

5,000

Current liabilities                                         

 $14,000

 $23,000

 $12,000

Long-term debt                                          

20,000

25,000

20,000

Total liabilities                                         

 $34,000

 $48,000

 $32,000

Paid-in capital                                           

5,000

5,000

5,000

Retained earnings                                        

28,000

21,000

19,000

Total liabilities and equities                                

 $67,000

 $74,000

 $56,000

Prepare the Asset section of a common-size balance sheet for each year.

Reference no: EM13575966

Questions Cloud

Cindy age 40 and don age 39 cowen are married dons 17 year : cindy age 40 and don age 39 cowen are married. dons 17 year old son from a former marriage lives with them. they also
An airline company sells 160 tickets for a plane with 150 : an airline company sells 160 tickets for a plane with 150 seats knowing that the probability that a passenger will not
Determine whether the distribution is a discrete : determine whether the distribution is a discrete probability distribution.x px0 0.001 0.002 1.003 0.004 0.00is the
Kanza inc obtained significant influence over rogan : kanza inc. obtained significant influence over rogan corporation by buying 30 of rogans 26300 outstanding shares of
Compute the following ratios for year 1 year 2 and year 3 : compute the following ratios for year 1 year 2 and year 3 for company a1. debt ratio2. debt-to-equity ratio1 preparing
The vp of sales at widgecorp who is comfortable with : deliverable length 500-1000 wordscompany w is testing a sales software package. their sales force of 500 people is
The companys borrowing rate is 12 percent the present value : complete the following assignment. submit your responses in msword as one document. label each section clearly. if you
Messages are transmitted from low speed terminals and : messages are transmitted from low speed terminals and arrive at a message concentrator at a poisson rate of 600hr.they
Company b and company c had the following dupont framework : company b and company c had the following dupont framework ratio values for year 3nbspcompany bcompany creturn on

Reviews

Write a Review

Finance Basics Questions & Answers

  Determine the amount of overhead that is underapplied

Bubba's Crawfish Processing Company uses a traditional overhead allocation based on direct labor hours. For the current year overhead is estimated at $2,250,000 and direct labor hours are budgeted at 415,000 hours.

  What is his portfolio beta

Jim Evans has $45,000 invested in a stock with a beta of 0.8 and another $55,000 invested in a stock with a beta of 1.4. These are the only two investments in his portfolio. What is his portfolio's beta?

  Ken washburn and associates incurred total cost of 10000

ken washburn and associates incurred total cost of 10000 toproduce 500 custom mirrors. a total of 550 hours were

  Which is the best alternative

A city has two alternatives for improving its sewage system. Use a 4% cost of money, which is conservative for a municipality.

  What kind of deal did the soccer player snag

Assuming all payments, except the first $2 million are paid at the end of each year and the discount rate is 9% what kind of deal did the soccer player snag?

  Define and discuss the concepts of risk and return

Define and discuss the concepts of risk and return. Also discuss the importance of portfolio diversification and the relationship to risk and return.

  What is the slope of the security market line

A stock has a beta of 2.5 and an expected return of 11.8%. The risk-free rate is 2.8%. What is the slope of the security market line?

  If a firm expects to have additional financial

if a firm expects to have additional financial requirements in the future would you recommend that it use convertibles

  Avoiding the risk of sub optimization

ROI used to estimate the performance of an investment center manager can sometimes lead to sub optimization.

  Domestic parent and foreign subsidiary

What major problem might arise with intercompany debt between a domestic parent and a foreign subsidiary or between subsidiaries in different countries? How has Hershey Foods dealt with this problem?

  Capital asset pricing model-market risk premium

Assume the market risk premium is 6.5% and risk free interest rate is 5%. Compute the cost of capital of investing in project with beta of 1.2.

  Compute the present value of receiving 2300 per year with

suppose the term structure of risk-free interest rates is as shown below term1 year2 years3 years5 years7 years10

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