Create a loan amortization schedule for the first five years of the 30 year mortgage from the first tab.
Calculate the net proceeds from the sale of the house.
Use the Sales Price from tab #1.
Loan Amortization							Sale of Property after 5 years
PV	0						Selling price (from #1)		$0
I	0.00%						Mortgage balance
NPER	0						after 5 years (60 mo)		$ -
PMT		Calculate the payment
FV	0						Profit from house		$0.00
							Selling costs		$0.00
Month	Beg Bal	Payment	Interest	Principal	End Bal
1	$ -						Net Proceeds		$0.00