Project Finance and Excel - Build Financial Models from Scratch - Laying Out the Debt Repayment Schedule

The video tutorial explains how to complete a P&L statement by calculating interest payments using a debt repayment schedule. It covers creating the schedule in Excel, using the PPMT function to compute principal repayments, and calculating interest payments. The tutorial also demonstrates how to implement these calculations in Excel, ensuring accurate financial modeling for debt servicing over a 40-year period.

What is the total debt drawdown amount mentioned in the text?

Explain how the principal repayment is computed according to the text.

What function is used to compute the principal repayment?

What adjustments are made to the debt repayment schedule when the project starts generating cash flows?

What happens to the outstanding debt balance as principal repayments are made?

What is the significance of the PPMT function in the context of the debt repayment schedule?

Describe the process of calculating interest payments as outlined in the text.

How does the interest payment change over the years according to the text?

How is the debt service calculated according to the text?

Summarize the overall process of creating a debt repayment schedule as described in the text.