Description of this paper

Need help with this question Magnusson Electr...




Need help with this question Magnusson Electrics had been a distributor of electrical goods for almost 70 years, supplying various industries including the auto industry in Michigan. The Magnusson family had run the business for 70 years, beginning with the founder Mike ?Electric? Magnusson an MIT engineer and pioneering entrepreneur. For various reasons including family feuding, foreign competition, and poor management not modernizing its distribution and logistics methods the firm lost its edge and the quality of its products and services became uncertain. It gradually became unprofitable, started to have cash flow problems, and by 2011, the firm was forced to declare bankruptcy. The firm had five distribution facilities but the EPA declared one of its facilities to be contaminated. Forced to pay a large amount of money into a clean up fund the company had to face reality that it was no longer capable of operating without fresh infusions of capital and management. The Magnusson family hired a search firm to find a buyer for the firm and after a six month search a potential buyer materialized. The firm of Fairfield General Holdings (FGH), a holding company in the distribution and logistics industry asked to see Magnusson?s balance sheet. MAGNUSSON?S CURRENT FINANCIAL CONDITION Here are the current book and market values of Magnusson?s assets and liabilities. The only assets of interest to buyers are its tangible (physical assets) which are listed below. The value of the contaminated facility and the land it was built on is zero and it is not included in the assets below. There is no cash or accounts receivable because these were used by the bankruptcy court to pay off part of the claims of Magnusson?s creditors (mostly taxes, employee wages and pension arrears, and some suppliers). Against these assets are the claims of suppliers and a bank loan used to finance a portion of the inventory. FGH hired a valuation consultant for Magnusson?s tangible assets and liabilities. Here are the consultant?s conclusions. Assets & Liabilities Current estimated Market Value Inventory 1,000,000 Equipment 850,000 Buildings 2,100,000 Land 400,000 Total assets 4,350,000 Accounts payable 375,000 Notes payable 1,200,000 Net assets 2,775,000 FGH?s business analysts calculated a value of $$3,025,000 for Magnusson?s net assets including $250,000 of goodwill and accordingly, on June 1st, 2011 FGH made an offer which was accepted. page 1 of 6 Summer 2012 GWU MBAD 6211.DE Case: FAIRFIELD-MAGNUSSON CORPORATION FGH?S BUSINESS PLAN FGH?s plan is to inject cash and business expertise into the firm: upgrading buildings, using robots in its facilities, outsourcing the transportation function to a specialist transportation company, seek a larger number of products to distribute both in the USA and abroad, and introducing modern methods of distribution and supplier management. FGH estimates that after all the upgrades are completed, the firm will have total assets of $12,000,000, that it will be able to carry 10 times the inventory it carries at present, and be able to achieve inventory turnover ratios of 6 at gross profit margins of 50%. So average inventory carried cost can be estimated as $1,000,000 x 10 = $10,000,000. Future annual cost of goods sold can be estimated as $1,000,000 x 10 x 6 = $60,000,000 and the future annual sales can be calculated as $1,000,000 x 10 x 6 x 2 = $120,000,000. An estimated NPM of 10% results in projected net income of $12,000,000. page 2 of 6 Summer 2012 GWU MBAD 6211.DE Case: FAIRFIELD-MAGNUSSON CORPORATION CREATION OF FAIRFIELD-MAGNUSSON To implement its business plan, FGH created a corporation - Fairfield-Magnusson - to act as the operating company. F-M issued 1,000,000 shares of $0.01 par all of which were purchased by Fairfield General Holdings paying FM $3,000,000 for those shares. On July 1st, 2011, F-M borrowed $8,000,000 on a 10 year 3% note with interest payable every six months and the face value due at the end of the 10 years. It then paid cash of $3,025,000 for all of Magnusson?s physical assets and debts and began the upgrade process. During this initial startup period, F-M also renegotiated the rate on the 6% 3 year $1,200,000 loan down to 4% and extended its term to 4 years with interest and principal payable in 4 year-end equal payments). Fairfield-Magnusson?s balance sheet as of September 1st, at the end of loan negotiations and the upgrades of its facilities and the implementation of the new inventory policy is shown below. Assume that both the loans began as of Sept 1st [so no interest needs to be calculated during the startup period from June 1st to Sep 1st]. Balance sheet items Book Value prior to Commencing Operations Cash 6,375,000 Accounts receivable 0 Inventory 0 Equipment 2,550,000 Buildings 3,000,000 Land 450,000 Total assets 12,375,000 Accounts payable 375,000 Notes payable (details below) 9,000,000 $0.01 par value Common stock (1M shares) 10,000 APIC 2,990,000 Total liabilities+equity Loans 12,375,000 Amount borrowed Notes payable 1 (4 year 4% equal annual payments) 1,000,000 Notes payable 2 (10 year 6% semi-annual payment of interest, principal repayment at end of term) 8,000,000 page 3 of 6 Summer 2012 GWU MBAD 6211.DE Case: FAIRFIELD-MAGNUSSON CORPORATION Fairfield-Magnusson?s Operations for the rest of the year. More favorable property tax rates were negotiated with the townships in which the three remaining facilities were located and the employees agreed to a slight wage reduction and a three year freeze. On Sept 1st, 2011 the firm reopened for business as Fairfield-Magnusson. Here are the summary transactions for the remaining 4 months of the year. Transaction list 1. The firm paid off all existing accounts payable to the suppliers as per the bankruptcy agreement. 2. It paid $130,000 on two day vacation for its most important suppliers. 3. To consolidate its initial operations and reduce operating costs, F-M closed two of its four distribution facilities. It sold one facility valued on the books for $540,000 cash and moth-balled another. The book values of the land, equipment, and buildings of the facility that was sold were $10,000, $200,000, and $350,000 respectively. 4. To announce its rebirth as Fairfield-Magnusson, the firm spent $100,000 contacting former customers and letting them know of its comeback and soliciting their business. 5. Gross purchases of inventory totaled $11,230,000. Purchase returns were $25,000. The firm was conscientious about taking cash payment discounts and took $120,845 in cash discounts. At year-end the firm had remaining accounts payable of $1,480,000. Transportation-in costs, all paid in cash, were $130,000 [hint: you can calculate cash paid to suppliers for inventory purchases from this information.] 6. All sales are on credit. Sold inventory for $18,500,000 at a gross profit margin of 50%. The firm uses average costing for inventory and keeps perpetual records but instead of keeping track of each item?s cost, the firm records cost of goods sold of 50% of revenues for each sale. Thus, the cost of goods recorded for each sale during the year is an estimated amount, not the actual cost of the individual item sold. This saves the firm the cost of keeping detailed records but also permits it to create periodic interim reports. At the end of the year, a physical inventory count is taken and the inventory valued. The inventory account is then written down or up (with the cost of goods sold being the other journal entry line) so that the inventory account?s year-end balance matches the count and valuation of the actual physical inventory. 7. Sales returns for the period were $250,000 and total cash discounts given were $300,060. 8. The firm paid $165,000 for electricity, telephone, and other administrative and office expenses. 9. Paid $1,839,750 for salaries and wages of general operations and administration together with all the payroll taxes (FICA) and various other payroll related costs. 10.Advertising and other selling costs of $600,000 were incurred and paid during the period. Salaries, wages, and other payroll costs for the sales function was $1,010,250. 11. Paid transportation-out costs for the period were $750,000. 12.The uncollected accounts receivable at the end of the year was $2,325,000. [hint: you can now calculate the cash collected from accounts receivable with this information.] 13.The firm purchased insurance and prepaid some other expenses to the amount of $230,000. page 4 of 6 Summer 2012 GWU MBAD 6211.DE Case: FAIRFIELD-MAGNUSSON CORPORATION 14. Total of property taxes assessed by all jurisdictions where facilities are located is $32,000 of which $2,000 remained to be paid at year-end. 15.The firm collected a $15,000 surety deposit for a special order for submersible electrical motors. 16. The corporate income tax rate is 35%. Information collected for making adjusting entries After looking through the books and various financial records the controller has collected the following information for making adjusting entries. 1. The percentage of ending receivables estimated to be uncollectible is 1%. 2. The valuation of the physical inventory found that the ending inventory balance needed to be $1,450,500. 3. Payroll expenses incurred but not paid as of Dec 31st. was $50,000. This amount is not included in the $1,839,750 amount mentioned in paragraph 9 in the transactions listing. 4. Fulfilled $10,000 of the special order for submersible motors described in paragraph 15 in the transactions listing. 5. The firm uses straight line depreciation. The cost of the original Magnusson equipment ($850,000) is estimated as having an useful life of 5 years and salvage value of zero. Newer equipment purchased by F-M ($2,550,000 - 850,000) is being depreciated over various lifetimes given below. Type Information technology Robots & other warehouse technology Transportation equipment Cost Estimated useful life Salvage Value $360,000 3 years 0 1,220,000 8 years 100,000 120,000 10 years 10,000 6. The cost of the original Magnusson Buildings ($2,100,000) is to be depreciated over 25 years with a salvage value of $100,000. The various improvements made by F-M ($900,000) are being depreciated over 15 years with a salvage value of zero. 7. At the end of the year, the firm had used $63,525 of the $230,000 prepaid for insurance and other expenses. page 5 of 6 Summer 2012 GWU MBAD 6211.DE Case: FAIRFIELD-MAGNUSSON CORPORATION Required (a) Present the year-end financial statements - the balance sheet, the income statement, the statement of changes in equity and the cash flow statement. On the income statement be sure to separate cost of goods sold, general and administrative expenses, selling expenses, financial revenues or expenses, and incidental gains and losses (from selling of equipment for example). In other words, your income statement should look like this: Revenue $ 100 less: cost of goods sold 40 gross profit 60 General and Admin exp -10 Selling expenses -20 income from operations 30 Financial revenues & expenses -5 Incidental gains and losses 3 << incidental gain Income before taxes 28 Provision for income tax 9.8 Net income 18.2 Round off all numbers to the nearest dollar - so no decimal points in your financial statements. (b) If you are the bank loan officer in charge of Fairfield-Magnussion?s loans what characteristics and measures would you use to evaluate F-M? Present a short (3-4 paragraphs) discussion of your conclusions. In your discussion, suggest what might be the maximum amount of unsecured long-term (5 years or more) loan you would recommend that the bank lend? (c) If you are Fairfield General Holdings? business analyst what characteristics of F-M would you measure and what conclusions would you draw? Present a short discussion (max 1 page) of your conclusions and recommendations. (d) If you are F-M?s CEO - write a short report (max 1 page) as to what would you present to your only shareholder (FGH) regarding whether F-M is on track to achieve FGH?s business plan. In particular, discuss F-M?s cash flows and whether operating cash flow can be used be for future expansion. page 6 of 6


Paper#8355 | Written in 18-Jul-2015

Price : $25