- 1 (20.51 KiB) Viewed 30 times
E F G H K A B C D 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 2020 2021 2019 30,003,250 1,921,500 96,075 200,000 2,493,640 124.682 2.938,103 146,905 429 430 Linkages 431 In each of the yellow boxes below select a 't' if the account on the left links to the account across the top or a '-'if it negatively impacts. 432 Only identify direct relationships. If some account impacts another account and the other account impacts a third account, do not indicate the relationship between the first account and the third account. 433 Leave boxes for which there is no relationship between the rows and columns blank. 434 435 Common Cash PP&E Intangible Equity Flow Assets 437 Depreciation 436 438 Cash Flow Amortization 439 440 CapEx Acquisition of Intangibles 441 Net Income 442 443 Common Dividends 444
44 445 Basic Example 446 In the following example we have hypothesized that all drivers remain constant except that the company aggressively cuts prices to gain market share. 447 Develop a basic models and apply it to forecast the current year and next year results. 448 Enter formulas in the yellow cell that complete the model. . 449 The comments to the right of each row will assist you. 450 2020 2022E 2023E 2021 1,108 1,000 451 452 453 454 11% 11% 11% 20% 20% 25% 30% 200 222 11% Size of Market in Units Market Unit Growth Rate Market Share Units Sold by Company Company Unit Growth Rate Price Per Unit Sales in $ Cost Per Unit Costs in $ Gross Profit In the yellow boxes calculate the 'Size of Market in Units' We assumed that market continues to grow at last year's rate We assumed that the company gains share by aggressively cutting price In the yellow boxes calculate the "Units Sold by Company' In the yellow boxes calculate the 'Company Unit Growth Rate' ' We assumed that the company gains share by aggressively cutting price In the yellow boxes calculate the "Sales in $' We assumed that the 'Cost Per Unit' remains constant In the yellow boxes calculate the "Cost in $' In the yellow boxes calculate the 'Gross Profit' 100 100 95 90 22,160 60 60 455 456 457 458 459 460 461 462 463 464 60 60 13,296 8,864
А B C D E F G H 2020 2019 15,005,190 2021 16,543,222 15,755,450 387 388 389 Property, Plant & Equipment Derivation 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 10,000,000 500,000 525,000 501,250 614,460 100,000 506,910 714,682 5.0% 3.5% 0.0%