American greetings case study solution

Case Study – American Greeting. Please follow instructions provided in the screenshot below. The assignment requires proficient understanding of finance since it is a financial analysis assignment with an excel worksheet to be completed. The assignment is for an MBA class hence thorough work is required. Use APA and an excel spreadsheet is attached for the purpose of creating a pro forma cashflow as well as the requirements described below.

Would like this assignment written following instruction below.Please complete work in 30hrs.

This spreadsheet supports STUDENT analysis of the case “American Greetings” (UVA-F-1693). This spreadsheet was prepared by Michael J. Schill, Associate Professor of Business Administration. Copyright © 2013 by the University of Virginia Darden School Foundation, Charlottesville, VA. All rights reserved. For customer service inquiries, send an e-mail to sales@dardenbusinesspublishing.com. No part of this publication may be reproduced, stored in a retrieval system, posted to the Internet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Darden School Rev. Feb. 6, 2014 Exhibit 1 AMERICAN GREETINGS American Greetings Share Price (monthly close) Dec-09 Jan-10 Feb-10 30 Mar-10 Apr-10 May-10 Jun-10 25 Jul-10 Aug-10 Sep-10 Oct-10 20 Nov-10 Dec-10 Jan-11 Feb-11 15 Mar-11 Apr-11 May-11 Jun-11 10Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 5 Dec-11 Closing Adjusted Price for American Greetings Shares $21 $17 $18 $20 $23 $22 $18 $20 $18 $18 $19 $19 $22 $21 $21 $23 $24 $23 $23 $22 $21 $18 $16 $17 $13 August-11 June-11 April-11 February-11 December-10 October-10 August-10 June-10 April-10 February-10 December-09 0 December-11 October-11 August-11 Exhibit 2 AMERICAN GREETINGS American Greetings Income Statement, December 2011 (in millions of dollars) 2008 2009 2010 2011E (Feb 2009) (Feb 2010) (Feb 2011) (Feb 2012) Total American Greetings Figures Total Revenue 1,691 Material, Labor, and Other Pruduction Costs 810 Selling, Distribution, and Marketing Expenses 619 Administrative and General Expenses 226 Goodwill and Other Intangible Asset Impairments 290 Other Operating Expenses 1 Operating Income (253) Net Interest and Other Nonoperating Expenses 22 Income Before Income Tax Expense (275) Income Tax Expense (47) Net Income (228) 1,636 713 508 276 0 0 139 18 121 39 82 1,593 682 478 261 0 3 175 19 156 69 87 1,677 743 526 258 0 (6) 157 28 129 47 82 Earnings Per Share (Basic) Dividends per Share (4.89) 0.60 2.07 0.36 2.18 0.56 2.22 0.60 By Business Unit Operating Segment Net Sales North American Social Expression Products International Social Expression Products Retail Operations AG Interactive 1,095 271 179 83 1,235 254 12 80 1,191 262 1,215 344 78 68 Operating Segment Earnings North American Social Expression Products International Social Expression Products Retail Operations AG Interactive Total Revenue by Product Category Everyday Greeting Cards Seasonal Greeting Cards Gift Packaging Other Revenue All Other Products 70 (78) (19) (162) 236 17 (35) 11 218 20 148 20 14 14 704 357 240 44 345 764 369 221 38 244 753 377 223 32 207 823 408 239 32 176 Note: Fiscal year ends February of subsequent year. Source: Company accounts; management and case writer estimates Exhibit 3 AMERICAN GREETINGS American Greetings Balance Sheet (in millions of dollars) 2009 2010 2011E (Feb 2010) (Feb 2011) (Feb 2012) Cash and Cash Equ