Purchase Transaction Journal Entries

The purchases transactions journal entries below act as a quick reference, and set out the most commonly encountered situations when dealing with the double entry posting of purchase transactions.

In each case the journal entries show the debit and credit account together with a brief narrative.

Read more

Preferred Stock Journal Entries

The preferred stock journal entries below act as a quick reference, and set out the most commonly encountered situations when dealing with the double entry posting of preferred stock transactions.

In each case the journal entries show the debit and credit account together with a brief narrative.

Read more

Term Deposit Journal Entries

The term deposit journal entries below act as a quick reference, and set out the most commonly encountered situations when dealing with the double entry posting of fixed term deposits.

In each case the journal entries show the debit and credit account together with a brief narrative.

Read more

Excel DB Function

The Excel DB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DB (cost, salvage, life, period, month).

Read more

Excel DDB Function

The Excel DDB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DDB (cost, salvage, life, period, factor).

By setting the factor parameter to either one or two, the function can be used to calculate either the declining balance depreciation or the double declining balance depreciation.

Read more

Excel SLN Function

The Excel SLN function is one of many Excel financial functions, and can be used to calculate the straight line depreciation of a long term asset. It has the syntax SLN (cost, salvage, life).

Read more

Bank Reconciliation Journal Entries

The bank reconciliation statement journal entries below act as a quick reference, and set out the most commonly encountered situations when dealing with the double entry posting relating to bank reconciliations.

In each case the bank reconciliation journal entries show the debit and credit account together with a brief narrative. For a fuller explanation of journal entries, view our examples section.

Read more

Growing Annuity Payment Formula FV

This growing annuity payment formula FV calculates the initial annuity payment required to provide a given future value FV using a growing annuity. The growing annuity payment formula assumes payments are made at the end of each period for n periods and are growing or declining at a constant rate (g), and a discount rate i is applied.

Read more

Loan Balance Formula

The loan balance annuity formula is used to find the balance outstanding on a loan by calculating the present value of the remaining loan installments. The payments are for the same amount, made at the end of each period, and a discount rate i% is applied.

Read more

Annuity Due Payment Formula FV

This annuity due payment formula FV calculates the annuity payment required to provide a given future value FV. The annuity formula assumes payments are made at the start of each period for n periods, and a discount rate i is applied.

Read more

Growing Annuity Payment Formula PV

This growing annuity payment formula PV calculates the initial annuity payment required to provide a given value today PV (present value) using a growing annuity. The growing annuity payment formula assumes payments are made at the end of each period for n periods and are growing or declining at a constant rate (g), and a discount rate i is applied.

Read more