Notes
Be consistent with inputs for rate. For example, for a 5-year loan with 4.5% annual interest, enter the rate as 4.5%/12. By convention, the loan value (pv) is entered as a negative value.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.