 Personal finance practice problem using Excel, adjustable rate mortgage or arm rate increase. Prepare to get financially fit by practicing personal finance. Here we are in our Excel worksheet. If you don't have access to the Excel worksheet, that's okay because we'll basically build this from a blank sheet. But if you do have access, there's three tabs down below. An example tab, a practice tab, and a blank tab. The example tab in essence being an answer key. Let's take a look at it now. Information on the left. We're going to use that to build our tables on the right. Our scenario being that we have an adjustable rate mortgage, one in which the rate can change over time. And we're going to start out thinking that as of this point in time, what would happen if the rate then increased from the 6.5 to the 8%. We'll think about the increase in the payments, which would be the first thing that we would most likely be concerned about to see if the cash flow is there. And then we might want to build. We would build in our amortization tables and we can get more complex scenarios such as what will be the interest and the loan principle and the equity that would be involved. And then we'll think about it from a different perspective. Looking at the loan, the original loan being a 30 year loan adjustable rate, which was then adjusted, meaning if you were taking on an adjustable rate loan from the start, you might then have more complex scenarios in the future that you would have to be running to say, what would happen if the rate was to increase, you know, five years for now or one year from now and try to think about best case and worst case scenarios, given the risk factors are going up. That's the pros and cons of going from a fixed rate to an adjustable rate. You're typically looking for better terms in terms of the rate upfront, but you've got your more exposure towards risk, which you'd have to approximate in some way in your decision making process. The second tab is going to have the blink information on the right in blue. So you don't have to work on reformatting the whole tables if you don't want to. And then the blink tab, we're going to reformat the full tables basically working from scratch. Now, if you don't have this information, you could build it pretty quickly. Just put this data on the left hand side. You could basically take the whole sheet. I would select the whole sheet format it first for your underlying formatting. You don't need to do this if you have the sheet, which I usually make currency brackets and then remove the decimals and no dollar sign. And then I'm not and then you'll adjust it as needed. For example, formatting these as percentages and adding decimals as needed. Okay, so first we're going to say we got the loan amount at this point in time is at the 131466 the years are 20. And then we have the adjustable rate at the 6.5, which is going to we're going to say what if it increases to 8% what would be the impact on the payments in that case. So that's the first thing we'll think about the original, the original payment or OG amount as they might call it in a more slangy current cool term would be negative PMT or payment calculation. This is the I started with a negative instead of an equal because I think that's the fastest way to type it. Although it's probably more proper to have the negative inside here, but I'm going to put negative PMT. We're going to start off with the rate was the 6.5% at the rate that's a yearly rate. So we're going to divide it by 12 to get the monthly rate. Remember all the time whenever you hear the rate, it's always a yearly rate because that's how we talk about rates because if you talked about them in days or months, they would be small and not very easy to communicate. So comma the number of periods we're going to say is 20 that's in years though and we want it in months. So I'm going to take the 20 times 12 20 times 12 and then comma and the present value is at the 131466. Now we're considering that's the loan balance. We're considering like at this point in time when the rate basically would change is our general idea here. So we're going to say and we'll we'll expand on that later on in the problem. So that's going to be the 980 and then the rate goes up to 8%. So now the new payment new payment amount is going to be less to the same thing with the 8% negative PMT. We might be able to copy this first one down if we wanted to like adjust the absolute ties and mixed references, but we want to recalculate it to negative PMT brackets. The rate now is the 8% that's a yearly rate. So we're going to divide it by 12 to get the monthly rate to comma the number of periods is still at the 20. And so we're going to say that's years. So I got to divide that by 12 to get to the months and then comma present value is still at this 131466. We're at the same point in time with these different rates in essence and something went horribly, horribly wrong because that doesn't that doesn't make sense. Let's do it again. Negative PMT brackets rate is this one divided by 12 comma number of periods is 20 times 12 comma and then the present value the 131466 and enter that looks more reasonable. Okay, so then the difference the increase I'm going to take the bottom one minus the top one because I'm going to say it's an increase in the payment. So I'm going to take the 1100 minus the 980. So there's a 9 119 increase there could be pennies involved here because I don't have the decimals currently I'm looking for the underlying font and underline if I want to add pennies to this. I could do so but I'm not I'm going to take them back out and this is a rounded number that we're working with here. Okay, so now we could think about this from a more complex scenario because you might think. You know, that's the first thing that you would think about can I afford that difference or change but you also might want to think about what's going to have the impact on the interest for my taxes, for example, and what's going to be the impact on my equity kind of calculations if I plan on selling the home at some point in time. So to do that we might want the amortization table, we might want to break this out by year. Again, you can do this online with online tools, but it's not as tight into your worksheet so you can't really run as much scenarios as easily and run different scenarios with more complex worksheets because everything won't be connected in that case. So I would use this to kind of double check the work oftentimes and then try to reconstruct it in our table here. So I'm going to start off with the OG loan. I'll call it the OG loan. So I'm going to take the skinny C and I'm going to make another skinny F out of it. That's the same size, home tab, clipboard, paintbrush it, skinny F. And then let's make our headers. I'm going to call this the OG loan and I'll make that red just to give it that's my title of this of this thing, the OG loan, let's make it red and white. And then this is going to be the year month payment as we've seen in prior presentation. So I'm going to a little bit faster here. Interest loan balance, loan balance. Notice I'm not wrapping the text. I'm using two cells so that I don't make us a wide one, a wide one. I don't want the one too wide. Loan balance. And then I'm going to select these and that one and let's make that black and white. Let's make it black and white and let's center it. There's our headers. I'm going to make these two a little bit more skinny, a little more skinnier. Skinnerize them. I'm going to skinnerize it. That's what I call my diet. I skinnerize myself. I'm doing some skinnerizing. And then I'm going to say this is going to be months, one, 20 times 12, 20 times 12 number of months we need to 240. So one, two, let's do a zero, one, two, and then I'll buckle my shoe real quick. Now I'm back. Now I'm going to copy it down. I'm going to select those three and copy that down to 240. One, two, buckle your shoe and then fill handle it down to 240, which makes sure your shoes buckle because when you auto drive this thing all the way down, you don't want to trip. So then we're going to go to the home tab. We're going to go to the alignment and center it. So there we go. And then this is going to be zero. And then we'll do our roundup formula to get the years here equals roundup. This is useful for the pivot table and the data that we'll do soon. So round up brackets, round up little doggies on the range. And so we're going to say round up that number divided by 12, but then I'm going to round it up with a comma. And then the number of digits is going to be at point one, which means one to the whole number to the full to the whole number. Don't give me don't give me these partial point numbers fraction things. That's not what I'm looking for. And then I double click on the fill handle button and then scroll down and it looks like it's doing what it has been designed to do and then we'll center it's just amazing. This whole thing is just amazing. Home tab alignment and center. And then I'll put some zeros here up top. And then the loan balance is going to be equal to the 131 466 enter the payment is going to be equal to the og payment. The oh to the G payment, which was right there the 980 I'm going to f for that one absolutizing it. We only need a mixed reference but absolute works dollar sign before the E and the ones when I copy it down it doesn't move that cell down because it's outside of my table information here. It's in the data set therefore it needs to be absolutized. That means absolute referencing it. This one is going to be equal to the loan balance times the interest rate, which is the og rate the original low rate that I wish we can hold on to. That needs to be absolutized because it's outside of my table in my table data sets. I'm going to f for it dollar sign before the B and 6 you only need a mixed reference but the absolute one is easy. Divide it by 12 because that would be the interest for a year and we need the month interest and enter. Now we're going to have the loan decrease which you might call the principal decrease if you were so inclined and who's to stop you to be inclined. And then we're in the loan balance which is going to be equal to the prior loan balance minus the decrease and those are both in our area here not in the data set so we don't need to absolutize any of that. No absolute references needed or mixed references or any kind of strange references to obscure things. I'm going to double click on that and then it'll copy it down double click it on the fill button and it should be zero at the bottom zero at the bottom. There's there's what it would be in the O to the G loan payment from that point in time for 20 years. Let's make that blue and then blue and borderized it. I painted it blue and then I put some borders around it because it's so nice looking that people probably want to break into it so then I need to put the borders up. So then I'm going to I'm going to make this a skinny and let's break this out on a year by year breakout. Now we'll do that a couple different formats and then we'll do the same thing for the new loan terms. So I'm going to make I'm going to copy this skinny column F and I'm going to put my cursor on the format painter and skinny up M F to the M FM just like the radio station. And then we're going to say I'm going to copy the same headers over here from the OG to the loan balance copy that and put that right here in the end. But then I'm going to get rid of the months because I don't want months we're talking years over years years over years right click and delete the months. And then the years how many years over years do we want we want one to buckle my shoe and once my shoes on tightly so it doesn't slip and I don't roll an ankle. I'm going to grab that fill handle and I'm going to drive the auto drives it all the way down to 20 20 years. That's what I'm talking about. And then we're going to go to the home tab alignment and center. And so now we're going to do our payments. So we're going to sum up I want to sum up these payments everything in the ones in the one area right there should add up to the 11762 11762. We're going to use a some if a fancy formula some if fancy formula range in it. So we want to pick up this range. I'm going to pick up the whole thing and call them G. I'm just going to say take the whole G column G to G G G. I knew a G G before and then criteria is going to be this one right there and then comma and the some range some range is going to be here. So we're saying everything that has a one in this criteria range over here. I want you to sum up the related number and the payment range. Boom does it and then it just sums that up. It's just incredible incredibly. Let's do it for the interest equals to some if range is going to be the same range right there. And G G again comma and then the criteria the number one again comma and then the some range. Now this is different interest. That's what we want. That's what we want. This one will change from year to year. It's going to have a differential from years one to years two loan decrease. Let's do this one equals the some if I want you to sum it but I got these conditions. This range right here you want to look at that range G G range and then I want you to take this criteria and find it in that range and then some comma the related some range field which is which is this is the loan decrease. That's what I want you to do. So there it is. Now I'm going to do it one more time so that I can copy. Don't delete. Oh, gotta do it again. But we're going to copy it across this time. I'm going to double click on this one. This G G. I don't want the G G to move to the right. So I'm going to say just just F for that one. So it doesn't move this one needs to be a mixed reference because I want it. I want this number here not to move to the right. So I need a dollar sign before the end but not the three because I want it to move down trickiness. The I I is one that we want to move to either J to K so we're going to say OK leave that as is Kype theater cross with the fill auto filling it we should get the same thing. And then I'm going to double click on the fill handle button and it copies it down just just miraculously it's like magic. It's like magic happened magic just happened right from my face. And so then we're going to say this is going to be equal to this one's a little different. I want to take the minimum so equals the men ifs brackets and then the men range is going to be this range G and then comma. And then actually sorry I got that big I got that mixed up the men range is the credit is this range the loan balance range and then comma and then the criteria range that's the G G. That's where G G lives. G G is over there and then we've got this last time trying to pull this one over so you can see it and then the criteria is the one. So there's the one and so that takes the lowest number with a one next to it. There's the one twenty eight one fifty two. Let's fill handle button it just double click on that fill handle button. Let's total it up down below total totally totaled totally totaled. Do you want to total it totally. I totally do. We're going to copy that across now total in it that way. Total total. All right then we're going to go up top and make that blue and border. I'm going to do it also the same thing with a pivot table which we've seen in the past. I'm going to go a little bit more quickly here. I can't copy the headers because there's two lines. So I'm just going to use this header column. I'm going to go all the way down and I'm just going to do the pivot table thing same thing to it. Pivot tape. Insert pivot tape and we're going to put that right there. That's where I want it. That's where I want it. Okay hold on a sec. That's the wrong table. Undo that. That's not a pivot table. Where's where did my undo things go. What happened. Okay I fixed it. Let's insert the right table this time pivot table that's what we're looking at pivot table existing concentrate focus focus like a beam of laser. And then I'm going to take the years over here I'm going to pull that to the left. So there's our years. So now it's pulling over this data and now I'm just going to take not the months but the payment the interest the data and the balance. And so there it is makes a nice table for us just automatically. And then let's format this thing. I'm going to hit the drop downs and say value formatting number formatting. I want to make it currency brackets dollar sign gone decimal down down and OK OK let's do it again. I missed that you did that way too fast. Let's do it again value field settings on the next one. We're going to say number formatting currency brackets dollar sign gone decimal down down OK OK that's still way too fast do it again. Okay let's do it again on the third one. We're going to go number formatting currency brackets dollar sign gone decimal down down OK OK I'll do it one more time slightly different though this one's different because I don't want the sum I want the men the men the men men the next part is the same currency brackets dollar sign gone decimal down down OK OK yeah yeah OK so now let's I'm going to select these columns I'm going to make them I'm going to skinnerize them. Just like when I go on a diet and skinnerize myself. I'm just going to skinnerize myself a little bit right there trim that trim off some skinner skinnerizing. OK so then we're going to we're going to do the same thing for the new rate one so we can do a side by side one things on one side the other things on the other side I call that a side by side so I'm going to say that we're going to I'm going to hide from from F. Well let's first copy the header I'm going to copy this header from the OG let's copy that header here and I'm going to put that over here copy that header right there and this isn't the OG this is going to be the rate change one change. OK so now I'm going to hide now I'm going to hide over here let's actually take the skinny well let's go from the skinny from from H on over to right here H to our her her right click and hide that stuff and then I'm going to make a skinny out of the S. I'm going to put my cursor on the C column home tab clipboard format paint it and skinny skinnerize the S automatic skinnerize and then we'll do our months again this one how long is this one 20 years 200 240 240 so we're going to say one let's say 012 buckle your shoe because you don't want to roll an ankle we're driving a long way here we're going to take the fill handle we're going to drive this on down 240 driving it down. With the with the auto fill we're in our auto and we're driving it down with our shoelace tied buckled however your shoes work to 240. So there it is the 240 does anyone have buckles on the shoe that would be like a boot buck buckle your boot sounds even better buckle your shoe buckle your boot boots have buckles don't they more than shoes I don't know. Anyway zero we're going to say years are going to be round up equals round up round up brackets this thing divided by 12 comma digits point one boom. And I'm going to double click on the fill button handle thing and that'll just summit down summit on down summit on down and then round this and then I'm going to center this one. So then I'm going to put some zeros up top we're going to say the loan balance this time is once again the 131 466 but the payment now under the new thing is rising up to 1100 I'm going to F for that making an absolute. I'm going to take my interest calculation then is the 131466 times the rate which is now 8% at the increase rate I need to make that absolute because it's outside in my data set not in the table I'm working on so I'm going to say F for making an absolute you only need a mixed reference but an absolute is easy. And then we're going to take that and divide it by 12 because that would be per year and we need it per month. The loan decrease is going to be the payment minus the interest. Neither of them need to be absolute or mixed or anything because they're inside the table we're working on the loan balance is going to be equal to the prior balance minus the 223. Neither of them need to be absolute or mixed because they're not coming from the data set but inside the table we're working on we're going to select these four we're going to double click the fill button. The fill handle button all the way down check that it goes down to zero it does. Let's go ahead and format these blue blue and border them to make them blue and once they're nice and blue and look good we got to put borders around it or people will come steal our stuff because it looks so good. So there we go blue and bordered. So then we're going to do the same thing on our year by year breakout. Let's do a year by year breakout. I'm going to copy these headers and put them over here and then I'm going to I'm going to I'm going to skin arise. I'm going to skin arise. Go from s home tab clipboard paintbrush it skinnerize Z making it skinnerized and then I'm going to get rid of the months because I don't need the months I'm going to do this a little bit more quickly this time. Mass rapido and then I'm going to say this is one to buckle my shoe and then drive it down with the auto fill to 20 not too far 20 we're not going that far. I can go I can go there with unbuckled my shoelaces. I can go that far without even my shoes tied. I didn't even need to buckle my shoe to go that far. But then we're going to say this equals the sum if brackets and the range is going to be the range is going to be this range. I'm going to make that absolute selecting F4 on the keyboard criteria then comma is going to be that one and then comma and then the sum range. Notice that this criteria by the way needs to be a mixed reference because I don't want the AA to move. So I'm going to say dollar sign before the letters but not the numbers and then the sum range is the payments. The VV doesn't need any any absolutizing because I want it to move to the right as we go so enter. So so wait a sec something went horribly wrong something went horribly wrong just do it again just do it again you messed it up. Some if brackets range is going to be not you that's the problem. It should be the range of T. That's your problem. You know what your problem is. OK I've got lots of criteria. We're going to go to the criteria that's going to be the zero. That's where we need a dollar sign before that one and then comma the sum range is going to be the payments. OK try it this time. Does it work check it double check it make sure that you didn't mess it up again 13169 C. I know what I'm doing. I know I'm talking about I'm going to copy that to the right and then double click the fill handle down on it. And so then there it is there it is. So then let's do those slightly different one of the loan balance equals the men if s if brackets the men range we want this one. Why why because that's where it happened to live. That's where the range is. That's just it's just the way it is. That's why why why that's criteria is going to be this range T not you T. And then the criteria is going to be the one boom and then it picks up this one down here check it make sure you didn't mess it up. You messed up last time I know I know I messed it up. OK but that was a one time thing because I'm always right. I'm going to sum up the totals here equals the sum of these. We're going to sum these up and then we'll copy this one to the right not all the way to the right but right there. And then let's make this blue and bordered blue and bordered. We'll do the same thing with a pivot table. Let's make a pivot table doing the same thing just to show you the different methods you can do this. I can't take the top I'm just going to take these as the header the header portion. Copy that down to 20. Copy it down to the 20 years 20 years have passed. And it's been an interesting how that happened. I wondered pivot table. Pivot table and then we're going to say existing worksheet. We're going to put that right here and OK OK put the years down. I'm going to copy that to the left and then I don't need the month payments interest decreased balance. Then I'm going to format these so they're not ugly or at least less ugly. Could you make them a little less ugly. I'm going to say OK. It's not my forte making things less ugly but I'll try. Let's do that. And so that's better. That's better. And then I'm going to format this one. We're going to make it currency brackets. Get rid of the dollar sign decimal down down and then OK OK two OK's. One more time. We're going to go number format currency brackets dollar sign decimal down down. OK OK last one's a little bit different. Poco distinct day or something. Wait now you got distracted because you don't know what you're talking. This is going to be a men a men number formatting and then currency brackets dollar sign gone decimal down down. OK OK. And then I'm going to make this a little bit skinner. I'm going to skinnerize it a bit. Do a little skinnerizing like that looks good. OK so that's another way we can do it. This one's too skinny too skinny. It's too skinny. That's not healthy. It's not healthy. OK so there we go. OK so now lastly let's think it let's think about this a little bit more complexly. Let's say that the beginning of the loan. Let's make another skinny column. I'm going to go from Z here and I'm going to put that over here and make that skinny. Let's say that the loan actually started at a 30 year loan which was one five five oh seven four and the years years were 30 years and the rate the rate was the same rate of that 6.5 6.5 or starting rate or 0.065. And I'm going to make that a decimal add some brackets to or some. So let's think about that because we're now we're going to kind of back into this 20 year loan. So notice here we kind of we kind of cheated here we kind of started as if we're at this point in time that's the loan balance. What would be the difference in the payments. But clearly if there's if you're starting at this point in time the 6.5 you might have like a 30 year loan or something like that. And then you got to make projections into the future. What if the rate changed 20 years from now to 8% or something like that. What would be the total play out of that. And clearly if you were planning on selling the home or something like that then you might have different scenarios in terms of what would the equity be at that point in time and so on with different kind of scenarios. So let's I'll try to kind of back into that by by using this scenario. So we're going to say we started off with a 30 year loan at the loan of a 155 74 and then after 20 years we're going to assume that that's when the rate then is going to is going to basically increase right. So I'm going to say OK let's let's imagine that scenario. So let's run it we're going to say OK then the payment payment would be equal to I'm going to calculate the payment which is going to be the PMT. Let's make it negative PMT negative PMT payment under these conditions would be the rate the 6.5% that's yearly. So I'm going to divide it by 12 and then comma number of periods is going to be 30 30 years this time that's in months. I got to multiply it times 12 and then comma and then the present value the 155 74. There's the 980. That's the same 980 that we talked about in the original the original scenario at that 20 years. So we're going to say we started it for a 30 year loan and let's run that amortization table just to just to kind of back into this get a fuller picture. So I'm going to make this a skinny. I'm going to take this skinny. I'm going to put that skinny over here. I'm going to make this blue. And then we're going to go over here and say our headers. So let's go pick up our headers. So I don't have to type them in again. And I'm going to I'm going to copy my headers up top. Same kind of thing. Lo Mismo. Okay. So this is the 30 year. So this is the OG OG this the real OG and then the months are going to be 30 years. That's 360 zero one to buckle your shoes. You need some tight shoes for this one because we're driving this thing down 360. We're going to take that fill handle drive it all the way down 360. You want to be make sure you you know it got your shoes tight on that one. And so we're going to go down 360 360 full 360 rotation. We're going to center it and then the years are going to be equal to we're going to do a round up round up the little doggies. Brackets we're going to take up on K four divided by 12 and then comma and we want to take that to the full digit which is point one. And so that rounds it to one copy that down put in more cursor on the fill button zero up top. And then I'm just going to center this whole thing. I'm just going to check that it goes down to 30 years it does. Of course it does what you think I messed it up or something. I know what I'm talking about. I'm going to make this go skinny and then we're going to put some zeros here. We'll say the balance is at the 155 74 payment is going to be equal to that 980 F4 making it absolute dollar sign before the letters and numbers. You only need a mixed reference but an absolute will do interest prior balance times the rate 6.5 going to make that absolute because I want to copy it down and that's in our data table. So I don't want it to move dollar sign before the number and the letter comma not a comma then divide it by 12 because that was a year we want months. And so we'll subtract this out the 980 minus the 840 then I'll subtract out this. This is the loan balance minus the loan reduction of the 140 selecting those four. If I did it right I should just be able to double click the fill button handle thing and that should then create zero at the bottom. If everything was constructed the way that I imagined it to be my imagination has been has come to life. That's exactly how I imagined it to be. And then I made it then I like then I like constructed the thing in my head that on on the table. So I'm going to make this I'm going to go up top and make this blue and bordered blue and border it. So there we have it and you can see then if I go down and say OK after 10 years after 10 years this is the point that I was trying to get to after 10 years down here. We've got that's where we kind of made that change the 131466 that's the loan balance at our starting point here where we said the 131466 I kind of constructed it to be that so you can. So we thought about it as this point in time but you can think about it as if you know you're going back from a 30 year loan and then where would you be if the rate changed. And if you're starting from the beginning then you got to take into consideration the risk somehow and run like a worst case scenario and a best case scenario and that kind of stuff. To compensate for the added risk that would be taken into consideration which gets complex but that's kind of the idea. Let's make this into our table thing again. I'm going to make take this skinny and make a year by year breakout and I'm going to copy these headers copy those headers put that right here. Let's get rid of the months because I don't need those months. We're not talking months now. We're not talking months. We're going to say one two and then I'm not even going to buckle my shoe. Don't even buckle your shoe because I can do this with my I do this barefoot. I'm not even putting shoes on so you can just you know my feet are tough enough to go down the 30 without the shoes buckle. So I'm going to say this is going to be equal to the some if some if brackets the range is going to be not the month range over there. Don't do that again. That's where I messed up last time. Comma and let's make that absolute F4 on the keyboard and then comma criteria is this one that needs to be mixed because I want it to move down but not to the right. So hold on a second. So I'm going to put a dollar sign before the a dollar sign and then comma criteria some range is going to be the payments do that. That's what I want you to do thing. Check it. Make sure it's not messed up. Make sure it's not messed up. And that's going to be 1029. Okay. That's good. And then I'm going to copy these down. Double clicking. Copy it down. Looks good. Mui being Mui being this one's a little different. We're going to take the men men ifs brackets range. We want the range the men range this one comma. And then the criteria range AJ AJ comma criteria is the one. Copy it down double clicking. Let's put a total down below. Do you want a total column? I totally do. I totally want a total column. We'll sum that up. Why even ask that? Totally. And now we'll copy it across. I'm going to put my cursor right there. Copy it across with the fill handle pull in the fill to the handle to the right. Let's make this blue and border border blue border blue. I'm going to select this and say there's the border. There's the blue border blue. Now after the 10 years that's where we're at at the 10 years. That's when we said that we ran the scenario from you'll recall. So right there the 131 for 66. That's when we ran this scenario after that 20 year time period as of that point in time. But you can also think of it all the way back out in a 30 year loan. Just for example's sake. Let's round it out with a pivot table. This thing needs to be rounded out because there's an edge. Get out the sandpaper around this thing out. Here we go. We'll stand this thing off. So I'm going to take this thing. We'll do the pivot table thing. I'm going to take this all the way down for the 30 years. It's kind of long one because this is the big guy. This is the 360 time period all the way around. And periods and months. So we'll take that and I'm going to go to the insert and then put in the pivot table. Putting in the pivot please. Put in the pivot please putting that right. Hold on a second. That's not how you do it. You messed it up. Do it again. I mean insert pivot table. And then I got to say I want it in the existing worksheet. That's the key point. Then I put it there and OK. And round it out. We're going to say year pulling that to the left. And not the months but the payments the interest to decrease the balance and then make it look better. We're going to hit the drop down value field setting number format currency brackets dollar sign gone decimal down down OK OK next one do it again value field setting number format currency brackets dollar sign gone decimal down down one more time slightly different though last one value field this time not the sum but the men then the same part number formatting currency brackets dollar sign gone decimal down down and OK OK OK. And then I'll skinnerize these skinnerize these just I wish I could skinnerize my belly like that is that easily just click the fill handle and then trim it down like that. What are you talking about? Just OK. And then I'm going to go ahead and I'm going to go ahead and I'm going to go ahead and I'm going to go ahead and I'm going to go ahead and and I'm going to go ahead and so there's the 10 now notice here now you got the side by side scenarios here if you format it this way. Right. So if I had this different side by side I could hide some cells for example to give the side by side. So in this format I gave the amortization we've got then the year by year break out over here. So I might want to see this year by year side by side with the next by year so here's the rate let's unhide some cells to do that I need to unhide some cells right click unhide and so now I've got so I'm going to go back to the beginning and just make sure everything is unhidden I'm going to unhide everything and so now I had the OG amortization table and then I put the year by year right next to it and then I had the rate change amortization table and then the year by year right next to it so you might want to then see the year by year to in order to kind of analyze the difference between the two in a bit more complex than just looking at the payment so I might then hide say the amortization table I might hide from here to here and so I'm going to right click and hide that and then I can say here's my OG from year to year for the 20 years and then I'm going to hide this amortization table and then hide that and so you could see how you could put these two right next to each other for the year by year breakout to give us some more nuance in terms of the total payments for the year the interest for the year the loan decreases and those are the things that you can use to help like think about where your equity will be possibly after a certain range of time and what will be the impact on the interest which could have a tax implication which is less easy to do if you did this and like it like a online or something like this with a calculator you can do these calculations but you can't really run the side by side scenarios as easily and then once you have the side by side scenarios you can make a difference column if you wanted to and look at the differences and then you could basically run different scenarios in terms of the rates for example the changing of the rates so those types of things are much much more flexibility if you're able to construct these things in an Excel worksheet to run those different scenarios gives you some more complexity in it some more nuance in it using the online tools possibly as a double check rather than the thing that you're completely dependent on and then run your worksheets in here for your scenarios so I'm going to unhide this stuff and that's where we stand right now whether the shoes buckled tied or barefoot we're standing that's where we that's where we stand