Finance Solved Homework Solution Sample

QUESTION

 

ANSWER

 

1)

Cost of house  $         3,87,500.00
Cash Payment 20%
Loan tenure 30 years
Interest rate 4.50%
Principal amount  $         3,10,000.00
EMI  $             -1,570.72 Monthly Interest 0.375%
Down payment  $            77,500.00 Cost of house  after 5 year

 

Sr. No EMI Interest paid Principal payment Beginning Balance Ending Balance
1  $              1,570.72  $                                    1,162.50  $                    408.22  $            3,10,000.00  $                  3,09,591.78
2  $              1,570.72  $                                    1,160.97  $                    409.76  $            3,09,591.78  $                  3,09,182.02
3  $              1,570.72  $                                    1,159.43  $                    411.29  $            3,09,182.02  $                  3,08,770.73
4  $              1,570.72  $                                    1,157.89  $                    412.83  $            3,08,770.73  $                  3,08,357.89
5  $              1,570.72  $                                    1,156.34  $                    414.38  $            3,08,357.89  $                  3,07,943.51
6  $              1,570.72  $                                    1,154.79  $                    415.94  $            3,07,943.51  $                  3,07,527.58
7  $              1,570.72  $                                    1,153.23  $                    417.50  $            3,07,527.58  $                  3,07,110.08
8  $              1,570.72  $                                    1,151.66  $                    419.06  $            3,07,110.08  $                  3,06,691.02
9  $              1,570.72  $                                    1,150.09  $                    420.63  $            3,06,691.02  $                  3,06,270.38
10  $              1,570.72  $                                    1,148.51  $                    422.21  $            3,06,270.38  $                  3,05,848.17
11  $              1,570.72  $                                    1,146.93  $                    423.79  $            3,05,848.17  $                  3,05,424.38
12  $              1,570.72  $                                    1,145.34  $                    425.38  $            3,05,424.38  $                  3,04,999.00
13  $              1,570.72  $                                    1,143.75  $                    426.98  $            3,04,999.00  $                  3,04,572.02
14  $              1,570.72  $                                    1,142.15  $                    428.58  $            3,04,572.02  $                  3,04,143.44
15  $              1,570.72  $                                    1,140.54  $                    430.19  $            3,04,143.44  $                  3,03,713.25
16  $              1,570.72  $                                    1,138.92  $                    431.80  $            3,03,713.25  $                  3,03,281.45
17  $              1,570.72  $                                    1,137.31  $                    433.42  $            3,03,281.45  $                  3,02,848.03
18  $              1,570.72  $                                    1,135.68  $                    435.04  $            3,02,848.03  $                  3,02,412.99
19  $              1,570.72  $                                    1,134.05  $                    436.68  $            3,02,412.99  $                  3,01,976.31
20  $              1,570.72  $                                    1,132.41  $                    438.31  $            3,01,976.31  $                  3,01,538.00
21  $              1,570.72  $                                    1,130.77  $                    439.96  $            3,01,538.00  $                  3,01,098.04
22  $              1,570.72  $                                    1,129.12  $                    441.61  $            3,01,098.04  $                  3,00,656.44
23  $              1,570.72  $                                    1,127.46  $                    443.26  $            3,00,656.44  $                  3,00,213.17
24  $              1,570.72  $                                    1,125.80  $                    444.93  $            3,00,213.17  $                  2,99,768.25
25  $              1,570.72  $                                    1,124.13  $                    446.59  $            2,99,768.25  $                  2,99,321.66
26  $              1,570.72  $                                    1,122.46  $                    448.27  $            2,99,321.66  $                  2,98,873.39
27  $              1,570.72  $                                    1,120.78  $                    449.95  $            2,98,873.39  $                  2,98,423.44
28  $              1,570.72  $                                    1,119.09  $                    451.64  $            2,98,423.44  $                  2,97,971.80
29  $              1,570.72  $                                    1,117.39  $                    453.33  $            2,97,971.80  $                  2,97,518.47
30  $              1,570.72  $                                    1,115.69  $                    455.03  $            2,97,518.47  $                  2,97,063.44
31  $              1,570.72  $                                    1,113.99  $                    456.74  $            2,97,063.44  $                  2,96,606.70
32  $              1,570.72  $                                    1,112.28  $                    458.45  $            2,96,606.70  $                  2,96,148.26
33  $              1,570.72  $                                    1,110.56  $                    460.17  $            2,96,148.26  $                  2,95,688.09
34  $              1,570.72  $                                    1,108.83  $                    461.89  $            2,95,688.09  $                  2,95,226.19
35  $              1,570.72  $                                    1,107.10  $                    463.63  $            2,95,226.19  $                  2,94,762.57
36  $              1,570.72  $                                    1,105.36  $                    465.36  $            2,94,762.57  $                  2,94,297.20
37  $              1,570.72  $                                    1,103.61  $                    467.11  $            2,94,297.20  $                  2,93,830.09
38  $              1,570.72  $                                    1,101.86  $                    468.86  $            2,93,830.09  $                  2,93,361.23
39  $              1,570.72  $                                    1,100.10  $                    470.62  $            2,93,361.23  $                  2,92,890.61
40  $              1,570.72  $                                    1,098.34  $                    472.38  $            2,92,890.61  $                  2,92,418.23
41  $              1,570.72  $                                    1,096.57  $                    474.16  $            2,92,418.23  $                  2,91,944.07
42  $              1,570.72  $                                    1,094.79  $                    475.93  $            2,91,944.07  $                  2,91,468.14
43  $              1,570.72  $                                    1,093.01  $                    477.72  $            2,91,468.14  $                  2,90,990.42
44  $              1,570.72  $                                    1,091.21  $                    479.51  $            2,90,990.42  $                  2,90,510.91
45  $              1,570.72  $                                    1,089.42  $                    481.31  $            2,90,510.91  $                  2,90,029.60
46  $              1,570.72  $                                    1,087.61  $                    483.11  $            2,90,029.60  $                  2,89,546.48
47  $              1,570.72  $                                    1,085.80  $                    484.93  $            2,89,546.48  $                  2,89,061.56
48  $              1,570.72  $                                    1,083.98  $                    486.74  $            2,89,061.56  $                  2,88,574.82
49  $              1,570.72  $                                    1,082.16  $                    488.57  $            2,88,574.82  $                  2,88,086.25
50  $              1,570.72  $                                    1,080.32  $                    490.40  $            2,88,086.25  $                  2,87,595.85
51  $              1,570.72  $                                    1,078.48  $                    492.24  $            2,87,595.85  $                  2,87,103.61
52  $              1,570.72  $                                    1,076.64  $                    494.09  $            2,87,103.61  $                  2,86,609.52
53  $              1,570.72  $                                    1,074.79  $                    495.94  $            2,86,609.52  $                  2,86,113.58
54  $              1,570.72  $                                    1,072.93  $                    497.80  $            2,86,113.58  $                  2,85,615.78
55  $              1,570.72  $                                    1,071.06  $                    499.67  $            2,85,615.78  $                  2,85,116.12
56  $              1,570.72  $                                    1,069.19  $                    501.54  $            2,85,116.12  $                  2,84,614.58
57  $              1,570.72  $                                    1,067.30  $                    503.42  $            2,84,614.58  $                  2,84,111.16
58  $              1,570.72  $                                    1,065.42  $                    505.31  $            2,84,111.16  $                  2,83,605.85
59  $              1,570.72  $                                    1,063.52  $                    507.20  $            2,83,605.85  $                  2,83,098.65
60  $              1,570.72  $                                    1,061.62  $                    509.10  $            2,83,098.65  $                  2,82,589.54
61  $              1,570.72  $                                    1,059.71  $                    511.01  $            2,82,589.54  $                  2,82,078.53
62  $              1,570.72  $                                    1,057.79  $                    512.93  $            2,82,078.53  $                  2,81,565.60
63  $              1,570.72  $                                    1,055.87  $                    514.85  $            2,81,565.60  $                  2,81,050.75
64  $              1,570.72  $                                    1,053.94  $                    516.78  $            2,81,050.75  $                  2,80,533.96
65  $              1,570.72  $                                    1,052.00  $                    518.72  $            2,80,533.96  $                  2,80,015.24
66  $              1,570.72  $                                    1,050.06  $                    520.67  $            2,80,015.24  $                  2,79,494.57
67  $              1,570.72  $                                    1,048.10  $                    522.62  $            2,79,494.57  $                  2,78,971.95
68  $              1,570.72  $                                    1,046.14  $                    524.58  $            2,78,971.95  $                  2,78,447.37
69  $              1,570.72  $                                    1,044.18  $                    526.55  $            2,78,447.37  $                  2,77,920.83
70  $              1,570.72  $                                    1,042.20  $                    528.52  $            2,77,920.83  $                  2,77,392.30
71  $              1,570.72  $                                    1,040.22  $                    530.50  $            2,77,392.30  $                  2,76,861.80
72  $              1,570.72  $                                    1,038.23  $                    532.49  $            2,76,861.80  $                  2,76,329.31
73  $              1,570.72  $                                    1,036.23  $                    534.49  $            2,76,329.31  $                  2,75,794.82
74  $              1,570.72  $                                    1,034.23  $                    536.49  $            2,75,794.82  $                  2,75,258.33
75  $              1,570.72  $                                    1,032.22  $                    538.51  $            2,75,258.33  $                  2,74,719.82
76  $              1,570.72  $                                    1,030.20  $                    540.53  $            2,74,719.82  $                  2,74,179.29
77  $              1,570.72  $                                    1,028.17  $                    542.55  $            2,74,179.29  $                  2,73,636.74
78  $              1,570.72  $                                    1,026.14  $                    544.59  $            2,73,636.74  $                  2,73,092.16
79  $              1,570.72  $                                    1,024.10  $                    546.63  $            2,73,092.16  $                  2,72,545.53
80  $              1,570.72  $                                    1,022.05  $                    548.68  $            2,72,545.53  $                  2,71,996.85
81  $              1,570.72  $                                    1,019.99  $                    550.74  $            2,71,996.85  $                  2,71,446.11
82  $              1,570.72  $                                    1,017.92  $                    552.80  $            2,71,446.11  $                  2,70,893.31
83  $              1,570.72  $                                    1,015.85  $                    554.87  $            2,70,893.31  $                  2,70,338.44
84  $              1,570.72  $                                    1,013.77  $                    556.96  $            2,70,338.44  $                  2,69,781.48
85  $              1,570.72  $                                    1,011.68  $                    559.04  $            2,69,781.48  $                  2,69,222.44
86  $              1,570.72  $                                    1,009.58  $                    561.14  $            2,69,222.44  $                  2,68,661.30
87  $              1,570.72  $                                    1,007.48  $                    563.24  $            2,68,661.30  $                  2,68,098.05
88  $              1,570.72  $                                    1,005.37  $                    565.36  $            2,68,098.05  $                  2,67,532.69
89  $              1,570.72  $                                    1,003.25  $                    567.48  $            2,67,532.69  $                  2,66,965.22
90  $              1,570.72  $                                    1,001.12  $                    569.60  $            2,66,965.22  $                  2,66,395.61
91  $              1,570.72  $                                        998.98  $                    571.74  $            2,66,395.61  $                  2,65,823.87
92  $              1,570.72  $                                        996.84  $                    573.88  $            2,65,823.87  $                  2,65,249.99
93  $              1,570.72  $                                        994.69  $                    576.04  $            2,65,249.99  $                  2,64,673.95
94  $              1,570.72  $                                        992.53  $                    578.20  $            2,64,673.95  $                  2,64,095.75
95  $              1,570.72  $                                        990.36  $                    580.37  $            2,64,095.75  $                  2,63,515.39
96  $              1,570.72  $                                        988.18  $                    582.54  $            2,63,515.39  $                  2,62,932.85
97  $              1,570.72  $                                        986.00  $                    584.73  $            2,62,932.85  $                  2,62,348.12
98  $              1,570.72  $                                        983.81  $                    586.92  $            2,62,348.12  $                  2,61,761.20
99  $              1,570.72  $                                        981.60  $                    589.12  $            2,61,761.20  $                  2,61,172.08
100  $              1,570.72  $                                        979.40  $                    591.33  $            2,61,172.08  $                  2,60,580.75
101  $              1,570.72  $                                        977.18  $                    593.55  $            2,60,580.75  $                  2,59,987.20
102  $              1,570.72  $                                        974.95  $                    595.77  $            2,59,987.20  $                  2,59,391.43
103  $              1,570.72  $                                        972.72  $                    598.01  $            2,59,391.43  $                  2,58,793.43
104  $              1,570.72  $                                        970.48  $                    600.25  $            2,58,793.43  $                  2,58,193.18
105  $              1,570.72  $                                        968.22  $                    602.50  $            2,58,193.18  $                  2,57,590.68
106  $              1,570.72  $                                        965.97  $                    604.76  $            2,57,590.68  $                  2,56,985.92
107  $              1,570.72  $                                        963.70  $                    607.03  $            2,56,985.92  $                  2,56,378.89
108  $              1,570.72  $                                        961.42  $                    609.30  $            2,56,378.89  $                  2,55,769.59
109  $              1,570.72  $                                        959.14  $                    611.59  $            2,55,769.59  $                  2,55,158.00
110  $              1,570.72  $                                        956.84  $                    613.88  $            2,55,158.00  $                  2,54,544.12
111  $              1,570.72  $                                        954.54  $                    616.18  $            2,54,544.12  $                  2,53,927.93
112  $              1,570.72  $                                        952.23  $                    618.49  $            2,53,927.93  $                  2,53,309.44
113  $              1,570.72  $                                        949.91  $                    620.81  $            2,53,309.44  $                  2,52,688.62
114  $              1,570.72  $                                        947.58  $                    623.14  $            2,52,688.62  $                  2,52,065.48
115  $              1,570.72  $                                        945.25  $                    625.48  $            2,52,065.48  $                  2,51,440.00
116  $              1,570.72  $                                        942.90  $                    627.82  $            2,51,440.00  $                  2,50,812.18
117  $              1,570.72  $                                        940.55  $                    630.18  $            2,50,812.18  $                  2,50,182.00
118  $              1,570.72  $                                        938.18  $                    632.54  $            2,50,182.00  $                  2,49,549.46
119  $              1,570.72  $                                        935.81  $                    634.91  $            2,49,549.46  $                  2,48,914.54
120  $              1,570.72  $                                        933.43  $                    637.29  $            2,48,914.54  $                  2,48,277.25
121  $              1,570.72  $                                        931.04  $                    639.68  $            2,48,277.25  $                  2,47,637.56
122  $              1,570.72  $                                        928.64  $                    642.08  $            2,47,637.56  $                  2,46,995.48
123  $              1,570.72  $                                        926.23  $                    644.49  $            2,46,995.48  $                  2,46,350.99
124  $              1,570.72  $                                        923.82  $                    646.91  $            2,46,350.99  $                  2,45,704.08
125  $              1,570.72  $                                        921.39  $                    649.33  $            2,45,704.08  $                  2,45,054.75
126  $              1,570.72  $                                        918.96  $                    651.77  $            2,45,054.75  $                  2,44,402.98
127  $              1,570.72  $                                        916.51  $                    654.21  $            2,44,402.98  $                  2,43,748.76
128  $              1,570.72  $                                        914.06  $                    656.67  $            2,43,748.76  $                  2,43,092.10
129  $              1,570.72  $                                        911.60  $                    659.13  $            2,43,092.10  $                  2,42,432.97
130  $              1,570.72  $                                        909.12  $                    661.60  $            2,42,432.97  $                  2,41,771.37
131  $              1,570.72  $                                        906.64  $                    664.08  $            2,41,771.37  $                  2,41,107.28
132  $              1,570.72  $                                        904.15  $                    666.57  $            2,41,107.28  $                  2,40,440.71
133  $              1,570.72  $                                        901.65  $                    669.07  $            2,40,440.71  $                  2,39,771.64
134  $              1,570.72  $                                        899.14  $                    671.58  $            2,39,771.64  $                  2,39,100.06
135  $              1,570.72  $                                        896.63  $                    674.10  $            2,39,100.06  $                  2,38,425.96
136  $              1,570.72  $                                        894.10  $                    676.63  $            2,38,425.96  $                  2,37,749.33
137  $              1,570.72  $                                        891.56  $                    679.16  $            2,37,749.33  $                  2,37,070.17
138  $              1,570.72  $                                        889.01  $                    681.71  $            2,37,070.17  $                  2,36,388.46
139  $              1,570.72  $                                        886.46  $                    684.27  $            2,36,388.46  $                  2,35,704.19
140  $              1,570.72  $                                        883.89  $                    686.83  $            2,35,704.19  $                  2,35,017.36
141  $              1,570.72  $                                        881.32  $                    689.41  $            2,35,017.36  $                  2,34,327.95
142  $              1,570.72  $                                        878.73  $                    691.99  $            2,34,327.95  $                  2,33,635.95
143  $              1,570.72  $                                        876.13  $                    694.59  $            2,33,635.95  $                  2,32,941.36
144  $              1,570.72  $                                        873.53  $                    697.19  $            2,32,941.36  $                  2,32,244.17
145  $              1,570.72  $                                        870.92  $                    699.81  $            2,32,244.17  $                  2,31,544.36
146  $              1,570.72  $                                        868.29  $                    702.43  $            2,31,544.36  $                  2,30,841.93
147  $              1,570.72  $                                        865.66  $                    705.07  $            2,30,841.93  $                  2,30,136.86
148  $              1,570.72  $                                        863.01  $                    707.71  $            2,30,136.86  $                  2,29,429.15
149  $              1,570.72  $                                        860.36  $                    710.37  $            2,29,429.15  $                  2,28,718.78
150  $              1,570.72  $                                        857.70  $                    713.03  $            2,28,718.78  $                  2,28,005.75
151  $              1,570.72  $                                        855.02  $                    715.70  $            2,28,005.75  $                  2,27,290.05
152  $              1,570.72  $                                        852.34  $                    718.39  $            2,27,290.05  $                  2,26,571.66
153  $              1,570.72  $                                        849.64  $                    721.08  $            2,26,571.66  $                  2,25,850.58
154  $              1,570.72  $                                        846.94  $                    723.78  $            2,25,850.58  $                  2,25,126.80
155  $              1,570.72  $                                        844.23  $                    726.50  $            2,25,126.80  $                  2,24,400.30
156  $              1,570.72  $                                        841.50  $                    729.22  $            2,24,400.30  $                  2,23,671.08
157  $              1,570.72  $                                        838.77  $                    731.96  $            2,23,671.08  $                  2,22,939.12
158  $              1,570.72  $                                        836.02  $                    734.70  $            2,22,939.12  $                  2,22,204.42
159  $              1,570.72  $                                        833.27  $                    737.46  $            2,22,204.42  $                  2,21,466.96
160  $              1,570.72  $                                        830.50  $                    740.22  $            2,21,466.96  $                  2,20,726.73
161  $              1,570.72  $                                        827.73  $                    743.00  $            2,20,726.73  $                  2,19,983.74
162  $              1,570.72  $                                        824.94  $                    745.79  $            2,19,983.74  $                  2,19,237.95
163  $              1,570.72  $                                        822.14  $                    748.58  $            2,19,237.95  $                  2,18,489.37
164  $              1,570.72  $                                        819.34  $                    751.39  $            2,18,489.37  $                  2,17,737.98
165  $              1,570.72  $                                        816.52  $                    754.21  $            2,17,737.98  $                  2,16,983.77
166  $              1,570.72  $                                        813.69  $                    757.04  $            2,16,983.77  $                  2,16,226.74
167  $              1,570.72  $                                        810.85  $                    759.87  $            2,16,226.74  $                  2,15,466.86
168  $              1,570.72  $                                        808.00  $                    762.72  $            2,15,466.86  $                  2,14,704.14
169  $              1,570.72  $                                        805.14  $                    765.58  $            2,14,704.14  $                  2,13,938.55
170  $              1,570.72  $                                        802.27  $                    768.45  $            2,13,938.55  $                  2,13,170.10
171  $              1,570.72  $                                        799.39  $                    771.34  $            2,13,170.10  $                  2,12,398.76
172  $              1,570.72  $                                        796.50  $                    774.23  $            2,12,398.76  $                  2,11,624.53
173  $              1,570.72  $                                        793.59  $                    777.13  $            2,11,624.53  $                  2,10,847.40
174  $              1,570.72  $                                        790.68  $                    780.05  $            2,10,847.40  $                  2,10,067.35
175  $              1,570.72  $                                        787.75  $                    782.97  $            2,10,067.35  $                  2,09,284.38
176  $              1,570.72  $                                        784.82  $                    785.91  $            2,09,284.38  $                  2,08,498.47
177  $              1,570.72  $                                        781.87  $                    788.86  $            2,08,498.47  $                  2,07,709.62
178  $              1,570.72  $                                        778.91  $                    791.81  $            2,07,709.62  $                  2,06,917.81
179  $              1,570.72  $                                        775.94  $                    794.78  $            2,06,917.81  $                  2,06,123.02
180  $              1,570.72  $                                        772.96  $                    797.76  $            2,06,123.02  $                  2,05,325.26
181  $              1,570.72  $                                        769.97  $                    800.75  $            2,05,325.26  $                  2,04,524.51
182  $              1,570.72  $                                        766.97  $                    803.76  $            2,04,524.51  $                  2,03,720.75
183  $              1,570.72  $                                        763.95  $                    806.77  $            2,03,720.75  $                  2,02,913.98
184  $              1,570.72  $                                        760.93  $                    809.80  $            2,02,913.98  $                  2,02,104.18
185  $              1,570.72  $                                        757.89  $                    812.83  $            2,02,104.18  $                  2,01,291.35
186  $              1,570.72  $                                        754.84  $                    815.88  $            2,01,291.35  $                  2,00,475.46
187  $              1,570.72  $                                        751.78  $                    818.94  $            2,00,475.46  $                  1,99,656.52
188  $              1,570.72  $                                        748.71  $                    822.01  $            1,99,656.52  $                  1,98,834.51
189  $              1,570.72  $                                        745.63  $                    825.10  $            1,98,834.51  $                  1,98,009.41
190  $              1,570.72  $                                        742.54  $                    828.19  $            1,98,009.41  $                  1,97,181.23
191  $              1,570.72  $                                        739.43  $                    831.29  $            1,97,181.23  $                  1,96,349.93
192  $              1,570.72  $                                        736.31  $                    834.41  $            1,96,349.93  $                  1,95,515.52
193  $              1,570.72  $                                        733.18  $                    837.54  $            1,95,515.52  $                  1,94,677.98
194  $              1,570.72  $                                        730.04  $                    840.68  $            1,94,677.98  $                  1,93,837.29
195  $              1,570.72  $                                        726.89  $                    843.83  $            1,93,837.29  $                  1,92,993.46
196  $              1,570.72  $                                        723.73  $                    847.00  $            1,92,993.46  $                  1,92,146.46
197  $              1,570.72  $                                        720.55  $                    850.18  $            1,92,146.46  $                  1,91,296.29
198  $              1,570.72  $                                        717.36  $                    853.36  $            1,91,296.29  $                  1,90,442.92
199  $              1,570.72  $                                        714.16  $                    856.56  $            1,90,442.92  $                  1,89,586.36
200  $              1,570.72  $                                        710.95  $                    859.78  $            1,89,586.36  $                  1,88,726.58
201  $              1,570.72  $                                        707.72  $                    863.00  $            1,88,726.58  $                  1,87,863.58
202  $              1,570.72  $                                        704.49  $                    866.24  $            1,87,863.58  $                  1,86,997.35
203  $              1,570.72  $                                        701.24  $                    869.48  $            1,86,997.35  $                  1,86,127.86
204  $              1,570.72  $                                        697.98  $                    872.74  $            1,86,127.86  $                  1,85,255.12
205  $              1,570.72  $                                        694.71  $                    876.02  $            1,85,255.12  $                  1,84,379.10
206  $              1,570.72  $                                        691.42  $                    879.30  $            1,84,379.10  $                  1,83,499.80
207  $              1,570.72  $                                        688.12  $                    882.60  $            1,83,499.80  $                  1,82,617.20
208  $              1,570.72  $                                        684.81  $                    885.91  $            1,82,617.20  $                  1,81,731.29
209  $              1,570.72  $                                        681.49  $                    889.23  $            1,81,731.29  $                  1,80,842.06
210  $              1,570.72  $                                        678.16  $                    892.57  $            1,80,842.06  $                  1,79,949.49
211  $              1,570.72  $                                        674.81  $                    895.91  $            1,79,949.49  $                  1,79,053.57
212  $              1,570.72  $                                        671.45  $                    899.27  $            1,79,053.57  $                  1,78,154.30
213  $              1,570.72  $                                        668.08  $                    902.65  $            1,78,154.30  $                  1,77,251.66
214  $              1,570.72  $                                        664.69  $                    906.03  $            1,77,251.66  $                  1,76,345.62
215  $              1,570.72  $                                        661.30  $                    909.43  $            1,76,345.62  $                  1,75,436.20
216  $              1,570.72  $                                        657.89  $                    912.84  $            1,75,436.20  $                  1,74,523.36
217  $              1,570.72  $                                        654.46  $                    916.26  $            1,74,523.36  $                  1,73,607.10
218  $              1,570.72  $                                        651.03  $                    919.70  $            1,73,607.10  $                  1,72,687.40
219  $              1,570.72  $                                        647.58  $                    923.15  $            1,72,687.40  $                  1,71,764.25
220  $              1,570.72  $                                        644.12  $                    926.61  $            1,71,764.25  $                  1,70,837.64
221  $              1,570.72  $                                        640.64  $                    930.08  $            1,70,837.64  $                  1,69,907.56
222  $              1,570.72  $                                        637.15  $                    933.57  $            1,69,907.56  $                  1,68,973.99
223  $              1,570.72  $                                        633.65  $                    937.07  $            1,68,973.99  $                  1,68,036.92
224  $              1,570.72  $                                        630.14  $                    940.59  $            1,68,036.92  $                  1,67,096.33
225  $              1,570.72  $                                        626.61  $                    944.11  $            1,67,096.33  $                  1,66,152.22
226  $              1,570.72  $                                        623.07  $                    947.65  $            1,66,152.22  $                  1,65,204.56
227  $              1,570.72  $                                        619.52  $                    951.21  $            1,65,204.56  $                  1,64,253.36
228  $              1,570.72  $                                        615.95  $                    954.77  $            1,64,253.36  $                  1,63,298.58
229  $              1,570.72  $                                        612.37  $                    958.35  $            1,63,298.58  $                  1,62,340.23
230  $              1,570.72  $                                        608.78  $                    961.95  $            1,62,340.23  $                  1,61,378.28
231  $              1,570.72  $                                        605.17  $                    965.56  $            1,61,378.28  $                  1,60,412.72
232  $              1,570.72  $                                        601.55  $                    969.18  $            1,60,412.72  $                  1,59,443.55
233  $              1,570.72  $                                        597.91  $                    972.81  $            1,59,443.55  $                  1,58,470.73
234  $              1,570.72  $                                        594.27  $                    976.46  $            1,58,470.73  $                  1,57,494.28
235  $              1,570.72  $                                        590.60  $                    980.12  $            1,57,494.28  $                  1,56,514.15
236  $              1,570.72  $                                        586.93  $                    983.80  $            1,56,514.15  $                  1,55,530.36
237  $              1,570.72  $                                        583.24  $                    987.49  $            1,55,530.36  $                  1,54,542.87
238  $              1,570.72  $                                        579.54  $                    991.19  $            1,54,542.87  $                  1,53,551.68
239  $              1,570.72  $                                        575.82  $                    994.91  $            1,53,551.68  $                  1,52,556.78
240  $              1,570.72  $                                        572.09  $                    998.64  $            1,52,556.78  $                  1,51,558.14
241  $              1,570.72  $                                        568.34  $                 1,002.38  $            1,51,558.14  $                  1,50,555.76
242  $              1,570.72  $                                        564.58  $                 1,006.14  $            1,50,555.76  $                  1,49,549.62
243  $              1,570.72  $                                        560.81  $                 1,009.91  $            1,49,549.62  $                  1,48,539.71
244  $              1,570.72  $                                        557.02  $                 1,013.70  $            1,48,539.71  $                  1,47,526.01
245  $              1,570.72  $                                        553.22  $                 1,017.50  $            1,47,526.01  $                  1,46,508.50
246  $              1,570.72  $                                        549.41  $                 1,021.32  $            1,46,508.50  $                  1,45,487.19
247  $              1,570.72  $                                        545.58  $                 1,025.15  $            1,45,487.19  $                  1,44,462.04
248  $              1,570.72  $                                        541.73  $                 1,028.99  $            1,44,462.04  $                  1,43,433.05
249  $              1,570.72  $                                        537.87  $                 1,032.85  $            1,43,433.05  $                  1,42,400.20
250  $              1,570.72  $                                        534.00  $                 1,036.72  $            1,42,400.20  $                  1,41,363.47
251  $              1,570.72  $                                        530.11  $                 1,040.61  $            1,41,363.47  $                  1,40,322.86
252  $              1,570.72  $                                        526.21  $                 1,044.51  $            1,40,322.86  $                  1,39,278.35
253  $              1,570.72  $                                        522.29  $                 1,048.43  $            1,39,278.35  $                  1,38,229.92
254  $              1,570.72  $                                        518.36  $                 1,052.36  $            1,38,229.92  $                  1,37,177.55
255  $              1,570.72  $                                        514.42  $                 1,056.31  $            1,37,177.55  $                  1,36,121.25
256  $              1,570.72  $                                        510.45  $                 1,060.27  $            1,36,121.25  $                  1,35,060.98
257  $              1,570.72  $                                        506.48  $                 1,064.25  $            1,35,060.98  $                  1,33,996.73
258  $              1,570.72  $                                        502.49  $                 1,068.24  $            1,33,996.73  $                  1,32,928.49
259  $              1,570.72  $                                        498.48  $                 1,072.24  $            1,32,928.49  $                  1,31,856.25
260  $              1,570.72  $                                        494.46  $                 1,076.26  $            1,31,856.25  $                  1,30,779.99
261  $              1,570.72  $                                        490.42  $                 1,080.30  $            1,30,779.99  $                  1,29,699.69
262  $              1,570.72  $                                        486.37  $                 1,084.35  $            1,29,699.69  $                  1,28,615.34
263  $              1,570.72  $                                        482.31  $                 1,088.42  $            1,28,615.34  $                  1,27,526.92
264  $              1,570.72  $                                        478.23  $                 1,092.50  $            1,27,526.92  $                  1,26,434.42
265  $              1,570.72  $                                        474.13  $                 1,096.60  $            1,26,434.42  $                  1,25,337.83
266  $              1,570.72  $                                        470.02  $                 1,100.71  $            1,25,337.83  $                  1,24,237.12
267  $              1,570.72  $                                        465.89  $                 1,104.84  $            1,24,237.12  $                  1,23,132.28
268  $              1,570.72  $                                        461.75  $                 1,108.98  $            1,23,132.28  $                  1,22,023.31
269  $              1,570.72  $                                        457.59  $                 1,113.14  $            1,22,023.31  $                  1,20,910.17
270  $              1,570.72  $                                        453.41  $                 1,117.31  $            1,20,910.17  $                  1,19,792.86
271  $              1,570.72  $                                        449.22  $                 1,121.50  $            1,19,792.86  $                  1,18,671.36
272  $              1,570.72  $                                        445.02  $                 1,125.71  $            1,18,671.36  $                  1,17,545.65
273  $              1,570.72  $                                        440.80  $                 1,129.93  $            1,17,545.65  $                  1,16,415.72
274  $              1,570.72  $                                        436.56  $                 1,134.17  $            1,16,415.72  $                  1,15,281.55
275  $              1,570.72  $                                        432.31  $                 1,138.42  $            1,15,281.55  $                  1,14,143.14
276  $              1,570.72  $                                        428.04  $                 1,142.69  $            1,14,143.14  $                  1,13,000.45
277  $              1,570.72  $                                        423.75  $                 1,146.97  $            1,13,000.45  $                  1,11,853.48
278  $              1,570.72  $                                        419.45  $                 1,151.27  $            1,11,853.48  $                  1,10,702.20
279  $              1,570.72  $                                        415.13  $                 1,155.59  $            1,10,702.20  $                  1,09,546.61
280  $              1,570.72  $                                        410.80  $                 1,159.92  $            1,09,546.61  $                  1,08,386.69
281  $              1,570.72  $                                        406.45  $                 1,164.27  $            1,08,386.69  $                  1,07,222.41
282  $              1,570.72  $                                        402.08  $                 1,168.64  $            1,07,222.41  $                  1,06,053.77
283  $              1,570.72  $                                        397.70  $                 1,173.02  $            1,06,053.77  $                  1,04,880.75
284  $              1,570.72  $                                        393.30  $                 1,177.42  $            1,04,880.75  $                  1,03,703.33
285  $              1,570.72  $                                        388.89  $                 1,181.84  $            1,03,703.33  $                  1,02,521.49
286  $              1,570.72  $                                        384.46  $                 1,186.27  $            1,02,521.49  $                  1,01,335.22
287  $              1,570.72  $                                        380.01  $                 1,190.72  $            1,01,335.22  $                  1,00,144.50
288  $              1,570.72  $                                        375.54  $                 1,195.18  $            1,00,144.50  $                     98,949.32
289  $              1,570.72  $                                        371.06  $                 1,199.66  $               98,949.32  $                     97,749.66
290  $              1,570.72  $                                        366.56  $                 1,204.16  $               97,749.66  $                     96,545.49
291  $              1,570.72  $                                        362.05  $                 1,208.68  $               96,545.49  $                     95,336.81
292  $              1,570.72  $                                        357.51  $                 1,213.21  $               95,336.81  $                     94,123.60
293  $              1,570.72  $                                        352.96  $                 1,217.76  $               94,123.60  $                     92,905.84
294  $              1,570.72  $                                        348.40  $                 1,222.33  $               92,905.84  $                     91,683.51
295  $              1,570.72  $                                        343.81  $                 1,226.91  $               91,683.51  $                     90,456.60
296  $              1,570.72  $                                        339.21  $                 1,231.51  $               90,456.60  $                     89,225.09
297  $              1,570.72  $                                        334.59  $                 1,236.13  $               89,225.09  $                     87,988.96
298  $              1,570.72  $                                        329.96  $                 1,240.77  $               87,988.96  $                     86,748.19
299  $              1,570.72  $                                        325.31  $                 1,245.42  $               86,748.19  $                     85,502.78
300  $              1,570.72  $                                        320.64  $                 1,250.09  $               85,502.78  $                     84,252.69
301  $              1,570.72  $                                        315.95  $                 1,254.78  $               84,252.69  $                     82,997.91
302  $              1,570.72  $                                        311.24  $                 1,259.48  $               82,997.91  $                     81,738.43
303  $              1,570.72  $                                        306.52  $                 1,264.21  $               81,738.43  $                     80,474.22
304  $              1,570.72  $                                        301.78  $                 1,268.95  $               80,474.22  $                     79,205.28
305  $              1,570.72  $                                        297.02  $                 1,273.70  $               79,205.28  $                     77,931.57
306  $              1,570.72  $                                        292.24  $                 1,278.48  $               77,931.57  $                     76,653.09
307  $              1,570.72  $                                        287.45  $                 1,283.28  $               76,653.09  $                     75,369.81
308  $              1,570.72  $                                        282.64  $                 1,288.09  $               75,369.81  $                     74,081.73
309  $              1,570.72  $                                        277.81  $                 1,292.92  $               74,081.73  $                     72,788.81
310  $              1,570.72  $                                        272.96  $                 1,297.77  $               72,788.81  $                     71,491.04
311  $              1,570.72  $                                        268.09  $                 1,302.63  $               71,491.04  $                     70,188.41
312  $              1,570.72  $                                        263.21  $                 1,307.52  $               70,188.41  $                     68,880.89
313  $              1,570.72  $                                        258.30  $                 1,312.42  $               68,880.89  $                     67,568.47
314  $              1,570.72  $                                        253.38  $                 1,317.34  $               67,568.47  $                     66,251.13
315  $              1,570.72  $                                        248.44  $                 1,322.28  $               66,251.13  $                     64,928.85
316  $              1,570.72  $                                        243.48  $                 1,327.24  $               64,928.85  $                     63,601.60
317  $              1,570.72  $                                        238.51  $                 1,332.22  $               63,601.60  $                     62,269.39
318  $              1,570.72  $                                        233.51  $                 1,337.21  $               62,269.39  $                     60,932.17
319  $              1,570.72  $                                        228.50  $                 1,342.23  $               60,932.17  $                     59,589.94
320  $              1,570.72  $                                        223.46  $                 1,347.26  $               59,589.94  $                     58,242.68
321  $              1,570.72  $                                        218.41  $                 1,352.31  $               58,242.68  $                     56,890.37
322  $              1,570.72  $                                        213.34  $                 1,357.39  $               56,890.37  $                     55,532.98
323  $              1,570.72  $                                        208.25  $                 1,362.48  $               55,532.98  $                     54,170.50
324  $              1,570.72  $                                        203.14  $                 1,367.59  $               54,170.50  $                     52,802.92
325  $              1,570.72  $                                        198.01  $                 1,372.71  $               52,802.92  $                     51,430.21
326  $              1,570.72  $                                        192.86  $                 1,377.86  $               51,430.21  $                     50,052.34
327  $              1,570.72  $                                        187.70  $                 1,383.03  $               50,052.34  $                     48,669.32
328  $              1,570.72  $                                        182.51  $                 1,388.21  $               48,669.32  $                     47,281.10
329  $              1,570.72  $                                        177.30  $                 1,393.42  $               47,281.10  $                     45,887.68
330  $              1,570.72  $                                        172.08  $                 1,398.65  $               45,887.68  $                     44,489.04
331  $              1,570.72  $                                        166.83  $                 1,403.89  $               44,489.04  $                     43,085.15
332  $              1,570.72  $                                        161.57  $                 1,409.16  $               43,085.15  $                     41,675.99
333  $              1,570.72  $                                        156.28  $                 1,414.44  $               41,675.99  $                     40,261.55
334  $              1,570.72  $                                        150.98  $                 1,419.74  $               40,261.55  $                     38,841.81
335  $              1,570.72  $                                        145.66  $                 1,425.07  $               38,841.81  $                     37,416.74
336  $              1,570.72  $                                        140.31  $                 1,430.41  $               37,416.74  $                     35,986.33
337  $              1,570.72  $                                        134.95  $                 1,435.78  $               35,986.33  $                     34,550.55
338  $              1,570.72  $                                        129.56  $                 1,441.16  $               34,550.55  $                     33,109.39
339  $              1,570.72  $                                        124.16  $                 1,446.56  $               33,109.39  $                     31,662.83
340  $              1,570.72  $                                        118.74  $                 1,451.99  $               31,662.83  $                     30,210.84
341  $              1,570.72  $                                        113.29  $                 1,457.43  $               30,210.84  $                     28,753.41
342  $              1,570.72  $                                        107.83  $                 1,462.90  $               28,753.41  $                     27,290.51
343  $              1,570.72  $                                        102.34  $                 1,468.39  $               27,290.51  $                     25,822.12
344  $              1,570.72  $                                          96.83  $                 1,473.89  $               25,822.12  $                     24,348.23
345  $              1,570.72  $                                          91.31  $                 1,479.42  $               24,348.23  $                     22,868.81
346  $              1,570.72  $                                          85.76  $                 1,484.97  $               22,868.81  $                     21,383.84
347  $              1,570.72  $                                          80.19  $                 1,490.54  $               21,383.84  $                     19,893.31
348  $              1,570.72  $                                          74.60  $                 1,496.12  $               19,893.31  $                     18,397.19
349  $              1,570.72  $                                          68.99  $                 1,501.74  $               18,397.19  $                     16,895.45
350  $              1,570.72  $                                          63.36  $                 1,507.37  $               16,895.45  $                     15,388.08
351  $              1,570.72  $                                          57.71  $                 1,513.02  $               15,388.08  $                     13,875.06
352  $              1,570.72  $                                          52.03  $                 1,518.69  $               13,875.06  $                     12,356.37
353  $              1,570.72  $                                          46.34  $                 1,524.39  $               12,356.37  $                     10,831.98
354  $              1,570.72  $                                          40.62  $                 1,530.10  $               10,831.98  $                       9,301.88
355  $              1,570.72  $                                          34.88  $                 1,535.84  $                 9,301.88  $                       7,766.04
356  $              1,570.72  $                                          29.12  $                 1,541.60  $                 7,766.04  $                       6,224.43
357  $              1,570.72  $                                          23.34  $                 1,547.38  $                 6,224.43  $                       4,677.05
358  $              1,570.72  $                                          17.54  $                 1,553.19  $                 4,677.05  $                       3,123.87
359  $              1,570.72  $                                          11.71  $                 1,559.01  $                 3,123.87  $                       1,564.86
360  $              1,570.72  $                                            5.87  $                 1,564.86  $                 1,564.86  $                               0.00

 

a. EMI  $                      1,570.72
b. Interest paid in first five years  $                    66,833.01
c. Percentage of interest used in paying on first payment 74.01%
d. Percentage  of interest used in paying fifteith payment 68.78%
e. Loan outstanding after five years  $                2,82,589.54
f. Return on down payment -5.59%

 

(Cost of house = Interest paid + Principal + Downpayment)

 

2)

Annuity payment  $  2,50,000.00
Monthly amount received  $           700.00
Tenure 30
Perpetuity interest rate 4.50%

 

a. Nominal Interest rate 0.027% (Simple nterst rate = (Total annuity payment- fixed annuity payment)/(no. of years*Fixed annuity*100)
b. Effective Interest rate 0.053% (Compounded rate of interest)
c.  & d. Perpetuity coupon yearly  $       11,250.00 (We should go for perpetuity as it gives high annual payment lifetime)
Annuity coupon early  $         8,400.00 (Interst rate is higher than fixed annual perpetuity)

 

3)

Initial investment  $        25,00,000
Rate of return required 12.50%
Amount borrowed  $        15,00,000
Bank rate of interest 6.75%
Investment account interest 13%
New interest rate 8.75%
Year 0 1 2 3 4 5
Cashflows  $                               -25,00,000  $     6,80,000  $                                 8,10,000  $ 9,70,000  $ 9,90,000  $    8,80,000
Cummulative cashflow  $                               -25,00,000  $  -18,20,000  $                             -10,10,000  $   -40,000  $ 9,50,000  $ 18,30,000
a. Payback period 3.04 years
b. NPV  $     4,72,974
c. IRR of the project 20.37% (Good investmetn since project is giving higher return than Required return)
d. Min. Interest required 9.25%
e. New Interst rate for capital 10.45% (Capital cost will increase by 1.2% of interest rate)

 

4)

Stock Number of shares Price per share Beta Share Value Weights
A 150  $                15.00 0.5  $      2,250.00 0.136778
B 200  $                25.00 1.2  $      5,000.00 0.303951
C 300  $                19.00 1.45  $      5,700.00 0.346505
D 100  $                35.00 2  $      3,500.00 0.212766
 $    16,450.00
T.bills yield 2%
S&P 500 returns 7.50%
a. Risky stock in portfolio A
b. Value of portfolio  $          16,450.00
c. Weight of stock C 34.65%
d. Portfolio Beta 1.36
e. Required rate of return for stock A 4.75%
f. Required rate of return for stock C 9.98%
g. Required rate of return from portfolio 9.49%
( Beta coeffecient measures the systemtic risk of stock. Higher the Beta, higher the risk)

 

5)

Dividend 1.35
Price of share 45
Dividend growth rate 5%
Shares outstanding        80,00,000
Next year dividend 1.4175 market value of Equity  $          36,00,00,000
Issue A
No of bonds 10000 Face value  $                  1,000.00 (Assuming a face value of $1000)
Rate 4.50% Present value  $                     973.00
Semiannual Future value  $                  1,000.00
Issued 7 years ago NPER 26
Bond Tenure 20 years Coupon rate 4.50%
Current value 97.30% of par Coupon payment  $                       22.50
Market value of Bond  $          97,30,000.00
Issue B
No of bonds 15000 Face value  $                  1,000.00
Issued 3 years ago Present value  $                     381.00
Bond Tenure 15 Future value  $                  1,000.00
Current value 38.10% of face value NPER (Tenure left) 12
Coupon rate 0.00%
Coupon payment 0
Market value of Bond  $          57,15,000.00
Total debt  $       1,54,45,000.00
Total capital of company  $     37,54,45,000.00
a. Cost of equity 8.15%
b. YTM of bond A 4.78%
c. YTM of bond B 8.37%
d. Cost of debt 6.11%
e. Weight of equity 95.89%
f. Cost of capital 8.07%

(Dividend capitalization model)

 

Looking for Finance Assignment Help. Whatsapp us at +16469488918 or chat with our chat representative showing on lower right corner or order from here. You can also take help from our Live Assignment helper for any exam or live assignment related assistance