Capital Gain Tax and Net Proceeds Worksheet by ltedprosser

VIEWS: 117 PAGES: 1

Capital Gain Tax and Net Proceeds Worksheet excellent Excel worksheet to analyze and evaluate capital gains treatment of both state and federal taxes on the sale of an income producing property. Also calculates net proceeds after tax.

More Info
									CALCULATION OF CAPITAL GAIN WORKSHEET
        Sale of Part of Holdings / Portfolio
BASIS AT CLOSING- JUNE 2, 2011 Two Properties        $   32,646,000
TEXAS ALLOCATION PER LOAN- 49.36%                    $   16,114,066
CAPITAL IMPROVEMENTS TEXAS -ADDED BASIS              $      750,000
BASIS INCLUDING CAPX                                 $   16,864,066
LESS DEPRECIATION                                    $     (430,000)
CURRENT BASIS                                        $   16,434,066

               SALE                                  $   24,000,000
               1% COMMISSION                         $     (240,000)
               CLOSING FEES / TITLE INSURANCE        $     (125,000)
ADJUSTED BASIS -TIME OF SALE//LESS SALES COST        $   23,635,000
LESS CURRENT BASIS                                   $   16,016,742
 AMOUNT SUBJECT TO CAPITAL GAINS TAX OF 23.25%       $    7,618,258
 TAX ON GAIN (23.25%)                                $    1,77
								
To top