Add-ins issue
I could not install the Add-ins as my excel prompts "not responding"

Beginning vs. Average Balance, and Diluted Shares Outstanding
1. Debt Sweep Tab, Interest Schedule, F67, in the case of Interest Income and Interest Expense, what is more commonly use, beginning balance or average balance? 2. Can you please explain again the Diluted Shares Outstanding formula (IS tab, cell I24)?

CapEx and capital lease
Shouldn't capital lease portion of CapEx be excluded from CFI calculation as capital lease by defination is funded by capital lease rather than cash?

making cash flow statement and debt sweep into a quarterly model
I am having a hard time trying to figure out how the quarterly debt sweep forecasts should tie into the annual debt sweep forecasts. For example, I think the 4q Cash Before Discretionary Debt Repayment / (Borrowing) should be the same as the fiscal year end number. Same thing with the different de... I am having a hard time trying to figure out how the quarterly debt sweep forecasts should tie into the annual debt sweep forecasts. For example, I think the 4q Cash Before Discretionary Debt Repayment / (Borrowing) should be the same as the fiscal year end number. Same thing with the different debt balances in the debt sweep, i think 4q should be the same as fiscal year end. Is there any help you can provide here? Read More

AFM Core Model: Forecasting Minority Interest
How would you forecast Minority Interest for a projected period on the Income Statement (Well also the balance sheet but that's another question) for, say, 5 years? The problem is, of the consolidated subisidiaries, there are no financial statements for the subisiary operating companies (nor any ... How would you forecast Minority Interest for a projected period on the Income Statement (Well also the balance sheet but that's another question) for, say, 5 years? The problem is, of the consolidated subisidiaries, there are no financial statements for the subisiary operating companies (nor any breakdowns of the assets and liabilities) You are only given segment break downs for revenues, EBITDA, SG&A, COGs, Other Op-ex. My initial guess was to forecast out each segment. After forecasting each segment, you would take the % of each segment's earnings (i.e. Revs-COGS-SG&A-Other) that are NOT owned by the parent and take that as the charge on the income statement (or an add back if the segments are reporting a loss). Am I on the right track? Read More