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

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

Get Answers to Unlimited Questions

Membership Benefits:

Transcribed Image Text

Other questions asked by students

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

Get Answers to Unlimited Questions

Membership Benefits:

Transcribed Image Text

Other questions asked by students

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.