# Calculate Yearly Rent

#### decent_boy

##### Board Regular
Hi
I need a formula to calculate yearly rent as per agreement date, rent will be increased after each year according to annual increment . Enclosed image is an example formula is required in yellow highlighted cells which calculates yearly amount as per billing month cell for example if agreement start year is Jan 2018 and bill year is Jan 2020 then rent amount after 2 year is 60,500. Further if bill year great than agreement end date then it shows "Agreement Expired"

#### Attachments

• Capture.PNG
21.2 KB · Views: 16

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### JimM

##### Well-known Member
Does this do what you want

=IF(D9>D1,"Agreement Expired",FV(E1,DATEDIF(C1,D9,"y"),0,-F1))

How do you get £44,000 as the result for Smith?? If interest is 15% then after 1 year the rent would be £46,000

#### decent_boy

##### Board Regular
Jim, thank you very much that is what i want
thanks for giving your time and effort

Replies
2
Views
87
Replies
6
Views
68
Replies
3
Views
215
Replies
1
Views
418
Replies
14
Views
191

1,129,795
Messages
5,638,382
Members
417,025
Latest member
MusterDuster

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back