Finance Essentials Toolkit:
30+ Optional Downloads for the book called Finance Essentials for Managers: The Tools You Need to Succeed as a Nonfinancial Professional
I will discuss each of the following optional downloadable resources listed below and Internet links during the chapters 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 the book 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 Chapters 1 to 8 as a precursor (inputs) into our 100 step investment research process (outputs) that we discuss in Chapter 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 I: THE ESSENTIALS:
Downloads for Chapter 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 Chapter 2: Introduction to the Income Statement:
Oracle’s Fiscal 2022 Fourth Quarter Financial Results (8-K) (2)
Income Statement Spreadsheet Example
Download for Chapter 3: Introduction to the Balance Sheet:
Oracle’s Fiscal 2022 Annual Report (10-K) (3)
Balance Sheet Spreadsheet Example
Download for Chapter 4: Introduction to the Cash Flow Statement:
Cash Flow Statement Spreadsheet Example
Download for Chapter 5: Introduction to Financial Ratios:
Download for Chapter 6: Introduction to Forecasting Financial Statements and Budgets:
7 Steps Template of Financial Statements and Modeling and Valuation Download
Download for Chapter 7: Introduction to Valuing Companies:
NPV Calculation Spreadsheet Download
Download for Chapter 9: How to Do Fundamental Investment Research:
100 Step Investment Research Dashboard
Elon Musk’s Significant Purchase of Tesla Shares on February 14th of 2020 (Form 4) (5)
Download for Chapter 11: Introduction to Mutual Funds and ETFs
Downloads for Chapter 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 II: THE ESSENTIALS APPLIED:
Download for Chapter 15 Exercise on Creating an Income Statement:
Income Statement Spreadsheet Exercise
Download for Chapter 16 Exercise on Creating a Balance Sheet:
Balance Sheet Spreadsheet Exercise
Download for Chapter 17 Exercise on Creating a Cash Flow Statement:
Cash Flow Statement Spreadsheet Exercise
Download for Chapter 18 Exercise on Using Financial Ratios:
Download for Chapter 19 Exercise on Forecasting Financial Statements:
Financial Model Spreadsheet Exercise
Download for Chapter 20 Exercise on Valuation Using Price to Earnings:
Price to Earnings Spreadsheet Exercise
Download for Chapter 21 Exercise on Valuation Using Price to Revenue:
Price to Revenue Spreadsheet Exercise
Download for Chapter 22 Exercise on Valuation Using Discounted Cash Flow:
Time Value of Money Spreadsheet Exercise
Downloads for Chapter 23 Exercise on Using Fundamental Investment Research
100 Step Investment Research Dashboard
113 Page Investment Research Report Exercise
1 Page Investment Write-up using Fundamentals, Valuation and Technical Analysis Framework
1 Page Investment Write-up using Fundamentals and Valuation Analysis Framework
DOWNLOADS FOR PART III: BEYOND THE ESSENTIALS:
Download for Chapter 24 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 Chapter 27 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 Chapter 28 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 Chapter 29 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