forecast.xlsx - Excel X X14 ZIt Times New Roma * 12 ~ A A = = AY O V BIU YA E = $ - % " .00 7.0 X A34 X fx Debt A B C D E F G H K L M N O P Q R 18 Operating profit 48,107 60,773 82,228 92,769 88,000 103,660 129,575 136,054 142,857 149,999 19 20 Interest expense 48 18 50 92 150 10,689 15.553 13,135 10,468 7,536 21 Pretax profit 48,059 60,755 82,178 92,677 87,850 92,971 114,023 122,919 132,388 142,464 22 Tax 17,629 22,175 29.995 33,827 31,500 33,336 40,885 44,075 47,470 51,083 23 Net income 30.430 38,580 52,183 58,850 56,350 59,635 73,138 78,844 84,918 91,381 24 25 26 Current assets 72,052 84,613 102,774 127,618 150,000 175,744 219,680 230,664 242,197 254,307 27 Property, plant, and equipment 146,362 201,725 268,809 345,977 430,000 543,415 679,269 713,232 748,894 786,339 28 Goodwill and other assets 38,421 38,334 66,084 69,014 110,000 125,179 156,473 164,297 172,512 181,137 29 Total assets 256,835 324,672 437,667 542,609 690.000 844,338 1,055,422 1,108,193 1,163,603 1,221,783 30 31 Current liabilities 45,643 55,705 86,865 109,610 130,000 166,283 207,853 218,246 229,158 240,616 32 Deferred rent and other liabilities 13,616 27,604 33,824 35,333 45,000 61,256 76,570 80,398 84,418 88,639 33 Total liabilities 59.259 83,309 120,689 144,943 175,000 227,539 284,423 298,645 313,577 329,256 34 Debt 60,984 178,148 259,210 218,915 174,474 125,595 35 Equity 197,576 241,363 316,978 397,666 454,016 438,651 511,789 590,633 675,552 766,933 Split: 36 Total liabilities and equity 256,835 324,672 437,667 542,609 690,000 844,338 1,055,422 1,108,193 1,163,603 1,221,783 37 38 Worksheet + 7136: 169554.3309 itx: 7