Populating the projected annual rental income based on revision dates

**aghlab** · 06-25-2013, 10:11 PM

The attached file contains 2 sheets. They are Projected Income sheet and Premises sheet. I want to get the Projected Income formalize to calculate its yearly projected income base on the Premise sheet.

In the premise sheet, I use five house as samples and each house has different timing in the tenant commencement. These properties has 5 revision date of rental increment with different periods.

Please help.

**Teethless mama** · 06-25-2013, 11:22 PM

Projected Income sheet

B4: =SUMPRODUCT((YEAR(PREMISES!$B2:$L2)=B$3)*PREMISES!$C2:$M2)

Copy across and down

**aghlab** · 06-26-2013, 12:55 AM

Attached is the amended file but it seems like it only generate 1 month's income and only according to year. For instance, there was no income stated in the year 2014. If the rental commenced in January 2013 there should be a recurring rental income through out the year until the year 2027.

It also occurs to me that the 5th revision date should have a rental ceased date, meaning that the rental should ceased at the said that and I require some assistance on that too.

PS: I forgot to mentioned the "Premise" sheet shows the monthly rental and the "Projected Income" sheet is for the whole year (Jan - Dec).