Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. what is the monthly payment for a $800,000 mortgag

What is the monthly payment for a $800,000 mortgage for the first 119 payments that is...

60.1K

Verified Solution

Question

Finance

What is the monthly payment for a $800,000 mortgage for thefirst 119 payments that is due in 10 years, has a 25 yearamortization, at 5% interest? What is the amount of the 120thpayment?

Please use Excel and explain. Make sure that formulas are set toshow in excel sheet.

Answer & Explanation Solved by verified expert
4.4 Ratings (1030 Votes)
Mortgage Amount 800000 Interest Rate 5 per annum or 512 04167 per month Amortization Tenure 25 years or 25 x 12 300 months Repayment Tenure 10 years or 12 x 10 120    See Answer
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

Transcribed Image Text

What is the monthly payment for a $800,000 mortgage for thefirst 119 payments that is due in 10 years, has a 25 yearamortization, at 5% interest? What is the amount of the 120thpayment?Please use Excel and explain. Make sure that formulas are set toshow in excel sheet.

Other questions asked by students

Q

Since {1, 2, . . . , 6} is the set of all possible outcomes...

Advance Math
Q

Draw the Lewis structure for AsF3 Draw the Lewis dot structure. To change the symbol of...

Chemistry
Q

A car moving at a constant speed of 40m/s overtakes a stationary police car which immediately...

Advance Math
Q

A wire carrying a current is shaped in the form of a circular loop of...

Physics
Q

problem 6 10 Express your answer in terms of pi and as a decimal rounded...

Geometry
Q

Find the indefinite integral x 362 x 49 dx 0 0 C

Calculus
Q

Determine the scalar equation i e standard form of the plane with vector equation 16...

Algebra
Q

Adding Rational Expressions Simplify each expression x 2y x 3y 9x 9x2 A 3 B...

Algebra
Q

53-55 4 points each 53. Assume you have $10,000 to invest in a fund...

Accounting
Q

Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. Calculate the...

Accounting
Q

compute following ratios (last pic) its not incomplete the question...

Accounting
Q

What is the tax exempt equivalent yield on a 9% bond yield given a marginal...

Finance