Using the FV function is perfect for calculating the ... Here’s how you’d set up the formula: In Google Sheets and Excel, you can type this directly or reference cell values for each component.