8/17/2023 0 Comments Excel maximum drawdown![]() So, substituting for v(i+2) using Equation 2 yields Which, with a little re-arranging can be written as Now using Equation 1 to substitute for v(i+1) in this second equation yields Since Equation 1 applies to all periods, it follows that This starts with the relationship between the loan amount outstanding in successive periods The analysis below, which determines p in terms of L, r and n, assumes payments are made at the end of each period. Note that if the payments p are made at the start of each period (rather than the end) the first equation would change to:Īnd v(i) would be the amount outstanding at the start of period i immediately before the payment p is made. The other two equations simply state the start and end conditions of the loan. ![]() ![]() Simply says, in words, that the amount outstanding at the beginning of period i is increased by adding interest accrued during period i before being reduced by the payment amount made at the end of period i to get the amount outstanding at the beginning of the following period (period i+1). v(i) is the amount of the loan outstanding at the beginning of the i'th period. The basic mathematical relationships involved are: v(i+1) = v(i)*(1+r) - pĪn amount L is borrowed for n periods at an interest rate of r per period and payment amounts of p are made at the end of each period. To get to the type of expression quoted in it is necessary to understand those mathematics and then adapt them to deal with the scenario outlined. Functions such as PMT shield users from having to understand the mathematics underlying Excel's financial calculation capabilities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |