Included here for download are the following Excel spreadsheets that I have developed.

  • Loan repayments calculator
  • Arbitrary Precision Number Calculations
  • Option price calculator


Loan repayments calculator

Listed below is a simple spreadsheet for calculating the repayments on a home mortgage or other loan.

Loan Repayments Calculator


Arbitrary Precision Number Calculations

Excel, like most computer software, is normally limited to 15 digits of calculation accuracy.

A while ago I developed some macros for performing Arbitrary Precision Number Calculations, i.e. calculations to any number of decimal places, such as 100.

Arbitrary Precision Number Calculations



Option Valuations

Options are a lot of fun. Whether you are a student doing a finance course, an investor who wants to experiment with trading options or a professional the spreadsheet below may be useful.

This Excel spreadsheet uses the standard Black and Scholes option pricing model to calculate the value of Call or Put options under whatever conditions you specify.

Available for students or home use below.

Option Price Calculator