Finance Solved Homework Solution Sample

QUESTION

ANSWER

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)

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

Nominal Interest rate

0.027%

(Simple nterst rate = (Total annuity payment- fixed annuity payment)/(no. of years*Fixed annuity*100)

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)

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)

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)

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