Finance Fundamentals: Project Evaluation with NPV

Rating 4.6 out of 5 (117 ratings in Udemy)

What you'll learn

Learn how to Build a Simple Financial Model in Excel
Be able to calculate the Net Present Value (NPV) for a Project and apply the NPV decision criterion to accept or reject the project on a financial basis.
Develop a Pro-Forma Income Statement from a set of Project Assumptions
Carry out Scenario Analysis on their model using Microsoft Excel's Data Tables and Goal Seek Function
Carry out Scenario Analysis with Excel's Data …

Rating 4.6 out of 5 (117 ratings in Udemy)

What you'll learn

Learn how to Build a Simple Financial Model in Excel
Be able to calculate the Net Present Value (NPV) for a Project and apply the NPV decision criterion to accept or reject the project on a financial basis.
Develop a Pro-Forma Income Statement from a set of Project Assumptions
Carry out Scenario Analysis on their model using Microsoft Excel's Data Tables and Goal Seek Function
Carry out Scenario Analysis with Excel's Data Tables and Goal Seek function
Calculate Free Cash Flow of a Project from Scratch
Understand the Time Value of Value
Understand the role and purpose of Net Present Value
Apply Mid-Year Discounting
Calculate the Terminal Value or Continuing Value for a Project
We will be doing plenty of hand calculations to illustrate the mechanics of the formula, before diving into Excel Spreadsheet to tackle the more in depth exercises.

Description

This is an introductory course designed for people who would like to gain a better understanding of how financial theory is used in project and business evaluation.

By the end of this course, you will be able to take your project/business ideas, and translate them into a simple financial model which will help you decide if the project is financially sound.

If you come from a non-finance background, but would like to learn finance fundamentals, as well as understand what is required to build a simple financial model in Microsoft Excel, then this is the course for you. I give you all the excel templates and exercise questions so that you can follow along. After all, learning by doing is the best approach to make the information stick!

The focus of this "Finance Fundamentals" course will be Project Evaluation with Net Present Value. You do not need to have any prior knowledge, and I have tried my best to structure the course so that the material builds logically on each other. We will start by looking at the time value of money concept, before moving onto simple present value type calculations. After this, we will look more closely at Net Present Value as a capital budgeting decision tool. I will then walk you through how to develop a simple pro-forma income statement so that you can estimate the Free Cash Flows for your own project.

Throughout the course, I use a combination of slides, calculation type questions, and excel exercises to help cement your understanding of the subject matter. All templates are provided so that you can follow along, and get the most out of the material.

Course outline:

Time Value of Money
Present Value and Discounted Cash Flow Analysis
Net Present Value
Calculating Free Cash Flows
Depreciation
Pro-Forma Income Statements
Calculating Terminal Value / Continuing Value
Discounting Adjustments
Looking at Risk
Brief overview of Internal Rate of Return (IRR) and Payback Periods

I will be trying my best to continual improving the course as time goes on, by adding more exercises and solution videos to the course.

Feel free to message me any questions you may have about the course. I will try my best to answer them as promptly as I can. I hope to see you inside :)

Thanks Everyone

Minh

Duration 3 Hours 58 Minutes

Paid

Self paced

Beginner Level

English (UK)

2933

Rating 4.6 out of 5 (117 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.