This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: formula results in the priority of paying off the Revolver, then Term Loan, and then the Senior Sub Notes. (Waterfall formula) Average Interest Expense Calculation =$C104*IF(B7=1, (D160+E160)/2,D160) If average interest formula trigger $C104 is turned on then multiply the interest rate by an average of this period’s debt balance and the prior period’s debt balance… Else Multiply the interest rate by last period’s debt balance. Calculation Of Fully Diluted Shares Outstanding Using Options Sample Formula: Diluted Shrs =E7+IF(E6>E9,E8E8*E9/E6,0) Logic If the options are out of the money use current shares outstanding (E7)…else use current shares outstanding (E7) + new net shares Where net new shares = number of vested options (E8) – amount of shares the firm could buyback with the exercise price proceeds (E8*E9/E6)...
View
Full Document
 Fall '08
 WEAVER
 Finance, Debt, Financial Modeling, Interest, debt balance, Optional Debt Prepayment

Click to edit the document details