Calculating basis points

Posted on June 28, 2011 by Dan

Here's a handy spreadsheet to help you calculate basis points, and prorate their charge as necessary. Simple, but useful.

This entry was posted in Tools. Bookmark the permalink.

2 Responses to Calculating basis points

  1. RacerDeb says:
    October 9, 2012 at 2:41 pm

    Need more assistance with basis points than shown here. Can you help with how to construct an excel formula to show the result of this basis point formula in either negative or positive result rather than just the difference between two cells that contain basis points?

    =(ROUND(N3,2)-(ROUND(D3,2)*10000))

    N3 is 12.8030223528177%
    D3 is 12.67%

    or

    N4 is 10.95%
    D4 is 10.90%

    Any help will be greatly appreciated.

    • Dan says:
      October 9, 2012 at 2:44 pm

      I think you have your bracket in the wrong place. =(ROUND(N3,2)-(ROUND(D3,2)*10000)) should be =(ROUND(N3,2)-(ROUND(D3,2))*10000)

Comments are closed.