File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri 12 AA = = = ab WAD Text 27 + Posle BU A Merge Canter $ - % 4029 La Coo Format Painter Cliphard sell Delele Turnal Sensitive Conciliora Fermal Cel Formatting Table Styles Cles Surl Fine 82 Filter Select Analyze Data F For R Alignment Nuner Styles CAR Falling Anayi Sandy C2 A B C Next Year Last Year Step 1 Grow the revenue. Assume a 13.2% growth rate, and round to the nearest ten thousand dollars. $ 440,000.00 S 216,480.00 $ 104,720.00 $ 118,800.00 $ 13,700.00 $ 105,100.00 $ 28,587.00 $ 76,513.00 S 8,646.00 $ 67,867.00 1 2 Revenue 3 COGS 4 SG&A 5 EBIT 6 Interest 7 EBT 8 Taxes 9 Net Income 10 Dividends 11 Add to RE 12 13 Cash 14 A Receivable 15 Inventory 16 Fixed Assets 17 Total Assets 18 A Payable 19 Debts 20 Common Stock 21 Retained Earnings 22 Treasury Stack 23 TA-TL&E $ 41,800.00 $ 22,000.00 $ 20,240.00 S 378,400.00 $ 462,440.00 S 13,200,00 $ 226,596.00 $ 217,475.00 S 62,611.00 S 57,442.00 Forecasting +