Powerful Excel formulas you should know in 2024 Performing the Initial Calculations To begin creating your amortization schedule, you’ll first need to calculate a few key values.

One may use CAGR to calculate returns from mutual funds schemes by taking into account the initial NAV and the current NAV or the NAV at which the investment was redeemed.