Accounting for Capital Leases Calculator

This accounting for capital leases calculator will help a business to produce the monthly accounting journals required to record capital leases.

The rental payments on a capital lease are split between principal and interest when posted to the accounting records. As the lease liability reduces each month the interest will reduce and the principal / interest split changes.

Our tutorial on capital lease accounting gives full details about how to account for capital leases.

accounting for capital leases calculator
Accounting for Capital Leases Calculator Preview

The Excel sheet, available for download below, will help you calculate the principal / interest split for a given accounting period, and provide the accounting journals needed to post the asset and associated depreciation, the lease liability, and the rental payments.

Accounting for Capital Leases Calculator Download

The accounting for capital leases calculator is available for download in Excel format by following the link below.

Notes and major health warnings
Users use this accounting 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 an accounting format that you might use. It is purely illustrative. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the template, please let us know and we will try to fix it.
Accounting for Capital Leases Calculator November 6th, 2016Team

You May Also Like


Related pages


what is the retail inventory methodapproximate doubling time formulaconvertible preferred stock examplewhat is nsf chequegrowing perpetuityis interest receivable a current assetdebtors control account definitionfinancial gearing formulafundamental accounting equation problems and solutionsfactoring accounts receivable examplereturn on retained earnings formulawhat is irr in accountingformula present value of annuityformat of general ledgertvm equationdepreciation formula excelallowance for doubtful receivablesreplenish petty cash journal entryformula for annuity paymenteom meanwrite off receivableworksheet for accountingformulas of accounting ratiosroce calculationhorizontal analysis of the income statementcumulative participating preferred stockaccrued income exampleaccounts receivable turnover in dayshow to calculate variable cost formuladebenture interest in income statementchecking account ledger templatenpv perpetuity calculatorexample of adjusting entriesdouble entry for fixed assetsexamples of adjusting journal entriesfactory overhead variancegearing calculationspresent value annuity calculatoraccounting equation templateaccrued expense payabledefine rocesimple accounting equationfixed asset disposal journal entrypledging accounts receivablecalculating ratios in exceltotal variable cost equationmarkup or margincheque definemark up ratiocumulative compound interest formulaaccounting entry for bad debtsexcel balance sheet formulabond payable on balance sheetthe effective interest amortization methodthe journal entry to record a return of merchandisedefine freight collecttraceable fixed costbond amortisationfuture value of lump sum excelretained earnings statement templatestock dividends journal entryjournal entry for issuing stockpresent value factor of annuityperiodic inventory system closing entriesbookkeeping exercisestimesheets templatesdouble entry bookkeeping tutorial pdfexamples of manufacturing overheadcash receipt journal examplenpv excel spreadsheetformula to find variable costefficiency ratio inventory turnover formulaprinciple of double entry bookkeepingsublease accounting journal entrieswhat are quick assets in accountingcost accounting absorption