CORPORATE FINANCE

profileEly0817
Essentials9eChapter05ExcelMasterstudent.week2.xlsx
Home>Business & Finance homework help>Accounting homework help>CORPORATE FINANCE

Chapter 5

Ross, Westerfield, and Jordan's Excel Master
Essentials of Corporate Finance, 9th edition
by Brad Jordan and Joe Smolira
Version 9.0
Chapter 5
In these spreadsheets, you will learn how to use the following Excel functions:
The following conventions are used in these spreadsheets:
1) Given data in blue
2) Calculations in red
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Excel.
To install these, click on the File button
then "Options," "Add-Ins" and select
"Go." Check "Analysis ToolPak" and
"Solver Add-In," then click "OK."

SUM

/xl/drawings/drawing1.xml#'Section%205.1'!A28

NPV

/xl/drawings/drawing1.xml#'Section%205.1'!A67

PV of an annuity

/xl/drawings/drawing1.xml#'Section%205.2'!A17

PMT

/xl/drawings/drawing1.xml#'Section%205.2'!A47

Annuity interest rate

/xl/drawings/drawing1.xml#'Section%205.2'!A77

Annuity periods

/xl/drawings/drawing1.xml#'Section%205.2'!A113

Annuity due

/xl/drawings/drawing1.xml#'Section%205.2'!A212

EAR

/xl/drawings/drawing1.xml#'Section%205.3'!A16

APR

/xl/drawings/drawing1.xml#'Section%205.3'!A44

Exponential function

/xl/drawings/drawing1.xml#'Section%206.3'!A75

Nested function

/xl/drawings/drawing1.xml#'Section%205.4'!A129

FV of an annuity

/xl/drawings/drawing1.xml#'Section%205.2'!A146

Loan amortization worksheet

/xl/drawings/drawing1.xml#'Section%205.4'!A88

Section 5.1

Chapter 5 - Section 1
Present Value and Future Value of Multiple Cash Flows
Future Value of Multiple Unequal Cash Flows
Unfortunately, Excel does not have a function to calculate the future value of multiple cash flows when the cash flows are of different amounts. However, we can calculate the future value of individual cash flows and sum them. Suppose we have the following set of cash flows:
t Cash flow
1 $ 10,000
2 15,000
3 2,000
4 19,000
5 16,500
Interest rate: 10%
What is the future value of these cash flows? We can set up a table to find the future value of each cash flow and sum the future values. Since we want the future value at year 5, we will use a simple trick. The number of years each cash flow will be compounded is 5 minus the year of the cash flow. So, we will use (5 - current year) as the number of periods and use the interest rate as an absolute reference. The future value of the cash flows is:
t Future value
1 $ 14,641.00
2 19,965.00
3 2,420.00
4 20,900.00
5 16,500.00
Total: $ 74,426.00
RWJ Excel Tip
To add the future values together, we used the SUM function. The SUM function is used so often that it has its own button on the Home menu.
Present Value of Multiple Unequal Cash Flows
To find the present value of multiple unequal cash flows, we will first discuss the same method we used to find the future value of multiple unequal cash flows. Let's look at Mark Teixeira's contract which was discussed in the chapter opener. What is the present value of the contract?
t Cash flow
0 $ 5,000,000
1 20,000,000
2 20,000,000
3 22,500,000
4 22,500,000
5 22,500,000
6 22,500,000
7 22,500,000
8 22,500,000
Interest rate: 12%
We can set up a table to find the present value of each cash flow similar to the table we used to find the future value of each cash flow. So, the present value of the contract is:
t Present value
0 $ 5,000,000
1 $ 17,857,143
2 $ 15,943,878
3 $ 16,015,056
4 $ 14,299,157
5 $ 12,767,104
6 $ 11,399,200
7 $ 10,177,857
8 $ 9,087,373
Total: $ 112,546,767
Excel does have a function that can be utilized to find the present value of unequal cash flows, the NPV, or net present value, function. We will discuss NPV in much more detail later, but for now, we will use it to find the present value of these cash flows. Using the NPV function, the present value of the contract is:
Present value: $ 112,546,767
RWJ Excel Tip
The NPV function is located under the Financial functions. We used the following arguments:
While we could have entered each cash flow individually (Year 1 cash flow as Value 1, Year 2 cash flow as Value 2, etc.,) we chose to enter all of the cash flows as an array. Excel automatically places the cash flow one period apart when entered in this manner. Notice in cell C65, we had to add the cash flow at time o since we did not want to discount that cash flow.

Section 5.2

Chapter 5 - Section 2
Valuing Level Cash Flows: Annuities and Perpetuities
Present Value for Annuity Cash Flows
Finding the present value of an annuity is a simple task in Excel. Remember the Pmt argument in the PV and FV functions that we left blank in Chapter 5? The Pmt stands for the annuity payment. Finding the present value of an annuity uses the PV function with the annuity payment in the Pmt argument.
Suppose you just won the lottery. Based on the following assumptions, what is the present value of your winnings?
Annual payment: $ 100,000
Number of years for payments: 25
Interest rate: 11%
Present value: $ 842,174.47
RWJ Excel Tip
To find the present value of this annuity, we used the following arguments:
Rate is simply the interest rate, Nper is the number of periods, and Pmt is the annuity payment. Since there is no present value, we left this blank. Notice also that we put a negative sign in front of the payment. Excel works like a calculator in that one of the cash flows must be positive and one of the cash flows must be negative. If we had left the payment as a positive number we would have gotten a negative answer. Since we prefer our answers to show as positive, we entered a negative in front of the payment.
To find the annuity payment, Excel uses the PMT function. Suppose you are buying a house with the following terms:
Purchase price: $ 175,000
Number of months for repayment: 240
Monthly interest rate: 0.50%
Monthly payment: $ 1,253.75
RWJ Excel Tip
To find the annuity payment, we used the following arguments:
Rate is simply the interest rate, Nper is the number of periods, and Pv is the present value. Since there is no future value, we left this blank. Notice also that we put a negative sign in front of the present value. Excel works like a calculator in that one of the cash flows must be positive and one of the cash flows must be negative. If we had left the present value as a positive number we would have gotten a negative answer. Since we prefer our answers to show as positive, we entered a negative in front of the present value.
To find the interest rate for an annuity, Excel uses the RATE function. Suppose you are saving for retirement and know how much you will save every year, as well as a target retirement balance. What interest rate is necessary for you to reach your goal?
Retirement goal: $ 1,500,000
Annual amount to save: $ 3,000
Number of years to save: 35
Interest rate: 12.62%
RWJ Excel Tip
To find the interest rate, we used the following arguments:
Nper is the number of periods, Pmt is the annuity payment, and Fv is the future value. Since there is no present value, we left this blank. Notice also that we put a negative sign in front of the payment. Excel requires that one of the cash flows be positive and one of the cash flows be negative. We could have made the payment positive and the future value negative and would have received the same answer.
Example 5.6: Finding the Number of Payments
You ran a little short on spring break, so you charged on your credit card. With the following assumptions, how long will it take you to pay off your credit card?
Amount owed: $ 1,000
Monthly payment: $ 20
Monthly interest rate: 1.50%
Number of months to pay off card: 93.11
Number of years to pay off card: 7.76
To find the number of periods, Excel uses the NPER function.
RWJ Excel Tip
To find the number of periods, we used the following arguments:
Rate is the interest rate per period, Pmt is the annuity payment, and Pv is the present value. Since there is no future value, we left this blank. Notice also that we put a negative sign in front of the payment. Excel requires that one of the cash flows be positive and one of the cash flows negative. We could have made the payment positive and the future value negative and would have received the same answer.
Future Value for Annuities
We can find the future value of an annuity using the Pmt argument in the FV function. Suppose you are saving for retirement. Based on the following assumptions, how much will you have when you retire?
Annual savings: $ 3,000
Number of years to save: 30
Interest rate: 11%
Future value: $ 597,062.63
RWJ Excel Tip
To find the future value of this annuity, we used the following arguments:
Rate is simply the interest rate, Nper is the number of periods, and Pmt is the annuity payment. Since there is no present value, we left this blank. Notice also that we put a negative sign in front of the payment. Excel works like a calculator in that one of the cash flows must be positive and one of the cash flows must be negative. If we had left the payment as a positive number we would have gotten a negative answer. Since we prefer our answers to show as positive, we entered a negative in front of the payment.
The NPER and RATE functions can be used with the future value to find the number of periods or interest rate in the same manner we used these functions with the present value.
Of course, both the present value and future value functions can accommodate a lump sum value and annuity payment simultaneously. Suppose you are going to save an equal annual amount for retirement, but you also have a little bit saved for retirement. With the following assumptions, how much will you have when you retire?
Present value: $ 25,000
Annual savings: $ 2,500
Number of years to save: 45
Interest rate: 11%
Future value: $ 5,204,852.44
RWJ Excel Tip
To find the future value of these cash flows, we used the following arguments:
Note that the payment and present value both have the same sign. This is because they are both the same type of cash flow, either an inflow or an outflow, depending on how you are viewing the cash flows.
A Note On Annuities Due
So far, we have talked about ordinary annuities, that is, the payments occur at the end of the period. What about annuities due, where the payments occur at the beginning of the period. Suppose you are going to save for retirement and the first deposit will be made today. With the following assumptions, how much will you have when you are ready to retire?
Beginning of period annuity deposit: $ 2,000
Number of years: 35
Interest rate: 10%
Future value: $ 596,253.61
RWJ Excel Tip
To calculate the future value of an annuity due, we use the FV function and set the type of payments to beginning of period like this:
In the FV and PV functions, the Type represents the payment type. If this argument is left blank or a 0 (zero) is entered, Excel uses end of period payments. If a 1 (one) is entered, Excel uses beginning of period payments.

Section 5.3

Chapter 5 - Section 3
Comparing Rates: The Effect of Compounding
Excel has functions to calculate the effective annual rate and the annual percentage rate.
Example 5.8: What's the EAR?
Suppose you make a deposit at a bank with the following APR and compounding periods. What is the effective annual return (EAR) of your investment?
APR: 12%
Compounding periods per year: 4
EAR: 12.55%
RWJ Excel Tip
To calculate the effective annual rate, we can use the EFFECT function as follows:
In the EFFECT function, Nominal_rate is the APR and Npery is the number of compounding periods per year.
Example 5.9: Quoting a Rate
As a lender, you know the interest rate and the number of compounding periods per year. In order to earn this interest rate, what rate do you quote?
EAR: 18%
Compounding periods per year: 12
APR: 16.67%
RWJ Excel Tip
To calculate the annual percentage rate, we can use the NOMINAL function as follows:
In the NOMINAL function, Effect_rate is the EAR and Npery is the number of compounding periods per year.

Section 5.4

Chapter 5 - Section 4
Loan Types and Loan Amortization
Pure Discount Loans
Pure discount loans are relatively simple since they are nothing more than a lump sum. Suppose we have a pure discount loan with the following characteristics:
Amount to be repaid: $ 25,000
Years until repayment: 7
Interest rate: 12%
Present value: $ 11,308.73
As you can see, we find the present value using the PV function.
Equal Principal Payment
Amortization tables are an excellent application of Excel's abilities. Because an amortization table is repetitive, once we get the first couple of rows, we can copy and paste to fill in the rest of the amortization table. Suppose we have the following 15 year loan that requires equal principal payments each year:
Loan amount: $ 350,000
Interest rate: 9%
This means that the equal annual principal payments will be:
Principal payments: $ 23,333.33
So, the equal principal payment amortization table will look like this:
Beginning Balance Total Payment Interest Paid Principal Payment Ending Balance
1 $ 350,000.00 $ 54,833.33 $ 31,500.00 $ 23,333.33 $ 326,666.67
2 326,666.67 52,733.33 29,400.00 23,333.33 303,333.33
3 303,333.33 50,633.33 27,300.00 23,333.33 280,000.00
4 280,000.00 48,533.33 25,200.00 23,333.33 256,666.67
5 256,666.67 46,433.33 23,100.00 23,333.33 233,333.33
6 233,333.33 44,333.33 21,000.00 23,333.33 210,000.00
7 210,000.00 42,233.33 18,900.00 23,333.33 186,666.67
8 186,666.67 40,133.33 16,800.00 23,333.33 163,333.33
9 163,333.33 38,033.33 14,700.00 23,333.33 140,000.00
10 140,000.00 35,933.33 12,600.00 23,333.33 116,666.67
11 116,666.67 33,833.33 10,500.00 23,333.33 93,333.33
12 93,333.33 31,733.33 8,400.00 23,333.33 70,000.00
13 70,000.00 29,633.33 6,300.00 23,333.33 46,666.67
14 46,666.67 27,533.33 4,200.00 23,333.33 23,333.33
15 23,333.33 25,433.33 2,100.00 23,333.33 - 0
Total $ 602,000.00 $ 252,000.00 $ 350,000.00
RWJ Excel Tip
To create the table, we first set up the header row and column. The beginning balance references the loan amount, the principal payment is an absolute reference to the earlier calculation of the principal payment, and the interest paid is the beginning balance multiplied by the interest rate (which is an absolute reference.) We then repeated this for the second period, except that the beginning balance in period 2 is the ending balance in period 1. Since we have used absolute references for the principal payment and interest rate, we can copy and paste the second row to fill in the table. To find the total payments, total interest payments, and total principal payments, we used the sum button.
Equal Payment
Creating an equal payment amortization schedule is similar to the equal principal amortization schedule. First, we need to calculate the loan payment for the 15 year loan, which we can calculate using the PMT function we discussed earlier. The loan payment will be:
Loan amount: $ 350,000
Interest rate: 9%
This means that the equal annual payments will be:
Equal payments: $ 43,420.61
So, the equal annual payment amortization table will look like this:
Beginning Balance Total Payment Interest Paid Principal Payment Ending Balance
1 $ 350,000.00 $ 43,420.61 $ 31,500.00 $ 11,920.61 $ 338,079.39
2 338,079.39 43,420.61 30,427.15 12,993.46 325,085.93
3 325,085.93 43,420.61 29,257.73 14,162.88 310,923.05
4 310,923.05 43,420.61 27,983.07 15,437.53 295,485.52
5 295,485.52 43,420.61 26,593.70 16,826.91 278,658.61
6 278,658.61 43,420.61 25,079.27 18,341.33 260,317.27
7 260,317.27 43,420.61 23,428.55 19,992.05 240,325.22
8 240,325.22 43,420.61 21,629.27 21,791.34 218,533.88
9 218,533.88 43,420.61 19,668.05 23,752.56 194,781.32
10 194,781.32 43,420.61 17,530.32 25,890.29 168,891.03
11 168,891.03 43,420.61 15,200.19 28,220.42 140,670.61
12 140,670.61 43,420.61 12,660.35 30,760.25 109,910.36
13 109,910.36 43,420.61 9,891.93 33,528.68 76,381.68
14 76,381.68 43,420.61 6,874.35 36,546.26 39,835.42
15 39,835.42 43,420.61 3,585.19 39,835.42 0.00
$ 651,309.13 $ 301,309.13 $ 350,000.00
RWJ Excel Tip
To create the table, we first set up the header row and column. The beginning balance referenced the loan amount, the total payment is an absolute reference to the earlier calculation of the payment amount, the interest payment is the beginning balance multiplied by the interest rate (which is an absolute reference,) and the principal payment is the total payment minus the interest paid. The ending balance is the beginning balance minus the principal payment. We then repeated this for the second period, except that the beginning balance in period 2 is the ending balance in period 1. Since we have used absolute references for the total payment and interest rate, we can copy and paste the second row to fill in the table. To find the total payments, total interest payments, and total principal payments over the life of the loan, we used the sum button.
RWJ Excel Tip
Loan amortization tables are so common that Excel has a built-in worksheet to calculate a loan amortization. To find this worksheet, right-click on one of the worksheet tabs, select Insert, then the Spreadsheet Solutions tab. Below you will see the built-in spreadsheet options. We selected the Loan Amortization worksheet and Excel inserted the Loan Amortization worksheet. We entered the values in the table at the top and the entire loan amortization table was constructed automatically.
"Balloon" or "Bullet" Loans
Balloon loans are loans that are amortized over a relatively long schedule, but at some point during the life of the loan, the remaining principal of the loan is repaid. We are going to be a little fancier here and set up the problem so that it works with any repayment schedule, whether annually, monthly, or any other period. Suppose we have a loan with the following characteristics:
Loan amount: $ 250,000
Amortization period (years): 30
Time balloon payment due (years): 8
Payments per year: 12
Interest rate (APR): 9.00%
So, based on the original amortization schedule, the payments will be:
Monthly payment: $ 2,011.56
The balloon payment is the present value of the remaining payments, so the balloon payment will be:
Balloon payment: $ 230,901.73
RWJ Excel Tip
Of course, we could solve this question with one calculation cell. Excel allows you to "nest" one function inside another. Below, we nested the payment calculation inside the present value function to calculate the balloon payment in one cell without the intermediate step of calculating the monthly payment. In this case, we would probably want to know the monthly payments due before the balloon payment, but we will be using nested functions more often.
Balloon payment: $ 230,901.73

Loan Amortization Schedule

Loan Amortization Schedule
Enter values Loan summary
Loan amount $ 250,000.00 Scheduled payment $ 1,179.17
Annual interest rate 3.90?% Scheduled number of payments 360
Loan period in years 30 Actual number of payments 360
Number of payments per year 12 Total early payments $ - 0
Start date of loan 8/1/16 Total interest $ 174,501.38
Optional extra payments $ - 0
Lender name:
Pmt. No. Payment Date Beginning Balance Scheduled Payment Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest
1 9/1/16 $ 250,000.00 $ 1,179.17 $ - 0 $ 1,179.17 $ 366.67 $ 812.50 $ 249,633.33 $ 812.50
2 10/1/16 $ 249,633.33 $ 1,179.17 $ - 0 $ 1,179.17 $ 367.86 $ 811.31 $ 249,265.47 $ 1,623.81
3 11/1/16 $ 249,265.47 $ 1,179.17 $ - 0 $ 1,179.17 $ 369.06 $ 810.11 $ 248,896.41 $ 2,433.92
4 12/1/16 $ 248,896.41 $ 1,179.17 $ - 0 $ 1,179.17 $ 370.26 $ 808.91 $ 248,526.15 $ 3,242.83
5 1/1/17 $ 248,526.15 $ 1,179.17 $ - 0 $ 1,179.17 $ 371.46 $ 807.71 $ 248,154.69 $ 4,050.54
6 2/1/17 $ 248,154.69 $ 1,179.17 $ - 0 $ 1,179.17 $ 372.67 $ 806.50 $ 247,782.02 $ 4,857.05
7 3/1/17 $ 247,782.02 $ 1,179.17 $ - 0 $ 1,179.17 $ 373.88 $ 805.29 $ 247,408.15 $ 5,662.34
8 4/1/17 $ 247,408.15 $ 1,179.17 $ - 0 $ 1,179.17 $ 375.09 $ 804.08 $ 247,033.05 $ 6,466.42
9 5/1/17 $ 247,033.05 $ 1,179.17 $ - 0 $ 1,179.17 $ 376.31 $ 802.86 $ 246,656.74 $ 7,269.27
10 6/1/17 $ 246,656.74 $ 1,179.17 $ - 0 $ 1,179.17 $ 377.54 $ 801.63 $ 246,279.20 $ 8,070.91
11 7/1/17 $ 246,279.20 $ 1,179.17 $ - 0 $ 1,179.17 $ 378.76 $ 800.41 $ 245,900.44 $ 8,871.31
12 8/1/17 $ 245,900.44 $ 1,179.17 $ - 0 $ 1,179.17 $ 379.99 $ 799.18 $ 245,520.44 $ 9,670.49
13 9/1/17 $ 245,520.44 $ 1,179.17 $ - 0 $ 1,179.17 $ 381.23 $ 797.94 $ 245,139.22 $ 10,468.43
14 10/1/17 $ 245,139.22 $ 1,179.17 $ - 0 $ 1,179.17 $ 382.47 $ 796.70 $ 244,756.75 $ 11,265.13
15 11/1/17 $ 244,756.75 $ 1,179.17 $ - 0 $ 1,179.17 $ 383.71 $ 795.46 $ 244,373.04 $ 12,060.59
16 12/1/17 $ 244,373.04 $ 1,179.17 $ - 0 $ 1,179.17 $ 384.96 $ 794.21 $ 243,988.08 $ 12,854.81
17 1/1/18 $ 243,988.08 $ 1,179.17 $ - 0 $ 1,179.17 $ 386.21 $ 792.96 $ 243,601.87 $ 13,647.77
18 2/1/18 $ 243,601.87 $ 1,179.17 $ - 0 $ 1,179.17 $ 387.46 $ 791.71 $ 243,214.40 $ 14,439.47
19 3/1/18 $ 243,214.40 $ 1,179.17 $ - 0 $ 1,179.17 $ 388.72 $ 790.45 $ 242,825.68 $ 15,229.92
20 4/1/18 $ 242,825.68 $ 1,179.17 $ - 0 $ 1,179.17 $ 389.99 $ 789.18 $ 242,435.69 $ 16,019.10
21 5/1/18 $ 242,435.69 $ 1,179.17 $ - 0 $ 1,179.17 $ 391.25 $ 787.92 $ 242,044.44 $ 16,807.02
22 6/1/18 $ 242,044.44 $ 1,179.17 $ - 0 $ 1,179.17 $ 392.53 $ 786.64 $ 241,651.91 $ 17,593.66
23 7/1/18 $ 241,651.91 $ 1,179.17 $ - 0 $ 1,179.17 $ 393.80 $ 785.37 $ 241,258.11 $ 18,379.03
24 8/1/18 $ 241,258.11 $ 1,179.17 $ - 0 $ 1,179.17 $ 395.08 $ 784.09 $ 240,863.03 $ 19,163.12
25 9/1/18 $ 240,863.03 $ 1,179.17 $ - 0 $ 1,179.17 $ 396.37 $ 782.80 $ 240,466.66 $ 19,945.93
26 10/1/18 $ 240,466.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 397.65 $ 781.52 $ 240,069.01 $ 20,727.44
27 11/1/18 $ 240,069.01 $ 1,179.17 $ - 0 $ 1,179.17 $ 398.95 $ 780.22 $ 239,670.06 $ 21,507.67
28 12/1/18 $ 239,670.06 $ 1,179.17 $ - 0 $ 1,179.17 $ 400.24 $ 778.93 $ 239,269.82 $ 22,286.60
29 1/1/19 $ 239,269.82 $ 1,179.17 $ - 0 $ 1,179.17 $ 401.54 $ 777.63 $ 238,868.28 $ 23,064.22
30 2/1/19 $ 238,868.28 $ 1,179.17 $ - 0 $ 1,179.17 $ 402.85 $ 776.32 $ 238,465.43 $ 23,840.54
31 3/1/19 $ 238,465.43 $ 1,179.17 $ - 0 $ 1,179.17 $ 404.16 $ 775.01 $ 238,061.27 $ 24,615.56
32 4/1/19 $ 238,061.27 $ 1,179.17 $ - 0 $ 1,179.17 $ 405.47 $ 773.70 $ 237,655.80 $ 25,389.26
33 5/1/19 $ 237,655.80 $ 1,179.17 $ - 0 $ 1,179.17 $ 406.79 $ 772.38 $ 237,249.01 $ 26,161.64
34 6/1/19 $ 237,249.01 $ 1,179.17 $ - 0 $ 1,179.17 $ 408.11 $ 771.06 $ 236,840.90 $ 26,932.70
35 7/1/19 $ 236,840.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 409.44 $ 769.73 $ 236,431.46 $ 27,702.43
36 8/1/19 $ 236,431.46 $ 1,179.17 $ - 0 $ 1,179.17 $ 410.77 $ 768.40 $ 236,020.69 $ 28,470.83
37 9/1/19 $ 236,020.69 $ 1,179.17 $ - 0 $ 1,179.17 $ 412.10 $ 767.07 $ 235,608.59 $ 29,237.90
38 10/1/19 $ 235,608.59 $ 1,179.17 $ - 0 $ 1,179.17 $ 413.44 $ 765.73 $ 235,195.15 $ 30,003.63
39 11/1/19 $ 235,195.15 $ 1,179.17 $ - 0 $ 1,179.17 $ 414.79 $ 764.38 $ 234,780.36 $ 30,768.01
40 12/1/19 $ 234,780.36 $ 1,179.17 $ - 0 $ 1,179.17 $ 416.13 $ 763.04 $ 234,364.23 $ 31,531.05
41 1/1/20 $ 234,364.23 $ 1,179.17 $ - 0 $ 1,179.17 $ 417.49 $ 761.68 $ 233,946.74 $ 32,292.73
42 2/1/20 $ 233,946.74 $ 1,179.17 $ - 0 $ 1,179.17 $ 418.84 $ 760.33 $ 233,527.90 $ 33,053.06
43 3/1/20 $ 233,527.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 420.20 $ 758.97 $ 233,107.69 $ 33,812.02
44 4/1/20 $ 233,107.69 $ 1,179.17 $ - 0 $ 1,179.17 $ 421.57 $ 757.60 $ 232,686.12 $ 34,569.62
45 5/1/20 $ 232,686.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 422.94 $ 756.23 $ 232,263.18 $ 35,325.85
46 6/1/20 $ 232,263.18 $ 1,179.17 $ - 0 $ 1,179.17 $ 424.32 $ 754.86 $ 231,838.87 $ 36,080.71
47 7/1/20 $ 231,838.87 $ 1,179.17 $ - 0 $ 1,179.17 $ 425.69 $ 753.48 $ 231,413.17 $ 36,834.19
48 8/1/20 $ 231,413.17 $ 1,179.17 $ - 0 $ 1,179.17 $ 427.08 $ 752.09 $ 230,986.09 $ 37,586.28
49 9/1/20 $ 230,986.09 $ 1,179.17 $ - 0 $ 1,179.17 $ 428.47 $ 750.70 $ 230,557.63 $ 38,336.98
50 10/1/20 $ 230,557.63 $ 1,179.17 $ - 0 $ 1,179.17 $ 429.86 $ 749.31 $ 230,127.77 $ 39,086.30
51 11/1/20 $ 230,127.77 $ 1,179.17 $ - 0 $ 1,179.17 $ 431.26 $ 747.92 $ 229,696.51 $ 39,834.21
52 12/1/20 $ 229,696.51 $ 1,179.17 $ - 0 $ 1,179.17 $ 432.66 $ 746.51 $ 229,263.86 $ 40,580.72
53 1/1/21 $ 229,263.86 $ 1,179.17 $ - 0 $ 1,179.17 $ 434.06 $ 745.11 $ 228,829.79 $ 41,325.83
54 2/1/21 $ 228,829.79 $ 1,179.17 $ - 0 $ 1,179.17 $ 435.47 $ 743.70 $ 228,394.32 $ 42,069.53
55 3/1/21 $ 228,394.32 $ 1,179.17 $ - 0 $ 1,179.17 $ 436.89 $ 742.28 $ 227,957.43 $ 42,811.81
56 4/1/21 $ 227,957.43 $ 1,179.17 $ - 0 $ 1,179.17 $ 438.31 $ 740.86 $ 227,519.12 $ 43,552.67
57 5/1/21 $ 227,519.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 439.73 $ 739.44 $ 227,079.39 $ 44,292.11
58 6/1/21 $ 227,079.39 $ 1,179.17 $ - 0 $ 1,179.17 $ 441.16 $ 738.01 $ 226,638.23 $ 45,030.12
59 7/1/21 $ 226,638.23 $ 1,179.17 $ - 0 $ 1,179.17 $ 442.60 $ 736.57 $ 226,195.63 $ 45,766.69
60 8/1/21 $ 226,195.63 $ 1,179.17 $ - 0 $ 1,179.17 $ 444.03 $ 735.14 $ 225,751.60 $ 46,501.83
61 9/1/21 $ 225,751.60 $ 1,179.17 $ - 0 $ 1,179.17 $ 445.48 $ 733.69 $ 225,306.12 $ 47,235.52
62 10/1/21 $ 225,306.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 446.93 $ 732.24 $ 224,859.19 $ 47,967.76
63 11/1/21 $ 224,859.19 $ 1,179.17 $ - 0 $ 1,179.17 $ 448.38 $ 730.79 $ 224,410.81 $ 48,698.56
64 12/1/21 $ 224,410.81 $ 1,179.17 $ - 0 $ 1,179.17 $ 449.84 $ 729.34 $ 223,960.98 $ 49,427.89
65 1/1/22 $ 223,960.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 451.30 $ 727.87 $ 223,509.68 $ 50,155.77
66 2/1/22 $ 223,509.68 $ 1,179.17 $ - 0 $ 1,179.17 $ 452.76 $ 726.41 $ 223,056.92 $ 50,882.17
67 3/1/22 $ 223,056.92 $ 1,179.17 $ - 0 $ 1,179.17 $ 454.24 $ 724.93 $ 222,602.68 $ 51,607.11
68 4/1/22 $ 222,602.68 $ 1,179.17 $ - 0 $ 1,179.17 $ 455.71 $ 723.46 $ 222,146.97 $ 52,330.57
69 5/1/22 $ 222,146.97 $ 1,179.17 $ - 0 $ 1,179.17 $ 457.19 $ 721.98 $ 221,689.78 $ 53,052.54
70 6/1/22 $ 221,689.78 $ 1,179.17 $ - 0 $ 1,179.17 $ 458.68 $ 720.49 $ 221,231.10 $ 53,773.04
71 7/1/22 $ 221,231.10 $ 1,179.17 $ - 0 $ 1,179.17 $ 460.17 $ 719.00 $ 220,770.93 $ 54,492.04
72 8/1/22 $ 220,770.93 $ 1,179.17 $ - 0 $ 1,179.17 $ 461.66 $ 717.51 $ 220,309.26 $ 55,209.54
73 9/1/22 $ 220,309.26 $ 1,179.17 $ - 0 $ 1,179.17 $ 463.17 $ 716.01 $ 219,846.10 $ 55,925.55
74 10/1/22 $ 219,846.10 $ 1,179.17 $ - 0 $ 1,179.17 $ 464.67 $ 714.50 $ 219,381.43 $ 56,640.05
75 11/1/22 $ 219,381.43 $ 1,179.17 $ - 0 $ 1,179.17 $ 466.18 $ 712.99 $ 218,915.25 $ 57,353.04
76 12/1/22 $ 218,915.25 $ 1,179.17 $ - 0 $ 1,179.17 $ 467.70 $ 711.47 $ 218,447.55 $ 58,064.51
77 1/1/23 $ 218,447.55 $ 1,179.17 $ - 0 $ 1,179.17 $ 469.22 $ 709.95 $ 217,978.34 $ 58,774.47
78 2/1/23 $ 217,978.34 $ 1,179.17 $ - 0 $ 1,179.17 $ 470.74 $ 708.43 $ 217,507.60 $ 59,482.89
79 3/1/23 $ 217,507.60 $ 1,179.17 $ - 0 $ 1,179.17 $ 472.27 $ 706.90 $ 217,035.32 $ 60,189.79
80 4/1/23 $ 217,035.32 $ 1,179.17 $ - 0 $ 1,179.17 $ 473.81 $ 705.36 $ 216,561.52 $ 60,895.16
81 5/1/23 $ 216,561.52 $ 1,179.17 $ - 0 $ 1,179.17 $ 475.35 $ 703.82 $ 216,086.17 $ 61,598.98
82 6/1/23 $ 216,086.17 $ 1,179.17 $ - 0 $ 1,179.17 $ 476.89 $ 702.28 $ 215,609.28 $ 62,301.26
83 7/1/23 $ 215,609.28 $ 1,179.17 $ - 0 $ 1,179.17 $ 478.44 $ 700.73 $ 215,130.84 $ 63,001.99
84 8/1/23 $ 215,130.84 $ 1,179.17 $ - 0 $ 1,179.17 $ 480.00 $ 699.18 $ 214,650.85 $ 63,701.17
85 9/1/23 $ 214,650.85 $ 1,179.17 $ - 0 $ 1,179.17 $ 481.56 $ 697.62 $ 214,169.29 $ 64,398.79
86 10/1/23 $ 214,169.29 $ 1,179.17 $ - 0 $ 1,179.17 $ 483.12 $ 696.05 $ 213,686.17 $ 65,094.84
87 11/1/23 $ 213,686.17 $ 1,179.17 $ - 0 $ 1,179.17 $ 484.69 $ 694.48 $ 213,201.48 $ 65,789.32
88 12/1/23 $ 213,201.48 $ 1,179.17 $ - 0 $ 1,179.17 $ 486.27 $ 692.90 $ 212,715.22 $ 66,482.22
89 1/1/24 $ 212,715.22 $ 1,179.17 $ - 0 $ 1,179.17 $ 487.85 $ 691.32 $ 212,227.37 $ 67,173.54
90 2/1/24 $ 212,227.37 $ 1,179.17 $ - 0 $ 1,179.17 $ 489.43 $ 689.74 $ 211,737.94 $ 67,863.28
91 3/1/24 $ 211,737.94 $ 1,179.17 $ - 0 $ 1,179.17 $ 491.02 $ 688.15 $ 211,246.92 $ 68,551.43
92 4/1/24 $ 211,246.92 $ 1,179.17 $ - 0 $ 1,179.17 $ 492.62 $ 686.55 $ 210,754.30 $ 69,237.98
93 5/1/24 $ 210,754.30 $ 1,179.17 $ - 0 $ 1,179.17 $ 494.22 $ 684.95 $ 210,260.08 $ 69,922.94
94 6/1/24 $ 210,260.08 $ 1,179.17 $ - 0 $ 1,179.17 $ 495.83 $ 683.35 $ 209,764.25 $ 70,606.28
95 7/1/24 $ 209,764.25 $ 1,179.17 $ - 0 $ 1,179.17 $ 497.44 $ 681.73 $ 209,266.82 $ 71,288.01
96 8/1/24 $ 209,266.82 $ 1,179.17 $ - 0 $ 1,179.17 $ 499.05 $ 680.12 $ 208,767.76 $ 71,968.13
97 9/1/24 $ 208,767.76 $ 1,179.17 $ - 0 $ 1,179.17 $ 500.68 $ 678.50 $ 208,267.09 $ 72,646.63
98 10/1/24 $ 208,267.09 $ 1,179.17 $ - 0 $ 1,179.17 $ 502.30 $ 676.87 $ 207,764.79 $ 73,323.50
99 11/1/24 $ 207,764.79 $ 1,179.17 $ - 0 $ 1,179.17 $ 503.93 $ 675.24 $ 207,260.85 $ 73,998.73
100 12/1/24 $ 207,260.85 $ 1,179.17 $ - 0 $ 1,179.17 $ 505.57 $ 673.60 $ 206,755.28 $ 74,672.33
101 1/1/25 $ 206,755.28 $ 1,179.17 $ - 0 $ 1,179.17 $ 507.22 $ 671.95 $ 206,248.06 $ 75,344.28
102 2/1/25 $ 206,248.06 $ 1,179.17 $ - 0 $ 1,179.17 $ 508.86 $ 670.31 $ 205,739.20 $ 76,014.59
103 3/1/25 $ 205,739.20 $ 1,179.17 $ - 0 $ 1,179.17 $ 510.52 $ 668.65 $ 205,228.68 $ 76,683.24
104 4/1/25 $ 205,228.68 $ 1,179.17 $ - 0 $ 1,179.17 $ 512.18 $ 666.99 $ 204,716.50 $ 77,350.23
105 5/1/25 $ 204,716.50 $ 1,179.17 $ - 0 $ 1,179.17 $ 513.84 $ 665.33 $ 204,202.66 $ 78,015.56
106 6/1/25 $ 204,202.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 515.51 $ 663.66 $ 203,687.15 $ 78,679.22
107 7/1/25 $ 203,687.15 $ 1,179.17 $ - 0 $ 1,179.17 $ 517.19 $ 661.98 $ 203,169.96 $ 79,341.21
108 8/1/25 $ 203,169.96 $ 1,179.17 $ - 0 $ 1,179.17 $ 518.87 $ 660.30 $ 202,651.09 $ 80,001.51
109 9/1/25 $ 202,651.09 $ 1,179.17 $ - 0 $ 1,179.17 $ 520.55 $ 658.62 $ 202,130.54 $ 80,660.12
110 10/1/25 $ 202,130.54 $ 1,179.17 $ - 0 $ 1,179.17 $ 522.25 $ 656.92 $ 201,608.29 $ 81,317.05
111 11/1/25 $ 201,608.29 $ 1,179.17 $ - 0 $ 1,179.17 $ 523.94 $ 655.23 $ 201,084.35 $ 81,972.28
112 12/1/25 $ 201,084.35 $ 1,179.17 $ - 0 $ 1,179.17 $ 525.65 $ 653.52 $ 200,558.70 $ 82,625.80
113 1/1/26 $ 200,558.70 $ 1,179.17 $ - 0 $ 1,179.17 $ 527.35 $ 651.82 $ 200,031.35 $ 83,277.62
114 2/1/26 $ 200,031.35 $ 1,179.17 $ - 0 $ 1,179.17 $ 529.07 $ 650.10 $ 199,502.28 $ 83,927.72
115 3/1/26 $ 199,502.28 $ 1,179.17 $ - 0 $ 1,179.17 $ 530.79 $ 648.38 $ 198,971.49 $ 84,576.10
116 4/1/26 $ 198,971.49 $ 1,179.17 $ - 0 $ 1,179.17 $ 532.51 $ 646.66 $ 198,438.98 $ 85,222.76
117 5/1/26 $ 198,438.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 534.24 $ 644.93 $ 197,904.73 $ 85,867.68
118 6/1/26 $ 197,904.73 $ 1,179.17 $ - 0 $ 1,179.17 $ 535.98 $ 643.19 $ 197,368.75 $ 86,510.87
119 7/1/26 $ 197,368.75 $ 1,179.17 $ - 0 $ 1,179.17 $ 537.72 $ 641.45 $ 196,831.03 $ 87,152.32
120 8/1/26 $ 196,831.03 $ 1,179.17 $ - 0 $ 1,179.17 $ 539.47 $ 639.70 $ 196,291.56 $ 87,792.02
121 9/1/26 $ 196,291.56 $ 1,179.17 $ - 0 $ 1,179.17 $ 541.22 $ 637.95 $ 195,750.34 $ 88,429.97
122 10/1/26 $ 195,750.34 $ 1,179.17 $ - 0 $ 1,179.17 $ 542.98 $ 636.19 $ 195,207.36 $ 89,066.16
123 11/1/26 $ 195,207.36 $ 1,179.17 $ - 0 $ 1,179.17 $ 544.75 $ 634.42 $ 194,662.61 $ 89,700.58
124 12/1/26 $ 194,662.61 $ 1,179.17 $ - 0 $ 1,179.17 $ 546.52 $ 632.65 $ 194,116.09 $ 90,333.24
125 1/1/27 $ 194,116.09 $ 1,179.17 $ - 0 $ 1,179.17 $ 548.29 $ 630.88 $ 193,567.80 $ 90,964.11
126 2/1/27 $ 193,567.80 $ 1,179.17 $ - 0 $ 1,179.17 $ 550.08 $ 629.10 $ 193,017.72 $ 91,593.21
127 3/1/27 $ 193,017.72 $ 1,179.17 $ - 0 $ 1,179.17 $ 551.86 $ 627.31 $ 192,465.86 $ 92,220.52
128 4/1/27 $ 192,465.86 $ 1,179.17 $ - 0 $ 1,179.17 $ 553.66 $ 625.51 $ 191,912.21 $ 92,846.03
129 5/1/27 $ 191,912.21 $ 1,179.17 $ - 0 $ 1,179.17 $ 555.46 $ 623.71 $ 191,356.75 $ 93,469.75
130 6/1/27 $ 191,356.75 $ 1,179.17 $ - 0 $ 1,179.17 $ 557.26 $ 621.91 $ 190,799.49 $ 94,091.65
131 7/1/27 $ 190,799.49 $ 1,179.17 $ - 0 $ 1,179.17 $ 559.07 $ 620.10 $ 190,240.42 $ 94,711.75
132 8/1/27 $ 190,240.42 $ 1,179.17 $ - 0 $ 1,179.17 $ 560.89 $ 618.28 $ 189,679.53 $ 95,330.03
133 9/1/27 $ 189,679.53 $ 1,179.17 $ - 0 $ 1,179.17 $ 562.71 $ 616.46 $ 189,116.82 $ 95,946.49
134 10/1/27 $ 189,116.82 $ 1,179.17 $ - 0 $ 1,179.17 $ 564.54 $ 614.63 $ 188,552.27 $ 96,561.12
135 11/1/27 $ 188,552.27 $ 1,179.17 $ - 0 $ 1,179.17 $ 566.38 $ 612.79 $ 187,985.90 $ 97,173.92
136 12/1/27 $ 187,985.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 568.22 $ 610.95 $ 187,417.68 $ 97,784.87
137 1/1/28 $ 187,417.68 $ 1,179.17 $ - 0 $ 1,179.17 $ 570.06 $ 609.11 $ 186,847.62 $ 98,393.98
138 2/1/28 $ 186,847.62 $ 1,179.17 $ - 0 $ 1,179.17 $ 571.92 $ 607.25 $ 186,275.70 $ 99,001.23
139 3/1/28 $ 186,275.70 $ 1,179.17 $ - 0 $ 1,179.17 $ 573.77 $ 605.40 $ 185,701.93 $ 99,606.63
140 4/1/28 $ 185,701.93 $ 1,179.17 $ - 0 $ 1,179.17 $ 575.64 $ 603.53 $ 185,126.29 $ 100,210.16
141 5/1/28 $ 185,126.29 $ 1,179.17 $ - 0 $ 1,179.17 $ 577.51 $ 601.66 $ 184,548.78 $ 100,811.82
142 6/1/28 $ 184,548.78 $ 1,179.17 $ - 0 $ 1,179.17 $ 579.39 $ 599.78 $ 183,969.39 $ 101,411.61
143 7/1/28 $ 183,969.39 $ 1,179.17 $ - 0 $ 1,179.17 $ 581.27 $ 597.90 $ 183,388.12 $ 102,009.51
144 8/1/28 $ 183,388.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 583.16 $ 596.01 $ 182,804.96 $ 102,605.52
145 9/1/28 $ 182,804.96 $ 1,179.17 $ - 0 $ 1,179.17 $ 585.05 $ 594.12 $ 182,219.91 $ 103,199.63
146 10/1/28 $ 182,219.91 $ 1,179.17 $ - 0 $ 1,179.17 $ 586.96 $ 592.21 $ 181,632.95 $ 103,791.85
147 11/1/28 $ 181,632.95 $ 1,179.17 $ - 0 $ 1,179.17 $ 588.86 $ 590.31 $ 181,044.09 $ 104,382.16
148 12/1/28 $ 181,044.09 $ 1,179.17 $ - 0 $ 1,179.17 $ 590.78 $ 588.39 $ 180,453.31 $ 104,970.55
149 1/1/29 $ 180,453.31 $ 1,179.17 $ - 0 $ 1,179.17 $ 592.70 $ 586.47 $ 179,860.62 $ 105,557.02
150 2/1/29 $ 179,860.62 $ 1,179.17 $ - 0 $ 1,179.17 $ 594.62 $ 584.55 $ 179,265.99 $ 106,141.57
151 3/1/29 $ 179,265.99 $ 1,179.17 $ - 0 $ 1,179.17 $ 596.56 $ 582.61 $ 178,669.44 $ 106,724.18
152 4/1/29 $ 178,669.44 $ 1,179.17 $ - 0 $ 1,179.17 $ 598.49 $ 580.68 $ 178,070.94 $ 107,304.86
153 5/1/29 $ 178,070.94 $ 1,179.17 $ - 0 $ 1,179.17 $ 600.44 $ 578.73 $ 177,470.50 $ 107,883.59
154 6/1/29 $ 177,470.50 $ 1,179.17 $ - 0 $ 1,179.17 $ 602.39 $ 576.78 $ 176,868.11 $ 108,460.37
155 7/1/29 $ 176,868.11 $ 1,179.17 $ - 0 $ 1,179.17 $ 604.35 $ 574.82 $ 176,263.76 $ 109,035.19
156 8/1/29 $ 176,263.76 $ 1,179.17 $ - 0 $ 1,179.17 $ 606.31 $ 572.86 $ 175,657.45 $ 109,608.05
157 9/1/29 $ 175,657.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 608.28 $ 570.89 $ 175,049.16 $ 110,178.93
158 10/1/29 $ 175,049.16 $ 1,179.17 $ - 0 $ 1,179.17 $ 610.26 $ 568.91 $ 174,438.90 $ 110,747.84
159 11/1/29 $ 174,438.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 612.24 $ 566.93 $ 173,826.66 $ 111,314.77
160 12/1/29 $ 173,826.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 614.23 $ 564.94 $ 173,212.43 $ 111,879.71
161 1/1/30 $ 173,212.43 $ 1,179.17 $ - 0 $ 1,179.17 $ 616.23 $ 562.94 $ 172,596.19 $ 112,442.65
162 2/1/30 $ 172,596.19 $ 1,179.17 $ - 0 $ 1,179.17 $ 618.23 $ 560.94 $ 171,977.96 $ 113,003.58
163 3/1/30 $ 171,977.96 $ 1,179.17 $ - 0 $ 1,179.17 $ 620.24 $ 558.93 $ 171,357.72 $ 113,562.51
164 4/1/30 $ 171,357.72 $ 1,179.17 $ - 0 $ 1,179.17 $ 622.26 $ 556.91 $ 170,735.46 $ 114,119.43
165 5/1/30 $ 170,735.46 $ 1,179.17 $ - 0 $ 1,179.17 $ 624.28 $ 554.89 $ 170,111.18 $ 114,674.32
166 6/1/30 $ 170,111.18 $ 1,179.17 $ - 0 $ 1,179.17 $ 626.31 $ 552.86 $ 169,484.87 $ 115,227.18
167 7/1/30 $ 169,484.87 $ 1,179.17 $ - 0 $ 1,179.17 $ 628.34 $ 550.83 $ 168,856.53 $ 115,778.00
168 8/1/30 $ 168,856.53 $ 1,179.17 $ - 0 $ 1,179.17 $ 630.39 $ 548.78 $ 168,226.14 $ 116,326.79
169 9/1/30 $ 168,226.14 $ 1,179.17 $ - 0 $ 1,179.17 $ 632.44 $ 546.73 $ 167,593.71 $ 116,873.52
170 10/1/30 $ 167,593.71 $ 1,179.17 $ - 0 $ 1,179.17 $ 634.49 $ 544.68 $ 166,959.21 $ 117,418.20
171 11/1/30 $ 166,959.21 $ 1,179.17 $ - 0 $ 1,179.17 $ 636.55 $ 542.62 $ 166,322.66 $ 117,960.82
172 12/1/30 $ 166,322.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 638.62 $ 540.55 $ 165,684.04 $ 118,501.37
173 1/1/31 $ 165,684.04 $ 1,179.17 $ - 0 $ 1,179.17 $ 640.70 $ 538.47 $ 165,043.34 $ 119,039.84
174 2/1/31 $ 165,043.34 $ 1,179.17 $ - 0 $ 1,179.17 $ 642.78 $ 536.39 $ 164,400.56 $ 119,576.23
175 3/1/31 $ 164,400.56 $ 1,179.17 $ - 0 $ 1,179.17 $ 644.87 $ 534.30 $ 163,755.69 $ 120,110.53
176 4/1/31 $ 163,755.69 $ 1,179.17 $ - 0 $ 1,179.17 $ 646.96 $ 532.21 $ 163,108.73 $ 120,642.74
177 5/1/31 $ 163,108.73 $ 1,179.17 $ - 0 $ 1,179.17 $ 649.07 $ 530.10 $ 162,459.66 $ 121,172.84
178 6/1/31 $ 162,459.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 651.18 $ 527.99 $ 161,808.49 $ 121,700.84
179 7/1/31 $ 161,808.49 $ 1,179.17 $ - 0 $ 1,179.17 $ 653.29 $ 525.88 $ 161,155.19 $ 122,226.71
180 8/1/31 $ 161,155.19 $ 1,179.17 $ - 0 $ 1,179.17 $ 655.42 $ 523.75 $ 160,499.78 $ 122,750.47
181 9/1/31 $ 160,499.78 $ 1,179.17 $ - 0 $ 1,179.17 $ 657.55 $ 521.62 $ 159,842.23 $ 123,272.09
182 10/1/31 $ 159,842.23 $ 1,179.17 $ - 0 $ 1,179.17 $ 659.68 $ 519.49 $ 159,182.55 $ 123,791.58
183 11/1/31 $ 159,182.55 $ 1,179.17 $ - 0 $ 1,179.17 $ 661.83 $ 517.34 $ 158,520.72 $ 124,308.92
184 12/1/31 $ 158,520.72 $ 1,179.17 $ - 0 $ 1,179.17 $ 663.98 $ 515.19 $ 157,856.74 $ 124,824.12
185 1/1/32 $ 157,856.74 $ 1,179.17 $ - 0 $ 1,179.17 $ 666.14 $ 513.03 $ 157,190.61 $ 125,337.15
186 2/1/32 $ 157,190.61 $ 1,179.17 $ - 0 $ 1,179.17 $ 668.30 $ 510.87 $ 156,522.30 $ 125,848.02
187 3/1/32 $ 156,522.30 $ 1,179.17 $ - 0 $ 1,179.17 $ 670.47 $ 508.70 $ 155,851.83 $ 126,356.72
188 4/1/32 $ 155,851.83 $ 1,179.17 $ - 0 $ 1,179.17 $ 672.65 $ 506.52 $ 155,179.18 $ 126,863.24
189 5/1/32 $ 155,179.18 $ 1,179.17 $ - 0 $ 1,179.17 $ 674.84 $ 504.33 $ 154,504.34 $ 127,367.57
190 6/1/32 $ 154,504.34 $ 1,179.17 $ - 0 $ 1,179.17 $ 677.03 $ 502.14 $ 153,827.31 $ 127,869.71
191 7/1/32 $ 153,827.31 $ 1,179.17 $ - 0 $ 1,179.17 $ 679.23 $ 499.94 $ 153,148.08 $ 128,369.65
192 8/1/32 $ 153,148.08 $ 1,179.17 $ - 0 $ 1,179.17 $ 681.44 $ 497.73 $ 152,466.64 $ 128,867.38
193 9/1/32 $ 152,466.64 $ 1,179.17 $ - 0 $ 1,179.17 $ 683.65 $ 495.52 $ 151,782.98 $ 129,362.89
194 10/1/32 $ 151,782.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 685.88 $ 493.29 $ 151,097.11 $ 129,856.19
195 11/1/32 $ 151,097.11 $ 1,179.17 $ - 0 $ 1,179.17 $ 688.10 $ 491.07 $ 150,409.00 $ 130,347.25
196 12/1/32 $ 150,409.00 $ 1,179.17 $ - 0 $ 1,179.17 $ 690.34 $ 488.83 $ 149,718.66 $ 130,836.08
197 1/1/33 $ 149,718.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 692.58 $ 486.59 $ 149,026.08 $ 131,322.67
198 2/1/33 $ 149,026.08 $ 1,179.17 $ - 0 $ 1,179.17 $ 694.84 $ 484.33 $ 148,331.24 $ 131,807.00
199 3/1/33 $ 148,331.24 $ 1,179.17 $ - 0 $ 1,179.17 $ 697.09 $ 482.08 $ 147,634.15 $ 132,289.08
200 4/1/33 $ 147,634.15 $ 1,179.17 $ - 0 $ 1,179.17 $ 699.36 $ 479.81 $ 146,934.79 $ 132,768.89
201 5/1/33 $ 146,934.79 $ 1,179.17 $ - 0 $ 1,179.17 $ 701.63 $ 477.54 $ 146,233.16 $ 133,246.43
202 6/1/33 $ 146,233.16 $ 1,179.17 $ - 0 $ 1,179.17 $ 703.91 $ 475.26 $ 145,529.24 $ 133,721.69
203 7/1/33 $ 145,529.24 $ 1,179.17 $ - 0 $ 1,179.17 $ 706.20 $ 472.97 $ 144,823.04 $ 134,194.66
204 8/1/33 $ 144,823.04 $ 1,179.17 $ - 0 $ 1,179.17 $ 708.50 $ 470.67 $ 144,114.55 $ 134,665.33
205 9/1/33 $ 144,114.55 $ 1,179.17 $ - 0 $ 1,179.17 $ 710.80 $ 468.37 $ 143,403.75 $ 135,133.70
206 10/1/33 $ 143,403.75 $ 1,179.17 $ - 0 $ 1,179.17 $ 713.11 $ 466.06 $ 142,690.64 $ 135,599.77
207 11/1/33 $ 142,690.64 $ 1,179.17 $ - 0 $ 1,179.17 $ 715.43 $ 463.74 $ 141,975.22 $ 136,063.51
208 12/1/33 $ 141,975.22 $ 1,179.17 $ - 0 $ 1,179.17 $ 717.75 $ 461.42 $ 141,257.46 $ 136,524.93
209 1/1/34 $ 141,257.46 $ 1,179.17 $ - 0 $ 1,179.17 $ 720.08 $ 459.09 $ 140,537.38 $ 136,984.02
210 2/1/34 $ 140,537.38 $ 1,179.17 $ - 0 $ 1,179.17 $ 722.42 $ 456.75 $ 139,814.96 $ 137,440.76
211 3/1/34 $ 139,814.96 $ 1,179.17 $ - 0 $ 1,179.17 $ 724.77 $ 454.40 $ 139,090.18 $ 137,895.16
212 4/1/34 $ 139,090.18 $ 1,179.17 $ - 0 $ 1,179.17 $ 727.13 $ 452.04 $ 138,363.06 $ 138,347.21
213 5/1/34 $ 138,363.06 $ 1,179.17 $ - 0 $ 1,179.17 $ 729.49 $ 449.68 $ 137,633.57 $ 138,796.89
214 6/1/34 $ 137,633.57 $ 1,179.17 $ - 0 $ 1,179.17 $ 731.86 $ 447.31 $ 136,901.70 $ 139,244.19
215 7/1/34 $ 136,901.70 $ 1,179.17 $ - 0 $ 1,179.17 $ 734.24 $ 444.93 $ 136,167.47 $ 139,689.12
216 8/1/34 $ 136,167.47 $ 1,179.17 $ - 0 $ 1,179.17 $ 736.63 $ 442.54 $ 135,430.84 $ 140,131.67
217 9/1/34 $ 135,430.84 $ 1,179.17 $ - 0 $ 1,179.17 $ 739.02 $ 440.15 $ 134,691.82 $ 140,571.82
218 10/1/34 $ 134,691.82 $ 1,179.17 $ - 0 $ 1,179.17 $ 741.42 $ 437.75 $ 133,950.40 $ 141,009.57
219 11/1/34 $ 133,950.40 $ 1,179.17 $ - 0 $ 1,179.17 $ 743.83 $ 435.34 $ 133,206.56 $ 141,444.91
220 12/1/34 $ 133,206.56 $ 1,179.17 $ - 0 $ 1,179.17 $ 746.25 $ 432.92 $ 132,460.32 $ 141,877.83
221 1/1/35 $ 132,460.32 $ 1,179.17 $ - 0 $ 1,179.17 $ 748.67 $ 430.50 $ 131,711.64 $ 142,308.32
222 2/1/35 $ 131,711.64 $ 1,179.17 $ - 0 $ 1,179.17 $ 751.11 $ 428.06 $ 130,960.53 $ 142,736.39
223 3/1/35 $ 130,960.53 $ 1,179.17 $ - 0 $ 1,179.17 $ 753.55 $ 425.62 $ 130,206.98 $ 143,162.01
224 4/1/35 $ 130,206.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 756.00 $ 423.17 $ 129,450.99 $ 143,585.18
225 5/1/35 $ 129,450.99 $ 1,179.17 $ - 0 $ 1,179.17 $ 758.45 $ 420.72 $ 128,692.53 $ 144,005.90
226 6/1/35 $ 128,692.53 $ 1,179.17 $ - 0 $ 1,179.17 $ 760.92 $ 418.25 $ 127,931.61 $ 144,424.15
227 7/1/35 $ 127,931.61 $ 1,179.17 $ - 0 $ 1,179.17 $ 763.39 $ 415.78 $ 127,168.22 $ 144,839.93
228 8/1/35 $ 127,168.22 $ 1,179.17 $ - 0 $ 1,179.17 $ 765.87 $ 413.30 $ 126,402.35 $ 145,253.22
229 9/1/35 $ 126,402.35 $ 1,179.17 $ - 0 $ 1,179.17 $ 768.36 $ 410.81 $ 125,633.98 $ 145,664.03
230 10/1/35 $ 125,633.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 770.86 $ 408.31 $ 124,863.12 $ 146,072.34
231 11/1/35 $ 124,863.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 773.37 $ 405.81 $ 124,089.76 $ 146,478.15
232 12/1/35 $ 124,089.76 $ 1,179.17 $ - 0 $ 1,179.17 $ 775.88 $ 403.29 $ 123,313.88 $ 146,881.44
233 1/1/36 $ 123,313.88 $ 1,179.17 $ - 0 $ 1,179.17 $ 778.40 $ 400.77 $ 122,535.48 $ 147,282.21
234 2/1/36 $ 122,535.48 $ 1,179.17 $ - 0 $ 1,179.17 $ 780.93 $ 398.24 $ 121,754.55 $ 147,680.45
235 3/1/36 $ 121,754.55 $ 1,179.17 $ - 0 $ 1,179.17 $ 783.47 $ 395.70 $ 120,971.08 $ 148,076.15
236 4/1/36 $ 120,971.08 $ 1,179.17 $ - 0 $ 1,179.17 $ 786.01 $ 393.16 $ 120,185.07 $ 148,469.31
237 5/1/36 $ 120,185.07 $ 1,179.17 $ - 0 $ 1,179.17 $ 788.57 $ 390.60 $ 119,396.50 $ 148,859.91
238 6/1/36 $ 119,396.50 $ 1,179.17 $ - 0 $ 1,179.17 $ 791.13 $ 388.04 $ 118,605.36 $ 149,247.95
239 7/1/36 $ 118,605.36 $ 1,179.17 $ - 0 $ 1,179.17 $ 793.70 $ 385.47 $ 117,811.66 $ 149,633.41
240 8/1/36 $ 117,811.66 $ 1,179.17 $ - 0 $ 1,179.17 $ 796.28 $ 382.89 $ 117,015.38 $ 150,016.30
241 9/1/36 $ 117,015.38 $ 1,179.17 $ - 0 $ 1,179.17 $ 798.87 $ 380.30 $ 116,216.51 $ 150,396.60
242 10/1/36 $ 116,216.51 $ 1,179.17 $ - 0 $ 1,179.17 $ 801.47 $ 377.70 $ 115,415.04 $ 150,774.30
243 11/1/36 $ 115,415.04 $ 1,179.17 $ - 0 $ 1,179.17 $ 804.07 $ 375.10 $ 114,610.97 $ 151,149.40
244 12/1/36 $ 114,610.97 $ 1,179.17 $ - 0 $ 1,179.17 $ 806.68 $ 372.49 $ 113,804.28 $ 151,521.89
245 1/1/37 $ 113,804.28 $ 1,179.17 $ - 0 $ 1,179.17 $ 809.31 $ 369.86 $ 112,994.98 $ 151,891.75
246 2/1/37 $ 112,994.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 811.94 $ 367.23 $ 112,183.04 $ 152,258.99
247 3/1/37 $ 112,183.04 $ 1,179.17 $ - 0 $ 1,179.17 $ 814.58 $ 364.59 $ 111,368.47 $ 152,623.58
248 4/1/37 $ 111,368.47 $ 1,179.17 $ - 0 $ 1,179.17 $ 817.22 $ 361.95 $ 110,551.24 $ 152,985.53
249 5/1/37 $ 110,551.24 $ 1,179.17 $ - 0 $ 1,179.17 $ 819.88 $ 359.29 $ 109,731.36 $ 153,344.82
250 6/1/37 $ 109,731.36 $ 1,179.17 $ - 0 $ 1,179.17 $ 822.54 $ 356.63 $ 108,908.82 $ 153,701.45
251 7/1/37 $ 108,908.82 $ 1,179.17 $ - 0 $ 1,179.17 $ 825.22 $ 353.95 $ 108,083.60 $ 154,055.40
252 8/1/37 $ 108,083.60 $ 1,179.17 $ - 0 $ 1,179.17 $ 827.90 $ 351.27 $ 107,255.70 $ 154,406.67
253 9/1/37 $ 107,255.70 $ 1,179.17 $ - 0 $ 1,179.17 $ 830.59 $ 348.58 $ 106,425.11 $ 154,755.25
254 10/1/37 $ 106,425.11 $ 1,179.17 $ - 0 $ 1,179.17 $ 833.29 $ 345.88 $ 105,591.83 $ 155,101.14
255 11/1/37 $ 105,591.83 $ 1,179.17 $ - 0 $ 1,179.17 $ 836.00 $ 343.17 $ 104,755.83 $ 155,444.31
256 12/1/37 $ 104,755.83 $ 1,179.17 $ - 0 $ 1,179.17 $ 838.71 $ 340.46 $ 103,917.11 $ 155,784.77
257 1/1/38 $ 103,917.11 $ 1,179.17 $ - 0 $ 1,179.17 $ 841.44 $ 337.73 $ 103,075.67 $ 156,122.50
258 2/1/38 $ 103,075.67 $ 1,179.17 $ - 0 $ 1,179.17 $ 844.17 $ 335.00 $ 102,231.50 $ 156,457.49
259 3/1/38 $ 102,231.50 $ 1,179.17 $ - 0 $ 1,179.17 $ 846.92 $ 332.25 $ 101,384.58 $ 156,789.74
260 4/1/38 $ 101,384.58 $ 1,179.17 $ - 0 $ 1,179.17 $ 849.67 $ 329.50 $ 100,534.91 $ 157,119.24
261 5/1/38 $ 100,534.91 $ 1,179.17 $ - 0 $ 1,179.17 $ 852.43 $ 326.74 $ 99,682.48 $ 157,445.98
262 6/1/38 $ 99,682.48 $ 1,179.17 $ - 0 $ 1,179.17 $ 855.20 $ 323.97 $ 98,827.28 $ 157,769.95
263 7/1/38 $ 98,827.28 $ 1,179.17 $ - 0 $ 1,179.17 $ 857.98 $ 321.19 $ 97,969.30 $ 158,091.14
264 8/1/38 $ 97,969.30 $ 1,179.17 $ - 0 $ 1,179.17 $ 860.77 $ 318.40 $ 97,108.52 $ 158,409.54
265 9/1/38 $ 97,108.52 $ 1,179.17 $ - 0 $ 1,179.17 $ 863.57 $ 315.60 $ 96,244.96 $ 158,725.14
266 10/1/38 $ 96,244.96 $ 1,179.17 $ - 0 $ 1,179.17 $ 866.37 $ 312.80 $ 95,378.58 $ 159,037.94
267 11/1/38 $ 95,378.58 $ 1,179.17 $ - 0 $ 1,179.17 $ 869.19 $ 309.98 $ 94,509.39 $ 159,347.92
268 12/1/38 $ 94,509.39 $ 1,179.17 $ - 0 $ 1,179.17 $ 872.01 $ 307.16 $ 93,637.38 $ 159,655.07
269 1/1/39 $ 93,637.38 $ 1,179.17 $ - 0 $ 1,179.17 $ 874.85 $ 304.32 $ 92,762.53 $ 159,959.40
270 2/1/39 $ 92,762.53 $ 1,179.17 $ - 0 $ 1,179.17 $ 877.69 $ 301.48 $ 91,884.84 $ 160,260.87
271 3/1/39 $ 91,884.84 $ 1,179.17 $ - 0 $ 1,179.17 $ 880.54 $ 298.63 $ 91,004.29 $ 160,559.50
272 4/1/39 $ 91,004.29 $ 1,179.17 $ - 0 $ 1,179.17 $ 883.41 $ 295.76 $ 90,120.88 $ 160,855.26
273 5/1/39 $ 90,120.88 $ 1,179.17 $ - 0 $ 1,179.17 $ 886.28 $ 292.89 $ 89,234.61 $ 161,148.16
274 6/1/39 $ 89,234.61 $ 1,179.17 $ - 0 $ 1,179.17 $ 889.16 $ 290.01 $ 88,345.45 $ 161,438.17
275 7/1/39 $ 88,345.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 892.05 $ 287.12 $ 87,453.40 $ 161,725.29
276 8/1/39 $ 87,453.40 $ 1,179.17 $ - 0 $ 1,179.17 $ 894.95 $ 284.22 $ 86,558.45 $ 162,009.52
277 9/1/39 $ 86,558.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 897.86 $ 281.31 $ 85,660.60 $ 162,290.83
278 10/1/39 $ 85,660.60 $ 1,179.17 $ - 0 $ 1,179.17 $ 900.77 $ 278.40 $ 84,759.83 $ 162,569.23
279 11/1/39 $ 84,759.83 $ 1,179.17 $ - 0 $ 1,179.17 $ 903.70 $ 275.47 $ 83,856.12 $ 162,844.70
280 12/1/39 $ 83,856.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 906.64 $ 272.53 $ 82,949.49 $ 163,117.23
281 1/1/40 $ 82,949.49 $ 1,179.17 $ - 0 $ 1,179.17 $ 909.58 $ 269.59 $ 82,039.90 $ 163,386.82
282 2/1/40 $ 82,039.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 912.54 $ 266.63 $ 81,127.36 $ 163,653.44
283 3/1/40 $ 81,127.36 $ 1,179.17 $ - 0 $ 1,179.17 $ 915.51 $ 263.66 $ 80,211.85 $ 163,917.11
284 4/1/40 $ 80,211.85 $ 1,179.17 $ - 0 $ 1,179.17 $ 918.48 $ 260.69 $ 79,293.37 $ 164,177.80
285 5/1/40 $ 79,293.37 $ 1,179.17 $ - 0 $ 1,179.17 $ 921.47 $ 257.70 $ 78,371.91 $ 164,435.50
286 6/1/40 $ 78,371.91 $ 1,179.17 $ - 0 $ 1,179.17 $ 924.46 $ 254.71 $ 77,447.44 $ 164,690.21
287 7/1/40 $ 77,447.44 $ 1,179.17 $ - 0 $ 1,179.17 $ 927.47 $ 251.70 $ 76,519.98 $ 164,941.91
288 8/1/40 $ 76,519.98 $ 1,179.17 $ - 0 $ 1,179.17 $ 930.48 $ 248.69 $ 75,589.50 $ 165,190.60
289 9/1/40 $ 75,589.50 $ 1,179.17 $ - 0 $ 1,179.17 $ 933.50 $ 245.67 $ 74,655.99 $ 165,436.27
290 10/1/40 $ 74,655.99 $ 1,179.17 $ - 0 $ 1,179.17 $ 936.54 $ 242.63 $ 73,719.45 $ 165,678.90
291 11/1/40 $ 73,719.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 939.58 $ 239.59 $ 72,779.87 $ 165,918.49
292 12/1/40 $ 72,779.87 $ 1,179.17 $ - 0 $ 1,179.17 $ 942.64 $ 236.53 $ 71,837.24 $ 166,155.02
293 1/1/41 $ 71,837.24 $ 1,179.17 $ - 0 $ 1,179.17 $ 945.70 $ 233.47 $ 70,891.54 $ 166,388.50
294 2/1/41 $ 70,891.54 $ 1,179.17 $ - 0 $ 1,179.17 $ 948.77 $ 230.40 $ 69,942.76 $ 166,618.89
295 3/1/41 $ 69,942.76 $ 1,179.17 $ - 0 $ 1,179.17 $ 951.86 $ 227.31 $ 68,990.91 $ 166,846.21
296 4/1/41 $ 68,990.91 $ 1,179.17 $ - 0 $ 1,179.17 $ 954.95 $ 224.22 $ 68,035.96 $ 167,070.43
297 5/1/41 $ 68,035.96 $ 1,179.17 $ - 0 $ 1,179.17 $ 958.05 $ 221.12 $ 67,077.90 $ 167,291.54
298 6/1/41 $ 67,077.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 961.17 $ 218.00 $ 66,116.73 $ 167,509.55
299 7/1/41 $ 66,116.73 $ 1,179.17 $ - 0 $ 1,179.17 $ 964.29 $ 214.88 $ 65,152.44 $ 167,724.43
300 8/1/41 $ 65,152.44 $ 1,179.17 $ - 0 $ 1,179.17 $ 967.43 $ 211.75 $ 64,185.02 $ 167,936.17
301 9/1/41 $ 64,185.02 $ 1,179.17 $ - 0 $ 1,179.17 $ 970.57 $ 208.60 $ 63,214.45 $ 168,144.77
302 10/1/41 $ 63,214.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 973.72 $ 205.45 $ 62,240.73 $ 168,350.22
303 11/1/41 $ 62,240.73 $ 1,179.17 $ - 0 $ 1,179.17 $ 976.89 $ 202.28 $ 61,263.84 $ 168,552.50
304 12/1/41 $ 61,263.84 $ 1,179.17 $ - 0 $ 1,179.17 $ 980.06 $ 199.11 $ 60,283.77 $ 168,751.61
305 1/1/42 $ 60,283.77 $ 1,179.17 $ - 0 $ 1,179.17 $ 983.25 $ 195.92 $ 59,300.53 $ 168,947.53
306 2/1/42 $ 59,300.53 $ 1,179.17 $ - 0 $ 1,179.17 $ 986.44 $ 192.73 $ 58,314.08 $ 169,140.26
307 3/1/42 $ 58,314.08 $ 1,179.17 $ - 0 $ 1,179.17 $ 989.65 $ 189.52 $ 57,324.43 $ 169,329.78
308 4/1/42 $ 57,324.43 $ 1,179.17 $ - 0 $ 1,179.17 $ 992.87 $ 186.30 $ 56,331.57 $ 169,516.08
309 5/1/42 $ 56,331.57 $ 1,179.17 $ - 0 $ 1,179.17 $ 996.09 $ 183.08 $ 55,335.47 $ 169,699.16
310 6/1/42 $ 55,335.47 $ 1,179.17 $ - 0 $ 1,179.17 $ 999.33 $ 179.84 $ 54,336.14 $ 169,879.00
311 7/1/42 $ 54,336.14 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,002.58 $ 176.59 $ 53,333.57 $ 170,055.59
312 8/1/42 $ 53,333.57 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,005.84 $ 173.33 $ 52,327.73 $ 170,228.93
313 9/1/42 $ 52,327.73 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,009.11 $ 170.07 $ 51,318.62 $ 170,398.99
314 10/1/42 $ 51,318.62 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,012.38 $ 166.79 $ 50,306.24 $ 170,565.78
315 11/1/42 $ 50,306.24 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,015.68 $ 163.50 $ 49,290.56 $ 170,729.27
316 12/1/42 $ 49,290.56 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,018.98 $ 160.19 $ 48,271.59 $ 170,889.47
317 1/1/43 $ 48,271.59 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,022.29 $ 156.88 $ 47,249.30 $ 171,046.35
318 2/1/43 $ 47,249.30 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,025.61 $ 153.56 $ 46,223.69 $ 171,199.91
319 3/1/43 $ 46,223.69 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,028.94 $ 150.23 $ 45,194.75 $ 171,350.14
320 4/1/43 $ 45,194.75 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,032.29 $ 146.88 $ 44,162.46 $ 171,497.02
321 5/1/43 $ 44,162.46 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,035.64 $ 143.53 $ 43,126.82 $ 171,640.55
322 6/1/43 $ 43,126.82 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,039.01 $ 140.16 $ 42,087.81 $ 171,780.71
323 7/1/43 $ 42,087.81 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,042.39 $ 136.79 $ 41,045.42 $ 171,917.50
324 8/1/43 $ 41,045.42 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,045.77 $ 133.40 $ 39,999.65 $ 172,050.89
325 9/1/43 $ 39,999.65 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,049.17 $ 130.00 $ 38,950.48 $ 172,180.89
326 10/1/43 $ 38,950.48 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,052.58 $ 126.59 $ 37,897.90 $ 172,307.48
327 11/1/43 $ 37,897.90 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,056.00 $ 123.17 $ 36,841.89 $ 172,430.65
328 12/1/43 $ 36,841.89 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,059.43 $ 119.74 $ 35,782.46 $ 172,550.39
329 1/1/44 $ 35,782.46 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,062.88 $ 116.29 $ 34,719.58 $ 172,666.68
330 2/1/44 $ 34,719.58 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,066.33 $ 112.84 $ 33,653.25 $ 172,779.52
331 3/1/44 $ 33,653.25 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,069.80 $ 109.37 $ 32,583.45 $ 172,888.89
332 4/1/44 $ 32,583.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,073.27 $ 105.90 $ 31,510.18 $ 172,994.79
333 5/1/44 $ 31,510.18 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,076.76 $ 102.41 $ 30,433.42 $ 173,097.20
334 6/1/44 $ 30,433.42 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,080.26 $ 98.91 $ 29,353.15 $ 173,196.10
335 7/1/44 $ 29,353.15 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,083.77 $ 95.40 $ 28,269.38 $ 173,291.50
336 8/1/44 $ 28,269.38 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,087.30 $ 91.88 $ 27,182.09 $ 173,383.38
337 9/1/44 $ 27,182.09 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,090.83 $ 88.34 $ 26,091.26 $ 173,471.72
338 10/1/44 $ 26,091.26 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,094.37 $ 84.80 $ 24,996.88 $ 173,556.52
339 11/1/44 $ 24,996.88 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,097.93 $ 81.24 $ 23,898.95 $ 173,637.76
340 12/1/44 $ 23,898.95 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,101.50 $ 77.67 $ 22,797.45 $ 173,715.43
341 1/1/45 $ 22,797.45 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,105.08 $ 74.09 $ 21,692.38 $ 173,789.52
342 2/1/45 $ 21,692.38 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,108.67 $ 70.50 $ 20,583.71 $ 173,860.02
343 3/1/45 $ 20,583.71 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,112.27 $ 66.90 $ 19,471.43 $ 173,926.92
344 4/1/45 $ 19,471.43 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,115.89 $ 63.28 $ 18,355.54 $ 173,990.20
345 5/1/45 $ 18,355.54 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,119.51 $ 59.66 $ 17,236.03 $ 174,049.85
346 6/1/45 $ 17,236.03 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,123.15 $ 56.02 $ 16,112.87 $ 174,105.87
347 7/1/45 $ 16,112.87 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,126.80 $ 52.37 $ 14,986.07 $ 174,158.24
348 8/1/45 $ 14,986.07 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,130.47 $ 48.70 $ 13,855.61 $ 174,206.94
349 9/1/45 $ 13,855.61 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,134.14 $ 45.03 $ 12,721.47 $ 174,251.97
350 10/1/45 $ 12,721.47 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,137.83 $ 41.34 $ 11,583.64 $ 174,293.32
351 11/1/45 $ 11,583.64 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,141.52 $ 37.65 $ 10,442.12 $ 174,330.97
352 12/1/45 $ 10,442.12 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,145.23 $ 33.94 $ 9,296.88 $ 174,364.90
353 1/1/46 $ 9,296.88 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,148.96 $ 30.21 $ 8,147.93 $ 174,395.12
354 2/1/46 $ 8,147.93 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,152.69 $ 26.48 $ 6,995.24 $ 174,421.60
355 3/1/46 $ 6,995.24 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,156.44 $ 22.73 $ 5,838.80 $ 174,444.33
356 4/1/46 $ 5,838.80 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,160.19 $ 18.98 $ 4,678.61 $ 174,463.31
357 5/1/46 $ 4,678.61 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,163.97 $ 15.21 $ 3,514.64 $ 174,478.51
358 6/1/46 $ 3,514.64 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,167.75 $ 11.42 $ 2,346.89 $ 174,489.94
359 7/1/46 $ 2,346.89 $ 1,179.17 $ - 0 $ 1,179.17 $ 1,171.54 $ 7.63 $ 1,175.35 $ 174,497.56
360 8/1/46 $ 1,175.35 $ 1,179.17 $ - 0 $ 1,175.35 $ 1,171.53 $ 3.82 $ - 0 $ 174,501.38
361 9/1/46 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
362 10/1/46 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
363 11/1/46 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
364 12/1/46 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
365 1/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
366 2/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
367 3/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
368 4/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
369 5/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
370 6/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
371 7/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
372 8/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
373 9/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
374 10/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
375 11/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
376 12/1/47 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
377 1/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
378 2/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
379 3/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
380 4/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
381 5/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
382 6/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
383 7/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
384 8/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
385 9/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
386 10/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
387 11/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
388 12/1/48 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
389 1/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
390 2/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
391 3/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
392 4/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
393 5/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
394 6/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
395 7/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
396 8/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
397 9/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
398 10/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
399 11/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
400 12/1/49 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
401 1/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
402 2/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
403 3/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
404 4/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
405 5/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
406 6/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
407 7/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
408 8/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
409 9/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
410 10/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
411 11/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
412 12/1/50 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
413 1/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
414 2/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
415 3/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
416 4/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
417 5/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
418 6/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
419 7/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
420 8/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
421 9/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
422 10/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
423 11/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
424 12/1/51 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
425 1/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
426 2/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
427 3/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
428 4/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
429 5/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
430 6/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
431 7/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
432 8/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
433 9/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
434 10/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
435 11/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
436 12/1/52 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
437 1/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
438 2/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
439 3/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
440 4/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
441 5/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
442 6/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
443 7/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
444 8/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
445 9/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
446 10/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
447 11/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
448 12/1/53 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
449 1/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
450 2/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
451 3/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
452 4/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
453 5/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
454 6/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
455 7/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
456 8/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
457 9/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
458 10/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
459 11/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
460 12/1/54 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
461 1/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
462 2/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
463 3/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
464 4/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
465 5/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
466 6/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
467 7/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
468 8/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
469 9/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
470 10/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
471 11/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
472 12/1/55 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
473 1/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
474 2/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
475 3/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
476 4/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
477 5/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
478 6/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
479 7/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38
480 8/1/56 $ - 0 $ 1,179.17 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 174,501.38

Master it!

Chapter 5 - Master it!
Excel is a tool for solving problems, but with many time value of money problems, you may still need to draw a time line.
This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals:
Years until retirement: 30
Amount to withdraw each year: $ 90,000
Years to withdraw in retirement: $ 20
Interest rate: 8%
Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into her account for her retirement fund.
a. If she starts making these deposits in one year and makes her last deposit on the day she retires, what amount must she deposit annually to be able to make the desired withdrawals at retirement?
b. Suppose your friend has just inherited a large sum of money. Rather than making equal annual payments, she has decided to make one lump sum deposit today to cover her retirement needs. What amount does she have to deposit today?
c. Suppose your friend's employer will contribute to the account each year as part of the company's profit sharing plan. In addition, your friend expects a distribution from a family trust several years from now. What amount must she deposit annually now to be able to make the desired withdrawals at retirement?
Employer's annual contribution: $ 1,500
Years until trust fund distribution: 20
Amount of trust fund distribution: $ 25,000

Solution

Master it! Solution
In order to answer any of these questions, first we need to know how much your friend will need when she is ready to retire. Since this amount will be the same for each of the parts of the problem, we will solve for this amount now, which will be:
Amount needed at retirement:
a. The amount your friend must save each year to fund her retirement is:
Amount to save each year:
b. The lump sum your friend must deposit today to fund her retirement is:
Lump sum deposited today:
c. To find the amount of the annual deposit now, it is easier to break down the components of the problem. Doing so for each of the following to find your friend's annual deposit, we get:
Value of employer's contribution at retirement:
Value of trust fund at retirement:
Amount to save each year now: