Interesting/infrequently used Excel Formulas

Options
Smeekins
Smeekins Member, ALL USERS, GroupMember, Certified Master Anaplanner Posts: 5 Certified Master Anaplanner
in Anaplan Community

Thought it might be interesting to share infrequently used Excel Formulas....I was working on a Real Estate model and came across the Excel Nominal Formula.  Essentially, the Nominal Formula takes a Compounded interest rate and converts back to a simple interest rate.  In Anaplan this is translated to.....  

 

(POWER(1 + Compounded Rate, 1 / 12) - 1) * 12

Where Compounded rate = provided compounded rate

12 is the number of compoundings per year (ie. once a month).  This would change based upon the number of compoundings such as 365 for daily.  The result is the nominal (simple) interest rate.  In case anyone ever needs to use this...…  Please feel free to share some of the Excel formulas that you have translated to Anaplan.

Categories