Financial statement analysis project

Assignment Help Financial Management
Reference no: EM131041

Financial Statement Analysis Project -- A Comparative Analysis of Kohl's Corporation and J.C. Penney Corporation

Using the financial statements for Kohl's Corporation and J.C. Penney Corporation, respectively, you will calculate and compare the financial ratios listed further down this documentfor the fiscal year ending 2010 and prepare your comments about the liquidity, solvency, and profitability of the two companies based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in Week 7 and one grade will be assigned for the entire project.

Overall Requirements

1. A completed worksheet title page tab, which is really a cover sheet with your name, the course, the date, your instructor's name, and the title for the project.

2. A completed worksheet profiles tab, which contains a-one paragraph description regarding each company with information about their history, what products they sell, where they are located, etc.

3. All 18 ratios for each company with the supporting calculations and commentary on your worksheet ratio tab. Supporting calculations must be shown either as a formula or as text typed into a different cell.The ratios are listed further down this document. Your comments for each ratio should include more than just a definition of the ratio. You should focus on interpreting each ratio number for each company and support your comments with the numbers found in the ratios.

4. The Summary and Conclusions worksheet tab, which is an overall comparison of how each company compares in terms of the major category of ratios (liquidity, profitability, and solvency). A nice way to conclude is to state which company you think is the better investment and why.

5. The Bibliography worksheet tab must contain at least your textbook as a reference. Any other information you use to profile the companies should also be cited as a reference.

Required Ratios for Final Project Submission

1. Earnings per share

2. Current ratio

3. Gross profit rate

4. Profit margin ratio

5. Inventory turnover ratio

6. Days in inventory

7. Receivables turnover ratio

8. Average collection period

9. Assetturnover ratio

10. Return on assets ratio

11. Debt to total assets ratio

12. Times interest earned ratio

13. Payout ratio

14. Return on common stockholders' equity ratio

15. Free cash flow

16. Current cash debt coverage ratio

17. Cash debt coverage ratio

Reference no: EM131041

Questions Cloud

Cyber troll case study : Case Study - THE CYBER TROLL
Evaluate the study : Binge drinking and alcohol-related behaviours amongst Pacific youth: a national survey of secondary school students
Discuss the ethical issues : Discuss the ethical issues
Symmetry in the rod : matlab programming
Financial statement analysis project : Using the financial statements for Kohl's Corporation and J.C. Penney Corporation, respectively, you will calculate and compare the financial ratios
Quantitative analysis : What is the probability of winning a prize in an office sweep
Evaluate thermal efficiency of the cycle : Evaluate thermal efficiency of the cycle
Find the absolute maximum and minimum mpg : Find the absolute maximum and minimum mpg
Level process control lab : Determination of the open-loop system

Reviews

Write a Review

 

Financial Management Questions & Answers

  Determine the constant growth rate in dividends

Arbitrage Financial is offering two possible investments with the same level of risk.

  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.

  Indifference curve analysis

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change.

  Personal financial management

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

  Replacement analysis

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

  Financial assessment of mk robe-stones limited business plan

Financial Assessment of MK Robe-Stones Limited Business Plan.

  Draw up balance sheet and income statement

Draw up balance sheet and income statement.

  Overview of financial management

Overview of Financial Management

  Estimate the residual value and perform firm valuation

Estimate the Residual Value and perform the corresponding firm valuation.

  Report annual cash flows

Briefly explain why you are using the computational method chosen. (Hint: you will need to decide to use the APV or WACC formula.

  A synthesis of contemporary market orientation perspectives

A synthesis of contemporary market orientation perspectives

  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.

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