Laptop Payment Plan Form

Instructions and help about Laptop Payment Plan Form

welcome back previously we learned how to create a using Excel now we're going to learn how to make a payment table from the information we have done already the first thing in cell a7 is we want to type payment number then total payment followed by the interest for payment the principal per payment and then the balance after the payment has been made we're going to put the original loan amount balance in cell e8 and then we're going to start our payment table and cell a1 or excuse me a nine through 89 so payment one two three four five we're gonna do 360 payments so I'm set entering 360 payments here it's a little bit different we're gonna use a trick called the fill feature now you want to highlight one through five and then make sure the cursor turns into the black cross as you see here once this cursor has turned into the black cross you can now fill it down to 360 payments oops a little too far and 360 there we go it automatically filled 360 payments for you oops now back to creat