IRM forecasting

IRM forecasting - Forecasting (millions) Growth Rate of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Forecasting (millions) Growth Rate of Sales 5% 5% 10% Proj. Proj. Proj. 2005 2006 2007 2008 2009 2010 2011 2012 Income Statement Sales 2,078 2,350 2,730 3,055 3,014 3,165 3,323 3,655 Cost of Goods Sold 938 1,074 1,260 1,382 1,271 1,335 1,401 1,541 Gross Profit 1,140 1,276 1,470 1,673 1,743 1,830 1,922 2,114 Administrative Expenses 570 664 771 882 874 918 964 1,060 Depreciation Expense 187 208 249 290 319 319 319 319 EBIT 383 404 450 501 550 593 639 735 Interest Expense 184 195 229 242 230 389 385 380 Taxable Income 199 209 221 259 320 204 254 355 Taxes 66 69 73 85 106 67 84 117 After Tax Income 133 140 148 174 214 137 170 238 Dividends Paid 0 0 0 0 0 0 0 0 Contri. to RE 133 140 148 174 214 137 170 238 Balance Sheet Cash 53 53 133 284 457 480 504 554 A/R 409 483 564 553 585 614 645 709 Other Current Assets 92 144 125 140 169 177 186 205 Curr. Assets 554 680 822 977 1,211 1,272 1,335 1,469 GFA 4,988 5,480 6,673 6,745 7,252 7,252 7,252 7,252 Accum. Depr. 776 951 1,187 1,364 1,616 1,935 2,254 2,573 NFA 4,212 4,529 5,486 5,381 5,636 5,317 4,998 4,679 Total Assets 4,766 5,209 6,308 6,358 6,847 6,589 6,333 6,148 A/P 148 148 209 155 175 184 193 212 Taxes Payable 0 0 2 0 21 22 23 25 Accruals 267 267 327 356 369 387 407 448 ST Portion of LTD 26 63 33 36 41 41 41 41 Other Current Liab. 151 160 194 183 208 218 229 252 Curr. Liab. 592 638 765 730 814 853 893 978 LTD 2,804 3,017 3,747 3,824 3,891 3,850 3,809 3,768 CS 1 1 2 2 2 2 2 2 Capital Surplus 1,106 1,145 1,210 1,250 1,299 907 482 14 RE 263 407 584 551 840 977 1,147 1,385 4,766 5,208 6,308 6,357 6,846 6,589 6,333 6,148 Proj. Proj. Proj. Ratios
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 02/22/2011.

Page1 / 16

IRM forecasting - Forecasting (millions) Growth Rate of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online