So, basically, I need to create a loan calculator in the Excel and one of the points is insurance bonus, it's also paid monthly, but I don't know the formula? I only know that it depends on the age and the remaining amount of loan. How to calculate it in Excel knowing that the payment will be done monthly so that means that the age changes when it's passed 12 months, and I have no idea how to change it as well. Can someone please help?
Asked
Active
Viewed 31 times
0
-
How is this related to mathematics? – copper.hat Oct 20 '19 at 17:08
-
@copper.hat It is related to actuarial science, so I assumed it must have some relation to mathematics? – user Oct 20 '19 at 17:16
-
Maybe try https://money.stackexchange.com/? – copper.hat Oct 20 '19 at 17:18