2020 2018 15,000,000 2019 15,750,000 16,537,500 10,000,000 500,000 525,000 501,250 614,460 100,000 506,910 714,682 5.0% 3.5% 0.0% 2019 2020 390 Calculate the values of the yellow cells below. 391 392 393 Revenues 394 395 Prior Year PP&E 396 - Depreciation 397 + Capital Expenditures (Capex) 398 - Write-down or Disposal of PP&E 399 = Current Year PP&E 400 401 Depreciation Percent of Prior PP&E 402 Current Year Capex Percent of Revenues 403 Current Year PP&E Percent of Revenues 404 405 406 Intangible Asset Derivation 407 Calculate the values of the yellow cells below. 408 409 410 Prior Year Intangible Assets 411 - Amortization 412 + Acquisitions of Intangible Assets 413 + Other Intangible Investments (Impairments) 414 = Current Year Intangible Assets 415 416 Amortization Percent of Prior Intangibles 417 418 419 Equity Derivation 420 Calculate the values of the yellow cells below. 421 422 423 Prior Year Common Equity 424 + Net Income Attributable to Common 425 - Common Dividends (Declared) 426 + Issues (Repurchases) of Common Equity 427 = Current Year Equity 428 429 2018 1,000,000 100,000 120,000 100,000 10,000 (100,000) 2019 2020 2018 30,000,000 1,921,500 96,075 200,000 2,493,640 124,682 2,938, 103 146,905