From the course: Excel for Banking Professionals

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Commercial banking financial models

Commercial banking financial models - Microsoft Excel Tutorial

From the course: Excel for Banking Professionals

Start my 1-month free trial Buy for my team

Commercial banking financial models

“

- [Instructor] When you're working in commercial banking, sometimes you'll be building the models for use by other folks in the bank, but then oftentimes you'll also be potentially reviewing models that are created and sent in by customers or business partners, that sort of thing. Let's take a look at an example of how this might work in practice. I'm in the 02_03_Begin Excel workbook. Okay. Now what we've got here is a fairly complicated model for a real estate project, all right? And we're going to assume that perhaps this is something that has been put together as part of our proposal to the bank, and we're trying to evaluate it. So this particular real estate developer has a set of base rents they expect to earn from the project and they've gone through and built out a cashflow forecast based on that. And their cash flow forecast is predicated on certain financing assumptions, shown down here, and cashflow assumptions,…

Contents