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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Civil Engineering
1.2K views

Question 1 The storage - outflow relationship for a small dam is given in Table 1....

Physics
1.2K views

When an electric mixer is used to vigorously stir a bowl of room temperature water...

Geometry
1.2K views

The greenhouse pictured below can be modeled as a rectangular prism with a half cylinder...

Statistics
1.2K views

Consider the spinner LD 6 5 7 4 Part A 8 3 1 2 10...

Accounting
1.2K views

Assume that Timberline Corporation has 2020 taxable income of $268,000 for purposes of computing the...

Accounting
1.2K views

For requirement 2 round the answer to 2 decimal places. Delta Company...

Accounting
1.2K views

Please help ASAP! no work...

Accounting
1.2K views

Current Attempt in Progress Vaughn Corporation acquired a 35% interest in Tamarisk Company on...

Accounting
1.2K views

The following transactions occurred during November: Nov. 1: Sent bills to clients...

Accounting
1.2K views

Zola Company manufactures and sells one product. The following information pertains to the companys first...

Accounting
1.2K views

E6-2 In the month of June, Jose Heberts Beauty Salon gave 4,000 haircuts, shampoos, and...

Accounting
1.2K views

4. a. Yountz Company budgets sales of $870,000, fixed costs of $35,200,...