43. ***PLEASE MAKE SPREADSHEET AS REQUESTED IN QUESTION AND MAKE IT either available here or if possible email it to me please mc4055@desales.edu since I have to email an actual spreadsheet for this***PLEASE

    LO.6 Determine the realized, recognized, and postponed gain or loss and the new basis for each of the following like-kind exchanges.

    	Adjusted Basis of Old Asset	Boot Given	Fair Market Value of New Asset	Boot Received
    a.	$7,000	$ 0	$12,000	$4,000
    b.	14,000	2,000	15,000	0
    c.	3,000	7,000	8,000	500
    d.	15,000	0	29,000	0
    e.	10,000	0	11,000	1,000
    f.	17,000	0	14,000	0

    • g.

      Create a Microsoft Excel spreadsheet thatby entering the fair market value and basis of property given up and the fair market value of property receivedwill compute (1) realized gain or loss, (2) boot received, (3) boot given, (4) gain (loss) recognized, (5) gain (loss) deferred, and (6) the basis of like-kind property received. In separate tabs, the spreadsheet should apply the simplified method and the alternative method. Ignore the implications of debt and depreciation.

      Test your spreadsheet using the data in this problem.

44. LO.7 Quintins roadside vegetable stand (adjusted basis of $275,000) is destroyed by a tractor-trailer accident. He receives insurance proceeds of $240,000. Quintin immediately uses the proceeds plus additional cash of $45,000 to build another roadside vegetable stand at the same location. What are the Federal income tax consequences to Quintin?