![]() ![]() The number of periods is the total number of payment periods, which in this case is 5, ![]() So it asks for the rate, in this case is 11%, ![]() If you wanted to work out the interest payments over the years 1 and 2, you can do the followingĪnd find CUMIPMT which stands for Cumulative Interest PaymentĪnd this will pop up, what it asks for is a bit of information about the loan, However, in Excel there’s and easier way to do that, using the Cumulative Interest Payment function and the Cumulative Principal Payment function. Generating a repayment amount, and we have developed an amortization table, so that we can work out what the interest charge is each year, and what the actual capital repayment is each year. In this example we have a loan outstanding of 100000, with an interest rate of 11%, over a period of 5 years. Please note that you need to have the Analysis Toolpack loaded in order for these functions to work. In this segment you will learn how to activate these functions and use these functions instead of building amortization tables. The CUMIPMT and CUMPRINC functions allow you to calculate the net interest paid and principal paid over any particular period without having to generate amortization tables ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |