Question: Continue to evaluate the company you had selected in Module 02. As part of your plan, use the spreadsheet provided below. The spreadsheet includes two

Continue to evaluate the company you had selected in Module 02.

As part of your plan, use the spreadsheet provided below. The spreadsheet includes two tabs - one for the Analytical Ratios and another for the Horizontal Analysis. Also, insert your risk analysis into the spreadsheet on a separate tab.

Company Name

Ratio Analysis

Recent YearYear - 1Year 2year

Short Term Debt

Cash Ratio

Quick Ratio

Current Ratio

Liquidity

A/R Turnover

Days to collect A/R

Inventory Turnover

Days to sell Inventory

Long-Term Debt

Debt to Equity

Times Interest Earned

Profitability

Earning per Share

Gross Profit Percentage

Profit Margin

Return on Assets

Return on Common Equity

CompanyName

Horizontal Analysis of Income Statement

Recent Year vs Year -1Year -1vs Year -2

$ Change% Change. $ Change% Change

Net Sales

Cost of Goods Sold

Gross Profit

Operating Expenses

Income from Operations

Other Revenue and Gains

Other Expenses and Losses

Income before Income Taxes

Income taxes

Net Income

Earnings per share

Company Name

Horizontal Analysis of Balance Sheet

Recent Year vs Year -1Year - 1 vs Year -2

$ Change% Change. $ Change% Change

Assets

Current Assets

Cash and Equivalents

Net Receivables

Inventory

Other current assets

Total Current Assets

Property, plant, & Equip

Total Assets

Liabilities

Current Liabilities

Payables

Short term/current long term debt

Other current liabilities

Total current liabilities

Long-term debt

Total Liabilities

Stockholder's Equity

Common Stock

Additional PICap

Retained Earnings

Total Stockholder's Equity

Total Liab & Stockholder's Equity

Feel free to add and subtract lines on the horizontal analysis to match the financial statements of the company you have chosen. You may want to also include a horizontal analysis of the cash flow statements since these can provide additional information. Copy the financial statement data into another tab on your spreadsheet.

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!

Module 03 Content Continue to evaluate the company you had selected in Module 02. As part of your plan, use the spreadsheet provided below. The spreadsheet includes two tabs - one for the Analytical...

This is a financial cost-benefit analysis class. I need help with the case study with the computations of the case study. The files are provided in the link below or is attached. Willing to pay to...

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

HSA 599 - Health Services Administration Capstone (Prerequisite: To be taken last or next to last; a grade of \"B\" or higher is required) COURSE DESCRIPTION Examines the strategic management process...

OL 215 Final Project One Guidelines and Rubric Overview The final project for this course is the creation of a decision-making and principles of management paper. As you continue on your path to earn...

Presentation "Sowing the Seeds: Program Evaluation that Works for You " is at the bottom Evaluate the presentation Transcript module ' Sowing the Seeds: Program Evaluation that Works for You " and...

MNG3701/101/3/2016 Tutorial Letter 101/3/2016 Strategic Planning MNG3701 Semesters 1 and 2 Department of Business Management IMPORTANT INFORMATION: Please activate your myUnisa and myLife email...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

I need help with this assignment. I have attached the required documents to be completed along with the instructions. Use the project guidelines and case study as a guide to complete the spreadsheet...

Type of Donut Chocolate Cream filled Strawberry Kale frosted Blueberry Cream filled surprise Number purchased 6.00 Submit 5.00 8.00 3.00 6.00 Probability Cumulative Probability Based on the above...

Harris Company manufactures and sells a single product. A partially completed schedule of the company's total costs and costs per unit over the relevant range of 52,000 to 92,000 units is given...

lim x 1 s i n ( x 2 - 1 ) x 2 - 1 pleax explain why i t does become lim x 0 ? s i n t t = 1

An investor has the opportunity to make an investment that will provide an effective annual yield of 12 percent. She is considering two other investments of equal risk that will provide compound...

A loan of $60,000 is due 10 years from today. The borrower wants to make annual payments at the end of each year into a sinking fund that will earn compound interest at an annual rate of 10 percent....

A pension fund is making an investment of $100,000 today and expects to receive $1,600 at the end of each month for the next five years. At the end of the fifth year, the capital investment of...

An investment in a real estate venture will provide returns at the end of the next four years as follows: year 1, $5,500; year 2, $7,500; year 3, $9,500; and year 4, $12,500. An investor wants to...

A corporation is considering the purchase of an interest in a real estate syndication at a price of $75,000. In return, the syndication promises to pay $1,000 at the end of each month for the next 25...

Q2: How sensitive are Stone Container's earnings and cash flow to the paper and linerhoard pricing cycle? Estimate for the next twelve months the effect on earnings and

The number of new ideas that emerge

7. Develop a circular model, with positive and negative feedback loops, showing the following critical variables:

Technology