Financial Modeling - Understanding the Negative & Surplus Cash Situations скачать в хорошем качестве

Financial Modeling - Understanding the Negative & Surplus Cash Situations

Academy of Financial Training's Video Tutorials on Financial Modeling in Excel In this Session, we understand in detail the Negative and Surplus Cash situations. We learn how to reflect them on the appropriate side inside the Balance Sheet using an IF (or MIN) formula. In real life, the surplus cash is invested by a prudent businessman. Whereas negative cash has to be funded e.g. bank overdraft, cash credit, revolver facility, sponsor loans etc. We may either earn Interest Income on surplus cash invested in short term investments, or we may have to pay interest expense on such loans. Actual impact of these situations is considered in the Model through our subsequent sessions.