Forum Discussion

Antoine74's avatar
Antoine74
Copper Contributor
May 11, 2023

Disbursement scenarios

Dear Community,  I am asking for help :  - I am builing a business plan (BP) ; - an important feature of this BP is a series of 5 investments that will cause cash outflows ; - for each of these i...
BI & Data Analysis
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 11, 2023

Antoine74 

I haven't got as far as NikolinoDE when it comes to scenario management.  You will clear need some steering data to set up your problem.  I would start by setting up a timeline and a Lambda function that distributes a given outflow along the timeline.

Worksheet formula
= Outflowλ(start, occurrences, periodicity, amount, periodCounter#)

where the function 'Outflowλ' is defined by

= LAMBDA(start,occurrences,periodicity,amount,periodCounter,
    LET(
      outflow, SEQUENCE(occurrences, , start, periodicity),
      BYCOL(IF(periodCounter=outflow,amount), SUMλ)
    )
  )

Resources