PLEASE FOLLOW THE FOLLOWING INSTRUCTIONS: I HAVE THE EXCEL FOR THE INCOME STATEMENT IF NEEDED
The Awesome Products Business Valuation Case Awesome is a small closely held company operating in the United States. Assume you are in the early stages of preparing a business valuation on Awesome Products to assist a potential purchaser.. Included in the case is a copy of Awesome Products, Inc. Unadjusted Income Statement and Balance Sheet and Operating Expense detail for the periods ending December 3lst; all numbers are in thousands. All questions on this case use the attached data as basis. Instructions: Complete each of the exercises. You will be graded on both content (correctness) and organization of your answers. 1. Based on the information given, prepare the normalization entries for the years 2010 - 2014. Explain your reasons for each normalization entry. 2. Using the data you created in #1, 21. Prepare normalized and common size balance sheets for each year from 2010 - 2014; and (you may want to use excel but please remember do not go too far over to the right. This makes it very difcult to print out) b. Prepare a normalized and common size income statement for each year from 2010 - 2014. (you may want to use excel but please remember do not go to far over to the right. This makes it very difcult to print out) 3. Compute the following ratios listed using the normalized data for each of the 5 years. Ratios to be calculated are: Industry Average 1. Growth Ratios 1. Sales Growth Percentage n/a 2. Earnings Growth Percentage n/a 11. Cost Control Ratios 1. Cost of Sales/Sales n/a 2. Gross Margin or Profit 41.2 3. Operating Expenses to Sales 37.4 4. Operating Margin or Profit 3.8 4. Trends: Analyze the ratios you calculated for each of the 5 years. Analyze and explain why you believe they are indicative of issues (positive or negative) to your planned valuation of Awesome Products Inc. 5. Using the normalized income statements developed above, estimate future income. State why you believe the method you selected for estimating future is the most appropriate for this company. 6. Based on the above exercises and a capitalization rate of 20%, calculate, using the interest capitalization method, the value of Awesome Products, Inc. In ormation needed or normali '01: entries You have discovered the following information after reviewing the nancial statements and other company documents, and interviewing management. 1. Net Sales During the period 2010 through 2014, the company has expanded their product line and opened new stores. This caused the increase in sales during this period. An analysis of the information shows the following: Year Number ofNew Stores Increase in Sales 201 l 1 20% 2012 2 10% 2013 0 2014 2 10% 2. Cost of Sales Products purchased from the same supplier. Different cost of sales percentages, due to different product lines. 3. Salaries and Wages Generally, the increase in salary expense was caused by hiring additional employees to work in the new stores. Included in the account, Ofcers' Compensation, is the salary of the owner, George Bigshot. His salary for the 5 year period has been: 2010 - $375,000 2011 -$400,000 2012 - $475,000 2013 -$500,000 2014 -$535,000 You have compared his salary to industry data, and the amount he receives appears to be high. His compensation appears to be 15% above the industry norm. June Bigshot is an employee and earns $35,000 per year recorded in Other Salaries & Wages. From interviews and physical observation, it does not appear that she has any responsibilities and is rarely at the business location. When Awesome opened the last 2 stores in 2014, they hired experienced managers. Each of these manager's earn $5,000 more than the managers in the other stores, this amount appears to be $3,000 above the norm in the industry. Selling Expenses This category includes numerous expense items. The Advertising and Promotion category is signicantly higher in 2014 compared to previous years. The marketing manager told you Awesome redesigned all their literature in 2014. The cost of the design work and printing costs was $550,000. Aer careful analysis, you notice that the Travel and Entertainment category has increased steadily since 2010. After asking questions, you discover personal trips that were paid for by the company. The annual amount for these trips, is as follows: 2012 = $80,259; 2013 = $120,000; and 2014 = $200,000. Other Selling Expenses, includes expenses for a condo owned by the company. The condo was acquired in 2010, and was capitalized as an investment on the Balance Sheet (see lnvestrnents below). The company has incurred $20,000 per year for the upkeep of the condo from 2010 - 2014.Also, in this category there is $23,000 in 2013 and $500,000 in 2012 related to an employee strike. The strike was settled and management does not anticipate any strikes in the future. Related to the strike the legal fees to handle the situation were $100,500 in 2013 and $80,750 in 2012. The legal fees were included in the General 8: Administrative section. iii-Cr [i 7' ' .. .. \\-.-..- T .. . .w...r '-. .1 Ls j The insurance account has increased signicantly. Most of the additional cost is due to the opening of the new stores. However, there is $10,000 per year of property insurance on the condo, and $12,500 per year of real estate taxes for the condo. The two stores opened in 2014 are in a specialty area, and the rent paid is signicantly higher than the other stores. The rent for each of these stores is $48,000 per year, and the average rent for the other stores is $30,000 per year. The use of oice supplies appears to be very inconsistent. The amount uctuates greatly from year to year, but you could not nd any reason for this. In each year, that new stores were opened, the company took the maximum deduction for Section 179 expenses of $13,500. This amount is recorded in the Depreciation Section. Under normal circumstances these assets would be depreciated over a 5 year period using straight line depreciation. 6. Investments The condominium was acquired in 2010 for $190,000. The condominium was depreciated on the straight line basis over 30 years, starting at the beginning of 2010 with the land valued at $l0,000. The balance in the Investment account was reduced accordingly, instead of showing accumulated depreciation and the depreciation expense was recorded in Other Expenses under the General 8: Administrative category. The balance in the Investment account represents stock that Mr. Bigshot trades on a regular basis. No gains or losses were incurred on these investments. 7. Dividends Dividends of$100,000 were paid in 201 1. 8. Advances from Afliates This account represents funds borrowed from another company owned by Mr. Bigshot. Awesome pays a fair rate of interest on the funds borrowed. A B D E G H I J K L M N O P R 1 Adjusted Adjusted yAdjusied Adjusted I Adjumd 1376mm Account 2010 adjust 2010 2011 adjust 2011 2012 adjun 2012 2013 adjun 2013 2014 jadjusmi 2014 2015 . Net Sales 6,269,714.00 7,523,657.00 8,276,022.00 8,689,823.00 : 9,732,602.00 . Cost of Sales 3,411,351.00 3,994,185.00 4,367,529.00 4,683,767.00 5,433,308.00 _ Gross Prot 2,858,363.00 3,529,472.00 3,908,493.00 4,006,056.00 4,299,294.00 Operating Expenses Salaries and Wages . Ofcers Compulsation 344,000.00 375,500.00 418,800.00 471,900.00 535,400.00 Retails Sales Salaries 436,000.00 553,900.00 784,901.00 817,873.00 815,849.00 I Managerial Salaries 156,743.00 188,091.00 206,901.00 217,246.00 243,315.00 > Other Salaries and Wages 47,022.00 56,428.00 62,070.00 65,173.00 72,994.00 Total 983,765.00 1,173,919.00 1,472,672.00 1,572,192.00 1,667,558.00 Selling Expenses: 12.414099, 13.994709. 14593900,. Auto 63,899.00 72,080.00 79,287.00 Jammy: 8165.00 _ . 91,834.00 98,698Q07' {15,6620} _ 109,778.00 q Telephone 40,991.00 45,768.00 49,657.00 61,557.00 68,725.00 Advem'sing & Promotion 415,138.00 431,149.00 423,592.00 425,626.00 505,984.00 Market Research 15,674.00 18,809.00 20,690.00 21,725.00 24,332.00 V Other 15,465.00 36,040.00 68,665.00 , 118,985.00 73,017.00 , Total 710319.00 795,452.00 849,341.00 935,902.00 1,007,1 12.00 General & Adminismtive: Ba] & Accounting 37,412.00 26,398.00 55,229.00 57,719.00 41,760.00 V Taxes 42,908.00 38,981.00 72,431.00 73,296.00 68,154.00 Insurance 56,554.00 68,376.00 95,789.00 106,303.00 103,989.00 ' Ofce Supplies 28,482.00 29,551.00 57,904.00 44,041.00 58,711.00 Donations 3,900.00 3,200.00 8,900.00 9,500.00 11,70(L00 , Postage & Freight 9,376.00 4,917.00 9,455.00 8,552.00 12,539.00 Rmt 7 418,515.00 491,163.00 .. 562,332.00 . ., 582,858.00 . 679,129.00 _ .7 7 Other 9,468.00 14,755.00 4,094.00 12,026.00 7,504.00 T9!!! , _ , , _ 1 ,jLlS-\"l \"1,241.10- , 16219;?" , .892.225~99_, ,, \"189.956.\
