# How to program sheet for simple loan payment? **URL:** \ **Category:** In My Humble Opinion\ **Created:** [November 1, 2018, 4:58pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844 "2018-11-01T16:58:36Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Grrr](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/grrr/32/146_2.png) [@Grrr](https://boards.straightdope.com/u/Grrr)\ **Post date:** [November 1, 2018, 4:58pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844/1 "2018-11-01T16:58:36Z")
On Google sheets (which is the same as excel so I’m told). I’ve figure out the “=pmt” part, but how do I get it to display the new balance each time a payment is made? So the loan is 10,000.00. Payment is 110 biweekly. I’ve tried programming the balance cell as follows: “=10,000.00-110”\* or more precisely: “cell the loan amount is in-cell the payment amount is in”. But that’s not working. ETA: Loan is interest free. Thanks ---
**Author:** ![ZipperJJ](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zipperjj/32/211_2.png) [@ZipperJJ](https://boards.straightdope.com/u/ZipperJJ)\ **Post date:** [November 1, 2018, 5:10pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844/2 "2018-11-01T17:10:11Z")
A= previous balance B= payment C = current balance A1 = 10000 B1 = 110 C1 = A1-B1 A2 = C1 B2 = 110 C2 = A2-B2 A3 = C2 B3 = 110 C3 = A3 -B3 ---
**Author:** ![Saint\_Cad](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/saint_cad/32/18907_2.png) [@Saint\_Cad](https://boards.straightdope.com/u/Saint_Cad)\ **Post date:** [November 1, 2018, 5:12pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844/3 "2018-11-01T17:12:56Z")
Try recursion A1 ‘Payment’ B1 ‘Balance’ A2 = 1 B2 = 10000 A3 =A1+1 B3 =B1-110 Copy row 3 and paste as far as you need until it’s paid off If you need a payoff table that uses interest that is pretty straightforward. ---
**Author:** ![Grrr](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/grrr/32/146_2.png) [@Grrr](https://boards.straightdope.com/u/Grrr)\ **Post date:** [November 1, 2018, 5:36pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844/4 "2018-11-01T17:36:10Z")
> [@Saint\_Cad](#): > > Try recursion > A1 ‘Payment’ > B1 ‘Balance’ > A2 = 1 > B2 = 10000 > A3 =A1+1 > B3 =B1-110 > > Copy row 3 and paste as far as you need until it’s paid off > If you need a payoff table that uses interest that is pretty straightforward. Thanks. That did the trick. And easy too! 🙂 One more question: Is there a way to make the dates fill in two weeks apart? Or do I have to enter that manually? Last question, I promise. ---
**Author:** ![Grrr](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/grrr/32/146_2.png) [@Grrr](https://boards.straightdope.com/u/Grrr)\ **Post date:** [November 1, 2018, 5:46pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844/5 "2018-11-01T17:46:35Z")
NM, I figured it out. Thanks again guys. ---
**Author:** ![Saint\_Cad](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/saint_cad/32/18907_2.png) [@Saint\_Cad](https://boards.straightdope.com/u/Saint_Cad)\ **Post date:** [November 1, 2018, 7:57pm UTC](https://boards.straightdope.com/t/how-to-program-sheet-for-simple-loan-payment/823844/6 "2018-11-01T19:57:01Z")
Just so everyone knows the solution to the date problem, Excel uses Julian days. You can see this by inputing a day and changing the format to “General”. So for example to add 7 days to the date in C2 simply type in **=C2+7** then format to a date as necessary. Ask as many questions as you like.