Project Finance and Excel - Build Financial Models from Scratch - Anatomy of a Multi-Scenario Input Sheet

This video tutorial guides viewers through the process of building a financial model from scratch using Excel. It covers setting up the Excel sheet, inputting assumptions, detailing construction and operation costs, and discussing financing and tax assumptions. The tutorial also explains how to set up a values column for scenario testing, ensuring flexibility in the model. The session concludes with a brief overview of the next steps.

What is the first step in building a financial model according to the text?

How does changing a number in Excel affect the rest of the model?

What should be included in the 'Input assumptions' sheet?

What is the significance of the 'gearing' ratio in financial modeling?

What should you do if you cannot find a necessary assumption during a financial modeling interview?

Why is it important not to hard code values in the financial model?

What are the different scenarios mentioned in the text for testing values?

What adjustments are made to limit the number of columns in the input assumptions sheet?

What is the purpose of highlighting certain cells in the input assumptions sheet?

Describe the process of importing values into the financial model.