Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me create a sensitivity analysis? Financial Statement Analysis Package (FSAP): Version 8.0 Financial Reporting, Financial Statement Analysis, and Valuation: A Strategic Perspective, 8th

Please help me create a sensitivity analysis?

Financial Statement Analysis Package (FSAP): Version 8.0 Financial Reporting, Financial Statement Analysis, and Valuation: A Strategic Perspective, 8th 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.) 2011 2012 2013 2014 BALANCE SHEET DATA Assets: Cash and cash equivalents 829 1,113 1,355 1,282 Marketable securities Accounts and notes receivablenet 299 332 419 365 Inventories 401 469 467 342 Prepaid expenses and other current assets 263 246 250 232 Deferred tax assetscurrent 238 210 168 477 Other current assets (1) 2,315 1,857 1,797 1,706 Other current assets (2) Current Assets 0 0 4,345 4,227 4,456 4,404 Investments in noncontrolled affiliates Property, plant, and equipmentat cost 18,421 19,497 20,820 22,513 6,294 6,731 7,431 8,221 Amortizable intangible assets (net) Goodwill 970 970 970 970 Other nonamortizable intangible assets 626 633 530 534 Other noncurrent assets (1) Other noncurrent assets (2) Total Assets 0 0 18,068 18,596 19,345 20,200 Liabilities and Equities: Accounts payable 1,057 1,107 1,247 1,203 Current accrued expenses 996 1,102 1,229 1,565 Notes payable and short-term debt Current maturities of long-term debt Deferred tax liabilitiescurrent Income taxes payable Other current liabilities (1) 1,836 2,170 2,571 2,897 Other current liabilities (2) 644 271 629 258 Current Liabilities 0 0 4,533 4,650 5,676 5,923 Long-term debt obligations 3,107 2,883 2,191 2,434 Long-term accrued liabilities Deferred tax liabilitiesnoncurrent 2,566 2,884 2,934 3,259 Other noncurrent liabilities (1) 75 63 437 554 Other noncurrent liabilities (2) 910 1,124 771 1,255 Total Liabilities 0 0 11,191 11,604 12,009 13,425 Preferred stock Common stock + Additional paid in capital 2030 2018 2039 2123 Retained earnings 5,395 5,768 6,431 7,416 Accum. other comprehensive income -224 -119 -3 -738 and other equity adjustments -324 -675 -1,131 -2,026 Total Common Shareholders' Equity 0 0 6,877 6,992 7,336 6,775 Noncontrolling interests Total Equity 0 0 6,877 6,992 7,336 6,775 Total Liabilities and Equities 0 0 18,068 18,596 19,345 20,200 INCOME STATEMENT DATA 0 0 2011 2012 2013 2014 Revenues 15,658 17,088 17,699 18,605 Gross Profit 0 0 15,658 17,088 17,699 18,605 -14,965 -16,465 -16,421 -16,380 Other operating income (1) Other operating income (2) Non-recurring operating gains Operating Profit 0 0 693 623 1,278 2,225 Interest income Income from equity affiliates Other income or gains -370 62 -69 -409 Income before Tax 0 0 323 685 1,209 1,816 -145 -264 -455 -680 Income from discontinued operations Extraordinary gains Changes in accounting principles Net Income 0 0 178 421 754 1,136 Net income attributable to noncontrolling interests Net Income attributable to common shareholders 0 0 178 421 754 1,136 Net Income (enter reported amount as a check) Other comprehensive income items Comprehensive Income 0 0 178 421 754 1,136 STATEMENT OF CASH FLOWS DATA 0 0 2011 2012 2013 2014 Net Income 0 0 178 421 754 1,136 Add back depreciation and amortization expenses 715 844 867 938 Add back stock-based compensation expense 90 -189 -5 279 Deferred income taxes 123 251 50 501 Decrease in accounts receivable -26 -33 -17 54 Decrease in inventories Decrease in prepaid expenses Decrease in other current assets -196 -104 -46 142 Decrease in other noncurrent assets Increase in accounts payable 253 186 343 36 Increase in income taxes payable Increase in other current liabilities 262 334 400 326 Increase in other noncurrent liabilities Other addbacks to net income -195 233 57 -233 Other operating cash flows 152 121 74 -277 Net CF from Operating Activities 0 0 1,356 2,064 2,477 2,902 Proceeds from sales of property, plant, and equipment -968 -1,348 -1,433 -1,748 -14 -80 Decrease in marketable securities -5,362 -2,481 -3,135 -3,080 Investments sold 5,343 2,996 3,198 3,185 -4 Payments for acquisitions of intangible assets -35 Other investment transactions Net CF from Investing Activities 0 0 -1,022 -833 -1,384 -1,727 Increase in short-term borrowing 300 Increase in long-term borrowing 20 27 96 110 Issue of capital stock 27 Proceeds from stock option exercises 76 38 -540 -578 -313 -561 -81 -22 -71 -139 Other financing transactions (1) -14 -5 -11 Other financing transactions (2) -227 -412 -558 -974 Net CF from Financing Activities 0 0 -766 -947 -851 -1,248 Effects of exchange rate changes on cash Net Change in Cash 0 0 -432 284 242 -73 Cash and cash equivalents, beginning of year 0 0 0 829 1,113 1,355 Cash and cash equivalents, end of year 0 0 829 1,113 1,355 1,282 SUPPLEMENTAL DATA 0 0 2011 2012 2013 2014 Statutory tax rate 240 423 636 Average tax rate implied from income statement data #DIV/0! #DIV/0! 44.9% 38.5% 37.6% 37.4% After-tax effects of nonrecurring and unusual items on net income Depreciation expense 715 844 867 938 Preferred stock dividends (total, if any) Common shares outstanding 775 757 718 696 Earnings per share (basic) 0.23 0.55 1.05 1.64 Common dividends per share #DIV/0! #DIV/0! 0.10 0.03 0.10 0.20 Share price at fiscal year end 8.56 10.24 18.84 42.32 FINANCIAL DATA CHECKS Assets - Liabilities - Equities 0 0 0 0 0 0 Net Income (computed) - Net Income (reported) 0 0 178 421 754 1,136 Cash Changes 0 -1,261 0 0 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions