junowe [z(g ye ulewoy
Junowre 170g 18 urewy
TedA [ord 9SBAIOUT 9/,6°7
JedA ord 9SBIIOUT 0/,G°¢
TedA 9ed ISBAIOUI 0G’
JedA [des as8a1dul 9, |
JUNOWE [Z(Z 18 UIeWdy
unowe [70 3e ureway
JUNOWE [70 Je Urewioy
Junowe [70g Je urewoy
Te3A ord 9SBAIOUI 0G’ |
9)eI Xe) X SWO0oul payod[oid
JUNOWe [707 38 UIeloy
SONUOADI J0U JO %G' |
PIRINOIEd SY
SONUIAJI IU JO %01
SJUAISIAU] JSO)) pue
SJUAUISOAU] ULIQ -8UO]
195SY JULIN.) JOYI0) UE SasuddxH predald
S
9[QBAISOY SIUNONY
SIUSUIISIAU] WIS I -1IO0YS
$)S9I9JU] SUI[[ONUOIUON 0} S[qeInquUNy awoou] 19N
STAY] QUIOJU] QAISUSYRIAWOD) 13YI0
$9550) Sasuadx4 JoylQ 10 (Suren)) Woo] YO
awoou] 1saxau] (asuadxy) wou] JOO
sore} AInbg Woy SWOdU]
osuadxy Xe] auwodu]
sosuadxq Sunerad(Q suLLnddI-UON
sasuadxs] gunerod( IPYIO
UO11eZI}IOUTY/UOTJRI0dIA3(]
sosuadxs Joy) pue suneIadQ 2101S
SONUIAI JU JO %L SANBISIUIWPY pu. TeIoudn) ‘SUI[[dS
SONUIAI JU JO %T¢ PIOS SPOOD JO 1S0D
Br or ee
EERE Te]
IBJA [ord ASLAIOUT 9% 71+
S910)S PASUII]
so101S pajerado-Aueduwo))
-suonjdunsse Jo uoneuedxa
Ue OPN[OUI 0} PSU JOU Op NOX JOSYSPEAIdS XXXXXXXXXX,] dU} 0} IDA0ALIED A[[ed1jetoIne [[1M
100Uspea1ds juauido]adaa(J XXXXXXXXXX,] AY) JO SHNSII AY |, ‘193YSpedlds juoutdojaad(] 1Sv22.40,]
oy wr suonismboe juowdimnbe pue ued ‘A1rodoid oy) pue Juswi3as Aq SNUIASI AY) JOIUS
0] PIU [[IM NOX "193YSPedlds XXXXXXXXXX, SY) Ul G+1ed X Y3NoIy) [+Ied X JOJ SJUSWD)L)S
Teroueury s, Auedwod ay) Jo 350210] © dredard 0) suonduwnsse SUIMO[[0J SY} 3S] °q
*109yspea1ds pn UO JUNOWIR YIM SI21Fe SWOUL AISUIYAIduI0d
PUR ‘sodue[eq 99S douB[eq AY} IBY} PUL A[3091I09 JO3YSPeIds 15s022.40,] 3)
0) JOAO PALLIBD 19Yspealds nip(7 Uo PAIdUS UOIBULIOJUI JUSWID)ILR)S [RIOURBUL) JBY) AJLUIDA EB
:paainbayy
"JOJUS ddUe[eq 3) ddUL[EQq 0) JUNO0IJL SJud[eAInba yseo
pue Used dy} Ym AI[IQIXJ[J [eIOURUL) SII 9SIOIOX [[IM SYONqIe)S JBY) SQWINSSE ‘9sed pajeIsojul
a3 Jo ed sty) Jo sasodind 10,1 SMO} sed JO JUSUISIE]S AY) USY) PUB JOYS 0Ue[eq AY} USy}
“JUSUIS)R)S SWOJUL dU} YIM ZUTUUIZoq PoIudsald 19pIo oy) ul sjunowre ay XXXXXXXXXX “suondunsse
30 19s pAUAsaxd ayy BuIsn G+ JX 0) [+ Jed x 10) uonerodio)) syonqie)s JO S)SLISI0J JUSWI)B)S
Jeroueuly Jo 30s © oxedoxd 0) Jv'S oy Sulzinn 39 [1M noA ‘Osed pajerdajur ays Jo wed Sig) Jo.
y Jed - ase) pajesbajuj
uoijesodio) syongiels
"TT0T ‘p 1_DQUIIQ Aep JO pus uey) Joye] ou preogsioele 0) ony Gan eon
Jb Spnqreg Teng
ISILdWeN Jse], 91 Ino [9qe] pue (dejdurd) JVs XXXXXXXXXXpareiduiods OA dae 3
"SONjel [eIouRUL) 9) IO). [[ XXXXXXXXXXISIIJ Ul 199yspedids 1SD22.40,]
UO J9MSUR INOA 908d “SHONngielS JO JUS uel [EI0UBUL) SY) J0J 9180 PINod seo
yonui os je) swo[qord 10 wio[qoId © AJ1Iusp] “S1aSSe [230) JO 9,09 ISAO SIUSSoIdal yotym
“SHIEK JO PUD 9Y) £q UOI[[IW (00°F $ 10A0 0} [TOT JO PUS SY Je UOI[[IW / GSE LOY i
ATIpeals smoi3 ysed Jo junowre pajoafoxd ay) ‘A[ XXXXXXXXXX109yspeards nok paredosd nok jy °°
'SJUNOJIL 1993S ddue[eq IAYIO [|e 10] suonddfoid
3unedwoo 19)ye yses Junnsai ayy 303fo1d "Aynbs siopjoyoreys snyd soniiqer|
[810] YIM S19SSE [810] )enbd 0) JUNOJIL [RIOUBULY [GIX[J AY) Se Used snipe [[IM nox °P
(%s 89) 20e[d
[WIAD UO 0] JA3YSpealds juoutdojanaa(g XXXXXXXXXX, PUR JSDI2.40,] UO SOFeuadrdd jeunio “0
1G9(J UO 912 1S3I9JU] AIO] 5] STCIOAY
sresodsip
ou — 1edk 13d ori OSZ1$
auwoduI Xe}-91d JO 9,6 [7
uonysmboe juswdinbs pue Queid ‘K11odoig
SIBJA [[& IOJ) jel Xe) SWOJUI SATII
PUSPIAID %{¢
Junowe [707 je urewioy
Junowre [0g Ie urewdy
JBIA [JIB3 3SBAIIAP 9,¢€
JBIA [OB 9SBaIIAP 9%, 7
[OB 9SBIIOUI 94 |
Jord 9SBAIOUL 9, Q
Jord 9SBIIOUI 0/40
(OB 9SBIAIOUIL Oi,
oro 9SBAIOUI 9/7
junowie [70g Ie urewdy]
192d
ULR)-3U0] Jed A JONI] JO %01
junowe [ZO je urewdy
JedA [ord 3SedIoul 9/,G
JedA Jord 9SedIOUI 9G ¢
Junowe [z0g Ie urewdy
junowre [70g je uretdy
134 [O83 9SBAIOUL 0/4,
Ie3K [OB 9SedIdUl 9% ¢" |
SPUSPIAL(]
SSOT) WOU] SAISUSYIdWO)) IYI) PAIL[NWNIIY
[E31dED) UI pred [EUORIPPY + 00}§ UOWWON)
SOUIIqel] ULId)-3U07] IYI0Q
ONUIAIY POLIdJI(
SonI[Iqer] ased] JuneiadQ uLo}-Suoy
199 WI)-Suo
INUIAIY PALIDJI(J JO UOTIOJ JUALIN) 29 AI[IQRIT/AN[BA 9I0]S
S)jouag pue [[0IAed paNIddy
o[qeled Soxe] dwoou]
sonI[Iqer] osedT Junerdd( juan)
199 Wd -3UO07] JO SOLIMBJA JUSLIND)
199 UrIdl-1I0YS pue d[qeAe S9ION
SanI[Iqer] paniddy
d]qeAe S1UNOIY
$19SSY uLId}-SuoT JYI0
[cn CT poo Sl
Xe], QWOdU] paridjod
S19SSY 9S()-JO-YTTY osea] Faeedo
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 the amount of cash