4.6 Sinking Funds
Learning Objectives
- Construct a sinking fund schedule
Formula & Symbol Hub
Symbols Used
- [latex]BAL[/latex] = Principal balance
- [latex]BV[/latex] = Book value
- [latex]FV[/latex] = Face value of bond
- [latex]PMT[/latex] = Annuity payment amount
- [latex]N[/latex] = Number of annuity payments
- [latex]I/Y[/latex] = Nominal interest rate
- [latex]P/Y[/latex] = Number of payments per year or payment frequency
- [latex]C/Y[/latex] = Number of compounds per year or compounding frequency
Formulas Used
-
Formula 4.1 – Bond Payment
[latex]\text{Payment}=\mbox{Face Value} \times \mbox{periodic bond rate}[/latex]
-
Formula 4.2 – Purchase Price on an Interest Payment Date
[latex]\text{Purchase Price}=\mbox{Present Value of Face Value}+\mbox{Present Value of Bond Payments}[/latex]
-
Formula 4.3 – Premium (Bonds)
[latex]\text{Premium}=\mbox{Purchase Price}-\mbox{Face Value}[/latex]
-
Formula 4.4 – Discount (Bonds)
[latex]\text{Discount}=\mbox{Face Value}-\mbox{Purchase Price}[/latex]
-
Formula 4.5 – Quoted Price (Bonds)
[latex]\mbox{Flat Price}-\mbox{Accrued Interest}[/latex]
-
Formula 4.6 – Quoted Price as a Percentage of Face Value
[latex]\frac{\mbox{Quoted Price}}{\mbox{Face Value}} \times 100\%[/latex]
-
Formula 4.7 – Periodic Cost of Debt
[latex]\mbox{Sinking Fund Payment}+\mbox{Periodic Interest Payment}[/latex]
-
Formula 4.8 – Book Value
[latex]\mbox{Loan Amount}-\mbox{Balance}[/latex]
Introduction
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:
- Capital Savings. When your goal is to acquire some form of a capital asset by the end of the fund, you have a capital savings sinking fund. What is a capital asset? It is any tangible property that is not easily converted into cash. For example, saving up to buy a home, car, warehouse, or even new production machinery are all capital savings.
- Debt Retirement. When your goal is to pay off some form of debt by the end of the fund, you have a debt retirement sinking fund. Perhaps as a consumer, if you were able to get a [latex]0\%[/latex] interest plan with no payments for one year, you might want to make monthly payments into your own savings account so that you would have the needed funds to pay off your purchase when it comes due. Businesses usually set up sinking funds for the retirement of stocks, bonds, and debentures.
Sinking Funds and Debt Retirement
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.
- Interest rate for the loan or debt. Because sinking funds are used to pay off loans, bonds, or other debts, there is an interest rate for calculating the amount of interest charged on the loan. For example, if the sinking fund is used to accumulate the face value of a bond, the interest rate on the debt is the coupon rate of the bond. This interest rate is only for calculating the interest due on the loan or debt, and does not have anything to do with the money deposited into the sinking fund.
- Interest rate for the sinking fund. Because a sinking fund is an interest-earning account, there is an interest rate for calculating the interest earned by the money in the sinking fund.
When a sinking fund is established to retire a debt, there are two different periodic costs or expenses made in relation to the debt.
- Periodic interest payments on the debt. The interest rate for the loan or debt is used to calculate the periodic interest payment. For example, if a sinking fund is used to accumulate the face value of a bond, the bond issuer still has to make the periodic bond payments to the bond holders. These periodic interest payments are not directly related to the sinking fund, but are a cost associated with the debt.
- Periodic payments made to the sinking fund.When a periodic interest payment is made on the debt, a payment is made into the sinking fund with the goal of accumulating the loan amount. The interest rate for the sinking fund is used to calculate the periodic annuity payment for the sinking fund. For example, if a sinking fund is used to accumulate the face value of a bond, the bond issuer makes a deposit into the sinking fund at the same time they make the bond payment. Because these periodic sinking fund payments are made as a result of a debt, they are also costs associated with 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.
[latex]\boxed{4.7}[/latex] Periodic Cost of Debt
[latex]\Large\begin{eqnarray*}{\color{red}{\mbox{Periodic Cost of the Debt}}}&=&{\color{blue}{\mbox{Periodic Interest Payment}}}\\&+&{\color{green}{\mbox{Periodic Sinking Fund Payment}}}\end{eqnarray*}[/latex]
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.
Example 4.6.1
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.
- Calculate the sinking fund payment.
- Calculate the periodic expense of the debt.
Solution
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{eqnarray*} FV & = & \$10,000,000 \\ I/Y & = & 4.5\% \\ P/Y & = & 2 \\ C/Y & = & 2 \\ t & = & 30 \mbox{ years} \end{eqnarray*}[/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.
[latex]\begin{eqnarray*} \mbox{Bond Payment}& = & FV \times \frac{\mbox{coupon rate}}{2} \\ & = & 10,000,000\times \frac{0.051}{2}\\ & = & \$255,000\end{eqnarray*}[/latex]
The bond payments are [latex]\$255,000[/latex].
Step 4: Calculate the periodic cost of the debt.
[latex]\begin{eqnarray*} \mbox{Periodic Cost of the Debt} & = & \mbox{Periodic Interest Payment}+\mbox{Periodic Sinking Fund Payment}\\ & = & 255,000+80,353.28 \\ & = & \$335,353.28\end{eqnarray*}[/latex]
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.
Key Takeaways
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.
Try It
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.
- Calculate the sinking fund payment.
- Calculate the periodic expense of the debt.
Solution
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] |
[latex]PMT=\$8,777.63[/latex]
b. Calculate the periodic expense of the debt.
[latex]\begin{eqnarray*} \mbox{Bond Payment} & = & FV \times \frac{\mbox{coupon rate}}{2} \\ & = & 200,000\times \frac{0.039}{2}\\ & = & \$3,900\end{eqnarray*}[/latex]
Write as a statement.
[latex]\begin{eqnarray*} \mbox{Periodic Cost of the Debt} & = & \mbox{Periodic Interest Payment}+\mbox{Periodic Sinking Fund Payment}\\ & = & 3,900+8,777.63 \\ & = & \$12,677.63\end{eqnarray*}[/latex]
Sinking Fund Schedules
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.
[latex]\boxed{4.8}[/latex] Book Value
[latex]\Large{\color{red}{\mbox{Book Value}}}={\color{blue}{\mbox{Principal}}}-{\color{green}{\mbox{Fund Balance}}}[/latex]
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:
- Payment Number. There is a row for every payment into the sinking fund.
- Payment. The sinking fund payment ([latex]PMT[/latex]). Because the sinking fund payment is rounded up, all of the payments are the same, including the last payment.
- Interest. The interest earned by the fund at the end of each payment interval.
- Increase. The total amount added to the fund with each payment interval.
- Balance. The current amount accumulated in the fund for each payment interval.
- Book Value. The book value of the debt.
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{Loan Amount}^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{Total Payments}^8[/latex] | [latex]\text{Total Interest}^10[/latex] | [latex]\text{Total Increase}^9[/latex] |
HOW TO
Fill In a Sinking Fund Schedule
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:
[latex]\mbox{Interest}=\mbox{Balance from Previous Row} \times i[/latex]
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:
[latex]\mbox{Increase}=PMT+\mbox{Interest}[/latex].
Step 5: Calculate the new balance. The balance is the sum of the balance in the previous row and the increase:
[latex]\mbox{Balance}=\mbox{Balance from Previous Row}+\mbox{Increase}[/latex]
Step 6: Calculate the new book value. The book value is the difference between the book value from the previous row and the increase:
[latex]\mbox{Book Value}=\mbox{Book Value from Previous Row}-\mbox{Increase}[/latex].
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:
[latex]\mbox{Total Payments}=N \times PMT[/latex].
Step 9: The total increase is the sum of the increase column, and is the last balance entry:
[latex]\mbox{Total Increase}=\mbox{Balance in Last Row}[/latex].
Step 10: The total interest is the sum of the interest column, and equals the difference between the other two column totals:
[latex]\mbox{Total Interest}=\mbox{Total Payments}-\mbox{Total Increase}[/latex].
Paths to Success
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.
Example 4.6.2
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{eqnarray*} FV & = & \$20,000 \\ I/Y & = & 4\% \\ P/Y & = & 2 \\ C/Y & = & 2 \\ t & = & 2 \mbox{ years} \end{eqnarray*}[/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] |
[latex]PMT=\$4,852.48[/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{4\%}{2}=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{blue}{(0 \times 0.02)}[/latex] | [latex]\$4,852.48[/latex][latex]\color{blue}{(4,852.48+0)}[/latex] | [latex]\$4,852.48[/latex][latex]\color{blue}{(0+4,852.48)}[/latex] | [latex]\$15,147.52[/latex][latex]\;\color{blue}{(20,000-4,582.48)}[/latex] |
| [latex]2[/latex] | [latex]\$4,852.48[/latex] | [latex]\;\;\$97.05\;\;[/latex][latex]\color{blue}{(4582.48 \times 0.02)}[/latex] | [latex]\$4,949.53[/latex][latex]\color{blue}{(4852.48+97.05)}[/latex] | [latex]\$9,802.01[/latex][latex]\;\color{blue}{(4852.48+4949.53)}[/latex] | [latex]\$10,197.99[/latex][latex]\color{blue}{(15,147.52-4949.53)}[/latex] |
| [latex]3[/latex] | [latex]\$4,852.48[/latex] | [latex]\;\$196.04\;[/latex][latex]\color{blue}{(9802.01 \times 0.02)}[/latex] | [latex]\$5,048.52[/latex][latex]\color{blue}{(4852.48+196.04)}[/latex] | [latex]\$14,850.5[/latex][latex]\;\color{blue}{(9802.01+5048.52)}[/latex] | [latex]\$5,149.47[/latex][latex]\color{blue}{(10,197.99-5048.52)}[/latex] |
| [latex]4[/latex] | [latex]\$4,852.48[/latex] | [latex]\$297.01[/latex][latex]\color{blue}{(14,850.53 \times 0.02)}[/latex] | [latex]\$5,149.49[/latex][latex]\color{blue}{(4852.48+297.01)}[/latex] | [latex]\$20,000.02[/latex][latex]\color{blue}{(14,850.53+5149.49)}[/latex] | [latex]-\$0.02[/latex][latex]\;\color{blue}{(5149.47-5149.49)}[/latex] |
| Totals | [latex]\$19,409.92[/latex][latex]\color{blue}{(4 \times 4852.48)}[/latex] | [latex]\$590.10[/latex][latex]\color{blue}{(20,000.02-19,409.92)}[/latex] | [latex]\$20,000.02[/latex] |
Things to Watch Out For
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.
Using the TI BAII Plus Calculator to Construct a Sinking Fund Schedule
To use the amortization worksheet to complete a sinking fund schedule:
- Solve for any unknown quantities about the sinking fund. You need to know all of the information about the sinking fund first before you can use the amortization worksheet.
- Enter all the value of all seven time value of money variables into the calculator ([latex]N[/latex], [latex]PV[/latex], [latex]FV[/latex], [latex]PMT[/latex], [latex]I/Y[/latex], [latex]P/Y[/latex], [latex]C/Y[/latex]). If you calculated the payment in the first step, you must re-enter it rounded up to the next cent and with the correct cash flow sign. Make sure the payment setting is set to END, and obey the cash flow sign convention. Because [latex]PMT[/latex] (the sinking fund payment) is paid out to the fund, [latex]PMT[/latex] is negative. At the end of the term, [latex]FV[/latex] is received, so [latex]FV[/latex] is positive.
- Go to the amortization worksheet by pressing 2nd AMORT (the [latex]PV[/latex] button).
- To view the entries for a specific row of the schedule, set [latex]P_1[/latex] and [latex]P_2[/latex] to the row number. For example, to view the entries for row [latex]5[/latex], set [latex]P_1=5[/latex] and [latex]P_2=5[/latex].
- At the [latex]P_1[/latex] prompt, enter the row number and press ENTER.
- Press the down arrow.
- At the [latex]P_2[/latex] prompt, enter the row number and press ENTER.
- Press the down arrow.
- The [latex]BAL[/latex] entry is the balance entry for the corresponding row.
- Press the down arrow.
- The [latex]PRN[/latex] entry is the increase entry for the corresponding row.
- Press the down arrow.
- The [latex]INT[/latex] entry is the interest entry for the corresponding row.
- Press the down arrow the return to the [latex]P_1[/latex] screen.
- Repeat the previous step with a different row number to view the entries for a different row.
Key Takeaways
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:
[latex]\mbox{Book Value} =\mbox{Principal}-\mbox{Fund Balance}[/latex]
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.
Example 4.6.3
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] |
[latex]PMT=\$5,793.65[/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] |
- Row 1: In the amortization worksheet, set [latex]P_1=1[/latex] and [latex]P_2=1[/latex]. The entry for the last column (the book value) is [latex]30,000-5,793.65[/latex].
- Row 2: In the amortization worksheet, set [latex]P_1=2[/latex] and [latex]P_2=2[/latex]. The entry for the last column (the book value) is [latex]30,000-11,688.69[/latex].
- Row 3: In the amortization worksheet, set [latex]P_1=3[/latex] and [latex]P_2=3[/latex]. The entry for the last column (the book value) is [latex]30,000-17,686.89[/latex].
- Row 4: In the amortization worksheet, set [latex]P_1=4[/latex] and [latex]P_2=4[/latex]. The entry for the last column (the book value) is [latex]30,000-23,790.06[/latex].
- Row 5: In the amortization worksheet, set P[latex]1=5[/latex] and P[latex]2=5[/latex]. The entry for the last column (the book value) is [latex]30,000-30,000.04[/latex].
- Totals Row:
- The increase total is the last balance entry ([latex]\$30,000.04[/latex]).
- The payments total is the sum of the payments: [latex]5 \times 5,793.65=28,968.25[/latex].
- The interest total is the difference in the other two column totals: [latex]30,000.04-28,968.25=1,031.79[/latex].
Try It
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] |
[latex]PMT=\$1,575.35[/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] |
Other Sinking Fund Calculations
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.
Example 4.6.4
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.
Solution
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] |
[latex]PMT=\$1,097.21[/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] |
- Row 7: In the amortization worksheet, set [latex]P_1=7[/latex] and [latex]P_2=7[/latex].
- Row 19: In the amortization worksheet, set [latex]P_1=19[/latex] and [latex]P_2=19[/latex].
- Row 20: In the amortization worksheet, set [latex]P_1=20[/latex] and [latex]P_2=20[/latex].
- Book Value for each Row:[latex]\mbox{Book Value}=25,000-\mbox{Balance}[/latex]
- Totals Row:
- The increase total is the last balance entry ([latex]\$25,000.17[/latex]).
- The payments total is the sum of the payments: [latex]20 \times 1,097.21=21,944.20[/latex].
- The interest total is the difference in the other two column totals: [latex]25,000.17-21,944.20=3,055.97[/latex].
Using the TI BAII Plus Calculator for Other Sinking Fund Calculations
To use the amortization worksheet to find the total interest, the total increase or the balance for a sinking fund:
- Solve for any unknown quantities about the sinking fund. You need to know all of the information about the sinking fund first before you can use the amortization worksheet.
- Enter all the value of all seven time value of money variables into the calculator ([latex]N[/latex], [latex]PV[/latex], [latex]FV[/latex], [latex]PMT[/latex], [latex]I/Y[/latex], [latex]P/Y[/latex], [latex]C/Y[/latex]). If you calculated the payment in the first step, you must re-enter it rounded up to the next cent and with the correct cash flow sign. Make sure the payment setting is set to END, and obey the cash flow sign convention. Because [latex]PMT[/latex] (the sinking fund payment) is paid out to the fund, [latex]PMT[/latex] is negative. At the end of the term, [latex]FV[/latex] is received, so [latex]FV[/latex] is positive.
- Go to the amortization worksheet by pressing 2nd AMORT (the [latex]PV[/latex] button).
- To find the balance in the fund after a payment, set [latex]P_1[/latex] and [latex]P_2[/latex] equal to the payment number. The [latex]BAL[/latex] entry is the balance after payment number [latex]P_2[/latex]. Note that the [latex]BAL[/latex] entry is only tied to the value of [latex]P_2[/latex] and does not depend on the value of [latex]P_1[/latex].
- To view the total increase or the total interest for a series of payments, set [latex]P_1[/latex] to the first payment number of the series of payments and set [latex]P_2[/latex] to the last payment number of the series of payments. For example, to view the total increase or the total interest for payments four to seven, set [latex]P_1=4[/latex] and [latex]P_2=7[/latex]. In the outputs from the amortization worksheet:
- The [latex]PRN[/latex] entry is the total increase from payment number [latex]P_1[/latex] to payment number [latex]P_2[/latex].
- The [latex]INT[/latex] entry is the total interest from payment number [latex]P_1[/latex] to payment number [latex]P_2[/latex].
Key Takeaways
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.
Example 4.6.5
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.
- What is the sinking fund payment?
- What was the balance in the fund after payment [latex]18[/latex]?
- By how much did the sinking fund increase with payment [latex]9[/latex]?
- How much interest was paid in year [latex]10[/latex]?
- What was the book value in the fund at the end of year [latex]8[/latex]?
Solution
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] |
[latex]PMT=\$11,663.61[/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] |
[latex]BAL=\$257,632.82[/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] |
[latex]PRN=\$14,045.45[/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] |
[latex]INT=\$12,525.11[/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]BAL=\$223,407.95[/latex]
[latex]\begin{eqnarray*}\mbox{Book Value} & = & 500,000-223,407.95 \\ & = & \$276,592.05 \end{eqnarray*}[/latex]
Step 6: Write as a statement.
After eight years, the book value in the fund is [latex]\$276,592.05[/latex].
Things to Watch Out For
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^{th}[/latex] payment is actually the last payment of the third year. The first payment to occur in year four is the [latex]37^{th}[/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.
- Calculate the payment number at the end of the year in question by multiplying [latex]P/Y[/latex] by the year number: [latex]P/Y\times\text{year number}[/latex]. To find the payment number at the start of the year, subtract the payment frequency less one ([latex]P/Y - 1[/latex]) from the last payment number of the year. For example, suppose the you have monthly payments and want to find the interest paid for year [latex]4[/latex]. The last payment in year [latex]4[/latex] is [latex]12\times 4=48[/latex]. The first payment in year [latex]4[/latex] is [latex]48-(12-1)=37[/latex].
- Calculate the payment number at the end of the year in question by multiplying [latex]P/Y[/latex] by the year number: [latex]P/Y\times\text{year number}[/latex]. To find the payment number for the first payment in the year, multiply [latex]P/Y[/latex] by the previous year number and then add one to it: [latex]P/Y\times (year-1)+1[/latex]. For example, suppose the you have monthly payments and want to find the interest paid for year [latex]4[/latex]. The first payment in year [latex]4[/latex] is [latex]12\times 3+1=37[/latex]. The last payment of the fourth year remains at payment [latex]48[/latex].
Try It
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.
- What is the sinking fund payment?
- How much interest did the sinking fund earn with the [latex]10[/latex]th payment?
- By how much did the sinking fund increase with the [latex]7[/latex]th payment?
- What is the balance on the loan after eight years?
- How much interest did the sinking fund earn in year three?
- By how much did the sinking fund increase in year six?
- What is the book value in the fund after year five?
Solution
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] |
[latex]PMT=\$4,670.22[/latex]
b. Calculate the interest for the [latex]10^{th}[/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] |
[latex]INT=\$911.13[/latex]
c. Calculate the increase for the [latex]7^{th}[/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] |
[latex]PRN=\$5,259.43[/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] |
[latex]BAL=\$87,049.56[/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] |
[latex]INT=\$871.06[/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] |
[latex]PRN=\$11,499.80[/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] |
[latex]BAL=\$51,137.61[/latex]
[latex]\begin{eqnarray*}\mbox{Book Value} & = & 100,000-51,137.61 \\ & = & \$48,862.39 \end{eqnarray*}[/latex]
Section 4.6 Exercises
- A company set up a sinking fund earning [latex]6.2\%[/latex] effective to accumulate [latex]\$10,000[/latex] to repay a loan. The company makes quarterly payments into the sinking fund for two years. Construct the sinking fund schedule for the loan.
Solution
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] - A company issued [latex]\$5,000,000[/latex] worth of bonds and set up a sinking fund earning [latex]7\%[/latex] compounded semi-annually to retire the bonds in six years. The company made semi-annual payments into the fund. Construct a sinking fund schedule showing the details of third year, the last two payments and the totals.
Solution
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] - A company borrowed [latex]\$800,000[/latex] to expand their factory. They establish a sinking fund earning [latex]5\%[/latex] compounded quarterly to accumulate the loan amount in [latex]8[/latex] years. The company made monthly payments into the sinking fund. Construct a sinking fund schedule showing the details of payment [latex]37[/latex], the last two payments and the totals.
Solution
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]\$500,000[/latex] bond with a [latex]6.5\%[/latex] coupon is redeemable in ten years. The bond comes with a sinking fund that requires deposits timed to match the bond payments. The sinking fund earns [latex]4\%[/latex] compounded semi-annually.
- What is the sinking fund payment?
- What is the periodic expense of the debt?
- What is the balance in the fund after two years?
- How much interest did the fund earn with the [latex]17[/latex]th payment?
- By how much did the fund increase with the [latex]8[/latex]th payment?
- How much interest did the fund earn in year nine?
- By how much did the fund increase in year six?
- What is the book value at the end of year seven?
Solution
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]\$125,000[/latex] face value bond is issued with [latex]15[/latex] years to maturity and a coupon rate of [latex]5\%[/latex]. A sinking fund is established to accumulate the face value of the bond. The sinking fund earns [latex]7.4\%[/latex] compounded semi-annual and the payments are time to match the bond payments.
- What is the sinking fund payment?
- What is the periodic expense of the debt?
- What is the balance in the fund half way through the term?
- How much interest did the fund earn with the [latex]20[/latex]th payment?
- By how much did the fund increase with the [latex]10[/latex]th payment?
- How much interest did the fund earn in year seven?
- By how much did the fund increase in year three?
- What is the book value at the end of year twelve?
Solution
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 company borrowed [latex]\$750,000[/latex] at [latex]3.8\%[/latex] compounded quarterly which required them to make quarterly interest payments. The company set up a sinking fund earning [latex]4.9\%[/latex] compounded quarterly to retire the debt in eight years. The company makes quarterly payments into the sinking fund at the same time they make the quarterly interest payments on the loan.
- What is the sinking fund payment?
- What is the periodic expense of the debt?
- What is the balance in the fund at the end of year five?
- How much interest did the fund earn with the [latex]13[/latex]th payment?
- By how much did the fund increase with the [latex]25[/latex]th payment?
- How much interest did the fund earn in year four?
- By how much did the fund increase in year six?
- What is the book value at the end of year two?
Solution
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]
Attribution
“7.6 Sinking Funds” from Business and Financial Mathematics by Valerie Watts is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.
“14.3: Sinking Fund Schedules” from Business Math: A Step-by-Step Handbook (2021B) by J. Olivier and Lyryx Learning Inc. through a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License unless otherwise noted.
“14.4: Debt Retirement & Amortization” from Business Math: A Step-by-Step Handbook (2021B) by J. Olivier and Lyryx Learning Inc. through a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License unless otherwise noted.
