Posts by: Guest 1
Finance 101: DDM?
Hi Hamilton, you mentioned that the DDM is a theoretical model not usually used by investment banks. What cash flows do investment banks typically use then and how do you attain them? Also, I was wondering what the difference between the coupon and YTM rate is? Does the coupon rate simply not ... Read More
Hi Hamilton, you mentioned that the DDM is a theoretical model not usually used by investment banks. What cash flows do investment banks typically use then and how do you attain them? Also, I was wondering what the difference between the coupon and YTM rate is? Does the coupon rate simply not ... Read More
calculating CHANGE in N.W.C , why monthly and not annual?
Question: in PACKAGE 2 "Basic FM and DCF"...........Free Cash Flow Calculation "video" why was the Change in NWC calculated on a monthly basis and not on annual basis (cell I14, tab: DCF (simple) in HRH Model Template) taking into consideration that the column is for the w... Read More
Question: in PACKAGE 2 "Basic FM and DCF"...........Free Cash Flow Calculation "video" why was the Change in NWC calculated on a monthly basis and not on annual basis (cell I14, tab: DCF (simple) in HRH Model Template) taking into consideration that the column is for the w... Read More
Lost Formatting in Excel '07
I'm building the company financial model and as you can imagine it has gotten bigger than any spreadsheet I've ever created with many more references, but I wouldn't say it is a massive file. 232KB if that means anything to you. As it is a company model is has the circular reference built in, but I ... Read More
I'm building the company financial model and as you can imagine it has gotten bigger than any spreadsheet I've ever created with many more references, but I wouldn't say it is a massive file. 232KB if that means anything to you. As it is a company model is has the circular reference built in, but I ... Read More
Balance Sheet Not Balancing
I'm having a hard time understanding how to balance my model in the balance sheet. For example, taking the completed core fundamental model of the WMT example I took that model as a template to use in valuing another company. In the B/S I added a line item in current liabilities which balances in ... Read More
I'm having a hard time understanding how to balance my model in the balance sheet. For example, taking the completed core fundamental model of the WMT example I took that model as a template to use in valuing another company. In the B/S I added a line item in current liabilities which balances in ... Read More
RE: Finance 101: DDM?
Hello! I've two questions regarding this module. 1) In the Disney example, what decide finally of whether or not to invest is to see does IRR beat the project-specific WACC. My question is: will it be possibe that IRR and NPV do not agree in the decision of investment, coz I recall from Corpora... Read More
Hello! I've two questions regarding this module. 1) In the Disney example, what decide finally of whether or not to invest is to see does IRR beat the project-specific WACC. My question is: will it be possibe that IRR and NPV do not agree in the decision of investment, coz I recall from Corpora... Read More
Projected balance sheet challenge
Hi, Thank you for the great job you are doing.I am new to financial modelling,but i have alittle challenge,I have projected my income statement and balance sheet,but the balance sheet is not adding up to zero,i have a positive no as the difference for all of the projected years,this is what i hope... Read More
Hi, Thank you for the great job you are doing.I am new to financial modelling,but i have alittle challenge,I have projected my income statement and balance sheet,but the balance sheet is not adding up to zero,i have a positive no as the difference for all of the projected years,this is what i hope... Read More
Re: Balance Sheet Not Balancing
thank goodness for WST Forums! My model balances now, now I will make sure to avoid this nuance in the future. Thank you so much!
thank goodness for WST Forums! My model balances now, now I will make sure to avoid this nuance in the future. Thank you so much!
Re: taxes
Thx. And the figure that shows up on the IS as tax is the GAAP ax figure from the tax schedule?
Thx. And the figure that shows up on the IS as tax is the GAAP ax figure from the tax schedule?
Corporate Valuation Methodologies: capital lease
Hi About the capital lease, the instructor mentioned in the lecture, his view of capital lease is not very positive, it shows more debt, less efficient for the asset turnover ratios, however, capitalized also means future depreciation, you can get the tax deduction for the capital lease, perhaps ... Read More
Hi About the capital lease, the instructor mentioned in the lecture, his view of capital lease is not very positive, it shows more debt, less efficient for the asset turnover ratios, however, capitalized also means future depreciation, you can get the tax deduction for the capital lease, perhaps ... Read More
Could you please explain exactly how the figures form the tax schedule (ie DTAs, DTLs) wrap into the CF Statement.