From the course: Excel for Corporate Finance Professionals
Join today to access over 24,900 courses taught by industry experts.
Valuation of assets in Excel - Microsoft Excel Tutorial
From the course: Excel for Corporate Finance Professionals
Valuation of assets in Excel
- [Michael] Perhaps the most common task in all of corporate finance is simply building basic financial models. So let's take a look at an example of the kind of detailed model you might be building if you were working in a corporate finance role. I'm in the 0501 Begin Excel file. Now, this is a model that I've set up, and this is supposed to represent kind of a local coffee shop, right? Or I should say perhaps a store for a coffee shop chain. So think of this as something like a Starbucks or a Dutch Brothers, or perhaps even a Dunkin. To be clear, I don't have any inside information about any of those firms, Starbucks, Dunkin, Dutch Brothers anything of the sort. This is all purely kind of wild speculation on my part, simply based on having gone into the stores before. All right? Now, when I build a model like this one, what we're going to start with is making a series of assumptions. Okay? So we need to start by…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.