Please use Tmobile 10-K to complete the data in the Excel spreadsheet.
Note, that the data in the Excel table is just a template and needs to be completely replaced with data from Tmobile 10-K.
Tmobile 10-K link:
https://www.sec.gov/Archives/edgar/data/1283699/000128369918000011/tmus12312017form10-k.htm
Sales Growth 3. 00 % 3. 00 % 3. 00% 3.00 % 3. 00% 3.00% 3.00% Cost of revenue -37. 04% - 37. 04% -37. 04% - 37. 04 % - 37. 04% -37. 04% \\N m Research and development* - 12. 62% - 12. 62% - 12. 62% -12. 62% -12. 62% - 12. 62% - 12.62% - 12. 62% 4 Sales , General and administrative* - 23. 28% - 23. 28% 23. 28% 23. 28% -23. 28% 23. 28 % - 23. 28 % -23. 28% - 23. 28% 5\\ WACC 9.00% Restructuring , merger and acquisition - 1. 57 % -1. 57% - 1. 57 % - 1. 57% - 1. 57 % - 1. 57 % 6\\ TGROW Other operating expenses 1 . 04 % 1. 04 % 1. 04% 1 . 04% 1. 04% 1 . 04 % 11 . 00% Interest Expense* - 1 . 79 % - 1 . 79 % 1 . 79 % -1 . 79 % - 1 . 79 % -1 . 79 % - 1 . 79 % -1 . 79 % - 1 . 79 % Other income ( expo 0 . 87% 0 . 87% 0 . 87% 0. 87% 0 . 87% 0 . 87% 0 . 87% 9 Provision for income taxes 21. 80% 21. 80 % 21. 80% - 21 . 80% -21 . 80 % 10 Add Dept 4 . 76% 4 . 76% 4 . 76% 4 . 76% 4 . 76 % 4 . 76 % 4 . 76% 4 . 76 % 11 Add Stock Based 3. 18 % 3 . 18 % 3. 18% 3. 18% 3. 18% 3 . 18 % 3 . 18 % 3. 18% 3. 18 % 12 Cap EX - 2.01% - 2.01% - 2. 01 % - 2. 01 % - 2. 01% - 2.01% - 2. 01 % - 2. 01% 13 2018 2020 2026 2027 $48, 005 $50 , 929 anuanay $49 , 445 $52, 456 $55 , 651 $60 , 811 562, 636 564 , 515 Cost of revenue (517 , 781 ) (518 , 314 )) 1518 , 864 ) (519 , 430 ) (520, 013 )| ( 520 , 613 ) (521 , 232 ) (521 , 868 )| ( 523 , 200 ) ( 523 , 896 ) Gross profit $30 , 224 531 , 131 532, 065 533, 027 $34 , 017 535, 038 $36, 089 537 , 172 $38 , 287 $39 , 435 540, 618 ` ` D W N - D 6 0 J O VID Research and development (56, 240 ) (56 , 620 ) (57 , 023 ) (57, 234) ( 57 , 451 ) (57 , 905 ) Sales , General and administrative* ($1 1 , 177) (511 , 5 (512, 956 ) Restructuring , merger and acquisition (5756 ) $848 ) (5874 ) (5927 ) (5955 ) (5983) (51 , 013 ) Other operating expenses 5497 $514 $530 5546 Operating income $13, 511 $13 , 917 $14 , 334 $14 , 764 $15 , 207 $15 , 563 $16 , 133 $16, 617 $17 , 116 Interest Expense* (5861 ) $885 ) (5912 ) (5939 ) 15967 ) (5996) $1 , 025 ) (51 , 155 ) Other income ( expense ) 5419 5456 5470 5484 5529 5545 Income before taxes $12 , 287 $12 , 563 $13 , 434 $13 , 837 $14 , 252 $14 , 680 $15 , 120 $15 , 574 $16 , 041 $16 , 522 Provision for income taxes (52 , 843 ) (53 , 016 ) 153 , 107 ) (53 , 200 ) (53 , 296 ) (53 , 395 ) (53, 497 ) (53, 602 ) Net income* 59 , 609 59, 902 $10 , 199 $10 , 505 $10 , 821 $1 1 , 145 $11 , 480 $11 , 824 $12 , 179 $12 , 544 $12 , 920 Add Dept 52 , 286 52 , 354 52, 497 $2, 572 52, 649 $2 , 728 $2 , 895 $2, 981 Add Stock Based $1 , 526 $1 , 572 $1 , 620 $1 , 668 $1 , 718 $1 , 823 $1 , 877 $1 , 934 $2, 052 Cash From Operations $14 , 243\\ $15 , 111 $15, 564 $16 , 031 $16, 512 $17 , 007 $17 , 517 $18 , 043 33\\ Cap EX (51 , 024 ) (51, 086) (51 , 119 ) (51 , 152 ) (51 , 259 )| 34 Free Cash Flow $12 , 834 $13 , 220 $13 , 616 $14 , 025 $14 , 445 $14 , 879 $15 , 785 $16 , 258 $16 , 746 35 PV of Cash Flows $1 1 , 127 $10 , 514 59 , 935 59 , 388 $8 , 872 $8 , 383 $7 , 922 57 , 486 $215 , 606 $92 , 476 38| PV OFTV* 591 , 074 39\\ Total Value $183 , 550. 03 40 41| Per Share* $38. 08 42 43 44 CSCO Income Statement| Capital Structure| COE | COD | WACC \\\\
