Answer in excel only
construct a cash flow table for fiscal years 2012 to 2015 and long term growth. based on income statement (table 45.2) and financial ratios (table 45.8). used bullish scenario. hints:
change in net work capital=new NWC
investment (change in fixed asset)= new fixed asset- old fixed asset
2008 Feb 2009 2009 Feb 2010) 2010 Feb 2011) 2011 Feb 2012 1593 1636 713 1691 810 619 226 47 260 1677 743 525 258 0 276 0 Total American Greetings Figures Total Revenue Material Labor and Other Production Costs Soling. Distribution and Marketing Expenses Administrative and General Expenses Goodwill and Other Intangible Asset Impaments Other Operating Expenses Operating Income Not interest and Other Nonoperating Expenses Income Before Income Tax Expense Income Tax Expense Not Income Earnings Per Share (Basic Dividends por Share 157 28 129 47 82 22 87 207 2.18 056 2.22 0.60 060 1235 1.191 1215 1095 271 179 12 80 78 68 218 By Business Unit Operating Segment Ner Sales North American Social Expression Products International Social Expression Products Rutal Operations AG Interactive Operating Segmentos North American Social Expression Products International Social Expression Products Retail Operations AG Interactive Total Revenue by Product Category Everyday Greeting Cards Seasonal Greeting Cards Gil Packaging Other Revenue Al Other Products 70 (78) 119 236 17 148 20 OS 11 764 750 704 357 240 40 345 221 823 408 230 32 176 30 207 EXHIBIT 45.81 Financial Forecast Assumptions Actual 2011 Forecast 2013 2014 2012 2015 5.3% 15% 90% 20% 9.0% 5.02 1 OR 9.0% 6.00 1.95 6.50 25% 9.0% 7.50 1.95 7.00 1.95 1.95 1.95 Bullish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Pod Asset Turnover Bearish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Fixed Asset Turnover 5.3% 0.0% 0.0% 8.OR 600 195 70% 0.0% 60% 7.00 195 0.0% 50% 7.50 1.95 5.02 1.95 6.50 1.95 2008 Feb 2009 2009 Feb 2010) 2010 Feb 2011) 2011 Feb 2012 1593 1636 713 1691 810 619 226 47 260 1677 743 525 258 0 276 0 Total American Greetings Figures Total Revenue Material Labor and Other Production Costs Soling. Distribution and Marketing Expenses Administrative and General Expenses Goodwill and Other Intangible Asset Impaments Other Operating Expenses Operating Income Not interest and Other Nonoperating Expenses Income Before Income Tax Expense Income Tax Expense Not Income Earnings Per Share (Basic Dividends por Share 157 28 129 47 82 22 87 207 2.18 056 2.22 0.60 060 1235 1.191 1215 1095 271 179 12 80 78 68 218 By Business Unit Operating Segment Ner Sales North American Social Expression Products International Social Expression Products Rutal Operations AG Interactive Operating Segmentos North American Social Expression Products International Social Expression Products Retail Operations AG Interactive Total Revenue by Product Category Everyday Greeting Cards Seasonal Greeting Cards Gil Packaging Other Revenue Al Other Products 70 (78) 119 236 17 148 20 OS 11 764 750 704 357 240 40 345 221 823 408 230 32 176 30 207 EXHIBIT 45.81 Financial Forecast Assumptions Actual 2011 Forecast 2013 2014 2012 2015 5.3% 15% 90% 20% 9.0% 5.02 1 OR 9.0% 6.00 1.95 6.50 25% 9.0% 7.50 1.95 7.00 1.95 1.95 1.95 Bullish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Pod Asset Turnover Bearish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Fixed Asset Turnover 5.3% 0.0% 0.0% 8.OR 600 195 70% 0.0% 60% 7.00 195 0.0% 50% 7.50 1.95 5.02 1.95 6.50 1.95
