Posts by: Guest 1
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
Data skip blank and split window toggle
Hi there,
1) i hv some quarterly data series placed vertically, i need to sum 4 quarters to get full year, how can i do it quickly if i hv over 20 years data. (using skip blank function in paste special doesn't work)
2) using split window, how can i toggle all 4 quadrants
Hi there,
1) i hv some quarterly data series placed vertically, i need to sum 4 quarters to get full year, how can i do it quickly if i hv over 20 years data. (using skip blank function in paste special doesn't work)
2) using split window, how can i toggle all 4 quadrants
Questions about total debt & preferred stock
Q1: The section of Company Overview in Package shows how to calculate total debt. In financial summary, cell F34, total debt = commercial paper+current portion of long-term debt +long-term debt. However, in cell L32, total debt/total capitalization, total debt here = F34(total debt) +preferred stock... Read More
Q1: The section of Company Overview in Package shows how to calculate total debt. In financial summary, cell F34, total debt = commercial paper+current portion of long-term debt +long-term debt. However, in cell L32, total debt/total capitalization, total debt here = F34(total debt) +preferred stock... Read More
Re: Software for Financial Analyst
I just complete the package 1, but I'm really not fully understand all the topic that cover in package 1. I am switching career from commercial real estate agent to finance. Therefore, I doesn't have any finance back ground. Can you please advise what should I do or take to catch myself. Thank y... Read More
I just complete the package 1, but I'm really not fully understand all the topic that cover in package 1. I am switching career from commercial real estate agent to finance. Therefore, I doesn't have any finance back ground. Can you please advise what should I do or take to catch myself. Thank y... 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... 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 take the PIK interest out. It looks like you are adjusting for it by decreasing the Debt Repayment amount in row 32 on the Cashflow which I think will arrive at the same result but is not all that clear if one is looking at the model printed out for example. Could it be clearer to actually include a PIK adjustment line in the cashflow somewhere? Read More