I want to add a feature to my model that will include these inputs:
Start Date
Number of Months
Amount
Then I want the model to spread the amount across the months using a normal distribution (bell curve). In Excel, I have used the NORMDIST function to calculate the probability be period and then multiply that against the full amount.
Any ideas? TIA