Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(1) Calculate the monthly payment for a 30 year mortgage of $100,000 at 6% interest. Solve for PMT Why is the solution negative? (2) Calculate

(1) Calculate the monthly payment for a 30 year mortgage of $100,000 at 6% interest. Solve for PMT

Why is the solution negative?

(2) Calculate the monthly payment for a 15 year mortgage of $100,000 at 6% interest. Solve for PMT

(3) Your budget allows a monthly mortgage payment of $700. How much can you borrow based on a 30 year mortgage at 6%? Solve for PV

(4) Youve just taken out the $100,000, 30 yr mortgage at 6%. When will the mortgage be paid in full assuming you add $200 to each monthly payment you make? Solve first for payment, then add $200 to this payment, input the new payment amount into PMT, then (press) solve for N.

(5) A lender offers you a $125,000, 30 year mortgage with monthly payments of $769.65. Whats the interest rate? Solve for I. Hint, be sure to enter the payment as a negative number.

(6) You have taken out a new 30 year, $100,000 mortgage at 6% interest on your home. You now learn that you will most likely move to another state in 5 years. What will the loan balance be in 5 years? Solve for PMT, then reload 60 into N, solve for FV.

(7) You are considering refinancing your homes 30 year mortgage at a lower interest rate. Your original loan amount was $85,000 and your current monthly payment is $683.93. Assuming you wish to continue paying the same monthly amount on a new 30 year mortgage, how much cash can you pull out from refinancing the current loan balance at 6% now that you have been in the home for five years? Solve for original I. Reload 60 into N. Solve for FV. Solve for the new PV under the new terms, then subtract from FV found above.

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

Valuation Workbook Step By Step Exercises And Tests To Help You Master Valuation

Authors: McKinsey & Company Inc.

7th Edition

1119611814, 978-1119611813

More Books

Students also viewed these Finance questions