About

This page contains computer files and source code (Excel, Python scripts, Jupyter notebooks, etc) that are covered in class.

EngFinancialPy Python Module

This Python Module contains all the Class and Function definitions used by all the Python code and Jupyter notebooks covered in class.

 

How to use:

1. Download the Latest Source Code
2. Unzip the file and copy EngFinancialPy.py to the working directory or folder where you save and execute your .py or .ipynb files.
3. Use apporpiate import statements in your code to access the names in the module you want to use.
4. No pip or conda install needed.
5. See User Guide for documentation and examples from the lecture notes.

Chapter 2: Time Value of Money

Excel Files

• 2.4.3 Example on Finding interest rate using Excel Goal Seek
• 2.6.2 Excel file for Interest Annunity Factors Calculator

Python Code and Jupyter Notebooks

• 2.2 Equivalent values of discrete cash flows examples
• 2.2.9 Equivalent values of Geometric series cash flows
• 2.4.3 Find interest rate using equation solver
• 2.5 Continuous compounding of discrete cash flows
• 2.8 Compute interest factors
• 2.8 Draw cash flow diagrams
• 2.8 Geometric series cash flows analysis

Chapter 3: Financial Analysis of Single Project

Excel Files

• 3.2.2 Apartment building development problem
• 3.3.1 Finding IRR using Goal Seek
• 3.4 Discounted payback period example
• 3.5.2 Airport expansion problem - Conventional BC ratio
• 3.5.3 Airport expansion problem - Modified BC ratio
• 3.6 Using Excel financial functions for project evaluation

Python Code and Jupyter Notebooks

• 3.2.2 Capital Recovery amount
• 3.3.1 Find IRR using Root function
• 3.3.1 Find multiple IRRs using root function
• 3.7.2 Financial analysis of ABC Company
• 3.7.2 Financial analysis of XYZ Company
• 3.7.2 Financial analysis of Charlie Company
• 3.7.2 Financial analysis of Airport expansion using B/C Ratio methods

Chapter 4: Financal Decision on Multiple Projects

Excel Files

• 4.2 Fundametal principles of projects evaluation
• 4.3.1 Projects evaluation - Equivalent Worth methods
• 4.3.2 Projects evaluation - IRR method
• 4.3.3 Projects evaluation - BC ratio method
• 4.4 Projects evaluation - Repeatability assumption
• 4.5.1 Evaluation of investment projects - Co-termination assumption
• 4.5.2 Evaluation of cost projects - Co-termination assumption

Python Code and Jupyter Notebooks

• 4.3.1 Investment projects with equal lives equivalent worth methods
• 4.3.1 Cost projects with equal lives equivalent worth methods
• 4.3.2 Investment projects with equal lives IRR method
• 4.3.2 Cost projects with equal lives IRR method
• 4.3.3 Investment projects with equal lives B/C ratio methods
• 4.4.1 Investment projects with unequal lives Repeatability assumption
• 4.4.2 Cost projects with unequal lives Repeatability assumption
• 4.5.1 Investment projects with unequal lives Cotermination and reinvestment assumptions
• 4.5.2 Cost projects (Forklift) with unequal lives Cotermination assumption
• 4.5.2 Cost Projects (Pump selection) with unequal lives Cotermination assumption

Chapter 5: Understanding Key Project Uncertainties

Excel Files

• 5.2 One-way range sensitivity analysis - tornado and spider diagrams
• 5.3 Break-even Analysis example (auto vs manual machine)
• 5.4 Decision reversal and Critical factors analysis

Python Code and Jupyter Notebooks

• 5.2 One-way range sensitivity analysis with Tornado and Spider diagrams
• 5.3 Break-even analysis with rainbow diagrams
• 5.4 Decision reversal and Critical factors analysis

Chapter 6: Project Risk Analysis

Excel Files

• 6.5.2 Monte Carlo simulation with Excel built-in functions
• 6.5.4 Monte Carlo simulation with @Risk
• @Risk Software (Trial version available)

Python Code and Jupyter Notebooks

• 6.5.3 Monte Carlo Simulation example

Chapter 7: Financial Analysis with Depreciation and Taxes

Excel Files

• 7.2 Classical Depreciation Methods
• 7.4.6 After-tax cash flow analysis of projects (useful ATACF templates here)
• 7.5.2 After-tax cash flow risk analysis under uncertainty

Python Code and Jupyter Notebooks

• 7.4.6 After-tax cash flow analysis 1-Year captial allowance
• 7.4.6 After-tax cash flow analysis 3-Year captial allowance

Chapter 8: Capital Assset Replacement Analysis

Excel Files

• 8.2 Principles of replacement analysis
• 8.3.1 to 8.3.3 Economic service life of new asset - Conventional EUAC
• 8.3.5 Economic service service life of new asset - Total marginal costs method
• 8.4.3 Replacement analysis infinite study period defender's TC not monotonic
• 8.4.4 Replacement analysis infinite study period defender's TC monotonic
• 8.5.1 Replacement analysis finite study period

Python Code and Jupyter Notebooks

• 8.3.5 Economic service life of new assset (Machine A)
• 8.3.5 Economic service life of new forklift truck
• 8.4.3 Replacement analysis Infinite horizon Defender's TC values is not monotonically non-decreasing
• 8.4.4 Replacement analysis Infinite horizon Defender's TC values is monotonically non-decreasing
• 8.5.1 Replacement analysis under finite horizon
• 8.5.2 Replacement analysis under finitie horizon - Dynamic Programming

Chapter 9: Basic Cost Estimation Techniques

Excel Files

• 9.4 Power sizing techniques
• 9.5 Learning and improving
• 9.6.1 Linear regression method
• 9.6.2 Multiple linear regression

Python Code and Jupyter Notebooks

• 9.5 Learning Curve model
• 9.6.1 Single variable Linear Regression (matrix form)
• 9.6.2 Multiple variables Linear Regression (matrix form)