Thanks for the great tutorial! I have a question: in the income statement you have considered only the Depreciation in the D&A line item. Shouldn't you also add the amortization (that comes from term loan's mandatory amortization)? New to financial modeling. So any help is appreciated.
That is correct. Thank you for pointing this out, Iris. "Net working capital" should be tied to revenue (as a percentage) and the "change in net working capital" (which hits the CF statement) should be the delta between the current year's "net working capital" and that of the previous one.
There are some problems that If I link the total interest (after debt schedule) to P&L, because Initial Net incom creates Pre-revolver cashflow uses to calculate RCF interest , then you use this RCF interest back to P&L- it will change again Pre-revolve and then RCF interest, that is not correct due to the cause-effect relationship, excel cann't understand.
@@financialmodelingtutorials7906 I had the same problem. But when i enabled iterative calculation, the total interest payment value changes and the overall CF also gets modified. How can i fix this?
Thank you for the excellent tutorial. Would also like to see one that includes a purchase price allocation exercise.
Thank you very much !!!! Waiting for more
Thank you for your comment, Murtuza. More coming soon. Any particular subject you are interested in?
@@financialmodelingtutorials7906 Geia sas, yes an M&A model with IS analysis, AVP, DCF, premium analysis. Euxaristo
Thank you so much
Thanks for the great tutorial! I have a question: in the income statement you have considered only the Depreciation in the D&A line item. Shouldn't you also add the amortization (that comes from term loan's mandatory amortization)? New to financial modeling. So any help is appreciated.
Hi, capital repayments are not indicated on an income statement.
The change in NWC does not add up. in 2019, the NWC was 10 and in 2020 the NWC is 10.5 which would imply a DELTA(NWC) of 0.5 right? min 15-16
That is correct. Thank you for pointing this out, Iris. "Net working capital" should be tied to revenue (as a percentage) and the "change in net working capital" (which hits the CF statement) should be the delta between the current year's "net working capital" and that of the previous one.
Why is mandatory loan amortization CFO? Shouldn't it be CFF?
how do you download the excel file
Sir waiting for more videos
Hey Yogeshm - thank you for your comment. Any particular preferences?
There are some problems that If I link the total interest (after debt schedule) to P&L, because Initial Net incom creates Pre-revolver cashflow uses to calculate RCF interest , then you use this RCF interest back to P&L- it will change again Pre-revolve and then RCF interest, that is not correct due to the cause-effect relationship, excel cann't understand.
allow circular iterations in settings that might resolve the problem
What Gaurav mentioned is correct. Go to excel options--> formulas--> and make sure "enable iterative calculation" is on
@@financialmodelingtutorials7906 I had the same problem. But when i enabled iterative calculation, the total interest payment value changes and the overall CF also gets modified.
How can i fix this?
How can I download the excel file
Got it