Financial management and accountancy

Stock turnover calculatorMany businesses believe that they consistently carry more stock than is needed. As holding stock means tying up cash, then ideally you would want to keep stock at minimum levels to meet sales forecasts and keep production run... Read more

Work in progress monitoring toolWhether your company manufactures goods or supplies services, work in progress (WIP) control is an important element of working capital management. Excess WIP costs money and in the worst cases can end up being unbilla... Read more

Transfer pricing templateTransfer pricing isn't just an issue for global companies trading with each other across borders. It's based on the principle that transactions for goods or services sold between related parties, such as between two connected c... Read more

Doubtful debts calculatorIf you have concerns over the ability of the debtor to pay, it's prudent to establish a provision for the amount of the doubtful debt. Such a debt may become bad in due course, either in part or in full. Alternatively, you mig... Read more

Monthly prepayments calculatorYou 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. Howev... Read more

Indexing management accountsNearly the entire focus of management accounts is performance against budget and looking at the reasons for variances. However, comparisons with how you were doing this time last year, i.e. "growth", are also critical. Addin... Read more

Bid budget workbookBidding for projects can be a risky business, particularly when the price will be set in advance. Bidding at a price that does not include each element of the work to be carried out will result in lower than expected profits or eve... Read more

IRR and NPV workbookIRR (internal rate of return) and NPV (net present value) are discounted cash flow approaches and are widely used for investment appraisal. Whilst they are based on the same ingredients, the results differ, so you'll need a methodo... Read more