课程: Excel Modeling Tips and Tricks

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Thinking through the model structure

Thinking through the model structure - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

开始一个月试用 购买团队方案

Thinking through the model structure

“

- [Instructor] It's fairly easy to go through and build simple Excel models. But what makes Excel modeling a useful skill is the ability to adjust that model based on real-world business conditions. Let's take a look at an example. I'm in the 02_02_Begin Excel file. So what we'd seen previously is we had a simple Excel model that let us go through and figure out what our payments look like and what our balance looked like on a $250,000 loan at 4% for 180 months, i.e. 15 years. I'm going to take that model and we'll apply it in our new sheet, 02_02. And this time we want to add or introduce a little bit of a complexity, a real world kind of situation. In many loans, you'll often find a teaser rate, right? Car loans, home loans, sometimes certainly furniture loans, things like that, they'll often advertise, "Oh, 0% interest for the first 12 months, 24 months, two years," whatever that might be, okay? Sometimes they say no payments, sometimes they have a teaser that kind of goes up for a…

内容