长期项目需深度分析，并与投资方、放贷方及合作伙伴多轮谈判。MS Excel财务模型是规划、架构与分析的核心，把预期和预测一网打尽。模型质量决定决策精度，也决定你说服各方的力度。
本在线课教你为项目搭建全套报表与指标的项目融资模型，从Excel“零”起步，拆解建模最佳实践，吃透每项技术/财务方法与指标的门道。本课程示范模型虽典型，却通杀各类场景：创业、新品、风投皆可用。掌握这套万能模板，未来项目随取随用。
课程面向有 Excel 基础的同学，不会学习电子表格或MS Excel界面的基础知识，只讲模型专用函数，随用随讲。每一步都配源文件，因此，在课程结束时，您将拥有全新的技能和完善的专业财务模型。最后一周进行结业大作业：输出你自己的融资模型。
结课后，你将能独立搭建企业/项目级完整财务模型。这些模型可直接服务投资决策、股权融资或债务筹资。
结课后，你将能独立搭建企业/项目级完整财务模型。这些模型可直接服务投资决策、股权融资或债务筹资。
该课程包括简短的视频讲座，视频时长在7至12分钟，内嵌不打分问题。 每周将有一个打分测试，和结业大作业。 学生将选择一个真实的或虚构的项目，收集必要的数据和建立一个在课堂中涉及的模板演变的模板。 最后，您将提交您的模型用于同行评估，这有助于了解金融分析师在开发金融模型时会遇到的真实场景。
该课程的目标是通过与老师讨论优秀案例以及学生在自己的项目中实践，提供投资项目财务建模的实用技能。
Long-term projects require a thorough analysis, negotiations with investors, lenders, and partners. The financial model in MS Excel is the most important tool for planning, structuring, and analysis of a project. Here you pull up and summarize all available information on your expectations and forecast. Quality of your model defines the precision of your decisions and your ability to convince the other participants of the project.
In this online-course you will learn how to build for your project a financial model with all reports and ratios that used in project finance. We will go through the path from a blank Excel workbook, discuss the best practice for financial modeling, dig into technical and financial aspects of the methods and ratios that we use in the model. Within the course we will work with a typical project finance model, but this model has a wide range of possible applications. The same structure and principles could be used for any project to create a new business, launch a product or for venture investments. You will see that the approach we use is universal and the model we build in the course can be your template for many future projects.
The course is aimed at students with some experience in Excel. We will not be learning the basics of spreadsheets or MS Excel interface, but all special functions and services will be presented and explained before we use them in our model. All stages the development of the model will be supplemented with Excel files, so by the end of the course you will have both new skills and ready professional financial models. During the last week of the course you will develop your capstone project – your own financial model.
After the HSE course, students will have necessary knowledge and skills to build a fully-fledged financial model for a project or a company. The model can be used to support investment decisions, raise capital or apply for debt financing
The course consists of short video lectures, 7 to 12 minutes long, with embedded non-graded questions. Each week there will be a graded test, a and a final exam – capstone project. Students will choose a real or fictious project, collect necessary data and build a model from a template provided here. Finally, you will be required to submit your model for peer evaluation. It gives them a taste of what financial analysts go through in real life when developing a financial model.
The goal of the course is to provide practical skills in financial modelling of investment projects by discussing best practice with the teacher as well as students work on their own projects.
