A sinking fund is a special account into which an investor, either an individual or a business, makes annuity payments so that sufficient funds are on hand by a specified date to meet a future savings goal or debt obligation. In its simplest terms, a sinking fund is a financial savings place. As the definition indicates, a sinking fund has is used for one of two main purposes:
Whether the sinking fund is for capital savings or debt retirement, the mathematical calculations and procedures are identical. However, this section will focus on using sinking funds for debt retirement. Now, why discuss sinking funds in the chapter about bonds? Many bonds carry a sinking fund provision. Once the bond has been issued, the company must start regular contributions to a sinking fund because large sums of money have been borrowed over a long time frame, and investors need assurance that the bond issuer will be able to repay its debt upon bond maturity.
To provide further assurance to bondholders, the sinking fund is typically managed by a neutral third party rather than the bond-issuing company. This third-party company ensures the integrity of the fund, working toward the debt retirement in a systematic manner according to the provisions of the sinking fund. Investors much prefer bonds or debentures that are backed by sinking funds and third-party management because they are less likely to default.
Sinking funds are an alternative way to pay off a loan or debt. A sinking fund is used to accumulate the principal only owed on a debt so that the principal of the debt can be repaid in its entirety on the maturity date. For example, sinking funds are used to accumulate the face value of bonds so that money is available to pay the face value at maturity. Sinking funds are NOT used to pay the interest due on the debt. For example, sinking funds are not used to pay the periodic bond payments.
In the case of bonds or debentures, sinking funds are most commonly set up as ordinary simple annuities that match the timing of the bond interest payments. Thus, when a bond issuer makes a bond interest payment to its bondholders, it also makes an annuity payment to its sinking fund. In other applications, any type of annuity is possible, whether ordinary or due, general or simple.
When a sinking fund is used to retire a debt, there are two interest rates associated with the debt.
When a sinking fund is established to retire a debt, there are two different periodic costs or expenses made in relation to the debt.
The periodic cost of a debt retired with a sinking fund is the total amount paid each payment interval as a result of the debt.
The payments made into a sinking fund form an annuity, and are calculated the same as any other annuity payment with the future value of the sinking fund set to the loan amount and using the interest rate associated with the sinking fund. Because the goal of the sinking fund is to accumulate at least the required amount, sinking fund payments are always rounded UP to the next cent. Consequently, all of the payments made to a sinking fund, including the last payment, are the same.
A bank issued a [latex]\$10,000,000[/latex] face value bond carrying a [latex]5.1\%[/latex] coupon and [latex]30[/latex] years until maturity. The bank set up a sinking earning [latex]4.5\%[/latex] to accumulate the face value of the bond.
Step 1: The given information for the sinking fund is
Because no other information is given, the frequency of the payments (for both the bond and the sinking fund) and the compounding frequencies (for the coupon rate and the sinking fund rate) are assumed to be semi-annual.
[latex]\begin FV & = & \$10,000,000 \\ I/Y & = & 4.5\% \\ P/Y & = & 2 \\ C/Y & = & 2 \\ t & = & 30 \mbox < years>\end[/latex]
Step 2: Calculate the sinking fund payment.
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 30=60[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]10,000,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]4.5[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]PMT=\$80,353.2748. \rightarrow \$80,353.28[/latex]
The sinking fund payment is [latex]\$80,353.28[/latex]. Remember, sinking fund payments always get rounded UP to the next cent.
Step 3: Calculate the bond payment.
The bond payments are [latex]\$255,000[/latex].
Step 4: Calculate the periodic cost of the debt.
Step 5: Write as a statement.
The periodic cost of the debt is [latex]\$335,353.28[/latex]. This means that every six months the bank must pay out a total of [latex]\$335,353.28[/latex] because of the debt. Of this amount, [latex]\$255,000[/latex] goes to paying the bond payments and [latex]\$80,353.28[/latex] goes to the sinking fund to accumulate the [latex]\$10,000,000[/latex] face value of the bonds.
The goal of a sinking fund is to accumulate the loan amount so that the loan amount can be paid off in one lump-sum payment at the end of the term. So, the loan amount becomes the future value of the sinking fund.
Sinking fund payments always get rounded UP to the next cent. This ensures that the final amount in the sinking fund will be at or over the loan amount. Rounding the payment up guarantees that the balance in the sinking fund at the end of the term will always be at or over the loan amount.
1) A company issued bonds worth [latex]\$200,000[/latex] to raise money to build an expansion to its factory. The bonds have a coupon rate of [latex]3.9\%[/latex] compounded semi-annually and ten years to maturity. The company established a sinking fund earning [latex]2.7\%[/latex] compounded semi-annually to accumulate the face value of the bonds.
a. Calculate the sinking fund payment.
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 10=20[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]200,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]2.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
b. Calculate the periodic expense of the debt.
Write as a statement.
When a company takes out a loan or issues bonds, these are debts to the company. Through a sinking fund the company saves up money to extinguish that debt. The book value of the debt is the difference between the principal amount owing on the debt (i.e. the loan amount or face value of the bond) and the accumulated balance in the sinking fund at any point in time. For example, if the company issued [latex]\$10[/latex] million in bonds and has accumulated [latex]\$1[/latex] million in its sinking fund, the book value of the debt is [latex]\$9[/latex] million.
A sinking fund schedule is a table that records the sinking fund contribution, the interest earned by the fund, the increase in the fund, the accumulated balance for every payment, and the current book value of the debt. A sinking fund schedule is very similar to an amortization schedule except that the balance increases instead of decreases and the interest is earned instead of being paid.
A sinking fund schedule has six columns:
To fill in a sinking fund schedule, you first need to have all of the details about the fund, including the loan amount ([latex]FV[/latex]), the sinking fund payment ([latex]PMT[/latex]), the number of payments ([latex]N[/latex]), and the sinking fund’s interest rate. If any of these quantities are missing, calculate out the missing value before completing the sinking fund schedule.
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]0[/latex] | [latex]0[/latex] | [latex]\text^1[/latex] | |||
[latex]1[/latex] | [latex]PMT^2[/latex] | [latex]INT^3[/latex] | [latex]INC^4[/latex] | [latex]BAL^5[/latex] | [latex]BV^6[/latex] |
[latex]2[/latex] | [latex]PMT^2[/latex] | [latex]INT^3[/latex] | [latex]INC^4[/latex] | [latex]BAL^5[/latex] | [latex]BV^6[/latex] |
[latex]\vdots[/latex] | [latex]\vdots[/latex] | [latex]\vdots[/latex] | [latex]\vdots[/latex] | [latex]\vdots[/latex] | [latex]\vdots[/latex] |
[latex]N-1[/latex] | [latex]PMT^2[/latex] | [latex]INT^3[/latex] | [latex]INC^4[/latex] | [latex]BAL^5[/latex] | [latex]BV^6[/latex] |
[latex]N[/latex] | [latex]PMT^2[/latex] | [latex]INT^3[/latex] | [latex]INC^4[/latex] | [latex]BAL^5[/latex] | [latex]BV^6[/latex] |
Totals | [latex]\text^8[/latex] | [latex]\text^10[/latex] | [latex]\text^9[/latex] |
Follow these steps to fill in a sinking fund schedule.
Step 1: In row [latex]0[/latex], the only entries are in the balance and book value columns. The initial balance is [latex]0[/latex] and the initial book value is the loan amount (the future value of the sinking fund).
Step 2: Each entry in the payment column is the sinking fund payment. If you have to calculate out the payment, remember to round the payment up to the next cent. All of the payments in this column are the same, including the last payment.
Step 3: Calculate the interest. The interest is the balance from the previous row times the periodic interest rate:
Note: this calculation uses the periodic sinking fund rate, not the periodic interest rate associated with the loan.
Step 4: Calculate the increase. The increase is the sum of the payment and the interest:
Step 5: Calculate the new balance. The balance is the sum of the balance in the previous row and the increase:
Step 6: Calculate the new book value. The book value is the difference between the book value from the previous row and the increase:
Step 7: For each payment, repeat steps [latex]2[/latex] through [latex]6[/latex], including for the last row.
Step 8: The total payments is the sum of the payment column:
Step 9: The total increase is the sum of the increase column, and is the last balance entry:
Step 10: The total interest is the sum of the interest column, and equals the difference between the other two column totals:
The manual calculation of the interest entry above is based on the assumption that the payment frequency and the compounding frequency are equal. If the payment frequency and the compounding frequency are not equal, an interest conversion would be required to convert the interest rate to the equivalent rate with the compounding frequency equal to the payment frequency. However, if you use the TI BAII Plus’s built-in amortization worksheet (described below), no interest conversion is required.
As you fill in the schedule, round the entries to two decimal places.
The sinking fund schedule presented here assumes the payments are made at the end of the payment interval. That is, the sinking fund schedule presented above is for an ordinary annuity. If the sinking fund is an annuity due (payments at the beginning), the calculations are the same except for the interest column, where the interest is based on both the balance from the previous row and the payment.
A company has to repay a [latex]\$20,000[/latex] loan in two years. The company establishes a sinking fund earning [latex]4\%[/latex] compounded semi-annually and makes end-of-six-month payments into the fund to accumulate the loan amount. Construct the sinking fund schedule.
Solution
Step 1: The given information is
[latex]\begin FV & = & \$20,000 \\ I/Y & = & 4\% \\ P/Y & = & 2 \\ C/Y & = & 2 \\ t & = & 2 \mbox < years>\end[/latex]
Step 2: Calculate the sinking fund payment.
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 2=4[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]20,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
The sinking fund payment is [latex]\$4,852.48[/latex].
Step 3: Complete the sinking fund schedule.
Because the payment frequency and the compounding frequency are equal, no interest conversion is required. The calculations for each entry are shown in blue. The periodic interest rate is [latex]i=\frac=2\%[/latex].
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]0[/latex] | [latex]\$0[/latex] | [latex]\$20,000[/latex] | |||
[latex]1[/latex] | [latex]\$4,852.48[/latex] | [latex]\;\;\;\;\;\;\;\;\;\;\$0\;\;\;\;\;\;\;\;\;\;[/latex][latex]\color<(0 \times 0.02)>[/latex] | [latex]\$4,852.48[/latex][latex]\color[/latex] | [latex]\$4,852.48[/latex][latex]\color[/latex] | [latex]\$15,147.52[/latex][latex]\;\color[/latex] |
[latex]2[/latex] | [latex]\$4,852.48[/latex] | [latex]\;\;\$97.05\;\;[/latex][latex]\color<(4582.48 \times 0.02)>[/latex] | [latex]\$4,949.53[/latex][latex]\color[/latex] | [latex]\$9,802.01[/latex][latex]\;\color[/latex] | [latex]\$10,197.99[/latex][latex]\color[/latex] |
[latex]3[/latex] | [latex]\$4,852.48[/latex] | [latex]\;\$196.04\;[/latex][latex]\color<(9802.01 \times 0.02)>[/latex] | [latex]\$5,048.52[/latex][latex]\color[/latex] | [latex]\$14,850.5[/latex][latex]\;\color[/latex] | [latex]\$5,149.47[/latex][latex]\color[/latex] |
[latex]4[/latex] | [latex]\$4,852.48[/latex] | [latex]\$297.01[/latex][latex]\color<(14,850.53 \times 0.02)>[/latex] | [latex]\$5,149.49[/latex][latex]\color[/latex] | [latex]\$20,000.02[/latex][latex]\color[/latex] | [latex]-\$0.02[/latex][latex]\;\color[/latex] |
Totals | [latex]\$19,409.92[/latex][latex]\color<(4 \times 4852.48)>[/latex] | [latex]\$590.10[/latex][latex]\color[/latex] | [latex]\$20,000.02[/latex] |
In the previous example, the final balance is slightly more than the required [latex]\$20,000[/latex] because the sinking fund payment was rounded up to the next cent. By rounding the payment up, we ensure that the sinking fund has at least [latex]\$20,000[/latex] at the end of the term.
Although the calculations in a sinking fund schedule are relatively straightforward, the manual calculations are time-consuming, especially when the schedule has a lot of rows. The amortization worksheet on a financial calculator, such as the TI BAII Plus, can be used to quickly calculate the entries for each row of the schedule.
To use the amortization worksheet to complete a sinking fund schedule:
On the amortization worksheet, [latex]BAL[/latex] is the balance entry, [latex]PRN[/latex] is the increase entry, and [latex]INT[/latex] is the interest entry.
You cannot get the entries for the last column, the book value, from the amortization worksheet on the calculator. This entry will still need to be calculated manually. You can find the book value for any row by subtracting the balance for the row from the loan amount:
Make sure to re-enter [latex]PMT[/latex] rounded up to the next cent before using the amortization worksheet. Otherwise, you will not get the correct entries for the sinking fund schedule.
As you read the entries off of the amortization worksheet on the calculator and put them in the schedule, round the entries to [latex]2[/latex] decimal places.
A company set up a sinking fund to accumulated the [latex]\$30,000[/latex] they need to repay a loan. The sinking fund earns [latex]3.5\%[/latex] compounded semi-annually. The company made semi-annual deposits into the sinking fund for [latex]2.5[/latex] years. Construct the sinking fund schedule.
Solution
Step 1: Calculate the sinking fund deposit.
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 2.5=5[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]30,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]3.5[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
Step 2: Enter the information into the time value of money buttons on the calculator.
PMT Setting | END |
[latex]N[/latex] | [latex]5[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]30,000[/latex] |
[latex]PMT[/latex] | [latex]-5,793.65[/latex] |
[latex]I/Y[/latex] | [latex]3[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
Step 4: Complete the sinking fund schedule using the amortization worksheet on the calculator.
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]0[/latex] | [latex]\$0[/latex] | [latex]\$30,000[/latex] | |||
[latex]1[/latex] | [latex]\$5,793.65[/latex] | [latex]\$0[/latex] | [latex]\$5,793.65[/latex] | [latex]\$5,793.65[/latex] | [latex]\$24,206.35[/latex] |
[latex]2[/latex] | [latex]\$5,793.65[/latex] | [latex]\$101.39[/latex] | [latex]\$5,895.04[/latex] | [latex]\$11,688.69[/latex] | [latex]\$18,311.31[/latex] |
[latex]3[/latex] | [latex]\$5,793.65[/latex] | [latex]\$204.55[/latex] | [latex]\$5,998.20[/latex] | [latex]\$17,686.89[/latex] | [latex]\$12,313.11[/latex] |
[latex]4[/latex] | [latex]\$5,793.65[/latex] | [latex]\$309.52[/latex] | [latex]\$6,103.17[/latex] | [latex]\$23,790.06[/latex] | [latex]\$6,209.94[/latex] |
[latex]5[/latex] | [latex]\$5,793.65[/latex] | [latex]\$416.33[/latex] | [latex]\$6,209.98[/latex] | [latex]\$30,000.04[/latex] | [latex]-\$0.04[/latex] |
Totals | [latex]\$28,968.25[/latex] | [latex]\$1,031.79[/latex] | [latex]\$30,000.04[/latex] |
2) A [latex]\$10,000[/latex] loan was repaid using a sinking fund that was earning [latex]4.5\%[/latex] compounded semi-annually. Deposits were made every six months into the fund for three years to accumulate the loan amount. Construct the sinking fund schedule.
Solution
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 3=6[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]10,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]4.5[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]0[/latex] | [latex]\$0[/latex] | [latex]\$10,000[/latex] | |||
[latex]1[/latex] | [latex]\$1,575.35[/latex] | [latex]\$0[/latex] | [latex]\$1,575.35[/latex] | [latex]\$1,575.35[/latex] | [latex]\$8,424.65[/latex] |
[latex]2[/latex] | [latex]\$1,575.35[/latex] | [latex]\$35.45[/latex] | [latex]\$1,610.80[/latex] | [latex]\$3,186.15[/latex] | [latex]\$6,813.85[/latex] |
[latex]3[/latex] | [latex]\$1,575.35[/latex] | [latex]\$71.69[/latex] | [latex]\$1,647.04[/latex] | [latex]\$4,833.18[/latex] | [latex]\$5,166.82[/latex] |
[latex]4[/latex] | [latex]\$1,575.35[/latex] | [latex]\$108.75[/latex] | [latex]\$1,684.10[/latex] | [latex]\$6,517.28[/latex] | [latex]\$3,482.72[/latex] |
[latex]5[/latex] | [latex]\$1,575.35[/latex] | [latex]\$146.64[/latex] | [latex]\$1,721.99[/latex] | [latex]\$8,239.27[/latex] | [latex]\$1,760.73[/latex] |
[latex]6[/latex] | [latex]\$1,575.35[/latex] | [latex]\$185.38[/latex] | [latex]\$1,760.73[/latex] | [latex]\$10,000[/latex] | [latex]\$0[/latex] |
Totals | [latex]\$9,452.10[/latex] | [latex]\$547.90[/latex] | [latex]\$10,000[/latex] |
Similar to working with loans, the amortization worksheet on the financial calculator can be applied to sinking funds to find a partial sinking fund schedule, to find the total interest or the total increase for a series of payments, to find the balance in the fund after any payment, or to find the book value after any payment.
A company took out a [latex]\$25,000[/latex] loan and establishes a sinking fund earning [latex]2.7\%[/latex] compounded semi-annually to accumulate the loan amount. The company makes semi-annual payments into the fund for ten years. Construct a partial sinking fund schedule showing the details of payment #[latex]7[/latex], the last two payments and the totals.
Step 1: Calculate the sinking fund deposit.
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 10=20[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]25,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]2.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
Step 2: Enter the information into the time value of money buttons on the calculator.
PMT Setting | END |
[latex]N[/latex] | [latex]20[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]25,000[/latex] |
[latex]PMT[/latex] | [latex]-1,097.21[/latex] |
[latex]I/Y[/latex] | [latex]2.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
Step 3: Complete the partial sinking fund schedule using the amortization worksheet on the calculator.
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]7[/latex] | [latex]\$1,097.21[/latex] | [latex]\$91.93[/latex] | [latex]\$1,189.14[/latex] | [latex]\$7,988.62[/latex] | [latex]\$17,011.38[/latex] |
[latex]19[/latex] | [latex]\$1,097.21[/latex] | [latex]\$299.54[/latex] | [latex]\$1,396.75[/latex] | [latex]\$23,584.57[/latex] | [latex]\$1,415.43[/latex] |
[latex]20[/latex] | [latex]\$1,097.21[/latex] | [latex]\$318.39[/latex] | [latex]\$1,415.60[/latex] | [latex]\$25,000.17[/latex] | [latex]-\$0.17[/latex] |
Totals | [latex]\$21,944.20[/latex] | [latex]\$3,055.97[/latex] | [latex]\$25,000.17[/latex] |
To use the amortization worksheet to find the total interest, the total increase or the balance for a sinking fund:
The [latex]PRN[/latex] entry on the amortization worksheet is the sum of the increase entries in the sinking fund schedule starting at payment number [latex]P_1[/latex] and ending at payment number [latex]P_2[/latex]. For example, if [latex]P_1=4[/latex] and [latex]P_2=7[/latex]. the [latex]PRN[/latex] entry tells you the sum of the increase column in the sinking fund schedule starting with payment number [latex]4[/latex] and ending with payment number [latex]7[/latex].
The [latex]INT[/latex] entry on the amortization worksheet is the sum of the interest entries in the sinking fund schedule starting at payment number [latex]P_1[/latex] and ending at payment number [latex]P_2[/latex]. For example, if [latex]P_1=4[/latex] and [latex]P_2=7[/latex], the [latex]INT[/latex] entry tells you the sum of the interest column in the sinking fund schedule starting with payment number [latex]4[/latex] and ending with payment number [latex]7[/latex].
The calculator thinks in terms of payment numbers, not years. That is, [latex]P_1[/latex] and [latex]P_2[/latex] must be payment numbers.
A company issued [latex]\$500,000[/latex] worth of bonds with [latex]15[/latex] years to maturity. The company set up a sinking fund earning [latex]4.7\%[/latex] compounded semi-annually to accumulate the face value of the bonds and made semi-annual payments into the sinking fund.
Step 1: Calculate the payment.
PMT Setting | END |
[latex]N[/latex] | [latex]12 \times 15=30[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]500,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]4.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
Step 2: Calculate the balance for payment [latex]18[/latex].
To find the balance for payment [latex]18[/latex], set [latex]P_1=18[/latex] and [latex]P_2=18[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]30[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]500,000[/latex] |
[latex]PMT[/latex] | [latex]-11,663.61[/latex] |
[latex]I/Y[/latex] | [latex]4.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]18[/latex] |
[latex]P_2[/latex] | [latex]18[/latex] |
After [latex]18[/latex] payments, the balance in the fund is [latex]\$257,632.82[/latex].
Step 3: Calculate the increase for payment [latex]9[/latex].
To find the interest for payment [latex]9[/latex], set [latex]P_1=9[/latex] and [latex]P_2=9[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]30[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]500,000[/latex] |
[latex]PMT[/latex] | [latex]-11,663.61[/latex] |
[latex]I/Y[/latex] | [latex]4.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]9[/latex] |
[latex]P_2[/latex] | [latex]9[/latex] |
The increase for payment [latex]9[/latex] is [latex]\$14,045.45[/latex].
Step 4: Calculate the interest paid for year ten.
To find the interest paid in year two, set [latex]P_1[/latex] to first payment number of year ten and [latex]P_2[/latex] to last payment of year ten. There are [latex]2[/latex] payments a year, so the last payment made in year two is [latex]20[/latex] ([latex]2\times 10[/latex]). The first payment made in year ten is [latex]19[/latex] ([latex]2\times 9+1[/latex]). So, to find the interest paid in year ten, set [latex]P_1=19[/latex] and [latex]P_2=20[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]30[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]500,000[/latex] |
[latex]PMT[/latex] | [latex]-11,663.61[/latex] |
[latex]I/Y[/latex] | [latex]4.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]10[/latex] |
[latex]P_2[/latex] | [latex]20[/latex] |
The interest paid in year ten is [latex]\$12,525.11[/latex].
Step 5: Calculate the book value after eight years.
To find the book value, calculate the balance after eight years and then subtract the balance from [latex]\$500,000[/latex]. To find the balance after eight years, enter the payment number that corresponds to the last payment made in year eight. There are [latex]2[/latex] payments a year, so the last payment made in year eight is [latex]16[/latex] ([latex]8\times 2[/latex]). So, to find the balance after eight years, set [latex]P_1=16[/latex] and [latex]P_2=16[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]30[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]500,000[/latex] |
[latex]PMT[/latex] | [latex]-11,663.61[/latex] |
[latex]I/Y[/latex] | [latex]4.7[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]16[/latex] |
[latex]P_2[/latex] | [latex]16[/latex] |
[latex]\begin\mbox & = & 500,000-223,407.95 \\ & = & \$276,592.05 \end[/latex]
Step 6: Write as a statement.
After eight years, the book value in the fund is [latex]\$276,592.05[/latex].
A common mistake occurs in translating years into payment numbers. You often need to find the total interest or the total increase in the sinking fund for a particular year. To do this, you need to set [latex]P_1[/latex] equal to the number of the first payment that occurs in that year and [latex]P_2[/latex] equal to the number of the last payment that occurs in that year.
For example, suppose you have monthly payments and you want to know the total interest in the fourth year. In error, you might calculate that the fourth year begins with payment [latex]36[/latex] and ends with payment [latex]48[/latex], and so enter [latex]P_1=36[/latex] and [latex]P_2=48[/latex]. But the [latex]36^[/latex] payment is actually the last payment of the third year. The first payment to occur in year four is the [latex]37^[/latex]. So, if you wanted to find the total interest in year [latex]4[/latex], [latex]P_1=37[/latex] and [latex]P_2=48[/latex].
When you need to find the first payment number and last payment number for a particular year, there are two methods you can use to calculate the correct payment numbers.
3) A company sold [latex]\$100,000[/latex] worth of bonds and set up a sinking fund earning [latex]4\%[/latex] compounded semi-annually to retire the bonds in nine years. The company made semi-annual deposits into the sinking fund.
a. Calculate the payment.
PMT Setting | END |
[latex]N[/latex] | [latex]2 \times 9=18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]?[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
b. Calculate the interest for the [latex]10^[/latex] payment.
PMT Setting | END |
[latex]N[/latex] | [latex]18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-4,670.22[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]10[/latex] |
[latex]P_2[/latex] | [latex]10[/latex] |
c. Calculate the increase for the [latex]7^[/latex] payment.
PMT Setting | END |
[latex]N[/latex] | [latex]18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-4,670.22[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]7[/latex] |
[latex]P_2[/latex] | [latex]7[/latex] |
d. Calculate the balance at the end of year [latex]8[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-4,670.22[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]16[/latex] |
[latex]P_2[/latex] | [latex]16[/latex] |
e. Calculate the interest for year [latex]3[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-4,670.22[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]5[/latex] |
[latex]P_2[/latex] | [latex]6[/latex] |
f. Calculate the increase for year [latex]6[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-4,670.22[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]11[/latex] |
[latex]P_2[/latex] | [latex]12[/latex] |
g. Calculate the book value after year [latex]5[/latex].
PMT Setting | END |
[latex]N[/latex] | [latex]18[/latex] |
[latex]PV[/latex] | [latex]0[/latex] |
[latex]FV[/latex] | [latex]100,000[/latex] |
[latex]PMT[/latex] | [latex]-4,670.22[/latex] |
[latex]I/Y[/latex] | [latex]4[/latex] |
[latex]P/Y[/latex] | [latex]2[/latex] |
[latex]C/Y[/latex] | [latex]2[/latex] |
[latex]P_1[/latex] | [latex]10[/latex] |
[latex]P_2[/latex] | [latex]10[/latex] |
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]0[/latex] | [latex]\$0[/latex] | [latex]\$10,000[/latex] | |||
[latex]1[/latex] | [latex]\$1,185.21[/latex] | [latex]\$0[/latex] | [latex]\$1,185.21[/latex] | [latex]\$1,185.21[/latex] | [latex]\$8,814.79[/latex] |
[latex]2[/latex] | [latex]\$1,185.21[/latex] | [latex]\$17.96[/latex] | [latex]\$1,203.17[/latex] | [latex]\$2,388.38[/latex] | [latex]\$7,611.62[/latex] |
[latex]3[/latex] | [latex]\$1,185.21[/latex] | [latex]\$36.19[/latex] | [latex]\$1,221.40[/latex] | [latex]\$3,609.78[/latex] | [latex]\$6,390.22[/latex] |
[latex]4[/latex] | [latex]\$1,185.21[/latex] | [latex]\$54.70[/latex] | [latex]\$1,239.91[/latex] | [latex]\$4,849.68[/latex] | [latex]\$5,150.32[/latex] |
[latex]5[/latex] | [latex]\$1,185.21[/latex] | [latex]\$73.48[/latex] | [latex]\$1,258.69[/latex] | [latex]\$6,108.38[/latex] | [latex]\$3,891.62[/latex] |
[latex]6[/latex] | [latex]\$1,185.21[/latex] | [latex]\$92.55[/latex] | [latex]\$1,277.76[/latex] | [latex]\$7,386.14[/latex] | [latex]\$2,613.86[/latex] |
[latex]7[/latex] | [latex]\$1,185.21[/latex] | [latex]\$111.92[/latex] | [latex]\$1,297.13[/latex] | [latex]\$8,683.27[/latex] | [latex]\$1,316.73[/latex] |
[latex]8[/latex] | [latex]\$1,185.21[/latex] | [latex]\$131.57[/latex] | [latex]\$1,316.78[/latex] | [latex]\$10,000.05[/latex] | [latex]-\$0.05[/latex] |
Totals | [latex]\$9,481.68[/latex] | [latex]\$518.37[/latex] | [latex]\$10,000.05[/latex] |
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]5[/latex] | [latex]\$342,419.75[/latex] | [latex]\$50,514.79[/latex] | [latex]\$392,934.54[/latex] | [latex]\$1,836,214.23[/latex] | [latex]\$3,163,785.77[/latex] |
[latex]6[/latex] | [latex]\$342,419.75[/latex] | [latex]\$64,267.50[/latex] | [latex]\$406,687.25[/latex] | [latex]\$2,242,901.47[/latex] | [latex]\$3,757,098.53[/latex] |
[latex]11[/latex] | [latex]\$342,419.75[/latex] | [latex]\$140,597.13[/latex] | [latex]\$483,016.88[/latex] | [latex]\$4,500,077.59[/latex] | [latex]\$49,922.41[/latex] |
[latex]12[/latex] | [latex]\$342,419.75[/latex] | [latex]\$157,502.72[/latex] | [latex]\$499,922.47[/latex] | [latex]\$5,000,000.05[/latex] | [latex]-\$0.05[/latex] |
Totals | [latex]\$4,109,037[/latex] | [latex]\$890,963.05[/latex] | [latex]\$5,000,000.05[/latex] |
Payment Number | Payment | Interest | Increase | Balance | Book Value |
[latex]37[/latex] | [latex]\$6,800.52[/latex] | [latex]\$1,093.21[/latex] | [latex]\$7,893.73[/latex] | [latex]\$271,355.37[/latex] | [latex]\$528,644.63[/latex] |
[latex]95[/latex] | [latex]\$6,800.52[/latex] | [latex]\$3,236.08[/latex] | [latex]\$10,036.60[/latex] | [latex]\$789,922.04[/latex] | [latex]\$10,077.96[/latex] |
[latex]96[/latex] | [latex]\$6,800.52[/latex] | [latex]\$3,277.72[/latex] | [latex]\$10,078.24[/latex] | [latex]\$800,000.29[/latex] | [latex]-\$0.29[/latex] |
Totals | [latex]\$652,849.92[/latex] | [latex]\$890,963.05[/latex] | [latex]\$5,000,000.05[/latex] |
a. [latex]\$20,578.40[/latex]; b. [latex]\$36,828.40[/latex]; c. [latex]\$84,816.10[/latex]; d. [latex]\$7,671.33[/latex]; e. [latex]\$23,638.11[/latex]; f. [latex]\$15,907.66[/latex]; g. [latex]\$50,671.61[/latex]; h. [latex]\$171,281.91[/latex]
a. [latex]\$2,342.79[/latex]; b. [latex]\$5,467.79[/latex]; c. [latex]\$45,878.92[/latex]; d. [latex]\$2,329.50[/latex]; e. [latex]\$3,248.94[/latex]; f. [latex]\$2,694.64[/latex]; g. [latex]\$5,518.73[/latex]; h. [latex]\$36,885.21[/latex]
a. [latex]\$19,284.57[/latex]; b. [latex]\$33,534.57[/latex]; c. [latex]\$434,053.97[/latex]; d. [latex]\$3,033.85[/latex]; e. [latex]\$25,829.55[/latex]; f. [latex]\$13,789.23[/latex]; g. [latex]\$100,229.96[/latex]; h. [latex]\$588,944.27[/latex]