Periodic Rate Functions in Excel. ... For example, an $12,000 loan with 36 payment periods, a $550 periodic payment, payments coming at the beginning of the period, ...

Calculating the future value of a present single sum with multiple interest rates. This example shows how to use the ­FVSCHEDULE function in Excel to calculate the future value of a present single sum ...

Use Excel in your rate card formulas to calculate discounts, ... Functions include the RATE() function, ... multiply and divide values. For example, input the formula "=15*5" -- without the ...

Read: 10 Text functions in Excel with examples 15] FVSHEDULE The FVSHEDULE function returns the future value of an initial principle after applying a series of compound interest rates.