How to use the FVSCHEDULE function in Excel Office 365?
Tags: tousethefvschedulefu, excel, excelfunctions
Published: 2021-08-25 02:35:53

---
title: How to use the FVSCHEDULE function in Excel Office 365?
published: true
date: 2021-08-20 13:49:49 UTC
tags: ToUseTheFVSCHEDULEFu,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-fvschedule-function-in-excel-office-365/
---

 **FVSCHEDULE function** takes a **present value or initial principal amount** and **interest rates** for different periods are given as schedule array in the argument. In this short tutorial, we describe **how to use the FVSCHEDULE Function In Excel Office 365** in simple steps. Let’s get into the **article!!**

## FVSCHEDULE function syntax

```
=FVSCHEDULE (principal, schedule)
```

**Syntax Explanation:**

- **principal** : **initial amount or present value** at the **start of first year**.
- **schedule** : **scheduled interest rates** given as an array.

## Example

- Firstly, you have to **create the sample data**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-19.png)<figcaption>Sample data</figcaption>

- For instances, Mr. Harry has borrowed **100 dollars** with terms having condition that if he is not able to pay the **initial principal amount** with **interest rate** , the **interest rate will increase by 1 percent** for **each year**.
- You need to use the **FVSCHEDULE function** formula.

```
=FVSCHEDULE(B3,B4:B7)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/future-value-1024x412.png)<figcaption>Future value</figcaption>

## FV function with different interest rates for the different year periods

**Example** :

- You need to calculate the **future value** using the **FV function**.
- Then, you have to use the following **formula** to calculate future value for **1st year**.

```
=FV(C6,1,0,-C3)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/future-value-for-1st-year-1024x490.png)<figcaption>future value for 1st year</figcaption>

- Now, you need to use the following **formula** to calculate future value for **2nd year**.

```
=FV(C7,1,0,-E6)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/future-value-for-2nd-year-1024x493.png)<figcaption>future value for 2nd year</figcaption>

- At last, you have to calculate for each year will return the same amount as the **FVSCHEDULE function** at the **end of 4th year**.

![](https://geekexcel.com/wp-content/uploads/2021/08/future-value-for-4th-year-1024x502.png)<figcaption>future value for 4th year</figcaption>

**Check this too** : [How To Use Excel Text Functions in Office 365?](https://geekexcel.com/list-of-text-functions-in-microsoft-excel-365/)

**NOTES:**

- The function returns the **#VALUE! Error** if an argument in the function is **non-numeric**.
- **Blank cells** are considered as **0 value**.

## Sum-Up

In the above short tutorial, we have illustrated **how to use the FVSCHEDULE Function In Excel Office 365**  **tion In Excel Office 365**. Hope you like this article. Please feel free to state your **query** or **feedback** for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Keep Reading:**

- **[How to use the T.INV function in Excel office 365? – Easy Tricks!!](https://geekexcel.com/how-to-use-the-t-inv-function-in-excel-office-365-easy-tricks/)**
- **[Excel Formulas to Calculate the Basic Rates with VLOOKUP!!](https://geekexcel.com/excel-formulas-find-basic-rates-with-vlookup/)**
- **[Formulas to Calculate the Future Value of Annuity ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-future-value-of-annuity/)**
- **[Excel Formulas to Calculate the Payment Periods for Loan ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-calculate-the-payment-periods-for-loan/)**
- **[Excel Formulas to Calculate the Periods for Annuity ~ Useful Guide!!](https://geekexcel.com/excel-formulas-to-calculate-the-periods-for-annuity/)**