![]() Then this is actually your biggest issue (as to why things don't balance) I think: I don't know whats going on with the historical data, but something is up. For unearned revenue, the item on the SCF is not considering the change in non-current unearned revenue. Then with the capital leases I'm not sure how the $10,000 number under financing cash flows connects with what is going on on the balance sheet, seems like it doesn't. Then you have "Amortization of deferred costs" on the CF statement every year as if you are amortizing on a SL basis over 10-years, but the balance sheet items stay constant over the whole time period. Although this isn't actually affecting articulation because your BS and SCF agree on the revolver going down by $215M to -$107M. The several things I noticed: biggest issue is the revolver which you have flip flopping between positive/negative values. Check out our 15% off discount to Wall Street Prep's Financial Modeling Courses. Sign up for our financial modeling training course to learn all this and more. To get to the menu option: Alt + T + O then go to Formulas, check iterative calculations and set to 100 If you are encountering circular references when building out your model - you should go to options and make sure that iterative calculations are turned on. You can also view a separate thread on this topic. ![]() Try it and you'll see you cash balance will always equal that min cash balance plug. This will ensure you have your minimum cash balance and the revolver draws and pays down around this balance. If it's a surplus, you can sweep it or let it accumulate as a cash balance. (-) Min cash balance (plug here or in your assumptions page)įrom here, if this is negative, you get your revolver to auto draw the shortfall. (-) Mandatory Repayments (revolver isn't mandatory, only Term Loan amortizations / maturities)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |