cuadro de amortizacion

9
n cuota mensual abono a intereses abono a capital saldo 0 $ 72,000.00 1 $ 1,279.90 $ 1,260.00 $ 19.90 $ 71,980.10 2 $ 1,279.90 $ 1,259.65 $ 20.25 $ 71,959.85 3 $ 1,279.90 $ 1,259.30 $ 20.60 $ 71,939.25 4 $ 1,279.90 $ 1,258.94 $ 20.96 $ 71,918.29 74 $ 69,031.68 75 $ 1,279.90 $ 1,208.05 $ 71.85 $ 68,959.83

Upload: enitaaguilar

Post on 17-Sep-2015

3 views

Category:

Documents


1 download

DESCRIPTION

cuadro de amortizacion

TRANSCRIPT

EJERCICIO 2ncuota mensual abono a interesesabono a capital saldo 0$72,000.001$1,279.90$1,260.00$19.90$71,980.102$1,279.90$1,259.65$20.25$71,959.853$1,279.90$1,259.30$20.60$71,939.254$1,279.90$1,258.94$20.96$71,918.2974$69,031.6875$1,279.90$1,208.05$71.85$68,959.83

Hoja2ncuota mensual abono a interesesabono a capital saldo 0$30,000.001$394.03$300.00$94.03$29,905.972$394.03$299.06$94.97$29,811.003$394.03$298.11$95.92$29,715.084$394.03$297.15$96.88$29,618.20

Hoja3

Ejercicio 3ncuota mensual abono a interesesabono a capital saldo 0$75,000.001$957.357663$711.60$245.76$74,754.242$957.357663$709.27$248.09$74,506.153$957.357663$706.91$250.44$74,255.714$957.357663$704.54$252.82$74,002.895$957.357663$702.14$255.22$73,747.676$957.357663$699.72$257.64$73,490.037$957.357663$697.27$260.08$73,229.958$957.357663$694.81$262.55$72,967.409$957.357663$692.31$265.04$72,702.3510$957.357663$689.80$267.56$72,434.8011$957.357663$687.26$270.10$72,164.7012$957.357663$684.70$272.66$71,892.0413$957.357663$682.11$275.25$71,616.7914$957.357663$679.50$277.86$71,338.9415$957.357663$676.86$280.49$71,058.4416$957.357663$674.20$283.16$70,775.2917$957.357663$671.52$285.84$70,489.4518$957.357663$668.80$288.55$70,200.8919$957.357663$666.07$291.29$69,909.6020$957.357663$663.30$294.06$69,615.5421$957.357663$660.51$296.85$69,318.7022$957.357663$657.70$299.66$69,019.0423$957.357663$654.85$302.51$68,716.5324$957.357663$651.98$305.38$68,411.1625$957.357663$649.09$308.27$68,102.8826$957.357663$646.16$311.20$67,791.6927$957.357663$643.21$314.15$67,477.5428$957.357663$640.23$317.13$67,160.4129$957.357663$637.22$320.14$66,840.2730$957.357663$634.18$323.18$66,517.0931$957.357663$631.11$326.24$66,190.8532$957.357663$628.02$329.34$65,861.5133$957.357663$624.89$332.46$65,529.0434$957.357663$621.74$335.62$65,193.4335$957.357663$618.56$338.80$64,854.6236$957.357663$615.34$342.02$64,512.6137$957.357663$612.10$345.26$64,167.3438$957.357663$608.82$348.54$63,818.8139$957.357663$605.51$351.84$63,466.9640$957.357663$602.17$355.18$63,111.7841$957.357663$598.80$358.55$62,753.2242$957.357663$595.40$361.96$62,391.2743$957.357663$591.97$365.39$62,025.8844$957.357663$588.50$368.86$61,657.0245$957.357663$585.00$372.36$61,284.6746$957.357663$581.47$375.89$60,908.7847$957.357663$577.90$379.46$60,529.3248$957.357663$574.30$383.06$60,146.2749$957.357663$570.67$386.69$59,759.5850$957.357663$567.00$390.36$59,369.2251$957.357663$563.30$394.06$58,975.1652$957.357663$559.56$397.80$58,577.3653$957.357663$555.78$401.58$58,175.7854$957.357663$551.97$405.39$57,770.4055$957.357663$548.13$409.23$57,361.1656$957.357663$544.24$413.11$56,948.0557$957.357663$540.32$417.03$56,531.0158$957.357663$536.37$420.99$56,110.0259$957.357663$532.37$424.99$55,685.0460$957.357663$528.34$429.02$55,256.0261$957.357663$524.27$433.09$54,822.9362$957.357663$520.16$437.20$54,385.7363$957.357663$516.01$441.35$53,944.3964$957.357663$511.82$445.53$53,498.8565$957.357663$507.60$449.76$53,049.0966$957.357663$503.33$454.03$52,595.0667$957.357663$499.02$458.34$52,136.7368$957.357663$494.67$462.68$51,674.0469$957.357663$490.28$467.07$51,206.9770$957.357663$485.85$471.51$50,735.4671$957.357663$481.38$475.98$50,259.4872$957.357663$476.86$480.50$49,778.9973$957.357663$472.30$485.05$49,293.9374$957.357663$467.70$489.66$48,804.2875$957.357663$463.05$494.30$48,309.9776$957.357663$458.37$498.99$47,810.9877$957.357663$453.63$503.73$47,307.2578$957.357663$448.85$508.51$46,798.7579$957.357663$444.03$513.33$46,285.4280$957.357663$439.16$518.20$45,767.2281$957.357663$434.24$523.12$45,244.1082$957.357663$429.28$528.08$44,716.0283$957.357663$424.27$533.09$44,182.9284$957.357663$419.21$538.15$43,644.7785$957.357663$414.10$543.26$43,101.5286$957.357663$408.95$548.41$42,553.1187$957.357663$403.74$553.61$41,999.4988$957.357663$398.49$558.87$41,440.6389$957.357663$393.19$564.17$40,876.4690$957.357663$387.84$569.52$40,306.9491$957.357663$382.43$574.93$39,732.0192$957.357663$376.98$580.38$39,151.6393$957.357663$371.47$585.89$38,565.7494$957.357663$365.91$591.45$37,974.3095$957.357663$360.30$597.06$37,377.2496$957.357663$354.64$602.72$36,774.5297$957.357663$348.92$608.44$36,166.0898$957.357663$343.14$614.21$35,551.8699$957.357663$337.32$620.04$34,931.82100$957.357663$331.43$625.92$34,305.90101$957.357663$325.49$631.86$33,674.03102$957.357663$319.50$637.86$33,036.17103$957.357663$313.45$643.91$32,392.26104$957.357663$307.34$650.02$31,742.24105$957.357663$301.17$656.19$31,086.06106$957.357663$294.94$662.41$30,423.64107$957.357663$288.66$668.70$29,754.95108$957.357663$282.31$675.04$29,079.90109$957.357663$275.91$681.45$28,398.46110$957.357663$269.44$687.91$27,710.54111$957.357663$262.92$694.44$27,016.10112$957.357663$256.33$701.03$26,315.07113$957.357663$249.68$707.68$25,607.39114$957.357663$242.96$714.39$24,893.00115$957.357663$236.18$721.17$24,171.83116$957.357663$229.34$728.02$23,443.81117$957.357663$222.43$734.92$22,708.89118$957.357663$215.46$741.90$21,966.99119$957.357663$208.42$748.93$21,218.06120$957.357663$201.32$756.04$20,462.02121$957.357663$194.14$763.21$19,698.80122$957.357663$186.90$770.46$18,928.35123$957.357663$179.59$777.77$18,150.58124$957.357663$172.21$785.14$17,365.44125$957.357663$164.76$792.59$16,572.84126$957.357663$157.24$800.11$15,772.73127$957.357663$149.65$807.71$14,965.02128$957.357663$141.99$815.37$14,149.65129$957.357663$134.25$823.11$13,326.55130$957.357663$126.44$830.92$12,495.63131$957.357663$118.56$838.80$11,656.83132$957.357663$110.60$846.76$10,810.07133$957.357663$102.57$854.79$9,955.28134$957.357663$94.46$862.90$9,092.38135$957.357663$86.27$871.09$8,221.29136$957.357663$78.00$879.35$7,341.94137$957.357663$69.66$887.70$6,454.24138$957.357663$61.24$896.12$5,558.12139$957.357663$52.74$904.62$4,653.50140$957.357663$44.15$913.21$3,740.29141$957.357663$35.49$921.87$2,818.42142$957.357663$26.74$930.62$1,887.81143$957.357663$17.91$939.45$948.36144$957.357663$9.00$948.36$0.00

EJERCICIO 4ncuota mensual abono a interesesabono a capital saldo 0$9,000.001$2,394.02$227.59$2,166.43$6,833.572$2,394.02$172.81$2,221.21$4,612.363$2,394.02$116.64$2,277.38$2,334.984$2,394.02$59.05$2,334.97$0.00

Hoja1ncuota mensual abono a interesesabono a capital saldo 0$10,0001$278.46$79.74$198.72$9,801.282$278.46$78.16$200.30$9,600.983$278.46$76.56$201.90$9,399.074$278.46$74.95$203.51$9,195.565$278.46$73.33$205.13$8,990.436$278.46$71.69$206.77$8,783.667$278.46$70.04$208.42$8,575.248$278.46$68.38$210.08$8,365.169$278.46$66.70$211.76$8,153.4010$278.46$65.02$213.44$7,939.9611$278.46$63.31$215.15$7,724.8112$278.46$61.60$216.86$7,507.9513$278.46$59.87$218.59$7,289.3514$278.46$58.13$220.33$7,069.0215$278.46$56.37$222.09$6,846.9316$278.46$54.60$223.86$6,623.0717$278.46$52.81$225.65$6,397.4218$278.46$51.01$227.45$6,169.9719$278.46$49.20$229.26$5,940.7120$278.46$47.37$231.09$5,709.62

Hoja4ncouta interestotal al fondoacumulado 1$277.580.0$277.57$277.572$277.57$27.76$305.33$582.903$277.57$58.29$335.86$918.764$277.57$91.88$369.45$1,288.205$278.57$128.82$407.39$1,695.596$279.57$169.56$449.13$2,144.727$280.57$214.47$495.04$2,639.768$281.57$263.98$545.55$3,185.319$282.57$318.53$601.10$3,786.4110$283.57$378.64$662.21$4,448.6211$284.57$444.86$729.43$5,178.0512$285.57$517.81$803.38$5,981.4313$286.57$598.14$884.71$6,866.1414$287.57$686.61$974.18$7,840.3315$288.57$784.03$1,072.60$8,912.93