Rule of 78 excel spreadsheet free
Excel and the Rule of 72 The Rule of 72 is a guesstimate of how long it will take an investment at a specific interest rate to double in value. But how accurate is this rule? This Excel Hey all. Currently, i have a little spread sheet to work out interest paid per period. . Basicly. . i work out interest per unit, and multiply that by units per period. . works great. . however. . thats simple interest. . i now need to work it out with rule of 78. .rule of 78 excel spreadsheet How can the answer be improved?
Rule of 78. The alternate name for the Rule of 78, the sum of the digits, gets it name from the need to calculate the sum of the digits for each month of the loan. The sum of the digits for a one year loan, with monthly payments, is 78, thus the name. The formula for the sum of rule of 78 excel spreadsheet Apr 03, 2008 Research Definition: A formula used to determine rebates on interest for installment loans. For a 12month loan: 1 2 12 78. After the first month, 1278th of the interest is owed, 1178ths after the second month, etc. The following formula is theRating: 4.72 / Views: 712