Home load amount: $250,000 Down Payment: 20% Loan Term: 30 years Interest Rate: 4.5% Loan Fees: $1500
Online calculator returns the following: ( https://www.calculator.net/apr- calculator.html ) Real ARP: 4.564% Down Payment: $50,000 Monthly Pay: $1,013.37 Total of 360 Payments:$364.813.42
如果不用这个online calculator, how to write a formula to calculator ARP in order to get the 4.564%
Home load amount: $250,000
Down Payment: 20%
Loan Term: 30 years
Interest Rate: 4.5%
Loan Fees: $1500
Online calculator returns the following: ( https://www.calculator.net/apr-
calculator.html )
Real ARP: 4.564%
Down Payment: $50,000
Monthly Pay: $1,013.37
Total of 360 Payments:$364.813.42
如果不用这个online calculator, how to write a formula to calculator ARP in
order to get the 4.564%
感谢回复！！
excel有公式吧
200000-1500=1013*(1-(1+APR/12)^-360)/APR*12
1013.37*(1-(1+0.04564/12)^-360)*12/0.04564+1500=200,0007.3