Question
PLEASE USE EXCEL and SHOW what to put in cells and a solution method explanation would be appreciated. Given the conditions below, determine which of
PLEASE USE EXCEL and SHOW what to put in cells and a solution method explanation would be appreciated.
Given the conditions below, determine which of the following options of paying your mortgage is the most profitable over a 30 year analysis period:(a) Pay off mortgage according to the original schedule (b) Increase each total monthly mortgage payment to 120% of the original scheduled payment (c) Double the monthly mortgage payment
-you have asalary of 50,000$ a year with an annual 4% pay raise.(You are placed in the 20% tax bracket)
-You have a 30 year 7% mortgage with an original balance of 150,000.(You make monthly payments)
-Each month you pay 250$ into a reserve account in which the bank uses to pay your home and property taxes.
-Your total monthly expenses are 650$ and you expect it to rise by 4% annually.
-In the next three years, you are going to attend graduate school for two years costing you 25,000$ annually. Your company reimbursed you for 10,000$ a year.You decide to set up a graduate school fund account with a bank offering you a 4% interest rate.
- each month, you put the following percentages of whatever is left of your monthly income (after all your expenses have been covered): 4.1) 30% into the graduate school fund account (this account pays back 4% interest) 4.2) 40% into a 6% retirement funds account, 4.3) 30% into a 2% emergency savings account.
-You are faced with the challenge of figuring out how best to pay off your mortgage.
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