Question
Can you please solve this using excel!! The New York Times posed a scenario with two individuals, Sue and Joe, who each have $1200 a
Can you please solve this using excel!!
The New York Times posed a scenario with two individuals, Sue and Joe, who each have $1200 a month to spend on housing and investing. Each takes out a mortgage for $140,000. Sue gets a 30-year mortgage at a rate of 6.625%. Joe gets a 15-year mortgage at a rate of 6.25%. Whatever money is left after the mortgage payment is invested in a mutual fund with a return of 10% annually Source: The New York Times. a) What annual interest rate, when compounded monthly, gives an effective annual rate of 10%? b) What is Sue's monthly payment? c) If Sue invests the remainder of her $1200 each month, after the payment in part (b), in a mutual fund with the interest rate in part (a), how much money will she have in the fund at the end of 30 years? d) What is Joe's monthly payment?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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