Posts by: Guest 1
Interview Question - What would Hamilton or Dave Do?
I was hit in an interview with the question, "How would you value TiVo?" Here's the rub: the company is way out of my field. Yes, I know what a TiVo is, and I also know my cable box does the same thing. I also know I don't watch TV and have never had an occasion to use the DVR functions. S... Read More
I was hit in an interview with the question, "How would you value TiVo?" Here's the rub: the company is way out of my field. Yes, I know what a TiVo is, and I also know my cable box does the same thing. I also know I don't watch TV and have never had an occasion to use the DVR functions. S... Read More
Income Tax Payable
I just wanted to know if Income Tax payable can be lumped together as AP on the balance sheet or do we categorized it as accrued income taxes? Can you please explain? Thank you.
I just wanted to know if Income Tax payable can be lumped together as AP on the balance sheet or do we categorized it as accrued income taxes? Can you please explain? Thank you.
PIK interest and P&L/Cashflow
In the Complex LBO please confirm how you are adjusting the Cashflow for the PIK interest which should not be hitting he cash balance. It seems you are taking the whole PIK interest into the total net interest in the PL (which is correct) but then the Net Income is not adjusted in the Cashflow to ta... Read More
In the Complex LBO please confirm how you are adjusting the Cashflow for the PIK interest which should not be hitting he cash balance. It seems you are taking the whole PIK interest into the total net interest in the PL (which is correct) but then the Net Income is not adjusted in the Cashflow to ta... Read More
Re: a question about circular refences
Thank you very much for the detailed explanation.
Thank you very much for the detailed explanation.
a question about the certificat?ion
When we calculate a ratio which compares a BS account (such as receivable) with an income, we should use the average of the BS account instead of the ending balance. In the course, Mr. Lin uses the ending balance for the training purpose. For the certification of advanced financial modeling, should ... Read More
When we calculate a ratio which compares a BS account (such as receivable) with an income, we should use the average of the BS account instead of the ending balance. In the course, Mr. Lin uses the ending balance for the training purpose. For the certification of advanced financial modeling, should ... Read More
Re: Software for Financial Analyst
I'm not good on excel. Do you have a class to train on how to use excel for this particular use or I have to take excel class out?
I'm not good on excel. Do you have a class to train on how to use excel for this particular use or I have to take excel class out?
Re: Insurance financial modeling
Hi there, I took this course over a year ago. Noticed that in CF sheet Row 37 has mandatory debt (repayment) / borrowing. But this is not factored into Total Cash Available / (Required) Row 40 which feeds into the Sweep tab. My Question: Does the model allow for debt pay down? If so, how do I use... Read More
Hi there, I took this course over a year ago. Noticed that in CF sheet Row 37 has mandatory debt (repayment) / borrowing. But this is not factored into Total Cash Available / (Required) Row 40 which feeds into the Sweep tab. My Question: Does the model allow for debt pay down? If so, how do I use... Read More
RE: Modeling out pension expenses on the cash flow statement
Thanks. The company have an item in the working capital section of the CF statement "payment to Pension Fund" of negative GBP100m.
Thanks. The company have an item in the working capital section of the CF statement "payment to Pension Fund" of negative GBP100m.
Reference Range: Valuation of other industries
How are we suppose to value and build reference range inclusive of Deal comps and complex trading comps of other industries apart from retail segment.?In all of the modules the common example have been Wall mart(retail store). How about health care industry, financial industry, energy sector? How ar... Read More
How are we suppose to value and build reference range inclusive of Deal comps and complex trading comps of other industries apart from retail segment.?In all of the modules the common example have been Wall mart(retail store). How about health care industry, financial industry, energy sector? How ar... Read More
Thank you!