Tabla_amortizacion.xls
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Tabla_amortizacion.xls as PDF for free.
More details
- Words: 859
- Pages: 7
Tabla de amortización Monto 7,366,000 Plazo Meses 24 Tasa 52.89% EA 3.60% MV Forma de pago Cuotas= abono de capital mas interes Period Saldo inicial Abono a K Intereses Cuota Saldo final 0 7,366,000 7,366,000 1 7,366,000 198,325 265,267 463,592 7,167,675 2 7,167,675 205,467 258,125 463,592 6,962,208 3 6,962,208 212,867 250,725 463,592 6,749,341 4 6,749,341 220,532 243,059 463,592 6,528,809 5 6,528,809 228,474 235,118 463,592 6,300,334 6 6,300,334 236,702 226,890 463,592 6,063,632 7 6,063,632 245,226 218,366 463,592 5,818,406 8 5,818,406 254,058 209,534 463,592 5,564,348 9 5,564,348 263,207 200,385 463,592 5,301,141 10 5,301,141 272,685 190,906 463,592 5,028,456 11 5,028,456 282,506 181,086 463,592 4,745,950 12 4,745,950 292,679 170,913 463,592 4,453,271 13 4,453,271 303,219 160,373 463,592 4,150,052 14 4,150,052 314,139 149,453 463,592 3,835,913 15 3,835,913 325,452 138,140 463,592 3,510,461 16 3,510,461 337,172 126,420 463,592 3,173,289 17 3,173,289 349,314 114,278 463,592 2,823,975 18 2,823,975 361,894 101,698 463,592 2,462,081 19 2,462,081 374,927 88,665 463,592 2,087,154 20 2,087,154 388,429 75,163 463,592 1,698,726 21 1,698,726 402,417 61,175 463,592 1,296,309 22 1,296,309 416,909 46,683 463,592 879,400 23 879,400 431,923 31,669 463,592 447,477 24 447,477 447,477 16,115 463,592 0 7,366,000 3,760,206 11,126,206 valor inicial Intereses pago total 51.05%
Tabla de amortización Monto 1,661,850 Plazo Meses 36 Tasa EA 30.71% MV 2.26% Forma de pago Cuotas= abono de capital mas interes Periodo Saldo inicial Abono a K Intereses Cuota Saldo final 0 1,661,850 1,661,850 1 1,661,850 30,413 37,505 67,919 1,631,437 2 1,631,437 31,100 36,819 67,919 1,600,337 3 1,600,337 31,801 36,117 67,919 1,568,536 4 1,568,536 32,519 35,399 67,919 1,536,016 5 1,536,016 33,253 34,666 67,919 1,502,763 6 1,502,763 34,004 33,915 67,919 1,468,760 7 1,468,760 34,771 33,148 67,919 1,433,989 8 1,433,989 35,556 32,363 67,919 1,398,433 9 1,398,433 36,358 31,561 67,919 1,362,075 10 1,362,075 37,179 30,740 67,919 1,324,896 11 1,324,896 38,018 29,901 67,919 1,286,878 12 1,286,878 38,876 29,043 67,919 1,248,003 13 1,248,003 39,753 28,166 67,919 1,208,249 14 1,208,249 40,650 27,268 67,919 1,167,599 15 1,167,599 41,568 26,351 67,919 1,126,031 16 1,126,031 42,506 25,413 67,919 1,083,526 17 1,083,526 43,465 24,454 67,919 1,040,060 18 1,040,060 44,446 23,473 67,919 995,614 19 995,614 45,449 22,470 67,919 950,165 20 950,165 46,475 21,444 67,919 903,690 21 903,690 47,524 20,395 67,919 856,166 22 856,166 48,596 19,322 67,919 807,570 23 807,570 49,693 18,226 67,919 757,877 24 757,877 50,815 17,104 67,919 707,063 25 707,063 51,961 15,957 67,919 655,101 26 655,101 53,134 14,785 67,919 601,967 27 601,967 54,333 13,585 67,919 547,634 28 547,634 55,559 12,359 67,919 492,075 29 492,075 56,813 11,105 67,919 435,261 30 435,261 58,095 9,823 67,919 377,166 31 377,166 59,407 8,512 67,919 317,759 32 317,759 60,747 7,171 67,919 257,012 33 257,012 62,118 5,800 67,919 194,894 34 194,894 63,520 4,398 67,919 131,373 35 131,373 64,954 2,965 67,919 66,420 36 66,420 66,420 1,499 67,919 0 TOTAL 1,661,850 783,222 2,445,072 47.13%
679,187
453,601
429,342
1,208,249
FCL
Año 0 -79,400,000
Año 1 163,510,367
Año 2 306,867,215
Año 3 383,985,108
Año 4 457,676,631
FCL -79,400,000 163,510,367 306,867,215 383,985,108 457,676,631 C Op 18.00% VPN 1,040,932,044 El proyecto, al no estar apalancado, es factible para los accionitas Rentb 100.35% Flujo de caja de los accionistas FCL -79,400,000 163,510,367 306,867,215 383,985,108 457,676,631 Desembolso 50,000,000 Abono a k 14,268,116 16,178,617 18,344,934 Int 1,719,106 -191,394 -2,357,711 Cuota 15,987,223 15,987,223 15,987,223 Beneficio fiscal 567,305 -63,160 -778,045 FCA -29,400,000 148,090,449 290,816,832 367,219,841 457,676,631 C Op 20.00% VPN 997,295,315.07 Rentb 144.23%
Año 5 667,126,117 667,126,117
FCL
800,000,000 700,000,000
0
600,000,000 500,000,000 400,000,000 300,000,000
667,126,117
200,000,000 100,000,000 0 -100,000,000 -200,000,000
667,126,117
Año 0
Año 1
Año 2
Año 3
Año 4
Año 5
Presupuesto de inversión Activos fijos Equipos Muebles y enseres Diferidos Gastos de constitución Gastos preliminares Intangibles Registro de la marca Desarrollo Capital de trabajo Efectivo
94,000,000 50,000,000
100.00% 53.19%
10,000,000
10.64%
0
0.00%
34,000,000
36.17%
4,000 1,500 500 1,000 800 4,500 7,700
Tabla de amortización Monto 50,000,000 6,695,000 56,695,000 Plazo Meses 48 Tasa 13.39% EA 1.05% Forma de pago Cuotas uniformes mensuales vencidas Period Saldo inicial Abono a K Intereses Cuota 0 20,000,000 1 20,000,000 1,121,730 210,539 1,332,269 2 18,878,270 1,133,538 198,730 1,332,269 3 17,744,732 1,145,471 186,798 1,332,269 4 16,599,261 1,157,529 174,739 1,332,269 5 15,441,732 1,169,714 162,554 1,332,269 6 14,272,018 1,182,028 150,241 1,332,269 7 13,089,990 1,194,471 137,798 1,332,269 8 11,895,519 1,207,045 125,223 1,332,269 9 10,688,474 1,219,752 112,517 1,332,269 10 9,468,722 1,232,592 99,677 1,332,269 11 8,236,130 1,245,567 86,701 1,332,269 12 6,990,563 1,258,679 73,589 1,332,269 13 5,731,884 1,271,929 60,339 1,332,269 14 4,459,954 1,285,319 46,950 1,332,269 15 3,174,635 1,298,849 33,419 1,332,269 16 1,875,786 1,312,522 19,746 1,332,269 17 563,264 1,326,339 5,929 1,332,269 18 -763,075 1,340,301 -8,033 1,332,269 19 -2,103,377 1,354,411 -22,142 1,332,269 20 -3,457,787 1,368,668 -36,400 1,332,269 21 -4,826,456 1,383,076 -50,808 1,332,269 22 -6,209,532 1,397,636 -65,367 1,332,269 23 -7,607,168 1,412,349 -80,080 1,332,269 24 -9,019,517 1,427,216 -94,948 1,332,269 25 -10,446,733 1,442,241 -109,972 1,332,269 26 -11,888,974 1,457,423 -125,155 1,332,269 27 -13,346,397 1,472,765 -140,497 1,332,269 28 -14,819,163 1,488,269 -156,000 1,332,269 29 -16,307,432 1,503,936 -171,667 1,332,269 30 -17,811,367 1,519,768 -187,499 1,332,269 31 -19,331,135 1,535,766 -203,498 1,332,269 32 -20,866,902 1,551,933 -219,665 1,332,269 33 -22,418,835 1,568,270 -236,002 1,332,269 34 -23,987,105 1,584,779 -252,511 1,332,269 35 -25,571,884 1,601,462 -269,194 1,332,269 36 -27,173,347 1,618,321 -286,052 1,332,269 47,961,668
MV Saldo final 20,000,000 18,878,270 17,744,732 16,599,261 15,441,732 14,272,018 13,089,990 11,895,519 10,688,474 9,468,722 8,236,130 6,990,563 5,731,884 4,459,954 3,174,635 1,875,786 563,264 -763,075 -2,103,377 -3,457,787 -4,826,456 -6,209,532 -7,607,168 -9,019,517 -10,446,733 -11,888,974 -13,346,397 -14,819,163 -16,307,432 -17,811,367 -19,331,135 -20,866,902 -22,418,835 -23,987,105 -25,571,884 -27,173,347 -28,791,667
Tabla de amortización Monto 1,661,850 Plazo Meses 36 Tasa EA 30.71% MV 2.26% Forma de pago Cuotas= abono de capital mas interes Periodo Saldo inicial Abono a K Intereses Cuota Saldo final 0 1,661,850 1,661,850 1 1,661,850 30,413 37,505 67,919 1,631,437 2 1,631,437 31,100 36,819 67,919 1,600,337 3 1,600,337 31,801 36,117 67,919 1,568,536 4 1,568,536 32,519 35,399 67,919 1,536,016 5 1,536,016 33,253 34,666 67,919 1,502,763 6 1,502,763 34,004 33,915 67,919 1,468,760 7 1,468,760 34,771 33,148 67,919 1,433,989 8 1,433,989 35,556 32,363 67,919 1,398,433 9 1,398,433 36,358 31,561 67,919 1,362,075 10 1,362,075 37,179 30,740 67,919 1,324,896 11 1,324,896 38,018 29,901 67,919 1,286,878 12 1,286,878 38,876 29,043 67,919 1,248,003 13 1,248,003 39,753 28,166 67,919 1,208,249 14 1,208,249 40,650 27,268 67,919 1,167,599 15 1,167,599 41,568 26,351 67,919 1,126,031 16 1,126,031 42,506 25,413 67,919 1,083,526 17 1,083,526 43,465 24,454 67,919 1,040,060 18 1,040,060 44,446 23,473 67,919 995,614 19 995,614 45,449 22,470 67,919 950,165 20 950,165 46,475 21,444 67,919 903,690 21 903,690 47,524 20,395 67,919 856,166 22 856,166 48,596 19,322 67,919 807,570 23 807,570 49,693 18,226 67,919 757,877 24 757,877 50,815 17,104 67,919 707,063 25 707,063 51,961 15,957 67,919 655,101 26 655,101 53,134 14,785 67,919 601,967 27 601,967 54,333 13,585 67,919 547,634 28 547,634 55,559 12,359 67,919 492,075 29 492,075 56,813 11,105 67,919 435,261 30 435,261 58,095 9,823 67,919 377,166 31 377,166 59,407 8,512 67,919 317,759 32 317,759 60,747 7,171 67,919 257,012 33 257,012 62,118 5,800 67,919 194,894 34 194,894 63,520 4,398 67,919 131,373 35 131,373 64,954 2,965 67,919 66,420 36 66,420 66,420 1,499 67,919 0 TOTAL 1,661,850 783,222 2,445,072 47.13%
679,187
453,601
429,342
1,208,249
FCL
Año 0 -79,400,000
Año 1 163,510,367
Año 2 306,867,215
Año 3 383,985,108
Año 4 457,676,631
FCL -79,400,000 163,510,367 306,867,215 383,985,108 457,676,631 C Op 18.00% VPN 1,040,932,044 El proyecto, al no estar apalancado, es factible para los accionitas Rentb 100.35% Flujo de caja de los accionistas FCL -79,400,000 163,510,367 306,867,215 383,985,108 457,676,631 Desembolso 50,000,000 Abono a k 14,268,116 16,178,617 18,344,934 Int 1,719,106 -191,394 -2,357,711 Cuota 15,987,223 15,987,223 15,987,223 Beneficio fiscal 567,305 -63,160 -778,045 FCA -29,400,000 148,090,449 290,816,832 367,219,841 457,676,631 C Op 20.00% VPN 997,295,315.07 Rentb 144.23%
Año 5 667,126,117 667,126,117
FCL
800,000,000 700,000,000
0
600,000,000 500,000,000 400,000,000 300,000,000
667,126,117
200,000,000 100,000,000 0 -100,000,000 -200,000,000
667,126,117
Año 0
Año 1
Año 2
Año 3
Año 4
Año 5
Presupuesto de inversión Activos fijos Equipos Muebles y enseres Diferidos Gastos de constitución Gastos preliminares Intangibles Registro de la marca Desarrollo Capital de trabajo Efectivo
94,000,000 50,000,000
100.00% 53.19%
10,000,000
10.64%
0
0.00%
34,000,000
36.17%
4,000 1,500 500 1,000 800 4,500 7,700
Tabla de amortización Monto 50,000,000 6,695,000 56,695,000 Plazo Meses 48 Tasa 13.39% EA 1.05% Forma de pago Cuotas uniformes mensuales vencidas Period Saldo inicial Abono a K Intereses Cuota 0 20,000,000 1 20,000,000 1,121,730 210,539 1,332,269 2 18,878,270 1,133,538 198,730 1,332,269 3 17,744,732 1,145,471 186,798 1,332,269 4 16,599,261 1,157,529 174,739 1,332,269 5 15,441,732 1,169,714 162,554 1,332,269 6 14,272,018 1,182,028 150,241 1,332,269 7 13,089,990 1,194,471 137,798 1,332,269 8 11,895,519 1,207,045 125,223 1,332,269 9 10,688,474 1,219,752 112,517 1,332,269 10 9,468,722 1,232,592 99,677 1,332,269 11 8,236,130 1,245,567 86,701 1,332,269 12 6,990,563 1,258,679 73,589 1,332,269 13 5,731,884 1,271,929 60,339 1,332,269 14 4,459,954 1,285,319 46,950 1,332,269 15 3,174,635 1,298,849 33,419 1,332,269 16 1,875,786 1,312,522 19,746 1,332,269 17 563,264 1,326,339 5,929 1,332,269 18 -763,075 1,340,301 -8,033 1,332,269 19 -2,103,377 1,354,411 -22,142 1,332,269 20 -3,457,787 1,368,668 -36,400 1,332,269 21 -4,826,456 1,383,076 -50,808 1,332,269 22 -6,209,532 1,397,636 -65,367 1,332,269 23 -7,607,168 1,412,349 -80,080 1,332,269 24 -9,019,517 1,427,216 -94,948 1,332,269 25 -10,446,733 1,442,241 -109,972 1,332,269 26 -11,888,974 1,457,423 -125,155 1,332,269 27 -13,346,397 1,472,765 -140,497 1,332,269 28 -14,819,163 1,488,269 -156,000 1,332,269 29 -16,307,432 1,503,936 -171,667 1,332,269 30 -17,811,367 1,519,768 -187,499 1,332,269 31 -19,331,135 1,535,766 -203,498 1,332,269 32 -20,866,902 1,551,933 -219,665 1,332,269 33 -22,418,835 1,568,270 -236,002 1,332,269 34 -23,987,105 1,584,779 -252,511 1,332,269 35 -25,571,884 1,601,462 -269,194 1,332,269 36 -27,173,347 1,618,321 -286,052 1,332,269 47,961,668
MV Saldo final 20,000,000 18,878,270 17,744,732 16,599,261 15,441,732 14,272,018 13,089,990 11,895,519 10,688,474 9,468,722 8,236,130 6,990,563 5,731,884 4,459,954 3,174,635 1,875,786 563,264 -763,075 -2,103,377 -3,457,787 -4,826,456 -6,209,532 -7,607,168 -9,019,517 -10,446,733 -11,888,974 -13,346,397 -14,819,163 -16,307,432 -17,811,367 -19,331,135 -20,866,902 -22,418,835 -23,987,105 -25,571,884 -27,173,347 -28,791,667
More Documents from "Manuel Gonzales"
Tabla_amortizacion.xls
November 2019 3
Modelos Mixtos En Gestion De Mantenienito.pdf
April 2020 9
Gonzalesabogado
April 2020 0
Gonzalesabogado
April 2020 1