Basic program for doing capital budgeting analysis investment portfolio proposal template inclusion of opportunity costs, working capital requirements, etc. Calculates the implied risk premium in a market.
Introduction to time value concepts, such as present value, internal rate of return, etc. Basic spreadsheet for deciding to buy or lease a car. Explains Internal Rate of Return, compares projects, etc. Demonstrates inflation and real rates of return. Cash flow worksheets – subsidized and unsubsidized. Spreadsheet for calculating optimal capital structures using different percents of debt. Calculation of Weighted Average Cost of Capital using beta’s for equity.
Generate a set of financial statements using two input sheets – operational data and financial data. Calculates the value or price of a 25 year bond with semi-annual interest payments. Analyzes the effects of combining two companies. Walks through a valuation of cash flows under three models- capital cash flows, equity cash flows, and free cash flows. Spreadsheet model for generating projected financials along with valuation based on WACC. Calculates a standard set of ratios based on input of financial data. Calculates expected return on stock and value based on no growth, growth, and variable growth.
Simplified Cash Flow Return on Investment Model. Add on tool for Excel 97, consists of 6 files. Analysis and simulation add on for excel, self extracting exe file. Excel add on for the pricing of options.
32Cash Flow Matrix – Basic cash flow model. Pricing and breakeven analysis for optimal pricing – Biz Pep. Excel workbook for creating 25 key performance ratios. Discounted Cash Flow Analysis from the book Analysis for Financial Management by Robert C. Historical Financial Statements from the book Analysis for Financial Management by Robert C. 47Balanced Scorecard – Set of templates for building a balanced scorecard.
52Excel Workbook 1-2 – Set of worksheets for evaluating financial performance and forecasting – Supplemental Material for Short Course 1 and 2 on this website. 56Assessment Templates – Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model. 57Cash Gap in Days – Spreadsheet for calculating number of days required for short-term financing. 58Cash Flow Template – Simple cash flow model with explanations of each cash flow component – Arkansas Small Business Development Center. 62Capital Budgeting Workbook – Several examples of capital budgeting analysis, including the use of Solver to select optimal projects.
Set of present value tables written in rich text format, compatible with most word processors. Includes examples of how to use present value tables. 66What If Analysis – Set of templates for sensitivity analysis using financial inputs. 1 – Basic spreadsheet illustrating competitive analysis – Business Tools Templates. 2 – Basic spreadsheet illustrating competitive analysis – Business Tools Templates.
73Project Plan – Project Scheduling Template currently setup for a Balanced Scorecard Project. 75E O Q Model – Simple Inventory Models for calculating Economic Order Quantity. 77Financial Projections Model – A comprehensive financial model for forecasting a complete set of financials with breakeven and valuation tabs developed by Frank Moyes and Stephen Lawrence at Leeds School of Business. 87Project Management Tool Kit – Collection of useful templates for managing projects – Michael D.
100Breakeven Forecasting Model – A clean and contemporary spreadsheet tool for easily forecasting breakeven. 108Real Estate Investment Analysis – Workbook example developed by Dr. Caroline Woolard, cherry wood, poplar, oil paint, 72″ x 15″ x 15″, 2017. Caroline Woolard, app, installation, dimensions variable, 2015. Caroline Woolard, Rhino sketch for 3D printing, 2016. Caroline Woolard, steel, poplar, study center materials, plexiglass, dimensions variable, 2016. Caroline Woolard, turned poplar, oil paint, dimensions variable, 2016.