Learn how to set up building a capital budgeting scenario using Excel.
- [Instructor] In this Excel example,…we'll look at using capital budgeting…in an applied setting.…The goal here is to help you to understand…how real company investments can be modeled…and decisions made about those investments…all using an Excel framework.…I'm in the 02_01 Excel file.…Let's look at some key points here shall we?…So what I've got is a fairly standard…type of investment.…In particular, to make this relatable…to a wide variety of industries,…we've picked an investment in a student rental property,…but we don't have to be making that specific…type of investment in order to have…a process that's generalizable to…a broader set of corporate investments.…
The keen factors, when we're first setting up this problem,…are the assumptions.…I've got all of my assumptions labeled in blue.…The blue text here indicates assumptions…that we're going to make…that'll affect the model.…The green text are various formulas…that we'll use later on.…Okay, so to begin with I've made an assumption…about occupancy rate.…Occupancy rate simply indicates how often…
- Capital budgeting in Excel
- Using Excel in project selection
- Analyzing capital structure using Excel
- Estimating weighted average cost of capital (WACC)
- Applying Excel to operational budgeting
- Cash flow budgeting
- Stress test tools for budgets
Skill Level Intermediate
Excel 2016: Power Query (Get & Transform)with Oz du Soleil1h 49m Intermediate
Excel: Analyzing and Visualizing Cash Flowswith Curt Frye1h 16m Intermediate
1. Critical Tasks in Corporate Finance
2. Project Selection in Excel
3. WACC and Capital Structure in Excel
4. Operational Budgeting in Excel
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.