Introduction to this document

Monthly prepayments calculator

You can make adjustments to your monthly management accounts for any expense that spans more than one period, e.g. rent. Other common examples of prepayments are insurance, maintenance contracts and business rates. However, this involves extra work each month in recalculating the expense that relates to the period after month-end. Using a prepayments calculator can save you valuable time each month.

Insurance

For example, your company will have a number of insurance policies with differing premiums and renewal dates so the monthly prepayment calculation could look like this:

 

Insurance policy

Premium £

Cover to

Days left at 31/12/12

Prepayment (£)

Employers' Liability

500

17/10/2013

290

397.26

Public liability

3,000

17/05/2012

137

1,501.37

Motor

4,000

04/08/2013

216

177.53

Office

2,000

28/02/2012

59

323.29

Total

 

 

 

2,399.45

 

However, you have to spend time each month recalculating the expense that relates to the period after month-end.

Use our Monthly Prepayments Calculator to help save you time recalculating your insurance prepayments each month.

Once you have customised it to your own rent, insurances, maintenance contracts, rates, etc., all you have to do is enter the month-end date at the top of the spreadsheet for it to automatically recalculate the prepayment.