Goal: Calculate how much money you will have in the future. FV combines your deposits (Principal) with the magic of Compound Interest.
-
Total Invested
-
Interest
Future Value
Ready...
💻 Formula Structure
=FV(rate, nper, pmt, [pv], [type])
1. Rate: Interest rate per period (e.g., 5%/12).
2. Nper: Total periods (Years * 12).
3. Pmt: Regular payment (Negative for deposit).
4. Pv: (Optional) Starting lump sum.
-- Calculate Future Wealth
=FV( 5%/12, 60, -500, 0 )
Final Amount:
-
⚠️ Common Pitfalls
🚫 Sign Confusion
Money you pay out (deposits) should be negative. Money you receive back (future value) will be positive. If you enter PMT as positive, FV returns negative (debt).
📅 Period Matching
Ensure Rate and Nper match. If you save Monthly, divide annual Rate by 12 and multiply Years by 12.