Mortgage APR Calculator using Microsoft Excel 2013 - Microsoft Community

hello, trying create excel spreadsheet template of mortgage apr calculator. 

i have data entry fields (entered user) that produce apr % automatically based on loan scenario.

i have tried using person's example: https://www.techwalla.com/articles/how-to-use-excel-to-calculate-apr , not getting desired result. 

i tried person's apr spreadsheet model well: http://vindeep.com/models/aprmodel.aspx

here example:

• loan term: 180 months
• loan amount: $50,000
• interest rate: 6.150% (based on 360 days per year)
• monthly p&i payment: $425.99
• apr closing costs: $554.00
• expected apr result: 6.324%

any appreciated. thanks!

calculated effect function of excel

=effect(6.15%,12)
=6.324%

effect syntax =effect(annual interest rate, number of compounding periods in year)

1 of examples many other information redundant.

Office / Excel / Windows other / Office 2013