Question
Tobin and his wife, Cynthia, both work and have a combined gross income of $90000 per year. They estimate the property taxes on their condo
Tobin and his wife, Cynthia, both work and have a combined gross income of $90000 per year. They estimate the property taxes on their condo will be $1200 and insurance would be about $1940 per year. Tobin takes the bus to work, but Cynthia has a car payment of $275 per month, and they are both still paying off student loans for a combined total of $220 per month. Use this information to answer the questions below. Express your answers rounded correctly to the nearest cent!
(i) Determine how much of a monthly mortgage Tobin and Cynthia can afford. (Use the Total Expense Ratio from your class materials.) Payment = $
(ii) If the couple can get a 15-year mortgage with a fixed rate of 7%, use Excel's PV function to determine how much house they could afford. Round your answer to the nearest $ 100. Amount to Borrow = $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started