Calculate Loan Interest In Given Year Excel Formula
Note: values hardcoded for readability only. rate - The interest rate per period. We divide 5% by 12 because 5% represents annual interest. nper - the total number of payment periods for the loan, 60. pv - The present value, or total value of all payments now, 30000. start_period - the starting period for a given year. end_period - the ending period for a given year. In the range F5:F9, here are the formulas used: Note many values could be picked up directly with cell references, but are hardcoded in this example for readability....