Final financial ratio analysis assignment

  

This term you have learned to understand a company’s financial story using the language of accounting. The recording and reporting of information is essential to decision makers and other users of financial information; numbers on the various financial statements are used to help further understand the financial condition of the business. This process is known as financial ratio analysis and allows us to analyze the company’s financial position in relation to other organizations in the industry. In this final assignment, you will apply the concepts you have learned throughout the term to perform financial statement analysis and to offer some recommendations. 

Assume that you are a health care consultant hired by the Dependable DME Company. DME is Durable Medical Equipment and includes all equipment that benefits patients who have certain medical conditions. The owner of the company, David Smith, is interested in applying for a loan to expand his business; he desires to open a second location in another city. He is preparing to apply to a local bank for a loan. 

The bank will base its decision on the following averages for the DME industry:

  

Ratio

Industry Average

 

Current   ratio

1.50

 

Quick   ratio

0.80

 

Receivables   turnover ratio

18.0

 

Inventory   turnover ratio

20.0

 

Debt   to assets ratio

0.56

 

Profit   margin

10.25%

The balance sheet data for Dependable DME Company follows:

  

December 31, 2017

December 31, 2016

 

Cash

$75,000

$60,000

 

Accounts   receivable

40,000

20,000

 

Inventory

30,000

20,000

 

Prepaid   insurance

5,000

5,000

 

Total current assets

140,000

105,000

 

Property   and equipment

600,000

550,000

 

Accumulated   depreciation

140,000

110,000

 

Total property and equipment

460,000

440,000

 

Total assets

$600,000

$545,000

 

Accounts   payable

$60,000

$60,000

 

Other   current liabilities

40,000

45,000

 

Total current liabilities

100,000

105,000

 

Bonds   payable

150,000

150,000

 

Total liabilities

250,000

255,000

 

Common   stock

250,000

250,000

 

Retained   earnings

100,000

40,000

 

Total stockholders’ equity

350,000

290,000

 

Total liabilities and stockholders’   equity

$600,000

$545,000

The income statement data for Dependable DME Company follows:

  

Sales

$600,000

 

Cost   of goods sold

350,000

 

Gross profit

$250,000

 

Operating   expenses

100,000

 

Operating income

$150,000

 

Interest   expense

25,000

 

Income before taxes

$125,000

 

Income   tax expense

65,000

 

Net   income

$60,000

Required: 

  1. Calculate the following six (6) ratios: Current Ratio, Quick Ratio, Receivables      Turnover Ratio, Inventory Turnover Ratio, Profit Margin Ratio and Debt to Assets      Ratio. Be sure to show the actual calculation as well as your final      answer. 

You are only required to calculate the ratios for 2017; however, for two of the ratios (Receivables Turnover Ratio and Inventory Turnover Ratio), you will need data from 2016 for the formula. When calculating the Quick Ratio, please note that Short-Term Investments are $0 in this scenario. (24 points; 4 points for each ratio calculation)

  1. Below each ratio, comment on the interpretation of      the ratio. In other words, what does the result tell you, specifically? (8      points)
  2. Based upon the industry averages upon which the bank      relies, should they approve the loan to Mr. Smith? Why or why not? (7      points)
  3. In one-half page, comment on what financial aspect      of Dependable DME Company looks good and where can Mr. Smith make some      improvements. Specifically identify at least two recommendations to Mr.      Smith that can be made to improve the financial position of his business.      (8 points)

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more