Question: 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.

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 1stthrough 24th, 25th through 48th, and 49th through 360th payments being the same amount respectively.

please review this work

On the fourth tab build the full amortization table for a 30

GPM Graduated Payment Mortgage (GPM) 5 pv= 14000 12000 10000 8000 PMT 6000 ---- INT 4000 2000 0 1 61 121 181 241 301 PMT Number 1 GPM Rules 3&4: Rule 1: Rule 2: Rules 3&4: 2 freq(pm/yr)- 12 Month# OLB(Beg): PMT: INT: AMORT: OLB(End): 3 n (no.yrs)- 30 0 $1,500,000.00 4 i=intyra 6.50% 1 $1,500,000.00 $8,127.80 $8,125.00 $2.80 $1,499,997.20 $1,500,000.00 2 $1,499,997.20 58,127.80 58,124.98 S2.81 $1,499,994.39 6 pmtu (58,127.80) 3 $1,499,994.39 $8,127.80 $8,124.97 $2.83 $1,499.991.56 7 fv= 0 4 $1,499,991.56 $8,127.80 $8,124.95 $2.84 $1,499,988.71 8 5 $1,499,988.71 $8,127.80 $8,124.94 $2.86 $1,499,985.85 9 6 $1,499,985.85 $8,127.80 $8,124.92 $2.88 $1,499,982.98 10 7 $1,499,982.98 $8,127.80 $8,124.91 $2.89 $1,499,980.09 11 8 $1,499,980.09 $8,127.80 $8,124.89 $2.91 $1,499,977.18 12 10% inc for 2 years 9 $1,499,977.18 $8,127.80 $8,124.88 $2.92 $1,499,974.26 13 10 $1,499,974.26 $8,127.80 $8,124.86 $2.94 $1,499,971.32 14 11 $1,499,971.32 $8,127.80 $8,124.84 $2.95 $1,499,968.36 15 12 $1,499,968.36 $8,127.80 $8,124.83 $2.97 $1,499,965.39 16 13 $1,499,965.39 $8,127.80 $8,124.81 $2.99 $1,499,962.41 17 14 $1,499,962.41 $8,127.80 $8,124.80 $3.00 $1,499,959.41 18 15 $1,499,959.41 $8,127.80 $8,124.78 $3.02 $1,499,956.39 19 16 $1,499,956.39 $8,127.80 $8,124.76 $3.04 $1,499,953.35 20 17 $1,499,953.35 $8,127.80 $8,124.75 $3.05 $1,499,950.30 21 18 $1,499,950.30 S8,127.80 S8,124.73 $3.07 $1,499,947.23 22 19 $1,499,947.23 $8,127.80 $8,124.71 $3.08 $1,499,944.15 23 20 $1,499,944.15 $8,127.80 $8,124.70 $3.10 $1,499,941.05 24 21 $1,499,941.05 $8,127.80 $8,124.68 $3.12 $1,499,937.93 25 22 $1,499,937.93 $8,127.80 $8,124.66 $3.14 $1,499,934.79 26 23 $1,499,934.79 $8,127.80 $8,124.65 $3.15 $1,499,931.64 27 24 $1,499,931.64 $8,127.80 $8,124.63 $3.17 $1,499,928.47 28 25 $1,499,928.47 $8,940.58 S8,124.61 $815.97 $1,499,112.50 29 26 $1,499,112.50 $8,940.58 $8,120.19 $820.39 $1,498,292.12 30 27 $1,498,292.12 $8,940.58 $8,115.75 $824.83 $1,497,467.29 31 28 $1,497,467.29 $8,940.58 $8,111.28 $829.30 $1,496,637.99 32 29 $1,496,637.99 $8,940.58 $8,106.79 $833.79 $1,495,804.20 33 30 $1,495,804.20 $8,940.58 $8,102.27 $838.31 $1,494,965.90 34 31 $1,494,965.90 $8,940.58 $8,097.73 $842.85 $1,494, 123.05 35 32 $1,494,123.05 $8,940.58 $8,093.17 5847.41 $1,493,275.64 36 33 $1,493,275.64 $8,940.58 $8,088.58 $852.00 $1,492,423.63 37 34 $1,492,423.63 58,940.58 58,083.96 $856.62 $1,491,567.02 38 35 $1,491,567.02 $8,940.58 $8,079.32 $861.26 $1,490,705.76 39 36 $1,490,705.76 $8,940.58 $8,074.66 $865.92 $1,489,839.84 40 37 $1,489,839.84 $8,940.58 $8,069.97 $870.61 $1,488,969.22 41 38 $1,488,969.22 $8,940.58 $8,065.25 $875.33 $1,488,093.89 42 39 $1,488,093.89 $8,940.58 $8,060.51 $880.07 $1,487,213.82 43 40 $1,487,213.82 $8,940.58 $8,055.74 $884.84 $1,486,328.99 44 41 $1,486,328.99 $8,940.58 $8,050.95 S889.63 $1,485,439.36 45 42 $1,485,439.36 $8,940.58 $8,046.13 $894.45 $1,484,544.91 46 43 $1,484,544.91 $8,940.58 $8,041.28 $899.29 $1,483,645.61 47 44 $1,483,645,61 $8,940.58 $8,036.41 $904.17 $1,482,741.45 48 45 $1,482,741.45 $8,940.58 $8,031.52 $909.06 $1,481,832.39 49 46 $1,481,832.39 $8,940.58 $8,026.59 $913.99 $1,480,918.40 50 47 $1,480,918.40 $8,940.58 $8,021.64 $918.94 $1,479,999.46 51 48 $1,479,999.46 $8,940.58 $8,016.66 S923.92 $1,479,075.55 52 49 $1,479,075.55 $9,834.64 $8,011.66 $1,822.98 $1,477,252.57 53 50 51,477,252.57 $9,834.64 $8,001.78 $1,832.85 $1,475,419.72 54 51 51,475,419.72 9,834.64 $7,991.86 $1,842.78 $1,473,576.94 55 52 $1,473,576.94 $9,834.64 $7,981.88 $1,852.76 $1,471,724.18 56 53 1 471 724 18 CO 824 64 67 071 BA 61 862 A 1.460 861 38 GPM Graduated Payment Mortgage (GPM) 5 pv= 14000 12000 10000 8000 PMT 6000 ---- INT 4000 2000 0 1 61 121 181 241 301 PMT Number 1 GPM Rules 3&4: Rule 1: Rule 2: Rules 3&4: 2 freq(pm/yr)- 12 Month# OLB(Beg): PMT: INT: AMORT: OLB(End): 3 n (no.yrs)- 30 0 $1,500,000.00 4 i=intyra 6.50% 1 $1,500,000.00 $8,127.80 $8,125.00 $2.80 $1,499,997.20 $1,500,000.00 2 $1,499,997.20 58,127.80 58,124.98 S2.81 $1,499,994.39 6 pmtu (58,127.80) 3 $1,499,994.39 $8,127.80 $8,124.97 $2.83 $1,499.991.56 7 fv= 0 4 $1,499,991.56 $8,127.80 $8,124.95 $2.84 $1,499,988.71 8 5 $1,499,988.71 $8,127.80 $8,124.94 $2.86 $1,499,985.85 9 6 $1,499,985.85 $8,127.80 $8,124.92 $2.88 $1,499,982.98 10 7 $1,499,982.98 $8,127.80 $8,124.91 $2.89 $1,499,980.09 11 8 $1,499,980.09 $8,127.80 $8,124.89 $2.91 $1,499,977.18 12 10% inc for 2 years 9 $1,499,977.18 $8,127.80 $8,124.88 $2.92 $1,499,974.26 13 10 $1,499,974.26 $8,127.80 $8,124.86 $2.94 $1,499,971.32 14 11 $1,499,971.32 $8,127.80 $8,124.84 $2.95 $1,499,968.36 15 12 $1,499,968.36 $8,127.80 $8,124.83 $2.97 $1,499,965.39 16 13 $1,499,965.39 $8,127.80 $8,124.81 $2.99 $1,499,962.41 17 14 $1,499,962.41 $8,127.80 $8,124.80 $3.00 $1,499,959.41 18 15 $1,499,959.41 $8,127.80 $8,124.78 $3.02 $1,499,956.39 19 16 $1,499,956.39 $8,127.80 $8,124.76 $3.04 $1,499,953.35 20 17 $1,499,953.35 $8,127.80 $8,124.75 $3.05 $1,499,950.30 21 18 $1,499,950.30 S8,127.80 S8,124.73 $3.07 $1,499,947.23 22 19 $1,499,947.23 $8,127.80 $8,124.71 $3.08 $1,499,944.15 23 20 $1,499,944.15 $8,127.80 $8,124.70 $3.10 $1,499,941.05 24 21 $1,499,941.05 $8,127.80 $8,124.68 $3.12 $1,499,937.93 25 22 $1,499,937.93 $8,127.80 $8,124.66 $3.14 $1,499,934.79 26 23 $1,499,934.79 $8,127.80 $8,124.65 $3.15 $1,499,931.64 27 24 $1,499,931.64 $8,127.80 $8,124.63 $3.17 $1,499,928.47 28 25 $1,499,928.47 $8,940.58 S8,124.61 $815.97 $1,499,112.50 29 26 $1,499,112.50 $8,940.58 $8,120.19 $820.39 $1,498,292.12 30 27 $1,498,292.12 $8,940.58 $8,115.75 $824.83 $1,497,467.29 31 28 $1,497,467.29 $8,940.58 $8,111.28 $829.30 $1,496,637.99 32 29 $1,496,637.99 $8,940.58 $8,106.79 $833.79 $1,495,804.20 33 30 $1,495,804.20 $8,940.58 $8,102.27 $838.31 $1,494,965.90 34 31 $1,494,965.90 $8,940.58 $8,097.73 $842.85 $1,494, 123.05 35 32 $1,494,123.05 $8,940.58 $8,093.17 5847.41 $1,493,275.64 36 33 $1,493,275.64 $8,940.58 $8,088.58 $852.00 $1,492,423.63 37 34 $1,492,423.63 58,940.58 58,083.96 $856.62 $1,491,567.02 38 35 $1,491,567.02 $8,940.58 $8,079.32 $861.26 $1,490,705.76 39 36 $1,490,705.76 $8,940.58 $8,074.66 $865.92 $1,489,839.84 40 37 $1,489,839.84 $8,940.58 $8,069.97 $870.61 $1,488,969.22 41 38 $1,488,969.22 $8,940.58 $8,065.25 $875.33 $1,488,093.89 42 39 $1,488,093.89 $8,940.58 $8,060.51 $880.07 $1,487,213.82 43 40 $1,487,213.82 $8,940.58 $8,055.74 $884.84 $1,486,328.99 44 41 $1,486,328.99 $8,940.58 $8,050.95 S889.63 $1,485,439.36 45 42 $1,485,439.36 $8,940.58 $8,046.13 $894.45 $1,484,544.91 46 43 $1,484,544.91 $8,940.58 $8,041.28 $899.29 $1,483,645.61 47 44 $1,483,645,61 $8,940.58 $8,036.41 $904.17 $1,482,741.45 48 45 $1,482,741.45 $8,940.58 $8,031.52 $909.06 $1,481,832.39 49 46 $1,481,832.39 $8,940.58 $8,026.59 $913.99 $1,480,918.40 50 47 $1,480,918.40 $8,940.58 $8,021.64 $918.94 $1,479,999.46 51 48 $1,479,999.46 $8,940.58 $8,016.66 S923.92 $1,479,075.55 52 49 $1,479,075.55 $9,834.64 $8,011.66 $1,822.98 $1,477,252.57 53 50 51,477,252.57 $9,834.64 $8,001.78 $1,832.85 $1,475,419.72 54 51 51,475,419.72 9,834.64 $7,991.86 $1,842.78 $1,473,576.94 55 52 $1,473,576.94 $9,834.64 $7,981.88 $1,852.76 $1,471,724.18 56 53 1 471 724 18 CO 824 64 67 071 BA 61 862 A 1.460 861 38

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!