| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | The "rate" and "nper" must have the same units. |
| | | Payment periods are numbered beginning with 1. |
| | | If "rate" <= 0, then #NUM! is returned. |
| | | If "nper" is not an integer, it is truncated. |
| | | If "nper" <= 0, then #NUM! is returned. |
| | | If "pv" <= 0, then #NUM! is returned. |
| | | If "start_period" is not an integer, it is truncated. |
| | | If "start_period" < 1, then #NUM! is returned. |
| | | If "end_period" is not an integer, it is truncated. |
| | | If "end_period" < 1, then #NUM! is returned. |
| | | If "start_period" > "end_period", then #NUM! is returned. |
| | | If "type" is not an integer, it is truncated. |
| | | If "type" is any number other than 0 or 1, then #NUM! is returned. |
| | | Example 1 - How much of a £200,000 mortgage, which is repayable over 15 years at 5.7%, will be paid towards the interest in the first year. |
| | | Example 2 - How much of a £200,000 mortgage, which is repayable over 15 years at 5.7%, will be paid towards the interest in the second year. |
| | | Example 3 - How much of a £200,000 mortgage, which is repayable over 15 years at 5.7%, will be paid towards the interest in the third year. |
