CLIENT: Name  
Deferred Gain Calculation
SALE DATE:  8/4/98 2005
Enter data in highlighted fields only 
                 
Sale Price 45,000.00  
   
Cost Basis 10,000.00  
    Do not change this  
Gain: 35,000.00 section after initial  
  year  
Gross Profit % = Gain / Gross Proceeds: 0.777778  
     
Cash received at closing  
   
Sale Price 45,000.00  
   
Less land contract/mortgage held back 5,000.00  
   
Cash recognized at closing 40,000.00  
   
  times gross profit % x 0.777778  
     
Recognized Gain 31,111.12  
     
Deferred Gain on Bldg: (total - recognized gain) 3,888.88  
                 
Gain recognized in prior years on installment payments if applicable 0.00
                 
Principal Payments Received on Installment Sale
   in the current year 15,000.00
  times gross profit % x 0.777778
Gain recognized in current year from
  principal payments        11,666.67
Total gain recognized to date on sale 42,777.79
 
Deferred Gain Balance -7,777.79
 

Click filename below to access file

Installment Sale Gain.xls




Business Forms Privacy Policy Also See Terms of Service.