Message Font: Serif | Sans-Serif
 
No. of Recommendations: 0
I need to calculate the reportable and deductible interest on an intra-family loan. Here are the terms:

100,000 loan @ 5% for 20 years. No payments for the first 5 years, interest accrues and added to principal. Payments begin in year 6. How much is interest and you much is principal for each year until loan paid off? I can calculate the payments for a loan without the initial time delay.

Any help greatly appreciated!

Terry
Print the post Back To Top
No. of Recommendations: 0
twputnam: "I need to calculate the reportable and deductible interest on an intra-family loan. Here are the terms:

100,000 loan @ 5% for 20 years. No payments for the first 5 years, interest accrues and added to principal. Payments begin in year 6. How much is interest and you much is principal for each year until loan paid off? I can calculate the payments for a loan without the initial time delay."


I cannot help as to the tax consequences of intra-family loan. Possible phantom income and new loan every year? Sorry.

OTOH, you did not give nearly enough information to calculate any amortization schedule.

--How frequently does interest compound? monthly, annually, something else? I would likely want to match to later payment frequency.

--How often are payments due once they start? Monthly, quarterly, annually, something else?

Regards, JAFO

--Is the loan intended to amortize itself over the last 15-years or will payments be calculated on some other schedule with a balloon payment at the end?

Regards, JAFO


Print the post Back To Top
No. of Recommendations: 0
Thanks for the reply.

Answer to questions:
Intrerest to compound monthly.
Payments to be monthly.
Loan to be fully amortized by the end of 20 yrs(15 years of payments).

Terry
Print the post Back To Top
No. of Recommendations: 5
twputnam: "100,000 loan @ 5% for 20 years. No payments for the first 5 years, interest accrues and added to principal. Payments begin in year 6. How much is interest and you much is principal for each year until loan paid off? I can calculate the payments for a loan without the initial time delay.

Interest to compound monthly.
Payments to be monthly.
Loan to be fully amortized by the end of 20 yrs(15 years of payments)."


Balance after 5 years is $128,335.87, monthly amortizing payment is $1014.87 for 179 payments and a final payment of ($1014.87 + $0.50) being $1015.27.

Prin. Bal. i rate int. payment P. reduce. new bal.
$100,000.00 0.05000 $416.67 $0.00 ($416.67) $100,416.67
$100,416.67 0.05000 $418.40 $0.00 ($418.40) $100,835.07
$100,835.07 0.05000 $420.15 $0.00 ($420.15) $101,255.22
$101,255.22 0.05000 $421.90 $0.00 ($421.90) $101,677.11
$101,677.11 0.05000 $423.65 $0.00 ($423.65) $102,100.77
$102,100.77 0.05000 $425.42 $0.00 ($425.42) $102,526.19
$102,526.19 0.05000 $427.19 $0.00 ($427.19) $102,953.38
$102,953.38 0.05000 $428.97 $0.00 ($428.97) $103,382.35
$103,382.35 0.05000 $430.76 $0.00 ($430.76) $103,813.11
$103,813.11 0.05000 $432.55 $0.00 ($432.55) $104,245.67
$104,245.67 0.05000 $434.36 $0.00 ($434.36) $104,680.02
$104,680.02 0.05000 $436.17 $0.00 ($436.17) $105,116.19
$105,116.19 0.05000 $437.98 $0.00 ($437.98) $105,554.17
$105,554.17 0.05000 $439.81 $0.00 ($439.81) $105,993.98
$105,993.98 0.05000 $441.64 $0.00 ($441.64) $106,435.62
$106,435.62 0.05000 $443.48 $0.00 ($443.48) $106,879.11
$106,879.11 0.05000 $445.33 $0.00 ($445.33) $107,324.44
$107,324.44 0.05000 $447.19 $0.00 ($447.19) $107,771.62
$107,771.62 0.05000 $449.05 $0.00 ($449.05) $108,220.67
$108,220.67 0.05000 $450.92 $0.00 ($450.92) $108,671.59
$108,671.59 0.05000 $452.80 $0.00 ($452.80) $109,124.39
$109,124.39 0.05000 $454.68 $0.00 ($454.68) $109,579.07
$109,579.07 0.05000 $456.58 $0.00 ($456.58) $110,035.65
$110,035.65 0.05000 $458.48 $0.00 ($458.48) $110,494.13
$110,494.13 0.05000 $460.39 $0.00 ($460.39) $110,954.53
$110,954.53 0.05000 $462.31 $0.00 ($462.31) $111,416.84
$111,416.84 0.05000 $464.24 $0.00 ($464.24) $111,881.07
$111,881.07 0.05000 $466.17 $0.00 ($466.17) $112,347.24
$112,347.24 0.05000 $468.11 $0.00 ($468.11) $112,815.36
$112,815.36 0.05000 $470.06 $0.00 ($470.06) $113,285.42
$113,285.42 0.05000 $472.02 $0.00 ($472.02) $113,757.44
$113,757.44 0.05000 $473.99 $0.00 ($473.99) $114,231.43
$114,231.43 0.05000 $475.96 $0.00 ($475.96) $114,707.40
$114,707.40 0.05000 $477.95 $0.00 ($477.95) $115,185.35
$115,185.35 0.05000 $479.94 $0.00 ($479.94) $115,665.28
$115,665.28 0.05000 $481.94 $0.00 ($481.94) $116,147.22
$116,147.22 0.05000 $483.95 $0.00 ($483.95) $116,631.17
$116,631.17 0.05000 $485.96 $0.00 ($485.96) $117,117.13
$117,117.13 0.05000 $487.99 $0.00 ($487.99) $117,605.12
$117,605.12 0.05000 $490.02 $0.00 ($490.02) $118,095.14
$118,095.14 0.05000 $492.06 $0.00 ($492.06) $118,587.21
$118,587.21 0.05000 $494.11 $0.00 ($494.11) $119,081.32
$119,081.32 0.05000 $496.17 $0.00 ($496.17) $119,577.49
$119,577.49 0.05000 $498.24 $0.00 ($498.24) $120,075.73
$120,075.73 0.05000 $500.32 $0.00 ($500.32) $120,576.05
$120,576.05 0.05000 $502.40 $0.00 ($502.40) $121,078.45
$121,078.45 0.05000 $504.49 $0.00 ($504.49) $121,582.94
$121,582.94 0.05000 $506.60 $0.00 ($506.60) $122,089.54
$122,089.54 0.05000 $508.71 $0.00 ($508.71) $122,598.24
$122,598.24 0.05000 $510.83 $0.00 ($510.83) $123,109.07
$123,109.07 0.05000 $512.95 $0.00 ($512.95) $123,622.02
$123,622.02 0.05000 $515.09 $0.00 ($515.09) $124,137.11
$124,137.11 0.05000 $517.24 $0.00 ($517.24) $124,654.35
$124,654.35 0.05000 $519.39 $0.00 ($519.39) $125,173.75
$125,173.75 0.05000 $521.56 $0.00 ($521.56) $125,695.30
$125,695.30 0.05000 $523.73 $0.00 ($523.73) $126,219.03
$126,219.03 0.05000 $525.91 $0.00 ($525.91) $126,744.95
$126,744.95 0.05000 $528.10 $0.00 ($528.10) $127,273.05
$127,273.05 0.05000 $530.30 $0.00 ($530.30) $127,803.35
$127,803.35 0.05000 $532.51 $0.00 ($532.51) $128,335.87
$128,335.87 0.05000 $534.73 $1,014.87 $480.14 $127,855.73
$127,855.73 0.05000 $532.73 $1,014.87 $482.14 $127,373.59
$127,373.59 0.05000 $530.72 $1,014.87 $484.15 $126,889.45
$126,889.45 0.05000 $528.71 $1,014.87 $486.16 $126,403.28
$126,403.28 0.05000 $526.68 $1,014.87 $488.19 $125,915.09
$125,915.09 0.05000 $524.65 $1,014.87 $490.22 $125,424.87
$125,424.87 0.05000 $522.60 $1,014.87 $492.27 $124,932.60
$124,932.60 0.05000 $520.55 $1,014.87 $494.32 $124,438.28
$124,438.28 0.05000 $518.49 $1,014.87 $496.38 $123,941.91
$123,941.91 0.05000 $516.42 $1,014.87 $498.45 $123,443.46
$123,443.46 0.05000 $514.35 $1,014.87 $500.52 $122,942.94
$122,942.94 0.05000 $512.26 $1,014.87 $502.61 $122,440.33
$122,440.33 0.05000 $510.17 $1,014.87 $504.70 $121,935.63
$121,935.63 0.05000 $508.07 $1,014.87 $506.80 $121,428.83
$121,428.83 0.05000 $505.95 $1,014.87 $508.92 $120,919.91
$120,919.91 0.05000 $503.83 $1,014.87 $511.04 $120,408.87
$120,408.87 0.05000 $501.70 $1,014.87 $513.17 $119,895.71
$119,895.71 0.05000 $499.57 $1,014.87 $515.30 $119,380.40
$119,380.40 0.05000 $497.42 $1,014.87 $517.45 $118,862.95
$118,862.95 0.05000 $495.26 $1,014.87 $519.61 $118,343.34
$118,343.34 0.05000 $493.10 $1,014.87 $521.77 $117,821.57
$117,821.57 0.05000 $490.92 $1,014.87 $523.95 $117,297.62
$117,297.62 0.05000 $488.74 $1,014.87 $526.13 $116,771.49
$116,771.49 0.05000 $486.55 $1,014.87 $528.32 $116,243.17
$116,243.17 0.05000 $484.35 $1,014.87 $530.52 $115,712.65
$115,712.65 0.05000 $482.14 $1,014.87 $532.73 $115,179.91
$115,179.91 0.05000 $479.92 $1,014.87 $534.95 $114,644.96
$114,644.96 0.05000 $477.69 $1,014.87 $537.18 $114,107.78
$114,107.78 0.05000 $475.45 $1,014.87 $539.42 $113,568.36
$113,568.36 0.05000 $473.20 $1,014.87 $541.67 $113,026.69
$113,026.69 0.05000 $470.94 $1,014.87 $543.93 $112,482.76
$112,482.76 0.05000 $468.68 $1,014.87 $546.19 $111,936.57
$111,936.57 0.05000 $466.40 $1,014.87 $548.47 $111,388.10
$111,388.10 0.05000 $464.12 $1,014.87 $550.75 $110,837.35
$110,837.35 0.05000 $461.82 $1,014.87 $553.05 $110,284.30
$110,284.30 0.05000 $459.52 $1,014.87 $555.35 $109,728.95
$109,728.95 0.05000 $457.20 $1,014.87 $557.67 $109,171.28
$109,171.28 0.05000 $454.88 $1,014.87 $559.99 $108,611.29
$108,611.29 0.05000 $452.55 $1,014.87 $562.32 $108,048.97
$108,048.97 0.05000 $450.20 $1,014.87 $564.67 $107,484.30
$107,484.30 0.05000 $447.85 $1,014.87 $567.02 $106,917.29
$106,917.29 0.05000 $445.49 $1,014.87 $569.38 $106,347.90
$106,347.90 0.05000 $443.12 $1,014.87 $571.75 $105,776.15
$105,776.15 0.05000 $440.73 $1,014.87 $574.14 $105,202.01
$105,202.01 0.05000 $438.34 $1,014.87 $576.53 $104,625.49
$104,625.49 0.05000 $435.94 $1,014.87 $578.93 $104,046.56
$104,046.56 0.05000 $433.53 $1,014.87 $581.34 $103,465.21
$103,465.21 0.05000 $431.11 $1,014.87 $583.76 $102,881.45
$102,881.45 0.05000 $428.67 $1,014.87 $586.20 $102,295.25
$102,295.25 0.05000 $426.23 $1,014.87 $588.64 $101,706.61
$101,706.61 0.05000 $423.78 $1,014.87 $591.09 $101,115.52
$101,115.52 0.05000 $421.31 $1,014.87 $593.56 $100,521.96
$100,521.96 0.05000 $418.84 $1,014.87 $596.03 $99,925.94
$99,925.94 0.05000 $416.36 $1,014.87 $598.51 $99,327.42
$99,327.42 0.05000 $413.86 $1,014.87 $601.01 $98,726.42
$98,726.42 0.05000 $411.36 $1,014.87 $603.51 $98,122.91
$98,122.91 0.05000 $408.85 $1,014.87 $606.02 $97,516.88
$97,516.88 0.05000 $406.32 $1,014.87 $608.55 $96,908.33
$96,908.33 0.05000 $403.78 $1,014.87 $611.09 $96,297.25
$96,297.25 0.05000 $401.24 $1,014.87 $613.63 $95,683.62
$95,683.62 0.05000 $398.68 $1,014.87 $616.19 $95,067.43
$95,067.43 0.05000 $396.11 $1,014.87 $618.76 $94,448.67
$94,448.67 0.05000 $393.54 $1,014.87 $621.33 $93,827.34
$93,827.34 0.05000 $390.95 $1,014.87 $623.92 $93,203.42
$93,203.42 0.05000 $388.35 $1,014.87 $626.52 $92,576.89
$92,576.89 0.05000 $385.74 $1,014.87 $629.13 $91,947.76
$91,947.76 0.05000 $383.12 $1,014.87 $631.75 $91,316.01
$91,316.01 0.05000 $380.48 $1,014.87 $634.39 $90,681.62
$90,681.62 0.05000 $377.84 $1,014.87 $637.03 $90,044.59
$90,044.59 0.05000 $375.19 $1,014.87 $639.68 $89,404.91
$89,404.91 0.05000 $372.52 $1,014.87 $642.35 $88,762.56
$88,762.56 0.05000 $369.84 $1,014.87 $645.03 $88,117.53
$88,117.53 0.05000 $367.16 $1,014.87 $647.71 $87,469.82
$87,469.82 0.05000 $364.46 $1,014.87 $650.41 $86,819.40
$86,819.40 0.05000 $361.75 $1,014.87 $653.12 $86,166.28
$86,166.28 0.05000 $359.03 $1,014.87 $655.84 $85,510.44
$85,510.44 0.05000 $356.29 $1,014.87 $658.58 $84,851.86
$84,851.86 0.05000 $353.55 $1,014.87 $661.32 $84,190.54
$84,190.54 0.05000 $350.79 $1,014.87 $664.08 $83,526.46
$83,526.46 0.05000 $348.03 $1,014.87 $666.84 $82,859.62
$82,859.62 0.05000 $345.25 $1,014.87 $669.62 $82,190.00
$82,190.00 0.05000 $342.46 $1,014.87 $672.41 $81,517.59
$81,517.59 0.05000 $339.66 $1,014.87 $675.21 $80,842.37
$80,842.37 0.05000 $336.84 $1,014.87 $678.03 $80,164.35
$80,164.35 0.05000 $334.02 $1,014.87 $680.85 $79,483.50
$79,483.50 0.05000 $331.18 $1,014.87 $683.69 $78,799.81
$78,799.81 0.05000 $328.33 $1,014.87 $686.54 $78,113.27
$78,113.27 0.05000 $325.47 $1,014.87 $689.40 $77,423.87
$77,423.87 0.05000 $322.60 $1,014.87 $692.27 $76,731.60
$76,731.60 0.05000 $319.72 $1,014.87 $695.15 $76,036.45
$76,036.45 0.05000 $316.82 $1,014.87 $698.05 $75,338.39
$75,338.39 0.05000 $313.91 $1,014.87 $700.96 $74,637.43
$74,637.43 0.05000 $310.99 $1,014.87 $703.88 $73,933.55
$73,933.55 0.05000 $308.06 $1,014.87 $706.81 $73,226.74
$73,226.74 0.05000 $305.11 $1,014.87 $709.76 $72,516.98
$72,516.98 0.05000 $302.15 $1,014.87 $712.72 $71,804.27
$71,804.27 0.05000 $299.18 $1,014.87 $715.69 $71,088.58
$71,088.58 0.05000 $296.20 $1,014.87 $718.67 $70,369.91
$70,369.91 0.05000 $293.21 $1,014.87 $721.66 $69,648.25
$69,648.25 0.05000 $290.20 $1,014.87 $724.67 $68,923.58
$68,923.58 0.05000 $287.18 $1,014.87 $727.69 $68,195.89
$68,195.89 0.05000 $284.15 $1,014.87 $730.72 $67,465.17
$67,465.17 0.05000 $281.10 $1,014.87 $733.77 $66,731.41
$66,731.41 0.05000 $278.05 $1,014.87 $736.82 $65,994.59
$65,994.59 0.05000 $274.98 $1,014.87 $739.89 $65,254.69
$65,254.69 0.05000 $271.89 $1,014.87 $742.98 $64,511.72
$64,511.72 0.05000 $268.80 $1,014.87 $746.07 $63,765.65
$63,765.65 0.05000 $265.69 $1,014.87 $749.18 $63,016.47
$63,016.47 0.05000 $262.57 $1,014.87 $752.30 $62,264.16
$62,264.16 0.05000 $259.43 $1,014.87 $755.44 $61,508.73
$61,508.73 0.05000 $256.29 $1,014.87 $758.58 $60,750.15
$60,750.15 0.05000 $253.13 $1,014.87 $761.74 $59,988.40
$59,988.40 0.05000 $249.95 $1,014.87 $764.92 $59,223.48
$59,223.48 0.05000 $246.76 $1,014.87 $768.11 $58,455.38
$58,455.38 0.05000 $243.56 $1,014.87 $771.31 $57,684.07
$57,684.07 0.05000 $240.35 $1,014.87 $774.52 $56,909.55
$56,909.55 0.05000 $237.12 $1,014.87 $777.75 $56,131.80
$56,131.80 0.05000 $233.88 $1,014.87 $780.99 $55,350.82
$55,350.82 0.05000 $230.63 $1,014.87 $784.24 $54,566.58
$54,566.58 0.05000 $227.36 $1,014.87 $787.51 $53,779.07
$53,779.07 0.05000 $224.08 $1,014.87 $790.79 $52,988.28
$52,988.28 0.05000 $220.78 $1,014.87 $794.09 $52,194.19
$52,194.19 0.05000 $217.48 $1,014.87 $797.39 $51,396.80
$51,396.80 0.05000 $214.15 $1,014.87 $800.72 $50,596.08
$50,596.08 0.05000 $210.82 $1,014.87 $804.05 $49,792.03
$49,792.03 0.05000 $207.47 $1,014.87 $807.40 $48,984.62
$48,984.62 0.05000 $204.10 $1,014.87 $810.77 $48,173.86
$48,173.86 0.05000 $200.72 $1,014.87 $814.15 $47,359.71
$47,359.71 0.05000 $197.33 $1,014.87 $817.54 $46,542.17
$46,542.17 0.05000 $193.93 $1,014.87 $820.94 $45,721.23
$45,721.23 0.05000 $190.51 $1,014.87 $824.36 $44,896.86
$44,896.86 0.05000 $187.07 $1,014.87 $827.80 $44,069.06
$44,069.06 0.05000 $183.62 $1,014.87 $831.25 $43,237.81
$43,237.81 0.05000 $180.16 $1,014.87 $834.71 $42,403.10
$42,403.10 0.05000 $176.68 $1,014.87 $838.19 $41,564.91
$41,564.91 0.05000 $173.19 $1,014.87 $841.68 $40,723.23
$40,723.23 0.05000 $169.68 $1,014.87 $845.19 $39,878.04
$39,878.04 0.05000 $166.16 $1,014.87 $848.71 $39,029.33
$39,029.33 0.05000 $162.62 $1,014.87 $852.25 $38,177.08
$38,177.08 0.05000 $159.07 $1,014.87 $855.80 $37,321.28
$37,321.28 0.05000 $155.51 $1,014.87 $859.36 $36,461.92
$36,461.92 0.05000 $151.92 $1,014.87 $862.95 $35,598.97
$35,598.97 0.05000 $148.33 $1,014.87 $866.54 $34,732.43
$34,732.43 0.05000 $144.72 $1,014.87 $870.15 $33,862.28
$33,862.28 0.05000 $141.09 $1,014.87 $873.78 $32,988.50
$32,988.50 0.05000 $137.45 $1,014.87 $877.42 $32,111.08
$32,111.08 0.05000 $133.80 $1,014.87 $881.07 $31,230.01
$31,230.01 0.05000 $130.13 $1,014.87 $884.74 $30,345.26
$30,345.26 0.05000 $126.44 $1,014.87 $888.43 $29,456.83
$29,456.83 0.05000 $122.74 $1,014.87 $892.13 $28,564.70
$28,564.70 0.05000 $119.02 $1,014.87 $895.85 $27,668.85
$27,668.85 0.05000 $115.29 $1,014.87 $899.58 $26,769.27
$26,769.27 0.05000 $111.54 $1,014.87 $903.33 $25,865.93
$25,865.93 0.05000 $107.77 $1,014.87 $907.10 $24,958.84
$24,958.84 0.05000 $104.00 $1,014.87 $910.87 $24,047.96
$24,047.96 0.05000 $100.20 $1,014.87 $914.67 $23,133.29
$23,133.29 0.05000 $96.39 $1,014.87 $918.48 $22,214.81
$22,214.81 0.05000 $92.56 $1,014.87 $922.31 $21,292.50
$21,292.50 0.05000 $88.72 $1,014.87 $926.15 $20,366.35
$20,366.35 0.05000 $84.86 $1,014.87 $930.01 $19,436.34
$19,436.34 0.05000 $80.98 $1,014.87 $933.89 $18,502.46
$18,502.46 0.05000 $77.09 $1,014.87 $937.78 $17,564.68
$17,564.68 0.05000 $73.19 $1,014.87 $941.68 $16,623.00
$16,623.00 0.05000 $69.26 $1,014.87 $945.61 $15,677.39
$15,677.39 0.05000 $65.32 $1,014.87 $949.55 $14,727.84
$14,727.84 0.05000 $61.37 $1,014.87 $953.50 $13,774.34
$13,774.34 0.05000 $57.39 $1,014.87 $957.48 $12,816.86
$12,816.86 0.05000 $53.40 $1,014.87 $961.47 $11,855.40
$11,855.40 0.05000 $49.40 $1,014.87 $965.47 $10,889.92
$10,889.92 0.05000 $45.37 $1,014.87 $969.50 $9,920.43
$9,920.43 0.05000 $41.34 $1,014.87 $973.53 $8,946.89
$8,946.89 0.05000 $37.28 $1,014.87 $977.59 $7,969.30
$7,969.30 0.05000 $33.21 $1,014.87 $981.66 $6,987.64
$6,987.64 0.05000 $29.12 $1,014.87 $985.75 $6,001.88
$6,001.88 0.05000 $25.01 $1,014.87 $989.86 $5,012.02
$5,012.02 0.05000 $20.88 $1,014.87 $993.99 $4,018.03
$4,018.03 0.05000 $16.74 $1,014.87 $998.13 $3,019.91
$3,019.91 0.05000 $12.58 $1,014.87 $1,002.29 $2,017.62
$2,017.62 0.05000 $08.41 $1,014.87 $1,006.46 $1,011.16
$1,011.16 0.05000 $04.21 $1,015.27 $1,010.66 $0.00

If the table did not appear properly, my apologies, but I do not have time to fiddle with formatting now.

If it helps, you could think of it as being two amortization schedules, first being 100k at 5% montlhy with zero payments for 60 months, and then second being $128,335.87 at 5% monthly fully amortized over 180 months.

Regards, JAFO
Print the post Back To Top
No. of Recommendations: 1
I should have previewed my prior replay!

Prin. Bal.- i rate -int.---payment ---P.reduce. new bal.
$100,000.00 0.05000 $416.67 $0.00--- ($416.67) $100,416.67 
$100,416.67 0.05000 $418.40 $0.00--- ($418.40) $100,835.07 
$100,835.07 0.05000 $420.15 $0.00--- ($420.15) $101,255.22 
$101,255.22 0.05000 $421.90 $0.00--- ($421.90) $101,677.11 
$101,677.11 0.05000 $423.65 $0.00--- ($423.65) $102,100.77 
$102,100.77 0.05000 $425.42 $0.00--- ($425.42) $102,526.19 
$102,526.19 0.05000 $427.19 $0.00--- ($427.19) $102,953.38 
$102,953.38 0.05000 $428.97 $0.00--- ($428.97) $103,382.35 
$103,382.35 0.05000 $430.76 $0.00--- ($430.76) $103,813.11 
$103,813.11 0.05000 $432.55 $0.00--- ($432.55) $104,245.67 
$104,245.67 0.05000 $434.36 $0.00--- ($434.36) $104,680.02 
$104,680.02 0.05000 $436.17 $0.00--- ($436.17) $105,116.19 
$105,116.19 0.05000 $437.98 $0.00--- ($437.98) $105,554.17 
$105,554.17 0.05000 $439.81 $0.00--- ($439.81) $105,993.98 
$105,993.98 0.05000 $441.64 $0.00--- ($441.64) $106,435.62 
$106,435.62 0.05000 $443.48 $0.00--- ($443.48) $106,879.11 
$106,879.11 0.05000 $445.33 $0.00--- ($445.33) $107,324.44 
$107,324.44 0.05000 $447.19 $0.00--- ($447.19) $107,771.62 
$107,771.62 0.05000 $449.05 $0.00--- ($449.05) $108,220.67 
$108,220.67 0.05000 $450.92 $0.00--- ($450.92) $108,671.59 
$108,671.59 0.05000 $452.80 $0.00--- ($452.80) $109,124.39 
$109,124.39 0.05000 $454.68 $0.00--- ($454.68) $109,579.07 
$109,579.07 0.05000 $456.58 $0.00--- ($456.58) $110,035.65 
$110,035.65 0.05000 $458.48 $0.00--- ($458.48) $110,494.13 
$110,494.13 0.05000 $460.39 $0.00--- ($460.39) $110,954.53 
$110,954.53 0.05000 $462.31 $0.00--- ($462.31) $111,416.84 
$111,416.84 0.05000 $464.24 $0.00--- ($464.24) $111,881.07 
$111,881.07 0.05000 $466.17 $0.00--- ($466.17) $112,347.24 
$112,347.24 0.05000 $468.11 $0.00--- ($468.11) $112,815.36 
$112,815.36 0.05000 $470.06 $0.00--- ($470.06) $113,285.42 
$113,285.42 0.05000 $472.02 $0.00--- ($472.02) $113,757.44 
$113,757.44 0.05000 $473.99 $0.00--- ($473.99) $114,231.43 
$114,231.43 0.05000 $475.96 $0.00--- ($475.96) $114,707.40 
$114,707.40 0.05000 $477.95 $0.00--- ($477.95) $115,185.35 
$115,185.35 0.05000 $479.94 $0.00--- ($479.94) $115,665.28 
$115,665.28 0.05000 $481.94 $0.00--- ($481.94) $116,147.22 
$116,147.22 0.05000 $483.95 $0.00--- ($483.95) $116,631.17 
$116,631.17 0.05000 $485.96 $0.00--- ($485.96) $117,117.13 
$117,117.13 0.05000 $487.99 $0.00--- ($487.99) $117,605.12 
$117,605.12 0.05000 $490.02 $0.00--- ($490.02) $118,095.14 
$118,095.14 0.05000 $492.06 $0.00--- ($492.06) $118,587.21 
$118,587.21 0.05000 $494.11 $0.00--- ($494.11) $119,081.32 
$119,081.32 0.05000 $496.17 $0.00--- ($496.17) $119,577.49 
$119,577.49 0.05000 $498.24 $0.00--- ($498.24) $120,075.73 
$120,075.73 0.05000 $500.32 $0.00--- ($500.32) $120,576.05 
$120,576.05 0.05000 $502.40 $0.00--- ($502.40) $121,078.45 
$121,078.45 0.05000 $504.49 $0.00--- ($504.49) $121,582.94 
$121,582.94 0.05000 $506.60 $0.00--- ($506.60) $122,089.54 
$122,089.54 0.05000 $508.71 $0.00--- ($508.71) $122,598.24 
$122,598.24 0.05000 $510.83 $0.00--- ($510.83) $123,109.07 
$123,109.07 0.05000 $512.95 $0.00--- ($512.95) $123,622.02 
$123,622.02 0.05000 $515.09 $0.00--- ($515.09) $124,137.11 
$124,137.11 0.05000 $517.24 $0.00--- ($517.24) $124,654.35 
$124,654.35 0.05000 $519.39 $0.00--- ($519.39) $125,173.75 
$125,173.75 0.05000 $521.56 $0.00--- ($521.56) $125,695.30 
$125,695.30 0.05000 $523.73 $0.00--- ($523.73) $126,219.03 
$126,219.03 0.05000 $525.91 $0.00--- ($525.91) $126,744.95 
$126,744.95 0.05000 $528.10 $0.00--- ($528.10) $127,273.05 
$127,273.05 0.05000 $530.30 $0.00--- ($530.30) $127,803.35 
$127,803.35 0.05000 $532.51 $0.00--- ($532.51) $128,335.87 
$128,335.87 0.05000 $534.73 $1,014.87 $480.14  $127,855.73 
$127,855.73 0.05000 $532.73 $1,014.87 $482.14  $127,373.59 
$127,373.59 0.05000 $530.72 $1,014.87 $484.15  $126,889.45 
$126,889.45 0.05000 $528.71 $1,014.87 $486.16  $126,403.28 
$126,403.28 0.05000 $526.68 $1,014.87 $488.19  $125,915.09 
$125,915.09 0.05000 $524.65 $1,014.87 $490.22  $125,424.87 
$125,424.87 0.05000 $522.60 $1,014.87 $492.27  $124,932.60 
$124,932.60 0.05000 $520.55 $1,014.87 $494.32  $124,438.28 
$124,438.28 0.05000 $518.49 $1,014.87 $496.38  $123,941.91 
$123,941.91 0.05000 $516.42 $1,014.87 $498.45  $123,443.46 
$123,443.46 0.05000 $514.35 $1,014.87 $500.52  $122,942.94 
$122,942.94 0.05000 $512.26 $1,014.87 $502.61  $122,440.33 
$122,440.33 0.05000 $510.17 $1,014.87 $504.70  $121,935.63 
$121,935.63 0.05000 $508.07 $1,014.87 $506.80  $121,428.83 
$121,428.83 0.05000 $505.95 $1,014.87 $508.92  $120,919.91 
$120,919.91 0.05000 $503.83 $1,014.87 $511.04  $120,408.87 
$120,408.87 0.05000 $501.70 $1,014.87 $513.17  $119,895.71 
$119,895.71 0.05000 $499.57 $1,014.87 $515.30  $119,380.40 
$119,380.40 0.05000 $497.42 $1,014.87 $517.45  $118,862.95 
$118,862.95 0.05000 $495.26 $1,014.87 $519.61  $118,343.34 
$118,343.34 0.05000 $493.10 $1,014.87 $521.77  $117,821.57 
$117,821.57 0.05000 $490.92 $1,014.87 $523.95  $117,297.62 
$117,297.62 0.05000 $488.74 $1,014.87 $526.13  $116,771.49 
$116,771.49 0.05000 $486.55 $1,014.87 $528.32  $116,243.17 
$116,243.17 0.05000 $484.35 $1,014.87 $530.52  $115,712.65 
$115,712.65 0.05000 $482.14 $1,014.87 $532.73  $115,179.91 
$115,179.91 0.05000 $479.92 $1,014.87 $534.95  $114,644.96 
$114,644.96 0.05000 $477.69 $1,014.87 $537.18  $114,107.78 
$114,107.78 0.05000 $475.45 $1,014.87 $539.42  $113,568.36 
$113,568.36 0.05000 $473.20 $1,014.87 $541.67  $113,026.69 
$113,026.69 0.05000 $470.94 $1,014.87 $543.93  $112,482.76 
$112,482.76 0.05000 $468.68 $1,014.87 $546.19  $111,936.57 
$111,936.57 0.05000 $466.40 $1,014.87 $548.47  $111,388.10 
$111,388.10 0.05000 $464.12 $1,014.87 $550.75  $110,837.35 
$110,837.35 0.05000 $461.82 $1,014.87 $553.05  $110,284.30 
$110,284.30 0.05000 $459.52 $1,014.87 $555.35  $109,728.95 
$109,728.95 0.05000 $457.20 $1,014.87 $557.67  $109,171.28 
$109,171.28 0.05000 $454.88 $1,014.87 $559.99  $108,611.29 
$108,611.29 0.05000 $452.55 $1,014.87 $562.32  $108,048.97 
$108,048.97 0.05000 $450.20 $1,014.87 $564.67  $107,484.30 
$107,484.30 0.05000 $447.85 $1,014.87 $567.02  $106,917.29 
$106,917.29 0.05000 $445.49 $1,014.87 $569.38  $106,347.90 
$106,347.90 0.05000 $443.12 $1,014.87 $571.75  $105,776.15 
$105,776.15 0.05000 $440.73 $1,014.87 $574.14  $105,202.01 
$105,202.01 0.05000 $438.34 $1,014.87 $576.53  $104,625.49 
$104,625.49 0.05000 $435.94 $1,014.87 $578.93  $104,046.56 
$104,046.56 0.05000 $433.53 $1,014.87 $581.34  $103,465.21 
$103,465.21 0.05000 $431.11 $1,014.87 $583.76  $102,881.45 
$102,881.45 0.05000 $428.67 $1,014.87 $586.20  $102,295.25 
$102,295.25 0.05000 $426.23 $1,014.87 $588.64  $101,706.61 
$101,706.61 0.05000 $423.78 $1,014.87 $591.09  $101,115.52 
$101,115.52 0.05000 $421.31 $1,014.87 $593.56  $100,521.96 
$100,521.96 0.05000 $418.84 $1,014.87 $596.03  $ 99,925.94 
$ 99,925.94 0.05000 $416.36 $1,014.87 $598.51  $ 99,327.42 
$ 99,327.42 0.05000 $413.86 $1,014.87 $601.01  $ 98,726.42 
$ 98,726.42 0.05000 $411.36 $1,014.87 $603.51  $ 98,122.91 
$ 98,122.91 0.05000 $408.85 $1,014.87 $606.02  $ 97,516.88 
$ 97,516.88 0.05000 $406.32 $1,014.87 $608.55  $ 96,908.33 
$ 96,908.33 0.05000 $403.78 $1,014.87 $611.09  $ 96,297.25 
$ 96,297.25 0.05000 $401.24 $1,014.87 $613.63  $ 95,683.62 
$ 95,683.62 0.05000 $398.68 $1,014.87 $616.19  $ 95,067.43 
$ 95,067.43 0.05000 $396.11 $1,014.87 $618.76  $ 94,448.67 
$ 94,448.67 0.05000 $393.54 $1,014.87 $621.33  $ 93,827.34 
$ 93,827.34 0.05000 $390.95 $1,014.87 $623.92  $ 93,203.42 
$ 93,203.42 0.05000 $388.35 $1,014.87 $626.52  $ 92,576.89 
$ 92,576.89 0.05000 $385.74 $1,014.87 $629.13  $ 91,947.76 
$ 91,947.76 0.05000 $383.12 $1,014.87 $631.75  $ 91,316.01 
$ 91,316.01 0.05000 $380.48 $1,014.87 $634.39  $ 90,681.62 
$ 90,681.62 0.05000 $377.84 $1,014.87 $637.03  $ 90,044.59 
$ 90,044.59 0.05000 $375.19 $1,014.87 $639.68  $ 89,404.91 
$ 89,404.91 0.05000 $372.52 $1,014.87 $642.35  $ 88,762.56 
$ 88,762.56 0.05000 $369.84 $1,014.87 $645.03  $ 88,117.53 
$ 88,117.53 0.05000 $367.16 $1,014.87 $647.71  $ 87,469.82 
$ 87,469.82 0.05000 $364.46 $1,014.87 $650.41  $ 86,819.40 
$ 86,819.40 0.05000 $361.75 $1,014.87 $653.12  $ 86,166.28 
$ 86,166.28 0.05000 $359.03 $1,014.87 $655.84  $ 85,510.44 
$ 85,510.44 0.05000 $356.29 $1,014.87 $658.58  $ 84,851.86 
$ 84,851.86 0.05000 $353.55 $1,014.87 $661.32  $ 84,190.54 
$ 84,190.54 0.05000 $350.79 $1,014.87 $664.08  $ 83,526.46 
$ 83,526.46 0.05000 $348.03 $1,014.87 $666.84  $ 82,859.62 
$ 82,859.62 0.05000 $345.25 $1,014.87 $669.62  $ 82,190.00 
$ 82,190.00 0.05000 $342.46 $1,014.87 $672.41  $ 81,517.59 
$ 81,517.59 0.05000 $339.66 $1,014.87 $675.21  $ 80,842.37 
$ 80,842.37 0.05000 $336.84 $1,014.87 $678.03  $ 80,164.35 
$ 80,164.35 0.05000 $334.02 $1,014.87 $680.85  $ 79,483.50 
$ 79,483.50 0.05000 $331.18 $1,014.87 $683.69  $ 78,799.81 
$ 78,799.81 0.05000 $328.33 $1,014.87 $686.54  $ 78,113.27 
$ 78,113.27 0.05000 $325.47 $1,014.87 $689.40  $ 77,423.87 
$ 77,423.87 0.05000 $322.60 $1,014.87 $692.27  $ 76,731.60 
$ 76,731.60 0.05000 $319.72 $1,014.87 $695.15  $ 76,036.45 
$ 76,036.45 0.05000 $316.82 $1,014.87 $698.05  $ 75,338.39 
$ 75,338.39 0.05000 $313.91 $1,014.87 $700.96  $ 74,637.43 
$ 74,637.43 0.05000 $310.99 $1,014.87 $703.88  $ 73,933.55 
$ 73,933.55 0.05000 $308.06 $1,014.87 $706.81  $ 73,226.74 
$ 73,226.74 0.05000 $305.11 $1,014.87 $709.76  $ 72,516.98 
$ 72,516.98 0.05000 $302.15 $1,014.87 $712.72  $ 71,804.27 
$ 71,804.27 0.05000 $299.18 $1,014.87 $715.69  $ 71,088.58 
$ 71,088.58 0.05000 $296.20 $1,014.87 $718.67  $ 70,369.91 
$ 70,369.91 0.05000 $293.21 $1,014.87 $721.66  $ 69,648.25 
$ 69,648.25 0.05000 $290.20 $1,014.87 $724.67  $ 68,923.58 
$ 68,923.58 0.05000 $287.18 $1,014.87 $727.69  $ 68,195.89 
$ 68,195.89 0.05000 $284.15 $1,014.87 $730.72  $ 67,465.17 
$ 67,465.17 0.05000 $281.10 $1,014.87 $733.77  $ 66,731.41 
$ 66,731.41 0.05000 $278.05 $1,014.87 $736.82  $ 65,994.59 
$ 65,994.59 0.05000 $274.98 $1,014.87 $739.89  $ 65,254.69 
$ 65,254.69 0.05000 $271.89 $1,014.87 $742.98  $ 64,511.72 
$ 64,511.72 0.05000 $268.80 $1,014.87 $746.07  $ 63,765.65 
$ 63,765.65 0.05000 $265.69 $1,014.87 $749.18  $ 63,016.47 
$ 63,016.47 0.05000 $262.57 $1,014.87 $752.30  $ 62,264.16 
$ 62,264.16 0.05000 $259.43 $1,014.87 $755.44  $ 61,508.73 
$ 61,508.73 0.05000 $256.29 $1,014.87 $758.58  $ 60,750.15 
$ 60,750.15 0.05000 $253.13 $1,014.87 $761.74  $ 59,988.40 
$ 59,988.40 0.05000 $249.95 $1,014.87 $764.92  $ 59,223.48 
$ 59,223.48 0.05000 $246.76 $1,014.87 $768.11  $ 58,455.38 
$ 58,455.38 0.05000 $243.56 $1,014.87 $771.31  $ 57,684.07 
$ 57,684.07 0.05000 $240.35 $1,014.87 $774.52  $ 56,909.55 
$ 56,909.55 0.05000 $237.12 $1,014.87 $777.75  $ 56,131.80 
$ 56,131.80 0.05000 $233.88 $1,014.87 $780.99  $ 55,350.82 
$ 55,350.82 0.05000 $230.63 $1,014.87 $784.24  $ 54,566.58 
$ 54,566.58 0.05000 $227.36 $1,014.87 $787.51  $ 53,779.07 
$ 53,779.07 0.05000 $224.08 $1,014.87 $790.79  $ 52,988.28 
$ 52,988.28 0.05000 $220.78 $1,014.87 $794.09  $ 52,194.19 
$ 52,194.19 0.05000 $217.48 $1,014.87 $797.39  $ 51,396.80 
$ 51,396.80 0.05000 $214.15 $1,014.87 $800.72  $ 50,596.08 
$ 50,596.08 0.05000 $210.82 $1,014.87 $804.05  $ 49,792.03 
$ 49,792.03 0.05000 $207.47 $1,014.87 $807.40  $ 48,984.62 
$ 48,984.62 0.05000 $204.10 $1,014.87 $810.77  $ 48,173.86 
$ 48,173.86 0.05000 $200.72 $1,014.87 $814.15  $ 47,359.71 
$ 47,359.71 0.05000 $197.33 $1,014.87 $817.54  $ 46,542.17 
$ 46,542.17 0.05000 $193.93 $1,014.87 $820.94  $ 45,721.23 
$ 45,721.23 0.05000 $190.51 $1,014.87 $824.36  $ 44,896.86 
$ 44,896.86 0.05000 $187.07 $1,014.87 $827.80  $ 44,069.06 
$ 44,069.06 0.05000 $183.62 $1,014.87 $831.25  $ 43,237.81 
$ 43,237.81 0.05000 $180.16 $1,014.87 $834.71  $ 42,403.10 
$ 42,403.10 0.05000 $176.68 $1,014.87 $838.19  $ 41,564.91 
$ 41,564.91 0.05000 $173.19 $1,014.87 $841.68  $ 40,723.23 
$ 40,723.23 0.05000 $169.68 $1,014.87 $845.19  $ 39,878.04 
$ 39,878.04 0.05000 $166.16 $1,014.87 $848.71  $ 39,029.33 
$ 39,029.33 0.05000 $162.62 $1,014.87 $852.25  $ 38,177.08 
$ 38,177.08 0.05000 $159.07 $1,014.87 $855.80  $ 37,321.28 
$ 37,321.28 0.05000 $155.51 $1,014.87 $859.36  $ 36,461.92 
$ 36,461.92 0.05000 $151.92 $1,014.87 $862.95  $ 35,598.97 
$ 35,598.97 0.05000 $148.33 $1,014.87 $866.54  $ 34,732.43 
$ 34,732.43 0.05000 $144.72 $1,014.87 $870.15  $ 33,862.28 
$ 33,862.28 0.05000 $141.09 $1,014.87 $873.78  $ 32,988.50 
$ 32,988.50 0.05000 $137.45 $1,014.87 $877.42  $ 32,111.08 
$ 32,111.08 0.05000 $133.80 $1,014.87 $881.07  $ 31,230.01 
$ 31,230.01 0.05000 $130.13 $1,014.87 $884.74  $ 30,345.26 
$ 30,345.26 0.05000 $126.44 $1,014.87 $888.43  $ 29,456.83 
$ 29,456.83 0.05000 $122.74 $1,014.87 $892.13  $ 28,564.70 
$ 28,564.70 0.05000 $119.02 $1,014.87 $895.85  $ 27,668.85 
$ 27,668.85 0.05000 $115.29 $1,014.87 $899.58  $ 26,769.27 
$ 26,769.27 0.05000 $111.54 $1,014.87 $903.33  $ 25,865.93 
$ 25,865.93 0.05000 $107.77 $1,014.87 $907.10  $ 24,958.84 
$ 24,958.84 0.05000 $104.00 $1,014.87 $910.87  $ 24,047.96 
$ 24,047.96 0.05000 $100.20 $1,014.87 $914.67  $ 23,133.29 
$ 23,133.29 0.05000 $ 96.39 $1,014.87 $918.48  $ 22,214.81 
$ 22,214.81 0.05000 $ 92.56 $1,014.87 $922.31  $ 21,292.50 
$ 21,292.50 0.05000 $ 88.72 $1,014.87 $926.15  $ 20,366.35 
$ 20,366.35 0.05000 $ 84.86 $1,014.87 $930.01  $ 19,436.34 
$ 19,436.34 0.05000 $ 80.98 $1,014.87 $933.89  $ 18,502.46 
$ 18,502.46 0.05000 $ 77.09 $1,014.87 $937.78  $ 17,564.68 
$ 17,564.68 0.05000 $ 73.19 $1,014.87 $941.68  $ 16,623.00 
$ 16,623.00 0.05000 $ 69.26 $1,014.87 $945.61  $ 15,677.39 
$ 15,677.39 0.05000 $ 65.32 $1,014.87 $949.55  $ 14,727.84 
$ 14,727.84 0.05000 $ 61.37 $1,014.87 $953.50  $ 13,774.34 
$ 13,774.34 0.05000 $ 57.39 $1,014.87 $957.48  $ 12,816.86 
$ 12,816.86 0.05000 $ 53.40 $1,014.87 $961.47  $ 11,855.40 
$ 11,855.40 0.05000 $ 49.40 $1,014.87 $965.47  $ 10,889.92 
$ 10,889.92 0.05000 $ 45.37 $1,014.87 $969.50  $ 09,920.43 
$ 09,920.43 0.05000 $ 41.34 $1,014.87 $973.53  $ 08,946.89 
$ 08,946.89 0.05000 $ 37.28 $1,014.87 $977.59  $ 07,969.30 
$ 07,969.30 0.05000 $ 33.21 $1,014.87 $981.66  $ 06,987.64 
$ 06,987.64 0.05000 $ 29.12 $1,014.87 $985.75  $ 06,001.88 
$ 06,001.88 0.05000 $ 25.01 $1,014.87 $989.86  $ 05,012.02 
$ 05,012.02 0.05000 $ 20.88 $1,014.87 $993.99  $ 04,018.03 
$ 04,018.03 0.05000 $ 16.74 $1,014.87 $998.13  $ 03,019.91 
$ 03,019.91 0.05000 $ 12.58 $1,014.87$1,002.29 $ 02,017.62 
$ 02,017.62 0.05000 $ 08.41 $1,014.87$1,006.46 $ 01,011.16 
$ 01,011.16 0.05000 $ 04.21 $1,015.27$1,010.66 $ 00,000.00 

Hope this is easier to use.

JAFO
Print the post Back To Top
No. of Recommendations: 0
Jafo

Thanks for the reply. I understand what you have done. I just have to think about it and do some calculations to convince myself that the computed interest, summed over annual 12 month periods, is the correct amount to show on the lenders tax return as income.

Thanks again!

Terry
Print the post Back To Top
Advertisement