S
sgl
using Excel 2003
I have taken the following from the Excel Help. I cannot Understand exactly
how this function works.
10% Annual interest
1 Period for which you want to find the interest
3 Years of loan
8,000.00 Present value of loan
-2,000 FV
0 Type (payments at end of period)
the results for each of the periods are as follows
-€1,983.43 period 1
-€1,999.95 period 2
-€2,016.62 period 3
-€6,000.00 Total repayment principal - which is correct
If I change the type to 1 (payments in advance) the total amounts are
-€2,033.15 period 1
-€1,983.43 period 2
-€1,999.95 period 3
-€6,016.53 Total repayment principal - This cannot be correct !!!!!
What am i doing wrong???
What about the IPMT Function. Would this have the same error??
Many thanks in advance for all help/sgl
I have taken the following from the Excel Help. I cannot Understand exactly
how this function works.
10% Annual interest
1 Period for which you want to find the interest
3 Years of loan
8,000.00 Present value of loan
-2,000 FV
0 Type (payments at end of period)
the results for each of the periods are as follows
-€1,983.43 period 1
-€1,999.95 period 2
-€2,016.62 period 3
-€6,000.00 Total repayment principal - which is correct
If I change the type to 1 (payments in advance) the total amounts are
-€2,033.15 period 1
-€1,983.43 period 2
-€1,999.95 period 3
-€6,016.53 Total repayment principal - This cannot be correct !!!!!
What am i doing wrong???
What about the IPMT Function. Would this have the same error??
Many thanks in advance for all help/sgl