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.

Key tools in Excel for commercial banking

Key tools in Excel for commercial banking - Microsoft Excel Tutorial

From the course: Excel for Banking Professionals

Start my 1-month free trial Buy for my team

Key tools in Excel for commercial banking

“

- [Presenter] When you're working in any area, there's probably certain tasks or processes that you do on a frequent basis. And certainly this is true when you're working in banking. So when you're working in banking, particularly commercial banking in this case, there's probably certain Excel functions that you're likely to use over and over again. Now I've listed a few that I think are very common or that I've seen when talking to commercial bankers used over and over again. We've got present value, future value, rate the formula for term, yield, interest payment, effect and the value of a depreciating asset. So let's talk about each of these briefly. So the present value the formulas what you see here and basically you're likely to use this for instance if you're trying to figure out the current value of a stream of cash flows received over time. For instance, if we're looking at a stream of cash flows from an investment…

Contents