N is the number of investment periods, for example 36 months, 3 years, etc. The basic Excel formula for compound interest is this: =PV*(1+R)^N Here's what you need to know about calculating compound interest in a Microsoft Excel spreadsheet. There isn't a quick one- or two-click way to learn how to calculate compound interest in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |