NVIDIA DCF Valuation Model Built From Scratch | FREE EXCEL INCLUDED (2023)

rareliquid September 21, 2023
Video Thumbnail
rareliquid Logo

rareliquid

@rareliquid

About

Welcome! My name is Ben, and my goal is to help you build your ideal career. A bit about me - after graduating from U.C. Berkeley, I worked as an investment banking analyst at J.P. Morgan, where I closed 15 transactions valued at over $14 billion. Previously, I worked on consulting projects for Deloitte, Cisco, and Andreessen Horowitz, and I received my MBA from Wharton and Masters in International Studies from UPENN in 2024. Videos are published around 12PM EST (New York time).

Video Description

⬇️ Download the NVIDIA DCF Excel for FREE ⬇️ ► https://www.wallstreetprep.com/lc-rl-nvidia-template/ ► Sign up to get emails notifications for my streams and when the excel models are available: https://forms.gle/jMUPmnSp5pvC9sQb6 🖥️Wall Street Prep🖥️ ► Use code RARELIQUID for 20% OFF on any course! ► https://www.wallstreetprep.com/self-study-programs/buy-side-financial-modeling/?wspoc=rliquid 👨‍🏫My 1:1 Banking Mentorship Program👨‍🏫 ► Our guarantee - secure a $150K+ / year investment banking offer within 180 days! ► Sign up: https://go.bankingaccelerator.com/58790797 🎥Related Videos🎥 DCF Beginner's Tutorial: https://youtu.be/nyot7FkYoqM Excel Shortcuts for Finance and Modeling: https://youtu.be/oDjhg57XH-A A Beginner's Guide to Portfolio Management: https://youtu.be/ICRB8vRX0Ls How Interest Rates and Inflation Affect the Markets: https://youtu.be/5enhDxIXM1Q Google DCF Model: https://youtu.be/V2gNxCAGAGA ⏱Timestamps⏱ 0:00 - Agenda 4:55 - Wall Street Prep 7:05 - Income Statement & Cash Flow Line Items 48:15 - Build DCF 1:31:30 - WACC 1:41:30 - Calculating Implied Share Price 2:03:15 - Price Discussion ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 📱Interact With Me📱 ► Instagram: https://www.instagram.com/rareliquid ► Twitter: https://twitter.com/rareliquid ► TikTok: https://www.tiktok.com/@rareliquid ► LinkedIn: https://www.linkedin.com/in/ben-chon-8b0ba34a/ ► Business Inquiries: [email protected] 🧑‍🎓Career Resources👩‍🎓 ► Buy my resume and cover letter: https://rareliquidcareers.com/ ► Books I recommend: https://amzn.to/3gy28xv ► My filming equipment: https://a.co/cf97WjW 🔎Disclaimer🔎 All content in this video is for entertainment purposes only. I am not a professional financial advisor and my statements are not to be taken as instructions or directions. In addition, some of the links above are affiliate links, meaning that at no additional cost to you, I may earn a commission if you click through and make a purchase. #nvidia #nvda #stocks #dcf

Upgrade Your Gaming

AI-recommended products based on this video

Loading...
Asus ROG Gladius III Wireless AimPoint Gaming Mouse, Connectivity (2.4GHz RF, Bluetooth, Wired), 36000 DPI Sensor, 6 programmable Buttons, ROG SpeedNova, Replaceable switches, Paracord Cable, White

Asus ROG Gladius III Wireless AimPoint Gaming Mouse, Connectivity (2.4GHz RF, Bluetooth, Wired), 36000 DPI Sensor, 6 programmable Buttons, ROG SpeedNova, Replaceable switches, Paracord Cable, White

(329)
$94.99$93.99
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
Asus ROG STRIX Z890-A GAMING WIFI Z890 LGA 1851 ATX motherboard, Intel® Core™ Ultra Series 2 Ready, Advanced AI PC-ready, 16+2+1+2 stages, DDR5, WiFi 7, 2.5G, 5x M.2, Thunderbolt™ 4, USB Type-C, AI OC

Asus ROG STRIX Z890-A GAMING WIFI Z890 LGA 1851 ATX motherboard, Intel® Core™ Ultra Series 2 Ready, Advanced AI PC-ready, 16+2+1+2 stages, DDR5, WiFi 7, 2.5G, 5x M.2, Thunderbolt™ 4, USB Type-C, AI OC

(54)
$299.99
FREE delivery Jan 11 - Feb 5
Loading...
Asus ROG Delta II Wireless Gaming Headset with Detachable Mic – Tri-Mode (BT, 2.4GHz, 3.5mm), 50mm Titanium-Plated Drivers, 110Hr Battery, Lightweight, for PC, PS5, PS4, Xbox, Switch, Mobile - Black

Asus ROG Delta II Wireless Gaming Headset with Detachable Mic – Tri-Mode (BT, 2.4GHz, 3.5mm), 50mm Titanium-Plated Drivers, 110Hr Battery, Lightweight, for PC, PS5, PS4, Xbox, Switch, Mobile - Black

(180)
$249.99$166.60
FREE delivery Sat, Jan 3
50+ bought in past month
Loading...
Asus ROG Swift 32” 4K OLED Gaming Monitor (PG32UCDM) - UHD (3840 x 2160), QD-OLED, 240Hz, 0.03ms, G-SYNC Compatible, Custom Heatsink, Graphene film, 99% DCI-P3, True 10-bit, 90W USB-C, 3 year warranty

Asus ROG Swift 32” 4K OLED Gaming Monitor (PG32UCDM) - UHD (3840 x 2160), QD-OLED, 240Hz, 0.03ms, G-SYNC Compatible, Custom Heatsink, Graphene film, 99% DCI-P3, True 10-bit, 90W USB-C, 3 year warranty

(909)
$1,663.35$1,355.90
FREE delivery Sat, Jan 3
Loading...
Logitech K250 Bluetooth Keyboard with Numpad, Easy Connectivity, Compact Wireless Keyboard Made with Recycled Plastic, Spill-Resistant, Comfortable Keys - Windows/MacOS - Graphite
Best Seller

Logitech K250 Bluetooth Keyboard with Numpad, Easy Connectivity, Compact Wireless Keyboard Made with Recycled Plastic, Spill-Resistant, Comfortable Keys - Windows/MacOS - Graphite

(49)
$19.99$18.59
FREE delivery Mon, Aug 18 on your first order
Loading...
Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black
Best Seller

Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black

(38,516)
$39.98$35.98
FREE delivery Thu, Sep 4
500+ bought in past month
Loading...
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

(21,223)
$44.98
FREE delivery Tue, Oct 14
1K+ bought in past month
Loading...
NEW SteelSeries Arctis Nova 3 Multi-Platform Gaming Headset - Signature Arctis Sound - ClearCast Gen 2 Mic - PC, PS5/PS4, Xbox Series X|S, Switch, Mobile

NEW SteelSeries Arctis Nova 3 Multi-Platform Gaming Headset - Signature Arctis Sound - ClearCast Gen 2 Mic - PC, PS5/PS4, Xbox Series X|S, Switch, Mobile

(9,500)
$99.98$67.37
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch

New SteelSeries Arctis Nova Pro for Xbox Multi-System Gaming Headset - Premium Hi-Fi Drivers - Hi-Res Audio - 360° Spatial - GameDAC Gen 2 - Quad-DAC - ClearCast Gen 2 Mic - Xbox, PC, PS5/PS4, Switch

(517)
$209.41$122.65
PrimeFREE delivery Sat, Jun 14
Loading...
Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black
Best Seller

Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black

(16,675)
$112.99$101.69
FREE delivery Sun, Aug 10
500+ bought in past month
Loading...
Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

(1,811)
$359.99$341.99
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

(41,678)
$74.97
FREE delivery Wed, Jun 18
400+ bought in past month
Loading...
SAMSUNG 870 EVO SATA III SSD 4TB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E4T0B/AM [Canada Version]

SAMSUNG 870 EVO SATA III SSD 4TB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E4T0B/AM [Canada Version]

(41,656)
$399.97
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
SAMSUNG EVO Select Micro SD-Memory-Card + Adapter, 128GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME128SA/AM) [Canada Version]

SAMSUNG EVO Select Micro SD-Memory-Card + Adapter, 128GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME128SA/AM) [Canada Version]

(12,472)
$19.99$18.59
FREE delivery Sun, Aug 10 on your first order
400+ bought in past month
Loading...
Asus Dual NVIDIA GeForce RTX 3050 6GB OC Edition Gaming Graphics Card - PCIe 4.0, 6GB GDDR6 Memory, HDMI 2.1, DisplayPort 1.4a, 2-Slot Design, Axial-tech Fan Design, 0dB Technology, Steel Bracket

Asus Dual NVIDIA GeForce RTX 3050 6GB OC Edition Gaming Graphics Card - PCIe 4.0, 6GB GDDR6 Memory, HDMI 2.1, DisplayPort 1.4a, 2-Slot Design, Axial-tech Fan Design, 0dB Technology, Steel Bracket

(903)
$248.98
FREE delivery Sat, Jan 3
300+ bought in past month
Loading...
Dell G16 Gaming Laptop 7630-16-inch QHD+ 240Hz 3ms Display, Intel Core i9-13900HX, 32GB DDR5 RAM, 1TB SSD, NVIDIA GeForce RTX 4060 8GB GDDR6, Windows 11 Home, Onsite Service - Metallic Nightshade

Dell G16 Gaming Laptop 7630-16-inch QHD+ 240Hz 3ms Display, Intel Core i9-13900HX, 32GB DDR5 RAM, 1TB SSD, NVIDIA GeForce RTX 4060 8GB GDDR6, Windows 11 Home, Onsite Service - Metallic Nightshade

(0)
$2,099.00
$11.58 delivery Aug 26 - 28
Loading...
HP Victus 15.6" 144Hz FHD Gaming Laptop, Intel i5-12450H, 32GB RAM, 1TB PCIe SSD, NVIDIA GeForce RTX 3050, Backlit Keyboard, HD Webcam, Win 11, Blue, 256GB Docking Station Set

HP Victus 15.6" 144Hz FHD Gaming Laptop, Intel i5-12450H, 32GB RAM, 1TB PCIe SSD, NVIDIA GeForce RTX 3050, Backlit Keyboard, HD Webcam, Win 11, Blue, 256GB Docking Station Set

(117)
$1,149.00
FREE delivery Jun 26 - Jul 8
Loading...
Acer Nitro V 15.6 FHD 144Hz Gaming Laptop, Intel i7-13620H, 32GB DDR5, 1TB SSD, NVIDIA GeForce RTX 4060, Keyboard Backlight, Wi-Fi 6, HD Webcam, Windows 11 Home, Black, 256GB Docking Station Set

Acer Nitro V 15.6 FHD 144Hz Gaming Laptop, Intel i7-13620H, 32GB DDR5, 1TB SSD, NVIDIA GeForce RTX 4060, Keyboard Backlight, Wi-Fi 6, HD Webcam, Windows 11 Home, Black, 256GB Docking Station Set

(105)
$1,655.10
FREE delivery Wed, Jun 18
Loading...
Portable Air Conditioners, wobuzhi Evaporative Air Cooler with LCD Screen, Fan Speed&Spray, 7 RGB Lights,USB Powered,1-8H Timer, Personal Air Conditioners, Portable Air Conditioners for Home Office

Portable Air Conditioners, wobuzhi Evaporative Air Cooler with LCD Screen, Fan Speed&Spray, 7 RGB Lights,USB Powered,1-8H Timer, Personal Air Conditioners, Portable Air Conditioners for Home Office

(32)
$39.99
FREE delivery Sun, Aug 10
200+ bought in past month
Loading...
llano RGB Laptop Cooling Pad with Powerful Turbofan Gaming Cooler Radiator with Infinitely Variable Speed, Touch Control, LCD Screen, 3-Port USB Hub, Seal Foam for Notebook Computer 15-19in

llano RGB Laptop Cooling Pad with Powerful Turbofan Gaming Cooler Radiator with Infinitely Variable Speed, Touch Control, LCD Screen, 3-Port USB Hub, Seal Foam for Notebook Computer 15-19in

(1,404)
$129.99
Prime
200+ bought in past month
Loading...
Neck Fan with Cooling Plate,Portable Neck Fan Rechargeable Battery Powered,Bladeless Personal Air Conditioner Wearable Neck Cooler Fans,USB Electric Quiet Necklace AC Fans for Travel Outdoor Black

Neck Fan with Cooling Plate,Portable Neck Fan Rechargeable Battery Powered,Bladeless Personal Air Conditioner Wearable Neck Cooler Fans,USB Electric Quiet Necklace AC Fans for Travel Outdoor Black

(35)
$39.99
600+ bought in past month
Loading...
MSI MAG CORELIQUID A15 240 - AIO ARGB CPU Liquid Cooler - 240mm Radiator - AM5, LGA 1851 Ready - Dual 120mm ARGB PWM Fans, Black

MSI MAG CORELIQUID A15 240 - AIO ARGB CPU Liquid Cooler - 240mm Radiator - AM5, LGA 1851 Ready - Dual 120mm ARGB PWM Fans, Black

(21)
$89.99$85.49
FREE delivery Sat, Jan 3
Loading...
llano RGB Laptop Cooling Pad with Powerful Turbofan Gaming Cooler Radiator with Infinitely Variable Speed, Touch Control, LCD Screen, 3-Port USB Hub, Seal Foam for Notebook Computer 15-19in

llano RGB Laptop Cooling Pad with Powerful Turbofan Gaming Cooler Radiator with Infinitely Variable Speed, Touch Control, LCD Screen, 3-Port USB Hub, Seal Foam for Notebook Computer 15-19in

(1,404)
$129.99
Prime
200+ bought in past month
Loading...
Redragon M612 Predator RGB Gaming Mouse, 8000 DPI Wired Optical Mouse with 11 Programmable Buttons & 5 Backlit Modes, Software Supports DIY Keybinds Rapid Fire Button

Redragon M612 Predator RGB Gaming Mouse, 8000 DPI Wired Optical Mouse with 11 Programmable Buttons & 5 Backlit Modes, Software Supports DIY Keybinds Rapid Fire Button

(8,052)
$22.49
FREE delivery Thu, Aug 21 on your first order
500+ bought in past month
Loading...
Lenovo M210 RGB Wired Gaming Mouse for PC, Laptop, Computer with Windows & Chrome OS - 3 Zone RGB, 8000 DPI Adjustable Sensor, 7 Programmable Buttons – Palm Grip Mouse for Gamers (Black)

Lenovo M210 RGB Wired Gaming Mouse for PC, Laptop, Computer with Windows & Chrome OS - 3 Zone RGB, 8000 DPI Adjustable Sensor, 7 Programmable Buttons – Palm Grip Mouse for Gamers (Black)

(52)
$26.62
FREE delivery Tue, Jun 17 on your first order
Loading...
Lenovo Legion KM310 RGB Wired Gaming Keyboard & Mouse Combo - K310 Keyboard w/Silent Operation & Compact Water-Resistant Design - M300S Mouse with 8000 Adjustable DPI, 220 IPS, 6 Programmable Buttons

Lenovo Legion KM310 RGB Wired Gaming Keyboard & Mouse Combo - K310 Keyboard w/Silent Operation & Compact Water-Resistant Design - M300S Mouse with 8000 Adjustable DPI, 220 IPS, 6 Programmable Buttons

(14)
$109.39
FREE delivery Tue, Jun 17
Loading...
Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black
Best Seller

Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black

(54,445)
$49.98$44.98
FREE delivery Tue, Oct 14
1K+ bought in past month