Financial Statements/Modelling

Project goal

The client asked me to prepare a Financial Model where he should have a model that evaluates product prices and other model aspects and can get him most of the result without spending too much time on the details like writing numbers manually, filtering, etc that can make his project finance modeling difficult. I was requested that making a relatively simple project finance model could be taught in a single day. I sat with the client and we checked the essentials of making a model including describing inputs, establishing operating cash flow, computing depreciation and project IRR, incorporating debt, making a cash flow waterfall, and computing some key financial ratios the same day when the project was offered.