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: Zin 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

Consider what happens when two people with different (or identical) love styles develop or ...

Psychology
Q

A division of the Winston Furniture Company manufactures dining tables and chairs. Each table requires 40...

Advance Math
Q

The rms value of this current as shown in figur 10 1 49 10 10...

Physics
Q

Tell whether the lines are parallel, perpendicular, or neither.Line 1: (4,1) and (3,5)Line 2: (8,6)...

Basic Math
Q

Solve by substitution f 8x7 e4x dx 8

Calculus
Q

Find the magnitude and angle with 0 0 2 for v 3 1

Algebra
Q

On July 1, 2017, Alabama Company issued 10% bonds dated July 1, 2017, with a...

Accounting
Q

A production department's output for the most recent month consisted of 10,000 units completed and...

Accounting
Q

tilly is emplyed as a yoga instructor and needs to be physically fit in order...

Accounting
Q

Riverside Incorporated makes one model of wooden canoe. Partial information for it follows: Riverside sells...

Accounting
Q

You are comparing two investment options. Option A pays five annual payments starting with $5,000...

Finance
Q

WallerWorld Foods is wants to expand into the fros business with a kale flavored fros...

Finance