Hi there,
I am trying to project revenue flows from rental income over a 3 year period.
We will be renting different quantities each month for a fixed term
I would like calculate the revenue received and amount outstanding to be paid by the customer at the end of each year.
Would also like it to be adaptable, ie change the rental term
I manged to hard code it by using an offset formula to add the number of units rented (this worked in the short term as we are not projecting past a rental period), but i am unsure how to make it variable
For example
Monthly rent: 300
Term: 36 months (like to be able to adjust this)
Units rented:
Jan 18: 5
Feb 18: 7
Mar 18: 3
Apr 18: 4
May 18: 9
etc
Would also like to build in a deferral period for payments to start and also a deposit on first payment, ie 2 months up front)
Hope the above makes sense!
Bookmarks