Main  /  Members  /  Microsoft Corp (MSFT)  /  Estimated Intrinsic Valuation - Summary

Estimated Intrinsic Valuation - Summary
Microsoft Corp (MSFT)
(Dollars and Shares in Millions, Except Per Share Amounts)

1.   Intrinsic Valuation Summary:
 
 A.   Estimated gross selling price of seller's assets at the end of first forecast year.$310,038
 B.   Estimated liabilities of the seller to be paid by the seller out of the gross selling price.(14,860)
 
 
 C.   Estimated intrinsic value of the seller's common equity at end of first forecast year.$295,178
 D.   Estimated fully diluted shares outstanding of seller at the end of first forecast year.10906
 
 
 E.   Estimated intrinsic value per fully diluted share of seller at the end of first forecast year.$27.07
 
 
2.   The Deal:
 
  A.   Gross selling price of seller's assets at the end of the first forecast year   $310,038
 
  Seller's forecast of year one operating earnings   $13,130
  Seller's forecast of year one EBITDA   $15,530
 
  Gross selling price, divided by forecasted year one operating earnings   23.61
  Gross selling price, divided by forecasted year one EBITDA   19.96
 
  B.   Total selling price of the seller's assets at the end of first forecast year
 
  Gross selling price of the seller's assets at the end of the first forecast year   $310,038
  Transaction expenses   $5,426
 
  Total selling price of the seller's assets at the end of the first forecast year   $315,464
 
  C.   Intangible assets recorded by the buyer at the end of the first forecast year
 
  Total selling price of the seller's assets at end of the first forecast year   $315,464
  Fair market value of the seller's assets at the end of the first forecast year   $67,829
 
  Intangible assets recorded by the buyer at the end of the first forecast year   $247,635
 
  Buyer's annual intangible asset amortization   $16,509
 
 
3.   Seller's Outcome:
 
  A.   Net pretax sales proceeds to the seller
 
  Gross selling price of the seller's assets at end of the first forecast year   $310,038
  Liabilities of the seller to be paid by the seller from the gross selling price   (14,860)
 
  Net pretax sales proceeds to the seller   $295,178
 
  Net worth of the seller's business at the end of the first forecast year   $56,777
 
    Net pretax sales proceeds to the seller, minus the net worth of the seller's business   $238,401
  Net pretax sales proceeds to the seller, divided by the net worth of the seller's business   5.20
 
 
4.   Buyer's Outcome:
 
  A.   Gross selling price of the buyer's assets at the end of four years of ownership   $451,352
 
  Buyer's forecast of year four operating earnings   $19,224
  Buyer's forecast of year four EBITDA   $19,624
 
  Gross selling price, divided by forecasted year four operating earnings   23.48
  Gross selling price, divided by forecasted year four EBITDA   23.00
 
  B.   Net pretax sales proceeds to the buyer's equity and subordinated debt investors
 
  Gross selling price of the buyer's assets at the end of four years of ownership   $451,352
  Liabilities of the buyer to be paid by the buyer from the gross selling price   $185,102
 
  Net pretax sales proceeds available to buyer's equity and subordinated debt investors   $266,250
 
  C.   Buyer's subordinated debt investors return on investment after four years of ownership
 
  Net sales proceeds to subordinated debt investors for equity warrants   $100,914
  Subordinated debt investors' original subordinated debt investment   $213,281
  Subordinated debt investors' fully diluted ownership interest in the buyer's sales proceeds   37.9%
  Subordinated debt investors' pretax annual rate of return   20.0%
  Subordinated debt investors' pretax annual rate of return target   20.0%
 
  D.   Buyer's equity investors' pretax return on investment after four years of ownership
 
  Net selling proceeds to equity investors   $165,336
  Equity investors' original equity investment   $94,639
  Equity investors' pretax annual rate of return   15.0%
  Equity investors' pretax annual rate of return target   15.0%