Good evening for everybody!
It's my first post here, after having registered minutes ago in this forum. I hope I can find some help to help me to solve this problem.
I looking for the solution formula to excel (office 2016) to this problem:
I have 15000 issued rights in wallet. In a few days I have to decide what to make with them.
I'll sell part of them so I can gather the money enough to refinance the underwriting of the other part not sold.
I need to know how many rights should I sell so that the sold one give me back the precise money to pay the underwriting of the remaining rights, knowing tha the price of rights will vary along the negotiation (just like shares in stock market).
Conditions:
Total Number of rights in wallet - 15000
Price of rights - they will be negotiated for some days (so price will be one constant variable)
Price to underwrite one right - 15*0.094
N.º of rights to sell - Variable (depending on price of the rights - i think...)
N.º of rights to underwrite - (the difference between the total number of rights and the sold rights)
Can you help me formulating a way to construct a formula to excel so i can solve this problem?
Thank you very much!
(I know it's unfair to say it, but I'm in a hurry... It would be nice if i have it tomorrow night. Thank you a lot for your attention.)
Bookmarks