#### UCLqZKkIG3gGv2Wg268Ah7kQ
#### SELECT * FROM DAvidKanal WHERE `Chan` ="UCLqZKkIG3gGv2Wg268Ah7kQ"
BASE
:::::::: SELECT * FROM DAvidKanal WHERE Chan="UCLqZKkIG3gGv2Wg268Ah7kQ"
#~~~~# SELECT * FROM DAvidKanal WHERE Chan="UCLqZKkIG3gGv2Wg268Ah7kQ"
#~~~~# http://chegu.de/Ausgabe.php?URL=https://www.youtube.com/feeds/videos.xml?channel_id=UCLqZKkIG3gGv2Wg268Ah7kQ
**25288
**?xml version="1.0" encoding="UTF-8"?>
feed xmlns:yt="http://www.youtube.com/xml/schemas/2015" xmlns:media="http://search.yahoo.com/mrss/" xmlns="http://www.w3.org/2005/Atom">
link rel="self" href="http://www.youtube.com/feeds/videos.xml?channel_id=UCLqZKkIG3gGv2Wg268Ah7kQ"/>
id>yt:channel:LqZKkIG3gGv2Wg268Ah7kQ/id>
yt:channelId>LqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>David Johnk/title>
link rel="alternate" href="https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2008-08-09T15:32:01+00:00/published>
entry>
id>yt:video:Xows9b4q6Rk/id>
yt:videoId>Xows9b4q6Rk/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Calculate the Payback Period in 30 seconds!/title>
link rel="alternate" href="https://www.youtube.com/watch?v=Xows9b4q6Rk"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-03-28T16:07:07+00:00/published>
updated>2024-04-03T21:22:16+00:00/updated>
media:group>
media:title>Calculate the Payback Period in 30 seconds!/media:title>
media:content url="https://www.youtube.com/v/Xows9b4q6Rk?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i1.ytimg.com/vi/Xows9b4q6Rk/hqdefault.jpg" width="480" height="360"/>
media:description>/media:description>
media:community>
media:starRating count="2" average="5.00" min="1" max="5"/>
media:statistics views="185"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:cidRL_pdmT8/id>
yt:videoId>cidRL_pdmT8/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Calculate the Payback Period on Excel/title>
link rel="alternate" href="https://www.youtube.com/watch?v=cidRL_pdmT8"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-03-28T15:51:37+00:00/published>
updated>2024-04-04T19:47:22+00:00/updated>
media:group>
media:title>Calculate the Payback Period on Excel/media:title>
media:content url="https://www.youtube.com/v/cidRL_pdmT8?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i4.ytimg.com/vi/cidRL_pdmT8/hqdefault.jpg" width="480" height="360"/>
media:description>Easily calculate the Payback Period on Excel./media:description>
media:community>
media:starRating count="1" average="5.00" min="1" max="5"/>
media:statistics views="55"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:Us4ajHPRlJE/id>
yt:videoId>Us4ajHPRlJE/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Turn Your Master's Into Gold: Excel's Future Value Magic/title>
link rel="alternate" href="https://www.youtube.com/watch?v=Us4ajHPRlJE"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-03-05T19:30:38+00:00/published>
updated>2024-03-12T02:58:51+00:00/updated>
media:group>
media:title>Turn Your Master's Into Gold: Excel's Future Value Magic/media:title>
media:content url="https://www.youtube.com/v/Us4ajHPRlJE?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i2.ytimg.com/vi/Us4ajHPRlJE/hqdefault.jpg" width="480" height="360"/>
media:description>Discover how to leverage your Master's Degree for bigger earnings with essential Excel tricks! In this video, I dive into calculating the future value of an ordinary annuity, using the example of additional earnings from a Master's degree. Whether you're in my personal finance class or simply looking to enhance your financial acumen, this tutorial is packed with valuable insights.
**PLEASE NOTE:** While I aim for accuracy, errors can slip through. Rest assured, the core concepts and methodologies remain sound, offering you reliable knowledge to apply in your financial planning.
**What You'll Learn:**
- The basics of calculating future value in Excel
- How to apply these calculations to real-world scenarios like salary increases from advanced degrees
- Different methods for solving time value of money problems, including Excel functions, financial calculators, and manual calculations for deeper understanding
**Important Notes:**
- I demonstrate multiple approaches to accommodate various learning styles and tool preferences.
- Despite a couple of minor missteps in my walkthrough (which I candidly acknowledge), the tutorial provides a robust foundation for financial analysis and decision-making.
**Here's the link to the file I used:** (Note: Actual file link not included here)
**Accuracy and Disclaimer:** This content is for educational purposes based on historical data. No future performance guarantees can be made. Always consult with a financial advisor for personalized advice.
If you find this video helpful and wish to support further content, consider a small contribution: https://www.buymeacoffee.com/DrDavidJohnk
**CTAs:**
- Don't forget to subscribe for more insightful content on Excel, finance, and how to make your education work harder for you.
- Liked the video? Hit the thumbs up and leave a comment with your thoughts or questions!
Remember, mastering Excel for financial planning, such as portfolio optimization, expected return calculations, and understanding the variance-covariance matrix, can significantly impact your personal and professional financial outcomes. Stay tuned for more tutorials that make finance accessible and actionable. Thanks for watching!
#BiggerEarnings #DavidJohnkChannel #OperationsManagement #TimeValueMoney #CareerDevelopment
CHAPTERS:
0:00 - Time Value of Money Calculation
0:40 - Future Value Factor Table Explained
6:50 - Excel Future Value Function Tutorial
7:45 - Financial Calculator for Future Value
9:20 - Brute Force Method in Excel for Future Value
12:59 - Financial Calculator Overview
13:22 - Outro/media:description>
media:community>
media:starRating count="3" average="5.00" min="1" max="5"/>
media:statistics views="118"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:MGXD76tnLe8/id>
yt:videoId>MGXD76tnLe8/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Unlocking TIPS: Calculate Total Return Like a Pro!/title>
link rel="alternate" href="https://www.youtube.com/watch?v=MGXD76tnLe8"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-02-25T17:35:06+00:00/published>
updated>2024-02-28T04:50:02+00:00/updated>
media:group>
media:title>Unlocking TIPS: Calculate Total Return Like a Pro!/media:title>
media:content url="https://www.youtube.com/v/MGXD76tnLe8?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i2.ytimg.com/vi/MGXD76tnLe8/hqdefault.jpg" width="480" height="360"/>
media:description>Unlock the secrets of Treasury Inflation-Protected Securities (TIPS) and learn how to calculate your total return, both in dollars and percentage, like a finance pro! In this detailed tutorial, I walk you through a real-world example from the "M Finance" textbook to demystify the process using Excel. Perfect for students and investors seeking to deepen their understanding of TIPS and inflation impact on investments.
π PLEASE NOTE: In our journey to unravel the calculation mysteries, a few hiccups were encountered. I openly discuss these moments to ensure you're getting the most accurate and transparent information.
π Important Notes:
- We explore the basics of TIPS, including coupon rates, CPI adjustments, and how to calculate cash flows.
- Understand the significance of semiannual payments and how inflation affects your investment's value.
β¨ Here's what you'll learn:
- How to set up your Excel sheet for success.
- Step-by-step guide on calculating purchase price, coupon payments, and sell price.
- The easy way to determine your total dollar return and total return percentage.
π While I've strived for precision, "I found out" that errors can sneak in. Rest assured, the core concepts and calculations presented are solid and will guide you correctly. Always remember, investing involves risks and there's no guarantee of future performance. This tutorial is for educational purposes based on historical data.
πββοΈ If you found this video helpful, consider supporting my work through "https://www.buymeacoffee.com/DrDavidJohnk". Every coffee counts!
π‘ Subscribe for more content on Excel, finance essentials, portfolio optimization, expected return calculations, variance-covariance matrix, Excel Solver applications, efficient frontier mapping, Beta calculations, and investment payback period insights.
Your journey to financial literacy and Excel mastery starts here. Let's dive in and calculate those returns together!
#FinancialLiteracy #MidyearCouponPayment #FaceValue #CouponRate #ReferenceCpi
CHAPTERS:
0:01 - Introduction to TIPS
0:27 - Understanding TIPS Basics
2:55 - Calculating TIPS Cash Flows
7:00 - TIPS Total Return Analysis/media:description>
media:community>
media:starRating count="5" average="5.00" min="1" max="5"/>
media:statistics views="157"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:nrHFXQg6Jq0/id>
yt:videoId>nrHFXQg6Jq0/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Avoid Costly Mistakes: Master Discounted Cash Flows using PB and DBP on Excel/title>
link rel="alternate" href="https://www.youtube.com/watch?v=nrHFXQg6Jq0"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-02-23T17:47:58+00:00/published>
updated>2024-03-17T04:16:35+00:00/updated>
media:group>
media:title>Avoid Costly Mistakes: Master Discounted Cash Flows using PB and DBP on Excel/media:title>
media:content url="https://www.youtube.com/v/nrHFXQg6Jq0?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i3.ytimg.com/vi/nrHFXQg6Jq0/hqdefault.jpg" width="480" height="360"/>
media:description>Embark on a journey to financial mastery with Excel as your guide! In this tutorial, I delve deep into calculating the payback period (PB) and the discounted payback period (DPB), two pivotal techniques in capital budgeting analysis that can save you from costly investment mistakes. Whether you're a finance professional or just keen to enhance your Excel skills, this video is tailored for you.
π **What You'll Learn:**
- Understanding the fundamentals of payback period and discounted payback period.
- Step-by-step guide on how to leverage Excel for effective capital budgeting analysis.
- Practical example to illustrate PB and DPB calculations.
π **PLEASE NOTE:** While I strive for accuracy, the complexities of Excel and finance mean occasional errors can slip through. I candidly acknowledge any oversights, ensuring you receive reliable and authentic content. Rest assured, the essence and educational value of the tutorial remain intact, guiding you confidently through Excel's capabilities in financial evaluation.
π **Important Notes:**
- This tutorial is designed with both beginners and seasoned professionals in mind.
- A hands-on approach featuring a practical example to solidify your understanding.
- Corrections and clarifications are provided transparently, ensuring you have the most accurate information.
Support my passion for teaching finance and Excel by considering a contribution: https://www.buymeacoffee.com/DrDavidJohnk
π **Subscribe for More:** Stay ahead in the world of finance and Excel. Sharpen your skills further by joining our community for upcoming tutorials on portfolio optimization, calculating Beta, and navigating the variance-covariance matrix.
**DISCLAIMER:** This content is for educational purposes only. While every effort is made to ensure accuracy, finance and investment strategies are subject to individual circumstances and market dynamics. Past performance is not indicative of future results.
Thank you for watching, and remember, the path to avoiding costly financial mistakes is through knowledge and skill. Let's conquer Excel together!
#FinanceAnalysis #DiscountedPaybackPeriod #ExcelSkills #ExcelFinanceSkills #DiscountedCashFlows
CHAPTERS:
0:00 - Introduction to PB & DPB
1:10 - Understanding Payback Period in Excel
7:14 - Calculating Discounted Payback Period in Excel
11:58 - Conclusion on Capital Budgeting Techniques/media:description>
media:community>
media:starRating count="1" average="5.00" min="1" max="5"/>
media:statistics views="85"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:bx-q9aMz9Hs/id>
yt:videoId>bx-q9aMz9Hs/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>How to do multiple regression on Excel for forecasting./title>
link rel="alternate" href="https://www.youtube.com/watch?v=bx-q9aMz9Hs"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-01-31T20:11:30+00:00/published>
updated>2024-03-16T12:45:09+00:00/updated>
media:group>
media:title>How to do multiple regression on Excel for forecasting./media:title>
media:content url="https://www.youtube.com/v/bx-q9aMz9Hs?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i3.ytimg.com/vi/bx-q9aMz9Hs/hqdefault.jpg" width="480" height="360"/>
media:description>A quick tutorial on how to conduct multiple regression on Excel/media:description>
media:community>
media:starRating count="8" average="5.00" min="1" max="5"/>
media:statistics views="331"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:6YegRC40MNI/id>
yt:videoId>6YegRC40MNI/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative./title>
link rel="alternate" href="https://www.youtube.com/watch?v=6YegRC40MNI"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2024-01-21T16:09:09+00:00/published>
updated>2024-03-16T22:03:58+00:00/updated>
media:group>
media:title>Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative./media:title>
media:content url="https://www.youtube.com/v/6YegRC40MNI?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i3.ytimg.com/vi/6YegRC40MNI/hqdefault.jpg" width="480" height="360"/>
media:description>Financial Income statement calculations in Excel.
It involves calculating various financial metrics such as gross profits, EBITDA, Net Income, EBT, and Depreciation expense.
0:00 Intro
0:30 Problem intro
1:40 Calculate gross profits
1:50 Calculate EBITDA
2:30 Solve for Net Income
2:45 Solve for EBT using algebra
3:40 Solve for EBT using Excel Goal Seek
5:44 Solve for Depreciation expense/media:description>
media:community>
media:starRating count="4" average="5.00" min="1" max="5"/>
media:statistics views="195"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:TBXiq7VM5rU/id>
yt:videoId>TBXiq7VM5rU/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>How to Show your Work on the Mini-cases/title>
link rel="alternate" href="https://www.youtube.com/watch?v=TBXiq7VM5rU"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-12-28T15:59:06+00:00/published>
updated>2024-03-28T15:47:58+00:00/updated>
media:group>
media:title>How to Show your Work on the Mini-cases/media:title>
media:content url="https://www.youtube.com/v/TBXiq7VM5rU?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i1.ytimg.com/vi/TBXiq7VM5rU/hqdefault.jpg" width="480" height="360"/>
media:description>Expectations for showing your work on the mini-case assignments/media:description>
media:community>
media:starRating count="7" average="5.00" min="1" max="5"/>
media:statistics views="168"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:XVCF3RN3uME/id>
yt:videoId>XVCF3RN3uME/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>How to show your work on Excel/title>
link rel="alternate" href="https://www.youtube.com/watch?v=XVCF3RN3uME"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-11-24T18:14:10+00:00/published>
updated>2024-02-28T01:49:33+00:00/updated>
media:group>
media:title>How to show your work on Excel/media:title>
media:content url="https://www.youtube.com/v/XVCF3RN3uME?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i1.ytimg.com/vi/XVCF3RN3uME/hqdefault.jpg" width="480" height="360"/>
media:description>This video demonstrated how to show your work on Excel for a particular online class I'm teaching. The techniques shown would be useful for most problem solving on Excel beyond this class!/media:description>
media:community>
media:starRating count="3" average="5.00" min="1" max="5"/>
media:statistics views="264"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:iWFsAQGgrr4/id>
yt:videoId>iWFsAQGgrr4/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Linear Programming Sensitivity Analysis on Excel/title>
link rel="alternate" href="https://www.youtube.com/watch?v=iWFsAQGgrr4"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-09-15T00:28:25+00:00/published>
updated>2024-04-10T10:19:30+00:00/updated>
media:group>
media:title>Linear Programming Sensitivity Analysis on Excel/media:title>
media:content url="https://www.youtube.com/v/iWFsAQGgrr4?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i2.ytimg.com/vi/iWFsAQGgrr4/hqdefault.jpg" width="480" height="360"/>
media:description>How to use Excel Solver to conduct a sensitivity or what-if analysis on a linear programming problem/media:description>
media:community>
media:starRating count="18" average="5.00" min="1" max="5"/>
media:statistics views="715"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:sGwpHKZ60WM/id>
yt:videoId>sGwpHKZ60WM/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Calculate a binomial interest rate tree from par values using Excel./title>
link rel="alternate" href="https://www.youtube.com/watch?v=sGwpHKZ60WM"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-04-18T04:14:11+00:00/published>
updated>2024-03-14T11:59:50+00:00/updated>
media:group>
media:title>Calculate a binomial interest rate tree from par values using Excel./media:title>
media:content url="https://www.youtube.com/v/sGwpHKZ60WM?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i4.ytimg.com/vi/sGwpHKZ60WM/hqdefault.jpg" width="480" height="360"/>
media:description>Contruct a binomial interest rate tree from par values using Excel. CFA study material/media:description>
media:community>
media:starRating count="15" average="5.00" min="1" max="5"/>
media:statistics views="1061"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:tnliHB5J8jE/id>
yt:videoId>tnliHB5J8jE/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Calculate the value of a capped, floating coupon rate bond. CFA fixed income study material./title>
link rel="alternate" href="https://www.youtube.com/watch?v=tnliHB5J8jE"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-04-09T18:35:06+00:00/published>
updated>2024-02-25T18:24:36+00:00/updated>
media:group>
media:title>Calculate the value of a capped, floating coupon rate bond. CFA fixed income study material./media:title>
media:content url="https://www.youtube.com/v/tnliHB5J8jE?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i1.ytimg.com/vi/tnliHB5J8jE/hqdefault.jpg" width="480" height="360"/>
media:description>Calculate the value of a capped floating coupon rate bond. CFA fixed income study material. Uses Excel, but doable on a calculator./media:description>
media:community>
media:starRating count="4" average="5.00" min="1" max="5"/>
media:statistics views="419"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:UdgOUxR5yUg/id>
yt:videoId>UdgOUxR5yUg/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Maximize Profit with tiered profits depending on quantity/title>
link rel="alternate" href="https://www.youtube.com/watch?v=UdgOUxR5yUg"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-03-23T21:39:21+00:00/published>
updated>2024-03-07T04:06:05+00:00/updated>
media:group>
media:title>Maximize Profit with tiered profits depending on quantity/media:title>
media:content url="https://www.youtube.com/v/UdgOUxR5yUg?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i2.ytimg.com/vi/UdgOUxR5yUg/hqdefault.jpg" width="480" height="360"/>
media:description>Use Excel to maximize profit on a production schedule that has profit differing depending on quantity. Uses Excel solver./media:description>
media:community>
media:starRating count="8" average="5.00" min="1" max="5"/>
media:statistics views="361"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:NIVGIgspr4o/id>
yt:videoId>NIVGIgspr4o/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Calculate Initial Assessment with CAMELS rating/title>
link rel="alternate" href="https://www.youtube.com/watch?v=NIVGIgspr4o"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-03-21T01:32:14+00:00/published>
updated>2024-03-14T02:06:31+00:00/updated>
media:group>
media:title>Calculate Initial Assessment with CAMELS rating/media:title>
media:content url="https://www.youtube.com/v/NIVGIgspr4o?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i3.ytimg.com/vi/NIVGIgspr4o/hqdefault.jpg" width="480" height="360"/>
media:description>FDIC Risk Category deposit insurance assessment scheme example on Excel/media:description>
media:community>
media:starRating count="15" average="5.00" min="1" max="5"/>
media:statistics views="798"/>
/media:community>
/media:group>
/entry>
entry>
id>yt:video:iJw9UByHX1s/id>
yt:videoId>iJw9UByHX1s/yt:videoId>
yt:channelId>UCLqZKkIG3gGv2Wg268Ah7kQ/yt:channelId>
title>Calculate spot rates from par rates using Excel/title>
link rel="alternate" href="https://www.youtube.com/watch?v=iJw9UByHX1s"/>
author>
name>David Johnk/name>
uri>https://www.youtube.com/channel/UCLqZKkIG3gGv2Wg268Ah7kQ/uri>
/author>
published>2023-03-07T03:21:13+00:00/published>
updated>2024-03-22T09:21:05+00:00/updated>
media:group>
media:title>Calculate spot rates from par rates using Excel/media:title>
media:content url="https://www.youtube.com/v/iJw9UByHX1s?version=3" type="application/x-shockwave-flash" width="640" height="390"/>
media:thumbnail url="https://i2.ytimg.com/vi/iJw9UByHX1s/hqdefault.jpg" width="480" height="360"/>
media:description>Use bootstrapping to calculate the spot rates from par rates. CFA study material for fixed income securities. Here's the dropbox to the file for this video: https://bit.ly/3IY7rmX/media:description>
media:community>
media:starRating count="21" average="5.00" min="1" max="5"/>
media:statistics views="3062"/>
/media:community>
/media:group>
/entry>
/feed>
David Johnk
01.08.2023 · 19:27:12 ···
29.03.2023 · 20:23:23 ···
06.04.2023 · 23:08:27 ··· 5 ··· ··· 22 ···
20.04.2024 · 13:19:25 ···
29.03.2023 · 20:23:23 ···
06.04.2023 · 23:08:27 ··· 5 ··· ··· 32 ···
1:: Calculate the Payback Period in 30 seconds!
01.01.1970 · 01:00:00 ··· 28.03.2024 · 16:07:07 ··· ··· ··· ··· ··· ···
2:: Calculate the Payback Period on Excel
01.01.1970 · 01:00:00 ··· 28.03.2024 · 15:51:37 ··· ··· ··· ··· ··· ··· Easily calculate the Payback Period on Excel.
3:: Turn Your Master's Into Gold: Excel's Future Value Magic
01.01.1970 · 01:00:00 ··· 05.03.2024 · 19:30:38 ··· ··· ··· ··· ··· ··· Discover how to leverage your Master's Degree for bigger earnings with essential Excel tricks! In this video, I dive into calculating the future value of an ordinary annuity, using the example of additional earnings from a Master's degree. Whether you're in my personal finance class or simply looking to enhance your financial acumen, this tutorial is packed with valuable insights.
**PLEASE NOTE:** While I aim for accuracy, errors can slip through. Rest assured, the core concepts and methodologies remain sound, offering you reliable knowledge to apply in your financial planning.
**What You'll Learn:**
- The basics of calculating future value in Excel
- How to apply these calculations to real-world scenarios like salary increases from advanced degrees
- Different methods for solving time value of money problems, including Excel functions, financial calculators, and manual calculations for deeper understanding
**Important Notes:**
- I demonstrate multiple approaches to accommodate various learning styles and tool preferences.
- Despite a couple of minor missteps in my walkthrough (which I candidly acknowledge), the tutorial provides a robust foundation for financial analysis and decision-making.
**Here's the link to the file I used:** (Note: Actual file link not included here)
**Accuracy and Disclaimer:** This content is for educational purposes based on historical data. No future performance guarantees can be made. Always consult with a financial advisor for personalized advice.
If you find this video helpful and wish to support further content, consider a small contribution: https://www.buymeacoffee.com/DrDavidJohnk
**CTAs:**
- Don't forget to subscribe for more insightful content on Excel, finance, and how to make your education work harder for you.
- Liked the video? Hit the thumbs up and leave a comment with your thoughts or questions!
Remember, mastering Excel for financial planning, such as portfolio optimization, expected return calculations, and understanding the variance-covariance matrix, can significantly impact your personal and professional financial outcomes. Stay tuned for more tutorials that make finance accessible and actionable. Thanks for watching!
#BiggerEarnings #DavidJohnkChannel #OperationsManagement #TimeValueMoney #CareerDevelopment
CHAPTERS:
0:00 - Time Value of Money Calculation
0:40 - Future Value Factor Table Explained
6:50 - Excel Future Value Function Tutorial
7:45 - Financial Calculator for Future Value
9:20 - Brute Force Method in Excel for Future Value
12:59 - Financial Calculator Overview
13:22 - Outro
4:: Unlocking TIPS: Calculate Total Return Like a Pro!
01.01.1970 · 01:00:00 ··· 25.02.2024 · 17:35:06 ··· ··· ··· ··· ··· ··· Unlock the secrets of Treasury Inflation-Protected Securities (TIPS) and learn how to calculate your total return, both in dollars and percentage, like a finance pro! In this detailed tutorial, I walk you through a real-world example from the "M Finance" textbook to demystify the process using Excel. Perfect for students and investors seeking to deepen their understanding of TIPS and inflation impact on investments.
👉 PLEASE NOTE: In our journey to unravel the calculation mysteries, a few hiccups were encountered. I openly discuss these moments to ensure you're getting the most accurate and transparent information.
📌 Important Notes:
- We explore the basics of TIPS, including coupon rates, CPI adjustments, and how to calculate cash flows.
- Understand the significance of semiannual payments and how inflation affects your investment's value.
✨ Here's what you'll learn:
- How to set up your Excel sheet for success.
- Step-by-step guide on calculating purchase price, coupon payments, and sell price.
- The easy way to determine your total dollar return and total return percentage.
🔗 While I've strived for precision, "I found out" that errors can sneak in. Rest assured, the core concepts and calculations presented are solid and will guide you correctly. Always remember, investing involves risks and there's no guarantee of future performance. This tutorial is for educational purposes based on historical data.
🙋♂️ If you found this video helpful, consider supporting my work through "https://www.buymeacoffee.com/DrDavidJohnk". Every coffee counts!
💡 Subscribe for more content on Excel, finance essentials, portfolio optimization, expected return calculations, variance-covariance matrix, Excel Solver applications, efficient frontier mapping, Beta calculations, and investment payback period insights.
Your journey to financial literacy and Excel mastery starts here. Let's dive in and calculate those returns together!
#FinancialLiteracy #MidyearCouponPayment #FaceValue #CouponRate #ReferenceCpi
CHAPTERS:
0:01 - Introduction to TIPS
0:27 - Understanding TIPS Basics
2:55 - Calculating TIPS Cash Flows
7:00 - TIPS Total Return Analysis
5:: Avoid Costly Mistakes: Master Discounted Cash Flows using PB and DBP on Excel
01.01.1970 · 01:00:00 ··· 23.02.2024 · 17:47:58 ··· ··· ··· ··· ··· ··· Embark on a journey to financial mastery with Excel as your guide! In this tutorial, I delve deep into calculating the payback period (PB) and the discounted payback period (DPB), two pivotal techniques in capital budgeting analysis that can save you from costly investment mistakes. Whether you're a finance professional or just keen to enhance your Excel skills, this video is tailored for you.
🔍 **What You'll Learn:**
- Understanding the fundamentals of payback period and discounted payback period.
- Step-by-step guide on how to leverage Excel for effective capital budgeting analysis.
- Practical example to illustrate PB and DPB calculations.
📌 **PLEASE NOTE:** While I strive for accuracy, the complexities of Excel and finance mean occasional errors can slip through. I candidly acknowledge any oversights, ensuring you receive reliable and authentic content. Rest assured, the essence and educational value of the tutorial remain intact, guiding you confidently through Excel's capabilities in financial evaluation.
📝 **Important Notes:**
- This tutorial is designed with both beginners and seasoned professionals in mind.
- A hands-on approach featuring a practical example to solidify your understanding.
- Corrections and clarifications are provided transparently, ensuring you have the most accurate information.
Support my passion for teaching finance and Excel by considering a contribution: https://www.buymeacoffee.com/DrDavidJohnk
🚀 **Subscribe for More:** Stay ahead in the world of finance and Excel. Sharpen your skills further by joining our community for upcoming tutorials on portfolio optimization, calculating Beta, and navigating the variance-covariance matrix.
**DISCLAIMER:** This content is for educational purposes only. While every effort is made to ensure accuracy, finance and investment strategies are subject to individual circumstances and market dynamics. Past performance is not indicative of future results.
Thank you for watching, and remember, the path to avoiding costly financial mistakes is through knowledge and skill. Let's conquer Excel together!
#FinanceAnalysis #DiscountedPaybackPeriod #ExcelSkills #ExcelFinanceSkills #DiscountedCashFlows
CHAPTERS:
0:00 - Introduction to PB & DPB
1:10 - Understanding Payback Period in Excel
7:14 - Calculating Discounted Payback Period in Excel
11:58 - Conclusion on Capital Budgeting Techniques
6:: How to do multiple regression on Excel for forecasting.
01.01.1970 · 01:00:00 ··· 31.01.2024 · 20:11:30 ··· ··· ··· ··· ··· ··· A quick tutorial on how to conduct multiple regression on Excel
7:: Income statement calculations in Excel. Demonstrates Excel goal seek as an algebra alterative.
01.01.1970 · 01:00:00 ··· 21.01.2024 · 16:09:09 ··· ··· ··· ··· ··· ··· Financial Income statement calculations in Excel.
It involves calculating various financial metrics such as gross profits, EBITDA, Net Income, EBT, and Depreciation expense.
0:00 Intro
0:30 Problem intro
1:40 Calculate gross profits
1:50 Calculate EBITDA
2:30 Solve for Net Income
2:45 Solve for EBT using algebra
3:40 Solve for EBT using Excel Goal Seek
5:44 Solve for Depreciation expense
8:: How to Show your Work on the Mini-cases
01.01.1970 · 01:00:00 ··· 28.12.2023 · 15:59:06 ··· ··· ··· ··· ··· ··· Expectations for showing your work on the mini-case assignments
9:: How to show your work on Excel
01.01.1970 · 01:00:00 ··· 24.11.2023 · 18:14:10 ··· ··· ··· ··· ··· ··· This video demonstrated how to show your work on Excel for a particular online class I'm teaching. The techniques shown would be useful for most problem solving on Excel beyond this class!
10:: Linear Programming Sensitivity Analysis on Excel
01.01.1970 · 01:00:00 ··· 15.09.2023 · 00:28:25 ··· ··· ··· ··· ··· ··· How to use Excel Solver to conduct a sensitivity or what-if analysis on a linear programming problem
11:: Calculate a binomial interest rate tree from par values using Excel.
01.01.1970 · 01:00:00 ··· 18.04.2023 · 04:14:11 ··· ··· ··· ··· ··· ··· Contruct a binomial interest rate tree from par values using Excel. CFA study material
12:: Calculate the value of a capped, floating coupon rate bond. CFA fixed income study material.
01.01.1970 · 01:00:00 ··· 09.04.2023 · 18:35:06 ··· ··· ··· ··· ··· ··· Calculate the value of a capped floating coupon rate bond. CFA fixed income study material. Uses Excel, but doable on a calculator.
13:: Maximize Profit with tiered profits depending on quantity
01.01.1970 · 01:00:00 ··· 23.03.2023 · 21:39:21 ··· ··· ··· ··· ··· ··· Use Excel to maximize profit on a production schedule that has profit differing depending on quantity. Uses Excel solver.
14:: Calculate Initial Assessment with CAMELS rating
01.01.1970 · 01:00:00 ··· 21.03.2023 · 01:32:14 ··· ··· ··· ··· ··· ··· FDIC Risk Category deposit insurance assessment scheme example on Excel
15:: Calculate spot rates from par rates using Excel
01.01.1970 · 01:00:00 ··· 07.03.2023 · 03:21:13 ··· ··· ··· ··· ··· ··· Use bootstrapping to calculate the spot rates from par rates. CFA study material for fixed income securities. Here's the dropbox to the file for this video: https://bit.ly/3IY7rmX
16:: Easily calculate Beta using historical stock data on Excel
01.01.1970 · 01:00:00 ··· 27.02.2023 · 07:50:29 ··· ··· ··· ··· ··· ··· Calculate Beta on Excel using historical adjusted close stock price data downloaded in bulk for free from Yahoo finance.
17:: Calculate the holding period return of a bond using Excel. CFA study material
01.01.1970 · 01:00:00 ··· 23.02.2023 · 02:36:33 ··· ··· ··· ··· ··· ··· Calculate the holding period return using both Excel and algebra formulas, helpful video for studying for the CFA! Here's the link to the file I used: https://bit.ly/3xKjhvw
18:: Minimize Shipping Costs on Excel
01.01.1970 · 01:00:00 ··· 06.02.2023 · 21:11:14 ··· ··· ··· ··· ··· ··· Minimize shipping costs using Excel Solver.
19:: How to submit your Excel homework
01.01.1970 · 01:00:00 ··· 31.01.2023 · 04:09:09 ··· ··· ··· ··· ··· ···
20:: My Tesla saved our lives!
01.01.1970 · 01:00:00 ··· 22.01.2023 · 20:00:00 ··· ··· ··· ··· ··· ··· We were driving at 11 PM on Saturday 1/21/2023 with Tesla FSD (Full Self Driving) engaged. I was a little bleary-eyed because I had been on the road since 9 AM that day. The Tesla alerted and braked, it might have steered to the right, but I'm not sure about that because I also did when I figured out what was going on...
Any way my Tesla's status has been elevated to one that you might give a good dog who saves your life!
21:: Test for randomness on Excel using the up/down or median runs test.
01.01.1970 · 01:00:00 ··· 17.09.2022 · 14:06:07 ··· ··· ··· ··· ··· ··· Here's the Dropbox link to the file I used in this video: https://bit.ly/3dkFZ6W
22:: Excel Lambda functions which easily calculate portfolio expected return and standard deviation
01.01.1970 · 01:00:00 ··· 08.09.2022 · 04:14:43 ··· ··· ··· ··· ··· ··· These Excel Lambda functions calculate various portfolio statistics from a list of prices (P) sorted in ascending order (from old to new), and portfolio weights (w)
Please note:
1) Expected values are not guaranteed values, they are based off of historical data
2) Results will differ with frequency (daily, monthly, etc) and number of observations
3) David W. Johnk assumes no responsibility or liability for any errors or omissions. This is provided in a "as is" basis with no guarantees of completeness, accuracy, usefulness or timeliness
see my YouTube video: https://youtu.be/7CIkj9NIS0s to see how to use these
periodicreturns = LAMBDA(P,OFFSET(P,1,0,ROWS(P)-1)/OFFSET(P,0,0,ROWS(P)-1)-1);
expectedrets = LAMBDA(P,BYCOL(periodicreturns(P),LAMBDA(array, AVERAGE(array))));
stdevrets = LAMBDA(P,BYCOL(periodicreturns(P),LAMBDA(array,stdev.p(array))));
varrets = LAMBDA(P,BYCOL(periodicreturns(P),LAMBDA(array,var.p(array))));
excessrets = LAMBDA(P,periodicreturns(P)-expectedrets(P));
varcovarmatrix = LAMBDA(P,MMULT(TRANSPOSE(excessrets(P)),excessrets(P))/(ROWS(P) - 1));
correlmatrix = LAMBDA(P,varcovarmatrix(P)/mmult(transpose(stdevrets(P)),stdevrets(P)));
portexpectedret = LAMBDA(w,P,sumproduct(w,expectedrets(P)));
portstddev = LAMBDA(w,P,SQRT(MMULT(MMULT(w,varcovarmatrix(P)),TRANSPOSE(w))));
23:: Easily make a Lambda function that calculates MSE
01.01.1970 · 01:00:00 ··· 23.08.2022 · 16:07:01 ··· ··· ··· ··· ··· ··· @DavidJohnk
24:: Use Excel to calculate MSE, MAD, SSE, tracking signal, and control limits on forecasts.
01.01.1970 · 01:00:00 ··· 23.08.2022 · 15:42:55 ··· ··· ··· ··· ··· ··· Here's the link to the file I used: https://bit.ly/3R5W8LK
25:: Simple linear regression with forecast adequacy calculations on Excel
01.01.1970 · 01:00:00 ··· 22.08.2022 · 05:30:44 ··· ··· ··· ··· ··· ··· Here's the link to the Excel file in the video: https://bit.ly/3K9rfUo
26:: Calculate centered moving average and SA method seasonal relatives on Excel.
01.01.1970 · 01:00:00 ··· 22.08.2022 · 03:49:03 ··· ··· ··· ··· ··· ···
27:: Calculate the standard deviation and expected value of a discrete probability distribution on Excel
01.01.1970 · 01:00:00 ··· 18.07.2022 · 02:07:18 ··· ··· ··· ··· ··· ···
28:: Excel and Monte Carlo to demonstrate the birthday paradox
01.01.1970 · 01:00:00 ··· 06.05.2022 · 18:04:25 ··· ··· ··· ··· ··· ···
29:: Create a new Excel function that easily calculates returns using the Lambda function.
01.01.1970 · 01:00:00 ··· 15.02.2022 · 05:03:33 ··· ··· ··· ··· ··· ···
30:: Create a new function on Excel called Net Future Value (NFV) using the new Excel Lamba function.
01.01.1970 · 01:00:00 ··· 11.02.2022 · 15:39:14 ··· ··· ··· ··· ··· ···
31:: Payday Loans - an example on Excel. Are they usurious?
01.01.1970 · 01:00:00 ··· 25.01.2022 · 04:21:36 ··· ··· ··· ··· ··· ···
32:: Answer to an interesting Reddit r/statistics problem I answered on Excel using Monte Carlo analysis
01.01.1970 · 01:00:00 ··· 05.12.2021 · 06:50:01 ··· ··· ··· ··· ··· ···