Comment Varied Payment with airSlate SignNow

Comment varied payment

hello everyone my from another set of eyes with today's Excel bytes blog post today we're going to take a look at how to create a payment table in Excel using the what-if analysis data table so here's our scenario I want to borrow $100,000 and an interest rate of 3 and 3/4 percent and I'm going to borrow that money for 30 years or 360 months so the first thing I want to do is just create to see what that payment will be so we're going to use the equal PMT function which is it calculates the payment for a loan based on a constant payment and conscious constant interest rates I'll hit tab so what's my rate my rate is 3 and 3/4 percent divided by 12 because it's going to be paid monthly and comma my number of periods is 360 months comma again and my present value is $100,000 close that up hit enter and it shows for 6312 now Excel will show that as a negative because it's a debt that you'll have now if you want to just show that as a positive number all you need to do is put a minus sign or a dash in front of the payment and then looking for convert that to a positive number now what if we want to see what that payment is going to be with various lengths of time and various interest rates I've set up a little table here unhide the rows and columns on and let's see how we can create that so here on our table we have 4 different lengths whether I want to do it for 10 years or 120 months I'm going to do it for 8 180 months 240 months or 360 months and already also set up the interest rates from 3 and 1/2 percent all the way up to 5 percent just to see what those variables would be so what we're gonna do is just highlight that table you know again notice how we have the formula that we had there - PMT in that area in the upper left hand corner we want to make sure we highlight that along with the number of payments as our column headers and the interest rates as our row headers highlight that and then we'll go to the data tab and the what-if analysis and the data tools group and we'll choose data table a dialog box will pop up and we just need to input the row input cell and the column input cell so a row input cell in this case is the 360 months or the number of months there the column input cell is the interest rates because the interest rates here is what's going to fill up that column and all I do is hit OK and voila it gives us all of the rates that we would pay based on the different scenarios of number of periods...