Manual document handling can be a cause of your company losing money and your employees losing interest in their duties. The easiest way to increase all enterprise procedures and boost your data would be to deal with everything with cutting-edge platform like DocHub. Manage all your files and Save Payment Agreement in Excel in a matter of seconds and save more time for pertinent duties.
With DocHub, you have unrestricted access to your files and Templates available for you at any moment. Check out all functions right now with your free DocHub profile.
welcome back previously we learned how to create a using Excel now were 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 were going to put the original loan amount balance in cell e8 and then were going to start our payment table and cell a1 or excuse me a nine through 89 so payment one two three four five were gonna do 360 payments so Im set entering 360 payments here its a little bit different were 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 crea