# Finance-AW-Q179

## Finance-AW-Q179 Online Services

Assignment #2

Download Excel Spreadsheet for Assignment #2 and save the file in your computer in a folder for this class. Name the file: YourLastName BusAc186 Assignment 02

Find the web site for J C Penney Department store. Do the same for this company as you did for Assignment #2. Go to the company’s web site and look for a link to the Investor’s pages. Go to the Investor’s Pages and locate the Annual Report for last year. The report should include the Financial reports for last year and at least one prior year. Download and save the Financial Statements from the report. You will need three year’s worth of Financial Reports, so also download and save the previous year’s Annual Report if your company’s report does not include at least 3 years worth of Financial Statements. Open the Excel Spreadsheet provided under the assignment link for Assignment #2. Save it to your computer. Complete the spreadsheet in all of the highlighted cells with information you find in the financial Statements. Be sure to do 3 year’s worth of data.

Compute the ratios on the rows that follow the Financial Report Highlights. USE EXCEL to compute the ratios. Do NOT calculate the ratios elsewhere and copy the answers into the spreadsheet. Credit will not be awarded for ratios that are not computed in Excel. Your instructor needs to be able to see your formulas in Excel in order to grade your work. Try to enter your formulas using point and click on the cells containing the data you are entering in the formulas.
For the Stock price, get it from today’s price posted on the Internet from any finance Web Site such as Yahoo finance.

Open and take another look at the Financials and ratios you found and calculated for Assignment #1 Write a double spaced 2 page paper comparing the Financials and ESPECIALLY the Ratios that you have calculated. for both companies. Did you find any trends for Macy’s? Penny’s? Using the ratios calculated, does the financial data indicate that one company or the other has a particular strength? or weakness? Are there any areas where one company is stronger or weaker than the other? Compare P/E ratios. Check to see P/E ratios for other competitors (You should be able to get that directly off of Yahoo Finance or other Financial web sites.) Does any company have a significantly higher (or lower) P/E Ratio? Considering that over the long haul, all numbers tend to gravitate to the mean, can you recommend one stock over another for an investor to purchase. ? What other indications do you see about the strengths and weaknesses of the 2 companies that you are analyzing?

You can read more about our case study assignment help services here.

## How it Works

#### How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

## Case Approach

#### Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

## Related Services

Student Name is ___________________________________ Fill in the highlighted areas
If your Firm’s Annual Report gives only 2 years, check last year’s Annual Report to get a 3rd Year’s Data
Important!!!!! Complete Current Date and Balance Sheet Years will complete themselves

Current Date –> _ _ #VALUE!

Company Name is _________
Balance Sheet Balance Sheet Balance Sheet
Balance Sheet Items for Year #VALUE! #VALUE! #VALUE!

Assets

Cash & Cash Equivalents
Accounts receivable
Inventory
Total Short term Assets

Equipment
Less Accumulated Depreciation
Equipment Net Book Value
Real Property
Less Accumulated Depreciation
Real Property Net Book Value
Total Long Term Assets

Total Assets

Liabilities & Stockholders Equity

Liablities

Accounts Payable (Combine if more than one)
Taxes Due
Other Short Term Debt
Total Short Term Liabilities

Long Term Debt
Other Liabilities
Total Long Term Debt

Total Liabilities

Stockholders Equity

Common Stock
Preferred Stock
Treasury Stock
Retained Earnings
Total Shareholders Equity

Total Liabilities and Stockholders Equity

Company Name _________
Income Statement Income Statement Income Statement

For Fiscal Year Ending December 31, #VALUE! December 31, #VALUE! December 31, #VALUE!

Net Sales

Cost of Goods Sold

Gross Profit

Operating Expenses

Gain or Loss from Unusual Expenses

Operating Income

Interest expense

Gain (Loss) before Taxes

Income Taxes

Net Income

Earnings per Share

Today’s Stock Price

Price / Earnings Ratio

Key Ratios

Return on Sales

Return on Assets

Return on Equity

Current Ratio

Acid Test Ratio

Inventory Turnover Ratio

Debt Ratio

Student Name is

Current Date 10/03/2015

Company Name is Macy’s
Balance Sheet
Balance Sheet Items for Year 2010

Assets

Cash & Cash Equivalents \$2,622
Accounts receivable \$535
Inventory \$3,213
Total Short term Assets \$6,370

THIS is why you have 2 yellow columns to properly format CONTRA ASSETS
LOOK for the REAL ESTATE SCHEDULE in “F” Pages of ANNUAL Report 1 100 plus page document
Equipment \$2,271
Less Accumulated Depreciation
Equipment Net Book Value \$2,271
Real Property \$5,814
Less Accumulated Depreciation \$2,854
Real Property Net Book Value \$2,960
Other Assets \$1,467
Total Long Term Assets \$6,698
Total Assets \$13,068

Liabilities & Stockholders Equity

Liablities

Accounts Payable (Combine if more than one) \$2,647
Taxes Due
Other Short Term Debt
Total Short Term Liabilities \$2,647

Long Term Debt \$3,099
Deferred Taxes \$1,192
Other Liabilities \$670
Total Long Term Debt \$4,961

Total Liabilities \$7,608

Stockholders Equity
Include the DETAIL Provided
Common Stock \$118
Preferred Stock
Treasury Stock
Retained Earnings \$1,417
Total Shareholders Equity \$5,460

Total Liabilities and Stockholders Equity \$13,068

Company Name
Income Statement

For Fiscal Year Ending December 31, 2010

Net Sales \$17,759

Cost of Goods Sold (\$10,799)

Gross Profit \$6,960

Operating Expenses (\$6,128)

Gain or Loss from Unusual Expenses \$11

Operating Income \$843

Interest expense (\$251)

Gain (Loss) before Taxes \$592

Income Taxes (\$203)

Net Income \$389

Earnings per Share \$1.64

Today’s Stock Price

Price / Earnings Ratio
Macy’s
Income Statement Income Statement Income Statement

December 31, 2014 December 31, 2013 December 31, 2012

\$28,105 \$27,931 \$27,686

-\$16,863 -\$16,725 -\$16,538

\$11,242 \$11,206 \$11,148

-\$8,355 -\$8,440 -\$8,482

-\$87 -\$88 -\$5

\$2,800 \$2,678 \$2,661

-\$395 -\$390 -\$425

-\$17 -\$137

\$2 \$2 \$3

\$2,390 \$2,290 \$2,102

-\$864 -\$804 -\$767

\$1,526 \$1,486 \$1,335

\$4.30 \$3.93 \$3.29

\$57.28 \$57.28 \$57.28

\$13.32 14.57506361 17.41033435

0.054296389 0.053202535 0.048219317

0.070537118 0.068688176 0.06042091

0.244199072 0.245579243 0.225012641

1.517289556 1.551921182 1.401405077

\$0.55 \$0.51 \$0.58

\$3.03 \$3.15 -\$3.23

0.711149117 0.7117336 0.73147771

2.461993919 2.469013386 2.724085623

Product Code -Finance-AW-Q179