Try to not roast this noob too hard

Hey guys,

So I am taking an introduction to Excel class at the local community college and the professor gave us an exercise that I can't figure out. Any and all help will be appreciated.

The Scenario:
This Excel sheet is to be used by a real estate investor who will be purchasing one $2,000,000 building every year for the next 20 years. He finances the entire $2 Mill, paying 4% interest on every purchase and earning 4% appreciation on every building every year. We need to build an Excel sheet that would show his equity buildup over the years.

My Idea
This row has 30 Columns, I just pasted a few here so you'd get an idea.
EquityExercise.PNG

I thought I could just copy the contents of Row#2 down while skipping one additional column every time but I can't figure out how to do it efficiently.

For example: My data is in columns A2:AD2 and I want to copy it to B3:BE3 and then to C4:CF4 followed by D5:DG5 and so on 20 times. Is there an automatic way to do this or do I just have to manually enter the data over and over again?

Also, this can not be the best way to present this data - what if I need a 100 rows! It would be impossible to print. Can you guys suggest a better way to get a similar result? Like is there any way to use charts etc?

Thanks again.

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.