Question
PLEASE USE EXCEL AND SHOW WHAT TO PUT IN CELLS, and an explanation of the method solution of would be helpful. Given the conditions below,
PLEASE USE EXCEL AND SHOW WHAT TO PUT IN CELLS, and an explanation of the method solution of would be helpful.
Given the conditions below, determine which of the following options (A, B, OR C) of paying your mortgage is the most profitable over a 30 year analysis period by using excel
(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 a salary 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