Excel Examples

Depreciation=Input on this sheet = Calculation
($000s)

1.



blunt PP&E
HistoricModel
2008200920102011201220132014201520162017201820192020202120222023
sodding(a) PP&E male child100,000 110,000 121,500 134,725 149,934 167,424 187,537 210,668 232,268 257,858 288,037 323,493 370,017 423,519 485,047 555,804
Maintenance capital expenditures2,500 2,875 3,306 3,802 4,373 5,028 5,783 6,650 7,648 8,795 10,114 11,631 13,376 15,382 17,689 20,343
Growth capital expenditures7,500 8,625 9,919 11,407 13,118 15,085 17,348 19,950 22,943 26,384 30,342 34,893 40,127 46,146 53,068 61,028
Gross disk value of dispositions(5,000)(5,000)(5,000)(5,000)
Gross PP&E EOY110,000 121,500 134,725 149,934 167,424 187,537 210,668 232,268 257,858 288,037 323,493 370,017 423,519 485,047 555,804 637,175

2. Net PP&E
Gross PP&E EOY110,000 121,500 134,725 149,934 167,424 187,537 210,668 232,268 257,858 288,037 323,493 370,017 423,519 485,047 555,804 637,175
Less accum. Dep. EOY, historic(50,000)(63,500)(77,500)
Less accum. Dep. EOY, model(93,742)(112,170)(133,112)(156,945)(179,604)...If you requisite to get a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper