Excel assignment
vk4queen
10FirmsCashFlows-Student.xlsxCash Flow Data (PEP example)
| PEP | DRI | HBI | AMZN | AAPL | CAT | F | KR | UPS | NFLX | DIS | |
| Year Ended… | 12/28/19 | ||||||||||
| Shares Outstanding | 1,389,544,618 Michael Dimond: From 10-k, front page. Not in millions. |
||||||||||
| Figures in… | Million USD | ||||||||||
| OpInc | 10,291 Michael Dimond: From Income Statement |
||||||||||
| Tax Rate (t) | 21% Michael Dimond: Computed from Income Statement |
||||||||||
| NOPAT = OpInc x (1-t) | 8,126 Michael Dimond: Computed |
||||||||||
| Dep & Amort Exp | 2,432 Michael Dimond: From Statement of Cash Flows |
||||||||||
| OCF = NOPAT + Dep & Amort | 10,558 Michael Dimond: Computed |
||||||||||
| ΔNOWC | 1,575 Michael Dimond: From Balance Sheet |
||||||||||
| ΔGFA | 3,973 Michael Dimond: From Balance Sheet & "Note 4 — Property, Plant and Equipment and Intangible Assets" |
||||||||||
| FCFF = OCF - ΔNOWC - ΔGFA | 5,010 Michael Dimond: Computed |
||||||||||
| Interest Expense, net | 935 Michael Dimond: From Income Statement |
||||||||||
| FCFF | 5,010 Michael Dimond: From above |
||||||||||
| ΔDebt | (253) Michael Dimond: From Balance Sheet |
||||||||||
| Int(1-t) | 738 Michael Dimond: Computed |
||||||||||
| PfdCF | - Michael Dimond: From Statement of Shareholders' Equity |
||||||||||
| FCFE = FCFF + ΔDebt - Int(1-t) - PfdCF | 4,019 | ||||||||||
| FCFF | 5,010 Michael Dimond: From above |
||||||||||
| Int(t) | 197 Michael Dimond: Computed |
||||||||||
| UCF = FCFF + Int(t) | 5,207 Michael Dimond: Computed |
