+0  
 
0
157
2
avatar

153000(.04/12)/[1-(1+.04/12)-12(15)]

Guest Oct 12, 2017
 #1
avatar
0

153000(.04/12)/[1-(1+.04/12)-12(15)]

This the TVM formula to calculate the monthly payment required to save $153,000 over a period of 15 years in the future. However, you have made a small mistake in writing it. It should be written like this:

 

$153,000*(0.04/12) / [1 -(1+0.04/12)^(-12*15)]

$153,000*(0.0033333) / [1 - (1.0033333)^(-180)]

$510 / [0.45063721031272090137130624075444]

=$1,131.72 - The monthly payment required to save $153,000 in the future.

Guest Oct 12, 2017
 #2
avatar
0

P.S. The Guest is correct in adjusting the formula and the result he/she obtained. However, the interpretation is wrong!. This formula calculates the monthly payment on a loan of $153,000 @4% compounded monthly over a period of 15 years, or 180 months.

Guest Oct 12, 2017

20 Online Users

avatar

New Privacy Policy

We use cookies to personalise content and advertisements and to analyse access to our website. Furthermore, our partners for online advertising receive information about your use of our website.
For more information: our cookie policy and privacy policy.