Compute each of the ratios for 2013 and 2014

Assignment Help Financial Management
Reference no: EM13828819

Comprehensive Problem

Use the following information to answer the questions below: note: all sales are credit sales

Income Stmt info: 2013 2014
Sales   $        1,050,000  $        1,128,750
less Cost of Goods Sold:                325,000                346,125
Gross Profit                725,000                782,625
Operating Expenses                575,000                609,500
Earnings before Interest  & Taxes                150,000                173,125
Interest exp                  25,000                  29,000
earnings before Taxes                125,000                144,125
Taxes                  50,000                  57,650
Net Income  $              75,000  $              86,475



Balance Sheet info: 12/31/2013 12/31/2014
Cash                  60,000  $              66,000
Accounts Receivable                  80,000  $              83,200
Inventory                110,000  $            119,900
Total Current Assets  $            250,000  $            269,100
Fixed Assets (Net)  $            300,000  $            318,000
Total Assets  $            550,000  $            587,100



Current Liabilities  $            130,000  $            136,500
Long Term Liabilities  $            150,000  $            170,000
Total Liabilities  $            280,000  $            306,500
Stockholder's Equity  $            270,000  $            280,600
Total Liab & Equity:  $            550,000  $            587,100

Compute each of the following ratios for 2013 and 2014 and indicate whether each ratio was getting "better" or "worse" from 2013 to 2014 and whether the 2014 ratio was "good" or "bad" compared to the Industry Avg (round all numbers to 2 digits past the decimal place)


2013 2014 Getting Better or Getting Worse? 2014 Industry Avg  "Good" or "Bad" compared to Industry Avg
Profit Margin


0.11
Current Ratio


1.90
Quick Ratio


1.12
Return on Assets


0.26
Debt to Assets


0.55
Receivables turnover


18.00
Avg. collection period*


21.20
Inventory Turnover**


8.25
Return on Equity


0.25
Times Interest Earned


8.15

*Assume a 360 day year

**Inventory Turnover can be computed 2 different ways. Use the formula listed in the text (the one the text indicates many credit reporting agencies generally use)

Reference no: EM13828819

Questions Cloud

Own system of getting the creative juices flowin'' : Everyone has his or her own system of getting the creative juices flowin' that includes locking in a topic, gathering the information, organizing the material and finding the right conditions under which to compose. What system works best for you?(a)..
What is the expected return on market-pre-tax cost of debt : The stock of Big Joe's has a beta of 1.54 and an expected return of 12.80 percent. The risk-free rate of return is 5.3 percent. What is the expected return on the market? The Bet-r-Bilt Company has a 5-year bond outstanding with a 4.60 percent coupon..
Poisson distribution to calculate unscheduled flight arrival : Poisson Distribution to Calculate Unscheduled Flight Arrivals
Useful in making financial decisions : 1 a)Are there any other types of information besides financial that may be useful in making financial decisions? b)  Identify the major components of a corporate compliance plan, including the establishment of internal controls relating to the financ..
Compute each of the ratios for 2013 and 2014 : Compute each of the ratios for 2013 and 2014 and indicate whether each ratio was getting "better" or "worse" from 2013 to 2014 and whether the 2014 ratio was "good" or "bad" compared to the Industry Avg (round all numbers to 2 digits past the deci..
Poisson distribution to calculate unscheduled flight arrival : Poisson Distribution to Calculate Unscheduled Flight Arrivals
Compare and contrast voluntary and involuntary groups : What intercultural perceptions do people have and how we relate to each other. What do people want to know or need to learn about these topics? - In your own word define and discuss short- and long-term memory. - Compare and contrast voluntary and in..
Some industries such as airlines rely heavily on debt : Why do you believe some industries such as airlines rely heavily on debt, while others such as computers do not?
Calculation of avg per diem cost of business class travel : Calculation of Average Per Diem Cost of Business Class Travel

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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