"[SBJ JO SISN pue SOINOS AY}
I9PISUOD ‘SISAJeue dy) UJ *[Z(7 I0J SMO[J USBI ,SYONqIe)S JO JUIUISSISSE [[eIOA0 UR OpPIAOI] °S
(Syuewkedar 1qap pue somyipuadxa [e31des 105 poapesu SpUBWSP sed JO 1431] UI SPUSPIAIP
Aed 0) dnUNUOO $YONQqIEIS PINOM AYA ¢SIudowAed 1qop wo} Iopyip sjuouwAed puspIalp
MOH "193p $31 Jo uoniod o[qezis e Aedo1 30u Ip Inq A[OANOdSaI UOI[[IW ()'6] ‘ZS PUL
"SETO°LS €19L°1$ JO SpudpIAIp pred s)onqrels XXXXXXXXXXPoued 1eok-o01ys ogy Jung “y
(A321e1s 5, Aueduwod oy) In0qe 2YedIPUI SIN) SIP JBYA (S19sse Surj[os Luo
Auedwos ay; s1 ¢s10sse Suroejdar Auedwios ay si Jo sasse Suippe Aueduwiod ay) Ss] ‘po
xd
XXXXXXXXXX]) 9) 10J SAPIAIOE JUNSIAUL WOT} SMO[JUI PUB SMOINO Ysed Arewrnd oy) AJRuopy °¢
"SuUONeIado wIoIy MO} Sed 0) PIJIOAU0D
SI OUWIOJUI Jou Us uonIppe ue se Jeadde uonezniowe pue uonerodrdop Ayam urejdxq °z
M-01 WO [Z0T AU} UI pajuasaid siedk
9914} 3) 10] suoneIado WoL} MO[F YSBO PUB SWIOIUT JOU UIMIeq dIysuone[a1 ay Ssnasiq °|
:paambayy
"TT0T ‘C1 IPQUIdAON
Ap JO pud uel) I9)e] JOU PIBOGYOB[E BIA JUSWNOOP JNO JIWIQNS PINOYS NOX * T SPngIels
[ENIUNSILISWENISeT, 9] 9) [9qe] pue 3dZ | 18 JUOy UBWIOY MON SOW], SUISN JUSWNIOP PIO
© UO Ssuonsonb ZuImoj[oF oy} SS2Ippe 0) 199yspeaids [90Xq Jv'Sd oy uo ndur pue padres nok
EIEP dU} 0) JOJO "93UBYD SY) PUIYSq SUOSEII ay) Inq Jueiodwur ST Jey) yseo ur 9Fueyd oy) 10 SI Jf
'SOSBIIOIP USED JI JO OSI0M PUB SOSBIIOUI USED JO doue[eq FUIpUS oy) JI JJO 10319q ST Auedwod ay)
SPN[OU0d ALIESSIOAU JOU P[NOYS SIOFLUBW [RIOUBULY ‘SMO USED) JO JusWLelS oy) SuizA[eue uj
Z Hed - ase) pajeibajuj
uonjesodio) syongJe}s
Data
Financial Statement Analysis Package (FSAP): Version 10.0
Financial Reporting, Financial Statement Analysis, and Valuation: A Strategic Perspective, 10th Edition FSAP User Guides:
By Jim Wahlen, Steve Baginski and Mark Bradshaw
The FSAP user should only enter data in the blue-font cells shaded light green.
The FSAP User Guides appear in column I to the right. The Data spreadsheet is designed for up to six years of financial statement data. The user must input the most recent year of financial statement data in column G, regardless of the number of years of data inputted.
The user must conform financial statement data to the FSAP template because the spreadsheets within FSAP use the Data spreadsheet as their base. The user can, however, rename account titles as necessary to match the account titles of the particular firm. FSAP contains a number of general purpose accounts that can be renamed to fit the accounts of the particular firm (for example, Other Cu
ent Assets (1) and (2)).
FSAP automatically computes the amounts of various sub-totals and totals within the Data spreadsheet. These items are shaded in gray and serve in checking the mathematical accuracy of inputted amounts. FSAP checks to ensure that total assets equal total liabilities and shareholders’ equity, that total revenues and gains minus total expenses and losses equal reported net income, and that cash flows from operating, investing, and financing activities equal the change in cash on the balance sheet. These financial data checks appear at the bottom of the Data spreadsheet. Any material non-zero amounts (that are not due to rounding) on these rows require the user to re-check amounts inputted to identify and co
ect the e
or.
Analyst Name: enter analysts' names Insert your name in column B.
Company Name: enter company name Enter the name of the company in Column B. This name will appear on the output of all spreadsheets within FSAP.
Year (Most recent in far right column.) 2016 2017 2018 2019 2020 2021 Throughout FSAP, enter amounts for account titles listed in
ackets
as negative numbers. Except for per share amounts, be consistent with the units of the amounts entered (for example, thosands or millions).
BALANCE SHEET DATA 2016 2017 2018 2019 2020 2021 Enter Balance Sheet Data:
Assets:
Cash and cash equivalents
Short-term investments
Accounts and notes receivable - net
Inventories
Prepaid expenses and other cu
ent assets
Other cu
ent assets (1) Other cu
ent assets (1), (2) and (3) can be renamed and used for different types of cu
ent assets for different firms.
Other cu
ent assets (2)
Other cu
ent assets (3)
Cu
ent Assets 0 0 0 0 0 0 FSAP automatically computes the amount of total cu
ent assets.
Long-term investments
Equity and cost investments
Property, plant, and equipment - at cost
Operating lease right-of-use assets
Other noncu
ent asset (1) Other noncu
ent assets (1), (2) and (3) can be renamed and used for different types of noncu
ent assets for different firms.
Other noncu
ent asset (2)
Other noncu
ent asset (3)
Total Assets 0 0 0 0 0 0 FSAP automatically computes the amount of total assets.
Liabilities and Equities:
Accounts payable
Accrued liabilities
Notes payable and short-term debt
Cu
ent maturities of long-term debt
Cu
ent operating lease liabilities
Income taxes payable
Other cu
ent liabilities (1) Other cu
ent liabilities (1) and (2) can be renamed and used for different types of cu
ent liabilities for different firms.
Other cu
ent liabilities (2)
Cu
ent Liabilities 0 0 0 0 0 0 FSAP automatically computes the amount of total cu
ent liabilities.
Long-term debt
Long-term operating lease liabilities
Defe
ed tax liabilities
Other noncu
ent liabilities (1) Other noncu
ent liabilities (1) and (2) can be renamed and used for different types of non-cu
ent liabilities for different firms.
Other noncu
ent liabilities (2)
Total Liabilities 0 0 0 0 0 0 FSAP automatically computes the amount of total liabilitries.
Prefe
ed stock
Common stock + Additional paid in capital
Retained earnings
Accum. other comprehensive income
and other equity adjustments Include on this line any treasury stock accounts and any items that do not fall within some other shareholders' equity line. Such items seldom appear in balance sheets of U.S. firms. Amounts that increase (decrease) total shareholders' equity should be entered as positive (negative) amounts.
Total Common Shareholders' Equity 0 0 0 0 0 0 FSAP automatically computes the amount of total shareholders' equity.
Noncontrolling interests
Total Equity 0 0 0 0 0 0
Total Liabilities and Equities 0 0 0 0 0 0 FSAP automatically computes the amount of total liabilities plus shareholders' equity.
INCOME STATEMENT DATA 2016 2017 2018 2019 2020 2021 Enter Income Statement Data:
Revenues When entering income statement data, enter amounts that increase income (revenues, gains, income) as positive amounts, and enter amounts that decrease income (expenses, losses) as negative amounts.
Gross Profit 0 0 0 0 0 0 FSAP automatically computes the amount of gross profit.
Add back: Imputed interest expense on operating lease obligations Compute and add back the imputed interest expense on operating lease obligations (if any), as shown in Chapter 10.
Other operating expenses (1), (2), and (3) can be renamed and used for different types of recu
ing operating expenses for different firms.
ing operating expenses> Non-recu
ing operating expenses can be renamed and used for different types of non-recu
ing expenses for different firms.
Income from equity affiliates
Wahlen, James M.: Wahlen, James M.:
Include here if reported as part of operating income.
Non-recu
ing operating gains The FSAP user must decide whether particular operating gains or losses are non-recu
ing - infrequent and unusual given the firm's business and operating environment. If so, enter the amounts on the appropriate rows. Enter expense and loss amounts as negative numbers.
Operating Income 0 0 0 0 0 0 FSAP automatically computes the amount of operating profit.
Subtract: Imputed interest expense on operating lease obligations Compute and subtract the imputed interest expense on operating lease obligations (if any), as shown in Chapter 10.
Interest and Other income Income from equity affiliates
Wahlen, James M.: Wahlen, James M.:
Include here if not reported as part of operating income.
Wahlen, James M.: Wahlen, James M.:
Include here if reported as part of operating income. Enter any amounts of income (or ) from equity or noncontrolled affiliates.
Other income or gains Enter income or gain amounts (or expense or loss amounts as negative numbers) that are unusual and non-recu
ing and outside of normal business operations.
Income before Tax 0 0 0 0 0 0 FSAP automatically computes the amount of income before tax.
Enter the amount of income tax expense that appears on the income statement in the section for income from continuing operations. If income tax expense reduces income, enter the amount as a negative number.
Income from discontinued operations Enter any amount reported in the separate section of the income statement labeled Discontinued Operations. The amount is reported net of tax effects. Enter as a positive or negative number as appropriate.
Extraordinary gains Enter any amount reported in the separate section of the income statement labeled Extraordinary Items. The amount is reported net of taxes. Enter as a positive or negative number as appropriate.
Income from changes in accounting principles Enter any amount reported in the separate section of the income statement labeled Changes in Accounting Principles. The amount is reported net of income taxes. Enter as a positive or negative number as appropriate.
Net Income 0 0 0 0 0 0 FSAP automatically computes the amount of net income using the above data for revenues, expenses, gains and losses.
Net income attributable to noncontrolling interests Enter the amount of net income attributable to noncontrolling interests. Enter amount as a negative number. If the firm reports a net loss attributable to noncontrolling interests, enter the amount as a positive number.
Net Income attributable to common shareholders 0 0 0 0 0 0
Net Income (enter reported amount as a check) Enter the amount of reported net income on this line. It will be used by FSAP to provide a mathematical check on the amounts of all revenues and expenses on preceding lines.
Other comprehensive income items This amount usually appears in the Statement of Comprehensive Income. Enter as a positive or negative number as appropriate.
Comprehensive Income 0 0 0 0 0 0 FSAP automatically computes the amount of comprehensive income.
STATEMENT OF CASH FLOWS DATA 2016 2017 2018 2019 2020 2021 Enter Statement of Cash Flows Data:
Net Income 0 0 0 0 0 0 In the Statement of Cash Flows Data, enter amounts reported on the firm's statement of cash flows. Enter amounts that increase (decrease) cash as positive (negative) numbers. The row headings help indicate whether amounts should be positive or negative.
Add back depreciation and amortization expenses FSAP automatically enters the Net Income amount computed above.
Add back stock-based compensation expense
Defe
ed income taxes
Decrease in accounts receivable
Decrease in inventories
Decrease in prepaid expenses
Decrease in other cu
ent assets
Decrease in other noncu
ent assets
Increase in accounts payable
Increase in income taxes payable
Increase in other cu
ent liabilities
Operating lease right-of-use assets and liabilities, net
Other addbacks to net income
Other operating cash flows
Net CF from Operating Activities 0 0 0 0 0 0 FSAP automatically computes the amount of cash flow from operations.
Proceeds from sales of property, plant, and equipment
Decrease in marketable securities
Investments sold
Payments for acquisitions of intangible assets
Other investing transactions
Net CF from Investing Activities 0 0 0 0 0 0 FSAP automatically computes the amount of cash flow from investing activities.
Increase in short-term bo
owing
owing
Increase in long-term bo
owing
owing
Issue of capital stock
Proceeds from stock option exercises
Other financing transactions (1)
Other financing transactions (2)
Net CF from Financing Activities 0 0 0 0 0 0 FSAP automatically computes