Udemy Business Product called Finance and Accounting 101 VILT Program:
For the calendar and replay of all lectures and how to access optional 1x1 Zoom meetings and office hours, please see the following link on Udemy’s website [Chris to insert]
30+Downloads for the Udemy Business Product called Finance and Accounting 101 VILT Program
I will discuss each of the following downloadable resources listed below and Internet links during the lessons where we discuss each item.
I recommend using Microsoft Excel on a computer and not on a tablet or on a mobile phone when opening the optional spreadsheets listed below. In addition, there are hundreds of clickable YouTube videos that I created that can be accessed from within the Excel spreadsheets for more in depth details and explanations of finance, accounting and investing topics.
The most important download that we will use in this VILT program is an Excel spreadsheet I created based on my work experience called 100 Step Investment Research Dashboard (based on my experience working at Goldman Sachs, the hedge fund, venture capital and consulting sectors). The aforementioned spreadsheet contains 100 tabs for about 100 investment research steps and links to 100 YouTube videos explaining each tab/step.
Upon completion of the 100 steps in the aforementioned spreadsheet, readers can create a comprehensive a 1 page investment executive summary, a 100+ page research report, along with many automatically generated charts, data analysis, financial statement, target prices and a comprehensive dashboard. Please think of Lessons 1 to 8 as a precursor (inputs) into our 100 step investment research process (outputs) that we discuss in Lesson 9. Please note, there are no macros in the spreadsheets listed below and students are advised to please only use the resources below as a guide and not as a recommendation of what to invest in.
DOWNLOADS FOR PART 1 OF 2: FINANCE AND ACCOUNTING LESSONS, EXERCISES AND QUIZZES:
Downloads for Lesson 1: Introduction to Accounting and Finance:
Jeff Bezos Interview from 1999 on Customer Service (1)
Revenue Forecast Spreadsheet. This spreadsheet explains how CFOs & Heads of Sales executives quantify & forecast Sales (also called Revenue). The spreadsheet contains optional YouTube links on how I created the spreadsheet (and how to use Excel).
Download for Lesson 2: Introduction to the Income Statement:
Oracle’s Fiscal 2022 Fourth Quarter Financial Results (8-K) (2)
Income Statement Spreadsheet Example
Income Statement Spreadsheet Exercise Download
Download for Lesson 3: Introduction to the Balance Sheet:
Oracle’s Fiscal 2022 Annual Report (10-K) (3)
Balance Sheet Spreadsheet Example
Balance Sheet Spreadsheet Exercise Download
Download for Lesson 4: Introduction to the Cash Flow Statement:
Cash Flow Statement Spreadsheet Example
Cash Flow Statement Spreadsheet Exercise Download
Download for Lesson 5: Introduction to Financial Ratios:
Formula Spreadsheet Exercise Download
Download for Lesson 6: Introduction to Forecasting Financial Statements and Budgets:
7 Steps Template of Financial Statements and Modeling and Valuation Download
Financial Model Spreadsheet Exercise Download
Download for Lesson 7: Introduction to Valuing Companies:
NPV Calculation Spreadsheet Download
Price to Earnings Spreadsheet Exercise Download
Price to Revenue Spreadsheet Exercise Download
DCF Spreadsheet Exercise Download
Time Value of Money Spreadsheet Exercise Download
Download for Lesson 9: How to Do Fundamental Investment Research:
100 Step Investment Research Dashboard Exercise Download
Elon Musk’s Significant Purchase of Tesla Shares on February 14th of 2020 (Form 4) (5)
113 Page Investment Research Report Template Download
1 Page Investment Write-up using Fundamentals and Valuation Analysis Framework Template Download
Download for Lesson 11: Introduction to Mutual Funds and ETFs
Downloads for Lesson 14 Introduction to Options and Derivatives:
Options Analysis and Valuation Spreadsheets based on my experience working in the hedge fund sector. These 4 spreadsheets contain dashboards on how to value options using 3 different valuation methodologies, as we as more than 30 options strategies. The aforementioned spreadsheets contain more than 100 links to YouTube videos explaining the basics of investing in options.
DOWNLOADS FOR PART 2 OF 2: CASE STUDIES:
Download for Lesson 15 Real life case study on Investment Banking: Meta’s IPO (Formerly Called Facebook):
Facebook’s IPO Prospectus (Also Called an S1 Filing) (7)
Download for Lesson 18 Real Life Case Study on Investment Management: Warren Buffett’s Portfolio:
Berkshire Hathaway’s 13G Filing (Investment in Hewlett-Packard) (8)
Berkshire Hathaway’s 13F Filing (9)
Downloads for Lesson 19 Real Life Case Study on Venture Capital: Sequoia’s Investment in YouTube
Sequoia Capital’s YouTube Investment (10)
Google SEC Filing on the YouTube Acquisition (11)
YouTube’s Series A Pitch Deck (12)
AirBnB’s Pitch Deck (13)
Downloads for Lesson 20 Conclusion and next Steps
Life Changing Advice from Steve Jobs Video (14)
_____
Sources:
1. CNBC, Jeff Bezos In 1999 On Amazon's Plans Before The Dotcom Crash, https://www.youtube.com/watch?v=GltlJO56S1g&ab_channel=CNBC, posted 2020
2. Securities and Exchange Commission, Oracle Announces Fiscal 2022 Fourth Quarter and Fiscal Full Year Financial Results, https://www.sec.gov/Archives/edgar/data/1341439/000156459022023099/orcl-ex991_6.htm, posted June 13th, 2022
3. Securities and Exchange Commission, Oracle Corporation Fiscal Year 2022 Form 10-K Annual Report, https://www.sec.gov/ix?doc=%2FArchives%2Fedgar%2Fdata%2F1341439%2F000156459022023675%2Forcl-10k_20220531.htm, posted June 22nd, 2022
4. VentureBeat, When a company founder resigns, investors should head for the exit too, https://venturebeat.com/entrepreneur/when-a-company-founder-resigns-investors-should-head-for-the-exit-too/, posted November 22nd, 2014
5. Securities and Exchange Commission, Statement of Changes in Beneficial Ownership [Elon Musk’s Trust Form 4 Purchase of Tesla Shares], https://www.sec.gov/Archives/edgar/data/1318605/000149473020000001/xslF345X03/edgardoc.xml, posted February 14th, 2020
6. VettaFi, ETF Database Quicklinks, https://etfdb.com/
7. Securities and Exchange Commission, Amendment No. 8 to Form S-1 Registration Statement [Facebook IPO S-1], https://www.sec.gov/Archives/edgar/data/1326801/000119312512235588/d287954ds1a.htm, posted May 16th, 2012
8. Securities and Exchange Commission, Schedule 13G [Berkshire Hathaway, Inc.’s Hewlett-Packard Ownership Filing], https://www.sec.gov/Archives/edgar/data/1067983/000119312522159669/d355075dsc13g.htm, posted May 25th, 2022
9. Securities and Exchange Commission, Schedule 13F [Berkshire Hathaway, Inc.’s Portfolio Ownership Filing], https://www.sec.gov/Archives/edgar/data/1067983/000095012322012275/xslForm13F_X01/18337.xml, posted November 14th, 2022
10. Sequoia Capital, https://www.sequoiacap.com/companies/youtube/
11. Securities and Exchange Commission, Form 8-K [Google’s Acquisition of YouTube Filing], https://www.sec.gov/Archives/edgar/data/1288776/000119312506238320/d8k.htm, posted November 13th, 2006
12. PitchDeckHunt, YouTube Pitch Deck, https://www.pitchdeckhunt.com/pitch-decks/youtube, 2005
13. PitchDeckHunt, AirBnB Pitch Deck, https://www.pitchdeckhunt.com/pitch-decks/airbnb, 2008
14. Silicon Valley Historical Association, Life Changing Advice from Steve Jobs, https://www.youtube.com/watch?v=POKSiisnY1o&ab_channel=ChrisHaroun, posted 2021