Could someone please use the financial statements for JcPenny from the company's annual report for years 2011-2014 and fill in the FSAP excel template. I want to make sure I entered correctly by comparing to another doc. Thanks!

Financial Statement Analysis Package (FSAP): Version 7.0 Financial Reporting, Financial Statement Analysis, and Valuation: A Strategic Perspective, 7th Edition By James Wahlen, Steve Baginski and Mark Bradshaw The FSAP User Guides appear in column I to the right. Analyst Name: Company Name: Year (Most recent in far right column.) BALANCE SHEET DATA Assets: Cash and cash equivalents Marketable securities Accounts receivable - net Inventories Prepaid expenses and other current assets Deferred tax assets - current Other current assets (1) Other current assets (2) Current Assets Long term investments Property, plant, and equipment - at cost Amortizable intangible assets (net) Goodwill and nonamortizable intangibles Deferred tax assets - noncurrent Other noncurrent assets (1) Other noncurrent assets (2) Total Assets Liabilities and Equities: Accounts payable - trade Current accrued liabilities Notes payable and short-term debt Current maturities of long-term debt Deferred tax liabilities - current Income taxes payable Other current liabilities (1) Other current liabilities (2) Current Liabilities Long-term debt Short-term debt Shareholder's equity Deferred tax liabilities - noncurrent Other noncurrent liabilities (1) Other noncurrent liabilities (2) Total Liabilities JcPenny 2011 2012 0 0 0 0 0 0 0 0 Minority interest Preferred stock Common stock + Additional paid in capital Retained earnings Accum. other comprehensive income Other equity adjustments Common Shareholders' Equity Total Liabilities and Equities 0 0 0 0 INCOME STATEMENT DATA Revenues Gross Profit Other operating income (1) Other operating income (2) Non-recurring operating gains Operating Profit Interest income Income from equity affiliates Premium on Early Retirement of Debt Income before Tax Income from discontinued operations Extraordinary gains Changes in accounting principles Net Income (computed) Net Income (enter reported amount as a check) Other comprehensive income items Comprehensive Income 2011 2012 0 0 0 0 0 0 0 0 STATEMENT OF CASH FLOWS DATA Net Income Add back depreciation and amortization expenses Add back stock-based compensation expense Deferred income taxes Decrease in accounts receivable Decrease in inventories Decrease in prepaid expenses Decrease in other current assets (1) Decrease in other current assets (2) Increase in accounts payable Increase in other current liabilities (1) Increase in other current liabilities (2) Increase in other noncurrent liabilities (1) Increase in other noncurrent liabilities (2) Other addbacks to net income Other operating cash flows Net CF from Operations Proceeds from sales of property, plant, and equipment Decrease in marketable securities Investments sold Other investment transactions Other investment transactions (2) Net CF from Investing Activities Increase in short-term borrowing Increase in long-term borrowing Issue of capital stock Proceeds from stock option exercises Other financing transactions (1) Other financing transactions (2) Net CF from Financing Activities Effects of exchange rate changes on cash Net Change in Cash Cash and cash equivalents, beginning of year Cash and cash equivalents, end of year 2011 2012 0 0 0 0 0 0 0 0 0 0 0 0 0 SUPPLEMENTAL DATA Statutory tax rate Average tax rate implied from income statement data After-tax effects of nonrecurring and unusual items on net income Total deferred tax assets (from above) Deferred tax asset valuation allowance Allowance for uncollectible accounts receivable Depreciation expense Cash paid on stock dividends (total, if any) Common shares outstanding Earnings per share (basic) Common dividends per share Market price per share at fiscal year end FINANCIAL DATA CHECKS Assets - Liabilities - Equities Net Income (computed) - Net Income (reported) Cash Changes 2011 2012 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0 7th Edition 2013 2014 0 0 0 0 0 0 0 0 0 0 0 0 2013 2014 0 0 0 0 0 0 0 0 2013 2014 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2013 2014 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 0 0 0