David Johnk
6.78K subscribers
0:35
Calculate the Payback Period in 30 seconds!
David Johnk
1.1K views • 2 months ago
2:01
Calculate the Payback Period on Excel
David Johnk
195 views • 2 months ago
13:44
Turn Your Master's Into Gold: Excel's Future Value Magic
David Johnk
128 views • 2 months ago
8:53
Unlocking TIPS: Calculate Total Return Like a Pro!
David Johnk
188 views • 3 months ago
12:17
Avoid Costly Mistakes: Master Discounted Cash Flows using PB and DBP on Excel
David Johnk
95 views • 3 months ago
11:16
How to do multiple regression on Excel for forecasting.
David Johnk
381 views • 3 months ago
6:41
Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.
David Johnk
254 views • 4 months ago
27:20
How to Show your Work on the Mini-cases
David Johnk
175 views • 5 months ago
36:39
How to show your work on Excel
David Johnk
292 views • 6 months ago
19:21
Linear Programming Sensitivity Analysis on Excel
David Johnk
785 views • 8 months ago
23:13
Calculate a binomial interest rate tree from par values using Excel.
David Johnk
1.2K views • 1 year ago
17:18
Calculate the value of a capped, floating coupon rate bond. CFA fixed income study material.
David Johnk
453 views • 1 year ago
15:42
Maximize Profit with tiered profits depending on quantity
David Johnk
403 views • 1 year ago
11:12
Calculate Initial Assessment with CAMELS rating
David Johnk
898 views • 1 year ago
12:28
Calculate spot rates from par rates using Excel
David Johnk
3.3K views • 1 year ago
11:24
Easily calculate Beta using historical stock data on Excel
David Johnk
510 views • 1 year ago
14:44
Calculate the holding period return of a bond using Excel. CFA study material
David Johnk
910 views • 1 year ago
6:01
Minimize Shipping Costs on Excel
David Johnk
3K views • 1 year ago
18:58
How to submit your Excel homework
David Johnk
189 views • 1 year ago
0:43
My Tesla saved our lives!
David Johnk
336 views • 1 year ago
13:09
Test for randomness on Excel using the up/down or median runs test.
David Johnk
2K views • 1 year ago
21:58
Excel Lambda functions which easily calculate portfolio expected return and standard deviation
David Johnk
1K views • 1 year ago
4:55
Easily make a Lambda function that calculates MSE
David Johnk
336 views • 1 year ago
17:22
Use Excel to calculate MSE, MAD, SSE, tracking signal, and control limits on forecasts.
David Johnk
2.3K views • 1 year ago
13:05
Simple linear regression with forecast adequacy calculations on Excel
David Johnk
291 views • 1 year ago
23:33
Calculate centered moving average and SA method seasonal relatives on Excel.
David Johnk
2.3K views • 1 year ago
13:28
Calculate the standard deviation and expected value of a discrete probability distribution on Excel
David Johnk
569 views • 1 year ago
11:20
Excel and Monte Carlo to demonstrate the birthday paradox
David Johnk
1.4K views • 2 years ago
17:28
Create a new Excel function that easily calculates returns using the Lambda function.
David Johnk
418 views • 2 years ago
14:44
Create a new function on Excel called Net Future Value (NFV) using the new Excel Lamba function.
David Johnk
885 views • 2 years ago
Load More