05:57

How to compute NPV for a project with a terminal value

05:26

Diamond Clark | UTK Senior Finance Major and Torch Fund Manager

16:53

Microsoft Excel Collegiate Challenge - Getting Started, Part 3 (let function)

24:29

Microsoft Excel Collegiate Challenge - Getting Started, Part 2 (data tables)

30:18

Microsoft Excel Collegiate Challenge - Getting Started, Part 1 (brute force)

05:06

David Thayer | Finance Speaker Series

01:05

Excel on Rocky Top - Spring 2024 Recap

01:10:36

Walkthrough video - Cornhole Case

43:29

Walkthrough video - Stock Portfolios Case

44:04

Walkthrough video - Project Your Budget Case

04:33

Lindsey Campbell | Updates from the Masters Investment Learning Center

09:44

Brian Stevens visits Finance 306 | Fall 2023

22:23

David Thayer | Director of Corporate Relations | UTK Finance Department

06:23

Hannah Patrignani | UTK Finance Major and Torch Fund Manager

07:22

Dr. Lauren Jacobs | Director of International Programs & Study Abroad

03:30

Lindsey Campbell | Excel Modeling Club @ UTK

02:19

New Course: Finance in Excel

05:31

Dr. David Brown | Microsoft Excel Collegiate Challenge

05:52

Dr. Michael Yates | UTK Finance Faculty

03:03

Emily Becker and Jackie Tenney | Women in Finance, Haslam College of Business

09:55

Dr. Sara Easler | Director of International Programs & Study Abroad, Haslam College of Business

05:22

Kirk Perkins | UTK Finance Student and Torch Fund Manager

28:32

Robert Fuller | Director of Masters in Accounting Program, UTK

13:32

Katie Hogrefe | Campus Recruiter, AllianceBernstein

06:37

Peyton Board and Joe Kato | Tennessee Undergrad Consulting Club | Part 2 of 2

15:04

Peyton Boord and Joe Kato | Tennessee Undergrad Consulting Club | Part 1 of 2

21:33

Holly and Jim Benedict | Part 2 of 2

16:26

Holly and Jim Benedict | Part 1 of 2

04:07

How to compute the WACC

01:54

How to estimate a firm's cost of equity using the CAPM

02:27

How to estimate a firm's cost of equity using the stock price and expected future cash flows

02:20

How to estimate the after tax cost of debt using credit spread data

02:44

How to estimate the after tax cost of debt using YTM

05:33

How to compute the weights for the WACC

03:25

How to compute cash flows from net working capital changes

04:47

How to compute the after tax cash flow from an asset sale

04:33

How to compute incremental cash flow from operations

02:29

How to compute the depreciation tax shield

02:07

How to compute depreciation expense

01:59

How to compute a project's profitability index

03:45

How to compute an equivalent annual annuity EAA

02:48

How to compute the NPV of a stock investment

03:08

How to compute the NPV of a bond investment

05:23

How to compute a project's Internal Rate of Return (IRR)

03:45

How to connect NPV to a stock price change

02:46

How to compute NPV for various cash flow structures

03:14

How to Compute a Project's Net Present Value (NPV)

02:37

How to back out the required rate of return for a constant growth stock

02:14

How to back out the required rate of return for a constant dividend stock

05:19

How to compute a normal and abnormal return (in a CAPM world)

08:18

How to compute beta, expected return, and volatility for a portfolio of the stock market and T bills

02:35

How to compute the beta for a 2-stock portfolio

06:06

How to compute the SML slope

03:32

How to decompose a stock's volatility into systematic and idiosyncratic components

04:40

How to use the CAPM to estimate expected (required) return

06:57

How to compute a portfolio expected return and volatility

06:18

How to compute end of period portfolio weights

03:53

How to compute portfolio weights

04:36

How to calculate a stock's expected return, variance, and standard deviation using probabilities

06:02

How to estimate the mean, variance, and standard deviation from a sample of stock returns