Results 1 to 2 of 2

Thread: Dynamically updating multiple scenario cashflow

  1. #1

    Dynamically updating multiple scenario cashflow



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I have a small problem I would like some help with if possible. Basically what I have is the below (dummy numbers, download picture to see full screen, sorry!):

    Click image for larger version. 

Name:	Capture.png 
Views:	11 
Size:	44.1 KB 
ID:	3248

    The original cashflow line is what I am working off.

    I need to produce two alternative rows below this line which do the following:

    Row 9: Subtract all positive values AFTER the financing date (31 March in this case, this has to be able to change at a later point if required) until the amount subtracted has reached the Threshold amount (Cell B1). I need to ONLY subtract positive amounts and ignore negative amounts. Then once the threshold amount has been matched, I want to add back in the total threshold amount on the closing date (Cell L5, however this may change also so that will need to be taken into account). I have shown this row as I would like to see it output as an example.

    Row 11: I want to ignore all values until you reach the financing date (31 march). Then ON the financing date, subtract the entire threshold, then proceed to ignore any values until the closing date (31 September) has been reached, then add the full threshold back in ON the closing date. It's the same case above where the financing date and the closing date can change in the future so this would need to update dynamically. I have also shown an example row (row 11) where the inputs I would require are shown.

    Let me know if any of the above needs clarification,

    Thanks
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	28.2 KB 
ID:	3247  

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Last edited by Pecoflyer; 2015-03-03 at 11:54 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •