Calculating basis points

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:

    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:

      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.