## Rogers State University Pixley Award 5-12-2018

...

From David Johnk

...

From David Johnk

Rogers State University May 2018 Commencement Pixley Award winner David W. Johnk...

From David Johnk

Formulate and Solve a Complex Linear Programming problem on Excel using Solver. Link to file used in this video: https://bit.ly/2qZvk6g...

From David Johnk

Use Excel solver to quickly solve a linear programming problem, no need to use lingo or some other program! Link to excel file used for this video: https://bit.ly/2HH4iKB...

From David Johnk

Minimize cost on a scheduling problem using Excel Solver. File used in video: https://bit.ly/2HwEuRj...

From David Johnk

There are two methods of calculating the Profitability Index (PI). One calculation assumes the decision rule is if the PI is greater than 1 you accept the project, another method assumes if the PI is greater than 0 you accept it. This video demonstrates...

From David Johnk

Linear Forecasting using control charts on Excel...

From David Johnk

Liquidity Premium Theory, Unbiased Expectations Theory problem solved on Excel...

From David Johnk

Using the Excel PV function to find the Present Value of two ordinary annuities...

From David Johnk

How to calculate the number of payments on a credit card using Excel and the math formula...

From David Johnk

...

From David Johnk

Use Excel and the ROE Dupont Analysis to calculate the Sustainable Growth rate from the Debt Ratio, Capital Intensity, Profit Margin and Dividend Payout....

From David Johnk

Demonstrates the Maximin, Maximax, Laplace and Minimax Regret methods on Excel...

From David Johnk

Calculating the profitability index (PI) on Excel. Additionally this video briefly explains the net present value (NPV) and internal rate of return (IRR) Excel functions....

From David Johnk

Use Excel to demonstrate portfolio optimization using two stocks. Subjects include benefits of diversification, Markowitz, efficient frontier, minimum variance portfolio, portfolio risk, portfolio return....

From David Johnk

In this video I demonstrate how to use "Multiple Stock Quote Downloader", a useful Excel file from the website investexcel.net. This file enables one to extract from finance.yahoo.com historical data of multiple securities simultaneously....

From David Johnk

Calculating the Future Value (FV) of uneven cash flows using two methods on Excel (FV and NPV)...

From David Johnk

Calculate the present value of a payment made in the future and move cash flows from one year to another using Excel, financial equations, and the BAII calculator....

From David Johnk

How to create Cash flow diagrams (time lines), compute the future value of money, and demonstration of the power of compound interest using Excel...

From David Johnk

What-if analysis of different corporate capital structures using Excel, scroll-bar form control, and data tables....

From David Johnk

Three ways to calculate Beta on Excel using historical data from Yahoo finance....

From David Johnk

How to calculate the yield to call on a callable bond using Excel and the Texas Instruments BAII calculator. (Recorded with http://screencast-o-matic.com)...

From David Johnk

Advanced yield curve calculations based on the unbiased expectations theory. Example uses Solver on Excel and the BAII calculator....

From David Johnk

Linear Programming mimimization using Excel (Recorded with http://screencast-o-matic.com)...

From David Johnk

Classifying A, B, and C inventory using Excel...

From David Johnk

Using Excel to calculate the expected value, standard deviation, and coefficient of variation of a discrete probablity distribution of EPS values in Finance....

From David Johnk

Captial Structure analysis - comparing debt ratios and EPS and ROE on excel (Recorded with http://screencast-o-matic.com)...

From David Johnk

Calculates the Present Value (PV) of both an ordinary annuity and an annuity due on Excel and on the HP12C....

From David Johnk

Cost and Crashing trade-offs using PERT anaysis and AOA network diagram on Excel...

From David Johnk

Calculating the Optimal run or order size using Excel...

From David Johnk

A-B-C classification of inventory using Excel...

From David Johnk

Using the CAPM to calculate the portfolio return on Excel...

From David Johnk

FV of uneven cash flows using excel and both beginning and ending period deposists....

From David Johnk

...

From David Johnk

...

From David Johnk

...

From David Johnk

Use Excel, the equation, and the HP12C to compare two different investments with different compounding periods...

From David Johnk

Finding the Future Value (FV) using different compounding periods on Excel...

From David Johnk

4 methods of calculating the future value of a lump sum....

From David Johnk

Solving chapter 3 problem 5 using Lingo...

From David Johnk

...

From David Johnk

...

From David Johnk

Linear Programming using graphical method with matrix algebra on Excel and the Excel Solver method...

From David Johnk

Production and Operations problem 12-6 A material requirements plan using lot-for-lot ordering on Excel...

From David Johnk

How to Calculate the Payback Period and the Discounted Payback Period on Excel...

From David Johnk

Calculating the Expected Portfolio Return on Excel Here's the link to the Excel file: http://bit.ly/1DqZhLr...

From David Johnk

Calculating the expected return, standard deviation, and coefficient of variation of a security which has a discrete probablility distribution using three methods on Excel. Here's the Excel file: http://bit.ly/1zfggeI...

From David Johnk

Changing the axis scaling, inserting axis titles, saving a template...

From David Johnk