Tutorspedia

Finance-AW-Q179 Online Services

 

Assignment #2

 
Download and read instructions for 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?

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
Additional Paid In Capital
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
Save your spreadsheet and your MS Word document analysis and upload both papers under the assignment link.
 
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
If your spreadsheet does not have a corresponding line ADD IT. Do NOT ignore data
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
Additional Paid In Capital $3,925
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

Looking for Finance-AW-Q179,please click here