Understanding the Mathematics of Personal Finance

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.

Добавить комментарий

Understanding the Mathematics of Personal Finance

PAYING OFF A LOAN VERY SLOWLY

This section uses a little math, but I’ll go through it slowly in small steps. As with the previous section, this section is not necessary if you don’t want to …

Taxation and Inflation

John Lennon once said, “Life is what happens to you while you’re busy making other plans.” Both taxation and inflation, it seems, are parts of life—they happen to you while …

PARI-MUTUEL BETTING

The pari-mutuel machine system used at race tracks offers a different approach to gambling. A roulette wheel owner is never sure what his or her daily operating cost will be; …

Как с нами связаться:

Украина:
г.Александрия
тел./факс +38 05235  77193 Бухгалтерия
+38 050 512 11 94 — гл. инженер-менеджер (продажи всего оборудования)

+38 050 457 13 30 — Рашид - продажи новинок
e-mail: msd@msd.com.ua
Схема проезда к производственному офису:
Схема проезда к МСД

Партнеры МСД

Контакты для заказов шлакоблочного оборудования:

+38 096 992 9559 Инна (вайбер, вацап, телеграм)
Эл. почта: inna@msd.com.ua

За услуги или товары возможен прием платежей Онпай: Платежи ОнПай