GBER (Analysis)
Name
Correct
Step #1: Click one of the tickers below to open a Yahoo window for analysis
HD
DIS
K
WMT
COST
SBUX
GE
Step #2: In the boxes below, enter the most recent ANNUAL data from the financial statements at Yahoo that were just opened in the pop-up window.
Income Statement annual data
1.
Total Revenue
2.
Cost of Revenue
3.
Gross Profit
4.
Earnings Before Interest and Taxes
5.
Income Before Taxes
6.
Income Tax Expense
7.
Tax Rate (#6 / #5)
8.
NOPAT (EBIT x (1 - #7))
Balance Sheet annual data
(see the menu - bottom left of the Yahoo window)
9.
Total Assets [current year]
10.
Accounts Payable [current year]
11.
Other Current Liabilities [current year]
12.
Operating and Invested Capital (#9 - #10 - #11)
13.
Total Assets [prior year]
14.
Accounts Payable [prior year]
15.
Other Current Liabilities [prior year]
16.
Operating and Invested Capital (#13 - #14 - #15)
18.
Change in OIC (#12 - #16)
Calculation of Residual Income and Free Cash Flow
19.
NOPAT from (#8 above)
20.
Estimation of WACC
21.
Capital Charge (#12 x #20)
22.
Residual Income (#19 - #21)
23.
NOPAT from (#8 above)
24.
Change in OIC (#18 above)
25.
Free Cash Flow (#23 - #24)
Copyright 2011 © Gaylen K. Bunker, All rights reserved