Monday, 27 June 2011 16:18

Bank Loan Assessor Teaser

Use this Excel spreadsheet to compare two bank loans, or to calculate the actual rate of interest being charged on a loan.

Features

  1. Converts all fees into a cost of money - the interest rate - making loans with different fees comparable
  2. Copes with bullet payments (where an element is repaid as a lump sum at the end)
  3. Exposes the flat rate sham
  4. Shows the actual (nominal) rate of interest the bank is charging, along with the corresponding APR
  5. Copes with monthly payments for terms up to 30 years
  6. Shows the amount of debt outstanding at any point during the loan
  7. Quick calculator for simple cases where you know the repayment and want to know the rate

 

Published in Teasers
Thursday, 12 May 2011 08:09

How to borrow money from your bank

Business bank managers everywhere despair, every day, at the quality of the loan requests they get. To make it worse, these requests are from established businesses, from MD's who, supposedly, know their stuff.  Lenders are given limited information and questionable financial data. This comes accompanied by an expectation that no reasonable bank manager could possibly fail to see why it is a good idea to hand over a big pot of money.

So what is going wrong ?  Why is there a mismatch between the expectations of the bank manager and those of the managing director ?

Published in Guidance
Wednesday, 27 April 2011 13:50

Bank loan assessor

Use this Excel spreadsheet to compare two bank loans, or to calculate the actual rate of interest being charged on a loan.

Features

  1. Converts all fees into a cost of money - the interest rate - making loans with different fees comparable
  2. Copes with bullet payments (where an element is repaid as a lump sum at the end)
  3. Exposes the flat rate sham
  4. Shows the actual (nominal) rate of interest the bank is charging, along with the corresponding APR
  5. Copes with monthly payments for terms up to 30 years
  6. Shows the amount of debt outstanding at any point during the loan
  7. Quick calculator for simple cases where you know the repayment and want to know the rate
Published in Downloads