Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer in excel only construct a cash flow table for fiscal years 2012 to 2015 and long term growth, based on income statement (45.2) and
Answer in excel only
2008 Feb 2009 2009 Feb 2010) 2010 Feb 2011) 2011 Feb 2012 1.593 1691 810 619 226 290 1636 713 SO 276 O 1677 763 526 258 261 o 157 129 47 69 37 228 2.18 14.89 0.60 207 0.36 222 0.50 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 impairments Other Operating Expenses Operating income Net Interest and Other Nonoperating Expenses Income Before Income Tax Expense Income Tax Expense Not Income Earnings Per Share (Basic) Dividends per Share By Business Unit Operating Segment Net Sales North American Social Expression Products International Social Expression Products Rotal Operations AG Interactive Operating Segment Earnings North American Social Expression Products International Social Expression Products Retal Operations AG Interactive Total Revenue by Product Category Everyday Greeting Cards Seasonal Greeting Cards Git Packaging Other Revenue Al Other Products 1.191 1215 1.095 271 179 83 1.235 254 12 78 235 14 218 20 17 70 (78 119 (162) 11 14 750 704 357 240 764 369 221 223 239 345 244 207 176 EXHIBIT 45.8 I Financial Forecast Assumptions Forecast Actual 2011 2012 2013 2014 2015 5.3% 20% 9.0% 1.0% 9.0% 6.00 1.95 1.5% 90% 6.50 1.95 25% 90% 7.50 1.95 7.00 5.02 1.95 195 Bullish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Fixed Asset Turnover Bearish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Fixed Asset Tumover 5.3% 0.0% 8.0% 6.00 0.0% 7.0% 6.50 1.95 0.0% 60% 7.00 1.95 5.02 1.95 0.0% 5.OK 7.50 1.95 1.95 2008 Feb 2009 2009 Feb 2010) 2010 Feb 2011) 2011 Feb 2012 1.593 1691 810 619 226 290 1636 713 SO 276 O 1677 763 526 258 261 o 157 129 47 69 37 228 2.18 14.89 0.60 207 0.36 222 0.50 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 impairments Other Operating Expenses Operating income Net Interest and Other Nonoperating Expenses Income Before Income Tax Expense Income Tax Expense Not Income Earnings Per Share (Basic) Dividends per Share By Business Unit Operating Segment Net Sales North American Social Expression Products International Social Expression Products Rotal Operations AG Interactive Operating Segment Earnings North American Social Expression Products International Social Expression Products Retal Operations AG Interactive Total Revenue by Product Category Everyday Greeting Cards Seasonal Greeting Cards Git Packaging Other Revenue Al Other Products 1.191 1215 1.095 271 179 83 1.235 254 12 78 235 14 218 20 17 70 (78 119 (162) 11 14 750 704 357 240 764 369 221 223 239 345 244 207 176 EXHIBIT 45.8 I Financial Forecast Assumptions Forecast Actual 2011 2012 2013 2014 2015 5.3% 20% 9.0% 1.0% 9.0% 6.00 1.95 1.5% 90% 6.50 1.95 25% 90% 7.50 1.95 7.00 5.02 1.95 195 Bullish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Fixed Asset Turnover Bearish Scenario Revenue Growth Operating Margin Not Working Capital Turnover Fixed Asset Tumover 5.3% 0.0% 8.0% 6.00 0.0% 7.0% 6.50 1.95 0.0% 60% 7.00 1.95 5.02 1.95 0.0% 5.OK 7.50 1.95 1.95 construct a cash flow table for fiscal years 2012 to 2015 and long term growth, based on income statement (45.2) and financial ratios (table 45.8) please use oly bullish scenario)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started