Answered step by step
Verified Expert Solution
Link Copied!

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
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)
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Fundamentals

Authors: Marlene Davies, John Aston

1st Edition

0273711733, 978-0273711735

More Books

Students also viewed these Accounting questions

Question

What general conclusions can be drawn from research on experience?

Answered: 1 week ago

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 1 week ago