Question

s Cut Copy Format Painter AutoSum A Fill Clear Sort & Find & Filter Select Paste в ㅣ u . .:.:·ク· · ー록三ーー圉Merge & Center· s-% , 留器 Conditional Format as Cell Insert Delete Format 1 Fomatting Table Styles Clipboard Font Alignment Cells Editing A1 Facility Amortization Table Payment Details Loan Details $6,245.45 5.75% 6 Payment 7 APR 8 Years 9 Pmts per Year 10 $325,000.00 0.479% Periodic Rate # of Payments 12 PaymentBeginning Payment Number PrincipalRemaining Cumulative Cumulative epayment Balance Balance AmountInterest PaidR Principal 12 13 15 18 20 21 10 Insurance Facilities Sales Inventory Ready + 100

1. Ensure that the Facilities worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6 to the optimal value of $6000. Complete this task by changing the Loan amount in cell E6.
2. Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6.
   Good
   B7 = .0325        B8 = 5              E6 = 275000
   Most Likely
   B7 = .0575          B8 = 5              E6 = 312227.32
   Bad
   B7 = .0700    B8 = 3      E6 = 350000
   Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately.

Answer 1

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:

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

The following are the obtained results in spreadsheet:

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

--------------------------------------------

Solution (2)  Three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6.

Good:

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

Most Likely:

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

Bad:

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.