373 374 Property, Plant & Equipment Derivation 375 Calculate the values of the yellow cells below. 376 377 2017 15,000,433 2018 15750454.65 2019 16537977.38 10,000,681 500,000 525,000 501,250 614,460 100,000 506,910 714,682 5.0% 1.1% 28.6% 2018 2019 378 Revenues 379 380 Prior Year PP&E 381 - Depreciation 382 + Capital Expenditures (Capex) 383 - Write-down or Disposal of PP&E 384 - Current Year PP&E 385 386 Depreciation Percent of Prior PP&E 387 Capex Percent of Revenues 388 Current Year PP&E Percent of Revenues 389 390 391 Intangible Asset Derivation 392 Calculate the values of the yellow cells below. 393 394 395 Prior Year Intangible Assets 396 - Amortization 397 + Acquisitions of Intangible Assets 398 + Other Intangible Investments (Impairments) 399 = Current Year Intangible Assets 400 401 Amortization Percent of Intangibles 402 403 404 Equity Derivation 405 Calculate the values of the yellow cells below. 406 407 408 Prior Year Common Equity 409 + Net Income Attributable to Common 410 - Common Dividends (Declared) 411 + Issues (Repurchases) of Common Equity 412 Current Year Equity 413 414 2017 1,000471 100,000 120,000 100,000 10,000 (100,000) 2017 2018 2019 30,000,286 1,921,583 96,075 200,000 2,493,640 124,682 2,938,103 146,905