![]() Zambeef expects, subject to additional funding to allow full implementation of the investment strategy, to double its Mpongwe Farm row cropping capacity, and also to deliver significantly improved production efficiency and capacity through the downstream food value chains. IFC, a member of the World Bank Group, is the largest global development institution focused on advancing economic development through supporting the private sector in developing countries. I sent you a PM.Zambeef (AIM: ZAM), the fully integrated cold chain foods and retail business with operations in Zambia, Nigeria and Ghana, is pleased to announce that is has entered into a ZMW 570 million (US$35 million) debt facility with the International Finance Corporation (“IFC”) to partially finance its USD100 investment strategy as announced on 16 June 2022. I think it's also very helpful to have separate schedules for important items, such as for the revolver, for the retained earnings account, etc. If the statement of cash flows is driven entirely by formulas connecting it to the IS/ BS, you will never have an issue where things don't balance. In general you need to get rid of anything hard coded, everything should be driven by formulas in the forecast years. So your balance sheet doesn't balance for the historical period if you use the numbers you actually have there - so that is def causing problems going forward. But this is a hardcoded number actually adding up your "total liabilities" and "total equity" accounts for 2013 gives $1,066,797 million. You have total liabilities + equity = $959M in 2013, equal to total assets. 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 |