Need help desperately on nested IF AND formula

[CH9260]

Hi everyone,

I'm working on a 10 cashflow statement on a rental home, where the home is being rented only during May, June, July and August. Here are basic assumptions:

Purchase Date: 6/1/23
Renovation Work: 6/1/23 - 4/30/2024
Rent Start Date: 5/1/24

In the first year of renting the home, the monthly rent would be $5000. For each year after that, the rent amount would be increased by 4.5%

How can I write a formula that I can drag across all months, that would show the correct amount of income being generated for each month?

 

[awoohaw]

how is this:

mr excel questions 5.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
3	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24
4	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5225	5225	5225	5225
Sheet10

Cell Formulas
Range	Formula
C4:Q4	C4	=IF(MOD(COLUMNS($B$4:C$4)-1,12)=0,1.045,1)*B4

 

[awoohaw]

Here it is with the year displayed:

mr excel questions 5.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 1	Year 2	Year 2	Year 2	Year 2
3	Feb-23	Mar-23	Apr-23	May-23	Jun-23	Jul-23	Aug-23	Sep-23	Oct-23	Nov-23	Dec-23	Jan-24	Feb-24	Mar-24	Apr-24	May-24
4	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5000	5225	5225	5225	5225
Sheet10

Cell Formulas
Range	Formula
B2:Q2	B2	="Year " & ROUNDUP(COLUMNS($B$4:B$4)/12,0)
C4:Q4	C4	=IF(MOD(COLUMNS($B$4:C$4)-1,12)=0,1.045,1)*B4