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 31st; all numbers are in thousands. All questions on this case use the attached data as basis. Instructions: Complete each of the exercises. 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, a. Prepare normalized and common size balance sheets for each year from 2010 - 2014 b. Prepare a normalized and common size income statement for each year from 2010 - 2014. Information needed for normalization entries You have discovered the following information after reviewing the financial 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 of New Stores Increase in Sales 2011 1 20% 2012 2 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, Officers' 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. 4. Selling Expenses This category includes numerous expense items. The Advertising and Promotion category is significantly 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. After 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 Investments 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 & Administrative section. 5. General & Administrative The insurance account has increased significantly. 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 significantly 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 office supplies appears to be very inconsistent. The amount fluctuates greatly from year to year, but you could not find any reason for this. In each year, that new stores were opened, the company took the maximum deduction for Section 179 expenses of $18,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 $10,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 & 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 2011. 8. Advances from Affiliates This account represents funds borrowed from another company owned by Mr. Bigshot. Awesome pays a fair rate of interest on the funds borrow Awesome Products ii' 0.1 SCHEDULE 1 Preparer's Name Awesome Products Unadjusted Balance Sheets '' (UNAUDITED & ALL NUMBERS IN THOUSANDS) 12/31/14 12/31/2013 12/31/2012 12/31/2011 12/31/2010 12/31/2014 12/31/13 12/31/12 12/31/11 12/31/10 Percentage of ASSETS Total Assets Current Assets : Cash $ 97,326 86,898 86,898 75,237 62,697 2.74 3.09% 3.28% 4.21% 3.71% Accounts Receivable-Trade 191,952 161,327 128,641 132832 153,497 5.39 5.74% 5.10% 7.43% 9.09% ,, Rec.-Related Companies 1,446 6,046 12,070 6,691 5,890 0.04 0.22% 0.48% 0.37% 0.35% Inventory 1210965 977,301 748,316 541,703 467,094 34.02 34.79% 29.65% 30.28% 27.66% ,', Prepaid Expenses 63,303 58,088 62,313 60,476 60,635 1.78 2.07% 2.47% 3.38% 3.59% Other Current Assets 48,023 41,873 4,296 23,458 1.35 1.49% 0.17% 0.00% 1.39% Total Current Assets 1613015 1,331,533 1,038,396 816939 773,271 45.32 47.4 41.15 47.64 47.79 Property, Plant and Equip ., Furniture and Fixtures 1,304,204 1,067,507 948,317 580,770 464,556 36.64% 38.00% 37.58% 32.47% 27.51% Leasehold Improvements 1,636,779 1,214,225 1,158,183 883,539 762,516 45.99% 43.22% 45.90% 49.39% 45.15% Transportation Equipment 35,471 21,594 34,164 36,566 31,727 1.00% 0.77% 1.35% 2.04% 1.88% Total 2,976,454 2,303,326 2,140,664 1,500,875 1,258,799 83.63% 81.99% 84.83% 83.90% 74.54% Less: Accumulated Depreciation (1,134,534) (928,544) (756,934) (648,670) (460,714) -31.88% -33.05% -30.00% -36.26% -27.28% Net Fixed Assets 1,841,920 1,374,782 1,383,730 852,205 798,085 51.75% 48.94% 54.83% 47.64% 47.26% Other Assets : Cash Value-Life Insurance 14,188 7,018 1,412 13,926 6,750 0.40% 0.25% 0.06% 0.78% 0.40% Investments 90,049 95,849 99,942 105,695 110,673 2.53% 3.41% 3.96% 5.91% 6.55% Total Other Assets 104,237 102,867 101,354 119,621 117,423 2.93% 3.66% 4.02% 6.69% 6.95% Total Assets $ 3,559,172 $ 2,809,182 $ 2,523,480 $ 1,788,765 $ 1,688,779 100.00% 100.00% 100.00% 100.00% 100.00% LIABILITIES & EQUITY Current Liabilities: Current Portion - LT Debt $ 52,307 $ 41,089 $ 57,690 $ 30,743 $ 30,820 1.46% 1.46% 2.28% 1.71% 1.83% Accounts Payable 603,544 399,226 386,869 219,610 305,501 16.96% 14.21% 15.33% 12.28% 18.09% 1 Due Bills & Gift Certificates 21,357 19,581 23,902 29,782 43,667 0.60% 0.70% 0.95% 1.66% 2.59% Advances From Affiliates 199,419 138,406 208,668 147,350 64,562 5.60% 4.93% 8.27% 8.24% 3.82% Accrued Salaries 137,577 160,897 128,474 120,023 198,431 3.87% 5.73% 5.09% 6.71% 11.75% ' Income Taxes Payable 110,227 98,713 66,111 43,784 52,087 3.10% 3.51% 2.62% 2.45% 3.08% Total Current Liabilities 1,124,431 857,912 871,714 591,292 695,068 31.59% 30.54% 34.54% 33.05% 41.16% Long Term Liabilities: LT Debt (Net-Current Portion) 613,486 379,320 331,741 183,217 289,457 17.24% 13.50% 13.15% 10.24% 17.14% Total LT Liabilities 613,486 379,320 331,741 183,217 289,457 17.24% 13.50% 13.15% 10.24% 17.14% Total Liabilities 1,737,917 1,237,232 1,203,455 774,509 984,525 48.83% 44.04% 47.69% 43.29% 58.30% Stockholders' Equity: Common Stock 10,000 10,000 10,000 10,000 10,000 0.28% 0.36% 0.40% 0.56% 0.59% Additional Paid-In Capital 14,976 14,976 14,976 14,976 14,976 0.42% 0.53% 0.59% 0.84% 0.89% Retained Earnings 1,796,279 1,546,974 1,295,049 989,280 679,278 50.47% 55.07% 51.32% 55.31% 40.22% Total Shareholders' Equity 1,821,255 1,571,950 1,320,025 1,014,256 704,254 51.17% 55.96% 52.31% 56.71% 41.70% Total Liab & Shareholders' Equity $ 3,559,172 $ 2,809,182 $ 2,523,480 $ 1,788,765 $ 1,688,779 100.00% 100.00% 100.00% 100.00% 100.00% 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. # of store . increase sales 2011 1 20% 2012 2 10% 2013 0 0 2014 2 10%