Function: SUM; Formula: Add, Subtract; Cell Referencing
Some cells are merged.
Using Excel to Calculate the Recognized Gain Using Property Transaction Rules Student Work Area
Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work areas as indicated.
PROBLEM
Elijah owns an apartment building that he purchased ten years ago and currently has an outstanding mortgage. Elijah sells the building for cash plus assumption of his mortgage. He pays commissions, title transfer fees, and an attorney at closing. The following information is provided for the apartment building.
What is Elijahs recognized gain?
Selling expenses
Original purchase price $
Outstanding mortgage Amount realized
Current adjusted basis
Cash portion of sales price of building Realized Gain
Commissions paid on the sale
Title transfer fees paid on the sale
Attorney fees paid for closing on the sale
