10-02-2014 02:32 PM
What is the best way (formula only) to show an increment by 5%. So for example cost = 23, what is the best formaula to use to also show 4 increments by 5%. So cost1 = cost + cost * 0.05 and cost2 = cost + cost*0.1 .. etc... Thanks
10-02-2014 02:42 PM
These can also vary slightly depending on when increases are, extra payments and all sorts of variations.
Anyways, there's a whole scheme of SAS finance functions that accomplishes these:
EDIT: I assumed a 4% increase for some reason, you can replace that with the relevant amount.
10-02-2014 02:47 PM
A formula is a part of one assignment with one result.
To get 4 answers you need 4 assignnents
Except for a CALL routine like CALL SCAN which derives 3 results in one statement. But to write your own call routine involves more than one statement.
So, what does your request mean.
Cost1 = cost * ( 1+ rate/100) ;
Cost2 = cost1*( 1+ rate/100) ;
Cost3 = cost2*( 1+ rate/100) ;
where rate is 5 for 5%
10-02-2014 03:05 PM
I am trying to see losses based on different cost scenarios so part of a larger formula , cost would be shoiwng as cost1, cost2, cost3, etc..
for example Losses = cost + fees + interest. I want to see the Losses scenarios if Cost incremented by 5% .. and I want to see it for 4 scenarios.
Need further help from the community? Please ask a new question.