Posts by: Guest 1
Complex LBO: mandatory repayment relink
A user asks: In your complex LBO course, while building the Debt Sweep we included the mandatory payments of the existing debt of the company (i.e $459m for 2005 $21m for 2006 and so on). However those nukmjbers where hard coded. At the time of building th model the instructor said to leave them ... Read More
A user asks: In your complex LBO course, while building the Debt Sweep we included the mandatory payments of the existing debt of the company (i.e $459m for 2005 $21m for 2006 and so on). However those nukmjbers where hard coded. At the time of building th model the instructor said to leave them ... Read More
a question about circular refences
The calculation of share repurchase involves circular reference? If it does and circular reference at share repurchase is not solved, what to do?
The calculation of share repurchase involves circular reference? If it does and circular reference at share repurchase is not solved, what to do?
Software for Financial Analyst
What kind of software that financial analyst usually used?
What kind of software that financial analyst usually used?
Re: Distressed Debt Model
In the Distressed Model, under the value tab. Hamilton highlighted cells O35:O42, the formulas are different from N35:N42. Can you please explain why the formulas suddenly changed? Secondly, with regards to debt reinstated or swapped out section under the value tab. Senior notes, went from 200 t... Read More
In the Distressed Model, under the value tab. Hamilton highlighted cells O35:O42, the formulas are different from N35:N42. Can you please explain why the formulas suddenly changed? Secondly, with regards to debt reinstated or swapped out section under the value tab. Senior notes, went from 200 t... Read More
Mr. Lin assumed that the diluted share outstanding in 2006 equals to that in 2005 in IS and then calculated EPS. Next, he used projected diluted EPS from IS to calculate the repurchased shares in CF and then calculated the basic shares outstanding. Next, he used the basic shares outstanding to recal... Mr. Lin assumed that the diluted share outstanding in 2006 equals to that in 2005 in IS and then calculated EPS. Next, he used projected diluted EPS from IS to calculate the repurchased shares in CF and then calculated the basic shares outstanding. Next, he used the basic shares outstanding to recalculate the diluted shares outstanding in IS. Then, the EPS in IS were recalculated. Does this cause iterating calculation / circular reference? Read More