![]() |
Compound Interest Problem
Can anyone tell me if there is an Excel function to calculate the future
value of an initial principal amount after adding compound interest. E.g a function that does the following P x (1+i%)^n Although the formula is straightforward my client, for reasons I do not understand, wants a specific Excel function. Any help much appreciated. Andrew. |
=FV(i, n, 0, -P)
Mangesh "Andrew Mackenzie" wrote in message ... Can anyone tell me if there is an Excel function to calculate the future value of an initial principal amount after adding compound interest. E.g a function that does the following P x (1+i%)^n Although the formula is straightforward my client, for reasons I do not understand, wants a specific Excel function. Any help much appreciated. Andrew. |
Yes, there is, and strangely enough <g it's called Future Value or FV. Check
it out in Help. On Fri, 23 Sep 2005 10:57:35 +0100, "Andrew Mackenzie" wrote: Can anyone tell me if there is an Excel function to calculate the future value of an initial principal amount after adding compound interest. E.g a function that does the following P x (1+i%)^n Although the formula is straightforward my client, for reasons I do not understand, wants a specific Excel function. Any help much appreciated. Andrew. |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com