Interest rate quiz four questions due in 3hours

profilebaros234
GPM_EXAMPLE.xlsx
Home>Mathematics homework help>Interest rate quiz four questions due in 3hours

Examples 1&2

Example 1: Graduated Payment Mortgage
Loan: 50,000
Term: 3 year
Interest 10% annually
Payment 30,881.67 annually
Year Beg Bal Pmt factor Payment Interest Principal End bal. factor
0 50,000.00 1.6190833959 49500 10000 49500
1 50,000.00 50% 15,440.84 5,000.00 10,440.84 39,559.16 0.4545454545 -55,000.00 -55,000.00 -24,644.62
2 39,559.16 50% 15,440.84 3,955.92 11,484.92 28,074.25 0.4132231405
3 28,074.25 100% 30,881.67 2,807.42 28,074.25 0.00 0.7513148009
11.11% 450.00% 10.56%
Example 2: Graduated Payment Mortgage
Loan: 50,000
Term: 3 year
Interest 10% annually PMT Growth 25%
Payment 16,045.81 annually
Year Beg Bal Growth factor Payment Interest Principal End bal. factor
0 50,000.00 3.1160781367
1 50,000.00 100% 16,045.81 5,000.00 11,045.81 38,954.19 0.9090909091
2 38,954.19 125% 20,057.26 3,895.42 16,161.84 22,792.34 1.0330578512
3 22,792.34 156% 25,071.58 2,279.23 22,792.34 0.00 1.1739293764

Exercise 1

Exercise 1
Loan: 120,000
Term: 10 year
Interest 10.0% annually
Payment 26,546.99 annually
Year Beg Bal Pmt factor Payment Interest Principal End bal. factor
0 120,000.00 4.5202865983
1 120,000.00 30% 7,964.10 12,000.00 -4,035.90 124,035.90 0.2727272727
2 124,035.90 45% 11,946.15 12,403.59 -457.45 124,493.35 0.3719008264
3 124,493.35 60% 15,928.19 12,449.33 3,478.86 121,014.49 0.4507888805
4 121,014.49 75% 19,910.24 12,101.45 7,808.79 113,205.70 0.5122600915
5 113,205.70 90% 23,892.29 11,320.57 12,571.72 100,633.98 0.5588291908
6 100,633.98 100% 26,546.99 10,063.40 16,483.59 84,150.38 0.5644739301
7 84,150.38 100% 26,546.99 8,415.04 18,131.95 66,018.43 0.5131581182
8 66,018.43 100% 26,546.99 6,601.84 19,945.15 46,073.29 0.4665073802
9 46,073.29 100% 26,546.99 4,607.33 21,939.66 24,133.63 0.4240976184
10 24,133.63 100% 26,546.99 2,413.36 24,133.63 -0.00 0.3855432894

Exercise 2

Exercise 2: Graudated Payment Mortgage
Loan: 120,000
Term: 10 year PMT Growth 10%
Interest 10.0% annually
Payment 14,394.98 annually
Year Beg Bal Growth factor Payment Interest Principal End bal. factor
0 120,000.00 8.3362413149
1 120,000.00 1.00000 14,394.98 12,000.00 2,394.98 117,605.02 0.9090909091
2 117,605.02 1.10000 15,834.47 11,760.50 4,073.97 113,531.05 0.9090909091
3 113,531.05 1.21000 17,417.92 11,353.11 6,064.82 107,466.23 0.9090909091
4 107,466.23 1.33100 19,159.71 10,746.62 8,413.09 99,053.14 0.9090909091
5 99,053.14 1.46410 21,075.69 9,905.31 11,170.37 87,882.77 0.9090909091
6 87,882.77 1.61051 23,183.25 8,788.28 14,394.98 73,487.80 0.9090909091
7 73,487.80 1.61051 23,183.25 7,348.78 15,834.47 57,653.32 0.826446281
8 57,653.32 1.61051 23,183.25 5,765.33 17,417.92 40,235.40 0.7513148009
9 40,235.40 1.61051 23,183.25 4,023.54 19,159.71 21,075.69 0.6830134554
10 21,075.69 1.61051 23,183.25 2,107.57 21,075.69 -0.00 0.6209213231