Question: Excel Homework Chapter 15 1. Compute the following ratios for 2015 and 2014 Current ratios cash ratio Times interest earned ratio Inventory turnover Gross profit

Excel Homework Chapter 15

1. Compute the following ratios for 2015 and 2014

Current ratios

cash ratio

Times interest earned ratio

Inventory turnover

Gross profit percentages

Debt to equity ratio

Rate of return on common stockholders' equity

Earnings per share of common stock

Price/earnings ratio

2. Prepare a vertical analysis for both the income statement and balance sheet

3. Prepare a horizontal analysis for both the income statement and balance sheet

4. Decide (a) whether Tanfields' ability to pay debts and to sell inventory improved

or deteriorated during 2015 and (b) whether the investment attractiveness of its common stock appears

to have increased or decreased.

5. Analyzing the vertical and horizontal analysis - what questions do you have? What do you notice?

Excel Homework Chapter 15 1. Compute the following ratios for 2015

and 2014 Current ratios cash ratio Times interest earned ratio Inventory turnover

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Back This window shows your responses and what was marked correct and incorrect from your previous a 1 63.26/100 points awarded Scored Assume it is Monday, May 1, the first business day of the month,...

Q:

Comparative financial statement data of Dangerfield, Inc. follow: o view the income statement.) (Click the icon to view the additional financial information.) (Click the ico E (Click the icon view...

Q:

Comparative financial statement data of Banfield, Inc., follow: 1. Market price of Banfields common stock: $ 49.50 at December 31, 2014, and $ 27.02 at December 31, 2013 2. Common shares outstanding:...

Q:

P17-31A Using ratios to evaluate a stock investment Comparative financial statement data of Danfield, Inc. follow: 1. Market price of Danfields common stock: $86.58 at December 31, 2015, and $46.54...

Q:

Comparative financial statement data of Tanfield, Inc., follow: 1. Market price of Tanfields common stock: $ 47.67 at December 31, 2014, and $ 27.84 at December 31, 2013 2. Common shares outstanding:...

Q:

P17-38B Using ratios to evaluate a stock investment Comparative financial statement data of Tanfield, Inc. follow: 1. Market price of Tanfields common stock: $86.58 at December 31, 2015, and $46.54...

Q:

ABC Company Case Analysis You have been hired by ABC Co. to assess their current financial situation and offer suggestions for potential expansion. ABC has been in business for 6 years and has grown...

Q:

Complete the following steps after reading theABC Co. Case Studyand the lesson materials. In an Excel spreadsheet, prepare the financial statements. Make income statement, statement of retained...

Q:

So basically, the information is below... I need answers to questions 4 and 5!! I have completed the rest as you can see below. I have added images! She lets you know during the course of your...

Q:

CASE ANALYSIS 1. In an Excel spreadsheet, prepare the financial statements. Create an income statement, statement of retained earnings and balance sheet. Be sure to use your own formulas whenever...

Q:

1.Selected financial data of Arianna and Beyonc for a recent year as presented here ( in millions). Arianna Corporation Beyonc, Inc. Income Statement Data for Year Net Sales $61,471 $374,526 Cost of...

Q:

Obtain a copy of Rufus and Millers 2007 article, Attorney Client Privilege and the Forensic Accountant published in The Value Examiner. (A link to this article is available at...

Q:

A buffer containing 0.2000 M of acid, HA and 0.1500 M of its conjugate base, A - , has pH of 3.35. A. Determine Ka of the acid HA; B. Predict the pH after 0.0015 mol of NaOH is added to 0.5000 L...

Q:

Alright, now let s get to explore what choices Kwame has when it comes to fixed income funds in the Plan. Does the Plan list at least one Government Bond Fund and at least one Corporate Bond Fund?...

Q:

a=2 b= 0 c= 2 d=0 e=0 f=9 g=3 5. Draw the Network diagram for the following project. Estimate the Earliest start time and Latest finish time for each activity. If every day it cost 200 rials for this...