Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • Last Modified:

How to calculate “Monthly Mortgage Payment Per $1,000” for Fixed 20 yr Mortgage for 0 Points

How to calculate the  “Monthly Payment Per $1,000” for the Fixed Rate Mortgage for 0 points for 20 year mortgages for loan amounts of $200,000.

Thanks
0
KavyaVS
Asked:
KavyaVS
4 Solutions
 
mds-cosCommented:
These templates contain all of the formulas you require for various mortgage calculation scenarios.

http://office.microsoft.com/en-us/templates/mortgage-amortization-schedule-TC001056620.aspx

http://www.vertex42.com/Calculators/mortgage-calculators.html
0
 
Seaton007Commented:
0
 
awking00Commented:
What is the interest rate?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
KavyaVSAuthor Commented:
Interest rate 4.000%
0
 
mds-cosCommented:
OK, so if the formulas are not working for you, here is the actual math

P = payment, L = dollars over a term of n months at a monthly interest rate of c. [For 4%, c is .04/12 or .00333333333333].


P = L[c(1 + c)n]/[(1 + c)n - 1]
0
 
KavyaVSAuthor Commented:
Thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now