This video goes over basic formatting and introduces students to shortcut keys in Excel.
Watch on Screencast Watch on Vimeo Back to Video ListThis 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 Screencast Watch on Vimeo Back to Video ListThis 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 Screencast Watch on Vimeo Back to Video ListThis 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 ListThis 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 ListThis video works on building and understanding financial statements for a fictional donut shop.
Handout Template Solution Watch on Screencast Back to Video ListThis video works through the example from the Free Cash Flow lecture video .
Problem Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet.
Practice Problems Solution Watch on Screencast Back to Video ListThis 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 ListThis 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 ListThis video goes over financial statement analysis for a real world company. It covers calculating a common-size balance sheet and income statement for Silk Road Medical (SILK). We also cover a range of ratio calculations. Lastly we discuss interpreting the numbers.
Template Solution Watch on Screencast Back to Video ListThis video goes over financial statement analysis for a real world company. It covers calculating a common-size balance sheet and income statement for YETI Holdings Inc (YETI). We also cover a range of ratio calculations. Lastly we discuss interpreting the numbers.
Template Solution Watch on Screencast Watch on Vimeo Back to Video ListThis video goes over financial statement analysis for a real world company. It covers calculating a common-size balance sheet and income statement for DocuSign (DOCU). We also cover a range of ratio calculations. Lastly we discuss interpreting the numbers.
Template Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet.
Practice Problems Solution Watch on Screencast Back to Video ListThis video goes over creating pro forma financial statements using cash as the plug and calculating unlevered cash flows.
Template Solution Watch on Vimeo Back to Video ListThis video extends the pro-forma example to require external financing. Specifically, how to use both debt and cash as the plugs, i.e., use debt financing if cash is no longer available.
Template Solution Watch on Vimeo Back to Video ListThis 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 ListThis video works through the practice problems worksheet.
Practice Problems Watch on Screencast Back to Video ListThis video works through the class worksheet.
Practice Problems Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet.
Practice Problems Watch on Screencast Back to Video ListThis video works through the in class exercise worksheet.
Practice Exercise Worksheet Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet.
Practice Problems Solution Watch on Screencast Back to Video ListThis video works through the in class exercise worksheet.
Practice Exercise Worksheet Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet for the Stock Valuation module.
Practice Problems Solution Watch on Screencast Back to Video ListThis video works through the in class exercise worksheet.
Class Exercise Worksheet Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet.
Practice Problems Solution Watch on Screencast Back to Video ListThis video works through the in class exercise worksheet.
Practice Exercise Worksheet Solution Watch on Screencast Back to Video ListThis video works through the the "Mega Example" from the lecture slides.
View Problem Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet.
Practice Problems Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet for the Risk and Return topic of Module 6.
Practice Problems Solution Watch on Screencast Back to Video ListThis video works through the class worksheet for Module 6.
Template Solution Watch on Screencast Back to Video ListThis video works through the practice problems worksheet for the Cost of Capital topic of Module 7.
Practice Problems Solution Watch on Screencast Back to Video List