|
|
This website provides learning materials for an
introduction to the philosophy and mechanics of performing financial
analyses on projects. The materials provided are designed for the
practitioner interested in learning the art and techniques of financially
assessing a project. That practitioner may be a university student just
learning the art or an employee desiring to assist their organization in
making better, informed evidenced-based decisions. The materials provided
extend beyond the topic’s conceptual introduction by providing enough “how
to” details to allow the novice to advance from little understanding of
financial analysis to being able to perform the tasks necessary to fully
assess the financial impact of proposed projects.
The materials provided combine three integrated components to accelerate the user’s learning. Those coponents are the text, videos (8) and Excel® workbooks (3). All downloadable below.
 |
Text Project Fincial Analysis (download)
o
This component is the 85-page (pdf)
pre-publication version of the book and provides the topic’s description
and learning guide. Feel free to e-mail me errata and suggestions at
TL.Faley (at) Gmail.com
o
An overview of the text is available as
the 11-page pdf of Chapter 1 (only).
<<Download Chapter 1 Only>> |
|
Videos
o
There are
eight videos videos that are referenced throughout the text. These
videos provide step-by-step instruction using Excel® to perform various
financial assessment tasks.
V2.1 Static Vs.
Dynamic Spreadsheets
V2.2
Discounting Future Values
V4.1 Project
NPV Calculations
V4.2 IRR using Goal Seek
V5.1 Project
Finical Model Building
V6.1 Tornado Diagram Input
Table
V6.2 Tornado Diagram Graphic
Creation |
|
|
Excel® Workbooks There are three downloadable Excel Workbooks (Workbook#1, Workbook#2, Workbook#3) <<Download ALL Workbooks>> All of the spreadsheets used in the videos, all the spreadsheets presented in the text, plus a number of templates that are useful as starting points for projects are included as the third learning component. These individual worksheets (19 different worksheets in total) are organized into three Excel® workbooks. All three workbooks are downloadable in a single ZIP file.
o
Excel®
Workbook #1:
The first workbook, “Project_Finance_Videos_Spreadsheet_Compilation.xls,”
includes 11 spreadsheets utilized in all the videos plus a couple of
generic templates. The inclusion of these spreadsheets allow the reader
to gain skills by working in in Excel® in parallel with the video
descriptions. The sequential tabs of that workbook are:
V2.1_Static_vs_Dynamic
V2.2_Discounting_Future_Values
V4.1_Project_NPV_Calculations
V4.2_IRR using Goal Seek
Project NPV Evaluation Template
Project Description
V5.1_Project Financial Model Building
V6.1_Tornado_Diagram Input
Tornado Diagram Template
V6.2_Tornado_Diagram_Graphic
V6.3_Success_Conditions
o
Excel®
Workbook #2:
The second Excel® workbook, “Project_Finance_Chapter_Spreadsheets_&_Templates.xls,”
includes six spreadsheets that appear in this text as well as templates
utilized as a starting place for some of the tasks described in the
text. The sequential tabs of that workbook are:
Chapter 2
Chapter 4
Project NPV Evaluation Template
Tornado Diagram Template
WACC Calculation Template
WACC_Industry Averages 2022
o
Excel®
Workbook #3:
This third workbook entitled “ACN_Free_Cash_Flow_Model_Data_0422.xls”
contains the information for Chapter 3 of the text (in four worksheets).
The first tab is a generic free cash flow model template that can be
utilized with any downloadable income statement, balance sheet, and
statement of cash flow for any firm. The workbook provides an example
using data for Accenture (ticker: ACN) that was downloaded from
http://financials.morningstar.com/income-statement/is.html?t=ACN®ion=usa&culture=en-US.
The sequential tabs of this workbook are:
ACN FCF Model
ACN Income Statement
ACN Balance Sheet
ACN Cash Flow |
|
 |
About the Author
Dr. Timothy L. Faley
is an educator, strategist, consultant, researcher and author focused on
accelerating the creation and development of new products, processes,
businesses and economies. His engineering and business career has
bridged both industry and academia. He currently holds the Kiril
Sokoloff endowed chair for entrepreneurship where he teaches innovation,
entrepreneurship and corporate finance. Prior to joining UVI, he was the
managing director of the Samuel Zell & Robert H. Lurie Institute for
Entrepreneurial Studies and adjunct professor of entrepreneurship in the
Ross School of Business at the University of Michigan.
Prior to Michigan he worked in industry in
research, new product development, new business development, financial
analyses, technology licensing, and corporate venture capital.
The Entrepreneurial Arch: A Strategic Framework for Discovering, Developing and Renewing Firms (www.entrepreneurialarch.com) The Innovation Pyramid: A Strategic Methodology for Impactful Problem Solving (www.theinnovationpyramid.com)
|
| © Timothy L. Faley 2022 |
