Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Finance & Accounting Finance Finance Fundamentals

Finance Fundamentals: Project Evaluation with NPV

An Introduction to Finance, Cash Flows, and Project Evaluation
Rating: 4.1 out of 54.1 (102 ratings)
2,855 students
Created by Minh Pham
Last updated 3/2018
English
English [Auto]
30-Day Money-Back Guarantee

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

8 sections • 29 lectures • 3h 6m total length

  • Preview02:25
  • Preview03:00

  • Preview02:37
  • Present Value
    03:44
  • CALCULATION EXERCISE: Present Value
    03:02
  • CALCULATION EXERCISE: PV of Multiple Cash Flows 1
    10:00
  • Preview05:50
  • Net Present Value
    04:56

  • 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

  • Preview02:29
  • 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
    06:18
  • CALCULATION EXERCISE: Bob and his online Business
    09:22

  • Preview03:43
  • 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

  • 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

  • Congrats :)
    00:37

Instructor

Minh Pham
Minh Pham
  • 4.1 Instructor Rating
  • 102 Reviews
  • 2,855 Students
  • 1 Course

I hold a Bachelor Degree in Engineering, and a Masters in Commerce from the University of Queensland, Australia. Since graduating (the first time), I have worked in multiple industries, including the mining sector as a reliability and project engineer, and the building sector as a HVAC and sustainability engineer.

I carried out my first professional "teaching gig" while working on a remote mine site, where I put together a training program for the tradesmen which covered the maintenance & troubleshooting of high-pressure conveyor brake systems.  It is as exciting as it sounds, but at the time it was critical, and also necessary to help our team avoid hydraulic injection injury; real nasty to endure and treat... I'll spare you the details.

After 3 years in the field, I went back to University to get my Masters in Commerce, as I had this deep desire to try and understand both the business and finance world.  

- Studying Engineering helped me understand the physical and material world.

- Studying Business helped me understand the human world, and helped me rationalized a lot of the seemingly "illogical" things big businesses tend to do. 

While at the University of Queensland, I was lucky enough to hold teaching positions at various different levels, and have taught in the following areas:

- Managerial Finance
- Corporate Finance
    - Valuations
    - Cost of Capital

In my last role at the University of Queensland, I worked as a Course Coordinator and Finance Lecturer, and was responsible for teaching cohorts of over 400 students.  During the same period I also dabbled within the Energy and Regulation Sector.  

So.. What brings me here? 

Well, for me, I wanted to be part of the online learning movement.  I am really passionate about online education, and truly believe it will be core to all our futures.  My hope is that online education will help give everyone access to the best information and education.  This I think is truly important, particularly as the cost of traditional education continues to increase.  

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.