Loan over month cashflow

Hi all,

I've looked around the forum and can't find exactly what I'm looking for so hopefully someone might be able to help. Here's the problem...

I am putting a cashflow forecast together and part of this is working out how a compound loan could effect cashflow at any given period over the next 5 years. I will be constatnly buying music equipment and so will be taking out several seperate loans throughout the forthcoming years.

I need two things:

1) Say I decide to input in my cashflow that I will take out a £1000 loan in January 2011. I've worked out what the monthly fixed payments would be and have a drop down box that allows me to choose if the payback period is 12, 24, 36 or 48 months. (the payments obviously change as I change the payment period)
SOLUTION NEEDED: I need it to do the following: When I select 12 months it copies the monthly fixed payment into the next 12 months worth of cells. Likewise if I selcted 24 months it then copies it across 24 months worth of cells and so on.
What do I do to do this?

2) If I took another loan out in June 2011 (6 months after the first loan) I would still be paying off the previous loan as well as described in 1). So... is it possible that if I added the second loan in June 2011 for a payment period of 24 months (or whatever time period I chose from the drop down box) it includes the second months figure to what is already needed to be paid from the first loan.
We were looking to not add a new row each time we took another loan as we could be taking out many loans over the forthcoming years.

Hope I have explained myself.

Look forward to your thoughts

Thanks

Ed