Categories
Blog Downloads

DOWNLOAD: Mortgage Calculator

If you’re buying a house to live in or a buy-to-let and need to understand monthly mortgage costs, you can download my mortgage calculator below.

The calculator offers you insight in to your ‘Interest Only’ and ‘Repayment’ monthly payments, taking in to consideration loan-to-value rate, arrangement fee rate, interest rate and term, which are all customisable.

Hopefully this will give you better insight in to how much your mortgage will cost you and/or how changing interest rates, term, arrangement fee and LTV will affect your mortgage payments.

The calculator is completely customisable and I’ve made it easy to know where to change what by highlighting changeable cells to green.

There are various websites that help you to calculate mortgage costs on a month-to-month basis, however I didn’t find them very flexible in terms of including arrangement fees, changing loan-to-value proportions and changing interest rate levels. I also really wanted to compare and do a bit of analysis around changing rates, which this calculator helps me to understand.

Download here.

Categories
Blog Downloads

DOWNLOAD: How to Better Manage Your Business Finances and Make Better Decisions

The better management and review of your sales and costs data can be a powerful way for you to gain unique insight in to your business, to help you in making better financial and strategic decisions on maximising profit.

This unique information can give you knowledge on if whether your current and historical decisions are moving your business towards your ultimate business objectives, such as increasing profit by x%, or reducing costs. This real-time information on your financial position will help you in making better future decisions that will support you in meeting your business objectives.

Controlling risk is key and that is exactly what this simple log I have created helps you to do. It does this by recording every sale, with associated details and every cost/expense with associated details. It then uses the simple formula as below to calculate your gross profit. 

  • Profit = Revenue – Costs

Your Gross Profit is outlined in the Sales tab and incorporates sales, costs and forecasted costs.

It’s an editable Excel spreadsheet and you are able to add or delete columns as you wish, but if you think the log needs more, then drop me a message. I’m continuously reviewing my posts and would be very pleased if you did this.

I can tell you with confidence that this system has helped me to better manage my business, by equipping me with the information in an accessible format that is functional, instead of my old folder full of receipts and invoices, that I had to search through and manage manually, which was a serious headache; you probably know the feeling. By treating this log as a live document, keeping it regularly up-to-date, some of the reasons it has come in handy are as follows:

  1. Real-time Information on how much my profit is relative to my sales and costs
  2. When it comes to completing my Tax Return, I don’t have to dig out all of my receipts at the end of the year and struggle to read them through the degradation of quality of my receipts.
  3. I also know that for every transaction listed in the calculator, I will either have or not have a corresponding receipt.
  4. It allows me to search through my transactions i.e. I don’t have to manually search through my receipt file for a transaction – I can search by any field of a record.
  5. It acts as a reference point for future expenses; If I want to go back to remember how much I spent on a drill in 2009 for example, I can do this very easily by using the CTRL+F search functionality.
  6. It records all details related to all transactions, with notes. If I have something I want to remember later on, I can simply write it in the notes section. I will also have information on how the customer paid, what date they paid and more.
  7. I can see who my main customers are. By using the sort functionality in the spreadsheets, I can sort by customer and with a simple calculation, work out their average spend with me.
  8. It helps me to model scenarios – I sometimes put it sales figures that I would like to achieve and see how this affects my profit; I do the same for costs too.

The log helps me in making strategic decisions ranging from reducing my spend on expenses or giving me important information on who my main customers are, to allow me to concentrate on them; we all know the 80/20 rule, right? It gives me knowledge on performance and what services of mine are most popular; this information allows me to develop ancillary services that relate to the popular services. 

It’s best to use this log as a live document you keep up-to-date on a regular basis. It may takes couple of uses to get used to inputting data, but once you’re in the flow of things, you won’t be able to live without it.

You can download it from here.

Take some time in getting to know the spreadsheet before using it. There are some example entries in the spreadsheet, which you can delete. 

Have fun in managing a better business.