Auxiliary formulation for Annual profit
Posted: Sat Apr 10, 2021 2:43 pm
Dear
I have a growing cash (LEVEL variable) for 60 months (5 years).
I want to know how to create a AUX variable (e.g. to name it as annual cash) which can calculate the every year cash amount as the sum of the past 12 monthly cash.
( refer to attached file , see the value of the table of the cash level at 12th month, at 24th month, at 36th month and so on)
for example. the graph of the AUX variable of the annual cash will show like:
x-axis (time) month 1st~12th (1st year) : a flat line to show 1st year cash level $18,150, then, month 13rd~24th (2nd year) another flat line to show the 2nd year cash level $14,810 (32,960-18,150)
what vensim functions or what formulation can do that ? ( I heard someone using Pulse functions to sample the amounts, I do not know how to do that in vensim), please help.
as you may know, company's financial budgeting take place annually at the end of the year, which require to record the annual amount as a reference to set next year budget e.g. percent of the cash for the investment etc. So I need that AUX variable.
Thank you
I have a growing cash (LEVEL variable) for 60 months (5 years).
I want to know how to create a AUX variable (e.g. to name it as annual cash) which can calculate the every year cash amount as the sum of the past 12 monthly cash.
( refer to attached file , see the value of the table of the cash level at 12th month, at 24th month, at 36th month and so on)
for example. the graph of the AUX variable of the annual cash will show like:
x-axis (time) month 1st~12th (1st year) : a flat line to show 1st year cash level $18,150, then, month 13rd~24th (2nd year) another flat line to show the 2nd year cash level $14,810 (32,960-18,150)
what vensim functions or what formulation can do that ? ( I heard someone using Pulse functions to sample the amounts, I do not know how to do that in vensim), please help.
as you may know, company's financial budgeting take place annually at the end of the year, which require to record the annual amount as a reference to set next year budget e.g. percent of the cash for the investment etc. So I need that AUX variable.
Thank you