Finance Fundamentals: Project Evaluation with NPV
4.5 (77 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,767 students enrolled

Finance Fundamentals: Project Evaluation with NPV

An Introduction to Finance, Cash Flows, and Project Evaluation
4.5 (77 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,767 students enrolled
Created by Minh Pham
Last updated 3/2018
English
English [Auto-generated]
Current price: $76.99 Original price: $109.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.
Requirements
  • Basic Mathematics, as we will be playing with numbers :)
  • Basic computer skills
  • Microsoft Excel for Building Financial Models
  • Pen and Paper for Calculation Exercises (or Tablet and Stylus)
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

    

Who this course is for:
  • Anyone that wants to improve or gain finance knowledge and skills
  • Anyone that wants to understand how Project are evaluated from a financial perspective
  • Anyone interested in financial modelling
  • Anyone interested in learning how to calculate items such as present value, free cash flow, depreciation, terminal value, NPV, IRR, or payback periods.
  • This is an Introductory Course. No prior knowledge in finance is required.
Course content
Expand all 29 lectures 03:06:08
+ Introduction
2 lectures 05:25

Quick overview of what we will be covering throughout this course.  

Course Equations that will be covered in this course are attached as a downloadable resource below. 

Preview 03:00
+ Time Value of Money and Present Value
6 lectures 30:09
Present Value
03:44
CALCULATION EXERCISE: Present Value
03:02
CALCULATION EXERCISE: PV of Multiple Cash Flows 1
10:00
Net Present Value
04:56
+ Calculating Free Cash Flow
6 lectures 24:22
Free Cash Flow - An Introduction
06:32
Depreciation
02:37
CALCULATION EXERCISE: Depreciation, Book Value, and Gain on Sale
06:53
Pro-Forma Financial Statements
02:38
GUESS WHO: Intangible Assets? Are they worth anything?
02:42
Calculating Free Cash Flow
03:00
+ Evaluating Projects with Limited Life-Span
4 lectures 46:30
CALCULATION EXERCISE: Project I-Scream Net Present Value
19:47
Case 1 Introduction
01:22
EXCEL EXERCISE: Case 1 Project with Limited Life-Span
22:52
+ Terminal Value
2 lectures 15:40
Terminal Value
06:18
CALCULATION EXERCISE: Bob and his online Business
09:22
+ Evaluating Project with Unlimited Lifespan
4 lectures 44:40
Excel EXERCISE: Project Melange - Calculating NPV
21:32
EXCEL EXAMPLE: Project Melange - Sensitivity Analysis using Data Tables
10:09
EXCEL EXAMPLE: Project Melange - Goal Seek and Break-Even Analysis
09:16
+ BONUS: Diving a little Deeper
4 lectures 18:45
Internal Rate of Return & Payback Periods
05:03
CALCULATION EXERCISE: Payback Periods - Gym
05:55
What is my risk?
05:29
Mid-Year Discounting Adjustment
02:18