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 new home sales belajar forex online 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.