# Finance Solved Homework Solution Sample

QUESTION

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