David Johnk

What age to retire? Maximize your total inflation-adjusted retirement income using Excel

Change a UNIX date to a normal date using both and Excel formula and and Excel Lambda function

Download from Yahoo Finance adjusted close price history to Excel for free; no copy-paste.

Calculate the Discounted Payback Period in 90 seconds!

Random sampling from a table of random numbers on Excel and alternate method using randarray.

Random sampling times in Excel. I recently recorded a better one here:

Workstation Balancing on Excel

How to do the StockTrak Assignments

Microeconomics: how to graph quantity supplied and quantity demanded versus price on Excel.

Calculate the weights of the minimum variance portfolio with two stocks on Excel

Graph the efficient frontier and capital allocation line for a three stock portfolio using Excel.

Two ways to download stock prices from Yahoo Finance to Excel now that it's behind a paywall.

Downloading stock prices and calculating periodic and average returns using various methods.

An intuitive method for solving a simple linear programming problem on Excel using Solver

Рассчитайте срок окупаемости в Excel

Turn Your Master's Into Gold: Excel's Future Value Magic

Unlocking TIPS: Calculate Total Return Like a Pro!

Avoid Costly Mistakes: Master Discounted Cash Flows using PB and DBP on Excel

Как выполнить множественную регрессию в Excel для прогнозирования.

Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.

How to Show your Work on the Mini-cases

How to show your work on Excel

Linear Programming Sensitivity Analysis on Excel

Calculate a binomial interest rate tree from par values using Excel.

Calculate the value of a capped, floating coupon rate bond. CFA fixed income study material.

Maximize Profit with tiered profits depending on quantity

Calculate Initial Assessment with CAMELS rating

Calculate spot rates from par rates using Excel

Easily calculate Beta using historical stock data on Excel