Pre-populate a range of cells with cashflow numbers - number of cells depends on the length of a lease in years

[mychaletfinder]

Hi - I am building a financial model for a sale and leaseback arrangement that has different durations ie 30 years or 50 years. I want to be able to set the number of years as an assumption and then for the model to display the cashflows in the same number of columns as the number of years. For example, if the lease term is set for 30 years and the annual cashflow is £1000 adjusted for inflation, then what formula do I use to make excel automatically populate 30 columns with the cashflows numbers in. if I change the assumption to 50 years, then 50 columns are populated. I need this to be modelled so that the IRR calculations can be automated for any length of lease selected. Thank you

 

[RayFrye]

I would suggest that you chop your requirements up into tiny pieces. This will allow you to think thru your requirements and someone here to get a handle on where you start, what happens in the middle (multiple steps) and how you might end the effort before the cycle starts over. I think most folks here want to help but many of us are programmers and we think in terms of formulas, forms, key strokes, subroutines and error processing. When we think about Excel apps our heads explode until we get the app to subroutines, then we can do our thing. Just a thought. And try something yourself and let us know where your thought process failed. Not too many here, although there are some, will sit down and write the app for you.