Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Financial Accounting For Executives And MBAs

Authors: Paul Simko, James Wallace, Joseph Comprix

5th Edition

1618533665, 9781618533661

More Books

Students also viewed these Accounting questions