If you really want the formula, it's quite complex. In response to the comments - I'm not asking for the formula but how to implement it - specifically, whether it's possible to use Excel's built-in tools to do so. For example, to calculate the APR on a $258,510 loan with 360 identical monthly payments of $1,171.92, the formula would be RATE(360,-1*1171.92,258510)*12īut how would you use RATE with a loan of the same size having with 180 payments scheduled as follows: 179 payments of 1171.92 and 1 payment of $140,374.96)? The RATE function requires all the payments to be the same amount. I'd prefer to use built-in formulas but can use VBA if that's the only way. I know how to get the APR for a schedule with identical payments, but can't figure out an irregular schedule. For example a 12 month loan with 11 payments of $100 and a final payment of $500. I'd like to setup an Excel spreadsheet to calculate the APR for a loan with an irregular payment schedule.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |