Excel 2010 Rate Function




About this tutorial:

Video duration: 2:36
In this video, you will learn how to determine the interest rate of a loan based on the amount of the loan, the number of payment periods, and the amount of the payments.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

6 thoughts on “Excel 2010 Rate Function

    BHAVIK PATEL

    (July 8, 2018 - 10:34 pm)

    Thank you I was stuck with the calculation it helps

    Its Reflect

    (July 8, 2018 - 10:34 pm)

    ad whore jk

    Its Reflect

    (July 8, 2018 - 10:34 pm)

    ultraboost 3.0 cny pls

    anjel gunu

    (July 8, 2018 - 10:34 pm)

    i find out solution of my problem in excel function so thanks lot of you

    Robert Sigurdarson

    (July 8, 2018 - 10:34 pm)

    Thanks a lot you sure know how to work them Excel functions

    Daniel Banz

    (July 8, 2018 - 10:34 pm)

    To convert the monthly periodic rate to an annual rate, aren't we supposed to use the EAR formula? 
    EAR = (1 + 0.005)^12 – 1 
            = 6.17% 
    Seems strange that we would just multiply the result by 12, but maybe that's just how it's done on Excel. 

Leave a Reply

Your email address will not be published. Required fields are marked *