
Assess capital budgeting risk using time value of money tools like net present value and internal rate of return, comparing projects by expected value and risk.
Explore how capital budgeting balances expected value and risk by using mean, population variance, standard deviation, and coefficient of variation; practice problems clarify ebita as a stock risk measure.
Adjust discount rates to reflect project risk when evaluating capital budgeting decisions. Apply risk-based cost of capital and hurdle rates, and compare net present value and internal rate of return.
Explore how Monte Carlo simulation models forecast capital budgeting outcomes using NPV and IRR, handling uncertain future cash flows with random inputs and what-if analyses.
Explore how long-term capital projects affect portfolios, emphasizing diversification, correlation, and risk reduction to optimize return for a given risk level.
Explore standard deviation, variance, and coefficient of variation through data sets, mean calculations, and population versus sample concepts, using one note and Excel for visual analysis.
Learn to compute standard deviation, variance, and coefficient of variation to project future outcomes, using an advertising campaign with expected value and inventory implications.
Learn to compute expected value, population variance, standard deviation, and coefficient of variation from a probabilistic sales scenario, using percent weights to inform budgeting, inventory, and production decisions.
Apply expected value, standard deviation, and coefficient of variation to a corporate finance budgeting scenario. Calculate mean, variance, and coefficient of variation for forecasting inventory needs.
Compare three investment alternatives using the coefficient of variation to evaluate expected value and risk, projecting returns across not good, good, and very good scenarios.
Apply the coefficient of variation to compare investment risk using expected return and standard deviation. Rank options by risk and assess whether higher returns justify higher risk in investment decisions.
Compare two project alternatives using the coefficient of variation, linking variance, standard deviation, and expected value from cash flow probabilities.
Explore capital budgeting using expected value and net present value with even five-year cash inflows, and evaluate project viability at a 14% cost of capital.
Compare two investment options using expected value and coefficient of variation to balance return and risk. Learn to compute variance and standard deviation for portfolio-level risk assessment.
Analyze capital budgeting decisions with expected value under uneven payments, applying net present value and internal rate of return to compare scenarios.
Apply capital budgeting with expected value across multiple years and net present value calculations. Model cash flows under low, average, and high scenarios, discount to present value, and assess variation.
Learn to calculate and interpret standard deviation, variance, and coefficient of variation with Excel, including population data, mean, practice problems, and cross-dataset comparisons.
Apply expected value, standard deviation, and coefficient of variation to future projections using an Excel practice problem, linking probability scenarios to sales outcomes.
Apply Excel to calculate expected value, standard deviation, and coefficient of variation for capital budgeting scenarios using forecasted outcomes and probabilities in corporate finance.
Compute the expected value, standard deviation, and coefficient of variation for three outcomes—bad, good, very good—using Excel with probabilities 30%, 50%, and 20%.
Explore three investment alternatives using the coefficient of variation in Excel, calculating expected value, variance, and standard deviation to assess risk and compare returns.
Compute the coefficient of variation as standard deviation divided by the expected return to compare five investment options on risk and return using Excel.
Use Excel to analyze capital budgeting with expected value and net present value for an investment with even yearly inflows over five years, and estimate IRR to compare projects.
Compare investment options using expected value and the coefficient of variation in an Excel-based practice problem, weighing returns, risk, and portfolio fit.
Use excel to calculate the expected value and net present value for capital budgeting with uneven payments, using scenarios, probabilities, inflows, and upfront outflows, and the internal rate of return.
Apply capital budgeting techniques in Excel to compute expected value and net present value from year-by-year cash flows, including upfront outflows and later inflows.
This course will cover the use of risk assessment tools as they relate to capital budgeting and investment decisions and how to use them.
We will include many example problems, both in the format of presentations and Excel worksheet problems. The Excel worksheet presentations will include a downloadable Excel workbook with at least two tabs, one with the answer, the second with a preformatted worksheet that can be completed in a step-by-step process along with the instructional videos.
When making long term investment and capital budgeting decisions we need to consider the time value of money. The decision-making process will estimate future cash flows and then apply our time value of money concepts to those future cash flows.
This course will take a step back in the process, providing tools to best estimate the future cash flows. To make the best decision we will need to estimate what the future cash flows will be and the likelihood of those cash flows, giving us numbers we can apply present value concepts to while also taking into consideration risk.
To help measure risk, the course will use statistical tools including the population mean, population variance, standard deviation, and coefficient of variation.
We will provide a quick overview of these statistical concepts in general and then consider how we can apply them to measuring risk for investment and capital budgeting decisions.