Ever wondered how they calculate the monthly instalments when you take out a auto- or a housing-loan? There is an easy formula in Excel (or other spreadsheet programs for that matter), to do so. Here is a little tutorial: Write principal amount, period and interest rate as shown above in three different cells. Enter formula [...]
Continue reading about How to calculate loan payments in Excel
