Question

1 Approved Answer

Posted on Jul 26, 2024

Download A Alternativ class. You must provide me with an Excel file that has 4 tabs. You may use the CH 17 Excel file as

Download A Alternativ class. You must provide me with an Excel file that has 4 tabs. You may use the CH 17 Excel file as a basis for the file that you e-mail to me. The file should be e-mailed by midnight on Friday, 9/24/14. Below are the 4 types of mortgages you need to build in Excel. 1) On the first tab build the full amortization table for a 30 year Interest Only (10) Loan with a 5.5% interest rate compounded monthly. The initial loan amount should be $5,000,000. 2) On the second tab build the full amortization table for a 15 year Constant Amortizing Mortgage (CAM) Loan with a 6% interest rate compounded monthly. The initial loan amount should be $7,500,000 3) On the third tab build the full amortization table for a 30 year Constant Payment Mortgage (CPM) Loan with a 4.5% interest rate compounded monthly. The initial loan amount should be $2,500,000 4) On the fourth tab build the full amortization table for a 30 year Graduated Payment Mortgage (GPM) Loan with a 6.5% interest rate compounded monthly. The initial loan amount should be $1,500,000. There should be 2 step ups, each a 10% increase. One every 2 years with the 1st through 24th, 25th through 48th, and 49th through 360th payments being the same amount respectively Excel File Edit Format Tools Data Window Help View Insert ROES AutoSave OFF CH 17 - Loan Amortization Examples Home Insert Draw Page Layout Formulas Data Review View Tell me Arial B 29 Wrap Text Currency ' A Paste B I Merge & Center E4 fx --B$6 D E F G 1 J Month Rule 34 OLB Bel PMT Rulet INT Rule 2 AMORT Se 9 2 3 4 S 6 7 14000 12000 10000 MOOD B 1 Interest-Only Mortgage 2 trepte 12 30 12.00% $1,000,000.00 pot 510.000.00 7 f 151.000.000 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 6000 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 0.00 50.00 $0.00 10.00 $0.00 $0.00 $9.00 $0.00 9 10 11 12 13 14 15 16 17 * 19 4000 2000 $10.000.00 $10.000.00 $1000000 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10.000.00 $10,000.00 $19,000.00 $10.00000 510.00000 $10.000.00 $10.000,00 $10.000.00 $10.000.00 $10,000.00 $10,000.00 310,000.00 $10.000.00 $50,000.00 110,000.00 $10,000.00 $10,000.00 10.000.00 $10,000.00 $10,000.00 110,000.00 $10,000.00 $10,000.00 $10,000.00 31,000,000.00 $1,000,000.00 $1.000.000.00 $1,000,000.00 $1,000,000 $1,000,000.00 $1,000,000.00 $1.000.000.00 $1.000.000.00 $1.000.000.00 $1.000.000.00 51 000 000.00 $1.000.000.00 $1.000.000.00 $1.000.000.00 $1.000.000,00 $1,000,000.00 51.000.000.00 31.000.000.00 100000000 $1.000.000.00 $1,000,000.00 $1.000.000.00 $1.000.000.00 $1,000,000.00 $1,000,000 00 51,000,000.00 11,000,000.00 51.000.000 DO $1,000,000.00 51.000.000.00 $1,000,000.00 $1,000,000 2.00 51.000.000,00 $1.000.000.00 $1,000,000.00 $1.000.000.00 $100,000.00 $1,000,000.00 $1.000,000.00 1 H Rules 364 OLIE $1.000.000.00 51.000.000.00 $1,000,000.00 $1,000,000.00 $1.000.000.00 $1,000,000.00 $1,000,000.00 $1,000,000.00 $1.000.000.00 $1,000,000.00 $1,000,000.00 $1,000,000.00 51.000.000.00 $1,000,000.00 $1.000.000.00 $1,000 000 00 $1,000,000.00 $1,000,000.00 51 000 000 00 51.000.000.00 $1,000,000 00 $1.000.000.00 $1 000 000.00 $1,000,000.00 $1,000,000.00 $1,000,000.00 $1.000.000.00 51 000 000 00 $1,000,000.00 $1,000,000.00 $5.000.000.00 $1.000.000.00 $1,000,000.00 $1.000.00000 51 1.000.000,00 31.000.000.00 31.000.000.00 51.000.000.00 51.000.000.00 $1.900,000.00 $1.000,000.00 $10,000.00 $10,000.00 $10.000.00 $10,000.00 $10.000.00 $10,000.00 $10.000,00 $10,000.00 $19.000.00 $10,0000 310.000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10.000.00 $10,000.00 $10,000.00 310,000.00 $10,000.00 $10.000.00 119.000.00 $10,000.00 $10.000.00 $10 000.00 $10,000.00 $10,000.00 310.000.00 $50,000.00 390,000.00 $10,000.00 $10.000.00 $10.000.00 310,000.00 310.000.00 310.000.00 $10,000.00 $10,000.00 21 22 23 24 25 26 27 28 23 30 31 32 33 50.00 30 09 $0.00 $0.00 0.00 $0.00 $0 00 10.00 SO DO $9.00 $0.00 $0.00 3000 50.00 $0.00 31000000 35 $19.000.00 $10.000.00 $1000000 $10.000.00 $10,000.00 $10.000.00 43 39 40 30.00 10.00 30.00 10 CAM CPM CPM(FRM)-Sched GPM ARM-Sched ARM-Charts + 24 MacBook Air Tools Data Insert Format Window Excel File Help Edit View CH 17 - Loan Amor AutoSave OFF Data Review Home View Tell me Insert Draw Formulas Page Layout X E Arial 8 2. Wrap Text ~ A A a. Av y Paste B I U Merge & Center FS 1 x fx =(B$4/B$2)*H4 B A 1 AM 2 frently 3 nino yrs) 12 30 12.00% $1,000,000.00 ($12.777.78) 0 Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 5 pv 6 pen 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 15 16 17 18 19 20 21 22 23 24 25 20 27 28 29 30 31 32 33 34 35 36 37 38 39 40 D E F G H Rules 38.4 Rule 2: Rule 1: Rules 384 OLB(Begl PMT INT AMORT: OLB(End) $1,000,000.00 $1,000,000.00 $12.777.78 $10,000.00 $2,777.78 $997.222.22 $997.222.22 $12,750.00 $994,444.44 $9.972 22 $2.777.78 $994,444.44 $12.722.22 $94.44 $2.777.78 $991,666.67 $991,666 67 $12.694.44 $9.916.67 $2,777.78 $988,888.89 $988.888 89 $12.666.67 $9.888.89 $2.777.78 $986.111.11 $986, 111.11 $12,638.89 $9.861.11 $2.777.78 $983,333.33 $983,333.33 $12,611.11 $9,833 33 $2.777.78 $980,555,56 $980,555,56 $12.583.33 $9,805 56 $2,777.78 $977,777.78 $977.777.78 $12.555.56 $9.777.78 $2.777.78 $975,000.00 $975.000.00 $12.527.78 $9.750.00 $2.777.78 $972,222 22 $972 222 22 $12,500.00 $9.722.22 $2.777.78 $969.444.44 $969.444.44 $12.472.22 $9.694.44 $2.777.78 $966,666.67 $966,666 67 $12.444.44 $9.666.67 $2,777.78 5963,888.89 $963,888.89 $12.416.67 $9.638 89 $2.777.78 $961.111.11 $961, 111.11 $12,388.89 $9.611.11 $2.777.78 $958,333.33 $958.333.33 $12,351.11 59,583.33 $2.777.78 $955,555.56 $955.555.56 $12,333 33 59,566.56 $2.777.78 $952.777.78 $952.777.78 $12.305.56 $9.527.78 $2.777.78 $950,000.00 $950,000.00 $12. 277.78 $9.500.00 $2.777.78 $947.222.22 $947.222.22 $12.250.00 $9.472.22 $2.777.78 $944,444 44 $944,444.44 $12 222 22 $9,444.44 $2.777.78 $941,666.67 $941,666.67 $12.194.44 $9,416.67 $2,777.78 $938,888.89 $938,888.80 $12,186.67 $9,388.89 $2,777.78 $936, 111.11 $936. 111.11 $12,138 89 $9,361.11 $2.777.78 $933,333 33 $933.333.33 $12.111.11 $9,333 33 $2.777.78 $930,555.56 $930.555.56 $12,063 33 $9,305 58 $2.777.78 $927.777.78 $927,777.78 $12.055.56 $9.277.78 $2.777.78 $925,000.00 $925,000.00 $12,027.78 $9.250.00 $2.777.78 $922,222 22 $922.222.22 $12,000.00 $9.22222 $2,777.78 $919.444.44 $919,444.44 $11.972 22 $9,194.44 $2.77778 $916,666.67 $916,666.67 $11,044 44 $9, 166.67 $2.777.78 5913,888.89 $213.888.89 $11,916.67 $9, 138.80 $2.777.78 $911,111.11 5911,111.11 $11,888.80 $9, 111.11 $2.777.78 $908,333.33 $908.333.33 $11,101.11 $9,083 33 $2.777.78 $905.555.56 $905.555.56 $11,833.33 $9,065 54 52.777.78 $02,777 78 $902.777.78 $11,805 56 $9,027.78 $2,777.78 $900.000.00 3900,000.00 $11,777.70 $9,000.00 52.777.78 5897.222.22 5897,222 22 $11,750.00 $8,972.22 52.777.78 $89444444 5894.444.44 $11.722 22 $8.944.44 $2.777.78 $491.600.67 191.000 $11.694.44 52.7777 TRELLE $06.688.00 CPM CPM(FRM)-Sched GPM ARM-Sched ARM-Cha 40 42 CAM 24 = Arial 8 - A We ext v Paste BIU a. Av Merge & Center F6 4 x fx =(B$4/B$2)*H5 D E B F G J H Rules 34 1 Classic FRMICPM 2 freqpetyr)" 3 n(no yrs)" Rule 1 INT Rule 2 AMORT PMT: OLB(Bog) Class 12 30 12.00% $1.000.000.00 ($10.26.13 0 Rules OLB(End) $1.000.000.00 $999. 713.87 $999.4249 $999.133.01 $966.838 21 54000 12000 $1,000,000.00 $999,713.87 $900.424.80 $999.133.01 $998. 21 $998 54047 $998.239.75 $99783602 $997629.25 $997, 319.42 $997,006.49 10000 8000 Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 20 21 4000 5 pv 6 pm 7 V 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 2000 $28613 $288.90 $291 $29480 $297.74 $300.72 $803 73 $308.77 $309.83 $312.93 $316.00 $31922 $40241 $305.64 $108.80 $32.18 $385.51 $338.86 $32.25 $345.67 $349.13 $3522 $356.15 $350 71 $363.30 SW4 $370.61 $37431 $378.06 0 $998.239.75 $99702 $997 609 25 $9973192 $90700649 $986.690.43 $986 37121 $9960480 $996.723.15 $986 30425 $996.082.08 5994.726.57 599438771 $904045.45 $983.69979 $933. 350.66 $99.998.04 $982 541 90 $980 282. 19 $991.918.89 $901 55196 $991, 181.34 $900,807.03 $10.28613 $10,000.00 $10.286.13 $10.286.13 $0.904.25 $10.286. 13 $9791 $10.26.13 $9.988 $10.286.13 $9.985.40 $10.286.13 $9.902.40 $10.286.13 $0.979.38 $10.285.13 $9.976.29 $10,288.13 $0.973.19 $10,286.13 $9.970.00 $10.286.13 $0.966.90 $10.288.13 $9.963.71 $10.28.13 $9.950 49 $10.286. 13 $9.967 23 $10.285 13 $9.9534 $10.285.13 $0.950.62 $10,286.13 $9.947 27 $10.2013 $0.9 $10.288.13 $9.900 45 $10.28.13 $9.937.00 $10.2013 $9.903.51 $10.286.13 $10.28813 Seos $10.28.13 $9.902.82 $10.286.13 $9.919.19 $10.28613 $9.915 52 $10.2013 $0.911.81 $10.286.13 $9.908.07 $10.286.13 $0.904 29 $10.288.13 $9.500 47 $10.28613 $9.896,61 $10.2013 59,392.72 $10.286.13 99.88 $10.286.13 $0.81 $10.286.13 $9.880 80 $10.26.13 S876.75 $10.200.13 $9.87265 $10.286.13 S. 88.50 $10.2013 $9.85434 $10.28.13 $9.80.12 $10,288.13 $10.2013 $9.85156 $10.286.13 30.34722 $10.280.13 $10.286.13 $0.30 $10.26.13 $10.286.13 $9.009.39 $10.286. 13 59.82480 CPM(FRM)-Sched $996,37121 $99604879 $996.72315 39953425 $996.02.08 $994.726.57 $94.387.71 $994.045.40 $983,699.79 $980 350 66 3980996 04 $982.641.50 $982,282.19 $991,918.0 $991551.95 $991, 181.324 $990 307.00 $900.428.90 $980,047.14 $989.66148 $60.27197 3988.878.57 $968. 481.23 3988.079.91 $987,674 50 596720521 $986,851.73 596,434.12 3986.012 $985.586 34 $985.15607 $94.72151 1984 282.60 23 24 25 26 27 28 29 30 31 $385.66 $390.41 $990047.14 ses. 661.48 S98 27197 $988.878.99 $988 48123 $988.079.91 398761450 $987.246.21 $986.85173 $401.31 36 36 17 38 39 40 41 42 $4093 5413.47 $41761 50178 $98601234 45 46 47 48 49 50 51 52 5964721.51 $98428260 $983.33930 SO 54330 $447.73 46 $983,39156 $982.939.35 48 3902.939 35 $382.42.62 590202122 GPM $ 5461.30 IO CAM CPM ARM-Sched ARM-CI SON Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial v 8 A = = 2 Wrap Text Paste v A v Merce Car B6 fx =B5/(PV(B4/B2,12,1)+1.075*PV(B4/B2,12,1)/(1+B4/B2)^12+1.075^2*PV(B4/B2, B J 1 GPM 2 treeply) 3 ninys D Rules 344 OLB(leg Montre G 12 30 12.00% $1.000.000.00 (9825676 1 2 3 4 5 6 14000 12000 10000 7.5% for 4 years 8 9 10 11 8000 6000 4000 5 p 6 pm 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 13 14 15 16 17 2000 1 20 22 23 24 25 25 27 2 $1,000,000.00 $1,00174424 $1,003, S05.93 $1,005,28523 $1,007 0233 $1.008,897 40 $1.010,730.61 $1,012.02.16 $1.054,452.23 $1,016, 341.00 $1,016.248.66 $1,020,17530 $1,022, 1213 $1,003 46766 $ 179 $ 1200 73 $1027 57 80 $1.02. $1.000,400.00 $1,631 8829 $1.033.218 $1,634,744.00 $1.606.206.40 51,037.603.59 $1.03.195.50 $1,040,046.2 $1.040.906.00 51,041,775.34 $1,042,68954 $1,003,538.51 51,044,433.33 $1,045,337.11 $1,046,24002 $1.00 $1,046, 108.02 310000 $1.00, $1.000,23720 $100,4834 $1.000,7221 $1.050, 63.43 $1.061.2017 51051493.44 51.061.7227 11.06.2013 11.00 217.75 31.082.54441 51,090.813.75 51.05306 CPM E F G H 1 Rule 1 Rule 2 Rules 364 PMT: INT: AMORT: OLB/End $1.000.000.00 S825670 $10,000.00 ($1,74424) $1.001,744.24 $0.286.76 $10.0174 (51761.691 $1,003,505.90 $8.255.76 $10.035,08 ($1,779.30) $1,005 285 23 $8.256.78 $10,052.85 ($1,797.00 $1,007,082 33 $8,256.78 $10,070.2 ($1815.07 $1008.897.40 $8,25670 $10,08897 ($1833.22) $1,010.730.61 58.256.78 $19,107 31 (51.851.55) $1,012.02.16 $8,25670 $10,125.62 ($1.870 07 $1.054,452 23 58.256.78 $10.144.52 ($1.888.77 $1,016 341.00 $10,163.41 (51,907.65) $1,018 248.65 $8.256.76 $10,182.49 (51,906 73 $1.020,175 $6.256.76 $10.201.75 (51,948.00) $1.002.121.38 58,874.94 $10.221.21 ($1.316.28 $1023 467 65 58.8744 $99.21.6 (51.359.74) $1,024,82730 58.874 $10.248.27 ($1,37334) $1.008.200.73 58.874 $10.262.01 (51 TOT $1.027,587 80 $10 275 ($1,000.00 $1,028 968.74 S8814 $10.289.89 (51,41495 $1.000 400.00 $8,874.4 $10,301.04 (51,429.10 $1.031.800.9 $6,874 $10,318 33 51,031.270.18 $8.87. $10,0275 151457) $1,004,734.00 SANS $10.37 ($1472.00 $1.036,200 40 S8814.94 $0.12.06 (51 487.137 $1,037 603.53 $1874.94 31037 (51,502.00 $1,000. 195.50 99 100 $10.39136 451409 $1,040,00 SR 500 $10,400.41 (5850911 $1.049,906,83 39.540.56 $10.400.00 ( $1,041.775 $0.54056 $10.417.75 (SET 2 $1,012.002.54 $8.540.56 510,42553 (SSSS 51.043,538.51 30,540,56 $10.4353 $10.433.33 3954056 $10.444.33 15903.78) $1.045,337 11 0.54056 $10.653.37 (591201) $1,046,249.90 50.540. Se $59.412.50 $90190 $0.54054 $104717186 $19.471.72 $1.063.10302 $2,50 $10.4103 (S040:47 so $1,048,048.40 39,540.50 $10.49045 ( SM $1.04.200.37 $10.26.10 de $10.490.83 $20.00 $1.00 23720 110.25610 310,502:37 (320020 $10.2610 $10.504.88 $1.060,7021 $10.10 $10.5072 (351 51.05091 510910 $10.500 . 51051217 $10.2010 $10.512.37 $10.2010 510514.50 51.0 51210 $1.051 $10.2010 $10.99014 (204.00 $1.000 277 510610 $10,692 510200.10 $10.595.44 31082,813.78 500 $10,503.14 $1.05.08 $11.05.31 110.630 14.45 $1.052.501,34 CPM(FRM)-Sched GPM ARM-Sched 31 32 33 M 37 38 39 40 31 AR 49 50 51 52 41 10 CAM ARM-CH 24 Download A Alternativ class. You must provide me with an Excel file that has 4 tabs. You may use the CH 17 Excel file as a basis for the file that you e-mail to me. The file should be e-mailed by midnight on Friday, 9/24/14. Below are the 4 types of mortgages you need to build in Excel. 1) On the first tab build the full amortization table for a 30 year Interest Only (10) Loan with a 5.5% interest rate compounded monthly. The initial loan amount should be $5,000,000. 2) On the second tab build the full amortization table for a 15 year Constant Amortizing Mortgage (CAM) Loan with a 6% interest rate compounded monthly. The initial loan amount should be $7,500,000 3) On the third tab build the full amortization table for a 30 year Constant Payment Mortgage (CPM) Loan with a 4.5% interest rate compounded monthly. The initial loan amount should be $2,500,000 4) On the fourth tab build the full amortization table for a 30 year Graduated Payment Mortgage (GPM) Loan with a 6.5% interest rate compounded monthly. The initial loan amount should be $1,500,000. There should be 2 step ups, each a 10% increase. One every 2 years with the 1st through 24th, 25th through 48th, and 49th through 360th payments being the same amount respectively Excel File Edit Format Tools Data Window Help View Insert ROES AutoSave OFF CH 17 - Loan Amortization Examples Home Insert Draw Page Layout Formulas Data Review View Tell me Arial B 29 Wrap Text Currency ' A Paste B I Merge & Center E4 fx --B$6 D E F G 1 J Month Rule 34 OLB Bel PMT Rulet INT Rule 2 AMORT Se 9 2 3 4 S 6 7 14000 12000 10000 MOOD B 1 Interest-Only Mortgage 2 trepte 12 30 12.00% $1,000,000.00 pot 510.000.00 7 f 151.000.000 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 6000 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 0.00 50.00 $0.00 10.00 $0.00 $0.00 $9.00 $0.00 9 10 11 12 13 14 15 16 17 * 19 4000 2000 $10.000.00 $10.000.00 $1000000 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10.000.00 $10,000.00 $19,000.00 $10.00000 510.00000 $10.000.00 $10.000,00 $10.000.00 $10.000.00 $10,000.00 $10,000.00 310,000.00 $10.000.00 $50,000.00 110,000.00 $10,000.00 $10,000.00 10.000.00 $10,000.00 $10,000.00 110,000.00 $10,000.00 $10,000.00 $10,000.00 31,000,000.00 $1,000,000.00 $1.000.000.00 $1,000,000.00 $1,000,000 $1,000,000.00 $1,000,000.00 $1.000.000.00 $1.000.000.00 $1.000.000.00 $1.000.000.00 51 000 000.00 $1.000.000.00 $1.000.000.00 $1.000.000.00 $1.000.000,00 $1,000,000.00 51.000.000.00 31.000.000.00 100000000 $1.000.000.00 $1,000,000.00 $1.000.000.00 $1.000.000.00 $1,000,000.00 $1,000,000 00 51,000,000.00 11,000,000.00 51.000.000 DO $1,000,000.00 51.000.000.00 $1,000,000.00 $1,000,000 2.00 51.000.000,00 $1.000.000.00 $1,000,000.00 $1.000.000.00 $100,000.00 $1,000,000.00 $1.000,000.00 1 H Rules 364 OLIE $1.000.000.00 51.000.000.00 $1,000,000.00 $1,000,000.00 $1.000.000.00 $1,000,000.00 $1,000,000.00 $1,000,000.00 $1.000.000.00 $1,000,000.00 $1,000,000.00 $1,000,000.00 51.000.000.00 $1,000,000.00 $1.000.000.00 $1,000 000 00 $1,000,000.00 $1,000,000.00 51 000 000 00 51.000.000.00 $1,000,000 00 $1.000.000.00 $1 000 000.00 $1,000,000.00 $1,000,000.00 $1,000,000.00 $1.000.000.00 51 000 000 00 $1,000,000.00 $1,000,000.00 $5.000.000.00 $1.000.000.00 $1,000,000.00 $1.000.00000 51 1.000.000,00 31.000.000.00 31.000.000.00 51.000.000.00 51.000.000.00 $1.900,000.00 $1.000,000.00 $10,000.00 $10,000.00 $10.000.00 $10,000.00 $10.000.00 $10,000.00 $10.000,00 $10,000.00 $19.000.00 $10,0000 310.000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10.000.00 $10,000.00 $10,000.00 310,000.00 $10,000.00 $10.000.00 119.000.00 $10,000.00 $10.000.00 $10 000.00 $10,000.00 $10,000.00 310.000.00 $50,000.00 390,000.00 $10,000.00 $10.000.00 $10.000.00 310,000.00 310.000.00 310.000.00 $10,000.00 $10,000.00 21 22 23 24 25 26 27 28 23 30 31 32 33 50.00 30 09 $0.00 $0.00 0.00 $0.00 $0 00 10.00 SO DO $9.00 $0.00 $0.00 3000 50.00 $0.00 31000000 35 $19.000.00 $10.000.00 $1000000 $10.000.00 $10,000.00 $10.000.00 43 39 40 30.00 10.00 30.00 10 CAM CPM CPM(FRM)-Sched GPM ARM-Sched ARM-Charts + 24 MacBook Air Tools Data Insert Format Window Excel File Help Edit View CH 17 - Loan Amor AutoSave OFF Data Review Home View Tell me Insert Draw Formulas Page Layout X E Arial 8 2. Wrap Text ~ A A a. Av y Paste B I U Merge & Center FS 1 x fx =(B$4/B$2)*H4 B A 1 AM 2 frently 3 nino yrs) 12 30 12.00% $1,000,000.00 ($12.777.78) 0 Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 5 pv 6 pen 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 15 16 17 18 19 20 21 22 23 24 25 20 27 28 29 30 31 32 33 34 35 36 37 38 39 40 D E F G H Rules 38.4 Rule 2: Rule 1: Rules 384 OLB(Begl PMT INT AMORT: OLB(End) $1,000,000.00 $1,000,000.00 $12.777.78 $10,000.00 $2,777.78 $997.222.22 $997.222.22 $12,750.00 $994,444.44 $9.972 22 $2.777.78 $994,444.44 $12.722.22 $94.44 $2.777.78 $991,666.67 $991,666 67 $12.694.44 $9.916.67 $2,777.78 $988,888.89 $988.888 89 $12.666.67 $9.888.89 $2.777.78 $986.111.11 $986, 111.11 $12,638.89 $9.861.11 $2.777.78 $983,333.33 $983,333.33 $12,611.11 $9,833 33 $2.777.78 $980,555,56 $980,555,56 $12.583.33 $9,805 56 $2,777.78 $977,777.78 $977.777.78 $12.555.56 $9.777.78 $2.777.78 $975,000.00 $975.000.00 $12.527.78 $9.750.00 $2.777.78 $972,222 22 $972 222 22 $12,500.00 $9.722.22 $2.777.78 $969.444.44 $969.444.44 $12.472.22 $9.694.44 $2.777.78 $966,666.67 $966,666 67 $12.444.44 $9.666.67 $2,777.78 5963,888.89 $963,888.89 $12.416.67 $9.638 89 $2.777.78 $961.111.11 $961, 111.11 $12,388.89 $9.611.11 $2.777.78 $958,333.33 $958.333.33 $12,351.11 59,583.33 $2.777.78 $955,555.56 $955.555.56 $12,333 33 59,566.56 $2.777.78 $952.777.78 $952.777.78 $12.305.56 $9.527.78 $2.777.78 $950,000.00 $950,000.00 $12. 277.78 $9.500.00 $2.777.78 $947.222.22 $947.222.22 $12.250.00 $9.472.22 $2.777.78 $944,444 44 $944,444.44 $12 222 22 $9,444.44 $2.777.78 $941,666.67 $941,666.67 $12.194.44 $9,416.67 $2,777.78 $938,888.89 $938,888.80 $12,186.67 $9,388.89 $2,777.78 $936, 111.11 $936. 111.11 $12,138 89 $9,361.11 $2.777.78 $933,333 33 $933.333.33 $12.111.11 $9,333 33 $2.777.78 $930,555.56 $930.555.56 $12,063 33 $9,305 58 $2.777.78 $927.777.78 $927,777.78 $12.055.56 $9.277.78 $2.777.78 $925,000.00 $925,000.00 $12,027.78 $9.250.00 $2.777.78 $922,222 22 $922.222.22 $12,000.00 $9.22222 $2,777.78 $919.444.44 $919,444.44 $11.972 22 $9,194.44 $2.77778 $916,666.67 $916,666.67 $11,044 44 $9, 166.67 $2.777.78 5913,888.89 $213.888.89 $11,916.67 $9, 138.80 $2.777.78 $911,111.11 5911,111.11 $11,888.80 $9, 111.11 $2.777.78 $908,333.33 $908.333.33 $11,101.11 $9,083 33 $2.777.78 $905.555.56 $905.555.56 $11,833.33 $9,065 54 52.777.78 $02,777 78 $902.777.78 $11,805 56 $9,027.78 $2,777.78 $900.000.00 3900,000.00 $11,777.70 $9,000.00 52.777.78 5897.222.22 5897,222 22 $11,750.00 $8,972.22 52.777.78 $89444444 5894.444.44 $11.722 22 $8.944.44 $2.777.78 $491.600.67 191.000 $11.694.44 52.7777 TRELLE $06.688.00 CPM CPM(FRM)-Sched GPM ARM-Sched ARM-Cha 40 42 CAM 24 = Arial 8 - A We ext v Paste BIU a. Av Merge & Center F6 4 x fx =(B$4/B$2)*H5 D E B F G J H Rules 34 1 Classic FRMICPM 2 freqpetyr)" 3 n(no yrs)" Rule 1 INT Rule 2 AMORT PMT: OLB(Bog) Class 12 30 12.00% $1.000.000.00 ($10.26.13 0 Rules OLB(End) $1.000.000.00 $999. 713.87 $999.4249 $999.133.01 $966.838 21 54000 12000 $1,000,000.00 $999,713.87 $900.424.80 $999.133.01 $998. 21 $998 54047 $998.239.75 $99783602 $997629.25 $997, 319.42 $997,006.49 10000 8000 Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 20 21 4000 5 pv 6 pm 7 V 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 2000 $28613 $288.90 $291 $29480 $297.74 $300.72 $803 73 $308.77 $309.83 $312.93 $316.00 $31922 $40241 $305.64 $108.80 $32.18 $385.51 $338.86 $32.25 $345.67 $349.13 $3522 $356.15 $350 71 $363.30 SW4 $370.61 $37431 $378.06 0 $998.239.75 $99702 $997 609 25 $9973192 $90700649 $986.690.43 $986 37121 $9960480 $996.723.15 $986 30425 $996.082.08 5994.726.57 599438771 $904045.45 $983.69979 $933. 350.66 $99.998.04 $982 541 90 $980 282. 19 $991.918.89 $901 55196 $991, 181.34 $900,807.03 $10.28613 $10,000.00 $10.286.13 $10.286.13 $0.904.25 $10.286. 13 $9791 $10.26.13 $9.988 $10.286.13 $9.985.40 $10.286.13 $9.902.40 $10.286.13 $0.979.38 $10.285.13 $9.976.29 $10,288.13 $0.973.19 $10,286.13 $9.970.00 $10.286.13 $0.966.90 $10.288.13 $9.963.71 $10.28.13 $9.950 49 $10.286. 13 $9.967 23 $10.285 13 $9.9534 $10.285.13 $0.950.62 $10,286.13 $9.947 27 $10.2013 $0.9 $10.288.13 $9.900 45 $10.28.13 $9.937.00 $10.2013 $9.903.51 $10.286.13 $10.28813 Seos $10.28.13 $9.902.82 $10.286.13 $9.919.19 $10.28613 $9.915 52 $10.2013 $0.911.81 $10.286.13 $9.908.07 $10.286.13 $0.904 29 $10.288.13 $9.500 47 $10.28613 $9.896,61 $10.2013 59,392.72 $10.286.13 99.88 $10.286.13 $0.81 $10.286.13 $9.880 80 $10.26.13 S876.75 $10.200.13 $9.87265 $10.286.13 S. 88.50 $10.2013 $9.85434 $10.28.13 $9.80.12 $10,288.13 $10.2013 $9.85156 $10.286.13 30.34722 $10.280.13 $10.286.13 $0.30 $10.26.13 $10.286.13 $9.009.39 $10.286. 13 59.82480 CPM(FRM)-Sched $996,37121 $99604879 $996.72315 39953425 $996.02.08 $994.726.57 $94.387.71 $994.045.40 $983,699.79 $980 350 66 3980996 04 $982.641.50 $982,282.19 $991,918.0 $991551.95 $991, 181.324 $990 307.00 $900.428.90 $980,047.14 $989.66148 $60.27197 3988.878.57 $968. 481.23 3988.079.91 $987,674 50 596720521 $986,851.73 596,434.12 3986.012 $985.586 34 $985.15607 $94.72151 1984 282.60 23 24 25 26 27 28 29 30 31 $385.66 $390.41 $990047.14 ses. 661.48 S98 27197 $988.878.99 $988 48123 $988.079.91 398761450 $987.246.21 $986.85173 $401.31 36 36 17 38 39 40 41 42 $4093 5413.47 $41761 50178 $98601234 45 46 47 48 49 50 51 52 5964721.51 $98428260 $983.33930 SO 54330 $447.73 46 $983,39156 $982.939.35 48 3902.939 35 $382.42.62 590202122 GPM $ 5461.30 IO CAM CPM ARM-Sched ARM-CI SON Home Insert Draw Page Layout Formulas Data Review View Tell me X Arial v 8 A = = 2 Wrap Text Paste v A v Merce Car B6 fx =B5/(PV(B4/B2,12,1)+1.075*PV(B4/B2,12,1)/(1+B4/B2)^12+1.075^2*PV(B4/B2, B J 1 GPM 2 treeply) 3 ninys D Rules 344 OLB(leg Montre G 12 30 12.00% $1.000.000.00 (9825676 1 2 3 4 5 6 14000 12000 10000 7.5% for 4 years 8 9 10 11 8000 6000 4000 5 p 6 pm 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 13 14 15 16 17 2000 1 20 22 23 24 25 25 27 2 $1,000,000.00 $1,00174424 $1,003, S05.93 $1,005,28523 $1,007 0233 $1.008,897 40 $1.010,730.61 $1,012.02.16 $1.054,452.23 $1,016, 341.00 $1,016.248.66 $1,020,17530 $1,022, 1213 $1,003 46766 $ 179 $ 1200 73 $1027 57 80 $1.02. $1.000,400.00 $1,631 8829 $1.033.218 $1,634,744.00 $1.606.206.40 51,037.603.59 $1.03.195.50 $1,040,046.2 $1.040.906.00 51,041,775.34 $1,042,68954 $1,003,538.51 51,044,433.33 $1,045,337.11 $1,046,24002 $1.00 $1,046, 108.02 310000 $1.00, $1.000,23720 $100,4834 $1.000,7221 $1.050, 63.43 $1.061.2017 51051493.44 51.061.7227 11.06.2013 11.00 217.75 31.082.54441 51,090.813.75 51.05306 CPM E F G H 1 Rule 1 Rule 2 Rules 364 PMT: INT: AMORT: OLB/End $1.000.000.00 S825670 $10,000.00 ($1,74424) $1.001,744.24 $0.286.76 $10.0174 (51761.691 $1,003,505.90 $8.255.76 $10.035,08 ($1,779.30) $1,005 285 23 $8.256.78 $10,052.85 ($1,797.00 $1,007,082 33 $8,256.78 $10,070.2 ($1815.07 $1008.897.40 $8,25670 $10,08897 ($1833.22) $1,010.730.61 58.256.78 $19,107 31 (51.851.55) $1,012.02.16 $8,25670 $10,125.62 ($1.870 07 $1.054,452 23 58.256.78 $10.144.52 ($1.888.77 $1,016 341.00 $10,163.41 (51,907.65) $1,018 248.65 $8.256.76 $10,182.49 (51,906 73 $1.020,175 $6.256.76 $10.201.75 (51,948.00) $1.002.121.38 58,874.94 $10.221.21 ($1.316.28 $1023 467 65 58.8744 $99.21.6 (51.359.74) $1,024,82730 58.874 $10.248.27 ($1,37334) $1.008.200.73 58.874 $10.262.01 (51 TOT $1.027,587 80 $10 275 ($1,000.00 $1,028 968.74 S8814 $10.289.89 (51,41495 $1.000 400.00 $8,874.4 $10,301.04 (51,429.10 $1.031.800.9 $6,874 $10,318 33 51,031.270.18 $8.87. $10,0275 151457) $1,004,734.00 SANS $10.37 ($1472.00 $1.036,200 40 S8814.94 $0.12.06 (51 487.137 $1,037 603.53 $1874.94 31037 (51,502.00 $1,000. 195.50 99 100 $10.39136 451409 $1,040,00 SR 500 $10,400.41 (5850911 $1.049,906,83 39.540.56 $10.400.00 ( $1,041.775 $0.54056 $10.417.75 (SET 2 $1,012.002.54 $8.540.56 510,42553 (SSSS 51.043,538.51 30,540,56 $10.4353 $10.433.33 3954056 $10.444.33 15903.78) $1.045,337 11 0.54056 $10.653.37 (591201) $1,046,249.90 50.540. Se $59.412.50 $90190 $0.54054 $104717186 $19.471.72 $1.063.10302 $2,50 $10.4103 (S040:47 so $1,048,048.40 39,540.50 $10.49045 ( SM $1.04.200.37 $10.26.10 de $10.490.83 $20.00 $1.00 23720 110.25610 310,502:37 (320020 $10.2610 $10.504.88 $1.060,7021 $10.10 $10.5072 (351 51.05091 510910 $10.500 . 51051217 $10.2010 $10.512.37 $10.2010 510514.50 51.0 51210 $1.051 $10.2010 $10.99014 (204.00 $1.000 277 510610 $10,692 510200.10 $10.595.44 31082,813.78 500 $10,503.14 $1.05.08 $11.05.31 110.630 14.45 $1.052.501,34 CPM(FRM)-Sched GPM ARM-Sched 31 32 33 M 37 38 39 40 31 AR 49 50 51 52 41 10 CAM ARM-CH 24