Company
Deferred Gain Calculation
12/31/2007
SALE DATE:  8/4/07
Gross Proceeds From Sale: 10,000.00
Net Book Value: 5,000.00
 
Gain: 5,000.00
Gross Profit % = Gain / Gross Proceeds: 0.500000
 
Cash received at closing; 2,000.00     (All received on building; zero 
       received for Covenant)
x 0.674135
 
Recognized Gain 1,348.27
 
Deferred Gain on Bldg: (total - recognized gain) 3,651.73
Deferred Gain on Covenant: 500.00
 
    Total Deferred Gain Before payments received on note: 4,151.73
 
                 
Gain on principal payments received in 1998:
Loan:
   Balance on Building --> Capital Gain 35,000.00 28%
   Covenant  --> Ordinary Income 90,000.00 72%
 
Total 125,000.00 100%
Principal Payments received: 4271.83
Capital Gain Portion 28% 1196.11
Ordinary Income Portion 72% 3075.72
Amount to reduce Deferred Gain & recognize on I/S:
  Capital gain portion * Gross Profit % 598.06
  Total Ordinary Income Portion 3075.72
 
Total Deferred Gain  recognized: 3673.78
8/98 Deferred Gain 4,151.73
12/98 recognized deferred gain 3,673.78
 
Deferred Gain Balance at 12/31/98: 477.95
 

Click filename below to access file

Deferred Gain Calculation.xlw




Business Forms Privacy Policy Also See Terms of Service.