Juan and his wife both work and have a combined gross income of 115000 per yr. they estimate the property taxes on their condo will be 1350 and insurance would be about 1600 yr. He has a car payment of 225 per month, and they have student loans for a combined total of 215 per month.

A) determine how much of a monthly mortgage Juan and his wife could afford. B) if the couple can get a 15 yr mortgage with a fixed rate of 6.65%, use excels pv function to determine how much house they could afford.