formato de amortizacion unica
Embed Size (px)
DESCRIPTION
Del curso de gestion tecnica empresarial, de la Universidad Nacional San Luis Gonzaga de IcaTRANSCRIPT
20aosGESTIN EMPRESARIAL1. DATOS:
CAPITAL (P):280000TASA:1Tasa (i) %:0.01%TIEMPO:20aosEn meses (n):240meses
2. FRMULAS:
RCuota mensualPCapitaliTasa de interesnNmero de meses
2. CUADRO DE AMORTIZACIN:
PERODOCAPITALAMORTIZACININTERSCUOTATasa (i)0280000---1279717283280030830.012279431286279730830.013279142289279430830.014278851292279130830.015278556295278930830.016278259297278630830.017277958300278330830.018277655303278030830.019277348306277730830.0110277039310277330830.0111276726313277030830.0112276410316276730830.0113276091319276430830.0114275769322276130830.0115275444325275830830.0116275115329275430830.0117274783332275130830.0118274448335274830830.0119274110339274430830.0120273768342274130830.0121273422345273830830.0122273074349273430830.0123272721352273130830.0124272365356272730830.0125272006359272430830.0126271643363272030830.0127271276367271630830.0128270906370271330830.0129270532374270930830.0130270154378270530830.0131269773381270230830.0132269388385269830830.0133268998389269430830.0134268605393269030830.0135268208397268630830.0136267807401268230830.0137267403405267830830.0138266993409267430830.0139266580413267030830.0140266163417266630830.0141265742421266230830.0142265316426265730830.0143264886430265330830.0144264452434264930830.0145264014439264530830.0146263571443264030830.0147263123447263630830.0148262671452263130830.0149262215456262730830.0150261754461262230830.0151261289465261830830.0152260819470261330830.0153260344475260830830.0154259864480260330830.0155259380484259930830.0156258891489259430830.0157258396494258930830.0158257897499258430830.0159257393504257930830.0160256884509257430830.0161256370514256930830.0162255851519256430830.0163255326525255930830.0164254796530255330830.0165254261535254830830.0166253721540254330830.0167253175546253730830.0168252624551253230830.0169252067557252630830.0170251504562252130830.0171250936568251530830.0172250363574250930830.0173249783579250430830.0174249198585249830830.0175248607591249230830.0176248010597248630830.0177247407603248030830.0178246798609247430830.0179246183615246830830.0180245562621246230830.0181244935627245630830.0182244301634244930830.0183243661640244330830.0184243014646243730830.0185242361653243030830.0186241702659242430830.0187241036666241730830.0188240363673241030830.0189239684679240430830.0190238998686239730830.0191238305693239030830.0192237605700238330830.0193236898707237630830.0194236184714236930830.0195235462721236230830.0196234734728235530830.0197233998736234730830.0198233255743234030830.0199232505750233330830.01100231747758232530830.01101230981766231730830.01102230208773231030830.01103229427781230230830.01104228638789229430830.01105227842797228630830.01106227037805227830830.01107226224813227030830.01108225403821226230830.01109224574829225430830.01110223737837224630830.01111222891846223730830.01112222037854222930830.01113221175863222030830.01114220303871221230830.01115219423880220330830.01116218535889219430830.01117217637898218530830.01118216730907217630830.01119215814916216730830.01120214890925215830830.01121213955934214930830.01122213012943214030830.01123212059953213030830.01124211097962212130830.01125210124972211130830.01126209143982210130830.01127208151992209130830.011282071501002208230830.011292061381012207130830.011302051161022206130830.011312040841032205130830.011322030421042204130830.011332019901053203030830.011342009271063202030830.011351998531074200930830.011361987681085199930830.011371976731095198830830.011381965671106197730830.011391954491117196630830.011401943211129195430830.011411931811140194330830.011421920301151193230830.011431908671163192030830.011441896921174190930830.011451885061186189730830.011461873081198188530830.011471860981210187330830.011481848761222186130830.011491836421234184930830.011501823951247183630830.011511811361259182430830.011521798651272181130830.011531785801284179930830.011541772831297178630830.011551759731310177330830.011561746501323176030830.011571733131337174630830.011581719631350173330830.011591706001363172030830.011601692231377170630830.011611678321391169230830.011621664271405167830830.011631650081419166430830.011641635751433165030830.011651621281447163630830.011661606661462162130830.011671591901476160730830.011681576991491159230830.011691561931506157730830.011701546721521156230830.011711531351536154730830.011721515841552153130830.011731500161567151630830.011741484331583150030830.011751468351599148430830.011761452201615146830830.011771435891631145230830.011781419421647143630830.011791402781664141930830.011801385981680140330830.011811369011697138630830.011821351871714136930830.011831334561731135230830.011841317071748133530830.011851299421766131730830.011861281581784129930830.011871263561801128230830.011881245371819126430830.011891226991838124530830.011901208431856122730830.011911189691875120830830.011921170751893119030830.011931151631912117130830.011941132321931115230830.011951112811951113230830.011961093111970111330830.011971073211990109330830.011981053112010107330830.011991032812030105330830.012001012312050103330830.01201991602071101230830.0120297069209199230830.0120394956211297130830.0120492823213395030830.0120590668215592830830.0120688492217690730830.0120786293219888530830.0120884073222086330830.0120981831224284130830.0121079566226581830830.0121177279228779630830.0121274969231077330830.0121372635233375030830.0121470279235772630830.0121567898238070330830.0121665494240467930830.0121763066242865530830.0121860614245263130830.0121958137247760630830.0122055635250258130830.0122153108252755630830.0122250557255253130830.0122347979257750630830.0122445376260348030830.0122542747262945430830.0122640091265642730830.0122737409268240130830.0122834700270937430830.0122931964273634730830.0123029200276332030830.0123126409279129230830.0123223590281926430830.0123320743284723630830.0123417868287620730830.0123514963290417930830.0123612030293315030830.012379067296312030830.01238607529929130830.01239305330226130830.01240030533130830.01459930739930
10aosGESTIN EMPRESARIAL1. DATOS:
CAPITAL (P):280000TASA:1Tasa (i) %:0.01%TIEMPO:10aosEn meses (n):120meses
2. FRMULAS:
RCuota mensualPCapitaliTasa de interesnNmero de meses
2. CUADRO DE AMORTIZACIN:
PERODOCAPITALAMORTIZACININTERSCUOTATasa (i)0280000---12787831217280040170.0122775531229278840170.0132763121242277640170.0142750581254276340170.0152737911267275140170.0162725121279273840170.0172712201292272540170.0182699151305271240170.0192685971318269940170.01102672661331268640170.01112659211345267340170.01122645631358265940170.01132631911372264640170.01142618061385263240170.01152604071399261840170.01162589941413260440170.01172575671427259040170.01182561251442257640170.01192546691456256140170.01202531991470254740170.01212517141485253240170.01222502141500251740170.01232486981515250240170.01242471681530248740170.01252456231546247240170.01262440621561245640170.01272424851577244140170.01282408931592242540170.01292392851608240940170.01302376601624239340170.01312360201641237740170.01322343631657236040170.01332326891674234440170.01342309991690232740170.01352292921707231040170.01362275671724229340170.01372258261742227640170.01382240671759225840170.01392222901777224140170.01402204961794222340170.01412186841812220540170.01422168541830218740170.01432150051849216940170.01442131381867215040170.01452112521886213140170.01462093471905211340170.01472074241924209340170.01482054811943207440170.01492035181962205540170.01502015361982203540170.01511995342002201540170.01521975132022199540170.01531954712042197540170.01541934082062195540170.01551913252083193440170.01561892212104191340170.01571870962125189240170.01581849502146187140170.01591827822168184940170.01601805932189182840170.01611783822211180640170.01621761482233178440170.01631738922256176140170.01641716142278173940170.01651693132301171640170.01661669892324169340170.01671646422347167040170.01681622712371164640170.01691598772394162340170.01701574582418159940170.01711550162443157540170.01721525482467155040170.01731500572492152540170.01741475402517150140170.01751449982542147540170.01761424312567145040170.01771398382593142440170.01781372192619139840170.01791345752645137240170.01801319032671134640170.01811292052698131940170.01821264802725129240170.01831237272752126540170.01841209472780123740170.01851181402808120940170.01861153042836118140170.01871124402864115340170.01881095472893112440170.01891066252922109540170.01901036742951106640170.01911006942980103740170.0192976843010100740170.019394643304097740170.019491573307194640170.019588471310191640170.019685339313288540170.019782175316485340170.019878979319582240170.019975752322779040170.0110072492326075840170.0110169200329272540170.0110265875332569240170.0110362516335865940170.0110459124339262540170.0110555699342659140170.0110652238346055740170.0110748743349552240170.0110845214353048740170.0110941649356545240170.0111038048360141640170.0111134411363738040170.0111230738367334440170.0111327028371030740170.0111423282374727040170.0111519497378423340170.0111615675382219540170.0111711814386015740170.011187915389911840170.01119397739387940170.01120039774040170.011210.011220.011230.011240.011250.011260.011270.011280.011290.011300.011310.011320.011330.011340.011350.011360.011370.011380.011390.011400.011410.011420.011430.011440.011450.011460.011470.011480.011490.011500.011510.011520.011530.011540.011550.011560.011570.011580.011590.011600.011610.011620.011630.011640.011650.011660.011670.011680.011690.011700.011710.011720.011730.011740.011750.011760.011770.011780.011790.011800.011810.011820.011830.011840.011850.011860.011870.011880.011890.011900.011910.011920.011930.011940.011950.011960.011970.011980.011990.012000.012010.012020.012030.012040.012050.012060.012070.012080.012090.012100.012110.012120.012130.012140.012150.012160.012170.012180.012190.012200.012210.012220.012230.012240.012250.012260.012270.012280.012290.012300.012310.012320.012330.012340.012350.012360.012370.012380.012390.012400.01202062482062
Hoja2
Hoja3