Project Finance and Excel - Build Financial Models from Scratch - Cash Flow Waterfall and CFADS Computation

The video tutorial guides viewers through creating and completing a cash flow statement in Excel. It covers setting up the template, adding line items, and calculating key metrics like CFADS, interest, and principal repayment. The tutorial also explains how to adjust dividends based on net profit and cash flow availability, ensuring no overpayment to investors. Finally, it demonstrates how to finalize the cash flow statement by adjusting for cash in hands and net cash flow, ensuring the statement is fully functional and accurate.

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF