12-19-2012 10:29 AM
I am working on a bond project. Sometimes bond is called, I need to create a new bond face value for each year after being called. Below is a simple table:
How can I create the last colume? (new FV)
Any help would be greatly appreciated!!
12-19-2012 11:02 AM
input Year BondFV Called ;
1 100 0
2 100 5
3 100 0
4 100 0
5 100 4
6 100 0
if _n_=1 then newFV=bondfv;
12-19-2012 11:20 AM
Thank you , Hai.Kuo. But I realized my problem is more complicated than this. ( I should have enbe more specific). I forgot to add that my sample inludes many companies, and each company has several action_types ( not juste being called, sometime paying for sinking fund). so I need to use by ID, and action_type, : if first.ID and first.action_type , something like that. newFV-called-sinkinfund
But thank you , anyway. I am not sure if I have limitation of numbers of posting each day in this website? I may repost my question.
Need further help from the community? Please ask a new question.