Rule of 78 Calculator

What does it do?

This rule of 78 calculator can be used to provide the rule of 78 calculation interest expense for any period in the term of a loan up to a maximum of 600 periods.

The calculator will also produce a loan amortization schedule setting out for each period, the beginning loan balance, the interest expense and repayment for the period, and the ending loan balance.


The Excel rule of 78 calculator, available for download below, is used to produce an loan amortization schedule by entering details relating to the loan principal, the periodic repayment, and the number of periods in the loan term.

rule of 78 calculator v 1.0
Rule of 78 Calculator Preview

The rule of 78 calculator is used as follows:

Step 1

Enter the principal loan amount.

Step 2

Enter the loan repayment. This is the constant loan repayment made at the end of each period throughout the term of the loan.

Step 3

Enter the loan term. This is the number of periods in the term of the loan. A period can be any term (month, year etc). The interest expense will be calculated for this period. For example if a loan has a 12 month term the term is entered as 12 then the expense will be for each month, if the term is entered as 3 years, then the depreciation expense will be calculated for each year.

Step 4

Enter the period for which the rule of 78 interest expense is required. For example, if the interest expense for period 3 is required enter 3.

Step 5

The rule of 78 calculator works out the interest expense for the period entered in step 4.

In addition, the calculator provides a rule of 78 loan amortization schedule setting out for each period, the beginning loan balance, the rule of 78 period interest, the period repayment, and the ending loan balance.

Rule of 78 Calculator Download

The Excel rule of 78 calculator, available for download below, will calculate the interest expense for any loan with a maximum term of up to 600 periods, and is used by simply entering values for the loan principal, periodic repayment, and loan term.

Notes and major health warnings
Users use this rule of 78 loan calculator template at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a rule 78 calculator with loan amortization schedule that you might use. It is a purely illustrative rule of 78 refund calculator. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the rule of 78 calculator excel, please let us know and we will try to fix it.
Rule of 78 Calculator November 6th, 2016Team

You May Also Like

Related pages

degree of financial leverage calculatortemplate for timesheetallowance for uncollectible accounts balance sheetaccounts receivable ledger definitionbank charges journal entryaccounting ledgers templatescredits and debits made easybad debt expense journal entryimprest fund definitionformula for beginning inventorythe dupont equationirr internal rate of return formularecording petty cash transactionsbook value formula depreciationperpetual system inventorydefine fob destinationallowance method bad debtaccrued expenses exampleaverage days sales in inventorydouble declining depreciation examplethe account receivable turnover measurescreditors collection periodannual depreciation straight line methoddouble bond equivalent calculatorbalance sheet accrued expensesexcel depreciation schedulefuture value annuity due tablepresent value lump sum formulaequation for retained earningsexamples of manufacturing overhead costsdepreciation straight line calculatorannuity cash flows calculatorhorizontal analysis of balance sheet examplereturn on capital employed rocehow to find receivables turnover ratiohow to write a voucher for paymentoverhead absorptionmanufacturing overhead formula examplemeaning of accrued expensesdividends formula accountinghow do you calculate stockholders equityjournal entries for accumulated depreciationabsorption costing exampleoperating lease payment calculatorpredetermined overhead rate calculatorhow to work out markupcost of merchandise sold equals beginning inventoryaccounting merchandise inventory journal entrybond amortization scheduledefine contribution margin per unitpercent complete formulaprove it accounts payable testaccounting ledgers examplesworksheet trial balance and adjustmentscontra entry definitiondebit balance in accounts payableexample of payment voucherannuity due definitionpv of perpetuity formulacommon stockholders equity formulatreasury stock account typepetty cash credit or debitcapital lease accounting lesseebad debts written off meaningblank income statement and balance sheetjournal entries debits and creditsfundamental accounting equation examplesaccured payrollnsf accounting definitiongross margin equalsrecording accrued expenseswhat are controllable expensesaccrued income meaningformula for total asset turnover ratiojournal entry for purchase of treasury stockaccounting t accounts templateannuity due chart