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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!