Results 1 to 3 of 3

Calculate daily interest rate

Threaded View

Beechams Calculate daily interest rate 11-08-2008, 10:39 AM
daddylonglegs DAYS360 doesn't give an... 11-08-2008, 12:08 PM
Beechams Many thanks for your reply.... 11-09-2008, 06:58 AM
  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    8

    Calculate daily interest rate

    Some years ago I came across a formulae to calculate Daily Interest on a Building Society Savings account in the UK.
    I have used this since but find my calculations never work out the same as my BS, although to my advantage!
    It is =B3*B4/360*DAYS360(B5,B6,TRUE)
    Where:
    B3=Capital
    B4=Interest Rate
    B5=Starting Date
    B6=Finishing Date
    For some reason the formulae uses 360/year and not 365/year.
    Using both still gives wrong answer.
    If anyone has an answer or a better formulae I would appreciate it.
    Many thanks.
    I use Excel 2000
    Last edited by VBA Noob; 11-09-2008 at 07:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1