From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using data tables in formulas

Using data tables in formulas - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Using data tables in formulas

“

Two Trees is considering a capital loan so that they can expand production by buying some capital equipment. But they want to see a whole bunch of options for how much this loan is going to cost them depending upon how long it takes them to pay back or maybe how much money they borrow. If you watch the movie on Goal Seek, you saw that we were able to substitute one input, maybe just the interest rate or maybe just the amount that they are borrowing. Well, using the Data Table feature we can substitute one or possibly two entire range of inputs. In this workbook, you want to be in a single variable worksheet. Let's take a look at what we are doing here. We have about $100,000 that we are going to borrow. The company thinks that the interest rate will be about 6% per year. It's thinking of paying it off over a period of 10 years. We'll use the Payment function for that. If you click on the syntax tab, you can see the syntax of the Payment function. So, we see =PMT. What's the interest…

Contents