Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. you take out a 25 year, $275, 000 mortgage with co

You take out a 25 year, $275, 000 mortgage with constant payments at the end of...

Free

50.1K

Verified Solution

Question

Accounting

You take out a 25 year, $275, 000 mortgage with constantpayments at the end of each month and i (12) = 6%. After 15 years,you wish to refinance the mortgage with a 10 year mortgage (alsowith constant payments at the end of each month) so that you pay$100 less each month than you originally were paying. Find themonthly nominal interest rate corresponding to this newmortgage

Answer & Explanation Solved by verified expert
3.7 Ratings (406 Votes)

Answer :

Loan present value (PV) = $275,000

Interest rate = 6% for first 15 years, compounded monthly = 6/12 = 0.50%

Loan period [NPER] = 25 years, Monthly = 25*12 = 300

Refinance the mortgage with a 10 year mortgage, so that you pay $100 less each month

To find the monthly nominal interest rate corresponding to this new mortgage we have to use PMT, PV and RATE function in excel

PV -275,000
NPER 300
Monthly interest rate 0.50%
Monthly payment $1,771.83
Remaining NPER 120
PV $159,594.74
Monthly payment $1,671.83
Monthly interest rate 0.3942%

Therefore monthly nominal interest rate corresponding to this new mortgage will be approximately 0.39%

Working

- A B
1 PV -275000
2 NPER =25*12
3 Monthly interest rate =6%/12
4 Montly payment =PMT(B3,B2,B1,0)
5 - -
6 Remaining NPER =10*12
7 PV =PV(B3,B6,-B4,0)
8 Monthly payment =B4-100
9 Montly interest rate =RATE(B6,-B8,B7,0)

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

25 All cell phone towers are experiencing technical difficulties except for the cell phone tower...

Geometry
Q

(6) Consider the function f(x, y) = 9 ? x^2 ? y^2 restricted to the domain...

Basic Math
Q

What are the physical and chemical properties of the spice cumin?

Chemistry
Q

Explain in brief the role of animal husbandry in human welfare.

Biology
Q

1. Luddism refers both to a historical movement and a social concept. What current technologies and...

Psychology
Q

Draw a mind map of Business Environments, Ethics and Strategy. (Hint: Start your mind-map with three...

General Management
Q

solid sphere is in pure rolling motion In rolling motion a body possesses translational kinetic...

Physics
Q

Find the a mean b median c mode and d midrange for the data and...

Statistics
Q

In problems 29 32 use the information given in the diagrams to find angle A...

Calculus
Q

If present value of total cash outflow is 15 000, and the present value of...

Accounting
Q

? Required information [The following information applies to the questions displayed below.] ...

Accounting
Q

Imperial Jewelers manufactures and sells a gold bracelet for $405.00. The company's accounting system says...

Accounting