Basic program for doing capital budgeting analysis with 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 real estate investment xls 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.