Solution (1)
Goal Seek to reduce the monthly payment in cell B6 to the optimal
value of $6000
The following are the data inputs in spreadsheet:
The following are the obtained results in spreadsheet:
--------------------------------------------
Solution (2) Three scenarios using Scenario
Manager. The scenarios should change the cells B7, B8, and
E6.
Good:
Most
Likely:
Bad:
Facility Amortization Table Goal Seek Status Goal Seeking with Cell B6 found a solution Step Pause Loan Details Loan 312227.318 Periodic Rate =B7/B9 # of Payments =B8*B9 Target value: 6000 Current value: $6,000.00 Payment Details Payment =PMT(E7,E8,-E6,0) APR 0.0575 Years 9 Pmts per Year 12 10 Payment Beginning Number Balance Cancel 132 14 3 =E6 =F12 =F13 =F14 =F15 =F16 =F17 =F18 Payment Amount =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =F19 17 6 18 7 19 8 20 9 21 10 22 11 23 12 24 13 25 14 26 15 27 16 28 17 29 18 30 19 31 20 32 21 33 22 34 23 35 24 2005 =F21 =F22 =F23 =F24 Principal Interest paid Repayment =$E$7*B12 =C12-D12 =$E$7*B13 =C13-D13 =$E$7*B14 =C14-D14 =$E$7*B15 =C15-D15 =$E$7*B16 =C16-D16 =$E$7*B17 =C17-D17 =$E$7*B18 =C18-D18 =$E$7*B19 =C19-D19 =$E$7*B20 =C20-D20 =$E$7*B21 =C21-D21 =$E$7*B22 =C22-D22 =$E$7*B23 =C23-D23 =$E$7*B24 =C24-D24 =SE$7*B25 =C25-D25 =$E$7*B26 =C26-D26 =$E$7*B27 =C27-D27 =$E$7*B28 =C28-D28 =$E$7*B29 =C29-029 =$E$7*B30 =C30-D30 =$E$7*B31 =C31-D31 =$E$7*B32 =C32-D32 =$E$7*B33 =C33-D33 =$E$7*B34 =C34-D34 =$E$7*B35 =C35-D35 CCD 2 CD2 Remaining Cumulativ Cumulative Balance e Interest Principal =B12-E12 =D12 =E12 =B13-E13 =D13+G12 =E13+H12 =B14-E14 =D14+G13 =E14+H13 =B15-E15 =D15+G14 =E15+H14 =B16-E16 =D16+G15 =E16+H15 =B17-E17 =D17+G16 =E17+H16 =B18-E18 =D18+G17 =E18+H17 =B19-E19 =D19+G18 =E19+H18 =B20-E20 =D20+G19 =E20+H19 =B21-E21 =D21+G20 =E21+H20 =B22-E22 =D22+G21 =E22+H21 =B23-E23 =D23+G22 =E23+H22 =B24-E24 =D 24+G23 =E24+H23 =B25-E25 =D25+G24 =E25+H24 =B26-E26 =D26+G25 =E26+H25 =B27-E27 =D27+G26 =E27+H26 =B28-E28 =D28+G27 =E28+H27 =B29-E29 =D29+G28 =E29+H28 =B30-E30 =D30+G29 =E30+H29 =B31-E31 =D31+G30 =E31+H30 =B32-E32 =D32+G31 =E32+H31 =B33-E33 =D33+G32=E33+H32 =B34-E34 =D34+G33 =E34+H33 =B35-E35 =D35+G34 =E35+H34 -D2c2 DOLCOLCO 2 =$B$6 =F26 =F27 =F28 =F29 =F30 =F31 =F32 =F33 =F34 -ros =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 Loncs
36 25 37 26 38 27 39 28 40 29 41 30 42 31 43 32 44 33 45 34 46 35 47 36 48 37 49 38 50 39 51 40 52 41 53 42 =F35 =F36 =F37 =F38 =F39 =F40 =F41 =F42 =F43 =F44 =F45 =F46 =F47 =F48 =F49 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$B$6 =$E$7*B36 =$E$7*B37 =$E$7*B38 =$E$7*B39 =$E$7*B40 =$E$7*B41 =$E$7*B42 =$E$7*B43 =$E$7*B44 =$E$7*B45 =$E$7*B46 =$E$7*B47 =$E$7*B48 =$E$7*B49 =$E$7*B50 =$E$7*B51 =$E$7*B52 =$E$7*B53 =$E$7*B54 =$E$7*B55 =$E$7*B56 =$E$7*B57 =$E$7*B58 =$E$7*B59 =$E$7*360 =$E$7*361 =$E$7*B62 =$E$7*363 =$E$7*364 =$E$7*365 =SE$7*366 =SE$7*367 =$E$7*B68 =$E$7*369 =$E$7*B70 =$E$7*B71 =B36-E36 =B37-E37 =B38-E38 =B39-E39 =B40-E40 =B41-E41 =B42-E42 =B43-E43 =B44-E44 =B45-E45 =B46-E46 =B47-E47 =B48-E48 =B49-E49 =B50-E50 =B51-E51 =B52-E52 =B53-E53 =B54-E54 =B55-E55 =B56-E56 =B57-E57 =B58-E58 =B59-E59 =B60-E60 =B61-E61 =C36-D36 =C37-D37 =C38-D38 =C39-D39 =C40-D40 =C41-D41 =C42-D42 =C43-D43 =C44-044 =C45-D45 =C46-D46 =C47-D47 =C48-D48 =C49-049 =C50-D50 =C51-D51 =C52-D52 =C53-D53 =C54-D54 =C55-D55 =C56-D56 =C57-D57 =C58-D58 =C59-D59 =C60-060 =C61-061 =C62-D62 =C63-D63 =C64-D64 =C65-D65 =C66-D66 =C67-D67 =C68-D68 =C69-D69 =C70-D70 =C71-D71 =F50 =F51 =F52 =F53 =F54 =F55 =F56 =F57 =F58 =F59 =F60 =F61 =F62 =F63 =F64 =F65 =F66 =F67 =F68 =F69 =D36+G35 =E36+H35 =D37+G36 =E37+H36 =D38+G37 =E38+H37 =D39+G38 =E39+H38 =D40+G39 =E40+H39 =D41+G40 =E41+H40 =D42+G41 =E42+H41 =D43+G42 =E43+H42 =D44+G43 =E44+H43 =D45+G44 =E45+H44 =D46+G45 =E46+H45 =D47+G46 =E47+H46 =D48+G47 =E48+H47 =D49+G48 =E49+H48 =D50+G49 1=E50+H49 =D51+G50 =E51+H50 =D52+G51 =E52+H51 =D53+G52 =E53+H52 =D54+G53 =E54+H53 =D55+G54 =E55+H54 =D56+G55 =E56+H55 =D57+G56 =E57+H56 =D58+G57 =E58+H57 =D59+G58 =E59+H58 =D60+G59 =E60+H59 =D61+G60 =E61+H60 =D62+G61 1=E62+H61 =D63+G62 =E63+H62 =D64+G63 =E64+H63 =D65+G64 =E65+H64 =D66+G65 =E66+H65 =D67+G66 =E67+H66 =D68+G67 =E68+H67 =D69+G68 =E69+H68 =D70+G69 =E70+H69 =D71+G70 =E71+H70 54 43 55 44 56 45 57 46 58 47 66 55 67 56 68 57 69 58 70 59 71 60 =B63-E63 =B64-E64 =B65-E65 =B66-E66 =B67-E67 =B68-E68 =B69-E69 =B70-E70 =B71-E71 =F70
Facility Amortization Table Goal Seek Status ? X Goal Seeking with Cell B6 found a solution. Step Pause Payment Details Payment $6,000.00 7 APR 5.75% Years 9 Pmts per Year 12 Loan Details Loan $312,227.32 Periodic Rate 0.479% # of Payments Target value: 6000 Current value: $6,000.00 8 60 OK Cancel 10 Payment Number Interest paid NMON Beginning Payment Balance Amount $312,227.32 $6,000.00 $307,723.41 $6,000.00 $303,197.92 $6,000.00 $298,650.74 $6,000.00 $294,081.77 $6,000.00 $289,490.92 $6,000.00 $284,878.06 $6,000.00 $280,243.10 $6,000.00 $275,585.93 $6,000.00 $270,906.45 $6,000.00 $266,204.54 $6,000.00 $261,480.10 $6,000.00 $256,733.03 $6,000.00 $251,963.21 $6,000.00 $247,170.53 $6,000.00 $242,354.89 $6,000.00 $237,516.18 $6,000.00 $232,654.27 $6,000.00 $227,769.08 $6,000.00 $222,860.47 $6,000.00 $217,928.34 $6,000.00 $212,972.58 $6,000.00 $207,993.08 $6,000.00 $202,989.71 $6,000.00 10107 nc227 1 .000.00 $1,496.09 $1,474.51 $1,452.82 $1,431.03 $1,409.14 $1,387.14 $1,365.04 $1,342.83 $1,320.52 $1,298.09 $1,275.56 $1,252.93 $1,230.18 $1,207.32 $1,184.36 $1,161.28 $1,138.10 $1,114.80 $1,091.39 $1,067.87 $1,044.24 $1,020.49 $996.63 $972.66 CO10 57 Principal Repayment $4,503.91 $4,525.49 $4,547.18 $4,568.97 $4,590.86 $4,612.86 $4,634.96 $4,657.17 $4,679.48 $4,701.91 $4,724.44 $4,747.07 $4,769.82 $4,792.68 $4,815.64 $4,838.72 $4,861.90 $4,885.20 $4,908.61 $4,932.13 $4,955.76 $4,979.51 $5,003.37 $5,027.34 Remaining Cumulative Cumulative Balance Interest Principal $307,723.41 $1,496.09 $4,503.91 $303,197.92 $2,970.60 $9,029.40 $298,650.74 $4,423.42 $13,576.58 $294,081.77 $5,854.46 $18,145.54 $289,490.92 $7,263.60 $22,736.40 $284,878.06 $8,650.74 $27,349.26 $280,243.10 $10,015.78 $31,984.22 $275,585.93 $11,358.61 $36,641.39 $270,906.45 $12,679.13 $41,320.87 $266,204.54 $13,977.22 $46,022.78 $261,480.10 $15,252.79 $50,747.21 $256,733.03 $16,505.71 $55,494.29 $251,963.21 $17,735.89 $60,264.11 $247,170.53 $18,943.21 $65,056.79 $242,354.89 $20,127.57 $69,872.43 $237,516.18 $21,288.86 $74,711.14 $232,654.27 $22,426.96 $79,573.04 $227,769.08 $23,541.76 $84,458.24 $222,860.47 $24,633.15 $89,366.85 $217,928.34 $25,701.02 $94,298.98 $212,972.58 $26,745.26 $99,254.74 $207,993.08 $27,765.76 $104,234.24 $202,989.71 $28,762.39 $109,237.61 $197,962.37 $29,735.05 $114,264.95 01020100 con co262 I 0110.21620 I حه_نعمت
$197,962.37 $6,000.00 $192,910.94 $6,000.00 $187,835.30 $6,000.00 $182,735.35 $6,000.00 $177,610.95 $6,000.00 $172,462.01 $6,000.00 $167,288.39 $6,000.00 $162,089.98 $6,000.00 $156,866.66 $6,000.00 $151,618.31 $6,000.00 $146,344.81 $6,000.00 $141,046.05 $6,000.00 $135,721.90 $6,000.00 $130,372.23 $6,000.00 $124,996.93 $6,000.00 $119,595.87 $6,000.00 $114,168.94 $6,000.00 $108,716.00 $6,000.00 $103,236.93 $6,000.00 $97,731.60 $6,000.00 $92,199.90 $6,000.00 $86,641.69 $6,000.00 $81,056.85 $6,000.00 $75,445.25 $6,000.00 $69,806.76 $6,000.00 $64,141.25 $6,000.00 $58,448.59 $6,000.00 $52,728.66 $6,000.00 $46,981.32 $6,000.00 $41,206.43 $6,000.00 $35,403.88 $6,000.00 $29,573.53 $6,000.00 $23,715.23 $6,000.00 $17,828.87 $6,000.00 $11,914.30 $6,000.00 $5,971.39 $6,000.00 $948.57 $924.36 $900.04 $875.61 $851.05 $826.38 $801.59 $776.68 $751.65 $726.50 $701.24 $675.85 $650.33 $624.70 $598.94 $573.06 $547.06 $520.93 $494.68 $468.30 $441.79 $415.16 $388.40 $361.51 $334.49 $307.34 $280.07 $252.66 $225.12 $197.45 $169.64 $141.71 $113.64 $85.43 $57.09 $28.61 $5,051.43 $5,075.64 $5,099.96 $5,124.39 $5,148.95 $5,173.62 $5,198.41 $5,223.32 $5,248.35 $5,273.50 $5,298.76 $5,324.15 $5,349.67 $5,375.30 $5,401.06 $5,426.94 $5,452.94 $5,479.07 $5,505.32 $5,531.70 $5,558.21 $5,584.84 $5,611.60 $5,638.49 $5,665.51 $5,692.66 $5,719.93 $5,747.34 $5,774.88 $5,802.55 $5,830.36 $5,858.29 $5,886.36 $5,914.57 $5,942.91 $5,971.39 $192,910.94 $30,683.62 $119,316.38 $187,835.30 $31,607.98 $124,392.02 $182,735.35 $32,508.03 $129,491.97 $177,610.95 $33,383.64 $134,616.36 $172,462.01 $34,234.69 $139,765.31 $167,288.39 $35,061.07 $144,938.93 $162,089.98 $35,862.66 $150,137.34 $156,866.66 $36,639.34 $155,360.66 $151,618.31 $37,390.99 $160,609.01 $146,344.81 $38,117.50 $165,882.50 $141,046.05 $38,818.73 $171,181.27 $135,721.90 $39,494.58 $176,505.42 $130,372.23 $40,144.91 $181,855.09 $124,996.93 $40,769.61 $187,230.39 $119,595.87 $41,368.56 $192,631.44 $114,168.94 $41,941.62 $198,058.38 $108,716.00 $42,488.68 $203,511.32 $103,236.93 $43,009.61 $208,990.39 $97,731.60 $43,504.29 $214,495.71 $92,199.90 $43,972.58 $220,027.42 $86,641.69 $44,414.38 $225,585.62 $81,056.85 $44,829.53 $231,170.47 $75,445.25 $45,217.93 $236,782.07 $69,806.76 $45,579.44 $242,420.56 $64,141.25 $45,913.93 $248,086.07 $58,448.59 $46,221.27 $253,778.73 $52,728.66 $46,501.34 $259,498.66 $46,981.32 $46,754.00 $265,246.00 $41,206.43 $46,979.12 $271,020.88 $35,403.88 $47,176.56 $276,823.44 $29,573.53 $47,346.21 $282,653.79 $23,715.23 $47,487.91 $288,512.09 $17,828.87 $47,601.55 $294,398.45 $11,914.30 $47,686.98 $300,313.02 $5,971.39 $47,744.07 $306,255.93 ($0.00) $47,772.68 $312,227.32
B C D G H K L M N Scenario Manager Facility Amortization Table Scenarios: Good Most Likely Bad Add... uw N- Delete Loan Details Loan $275,000.00 Periodic Rate 0.271% # of Payments 60 Payment Details 6 Payment $4,972.00 APR 3.25% 8 Years 5 9 Pmts per Year 12 Edit... Merge- 10 Summary... $B$7.$B$8.$E$6 Payment Number 1 2 Changing cells: Comment: Good 3 Show Close 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Beginning Payment Interest paid Balance Amount $275,000.00 $4,972.00 $744.79 $270,772.79 $4,972.00 $733.34 $266,534.13 $4,972.00 $721.86 $262,284.00 $4,972.00 $710.35 $258,022.35 $4,972.00 $698.81 $253,749.16 $4,972.00 $687.24 $249,464.39 $4,972.00 $675.63 $245,168.03 $4,972.00 $664.00 $240,860.02 $4,972.00 $652.33 $236,540.35 $4,972.00 $640.63 $232,208.98 $4,972.00 $628.90 $227,865.88 $4,972.00 $617.14 $223,511.02 $4,972.00 $605.34 $219,144.36 $4,972.00 $593.52 $214,765.87 $4,972.00 $581.66 $210,375.53 $4,972.00 $569.77 $205,973.30 $4,972.00 $557.84 $201,559.14 $4,972.00 $545.89 $197,133.03 $4,972.00 $533.90 $192,694.93 $4,972.00 $521.88 $188,244.81 $4,972.00 $509.83 $183,782.64 $4,972.00 $497.74 $179,308.38 $4,972.00 $485.63 $174,822.01 $4,972.00 $473.48 Principal Repayment $4,227.21 $4,238.66 $4,250.14 $4,261.65 $4,273.19 $4,284.76 $4,296.37 $4,308.00 $4,319.67 $4,331.37 $4,343.10 $4,354.86 $4,366.66 $4,378.48 $4,390.34 $4,402.23 $4,414.16 $4,426.11 $4,438.10 $4,450.12 $4,462.17 $4,474.26 $4,486.37 $4,498.52 Remaining Cumulativ Cumulativ Balance e Interest e Principal $270,772.79 $744.79 $4,227.21 $266,534.13 $1,478.13 $8,465.87 $262,284.00 $2,200.00 $12,716.00 $258,022.35 $2,910.35 $16,977.65 $253,749.16 $3,609.16 $21,250.84 $249,464.39 $4,296.40 $25,535.61 $245,168.03 $4,972.03 $29,831.97 $240,860.02 $5,636.03 $34,139.98 $236,540.35 $6,288.36 $38,459.65 $232,208.98 $6,928.99 $42,791.02 $227,865.88 $7,557.89 $47,134.12 $223,511.02 $8,175.02 $51,488.98 $219,144.36 $8,780.37 $55,855.64 $214,765.87 $9,373.88 $60,234.13 $210,375.53 $9,955.54 $64,624.47 $205,973.30 $10,525.31 $69,026.70 $201,559.14 $11,083.15 $73,440.86 $197,133.03 $11,629.04 $77,866.97 $192,694.93 $12,162.94 $82,305.07 $188,244.81 $12,684.82 $86,755.19 $183,782.64 $13,194.65 $91,217.36 $179,308.38 $13,692.40 $95,691.62 $174,822.01 $14,178.03 $100,177.99 $170,323.49 $14,651.50 $104,676.51
F G H K L M N Scenario Manager Facility Amortization Table Scenarios: Good Most likely Add Bad Delete Edit.. 8 Merge... Summary- Changing cells: $B$7,$B$8.$E$6 Comment: Most Likely Show Close 8 Payment Details Loan Details Payment $6,000.00 Loan $312,227.32 7 APR 5.75% Periodic Rate 0.479% Years 5 # of Payments 60 9 Pmts per Year 12 10 Payment Beginning Payment Principal Interest paid Number Balance Amount Repayment $312,227.32 $6,000.00 $1,496.09 $4,503.91 $307,723.41 $6,000.00 $1,474.51 $4,525.49 $303,197.92 $6,000.00 $1,452.82 $4,547.18 $298,650.74 $6,000.00 $1,431.03 $4,568.97 $294,081.78 $6,000.00 $1,409.14 $4,590.86 $289,490.92 $6,000.00 $1,387.14 $4,612.86 $284,878.06 $6,000.00 $1,365.04 $4,634.96 $280,243.10 $6,000.00 $1,342.83 $4,657.17 $275,585.93 $6,000.00 $1,320.52 $4,679.48 10 $270,906.45 $6,000.00 $1,298.09 $4,701.91 11 $266,204.54 $6,000.00 $1,275.56 $4,724.44 $261,480.11 $6,000.00 $1,252.93 $4,747.07 13 $256,733.03 $6,000.00 $1,230.18 $4,769.82 14 $251,963.21 $6,000.00 $1,207.32 $4,792.68 15 $247,170.53 $6,000.00 $1,184.36 $4,815.64 16 $242,354.89 $6,000.00 $1,161.28 $4,838.72 17 $237,516.18 $6,000.00 $1,138.10 $4,861.90 18 $232,654.27 $6,000.00 $1,114.80 $4,885.20 19 $227,769.08 $6,000.00 $1,091.39 $4,908.61 20 $222,860.47 $6,000.00 $1,067.87 $4,932.13 21 $217,928.34 $6,000.00 $1,044.24 $4,955.76 22 $212,972.58 $6,000.00 $1,020.49 $4,979.51 $207,993.08 $6,000.00 $996.63 $5,003.37 24 $202,989.71 $6,000.00 $972.66 $5,027.34 1107027 1 ec oon on NA EZ CE OLA2 12 Remaining Cumulativ Cumulativ Balance e Interest e Principal $307,723.41 $1,496.09 $4,503.91 $303,197.92 $2,970.60 $9,029.40 $298,650.74 $4,423.42 $13,576.58 $294,081.78 $5,854.46 $18,145.54 $289,490.92 $7,263.60 $22,736.40 $284,878.06 $8,650.74 $27,349.26 $280, 243.10 $10,015.78 $31,984.22 $275,585.93 $11,358.61 $36,641.39 $270,906.45 $12,679.13 $41,320.87 $266,204.54 $13,977.22 $46,022.78 $261,480.11 $15,252.79 $50,747.21 $256,733.03 $16,505.71 $55,494.29 $251,963.21 $17,735.89 $60,264.11 $247,170.53 $18,943.21 $65,056.79 $242,354.89 $20,127.57 $69,872.43 $237,516.18 $21,288.86 $74,711.14 $232,654.27 $22,426.96 $79,573.05 $227,769.08 $23,541.76 $84,458.24 $222,860.47 $24,633.15 $89,366.85 $217,928.34 $25,701.02 $94,298.98 $212,972.58 $26,745.26 $99,254.74 $207,993.08 $27,765.76 $104,234.24 $202,989.71 $28,762.39 $109,237.61 $197,962.37 $29,735.05 $114,264.95 103 10. Lenco. C110 215 21 23
ABC F G H K L MN J Scenario Manager Facility Amortization Table Scenarios Good Most Likely Add... Bad Delete Edit... 1 Merge- Summary... $B$7.$B$8,$E$6 Changing cells Comment Bad Show Close ON 8 Payment Details Loan Details Payment $10,806.98 $350,000.00 APR 7.00% Periodic Rate 0.583% Years 3 # of Payments 36 9 Pmts per Year 12 10 Payment Beginning Payment Principal Remaining Cumulativ Cumulativ Interest paid Number Balance Amount Repayment Balance e Interest e Principal $350,000.00 $10,806.98 $2,041.67 $8,765.32 $341,234.68 $2,041.67 $8,765.32 2 $341,234.68 $10,806.98 $1,990.54 $8,816.45 $332,418.23 $4,032.20 $17,581.77 3 $332,418.23 $10,806.98 $1,939.11 $8,867.88 $323,550.36 $5,971.31 $26,449.64 $323,550.36 $10,806.98 $1,887.38 $8,919.61 $314,630.75 $7,858.69 $35,369.25 $314,630.75 $10,806.98 $1,835.35 $8,971.64 $305,659.11 $9,694.03 $44,340.89 $305,659.11 $10,806.98 $1,783.01 $9,023.97 $296,635.14 $11,477.04 $53,364.86 $296,635.14 $10,806.98 $1,730.37 $9,076.61 $287,558.53 $13,207.41 $62,441.47 $287,558.53 $10,806.98 $1,677.42 $9,129.56 $278,428.97 $14,884.84 $71,571.03 $278,428.97 $10,806.98 $1,624.17 $9,182.81 $269,246.15 $16,509.01 $80,753.85 10 $269,246.15 $10,806.98 $1,570.60 $9,236.38 $260,009.77 $18,079.61 $89,990.23 11 $260,009.77 $10,806.98 $1,516.72 $9,290.26 $250,719.51 $19,596.33 $99,280.49 12 $250,719.51 $10,806.98 $1,462.53 $9,344.45 $241,375.06 $21,058.87 $108,624.94 13 $241,375.06 $10,806.98 $1,408.02 $9,398.96 $231,976.10 $22,466.89 $118,023.90 14 $231,976.10 $10,806.98 $1,353.19 $9,453.79 $222,522.31 $23,820.08 $127,477.69 15 $222,522.31 $10,806.98 $1,298.05 $9,508.94 $213,013.37 $25,118.13 $136,986.63 16 $213,013.37 $10,806.98 $1,242.58 $9,564.41 $203,448.96 $26,360.71 $146,551.04 $203,448.96 $10,806.98 $1,186.79 $9,620.20 $193,828.76 $27,547.49 $156,171.24 $193,828.76 $10,806.98 $1,130.67 $9,676.32 $184,152.45 $28,678.16 $165,847.55 19 $184,152.45 $10,806.98 $1,074.22 $9,732.76 $174,419.69 $29,752.38 $175,580.31 20 $174,419.69 $10,806.98 $1,017.45 $9,789.54 $164,630.15 $30,769.83 $185,369.85 21 $164,630.15 $10,806.98 $960.34 $9,846.64 $154,783.51 $31,730.17 $195,216.49 22 $154,783.51 $10,806.98 $902.90 $9,904.08 $144,879.43 $32,633.08 $205,120.57 23 $144,879.43 $10,806.98 $845.13 $9,961.85 $134,917.58 $33,478.21 $215,082.42 24 $134,917.58 $10,806.98 $787.02 $10,019.96 $124,897.61 $34,265.22 $225,102.39 LA 007 C1 let onc noz 10.07011101110101 1100270 la 100 on 17
Summary report: In case of Good scenario, the monthly payment will be $4, 972.00 In case of Most likely scenario, the monthly payment will be $6,000.00 In case of bad scenario, the monthly payment will be $10,806.98, the years/number of payments are also reduced in this case. Note: Only, the values have been changed in the scenario manager, the remaining values/formulas would be same in spreadsheet as in solution one. No, change at all, just the values to be changed, and the final answer of monthly payment will change.