amortization

3
Programación de la amortización de préstamo Especificar valores Importe del préstamo $ 60,000,000 Tasa de interés anual 6.60 % Númer Plazo del préstamo en años 5 Número de pagos al año 12 Total Fecha inicial del préstamo 8/28/2022 Pagos adicionales opcionales $ 1,000,000 Nombre de entidad de crédito: Fecha de pago Saldo inicial Pago adicional Pago total Capital Interés 1 9/28/2022 $ 60,000,000 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,846,781 $ 330,000 2 10/28/2022 $ 58,153,219 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,856,939 $ 319,843 3 11/28/2022 $ 56,296,280 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,867,152 $ 309,630 4 12/28/2022 $ 54,429,128 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,877,421 $ 299,360 5 1/28/2023 $ 52,551,707 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,887,747 $ 289,034 6 2/28/2023 $ 50,663,960 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,898,130 $ 278,652 7 3/28/2023 $ 48,765,831 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,908,569 $ 268,212 8 4/28/2023 $ 46,857,261 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,919,066 $ 257,715 9 5/28/2023 $ 44,938,195 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,929,621 $ 247,160 10 6/28/2023 $ 43,008,574 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,940,234 $ 236,547 11 7/28/2023 $ 41,068,340 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,950,905 $ 225,876 12 8/28/2023 $ 39,117,434 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,961,635 $ 215,146 13 9/28/2023 $ 37,155,799 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,972,424 $ 204,357 14 10/28/2023 $ 35,183,374 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,983,273 $ 193,509 15 11/28/2023 $ 33,200,101 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 1,994,181 $ 182,601 16 12/28/2023 $ 31,205,921 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,005,149 $ 171,633 17 1/28/2024 $ 29,200,772 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,016,177 $ 160,604 18 2/28/2024 $ 27,184,595 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,027,266 $ 149,515 19 3/28/2024 $ 25,157,329 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,038,416 $ 138,365 20 4/28/2024 $ 23,118,913 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,049,627 $ 127,154 21 5/28/2024 $ 21,069,285 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,060,900 $ 115,881 22 6/28/2024 $ 19,008,385 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,072,235 $ 104,546 23 7/28/2024 $ 16,936,150 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,083,633 $ 93,149 24 8/28/2024 $ 14,852,518 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,095,092 $ 81,689 25 9/28/2024 $ 12,757,425 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,106,615 $ 70,166 26 10/28/2024 $ 10,650,810 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,118,202 $ 58,579 27 11/28/2024 $ 8,532,608 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,129,852 $ 46,929 28 12/28/2024 $ 6,402,756 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,141,566 $ 35,215 29 1/28/2025 $ 4,261,190 $ 1,176,781 $ 1,000,000 $ 2,176,781 $ 2,153,345 $ 23,437 30 2/28/2025 $ 2,107,845 $ 1,176,781 $ 931,063 $ 2,107,845 $ 2,096,252 $ 11,593 31 3/28/2025 32 4/28/2025 Pago Pago programado

Upload: martha-salinas

Post on 18-Dec-2015

213 views

Category:

Documents


0 download

TRANSCRIPT

Loan amortization schedule

Program. amortizacin prstamoProgramacin de la amortizacin de prstamo

Especificar valoresResumen del prstamoImporte del prstamo$ 60,000,000Pago programado$ 1,176,781.33Tasa de inters anual6.60?%Nmero de pagos programado60Plazo del prstamo en aos5Nmero de pagos real30Nmero de pagos al ao12Total de pagos anticipados$ 29,931,063Fecha inicial del prstamo4/27/15Inters total$ 5,246,096Pagos adicionales opcionales$ 1,000,000

Nombre de entidad de crdito:

N PagoFecha de pagoSaldo inicialPago programadoPago adicionalPago totalCapitalIntersSaldo finalInters acumulativo

15/27/15$ 60,000,000$ 1,176,781$ 1,000,000$ 2,176,781$ 1,846,781$ 330,000$ 58,153,219$ 330,00026/27/15$ 58,153,219$ 1,176,781$ 1,000,000$ 2,176,781$ 1,856,939$ 319,843$ 56,296,280$ 649,84337/27/15$ 56,296,280$ 1,176,781$ 1,000,000$ 2,176,781$ 1,867,152$ 309,630$ 54,429,128$ 959,47248/27/15$ 54,429,128$ 1,176,781$ 1,000,000$ 2,176,781$ 1,877,421$ 299,360$ 52,551,707$ 1,258,83259/27/15$ 52,551,707$ 1,176,781$ 1,000,000$ 2,176,781$ 1,887,747$ 289,034$ 50,663,960$ 1,547,867610/27/15$ 50,663,960$ 1,176,781$ 1,000,000$ 2,176,781$ 1,898,130$ 278,652$ 48,765,831$ 1,826,519711/27/15$ 48,765,831$ 1,176,781$ 1,000,000$ 2,176,781$ 1,908,569$ 268,212$ 46,857,261$ 2,094,731812/27/15$ 46,857,261$ 1,176,781$ 1,000,000$ 2,176,781$ 1,919,066$ 257,715$ 44,938,195$ 2,352,44691/27/16$ 44,938,195$ 1,176,781$ 1,000,000$ 2,176,781$ 1,929,621$ 247,160$ 43,008,574$ 2,599,606102/27/16$ 43,008,574$ 1,176,781$ 1,000,000$ 2,176,781$ 1,940,234$ 236,547$ 41,068,340$ 2,836,153113/27/16$ 41,068,340$ 1,176,781$ 1,000,000$ 2,176,781$ 1,950,905$ 225,876$ 39,117,434$ 3,062,029124/27/16$ 39,117,434$ 1,176,781$ 1,000,000$ 2,176,781$ 1,961,635$ 215,146$ 37,155,799$ 3,277,175135/27/16$ 37,155,799$ 1,176,781$ 1,000,000$ 2,176,781$ 1,972,424$ 204,357$ 35,183,374$ 3,481,532146/27/16$ 35,183,374$ 1,176,781$ 1,000,000$ 2,176,781$ 1,983,273$ 193,509$ 33,200,101$ 3,675,040157/27/16$ 33,200,101$ 1,176,781$ 1,000,000$ 2,176,781$ 1,994,181$ 182,601$ 31,205,921$ 3,857,641168/27/16$ 31,205,921$ 1,176,781$ 1,000,000$ 2,176,781$ 2,005,149$ 171,633$ 29,200,772$ 4,029,273179/27/16$ 29,200,772$ 1,176,781$ 1,000,000$ 2,176,781$ 2,016,177$ 160,604$ 27,184,595$ 4,189,8771810/27/16$ 27,184,595$ 1,176,781$ 1,000,000$ 2,176,781$ 2,027,266$ 149,515$ 25,157,329$ 4,339,3931911/27/16$ 25,157,329$ 1,176,781$ 1,000,000$ 2,176,781$ 2,038,416$ 138,365$ 23,118,913$ 4,477,7582012/27/16$ 23,118,913$ 1,176,781$ 1,000,000$ 2,176,781$ 2,049,627$ 127,154$ 21,069,285$ 4,604,912211/27/17$ 21,069,285$ 1,176,781$ 1,000,000$ 2,176,781$ 2,060,900$ 115,881$ 19,008,385$ 4,720,793222/27/17$ 19,008,385$ 1,176,781$ 1,000,000$ 2,176,781$ 2,072,235$ 104,546$ 16,936,150$ 4,825,339233/27/17$ 16,936,150$ 1,176,781$ 1,000,000$ 2,176,781$ 2,083,633$ 93,149$ 14,852,518$ 4,918,488244/27/17$ 14,852,518$ 1,176,781$ 1,000,000$ 2,176,781$ 2,095,092$ 81,689$ 12,757,425$ 5,000,177255/27/17$ 12,757,425$ 1,176,781$ 1,000,000$ 2,176,781$ 2,106,615$ 70,166$ 10,650,810$ 5,070,343266/27/17$ 10,650,810$ 1,176,781$ 1,000,000$ 2,176,781$ 2,118,202$ 58,579$ 8,532,608$ 5,128,922277/27/17$ 8,532,608$ 1,176,781$ 1,000,000$ 2,176,781$ 2,129,852$ 46,929$ 6,402,756$ 5,175,852288/27/17$ 6,402,756$ 1,176,781$ 1,000,000$ 2,176,781$ 2,141,566$ 35,215$ 4,261,190$ 5,211,067299/27/17$ 4,261,190$ 1,176,781$ 1,000,000$ 2,176,781$ 2,153,345$ 23,437$ 2,107,845$ 5,234,5033010/27/17$ 2,107,845$ 1,176,781$ 931,063$ 2,107,845$ 2,096,252$ 11,5930.0$ 5,246,0963111/27/173212/27/17331/27/18342/27/18353/27/18364/27/18375/27/18386/27/18397/27/18408/27/18419/27/184210/27/184311/27/184412/27/18451/27/19462/27/19473/27/19484/27/19495/27/19506/27/19517/27/19528/27/19539/27/195410/27/195511/27/195612/27/19571/27/20582/27/20593/27/20604/27/20615/27/20626/27/20637/27/20648/27/20659/27/206610/27/206711/27/206812/27/20691/27/21702/27/21713/27/21724/27/21735/27/21746/27/21757/27/21768/27/21779/27/217810/27/217911/27/218012/27/21811/27/22822/27/22833/27/22844/27/22855/27/22866/27/22877/27/22888/27/22899/27/229010/27/229111/27/229212/27/22931/27/23942/27/23953/27/23964/27/23975/27/23986/27/23997/27/231008/27/231019/27/2310210/27/2310311/27/2310412/27/231051/27/241062/27/241073/27/241084/27/241095/27/241106/27/241117/27/241128/27/241139/27/2411410/27/2411511/27/2411612/27/241171/27/251182/27/251193/27/251204/27/251215/27/251226/27/251237/27/251248/27/251259/27/2512610/27/2512711/27/2512812/27/251291/27/261302/27/261313/27/261324/27/261335/27/261346/27/261357/27/261368/27/261379/27/2613810/27/2613911/27/2614012/27/261411/27/271422/27/271433/27/271444/27/271455/27/271466/27/271477/27/271488/27/271499/27/2715010/27/2715111/27/2715212/27/271531/27/281542/27/281553/27/281564/27/281575/27/281586/27/281597/27/281608/27/281619/27/2816210/27/2816311/27/2816412/27/281651/27/291662/27/291673/27/291684/27/291695/27/291706/27/291717/27/291728/27/291739/27/2917410/27/2917511/27/2917612/27/291771/27/301782/27/301793/27/301804/27/301815/27/301826/27/301837/27/301848/27/301859/27/3018610/27/3018711/27/3018812/27/301891/27/311902/27/311913/27/311924/27/311935/27/311946/27/311957/27/311968/27/311979/27/3119810/27/3119911/27/3120012/27/312011/27/322022/27/322033/27/322044/27/322055/27/322066/27/322077/27/322088/27/322099/27/3221010/27/3221111/27/3221212/27/322131/27/332142/27/332153/27/332164/27/332175/27/332186/27/332197/27/332208/27/332219/27/3322210/27/3322311/27/3322412/27/332251/27/342262/27/342273/27/342284/27/342295/27/342306/27/342317/27/342328/27/342339/27/3423410/27/3423511/27/3423612/27/342371/27/352382/27/352393/27/352404/27/352415/27/352426/27/352437/27/352448/27/352459/27/3524610/27/3524711/27/3524812/27/352491/27/362502/27/362513/27/362524/27/362535/27/362546/27/362557/27/362568/27/362579/27/3625810/27/3625911/27/3626012/27/362611/27/372622/27/372633/27/372644/27/372655/27/372666/27/372677/27/372688/27/372699/27/3727010/27/3727111/27/3727212/27/372731/27/382742/27/382753/27/382764/27/382775/27/382786/27/382797/27/382808/27/382819/27/3828210/27/3828311/27/3828412/27/382851/27/392862/27/392873/27/392884/27/392895/27/392906/27/392917/27/392928/27/392939/27/3929410/27/3929511/27/3929612/27/392971/27/402982/27/402993/27/403004/27/403015/27/403026/27/403037/27/403048/27/403059/27/4030610/27/4030711/27/4030812/27/403091/27/413102/27/413113/27/413124/27/413135/27/413146/27/413157/27/413168/27/413179/27/4131810/27/4131911/27/4132012/27/413211/27/423222/27/423233/27/423244/27/423255/27/423266/27/423277/27/423288/27/423299/27/4233010/27/4233111/27/4233212/27/423331/27/433342/27/433353/27/433364/27/433375/27/433386/27/433397/27/433408/27/433419/27/4334210/27/4334311/27/4334412/27/433451/27/443462/27/443473/27/443484/27/443495/27/443506/27/443517/27/443528/27/443539/27/4435410/27/4435511/27/4435612/27/443571/27/453582/27/453593/27/453604/27/453615/27/453626/27/453637/27/453648/27/453659/27/4536610/27/4536711/27/4536812/27/453691/27/463702/27/463713/27/463724/27/463735/27/463746/27/463757/27/463768/27/463779/27/4637810/27/4637911/27/4638012/27/463811/27/473822/27/473833/27/473844/27/473855/27/473866/27/473877/27/473888/27/473899/27/4739010/27/4739111/27/4739212/27/473931/27/483942/27/483953/27/483964/27/483975/27/483986/27/483997/27/484008/27/484019/27/4840210/27/4840311/27/4840412/27/484051/27/494062/27/494073/27/494084/27/494095/27/494106/27/494117/27/494128/27/494139/27/4941410/27/4941511/27/4941612/27/494171/27/504182/27/504193/27/504204/27/504215/27/504226/27/504237/27/504248/27/504259/27/5042610/27/5042711/27/5042812/27/504291/27/514302/27/514313/27/514324/27/514335/27/514346/27/514357/27/514368/27/514379/27/5143810/27/5143911/27/5144012/27/514411/27/524422/27/524433/27/524444/27/524455/27/524466/27/524477/27/524488/27/524499/27/5245010/27/5245111/27/5245212/27/524531/27/534542/27/534553/27/534564/27/534575/27/534586/27/534597/27/534608/27/534619/27/5346210/27/5346311/27/5346412/27/534651/27/544662/27/544673/27/544684/27/544695/27/544706/27/544717/27/544728/27/544739/27/5447410/27/5447511/27/5447612/27/544771/27/554782/27/554793/27/554804/27/55

balance generalBALANCE GENERAL

ACTIVO122012-1Q2013-1Q% Variac.Disponible 65,000,00068,250,0005.0%Inversiones75,000,00078,750,0005.0%Deudores55,000,00057,750,0005.0%Propiedad, planta y equipo5,000,0005,250,0005.0%Intangibles y otros activos246,096258,4015.0%Valorizaciones000.0%Total Activo200,246,096210,258,4015.0%

PASIVO Y PATRIMONIO12% Variac.Obligaciones financieras65,246,09635,183,374-46.1%Proveedores y Cuentas por pagar35,000,00036,750,0005.0%Impuestos, gravmenes y tasas6,000,0006,300,0005.0%Obligaciones laborales22,000,00023,100,0005.0%Pasivos estimados y provisiones34,000,00035,700,0005.0%Diferidos y otros pasivos8,000,0008,400,0005.0%Total Pasivo170,246,096145,433,374-14.6%PATRIMONIO30,000,00031,500,0005.0%Total Pasivo y Patrimonio200,246,096210,258,4015.0%Nmero de acciones en circulacin500500Valor intrnseco por accin6,000,0006,300,000

Estado de Resultados Bsico122012-1Q2013-1Q% Variac.Ingresos250,000,000262,500,0005.0%Costo de Venta50,000,00052,500,0005.0%Utilidad Bruta200,000,000210,000,0005.0%Gastos operacionales95,000,00099,750,0005.0%Utilidad Operacional105,000,000110,250,00016.1%Ingresos no operacionales5,000,0005,250,000-95.0%Gastos no operacionales12,000,00012,600,0005.0%Utilidad antes de impuestos sobre la renta98,000,000102,900,0005.0%Impuesto de renta62,500,00065,625,0005.0%UTILIDAD NETA35,500,00037,275,0005.0%