Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Essentials Of Finance And Accounting For Nonfinancial Managers

Authors: Edward Fields

3rd Edition

0814436943, 9780814436943

More Books

Students also viewed these Accounting questions

Question

6.66 Find zo such that P(-zo

Answered: 1 week ago