Part 2 the three items are still in correct. 2-1 the $663.90 is correct, but the amortization table is not, which messes you up for the other questions. If you look ay Principal, you will see it is a...

1 answer below »
part 2 of the excel sheets needs corrected, I tried to fix my self but got nowhere. ive attached feedback from the professor, which is on the word doc; also putt original instructions on the same word doc, if helps.


Part 2 the three items are still in correct. 2-1 the $663.90 is correct, but the amortization table is not, which messes you up for the other questions. If you look ay Principal, you will see it is a negative, which is correct. BUT, if you look at the End. Bal. for Period 1, it is more than the mortgage amount!! Look at the formula in F12 as it shows =B12-E12. But because the Principal is a negative, you have to add the two  =B12+E12, and you will see the new balance as $139,730.57, which is the correct balance. Change it, and then copy it all the way down to Period 300, and you should end with $0.00 Now, you can start on 2-2. 2-2 is now 7%, 24 years, and starts at Period 13. I did not see your formula, but it should be: 7%/12, 24*12, and the loan amount will be the Beg. Balance at Period 13. With this now correct, 2-3 should fall into place. 2-4 is 8%/12, 22*12, and the loan amount will be the Beg. Balance at Period 13. Original questions & setup Set-up another amortization schedule, this time using a 3% 25-year mortgage. Part 2 – 1 What is the monthly payment during the first year? Part 2 – 2 What will the monthly payment be for years 2 through 25? Go to your Pmt calculation. Change the Rate to 7%, and the number of years to 24 because we are starting in year 2. Part 2 – 3 What is the percentage increase in payments from year 1 to year 2? (Year 2 Monthly Payment – Year 1 Monthly Payment) / Year 1 Monthly Payment. Then convert this to a percentage. Part 2 – 4 What will the monthly payment be for years 4 through 25? Go to your Pmt calculation. Change the Rate to 8%, and the number of years to 22 because we are starting in year 5
part-2-corrections-coxzvcxt.docx week-2-assignment-patrick-garvin-updated-0c2ct0iz.xlsx
Answered Same DayMar 31, 2021

Answer To: Part 2 the three items are still in correct. 2-1 the $663.90 is correct, but the amortization table...

Shakeel answered on Mar 31 2021
159 Votes
Original schedule
    $175,000
    4.50%
    30
    A MORTGAGE CALCULATOR:
        Payment Calc    $886.70
    Mortgage    $175,000    
    Term    30
    Month    Beg. Amt.    Pmt    Interest    Principal    End. Bal.
    1    $175,000.00    $886.70    ($656.25)    $230.45    $ 174,769.55
    2    $ 174,769.55    $886.70    ($655.39)    $231.31    $ 174,538.24
    3    $ 174,538.24    $886.70    ($654.52)    $232.18    $ 174,306.06
    4    $ 174,306.06    $886.70    ($653.65)    $233.05    $ 174,073.00
    5    $ 174,073.00    $886.70    ($652.77)    $233.93    $ 173,839.08
    6    $ 173,839.08    $886.70    ($651.90)    $234.80    $ 173,604.28
    7    $ 173,604.28    $886.70    ($651.02)    $235.68    $ 173,368.59
    8    $ 173,368.59    $886.70    ($650.13)    $236.57    $ 173,132.03
    9    $ 173,132.03    $886.70    ($649.25)    $237.45    $ 172,894.57
    10    $ 172,894.57    $886.70    ($648.35)    $238.34    $ 172,656.23
    11    $ 172,656.23    $886.70    ($647.46)    $239.24    $ 172,416.99
    12    $ 172,416.99    $886.70    ($646.56)    $240.14    $ 172,176.85
    13    $ 172,176.85    $886.70    ($645.66)    $241.04    $ 171,935.82
    14    $ 171,935.82    $886.70    ($644.76)    $241.94    $ 171,693.88
    15    $ 171,693.88    $886.70    ($643.85)    $242.85    $ 171,451.03
    16    $ 171,451.03    $886.70    ($642.94)    $243.76    $ 171,207.27
    17    $ 171,207.27    $886.70    ($642.03)    $244.67    $ 170,962.60
    18    $ 170,962.60    $886.70    ($641.11)    $245.59    $ 170,717.01
    19    $ 170,717.01    $886.70    ($640.19)    $246.51    $ 170,470.50
    20    $ 170,470.50    $886.70    ($639.26)    $247.43    $ 170,223.07
    21    $ 170,223.07    $886.70    ($638.34)    $248.36    $ 169,974.70
    22    $ 169,974.70    $886.70    ($637.41)    $249.29    $ 169,725.41
    23    $ 169,725.41    $886.70    ($636.47)    $250.23    $ 169,475.18
    24    $ 169,475.18    $886.70    ($635.53)    $251.17    $ 169,224.01
    25    $ 169,224.01    $886.70    ($634.59)    $252.11    $ 168,971.90
    26    $ 168,971.90    $886.70    ($633.64)    $253.05    $ 168,718.85
    27    $ 168,718.85    $886.70    ($632.70)    $254.00    $ 168,464.84
    28    $ 168,464.84    $886.70    ($631.74)    $254.96    $ 168,209.89
    29    $ 168,209.89    $886.70    ($630.79)    $255.91    $ 167,953.98
    30    $ 167,953.98    $886.70    ($629.83)    $256.87    $ 167,697.10
    31    $ 167,697.10    $886.70    ($628.86)    $257.84    $ 167,439.27
    32    $ 167,439.27    $886.70    ($627.90)    $258.80    $ 167,180.47
    33    $ 167,180.47    $886.70    ($626.93)    $259.77    $ 166,920.69
    34    $ 166,920.69    $886.70    ($625.95)    $260.75    $ 166,659.95
    35    $ 166,659.95    $886.70    ($624.97)    $261.72    $ 166,398.22
    36    $ 166,398.22    $886.70    ($623.99)    $262.71    $ 166,135.52
    37    $ 166,135.52    $886.70    ($623.01)    $263.69    $ 165,871.83
    38    $ 165,871.83    $886.70    ($622.02)    $264.68    $ 165,607.15
    39    $ 165,607.15    $886.70    ($621.03)    $265.67    $ 165,341.47
    40    $ 165,341.47    $886.70    ($620.03)    $266.67    $ 165,074.80
    41    $ 165,074.80    $886.70    ($619.03)    $267.67    $ 164,807.14
    42    $ 164,807.14    $886.70    ($618.03)    $268.67    $ 164,538.46
    43    $ 164,538.46    $886.70    ($617.02)    $269.68    $ 164,268.78
    44    $ 164,268.78    $886.70    ($616.01)    $270.69    $ 163,998.09
    45    $ 163,998.09    $886.70    ($614.99)    $271.71    $ 163,726.39
    46    $ 163,726.39    $886.70    ($613.97)    $272.73    $ 163,453.66
    47    $ 163,453.66    $886.70    ($612.95)    $273.75    $ 163,179.91
    48    $ 163,179.91    $886.70    ($611.92)    $274.77    $ 162,905.14
    49    $ 162,905.14    $886.70    ($610.89)    $275.81    $ 162,629.33
    50    $ 162,629.33    $886.70    ($609.86)    $276.84    $ 162,352.49
    51    $ 162,352.49    $886.70    ($608.82)    $277.88    $ 162,074.62
    52    $ 162,074.62    $886.70    ($607.78)    $278.92    $ 161,795.70
    53    $ 161,795.70    $886.70    ($606.73)    $279.97    $ 161,515.73
    54    $ 161,515.73    $886.70    ($605.68)    $281.02    $ 161,234.72
    55    $ 161,234.72    $886.70    ($604.63)    $282.07    $ 160,952.65
    56    $ 160,952.65    $886.70    ($603.57)    $283.13    $ 160,669.52
    57    $ 160,669.52    $886.70    ($602.51)    $284.19    $ 160,385.33
    58    $ 160,385.33    $886.70    ($601.44)    $285.25    $ 160,100.08
    59    $ 160,100.08    $886.70    ($600.38)    $286.32    $ 159,813.75
    60    $ 159,813.75    $886.70    ($599.30)    $287.40    $ 159,526.36
    61    $ 159,526.36    $886.70    ($598.22)    $288.48    $ 159,237.88
    62    $ 159,237.88    $886.70    ($597.14)    $289.56    $ 158,948.32
    63    $ 158,948.32    $886.70    ($596.06)    $290.64    $ 158,657.68
    64    $ 158,657.68    $886.70    ($594.97)    $291.73    $ 158,365.95
    65    $ 158,365.95    $886.70    ($593.87)    $292.83    $ 158,073.12
    66    $ 158,073.12    $886.70    ($592.77)    $293.93    $ 157,779.19
    67    $ 157,779.19    $886.70    ($591.67)    $295.03    $ 157,484.17
    68    $ 157,484.17    $886.70    ($590.57)    $296.13    $ 157,188.03
    69    $ 157,188.03    $886.70    ($589.46)    $297.24    $ 156,890.79
    70    $ 156,890.79    $886.70    ($588.34)    $298.36    $ 156,592.43
    71    $ 156,592.43    $886.70    ($587.22)    $299.48    $ 156,292.95
    72    $ 156,292.95    $886.70    ($586.10)    $300.60    $ 155,992.35
    73    $ 155,992.35    $886.70    ($584.97)    $301.73    $ 155,690.62
    74    $ 155,690.62    $886.70    ($583.84)    $302.86    $ 155,387.76
    75    $ 155,387.76    $886.70    ($582.70)    $304.00    $ 155,083.77
    76    $ 155,083.77    $886.70    ($581.56)    $305.14    $ 154,778.63
    77    $ 154,778.63    $886.70    ($580.42)    $306.28    $ 154,472.35
    78    $ 154,472.35    $886.70    ($579.27)    $307.43    $ 154,164.93
    79    $ 154,164.93    $886.70    ($578.12)    $308.58    $ 153,856.35
    80    $ 153,856.35    $886.70    ($576.96)    $309.74    $ 153,546.61
    81    $ 153,546.61    $886.70    ($575.80)    $310.90    $ 153,235.71
    82    $ 153,235.71    $886.70    ($574.63)    $312.07    $ 152,923.64
    83    $ 152,923.64    $886.70    ($573.46)    $313.24    $ 152,610.41
    84    $ 152,610.41    $886.70    ($572.29)    $314.41    $ 152,296.00
    85    $ 152,296.00    $886.70    ($571.11)    $315.59    $ 151,980.41
    86    $ 151,980.41    $886.70    ($569.93)    $316.77    $ 151,663.63
    87    $ 151,663.63    $886.70    ($568.74)    $317.96    $ 151,345.67
    88    $ 151,345.67    $886.70    ($567.55)    $319.15    $ 151,026.52
    89    $ 151,026.52    $886.70    ($566.35)    $320.35    $ 150,706.17
    90    $ 150,706.17    $886.70    ($565.15)    $321.55    $ 150,384.62
    91    $ 150,384.62    $886.70    ($563.94)    $322.76    $ 150,061.86
    92    $ 150,061.86    $886.70    ($562.73)    $323.97    $ 149,737.90
    93    $ 149,737.90    $886.70    ($561.52)    $325.18    $ 149,412.71
    94    $ 149,412.71    $886.70    ($560.30)    $326.40    $ 149,086.31
    95    $ 149,086.31    $886.70    ($559.07)    $327.63    $ 148,758.69
    96    $ 148,758.69    $886.70    ($557.85)    $328.85    $ 148,429.83    ($57,995.12)
    97    $ 143,429.83    $886.70    ($537.86)    $348.84    $ 143,080.99
    98    $ 143,080.99    $886.70    ($536.55)    $350.15    $ 142,730.85
    99    $ 142,730.85    $886.70    ($535.24)    $351.46    $ 142,379.39
    100    $ 142,379.39    $886.70    ($533.92)    $352.78    $ 142,026.61
    101    $ 142,026.61    $886.70    ($532.60)    $354.10    $ 141,672.51
    102    $ 141,672.51    $886.70    ($531.27)    $355.43    $ 141,317.09
    103    $ 141,317.09    $886.70    ($529.94)    $356.76    $ 140,960.33
    104    $ 140,960.33    $886.70    ($528.60)    $358.10    $ 140,602.23
    105    $ 140,602.23    $886.70    ($527.26)    $359.44    $ 140,242.79
    106    $ 140,242.79    $886.70    ($525.91)    $360.79    $ 139,882.00
    107    $ 139,882.00    $886.70    ($524.56)    $362.14    $ 139,519.86
    108    $ 139,519.86    $886.70    ($523.20)    $363.50    $ 139,156.36
    109    $ 139,156.36    $886.70    ($521.84)    $364.86    $ 138,791.49
    110    $ 138,791.49    $886.70    ($520.47)    $366.23    $ 138,425.26
    111    $ 138,425.26    $886.70    ($519.09)    $367.60    $ 138,057.66
    112    $ 138,057.66    $886.70    ($517.72)    $368.98    $ 137,688.68
    113    $ 137,688.68    $886.70    ($516.33)    $370.37    $ 137,318.31
    114    $ 137,318.31    $886.70    ($514.94)    $371.76    $ 136,946.55
    115    $ 136,946.55    $886.70    ($513.55)    $373.15    $ 136,573.40
    116    $ 136,573.40    $886.70    ($512.15)    $374.55    $ 136,198.85
    117    $ 136,198.85    $886.70    ($510.75)    $375.95    $ 135,822.90
    118    $ 135,822.90    $886.70    ($509.34)    $377.36    $ 135,445.54
    119    $ 135,445.54    $886.70    ($507.92)    $378.78    $ 135,066.76
    120    $ 135,066.76    $886.70    ($506.50)    $380.20    $ 134,686.56
    121    $ 134,686.56    $886.70    ($505.07)    $381.62    $ 134,304.94
    122    $ 134,304.94    $886.70    ($503.64)    $383.06    $ 133,921.88
    123    $ 133,921.88    $886.70    ($502.21)    $384.49    $ 133,537.39
    124    $ 133,537.39    $886.70    ($500.77)    $385.93    $ 133,151.45
    125    $ 133,151.45    $886.70    ($499.32)    $387.38    $ 132,764.07
    126    $ 132,764.07    $886.70    ($497.87)    $388.83    $ 132,375.24
    127    $ 132,375.24    $886.70    ($496.41)    $390.29    $ 131,984.95
    128    $ 131,984.95    $886.70    ($494.94)    $391.76    $ 131,593.19
    129    $ 131,593.19    $886.70    ($493.47)    $393.22    $ 131,199.97
    130    $ 131,199.97    $886.70    ($492.00)    $394.70    $ 130,805.27
    131    $ 130,805.27    $886.70    ($490.52)    $396.18    $ 130,409.09
    132    $ 130,409.09    $886.70    ($489.03)    $397.67    $ 130,011.42
    133    $ 130,011.42    $886.70    ($487.54)    $399.16    $ 129,612.26
    134    $ 129,612.26    $886.70    ($486.05)    $400.65    $ 129,211.61
    135    $ 129,211.61    $886.70    ($484.54)    $402.16    $ 128,809.46
    136    $ 128,809.46    $886.70    ($483.04)    $403.66    $ 128,405.79
    137    $ 128,405.79    $886.70    ($481.52)    $405.18    $ 128,000.61
    138    $ 128,000.61    $886.70    ($480.00)    $406.70    $ 127,593.92
    139    $ 127,593.92    $886.70    ($478.48)    $408.22    $ 127,185.70
    140    $ 127,185.70    $886.70    ($476.95)    $409.75    $ 126,775.94
    141    $ 126,775.94    $886.70    ($475.41)    $411.29    $ 126,364.65
    142    $ 126,364.65    $886.70    ($473.87)    $412.83    $ 125,951.82
    143    $ 125,951.82    $886.70    ($472.32)    $414.38    $ 125,537.44
    144    $ 125,537.44    $886.70    ($470.77)    $415.93    $ 125,121.51
    145    $ 125,121.51    $886.70    ($469.21)    $417.49    $ 124,704.01
    146    $ 124,704.01    $886.70    ($467.64)    $419.06    $ 124,284.95
    147    $ 124,284.95    $886.70    ($466.07)    $420.63    $ 123,864.32
    148    $ 123,864.32    $886.70    ($464.49)    $422.21    $ 123,442.12
    149    $ 123,442.12    $886.70    ($462.91)    $423.79    $ 123,018.32
    150    $ 123,018.32    $886.70    ($461.32)    $425.38    $ 122,592.94
    151    $ 122,592.94    $886.70    ($459.72)    $426.98    $ 122,165.97
    152    $ 122,165.97    $886.70    ($458.12)    $428.58    $ 121,737.39
    153    $ 121,737.39    $886.70    ($456.52)    $430.18    $ 121,307.21
    154    $ 121,307.21    $886.70    ($454.90)    $431.80    $ 120,875.41
    155    $ 120,875.41    $886.70    ($453.28)    $433.42    $ 120,441.99
    156    $ 120,441.99    $886.70    ($451.66)    $435.04    $ 120,006.95
    157    $ 120,006.95    $886.70    ($450.03)    $436.67    $ 119,570.28
    158    $ 119,570.28    $886.70    ($448.39)    $438.31    $ 119,131.97
    159    $ 119,131.97    $886.70    ($446.74)    $439.95    $ 118,692.01
    160    $ 118,692.01    $886.70    ($445.10)    $441.60    $ 118,250.41
    161    $ 118,250.41    $886.70    ($443.44)    $443.26    $ 117,807.15
    162    $ 117,807.15    $886.70    ($441.78)    $444.92    $ 117,362.23
    163    $ 117,362.23    $886.70    ($440.11)    $446.59    $ 116,915.63
    164    $ 116,915.63    $886.70    ($438.43)    $448.27    $ 116,467.37
    165    $ 116,467.37    $886.70    ($436.75)    $449.95    $ 116,017.42
    166    $ 116,017.42    $886.70    ($435.07)    $451.63    $ 115,565.79
    167    $ 115,565.79    $886.70    ($433.37)    $453.33    $ 115,112.46
    168    $ 115,112.46    $886.70    ($431.67)    $455.03    $ 114,657.43
    169    $ 114,657.43    $886.70    ($429.97)    $456.73    $ 114,200.70
    170    $ 114,200.70    $886.70    ($428.25)    $458.45    $ 113,742.25
    171    $ 113,742.25    $886.70    ($426.53)    $460.17    $ 113,282.09
    172    $ 113,282.09    $886.70    ($424.81)    $461.89    $ 112,820.20
    173    $ 112,820.20    $886.70    ($423.08)    $463.62    $ 112,356.57
    174    $ 112,356.57    $886.70    ($421.34)    $465.36    $ 111,891.21
    175    $ 111,891.21    $886.70    ($419.59)    $467.11    $ 111,424.10
    176    $ 111,424.10    $886.70    ($417.84)    $468.86    $ 110,955.24
    177    $ 110,955.24    $886.70    ($416.08)    $470.62    $ 110,484.63
    178    $ 110,484.63    $886.70    ($414.32)    $472.38    $ 110,012.24
    179    $ 110,012.24    $886.70    ($412.55)    $474.15    $ 109,538.09
    180    $ 109,538.09    $886.70    ($410.77)    $475.93    $ 109,062.16
    181    $ 109,062.16    $886.70    ($408.98)    $477.72    $ 108,584.44
    182    $ 108,584.44    $886.70    ($407.19)    $479.51    $ 108,104.94
    183    $ 108,104.94    $886.70    ($405.39)    $481.31    $ 107,623.63
    184    $ 107,623.63    $886.70    ($403.59)    $483.11    $ 107,140.52
    185    $ 107,140.52    $886.70    ($401.78)    $484.92    $ 106,655.60
    186    $ 106,655.60    $886.70    ($399.96)    $486.74    $ 106,168.86
    187    $ 106,168.86    $886.70    ($398.13)    $488.57    $ 105,680.29
    188    $ 105,680.29    $886.70    ($396.30)    $490.40    $ 105,189.89
    189    $ 105,189.89    $886.70    ($394.46)    $492.24    $ 104,697.65
    190    $ 104,697.65    $886.70    ($392.62)    $494.08    $ 104,203.57
    191    $ 104,203.57    $886.70    ($390.76)    $495.94    $ 103,707.64
    192    $ 103,707.64    $886.70    ($388.90)    $497.80    $ 103,209.84
    193    $ 103,209.84    $886.70    ($387.04)    $499.66    $ 102,710.18
    194    $ 102,710.18    $886.70    ($385.16)    $501.54    $ 102,208.64
    195    $ 102,208.64    $886.70    ($383.28)    $503.42    $ 101,705.22
    196    $ 101,705.22    $886.70    ($381.39)    $505.30    $ 101,199.92
    197    $ 101,199.92    $886.70    ($379.50)    $507.20    $ 100,692.72
    198    $ 100,692.72    $886.70    ($377.60)    $509.10    $ 100,183.62
    199    $ 100,183.62    $886.70    ($375.69)    $511.01    $ 99,672.61
    200    $ 99,672.61    $886.70    ($373.77)    $512.93    $ 99,159.68
    201    $ 99,159.68    $886.70    ($371.85)    $514.85    $ 98,644.83
    202    $ 98,644.83    $886.70    ($369.92)    $516.78    $ 98,128.05
    203    $ 98,128.05    $886.70    ($367.98)    $518.72    $ 97,609.33
    204    $ 97,609.33    $886.70    ($366.03)    $520.66    $ 97,088.67
    205    $ 97,088.67    $886.70    ($364.08)    $522.62    $ 96,566.05
    206    $ 96,566.05    $886.70    ($362.12)    $524.58    $ 96,041.47
    207    $ 96,041.47    $886.70    ($360.16)    $526.54    $ 95,514.93
    208    $ 95,514.93    $886.70    ($358.18)    $528.52    $ 94,986.41
    209    $ 94,986.41    $886.70    ($356.20)    $530.50    $ 94,455.91
    210    $ 94,455.91    $886.70    ($354.21)    $532.49    $ 93,923.42
    211    $ 93,923.42    $886.70    ($352.21)    $534.49    $ 93,388.93
    212    $ 93,388.93    $886.70    ($350.21)    $536.49    $ 92,852.44
    213    $ 92,852.44    $886.70    ($348.20)    $538.50    $ 92,313.94
    214    $ 92,313.94    $886.70    ($346.18)    $540.52    $ 91,773.42
    215    $ 91,773.42    $886.70    ($344.15)    $542.55    $ 91,230.87
    216    $ 91,230.87    $886.70    ($342.12)    $544.58    $ 90,686.29
    217    $ 90,686.29    $886.70    ($340.07)    $546.63    $ 90,139.66
    218    $ 90,139.66    $886.70    ($338.02)    $548.68    $ 89,590.99
    219    $ 89,590.99    $886.70    ($335.97)    $550.73    $ 89,040.25
    220    $ 89,040.25    $886.70    ($333.90)    $552.80    $ 88,487.45
    221    $ 88,487.45    $886.70    ($331.83)    $554.87    $ 87,932.58
    222    $ 87,932.58    $886.70    ($329.75)    $556.95    $ 87,375.63
    223    $ 87,375.63    $886.70    ($327.66)    $559.04    $ 86,816.59
    224    $ 86,816.59    $886.70    ($325.56)    $561.14    $ 86,255.45
    225    $ 86,255.45    $886.70    ($323.46)    $563.24    $ 85,692.21
    226    $ 85,692.21    $886.70    ($321.35)    $565.35    $ 85,126.86
    227    $ 85,126.86    $886.70    ($319.23)    $567.47    $ 84,559.38
    228    $ 84,559.38    $886.70    ($317.10)    $569.60    $ 83,989.78
    229    $ 83,989.78    $886.70    ($314.96)    $571.74    $ 83,418.04
    230    $ 83,418.04    $886.70    ($312.82)    $573.88    $ 82,844.16
    231    $ 82,844.16    $886.70    ($310.67)    $576.03    $ 82,268.13
    232    $ 82,268.13    $886.70    ($308.51)    $578.19    $ 81,689.94
    233    $ 81,689.94    $886.70    ($306.34)    $580.36    $ 81,109.57
    234    $ 81,109.57    $886.70    ($304.16)    $582.54    $ 80,527.04
    235    $ 80,527.04    $886.70    ($301.98)    $584.72    $ 79,942.31
    236    $ 79,942.31    $886.70    ($299.78)    $586.92    $ 79,355.40
    237    $ 79,355.40    $886.70    ($297.58)    $589.12    $ 78,766.28
    238    $ 78,766.28    $886.70    ($295.37)    $591.33    $ 78,174.95
    239    $ 78,174.95    $886.70    ($293.16)    $593.54    $ 77,581.41
    240    $ 77,581.41    $886.70    ($290.93)    $595.77    $ 76,985.64
    241    $ 76,985.64    $886.70    ($288.70)    $598.00    $ 76,387.64
    242    $ 76,387.64    $886.70    ($286.45)    $600.25    $ 75,787.39
    243    $ 75,787.39    $886.70    ($284.20)    $602.50    $ 75,184.90
    244    $ 75,184.90    $886.70    ($281.94)    $604.76    $ 74,580.14
    245    $ 74,580.14    $886.70    ($279.68)    $607.02    $ 73,973.12
    246    $ 73,973.12    $886.70    ($277.40)    $609.30    $ 73,363.82
    247    $ 73,363.82    $886.70    ($275.11)    $611.58    $ 72,752.23
    248    $ 72,752.23    $886.70    ($272.82)    $613.88    $ 72,138.35
    249    $ 72,138.35    $886.70    ($270.52)    $616.18    $ 71,522.17
    250    $ 71,522.17    $886.70    ($268.21)    $618.49    $ 70,903.68
    251    $ 70,903.68    $886.70    ($265.89)    $620.81    $ 70,282.87
    252    $ 70,282.87    $886.70    ($263.56)    $623.14    $ 69,659.73
    253    $ 69,659.73    $886.70    ($261.22)    $625.48    $ 69,034.26
    254    $ 69,034.26    $886.70    ($258.88)    $627.82    $ 68,406.44
    255    $ 68,406.44    $886.70    ($256.52)    $630.18    $ 67,776.26
    256    $ 67,776.26    $886.70    ($254.16)    $632.54    $ 67,143.72
    257    $ 67,143.72    $886.70    ($251.79)    $634.91    $ 66,508.81
    258    $ 66,508.81    $886.70    ($249.41)    $637.29    $ 65,871.52
    259    $ 65,871.52    $886.70    ($247.02)    $639.68    $ 65,231.84
    260    $ 65,231.84    $886.70    ($244.62)    $642.08    $ 64,589.76
    261    $ 64,589.76    $886.70    ($242.21)    $644.49    $ 63,945.27
    262    $ 63,945.27    $886.70    ($239.79)    $646.90    $ 63,298.37
    263    $ 63,298.37    $886.70    ($237.37)    $649.33    $ 62,649.04
    264    $ 62,649.04    $886.70    ($234.93)    $651.77    $ 61,997.27
    265    $ 61,997.27    $886.70    ($232.49)    $654.21    $ 61,343.06
    266    $ 61,343.06    $886.70    ($230.04)    $656.66    $ 60,686.40
    267    $ 60,686.40    $886.70    ($227.57)    $659.13    $ 60,027.28
    268    $ 60,027.28    $886.70    ($225.10)    $661.60    $ 59,365.68
    269    $ 59,365.68    $886.70    ($222.62)    $664.08    $ 58,701.60
    270    $ 58,701.60    $886.70    ($220.13)    $666.57    $ 58,035.03
    271    $ 58,035.03    $886.70    ($217.63)    $669.07    $ 57,365.96
    272    $ 57,365.96    $886.70    ($215.12)    $671.58    $ 56,694.39
    273    $ 56,694.39    $886.70    ($212.60)    $674.10    $ 56,020.29
    274    $ 56,020.29    $886.70    ($210.08)    $676.62    $ 55,343.67
    275    $ 55,343.67    $886.70    ($207.54)    $679.16    $ 54,664.51
    276    $ 54,664.51    $886.70    ($204.99)    $681.71    $ 53,982.80
    277    $ 53,982.80    $886.70    ($202.44)    $684.26    $ 53,298.54
    278    $ 53,298.54    $886.70    ($199.87)    $686.83    $ 52,611.71
    279    $ 52,611.71    $886.70    ($197.29)    $689.41    $ 51,922.30
    280    $ 51,922.30    $886.70    ($194.71)    $691.99    $ 51,230.31
    281    $ 51,230.31    $886.70    ($192.11)    $694.59    $ 50,535.73
    282    $ 50,535.73    $886.70    ($189.51)    $697.19    $ 49,838.54
    283    $ 49,838.54    $886.70    ($186.89)    $699.80    $ 49,138.73
    284    $ 49,138.73    $886.70    ($184.27)    $702.43    $ 48,436.30
    285    $ 48,436.30    $886.70    ($181.64)    $705.06    $ 47,731.24
    286    $ 47,731.24    $886.70    ($178.99)    $707.71    $ 47,023.53
    287    $ 47,023.53    $886.70    ($176.34)    $710.36    $ 46,313.17
    288    $ 46,313.17    $886.70    ($173.67)    $713.02    $ 45,600.15
    289    $ 45,600.15    $886.70    ($171.00)    $715.70    $ 44,884.45
    290    $ 44,884.45    $886.70    ($168.32)    $718.38    $ 44,166.06
    291    $ 44,166.06    $886.70    ($165.62)    $721.08    $ 43,444.99
    292    $ 43,444.99    $886.70    ($162.92)    $723.78    $ 42,721.21
    293    $ 42,721.21    $886.70    ($160.20)    $726.49    $ 41,994.71
    294    $ 41,994.71    $886.70    ($157.48)    $729.22    $ 41,265.49
    295    $ 41,265.49    $886.70    ($154.75)    $731.95    $ 40,533.54
    296    $ 40,533.54    $886.70    ($152.00)    $734.70    $ 39,798.84
    297    $ 39,798.84    $886.70    ($149.25)    $737.45    $ 39,061.39
    298    $ 39,061.39    $886.70    ($146.48)    $740.22    $ 38,321.17
    299    $ 38,321.17    $886.70    ($143.70)    $742.99    $ 37,578.17
    300    $ 37,578.17    $886.70    ($140.92)    $745.78    $ 36,832.39
    301    $ 36,832.39    $886.70    ($138.12)    $748.58    $ 36,083.81
    302    $ 36,083.81    $886.70    ($135.31)    $751.38    $ 35,332.43
    303    $ 35,332.43    $886.70    ($132.50)    $754.20    $ 34,578.23
    304    $ 34,578.23    $886.70    ($129.67)    $757.03    $ 33,821.20
    305    $ 33,821.20    $886.70    ($126.83)    $759.87    $ 33,061.33
    306    $ 33,061.33    $886.70    ($123.98)    $762.72    $ 32,298.61
    307    $ 32,298.61    $886.70    ($121.12)    $765.58    $ 31,533.03
    308    $ 31,533.03    $886.70    ($118.25)    $768.45    $ 30,764.58
    309    $ 30,764.58    $886.70    ($115.37)    $771.33    $ 29,993.24
    310    $ 29,993.24    $886.70    ($112.47)    $774.22    $ 29,219.02
    311    $ 29,219.02    $886.70    ($109.57)    $777.13    $ 28,441.89
    312    $ 28,441.89    $886.70    ($106.66)    $780.04    $ 27,661.85
    313    $ 27,661.85    $886.70    ($103.73)    $782.97    $ 26,878.88
    314    $ 26,878.88    $886.70    ($100.80)    $785.90    $ 26,092.98
    315    $ 26,092.98    $886.70    ($97.85)    $788.85    $ 25,304.13
    316    $ 25,304.13    $886.70    ($94.89)    $791.81    $ 24,512.32
    317    $ 24,512.32    $886.70    ($91.92)    $794.78    $ 23,717.54
    318    $ 23,717.54    $886.70    ($88.94)    $797.76    $ 22,919.78
    319    $ 22,919.78    $886.70    ($85.95)    $800.75    $ 22,119.03
    320    $ 22,119.03    $886.70    ($82.95)    $803.75    $ 21,315.28
    321    $ 21,315.28    $886.70    ($79.93)    $806.77    $ 20,508.51
    322    $ 20,508.51    $886.70    ($76.91)    $809.79    $ 19,698.72
    323    $ 19,698.72    $886.70    ($73.87)    $812.83    $ 18,885.89
    324    $ 18,885.89    $886.70    ($70.82)    $815.88    $ 18,070.01
    325    $ 18,070.01    $886.70    ($67.76)    $818.94    $ 17,251.08
    326    $ 17,251.08    $886.70    ($64.69)    $822.01    $ 16,429.07
    327    $ 16,429.07    $886.70    ($61.61)    $825.09    $ 15,603.98
    328    $ 15,603.98    $886.70    ($58.51)    $828.18    $ 14,775.79
    329    $ 14,775.79    $886.70    ($55.41)    $831.29    $ 13,944.50
    330    $ 13,944.50    $886.70    ($52.29)    $834.41    $ 13,110.10
    331    $ 13,110.10    $886.70    ($49.16)    $837.54    $ 12,272.56
    332    $ 12,272.56    $886.70    ($46.02)    $840.68    $ 11,431.88
    333    $ 11,431.88    $886.70    ($42.87)    $843.83    $ 10,588.05
    334    $ 10,588.05    $886.70    ($39.71)    $846.99    $ 9,741.06
    335    $ 9,741.06    $886.70    ($36.53)    $850.17    $ 8,890.89
    336    $ 8,890.89    $886.70    ($33.34)    $853.36    $ 8,037.53
    337    $ 8,037.53    $886.70    ($30.14)    $856.56    $ 7,180.97
    338    $ 7,180.97    $886.70    ($26.93)    $859.77    $ 6,321.20
    339    $ 6,321.20    $886.70    ($23.70)    $862.99    $ 5,458.21
    340    $ 5,458.21    $886.70    ($20.47)    $866.23    $ 4,591.98
    341    $ 4,591.98    $886.70    ($17.22)    $869.48    $ 3,722.50
    342    $ 3,722.50    $886.70    ($13.96)    $872.74    $ 2,849.76
    343    $ 2,849.76    $886.70    ($10.69)    $876.01    $ 1,973.74                                        3.92    15.3664    0.2134222222
    344    $ 1,973.74    $886.70    ($7.40)    $879.30    $ 1,094.45                                                768.32
    345    $ 1,094.45    $886.70    ($4.10)    $882.60    $ 211.85
    346    $ 211.85    $886.70    ($0.79)    $885.90    $ (674.05)
    347    $ (674.05)    $886.70    $2.53    $889.23    $ (1,563.28)
    348    $ (1,563.28)    $886.70    $5.86    $892.56    $ (2,455.84)
    349    $ (2,455.84)    $886.70    $9.21    $895.91    $ (3,351.75)
    350    $ (3,351.75)    $886.70    $12.57    $899.27    $ (4,251.02)
    351    $ (4,251.02)    $886.70    $15.94    $902.64    $ (5,153.66)
    352    $ (5,153.66)    $886.70    $19.33    $906.03    $ (6,059.69)
    353    $ (6,059.69)    $886.70    $22.72    $909.42    $ (6,969.11)
    354    $ (6,969.11)    $886.70    $26.13    $912.83    $ (7,881.94)
    355    $ (7,881.94)    $886.70    $29.56    $916.26    $ (8,798.20)
    356    $ (8,798.20)    $886.70    $32.99    $919.69    $ (9,717.89)
    357    $ (9,717.89)    $886.70    $36.44    $923.14    $ (10,641.03)
    358    $ (10,641.03)    $886.70    $39.90    $926.60    $ (11,567.64)
    359    $ (11,567.64)    $886.70    $43.38    $930.08    $ (12,497.71)
    360    $ (12,497.71)    $886.70    $46.87    $933.57    $ (13,431.28)
        Part 1-2    $318,325.05    ($135,124.22)
        Part 1-3    $ 151,663.63
        Part 1-3A
        Part 1-3B    ($57,995.12)
Part 2
    $140,000.00                            $136,181.02                            $129,095.69
    3.00%                            7.00%                            8.00%
    25                            24                            22
    A MORTGAGE CALCULATOR:                            A MORTGAGE CALCULATOR:                            A MORTGAGE CALCULATOR:
        Payment Calc    $663.90                        Payment Calc    $977.45                        Payment Calc    $1,040.74
    Mortgage    $140,000.00                         Mortgage    $136,181.02                         Mortgage    $129,095.69    
    Term    25                        Term    24                        Term    22
    Month    Beg. Amt.    Pmt    Interest    Principal    End. Bal.        Month    Beg. Amt.    Pmt    Interest    Principal    End. Bal.        Month    Beg. Amt.    Pmt    Interest    Principal    End. Bal.
    1    $140,000.00    $663.90    $350.00    $313.90    $139,686.10        1    $136,181.02    $977.45    $794.39    $183.06    $135,997.96        1    $129,095.69    $1,040.74    $860.64    $180.10    $128,915.59
    2    $ 139,686.10    $663.90    $349.22    $314.68    $139,371.42        2    $ 135,997.96    $977.45    $793.32    $184.13    $135,813.83        2    $ 128,915.59    $1,040.74    $859.44    $181.30    $128,734.29
    3    $ 139,371.42    $663.90    $348.43    $315.47    $139,055.96        3    $ 135,813.83    $977.45    $792.25    $185.21    $135,628.62        3    $ 128,734.29    $1,040.74    $858.23    $182.51    $128,551.77
    4    $ 139,055.96    $663.90    $347.64    $316.26    $138,739.70        4    $ 135,628.62    $977.45    $791.17    $186.29    $135,442.34        4    $ 128,551.77    $1,040.74    $857.01    $183.73    $128,368.04
    5    $ 138,739.70    $663.90    $346.85    $317.05    $138,422.65        5    $ 135,442.34    $977.45    $790.08    $187.37    $135,254.97        5    $ 128,368.04    $1,040.74    $855.79    $184.95    $128,183.09
    6    $ 138,422.65    $663.90    $346.06    $317.84    $138,104.81        6    $ 135,254.97    $977.45    $788.99    $188.47    $135,066.50        6    $ 128,183.09    $1,040.74    $854.55    $186.19    $127,996.90
    7    $ 138,104.81    $663.90    $345.26    $318.63    $137,786.18        7    $ 135,066.50    $977.45    $787.89    $189.56    $134,876.94        7    $ 127,996.90    $1,040.74    $853.31    $187.43    $127,809.47
    8    $ 137,786.18    $663.90    $344.47    $319.43    $137,466.75        8    $ 134,876.94    $977.45    $786.78    $190.67    $134,686.27        8    $ 127,809.47    $1,040.74    $852.06    $188.68    $127,620.80
    9    $ 137,466.75    $663.90    $343.67    $320.23    $137,146.52        9    $ 134,686.27    $977.45    $785.67    $191.78    $134,494.48        9    $ 127,620.80    $1,040.74    $850.81    $189.94    $127,430.86
    10    $ 137,146.52    $663.90    $342.87    $321.03    $136,825.49        10    $ 134,494.48    $977.45    $784.55    $192.90    $134,301.58        10    $ 127,430.86    $1,040.74    $849.54    $191.20    $127,239.66
    11    $ 136,825.49    $663.90    $342.06    $321.83    $136,503.66        11    $ 134,301.58    $977.45    $783.43    $194.03    $134,107.56        11    $ 127,239.66    $1,040.74    $848.26    $192.48    $127,047.18
    12    $ 136,503.66    $663.90    $341.26    $322.64    $136,181.02        12    $ 134,107.56    $977.45    $782.29    $195.16    $133,912.40        12    $ 127,047.18    $1,040.74    $846.98    $193.76    $126,853.42
    13    $ 136,181.02    $663.90    $340.45    $323.44    $135,857.58        13    $ 133,912.40    $977.45    $781.16    $196.30    $133,716.10        13    $ 126,853.42    $1,040.74    $845.69    $195.05    $126,658.37
    14    $ 135,857.58    $663.90    $339.64    $324.25    $135,533.33        14    $ 133,716.10    $977.45    $780.01    $197.44    $133,518.66        14    $ 126,658.37    $1,040.74    $844.39    $196.35    $126,462.02
    15    $ 135,533.33    $663.90    $338.83    $325.06    $135,208.27        15    $ 133,518.66    $977.45    $778.86    $198.59    $133,320.07        15    $ 126,462.02    $1,040.74    $843.08    $197.66    $126,264.36
    16    $ 135,208.27    $663.90    $338.02    $325.88    $134,882.39        16    $ 133,320.07    $977.45    $777.70    $199.75    $133,120.31        16    $ 126,264.36    $1,040.74    $841.76    $198.98    $126,065.38
    17    $ 134,882.39    $663.90    $337.21    $326.69    $134,555.70        17    $ 133,120.31    $977.45    $776.54    $200.92    $132,919.40        17    $ 126,065.38    $1,040.74    $840.44    $200.31    $125,865.07
    18    $ 134,555.70    $663.90    $336.39    $327.51    $134,228.19        18    $ 132,919.40    $977.45    $775.36    $202.09    $132,717.31        18    $ 125,865.07    $1,040.74    $839.10    $201.64    $125,663.43
    19    $ 134,228.19    $663.90    $335.57    $328.33    $133,899.87        19    $ 132,717.31    $977.45    $774.18    $203.27    $132,514.04        19    $ 125,663.43    $1,040.74    $837.76    $202.98    $125,460.45
    20    $ 133,899.87    $663.90    $334.75    $329.15    $133,570.72        20    $ 132,514.04    $977.45    $773.00    $204.45    $132,309.59        20    $ 125,460.45    $1,040.74    $836.40    $204.34    $125,256.11
    21    $ 133,570.72    $663.90    $333.93    $329.97    $133,240.75        21    $ 132,309.59    $977.45    $771.81    $205.65    $132,103.94        21    $ 125,256.11    $1,040.74    $835.04    $205.70    $125,050.41
    22    $ 133,240.75    $663.90    $333.10    $330.79    $132,909.96        22    $ 132,103.94    $977.45    $770.61    $206.85    $131,897.09        22    $ 125,050.41    $1,040.74    $833.67    $207.07    $124,843.34
    23    $ 132,909.96    $663.90    $332.27    $331.62    $132,578.34        23    $ 131,897.09    $977.45    $769.40    $208.05    $131,689.04        23    $ 124,843.34    $1,040.74    $832.29    $208.45    $124,634.89
    24    $ 132,578.34    $663.90    $331.45    $332.45    $132,245.89        24    $ 131,689.04    $977.45    $768.19    $209.27    $131,479.78        24    $ 124,634.89    $1,040.74    $830.90    $209.84    $124,425.05
    25    $ 132,245.89    $663.90    $330.61    $333.28    $131,912.61        25    $ 131,479.78    $977.45    $766.97    $210.49    $131,269.29        25    $ 124,425.05    $1,040.74    $829.50    $211.24    $124,213.81
    26    $ 131,912.61    $663.90    $329.78    $334.11    $131,578.49        26    $ 131,269.29    $977.45    $765.74    $211.71    $131,057.57        26    $ 124,213.81    $1,040.74    $828.09    $212.65    $124,001.16
    27    $ 131,578.49    $663.90    $328.95    $334.95    $131,243.54        27    $ 131,057.57    $977.45    $764.50    $212.95    $130,844.62        27    $ 124,001.16    $1,040.74    $826.67    $214.07    $123,787.09
    28    $ 131,243.54    $663.90    $328.11    $335.79    $130,907.76        28    $ 130,844.62    $977.45    $763.26    $214.19    $130,630.43        28    $ 123,787.09    $1,040.74    $825.25    $215.49    $123,571.60
    29    $ 130,907.76    $663.90    $327.27    $336.63    $130,571.13        29    $ 130,630.43    $977.45    $762.01    $215.44    $130,414.99        29    $ 123,571.60    $1,040.74    $823.81    $216.93    $123,354.67
    30    $ 130,571.13    $663.90    $326.43    $337.47    $130,233.66        30    $ 130,414.99    $977.45    $760.75    $216.70    $130,198.29        30    $ 123,354.67    $1,040.74    $822.36    $218.38    $123,136.29
    31    $ 130,233.66    $663.90    $325.58    $338.31    $129,895.35        31    $ ...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?