# LOANS WITH FIRST PAYMENT DUE IMMEDIATELY

When you borrow cash, you don’t usually make your first payment on the loan at the time you get your cash; instead, you wait for a month (or whatever the payment period is). When you never actually see the cash, for example, if you drive away in a financed new car, sometimes the first payment on the loan is due immediately rather than a month later.[11] Some online calculators let you take this variation into account.

The third tab in my spreadsheet, labeled Loan V2, calculates amortization tables for loans where the first payment is due at the date of the start of the loan.

In Table 3.8, I show (the first few lines of) a 15-year loan taken in May of 2008 for \$175,000 at an APR of 8.00% with the first payment due immediately. As you can see, the format is the same as that of the Loan tab, so make sure you’re using the correct tab when you study a loan.

Table 3.8 A Loan With the First Payment Due When the Loan Is Taken

This sheet for loans with the first payment due at the start of the loan

 Start Month: 5 Start Year: 2008 Nr Mnthly Pmts 180 Principal \$175,000 Rate 8.00%
 Pmt Nr Mnth Year Balance (\$) Payment (\$) Interest (\$) Tot Int/Year (\$) 1 5 2008 173,338.68 1,661.32 0.00 0.00 2 6 2008 172,832.96 1,661.32 1,155.59 1,155.59 3 7 2008 172,323.86 1,661.32 1,152.22 2,307.81 4 8 2008 171,811.37 1,661.32 1,148.83 3,456.64 5 9 2008 171,295.47 1,661.32 1,145.41 4,602.05 6 10 2008 170,776.12 1,661.32 1,141.97 5,744.02 7 11 2008 170,253.31 1,661.32 1,138.51 6,882.52 8 12 2008 169,727.02 1,661.32 1,135.02 8,017.55 9 1 2009 169,197.22 1,661.32 1,131.51 1,131.51 10 2 2009 168,663.88 1,661.32 1,127.98 2,259.49

The noticeable differences between the Loan V2 sheet and the earlier Loan sheet are that the Pmt Nr column starts with 1 rather than with 0. The first payment occurs at Pmt Nr 1, and the balance is reduced from the principal immediately. What’ s happening is that the borrower is receiving \$175,000 and immediately returning \$1,661.32. In other words, this is really a \$173,338.68 loan.