This video goes over basic formatting and introduces students to shortcut keys in Excel.
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 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 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 works through the practice problems worksheet.
Practice Problems Solution Watch on Screencast 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 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.
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 theRaising Capital and Payout Policy module.
Practice Problems 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 for the Stock Valuation module.
Practice Problems Solution Watch on Screencast Back to Video List