Excel Videos

Introduction to Excel

Basic Excel Formatting Basic Excel Functions Additional Excel Practice

Financial Statements and Cash Flow

Lemonade Stand Part 1 Lemonade Stand Extension Donut Shop Example Lecture Example Practice Problems

Financial Statement Analysis Videos

Calculate and Interpret (EW) Calculate and Interpret (SFIX) Practice Problems

Introduction to Valuation Videos

Extra Practice Practice Problems

Discounted Cash Flow Valuation Videos

Practice Problems In Class Exercises

Interest Rates and Bond Valuation Videos

Practice Problems Class Exercises

Capital Budgeting Tools Videos

Practice Problems Class Exercises

Making Capital Investment Decisions Videos

Lecture Example Practice Problem

Raising Capital and Payout Policy Videos

Practice Problem

Stock Valuation Videos

Practice Problem Class Exercises

Risk and Return Videos

Practice Problem

Video #1: Basic Excel Formatting

This video goes over basic formatting and introduces students to shortcut keys in Excel.

Watch on Vimeo Back to Video List

Video #2: Functions

This video goes over the basic Excel functions. It covers functions related to time value of money, statistical function, logical functions, lookup functions, and custom formatting. You can reference this video throughout the course for more practice in Excel.

Template Solution Watch on Vimeo Back to Video List

Video #3: Additional Excel Practice

This video goes over additional Excel practice exercises ranging from navigation and formatting to using functions. You can reference this video throughout the course for more practice in Excel.

Template Watch on Vimeo Back to Video List

Video #4: Lemonade Stand Part 1

This video works through building an income statement and balance sheet for a fictional Lemonade stand company.

Handout Solution Watch on Screencast Watch on Vimeo Back to Video List

Video #5: Lemonade Stand Extension

This video works through an extension of our lemonade stand example; we add more complex transactions and build out a cash flow statement. The solution file is the same from above.

Handout Solution Watch on Screencast Watch on Vimeo Back to Video List

Video #6: Donut Shop Example

This video works on building and understanding financial statements for a fictional donut shop.

Handout Template Solution Watch on Screencast Back to Video List

Video #7: Lecture Example

This video works through the example from the Free Cash Flow lecture video .

Problem Solution Watch on Screencast Back to Video List

Video #8: Practice Problem 2

This video works through the practice problems worksheet.

Practice Problems Solution Watch on Screencast Back to Video List

Video #9: FSA: Calculate and Interpret: Edwards Lifesciences (EW)

This video goes over financial statement analysis for a real world company. It covers calculating a common-size balance sheet and income statement for Edwards Lifesciences (EW). We also cover a range of ratio calculations. Lastly we briefly discuss interpreting the numbers.

Template Solution Watch on Vimeo Back to Video List

Video #10: FSA: Calculate and Interpret: Stitch Fix (SFIX)

This video goes over financial statement analysis for a real world company. It covers calculating a common-size balance sheet and income statement for Stitch Fix (SFIX). We also cover a range of ratio calculations. Lastly we briefly discuss interpreting the numbers.

Template Solution Watch on Screencast Watch on Vimeo Back to Video List

Video #11: Practice Problem 3

This video works through the practice problems worksheet.

Practice Problems Solution Watch on Screencast Back to Video List

Video #12: Extra Practice

This video works through the extra practice quiz from the end of the Introduction to Valuation Module.

Go to Quiz Watch on Screencast Back to Video List

Video #12: Practice Problems 4

This video works through the practice problems worksheet.

Practice Problems Watch on Screencast Back to Video List

Video #13: Practice Problems 5

This video works through the practice problems worksheet.

Practice Problems Watch on Screencast Back to Video List

Video #14: In Class Exercises 5

This video works through the in class exercise worksheet.

Practice Exercise Worksheet Solution Watch on Screencast Back to Video List

Video #15: Practice Problems 6

This video works through the practice problems worksheet.

Practice Problems Solution Watch on Screencast Back to Video List

Video #16: Class Exercises

This video works through the in class exercise worksheet.

Practice Exercise Worksheet Solution Watch on Screencast Back to Video List

Video #17: Practice Problems

This video works through the practice problems worksheet.

Practice Problems Solution Watch on Screencast Back to Video List

Video #18: Class Exercises

This video works through the in class exercise worksheet.

Practice Exercise Worksheet Solution Watch on Screencast Back to Video List

Video #19: Lecture Example

This video works through the the "Mega Example" from the lecture slides.

View Problem Solution Watch on Screencast Back to Video List

Video #20: Practice Problem

This video works through the practice problems worksheet.

Practice Problems Solution Watch on Screencast Back to Video List

Video #21: Practice Problems

This video works through the practice problems worksheet for theRaising Capital and Payout Policy module.

Practice Problems Solution Watch on Screencast Back to Video List

Video #22: Practice Problems

This video works through the practice problems worksheet for the Stock Valuation module.

Practice Problems Solution Watch on Screencast Back to Video List

Video #22: Class Exercises

This video works through the in class exercise worksheet.

Class Exercise Worksheet Solution Watch on Screencast Back to Video List

Video #23: Practice Problems

This video works through the practice problems worksheet for the Stock Valuation module.

Practice Problems Solution Watch on Screencast Back to Video List