From a1f37240b7d4d47887135eff1b59ebe4ca6d40b5 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Sun, 8 Jan 2017 17:30:02 +0100 Subject: add IRR, IPMT, ISPMT test case Change-Id: I4179ec9fb31e4b7cb91f2dcd168048d403ab8a76 Reviewed-on: https://gerrit.libreoffice.org/32841 Reviewed-by: Markus Mohrhard Tested-by: Markus Mohrhard --- sc/qa/unit/data/functions/financial/fods/ipmt.fods | 1802 ++++ sc/qa/unit/data/functions/financial/fods/irr.fods | 10181 +++++++++++++++++++ .../unit/data/functions/financial/fods/ispmt.fods | 1938 ++++ 3 files changed, 13921 insertions(+) create mode 100644 sc/qa/unit/data/functions/financial/fods/ipmt.fods create mode 100644 sc/qa/unit/data/functions/financial/fods/irr.fods create mode 100644 sc/qa/unit/data/functions/financial/fods/ispmt.fods (limited to 'sc') diff --git a/sc/qa/unit/data/functions/financial/fods/ipmt.fods b/sc/qa/unit/data/functions/financial/fods/ipmt.fods new file mode 100644 index 000000000000..727d77c0088e --- /dev/null +++ b/sc/qa/unit/data/functions/financial/fods/ipmt.fods @@ -0,0 +1,1802 @@ + + + + 2017-01-08T17:26:18.147481385P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/92a1ad1f36b6d3cc13135a8c0805508933011577 + + + 0 + 0 + 34080 + 18721 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + 4 + 21 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + Sheet2 + 1241 + 0 + 90 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + false + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + € + + + + + + - + € + + + + + + + Kč + + + - + + Kč + + + + + Kč + + + + - + + Kč + + + + + Kč + + + - + + Kč + + + + + Kč + + + + - + + Kč + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + Kč + + + - + + + Kč + + + + + - Kč + + + + + + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + + + Kč + + + - + + + Kč + + + + + - + + Kč + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + Yes + + + Yes + + + No + + + + + True + + + True + + + False + + + + + On + + + On + + + Off + + + + + ¥€ + + + + + + + + + ( + € + + + + + ) + + + + + + € + + + + - + + + € + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + % + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + + + + + + + + + + + + + IPMT Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple IPMT formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Data + + + Description + + + + + + + + + + + + -352.97 Kč + + + -352.973422514773 + + + TRUE + + + =IPMT(0.05,5,7,15000) + + + + + 10.00% + + + Annual interest + + + + + + + + + + + + -22.61 Kč + + + -22.6129267839967 + + + TRUE + + + =IPMT(0.075/12, 8, 2*12, 5000) + + + + + 1 + + + Period for which you want to find the interest paid. + + + + + + + + + + + + -8.06 Kč + + + -8.06341136318208 + + + TRUE + + + =IPMT(0.06/52, 30, 4*52, 8000, 0 ,1) + + + + 3 + + + Years of loan + + + + + + + + + + + + -256.50 Kč + + + -256.504747019891 + + + TRUE + + + =IPMT(0.0525/1, 4, 10*1, 6500) + + + + 8000 + + + Present value of loan + + + + + + + + + + + -66.67 Kč + + + -66.6666666666667 + + + TRUE + + + =IPMT(I2/12, I3, I4*12,I5) + + + + + + + + + + + + -292.45 Kč + + + -292.447129909365 + + + TRUE + + + =IPMT(I2, 3,I4, I5) + + + + + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =IPMT(0,5,7,15000) + + + + + + + + + + + Err:502 + + + error + + + TRUE + + + =IPMT(0.05,0,7,15000) + + + + + + + + + Err:502 + + + error + + + TRUE + + + =IPMT(0.05,5,0,15000) + + + + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =IPMT(0.05,5,7,0) + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =IPMT(0.05,5,7,) + + + + + + + + Err:511 + + + error + + + TRUE + + + =IPMT(0.05,5,7) + + + + + + + + + + + Err:502 + + + error + + + TRUE + + + =IPMT(0.05,5,,15000) + + + + + + -8.06 Kč + + + -8.06341136318208 + + + TRUE + + + =IPMT(0.06/52, 30, 4*52, 8000, ,1) + + + + + + + + -8.07 Kč + + + -8.07271529937037 + + + TRUE + + + =IPMT(0.06/52, 30, 4*52, 8000, 0 ) + + + + + + + + + + + + + + + + + + + + + + + + + + + + -8.06 Kč + + + error + + + + =IPMT(0.06/52, 30, 4*52, 8000, 0 ,2) + + + Type parameter = 0 or 1 + + + + + + -8.06 Kč + + + error + + + + =IPMT(0.06/52, 30, 4*52, 8000, 0 ,-2) + + + Tdf#100650 + + + + + + + + + + + + + + + IPMTSummary: Returns the amount of an annuity payment going towards interest.Syntax: IPMT( Number Rate ; Number Period ; Number Nper ; Number PV [ ; Number FV = 0 [ ; Number Type = 0 ] ] )Returns: CurrencyConstraints: None.Semantics: Computes the interest portion of an amortized payment for a constant interest rate and regular payments. The interest payment is the interest rate multiplied by the balance at the beginning of the period. The parameters are:Rate: The periodic interest rate.Period: The period for which the interest payment is computed.Nper: The total number of periods for which the payments are madePV: The present value (e.g. The initial loan amount).FV: The future value (optional) at the end of the periods. Zero if omitted.Type: the due date for the payments (optional). Zero if omitted. If type is 1, then payments are made at the beginning of each period. If type is 0, then payments are made at the end of each period. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/financial/fods/irr.fods b/sc/qa/unit/data/functions/financial/fods/irr.fods new file mode 100644 index 000000000000..ced44ffd0c49 --- /dev/null +++ b/sc/qa/unit/data/functions/financial/fods/irr.fods @@ -0,0 +1,10181 @@ + + + + 2017-01-08T17:28:26.818403505P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/92a1ad1f36b6d3cc13135a8c0805508933011577 + + + 0 + 0 + 41361 + 17397 + + + view1 + + + 2 + 8 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + 4 + 16 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + 6 + 10 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + Sheet2 + 1241 + 0 + 90 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + false + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + € + + + + + + - + € + + + + + + + Kč + + + - + + Kč + + + + + Kč + + + + - + + Kč + + + + + Kč + + + - + + Kč + + + + + Kč + + + + - + + Kč + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + Kč + + + - + + + Kč + + + + + - Kč + + + + + + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + + + Kč + + + - + + + Kč + + + + + - + + Kč + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + Yes + + + Yes + + + No + + + + + True + + + True + + + False + + + + + On + + + On + + + Off + + + + + ¥€ + + + + + + + + + ( + € + + + + + ) + + + + + + € + + + + - + + + € + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + $ + + + + + ($ + + ) + + + + $ + + + + + + ($ + + ) + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + + $ + + + + + + $ + + ( + + ) + + + $ + + - + + + + + + + + + + + + + + % + + + + % + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + % + + + + % + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + + + + + + + + + + + + + IRR Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple IRR formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + -10000 + + + + -7500 + + + -10000 + + + + Data + + + Description + + + + + + + + + + 11.33% + + + 0.113321028236252 + + + TRUE + + + =IRR(G1:G4) + + + + + 3500 + + + + 3000 + + + 3400 + + + + -70000 + + + Initial cost of a business + + + + + + + + + + -114.53% + + + -1.14534844077746 + + + TRUE + + + =IRR(G1:G4,1) + + + + + 7600 + + + + 5000 + + + 6500 + + + + 12000 + + + Net income for the first year + + + + + + + + + + 27.67% + + + 0.276668412777335 + + + TRUE + + + =IRR(I1:I5) + + + + 1000 + + + + 1200 + + + 1000 + + + + 15000 + + + Net income for the second year + + + + + + + + + + 4.99% + + + 0.049858473742953 + + + TRUE + + + =IRR(J1:J4) + + + + 4000 + + + + + 18000 + + + Net income for the third year + + + + + + + + + + -2.12% + + + -0.021244848273411 + + + TRUE + + + =IRR(L2:L6) + + + + + 21000 + + + Net income for the fourth year + + + + + + + + + 8.66% + + + 0.086630948036532 + + + TRUE + + + =IRR(L2:L7) + + + + + 26000 + + + Net income for the fifth year + + + + + + + + + -44.35% + + + -0.443506941334741 + + + TRUE + + + =IRR(L2:L4,-0.1) + + + + + + + + + + + Err:504 + + + error + + + TRUE + + + =IRR(,) + + + + + + + + + + Err:504 + + + error + + + TRUE + + + =IRR(,0.1) + + + + + + + + + + Err:511 + + + error + + + TRUE + + + =IRR() + + + + + + + + + + 0.38% + + + 0.003775673822856 + + + TRUE + + + =IRR(bug40460.G11:bug40460.G251,0) + + + + 10 + + + + + + + + + + + + + 20 + + + + + + + + + + + + + + -35 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Err:523 + + + 0.003775673822856 + + + + =IRR(bug40460.G11:bug40460.G251) + + + Tdf#40460 + + + + + + Err:504 + + + + + =IRR(G12:G13~G14) + + + AOO#118154 enhancement + + + + + + Err:504 + + + + + =IRR( {-10000;5000;5000;5000}) + + + Tdf#58585 enhancement + + + + + + + + + IRRSummary: Compute the internal rate of return for a series of cash flows.Syntax: IRR( NumberSequence Values [ ; Number Guess = 0.1 ] )Returns: PercentageConstraints: None.Semantics: Compute the internal rate of return for a series of cash flows.If provided, Guess is an estimate of the interest rate to start the iterative computation. If omitted, the value 0.1 (10%) is assumed.The result of IRR is the rate at which the NPV() function will return zero with the given values.There is no closed form for IRR. Evaluators may return an approximate solution using an iterative method, in which case the Guess parameter may be used to initialize the iteration. If the evaluator is unable to converge on a solution given a particular Guess, it may return an Error. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + https://bugs.documentfoundation.org/show_bug.cgi?id=40460 + + + + + + + PRESTAMO A COSTE AMORTIZADO HIPOTECA NAVE TORRECILLA + + + + + + + + LibreOffice gives "Err:523" at cell G11. However, the value 0.3775... is a solution. This solution is found by Gnumeric on the same spreadsheet file. By the way, MS Excel fails as LibreOffice does. + + + + + + Préstamo: 1,000,000 € + + + + Vencimiento: + + + Mensual + + + + + + interés:4,25% + + + + nº de años: 20 + + + + + + Fecha: 30/06/08 + + + 11/08/2010 + + + Gtos. Formaliz: 23,772,40 € + + + + + + + + + + + + + + + C U A D R O D E A M O R T I Z A C I O N + + + + + + TIR + + + VAN a TIR interes + + + + + + Periodo + + + fecha + + + cuota + + + intereses + + + capital + + + pte amortiz + + + Err:523 + + + Err:523 + + + + + + + 0 + + + 11/08/2010 + + + + 1,000,000.00 + + + -976,227.60 + + + If 0,00 then OK + + + -976,227.60 + + + + + + 1 + + + 12/08/2010 + + + 6,192.34 + + + 3,541.67 + + + 2,650.67 + + + 997,349.33 + + + 6,192.34 + + + + 6,192.34 + + + + + + 2 + + + 01/08/2011 + + + 6,192.34 + + + 3,532.28 + + + 2,660.06 + + + 994,689.27 + + + 6,192.34 + + + + 6,192.34 + + + + + + 3 + + + 02/08/2011 + + + 6,192.34 + + + 3,522.86 + + + 2,669.48 + + + 992,019.78 + + + 6,192.34 + + + + 6,192.34 + + + + + + 4 + + + 03/08/2011 + + + 6,192.34 + + + 3,513.40 + + + 2,678.94 + + + 989,340.85 + + + 6,192.34 + + + + 6,192.34 + + + + + + 5 + + + 04/08/2011 + + + 6,192.34 + + + 3,503.92 + + + 2,688.42 + + + 986,652.42 + + + 6,192.34 + + + + 6,192.34 + + + + + + 6 + + + 05/08/2011 + + + 6,192.34 + + + 3,494.39 + + + 2,697.95 + + + 983,954.48 + + + 6,192.34 + + + + 6,192.34 + + + + + + 7 + + + 06/08/2011 + + + 6,192.34 + + + 3,484.84 + + + 2,707.50 + + + 981,246.98 + + + 6,192.34 + + + + 6,192.34 + + + + + + 8 + + + 07/08/2011 + + + 6,192.34 + + + 3,475.25 + + + 2,717.09 + + + 978,529.88 + + + 6,192.34 + + + + 6,192.34 + + + + + + 9 + + + 08/08/2011 + + + 6,192.34 + + + 3,465.63 + + + 2,726.71 + + + 975,803.17 + + + 6,192.34 + + + + 6,192.34 + + + + + + 10 + + + 09/08/2011 + + + 6,192.34 + + + 3,455.97 + + + 2,736.37 + + + 973,066.80 + + + 6,192.34 + + + + 6,192.34 + + + + + + 11 + + + 10/08/2011 + + + 6,192.34 + + + 3,446.28 + + + 2,746.06 + + + 970,320.74 + + + 6,192.34 + + + + 6,192.34 + + + + + + 12 + + + 11/08/2011 + + + 6,192.34 + + + 3,436.55 + + + 2,755.79 + + + 967,564.95 + + + 6,192.34 + + + + 6,192.34 + + + + + + 13 + + + 12/08/2011 + + + 6,192.34 + + + 3,426.79 + + + 2,765.55 + + + 964,799.40 + + + 6,192.34 + + + + 6,192.34 + + + + + + 14 + + + 01/08/2012 + + + 6,192.34 + + + 3,417.00 + + + 2,775.34 + + + 962,024.06 + + + 6,192.34 + + + + 6,192.34 + + + + + + 15 + + + 02/08/2012 + + + 6,192.34 + + + 3,407.17 + + + 2,785.17 + + + 959,238.89 + + + 6,192.34 + + + + 6,192.34 + + + + + + 16 + + + 03/08/2012 + + + 6,192.34 + + + 3,397.30 + + + 2,795.04 + + + 956,443.86 + + + 6,192.34 + + + + 6,192.34 + + + + + + 17 + + + 04/08/2012 + + + 6,192.34 + + + 3,387.41 + + + 2,804.93 + + + 953,638.92 + + + 6,192.34 + + + + 6,192.34 + + + + + + 18 + + + 05/08/2012 + + + 6,192.34 + + + 3,377.47 + + + 2,814.87 + + + 950,824.05 + + + 6,192.34 + + + + 6,192.34 + + + + + + 19 + + + 06/08/2012 + + + 6,192.34 + + + 3,367.50 + + + 2,824.84 + + + 947,999.21 + + + 6,192.34 + + + + 6,192.34 + + + + + + 20 + + + 07/08/2012 + + + 6,192.34 + + + 3,357.50 + + + 2,834.84 + + + 945,164.37 + + + 6,192.34 + + + + 6,192.34 + + + + + + 21 + + + 08/08/2012 + + + 6,192.34 + + + 3,347.46 + + + 2,844.88 + + + 942,319.49 + + + 6,192.34 + + + + 6,192.34 + + + + + + 22 + + + 09/08/2012 + + + 6,192.34 + + + 3,337.38 + + + 2,854.96 + + + 939,464.53 + + + 6,192.34 + + + + 6,192.34 + + + + + + 23 + + + 10/08/2012 + + + 6,192.34 + + + 3,327.27 + + + 2,865.07 + + + 936,599.46 + + + 6,192.34 + + + + 6,192.34 + + + + + + 24 + + + 11/08/2012 + + + 6,192.34 + + + 3,317.12 + + + 2,875.22 + + + 933,724.24 + + + 6,192.34 + + + + 6,192.34 + + + + + + 25 + + + 12/08/2012 + + + 6,192.34 + + + 3,306.94 + + + 2,885.40 + + + 930,838.84 + + + 6,192.34 + + + + 6,192.34 + + + + + + 26 + + + 01/08/2013 + + + 6,192.34 + + + 3,296.72 + + + 2,895.62 + + + 927,943.22 + + + 6,192.34 + + + + 6,192.34 + + + + + + 27 + + + 02/08/2013 + + + 6,192.34 + + + 3,286.47 + + + 2,905.87 + + + 925,037.35 + + + 6,192.34 + + + + 6,192.34 + + + + + + 28 + + + 03/08/2013 + + + 6,192.34 + + + 3,276.17 + + + 2,916.17 + + + 922,121.18 + + + 6,192.34 + + + + 6,192.34 + + + + + + 29 + + + 04/08/2013 + + + 6,192.34 + + + 3,265.85 + + + 2,926.49 + + + 919,194.69 + + + 6,192.34 + + + + 6,192.34 + + + + + + 30 + + + 05/08/2013 + + + 6,192.34 + + + 3,255.48 + + + 2,936.86 + + + 916,257.83 + + + 6,192.34 + + + + 6,192.34 + + + + + + 31 + + + 06/08/2013 + + + 6,192.34 + + + 3,245.08 + + + 2,947.26 + + + 913,310.57 + + + 6,192.34 + + + + 6,192.34 + + + + + + 32 + + + 07/08/2013 + + + 6,192.34 + + + 3,234.64 + + + 2,957.70 + + + 910,352.87 + + + 6,192.34 + + + + 6,192.34 + + + + + + 33 + + + 08/08/2013 + + + 6,192.34 + + + 3,224.17 + + + 2,968.17 + + + 907,384.70 + + + 6,192.34 + + + + 6,192.34 + + + + + + 34 + + + 09/08/2013 + + + 6,192.34 + + + 3,213.65 + + + 2,978.69 + + + 904,406.01 + + + 6,192.34 + + + + 6,192.34 + + + + + + 35 + + + 10/08/2013 + + + 6,192.34 + + + 3,203.10 + + + 2,989.24 + + + 901,416.78 + + + 6,192.34 + + + + 6,192.34 + + + + + + 36 + + + 11/08/2013 + + + 6,192.34 + + + 3,192.52 + + + 2,999.82 + + + 898,416.95 + + + 6,192.34 + + + + 6,192.34 + + + + + + 37 + + + 12/08/2013 + + + 6,192.34 + + + 3,181.89 + + + 3,010.45 + + + 895,406.51 + + + 6,192.34 + + + + 6,192.34 + + + + + + 38 + + + 01/08/2014 + + + 6,192.34 + + + 3,171.23 + + + 3,021.11 + + + 892,385.40 + + + 6,192.34 + + + + 6,192.34 + + + + + + 39 + + + 02/08/2014 + + + 6,192.34 + + + 3,160.53 + + + 3,031.81 + + + 889,353.59 + + + 6,192.34 + + + + 6,192.34 + + + + + + 40 + + + 03/08/2014 + + + 6,192.34 + + + 3,149.79 + + + 3,042.55 + + + 886,311.04 + + + 6,192.34 + + + + 6,192.34 + + + + + + 41 + + + 04/08/2014 + + + 6,192.34 + + + 3,139.02 + + + 3,053.32 + + + 883,257.72 + + + 6,192.34 + + + + 6,192.34 + + + + + + 42 + + + 05/08/2014 + + + 6,192.34 + + + 3,128.20 + + + 3,064.14 + + + 880,193.59 + + + 6,192.34 + + + + 6,192.34 + + + + + + 43 + + + 06/08/2014 + + + 6,192.34 + + + 3,117.35 + + + 3,074.99 + + + 877,118.60 + + + 6,192.34 + + + + 6,192.34 + + + + + + 44 + + + 07/08/2014 + + + 6,192.34 + + + 3,106.46 + + + 3,085.88 + + + 874,032.72 + + + 6,192.34 + + + + 6,192.34 + + + + + + 45 + + + 08/08/2014 + + + 6,192.34 + + + 3,095.53 + + + 3,096.81 + + + 870,935.91 + + + 6,192.34 + + + + 6,192.34 + + + + + + 46 + + + 09/08/2014 + + + 6,192.34 + + + 3,084.56 + + + 3,107.78 + + + 867,828.14 + + + 6,192.34 + + + + 6,192.34 + + + + + + 47 + + + 10/08/2014 + + + 6,192.34 + + + 3,073.56 + + + 3,118.78 + + + 864,709.36 + + + 6,192.34 + + + + 6,192.34 + + + + + + 48 + + + 11/08/2014 + + + 6,192.34 + + + 3,062.51 + + + 3,129.83 + + + 861,579.53 + + + 6,192.34 + + + + 6,192.34 + + + + + + 49 + + + 12/08/2014 + + + 6,192.34 + + + 3,051.43 + + + 3,140.91 + + + 858,438.62 + + + 6,192.34 + + + + 6,192.34 + + + + + + 50 + + + 01/08/2015 + + + 6,192.34 + + + 3,040.30 + + + 3,152.04 + + + 855,286.58 + + + 6,192.34 + + + + 6,192.34 + + + + + + 51 + + + 02/08/2015 + + + 6,192.34 + + + 3,029.14 + + + 3,163.20 + + + 852,123.38 + + + 6,192.34 + + + + 6,192.34 + + + + + + 52 + + + 03/08/2015 + + + 6,192.34 + + + 3,017.94 + + + 3,174.40 + + + 848,948.98 + + + 6,192.34 + + + + 6,192.34 + + + + + + 53 + + + 04/08/2015 + + + 6,192.34 + + + 3,006.69 + + + 3,185.65 + + + 845,763.33 + + + 6,192.34 + + + + 6,192.34 + + + + + + 54 + + + 05/08/2015 + + + 6,192.34 + + + 2,995.41 + + + 3,196.93 + + + 842,566.40 + + + 6,192.34 + + + + 6,192.34 + + + + + + 55 + + + 06/08/2015 + + + 6,192.34 + + + 2,984.09 + + + 3,208.25 + + + 839,358.15 + + + 6,192.34 + + + + 6,192.34 + + + + + + 56 + + + 07/08/2015 + + + 6,192.34 + + + 2,972.73 + + + 3,219.61 + + + 836,138.54 + + + 6,192.34 + + + + 6,192.34 + + + + + + 57 + + + 08/08/2015 + + + 6,192.34 + + + 2,961.32 + + + 3,231.02 + + + 832,907.52 + + + 6,192.34 + + + + 6,192.34 + + + + + + 58 + + + 09/08/2015 + + + 6,192.34 + + + 2,949.88 + + + 3,242.46 + + + 829,665.06 + + + 6,192.34 + + + + 6,192.34 + + + + + + 59 + + + 10/08/2015 + + + 6,192.34 + + + 2,938.40 + + + 3,253.94 + + + 826,411.12 + + + 6,192.34 + + + + 6,192.34 + + + + + + 60 + + + 11/08/2015 + + + 6,192.34 + + + 2,926.87 + + + 3,265.47 + + + 823,145.65 + + + 6,192.34 + + + + 6,192.34 + + + + + + 61 + + + 12/08/2015 + + + 6,192.34 + + + 2,915.31 + + + 3,277.03 + + + 819,868.62 + + + 6,192.34 + + + + 6,192.34 + + + + + + 62 + + + 01/08/2016 + + + 6,192.34 + + + 2,903.70 + + + 3,288.64 + + + 816,579.98 + + + 6,192.34 + + + + 6,192.34 + + + + + + 63 + + + 02/08/2016 + + + 6,192.34 + + + 2,892.05 + + + 3,300.29 + + + 813,279.70 + + + 6,192.34 + + + + 6,192.34 + + + + + + 64 + + + 03/08/2016 + + + 6,192.34 + + + 2,880.37 + + + 3,311.97 + + + 809,967.72 + + + 6,192.34 + + + + 6,192.34 + + + + + + 65 + + + 04/08/2016 + + + 6,192.34 + + + 2,868.64 + + + 3,323.70 + + + 806,644.02 + + + 6,192.34 + + + + 6,192.34 + + + + + + 66 + + + 05/08/2016 + + + 6,192.34 + + + 2,856.86 + + + 3,335.48 + + + 803,308.54 + + + 6,192.34 + + + + 6,192.34 + + + + + + 67 + + + 06/08/2016 + + + 6,192.34 + + + 2,845.05 + + + 3,347.29 + + + 799,961.25 + + + 6,192.34 + + + + 6,192.34 + + + + + + 68 + + + 07/08/2016 + + + 6,192.34 + + + 2,833.20 + + + 3,359.14 + + + 796,602.11 + + + 6,192.34 + + + + 6,192.34 + + + + + + 69 + + + 08/08/2016 + + + 6,192.34 + + + 2,821.30 + + + 3,371.04 + + + 793,231.07 + + + 6,192.34 + + + + 6,192.34 + + + + + + 70 + + + 09/08/2016 + + + 6,192.34 + + + 2,809.36 + + + 3,382.98 + + + 789,848.09 + + + 6,192.34 + + + + 6,192.34 + + + + + + 71 + + + 10/08/2016 + + + 6,192.34 + + + 2,797.38 + + + 3,394.96 + + + 786,453.13 + + + 6,192.34 + + + + 6,192.34 + + + + + + 72 + + + 11/08/2016 + + + 6,192.34 + + + 2,785.35 + + + 3,406.99 + + + 783,046.14 + + + 6,192.34 + + + + 6,192.34 + + + + + + 73 + + + 12/08/2016 + + + 6,192.34 + + + 2,773.29 + + + 3,419.05 + + + 779,627.09 + + + 6,192.34 + + + + 6,192.34 + + + + + + 74 + + + 01/08/2017 + + + 6,192.34 + + + 2,761.18 + + + 3,431.16 + + + 776,195.93 + + + 6,192.34 + + + + 6,192.34 + + + + + + 75 + + + 02/08/2017 + + + 6,192.34 + + + 2,749.03 + + + 3,443.31 + + + 772,752.62 + + + 6,192.34 + + + + 6,192.34 + + + + + + 76 + + + 03/08/2017 + + + 6,192.34 + + + 2,736.83 + + + 3,455.51 + + + 769,297.11 + + + 6,192.34 + + + + 6,192.34 + + + + + + 77 + + + 04/08/2017 + + + 6,192.34 + + + 2,724.59 + + + 3,467.75 + + + 765,829.36 + + + 6,192.34 + + + + 6,192.34 + + + + + + 78 + + + 05/08/2017 + + + 6,192.34 + + + 2,712.31 + + + 3,480.03 + + + 762,349.34 + + + 6,192.34 + + + + 6,192.34 + + + + + + 79 + + + 06/08/2017 + + + 6,192.34 + + + 2,699.99 + + + 3,492.35 + + + 758,856.98 + + + 6,192.34 + + + + 6,192.34 + + + + + + 80 + + + 07/08/2017 + + + 6,192.34 + + + 2,687.62 + + + 3,504.72 + + + 755,352.26 + + + 6,192.34 + + + + 6,192.34 + + + + + + 81 + + + 08/08/2017 + + + 6,192.34 + + + 2,675.21 + + + 3,517.13 + + + 751,835.13 + + + 6,192.34 + + + + 6,192.34 + + + + + + 82 + + + 09/08/2017 + + + 6,192.34 + + + 2,662.75 + + + 3,529.59 + + + 748,305.54 + + + 6,192.34 + + + + 6,192.34 + + + + + + 83 + + + 10/08/2017 + + + 6,192.34 + + + 2,650.25 + + + 3,542.09 + + + 744,763.45 + + + 6,192.34 + + + + 6,192.34 + + + + + + 84 + + + 11/08/2017 + + + 6,192.34 + + + 2,637.70 + + + 3,554.64 + + + 741,208.81 + + + 6,192.34 + + + + 6,192.34 + + + + + + 85 + + + 12/08/2017 + + + 6,192.34 + + + 2,625.11 + + + 3,567.23 + + + 737,641.58 + + + 6,192.34 + + + + 6,192.34 + + + + + + 86 + + + 01/08/2018 + + + 6,192.34 + + + 2,612.48 + + + 3,579.86 + + + 734,061.72 + + + 6,192.34 + + + + 6,192.34 + + + + + + 87 + + + 02/08/2018 + + + 6,192.34 + + + 2,599.80 + + + 3,592.54 + + + 730,469.19 + + + 6,192.34 + + + + 6,192.34 + + + + + + 88 + + + 03/08/2018 + + + 6,192.34 + + + 2,587.08 + + + 3,605.26 + + + 726,863.92 + + + 6,192.34 + + + + 6,192.34 + + + + + + 89 + + + 04/08/2018 + + + 6,192.34 + + + 2,574.31 + + + 3,618.03 + + + 723,245.89 + + + 6,192.34 + + + + 6,192.34 + + + + + + 90 + + + 05/08/2018 + + + 6,192.34 + + + 2,561.50 + + + 3,630.84 + + + 719,615.05 + + + 6,192.34 + + + + 6,192.34 + + + + + + 91 + + + 06/08/2018 + + + 6,192.34 + + + 2,548.64 + + + 3,643.70 + + + 715,971.35 + + + 6,192.34 + + + + 6,192.34 + + + + + + 92 + + + 07/08/2018 + + + 6,192.34 + + + 2,535.73 + + + 3,656.61 + + + 712,314.74 + + + 6,192.34 + + + + 6,192.34 + + + + + + 93 + + + 08/08/2018 + + + 6,192.34 + + + 2,522.78 + + + 3,669.56 + + + 708,645.18 + + + 6,192.34 + + + + 6,192.34 + + + + + + 94 + + + 09/08/2018 + + + 6,192.34 + + + 2,509.79 + + + 3,682.55 + + + 704,962.63 + + + 6,192.34 + + + + 6,192.34 + + + + + + 95 + + + 10/08/2018 + + + 6,192.34 + + + 2,496.74 + + + 3,695.60 + + + 701,267.03 + + + 6,192.34 + + + + 6,192.34 + + + + + + 96 + + + 11/08/2018 + + + 6,192.34 + + + 2,483.65 + + + 3,708.69 + + + 697,558.34 + + + 6,192.34 + + + + 6,192.34 + + + + + + 97 + + + 12/08/2018 + + + 6,192.34 + + + 2,470.52 + + + 3,721.82 + + + 693,836.52 + + + 6,192.34 + + + + 6,192.34 + + + + + + 98 + + + 01/08/2019 + + + 6,192.34 + + + 2,457.34 + + + 3,735.00 + + + 690,101.52 + + + 6,192.34 + + + + 6,192.34 + + + + + + 99 + + + 02/08/2019 + + + 6,192.34 + + + 2,444.11 + + + 3,748.23 + + + 686,353.29 + + + 6,192.34 + + + + 6,192.34 + + + + + + 100 + + + 03/08/2019 + + + 6,192.34 + + + 2,430.83 + + + 3,761.51 + + + 682,591.78 + + + 6,192.34 + + + + 6,192.34 + + + + + + 101 + + + 04/08/2019 + + + 6,192.34 + + + 2,417.51 + + + 3,774.83 + + + 678,816.96 + + + 6,192.34 + + + + 6,192.34 + + + + + + 102 + + + 05/08/2019 + + + 6,192.34 + + + 2,404.14 + + + 3,788.20 + + + 675,028.76 + + + 6,192.34 + + + + 6,192.34 + + + + + + 103 + + + 06/08/2019 + + + 6,192.34 + + + 2,390.73 + + + 3,801.61 + + + 671,227.15 + + + 6,192.34 + + + + 6,192.34 + + + + + + 104 + + + 07/08/2019 + + + 6,192.34 + + + 2,377.26 + + + 3,815.08 + + + 667,412.07 + + + 6,192.34 + + + + 6,192.34 + + + + + + 105 + + + 08/08/2019 + + + 6,192.34 + + + 2,363.75 + + + 3,828.59 + + + 663,583.48 + + + 6,192.34 + + + + 6,192.34 + + + + + + 106 + + + 09/08/2019 + + + 6,192.34 + + + 2,350.19 + + + 3,842.15 + + + 659,741.33 + + + 6,192.34 + + + + 6,192.34 + + + + + + 107 + + + 10/08/2019 + + + 6,192.34 + + + 2,336.58 + + + 3,855.76 + + + 655,885.57 + + + 6,192.34 + + + + 6,192.34 + + + + + + 108 + + + 11/08/2019 + + + 6,192.34 + + + 2,322.93 + + + 3,869.41 + + + 652,016.16 + + + 6,192.34 + + + + 6,192.34 + + + + + + 109 + + + 12/08/2019 + + + 6,192.34 + + + 2,309.22 + + + 3,883.12 + + + 648,133.05 + + + 6,192.34 + + + + 6,192.34 + + + + + + 110 + + + 01/08/2020 + + + 6,192.34 + + + 2,295.47 + + + 3,896.87 + + + 644,236.18 + + + 6,192.34 + + + + 6,192.34 + + + + + + 111 + + + 02/08/2020 + + + 6,192.34 + + + 2,281.67 + + + 3,910.67 + + + 640,325.51 + + + 6,192.34 + + + + 6,192.34 + + + + + + 112 + + + 03/08/2020 + + + 6,192.34 + + + 2,267.82 + + + 3,924.52 + + + 636,400.99 + + + 6,192.34 + + + + 6,192.34 + + + + + + 113 + + + 04/08/2020 + + + 6,192.34 + + + 2,253.92 + + + 3,938.42 + + + 632,462.57 + + + 6,192.34 + + + + 6,192.34 + + + + + + 114 + + + 05/08/2020 + + + 6,192.34 + + + 2,239.97 + + + 3,952.37 + + + 628,510.20 + + + 6,192.34 + + + + 6,192.34 + + + + + + 115 + + + 06/08/2020 + + + 6,192.34 + + + 2,225.97 + + + 3,966.37 + + + 624,543.83 + + + 6,192.34 + + + + 6,192.34 + + + + + + 116 + + + 07/08/2020 + + + 6,192.34 + + + 2,211.93 + + + 3,980.41 + + + 620,563.42 + + + 6,192.34 + + + + 6,192.34 + + + + + + 117 + + + 08/08/2020 + + + 6,192.34 + + + 2,197.83 + + + 3,994.51 + + + 616,568.91 + + + 6,192.34 + + + + 6,192.34 + + + + + + 118 + + + 09/08/2020 + + + 6,192.34 + + + 2,183.68 + + + 4,008.66 + + + 612,560.25 + + + 6,192.34 + + + + 6,192.34 + + + + + + 119 + + + 10/08/2020 + + + 6,192.34 + + + 2,169.48 + + + 4,022.86 + + + 608,537.39 + + + 6,192.34 + + + + 6,192.34 + + + + + + 120 + + + 11/08/2020 + + + 6,192.34 + + + 2,155.24 + + + 4,037.10 + + + 604,500.29 + + + 6,192.34 + + + + 6,192.34 + + + + + + 121 + + + 12/08/2020 + + + 6,192.34 + + + 2,140.94 + + + 4,051.40 + + + 600,448.89 + + + 6,192.34 + + + + 6,192.34 + + + + + + 122 + + + 01/08/2021 + + + 6,192.34 + + + 2,126.59 + + + 4,065.75 + + + 596,383.14 + + + 6,192.34 + + + + 6,192.34 + + + + + + 123 + + + 02/08/2021 + + + 6,192.34 + + + 2,112.19 + + + 4,080.15 + + + 592,302.99 + + + 6,192.34 + + + + 6,192.34 + + + + + + 124 + + + 03/08/2021 + + + 6,192.34 + + + 2,097.74 + + + 4,094.60 + + + 588,208.39 + + + 6,192.34 + + + + 6,192.34 + + + + + + 125 + + + 04/08/2021 + + + 6,192.34 + + + 2,083.24 + + + 4,109.10 + + + 584,099.29 + + + 6,192.34 + + + + 6,192.34 + + + + + + 126 + + + 05/08/2021 + + + 6,192.34 + + + 2,068.68 + + + 4,123.66 + + + 579,975.63 + + + 6,192.34 + + + + 6,192.34 + + + + + + 127 + + + 06/08/2021 + + + 6,192.34 + + + 2,054.08 + + + 4,138.26 + + + 575,837.37 + + + 6,192.34 + + + + 6,192.34 + + + + + + 128 + + + 07/08/2021 + + + 6,192.34 + + + 2,039.42 + + + 4,152.92 + + + 571,684.46 + + + 6,192.34 + + + + 6,192.34 + + + + + + 129 + + + 08/08/2021 + + + 6,192.34 + + + 2,024.72 + + + 4,167.62 + + + 567,516.83 + + + 6,192.34 + + + + 6,192.34 + + + + + + 130 + + + 09/08/2021 + + + 6,192.34 + + + 2,009.96 + + + 4,182.38 + + + 563,334.45 + + + 6,192.34 + + + + 6,192.34 + + + + + + 131 + + + 10/08/2021 + + + 6,192.34 + + + 1,995.14 + + + 4,197.20 + + + 559,137.25 + + + 6,192.34 + + + + 6,192.34 + + + + + + 132 + + + 11/08/2021 + + + 6,192.34 + + + 1,980.28 + + + 4,212.06 + + + 554,925.19 + + + 6,192.34 + + + + 6,192.34 + + + + + + 133 + + + 12/08/2021 + + + 6,192.34 + + + 1,965.36 + + + 4,226.98 + + + 550,698.21 + + + 6,192.34 + + + + 6,192.34 + + + + + + 134 + + + 01/08/2022 + + + 6,192.34 + + + 1,950.39 + + + 4,241.95 + + + 546,456.26 + + + 6,192.34 + + + + 6,192.34 + + + + + + 135 + + + 02/08/2022 + + + 6,192.34 + + + 1,935.37 + + + 4,256.97 + + + 542,199.28 + + + 6,192.34 + + + + 6,192.34 + + + + + + 136 + + + 03/08/2022 + + + 6,192.34 + + + 1,920.29 + + + 4,272.05 + + + 537,927.23 + + + 6,192.34 + + + + 6,192.34 + + + + + + 137 + + + 04/08/2022 + + + 6,192.34 + + + 1,905.16 + + + 4,287.18 + + + 533,640.05 + + + 6,192.34 + + + + 6,192.34 + + + + + + 138 + + + 05/08/2022 + + + 6,192.34 + + + 1,889.98 + + + 4,302.36 + + + 529,337.69 + + + 6,192.34 + + + + 6,192.34 + + + + + + 139 + + + 06/08/2022 + + + 6,192.34 + + + 1,874.74 + + + 4,317.60 + + + 525,020.08 + + + 6,192.34 + + + + 6,192.34 + + + + + + 140 + + + 07/08/2022 + + + 6,192.34 + + + 1,859.45 + + + 4,332.89 + + + 520,687.19 + + + 6,192.34 + + + + 6,192.34 + + + + + + 141 + + + 08/08/2022 + + + 6,192.34 + + + 1,844.10 + + + 4,348.24 + + + 516,338.95 + + + 6,192.34 + + + + 6,192.34 + + + + + + 142 + + + 09/08/2022 + + + 6,192.34 + + + 1,828.70 + + + 4,363.64 + + + 511,975.31 + + + 6,192.34 + + + + 6,192.34 + + + + + + 143 + + + 10/08/2022 + + + 6,192.34 + + + 1,813.25 + + + 4,379.09 + + + 507,596.22 + + + 6,192.34 + + + + 6,192.34 + + + + + + 144 + + + 11/08/2022 + + + 6,192.34 + + + 1,797.74 + + + 4,394.60 + + + 503,201.61 + + + 6,192.34 + + + + 6,192.34 + + + + + + 145 + + + 12/08/2022 + + + 6,192.34 + + + 1,782.17 + + + 4,410.17 + + + 498,791.45 + + + 6,192.34 + + + + 6,192.34 + + + + + + 146 + + + 01/08/2023 + + + 6,192.34 + + + 1,766.55 + + + 4,425.79 + + + 494,365.66 + + + 6,192.34 + + + + 6,192.34 + + + + + + 147 + + + 02/08/2023 + + + 6,192.34 + + + 1,750.88 + + + 4,441.46 + + + 489,924.20 + + + 6,192.34 + + + + 6,192.34 + + + + + + 148 + + + 03/08/2023 + + + 6,192.34 + + + 1,735.15 + + + 4,457.19 + + + 485,467.01 + + + 6,192.34 + + + + 6,192.34 + + + + + + 149 + + + 04/08/2023 + + + 6,192.34 + + + 1,719.36 + + + 4,472.98 + + + 480,994.03 + + + 6,192.34 + + + + 6,192.34 + + + + + + 150 + + + 05/08/2023 + + + 6,192.34 + + + 1,703.52 + + + 4,488.82 + + + 476,505.21 + + + 6,192.34 + + + + 6,192.34 + + + + + + 151 + + + 06/08/2023 + + + 6,192.34 + + + 1,687.62 + + + 4,504.72 + + + 472,000.49 + + + 6,192.34 + + + + 6,192.34 + + + + + + 152 + + + 07/08/2023 + + + 6,192.34 + + + 1,671.67 + + + 4,520.67 + + + 467,479.82 + + + 6,192.34 + + + + 6,192.34 + + + + + + 153 + + + 08/08/2023 + + + 6,192.34 + + + 1,655.66 + + + 4,536.68 + + + 462,943.14 + + + 6,192.34 + + + + 6,192.34 + + + + + + 154 + + + 09/08/2023 + + + 6,192.34 + + + 1,639.59 + + + 4,552.75 + + + 458,390.39 + + + 6,192.34 + + + + 6,192.34 + + + + + + 155 + + + 10/08/2023 + + + 6,192.34 + + + 1,623.47 + + + 4,568.87 + + + 453,821.51 + + + 6,192.34 + + + + 6,192.34 + + + + + + 156 + + + 11/08/2023 + + + 6,192.34 + + + 1,607.28 + + + 4,585.06 + + + 449,236.46 + + + 6,192.34 + + + + 6,192.34 + + + + + + 157 + + + 12/08/2023 + + + 6,192.34 + + + 1,591.05 + + + 4,601.29 + + + 444,635.16 + + + 6,192.34 + + + + 6,192.34 + + + + + + 158 + + + 01/08/2024 + + + 6,192.34 + + + 1,574.75 + + + 4,617.59 + + + 440,017.57 + + + 6,192.34 + + + + 6,192.34 + + + + + + 159 + + + 02/08/2024 + + + 6,192.34 + + + 1,558.40 + + + 4,633.94 + + + 435,383.63 + + + 6,192.34 + + + + 6,192.34 + + + + + + 160 + + + 03/08/2024 + + + 6,192.34 + + + 1,541.98 + + + 4,650.36 + + + 430,733.27 + + + 6,192.34 + + + + 6,192.34 + + + + + + 161 + + + 04/08/2024 + + + 6,192.34 + + + 1,525.51 + + + 4,666.83 + + + 426,066.45 + + + 6,192.34 + + + + 6,192.34 + + + + + + 162 + + + 05/08/2024 + + + 6,192.34 + + + 1,508.99 + + + 4,683.35 + + + 421,383.09 + + + 6,192.34 + + + + 6,192.34 + + + + + + 163 + + + 06/08/2024 + + + 6,192.34 + + + 1,492.40 + + + 4,699.94 + + + 416,683.15 + + + 6,192.34 + + + + 6,192.34 + + + + + + 164 + + + 07/08/2024 + + + 6,192.34 + + + 1,475.75 + + + 4,716.59 + + + 411,966.56 + + + 6,192.34 + + + + 6,192.34 + + + + + + 165 + + + 08/08/2024 + + + 6,192.34 + + + 1,459.05 + + + 4,733.29 + + + 407,233.27 + + + 6,192.34 + + + + 6,192.34 + + + + + + 166 + + + 09/08/2024 + + + 6,192.34 + + + 1,442.28 + + + 4,750.06 + + + 402,483.22 + + + 6,192.34 + + + + 6,192.34 + + + + + + 167 + + + 10/08/2024 + + + 6,192.34 + + + 1,425.46 + + + 4,766.88 + + + 397,716.34 + + + 6,192.34 + + + + 6,192.34 + + + + + + 168 + + + 11/08/2024 + + + 6,192.34 + + + 1,408.58 + + + 4,783.76 + + + 392,932.58 + + + 6,192.34 + + + + 6,192.34 + + + + + + 169 + + + 12/08/2024 + + + 6,192.34 + + + 1,391.64 + + + 4,800.70 + + + 388,131.87 + + + 6,192.34 + + + + 6,192.34 + + + + + + 170 + + + 01/08/2025 + + + 6,192.34 + + + 1,374.63 + + + 4,817.71 + + + 383,314.17 + + + 6,192.34 + + + + 6,192.34 + + + + + + 171 + + + 02/08/2025 + + + 6,192.34 + + + 1,357.57 + + + 4,834.77 + + + 378,479.40 + + + 6,192.34 + + + + 6,192.34 + + + + + + 172 + + + 03/08/2025 + + + 6,192.34 + + + 1,340.45 + + + 4,851.89 + + + 373,627.50 + + + 6,192.34 + + + + 6,192.34 + + + + + + 173 + + + 04/08/2025 + + + 6,192.34 + + + 1,323.26 + + + 4,869.08 + + + 368,758.43 + + + 6,192.34 + + + + 6,192.34 + + + + + + 174 + + + 05/08/2025 + + + 6,192.34 + + + 1,306.02 + + + 4,886.32 + + + 363,872.11 + + + 6,192.34 + + + + 6,192.34 + + + + + + 175 + + + 06/08/2025 + + + 6,192.34 + + + 1,288.71 + + + 4,903.63 + + + 358,968.48 + + + 6,192.34 + + + + 6,192.34 + + + + + + 176 + + + 07/08/2025 + + + 6,192.34 + + + 1,271.35 + + + 4,920.99 + + + 354,047.49 + + + 6,192.34 + + + + 6,192.34 + + + + + + 177 + + + 08/08/2025 + + + 6,192.34 + + + 1,253.92 + + + 4,938.42 + + + 349,109.07 + + + 6,192.34 + + + + 6,192.34 + + + + + + 178 + + + 09/08/2025 + + + 6,192.34 + + + 1,236.43 + + + 4,955.91 + + + 344,153.15 + + + 6,192.34 + + + + 6,192.34 + + + + + + 179 + + + 10/08/2025 + + + 6,192.34 + + + 1,218.88 + + + 4,973.46 + + + 339,179.69 + + + 6,192.34 + + + + 6,192.34 + + + + + + 180 + + + 11/08/2025 + + + 6,192.34 + + + 1,201.26 + + + 4,991.08 + + + 334,188.61 + + + 6,192.34 + + + + 6,192.34 + + + + + + 181 + + + 12/08/2025 + + + 6,192.34 + + + 1,183.58 + + + 5,008.76 + + + 329,179.86 + + + 6,192.34 + + + + 6,192.34 + + + + + + 182 + + + 01/08/2026 + + + 6,192.34 + + + 1,165.85 + + + 5,026.49 + + + 324,153.36 + + + 6,192.34 + + + + 6,192.34 + + + + + + 183 + + + 02/08/2026 + + + 6,192.34 + + + 1,148.04 + + + 5,044.30 + + + 319,109.06 + + + 6,192.34 + + + + 6,192.34 + + + + + + 184 + + + 03/08/2026 + + + 6,192.34 + + + 1,130.18 + + + 5,062.16 + + + 314,046.90 + + + 6,192.34 + + + + 6,192.34 + + + + + + 185 + + + 04/08/2026 + + + 6,192.34 + + + 1,112.25 + + + 5,080.09 + + + 308,966.81 + + + 6,192.34 + + + + 6,192.34 + + + + + + 186 + + + 05/08/2026 + + + 6,192.34 + + + 1,094.26 + + + 5,098.08 + + + 303,868.73 + + + 6,192.34 + + + + 6,192.34 + + + + + + 187 + + + 06/08/2026 + + + 6,192.34 + + + 1,076.20 + + + 5,116.14 + + + 298,752.59 + + + 6,192.34 + + + + 6,192.34 + + + + + + 188 + + + 07/08/2026 + + + 6,192.34 + + + 1,058.08 + + + 5,134.26 + + + 293,618.33 + + + 6,192.34 + + + + 6,192.34 + + + + + + 189 + + + 08/08/2026 + + + 6,192.34 + + + 1,039.90 + + + 5,152.44 + + + 288,465.89 + + + 6,192.34 + + + + 6,192.34 + + + + + + 190 + + + 09/08/2026 + + + 6,192.34 + + + 1,021.65 + + + 5,170.69 + + + 283,295.20 + + + 6,192.34 + + + + 6,192.34 + + + + + + 191 + + + 10/08/2026 + + + 6,192.34 + + + 1,003.34 + + + 5,189.00 + + + 278,106.20 + + + 6,192.34 + + + + 6,192.34 + + + + + + 192 + + + 11/08/2026 + + + 6,192.34 + + + 984.96 + + + 5,207.38 + + + 272,898.82 + + + 6,192.34 + + + + 6,192.34 + + + + + + 193 + + + 12/08/2026 + + + 6,192.34 + + + 966.52 + + + 5,225.82 + + + 267,672.99 + + + 6,192.34 + + + + 6,192.34 + + + + + + 194 + + + 01/08/2027 + + + 6,192.34 + + + 948.01 + + + 5,244.33 + + + 262,428.66 + + + 6,192.34 + + + + 6,192.34 + + + + + + 195 + + + 02/08/2027 + + + 6,192.34 + + + 929.43 + + + 5,262.91 + + + 257,165.76 + + + 6,192.34 + + + + 6,192.34 + + + + + + 196 + + + 03/08/2027 + + + 6,192.34 + + + 910.80 + + + 5,281.54 + + + 251,884.21 + + + 6,192.34 + + + + 6,192.34 + + + + + + 197 + + + 04/08/2027 + + + 6,192.34 + + + 892.09 + + + 5,300.25 + + + 246,583.96 + + + 6,192.34 + + + + 6,192.34 + + + + + + 198 + + + 05/08/2027 + + + 6,192.34 + + + 873.32 + + + 5,319.02 + + + 241,264.94 + + + 6,192.34 + + + + 6,192.34 + + + + + + 199 + + + 06/08/2027 + + + 6,192.34 + + + 854.48 + + + 5,337.86 + + + 235,927.08 + + + 6,192.34 + + + + 6,192.34 + + + + + + 200 + + + 07/08/2027 + + + 6,192.34 + + + 835.58 + + + 5,356.76 + + + 230,570.32 + + + 6,192.34 + + + + 6,192.34 + + + + + + 201 + + + 08/08/2027 + + + 6,192.34 + + + 816.60 + + + 5,375.74 + + + 225,194.58 + + + 6,192.34 + + + + 6,192.34 + + + + + + 202 + + + 09/08/2027 + + + 6,192.34 + + + 797.56 + + + 5,394.78 + + + 219,799.80 + + + 6,192.34 + + + + 6,192.34 + + + + + + 203 + + + 10/08/2027 + + + 6,192.34 + + + 778.46 + + + 5,413.88 + + + 214,385.92 + + + 6,192.34 + + + + 6,192.34 + + + + + + 204 + + + 11/08/2027 + + + 6,192.34 + + + 759.28 + + + 5,433.06 + + + 208,952.87 + + + 6,192.34 + + + + 6,192.34 + + + + + + 205 + + + 12/08/2027 + + + 6,192.34 + + + 740.04 + + + 5,452.30 + + + 203,500.57 + + + 6,192.34 + + + + 6,192.34 + + + + + + 206 + + + 01/08/2028 + + + 6,192.34 + + + 720.73 + + + 5,471.61 + + + 198,028.96 + + + 6,192.34 + + + + 6,192.34 + + + + + + 207 + + + 02/08/2028 + + + 6,192.34 + + + 701.35 + + + 5,490.99 + + + 192,537.97 + + + 6,192.34 + + + + 6,192.34 + + + + + + 208 + + + 03/08/2028 + + + 6,192.34 + + + 681.91 + + + 5,510.43 + + + 187,027.54 + + + 6,192.34 + + + + 6,192.34 + + + + + + 209 + + + 04/08/2028 + + + 6,192.34 + + + 662.39 + + + 5,529.95 + + + 181,497.59 + + + 6,192.34 + + + + 6,192.34 + + + + + + 210 + + + 05/08/2028 + + + 6,192.34 + + + 642.80 + + + 5,549.54 + + + 175,948.05 + + + 6,192.34 + + + + 6,192.34 + + + + + + 211 + + + 06/08/2028 + + + 6,192.34 + + + 623.15 + + + 5,569.19 + + + 170,378.86 + + + 6,192.34 + + + + 6,192.34 + + + + + + 212 + + + 07/08/2028 + + + 6,192.34 + + + 603.43 + + + 5,588.91 + + + 164,789.94 + + + 6,192.34 + + + + 6,192.34 + + + + + + 213 + + + 08/08/2028 + + + 6,192.34 + + + 583.63 + + + 5,608.71 + + + 159,181.23 + + + 6,192.34 + + + + 6,192.34 + + + + + + 214 + + + 09/08/2028 + + + 6,192.34 + + + 563.77 + + + 5,628.57 + + + 153,552.66 + + + 6,192.34 + + + + 6,192.34 + + + + + + 215 + + + 10/08/2028 + + + 6,192.34 + + + 543.83 + + + 5,648.51 + + + 147,904.15 + + + 6,192.34 + + + + 6,192.34 + + + + + + 216 + + + 11/08/2028 + + + 6,192.34 + + + 523.83 + + + 5,668.51 + + + 142,235.64 + + + 6,192.34 + + + + 6,192.34 + + + + + + 217 + + + 12/08/2028 + + + 6,192.34 + + + 503.75 + + + 5,688.59 + + + 136,547.05 + + + 6,192.34 + + + + 6,192.34 + + + + + + 218 + + + 01/08/2029 + + + 6,192.34 + + + 483.60 + + + 5,708.74 + + + 130,838.32 + + + 6,192.34 + + + + 6,192.34 + + + + + + 219 + + + 02/08/2029 + + + 6,192.34 + + + 463.39 + + + 5,728.95 + + + 125,109.36 + + + 6,192.34 + + + + 6,192.34 + + + + + + 220 + + + 03/08/2029 + + + 6,192.34 + + + 443.10 + + + 5,749.24 + + + 119,360.12 + + + 6,192.34 + + + + 6,192.34 + + + + + + 221 + + + 04/08/2029 + + + 6,192.34 + + + 422.73 + + + 5,769.61 + + + 113,590.51 + + + 6,192.34 + + + + 6,192.34 + + + + + + 222 + + + 05/08/2029 + + + 6,192.34 + + + 402.30 + + + 5,790.04 + + + 107,800.47 + + + 6,192.34 + + + + 6,192.34 + + + + + + 223 + + + 06/08/2029 + + + 6,192.34 + + + 381.79 + + + 5,810.55 + + + 101,989.92 + + + 6,192.34 + + + + 6,192.34 + + + + + + 224 + + + 07/08/2029 + + + 6,192.34 + + + 361.21 + + + 5,831.13 + + + 96,158.80 + + + 6,192.34 + + + + 6,192.34 + + + + + + 225 + + + 08/08/2029 + + + 6,192.34 + + + 340.56 + + + 5,851.78 + + + 90,307.02 + + + 6,192.34 + + + + 6,192.34 + + + + + + 226 + + + 09/08/2029 + + + 6,192.34 + + + 319.84 + + + 5,872.50 + + + 84,434.52 + + + 6,192.34 + + + + 6,192.34 + + + + + + 227 + + + 10/08/2029 + + + 6,192.34 + + + 299.04 + + + 5,893.30 + + + 78,541.22 + + + 6,192.34 + + + + 6,192.34 + + + + + + 228 + + + 11/08/2029 + + + 6,192.34 + + + 278.17 + + + 5,914.17 + + + 72,627.04 + + + 6,192.34 + + + + 6,192.34 + + + + + + 229 + + + 12/08/2029 + + + 6,192.34 + + + 257.22 + + + 5,935.12 + + + 66,691.93 + + + 6,192.34 + + + + 6,192.34 + + + + + + 230 + + + 01/08/2030 + + + 6,192.34 + + + 236.20 + + + 5,956.14 + + + 60,735.79 + + + 6,192.34 + + + + 6,192.34 + + + + + + 231 + + + 02/08/2030 + + + 6,192.34 + + + 215.11 + + + 5,977.23 + + + 54,758.55 + + + 6,192.34 + + + + 6,192.34 + + + + + + 232 + + + 03/08/2030 + + + 6,192.34 + + + 193.94 + + + 5,998.40 + + + 48,760.15 + + + 6,192.34 + + + + 6,192.34 + + + + + + 233 + + + 04/08/2030 + + + 6,192.34 + + + 172.69 + + + 6,019.65 + + + 42,740.50 + + + 6,192.34 + + + + 6,192.34 + + + + + + 234 + + + 05/08/2030 + + + 6,192.34 + + + 151.37 + + + 6,040.97 + + + 36,699.53 + + + 6,192.34 + + + + 6,192.34 + + + + + + 235 + + + 06/08/2030 + + + 6,192.34 + + + 129.98 + + + 6,062.36 + + + 30,637.17 + + + 6,192.34 + + + + 6,192.34 + + + + + + 236 + + + 07/08/2030 + + + 6,192.34 + + + 108.51 + + + 6,083.83 + + + 24,553.34 + + + 6,192.34 + + + + 6,192.34 + + + + + + 237 + + + 08/08/2030 + + + 6,192.34 + + + 86.96 + + + 6,105.38 + + + 18,447.96 + + + 6,192.34 + + + + 6,192.34 + + + + + + 238 + + + 09/08/2030 + + + 6,192.34 + + + 65.34 + + + 6,127.00 + + + 12,320.95 + + + 6,192.34 + + + + 6,192.34 + + + + + + 239 + + + 10/08/2030 + + + 6,192.34 + + + 43.64 + + + 6,148.70 + + + 6,172.25 + + + 6,192.34 + + + + 6,192.34 + + + + + + 240 + + + 11/08/2030 + + + 6,194.11 + + + 21.86 + + + 6,172.25 + + + 0.00 + + + 6,194.11 + + + + 6,194.11 + + + + + + + + + + + + + + + + + + + + C O S T E A M O R T I Z A D O + + + + + + + + + interés, se usa el TIR = + + + + 0.33127% + + + + + + + + Periodo + + + fecha + + + cuota + + + intereses + + + capital + + + pte amortiz + + + C/P + + + L/P + + + + + + 0 + + + 10/28/2010 + + + + 37,555.33 + + + 1,971.18 + + + 35,584.15 + + + + + + 1 + + + 11/28/2010 + + + 1,108.37 + + + 124.41 + + + 983.96 + + + 36,571.37 + + + + + + + + 2 + + + 12/28/2010 + + + 1,108.37 + + + 121.15 + + + 987.22 + + + 35,584.15 + + + 12,104.85 + + + 23,479.30 + + + + + + 3 + + + 01/28/2011 + + + 1,108.37 + + + 117.88 + + + 990.49 + + + 34,593.66 + + + + + + + + 4 + + + 02/28/2011 + + + 1,108.37 + + + 114.60 + + + 993.77 + + + 33,599.89 + + + + + + + + 5 + + + 03/28/2011 + + + 1,108.37 + + + 111.31 + + + 997.06 + + + 32,602.83 + + + + + + + + 6 + + + 04/28/2011 + + + 1,108.37 + + + 108.00 + + + 1,000.37 + + + 31,602.46 + + + + + + + + 7 + + + 05/28/2011 + + + 1,108.37 + + + 104.69 + + + 1,003.68 + + + 30,598.78 + + + + + + + + 8 + + + 06/28/2011 + + + 1,108.37 + + + 101.36 + + + 1,007.01 + + + 29,591.77 + + + + + + + + 9 + + + 07/28/2011 + + + 1,108.37 + + + 98.03 + + + 1,010.34 + + + 28,581.43 + + + + + + + + 10 + + + 08/28/2011 + + + 1,108.37 + + + 94.68 + + + 1,013.69 + + + 27,567.74 + + + + + + + + 11 + + + 09/28/2011 + + + 1,108.37 + + + 91.32 + + + 1,017.05 + + + 26,550.70 + + + + + + + + 12 + + + 10/28/2011 + + + 1,108.37 + + + 87.95 + + + 1,020.42 + + + 25,530.28 + + + + + + + + 13 + + + 11/28/2011 + + + 1,108.37 + + + 84.57 + + + 1,023.80 + + + 24,506.49 + + + + + + + + + + + + + + + + + 14 + + + 12/28/2011 + + + 1,108.37 + + + 81.18 + + + 1,027.19 + + + 23,479.30 + + + 12,594.91 + + + 10,884.44 + + + + + + 15 + + + 01/28/2012 + + + 1,108.37 + + + 77.78 + + + 1,030.59 + + + 22,448.71 + + + + + + + + 16 + + + 02/28/2012 + + + 1,108.37 + + + 74.37 + + + 1,034.00 + + + 21,414.70 + + + + + + + + 17 + + + 03/28/2012 + + + 1,108.37 + + + 70.94 + + + 1,037.43 + + + 20,377.27 + + + + + + + + 18 + + + 04/28/2012 + + + 1,108.37 + + + 67.50 + + + 1,040.87 + + + 19,336.41 + + + + + + + + 19 + + + 05/28/2012 + + + 1,108.37 + + + 64.06 + + + 1,044.31 + + + 18,292.09 + + + + + + + + 20 + + + 06/28/2012 + + + 1,108.37 + + + 60.60 + + + 1,047.77 + + + 17,244.32 + + + + + + + + 21 + + + 07/28/2010 + + + 1,108.37 + + + 57.13 + + + 1,051.24 + + + 16,193.07 + + + + + + + + 22 + + + 08/28/2012 + + + 1,108.37 + + + 53.64 + + + 1,054.73 + + + 15,138.35 + + + + + + + + 23 + + + 09/28/2012 + + + 1,108.37 + + + 50.15 + + + 1,058.22 + + + 14,080.13 + + + + + + + + 24 + + + 10/28/2012 + + + 1,108.37 + + + 46.64 + + + 1,061.73 + + + 13,018.40 + + + + + + + + 25 + + + 11/28/2012 + + + 1,108.37 + + + 43.13 + + + 1,065.24 + + + 11,953.16 + + + + + + + + 26 + + + 12/28/2012 + + + 1,108.37 + + + 39.60 + + + 1,068.77 + + + 10,884.38 + + + 10,884.38 + + + + + + + 27 + + + 01/28/2013 + + + 1,108.37 + + + 36.06 + + + 1,072.31 + + + 9,812.07 + + + + + + + + 28 + + + 02/28/2013 + + + 1,108.37 + + + 32.50 + + + 1,075.87 + + + 8,736.20 + + + + + + + + 29 + + + 03/28/2013 + + + 1,108.37 + + + 28.94 + + + 1,079.43 + + + 7,656.77 + + + + + + + + 30 + + + 04/28/2013 + + + 1,108.37 + + + 25.36 + + + 1,083.01 + + + 6,573.77 + + + + + + + + 31 + + + 05/28/2013 + + + 1,108.37 + + + 21.78 + + + 1,086.59 + + + 5,487.18 + + + + + + + + 32 + + + 06/28/2013 + + + 1,108.37 + + + 18.18 + + + 1,090.19 + + + 4,396.98 + + + + + + + + 33 + + + 07/28/2013 + + + 1,108.37 + + + 14.57 + + + 1,093.80 + + + 3,303.18 + + + + + + + + 34 + + + 08/28/2013 + + + 1,108.37 + + + 10.94 + + + 1,097.43 + + + 2,205.75 + + + + + + + + 35 + + + 09/28/2013 + + + 1,108.37 + + + 7.31 + + + 1,101.06 + + + 1,104.69 + + + + + + + + 36 + + + 10/28/2013 + + + 1,108.37 + + + 3.66 + + + 1,104.71 + + + -0.02 + + + + + + + + + + + + + + + + + + D I A R I O + + + + + + 1º concesión préstamo + + + + + 10/28/2010 + + + + + + + + 37,555.33 + + + (570) + + + a + + + (170) + + + 35,584.15 + + + + + + + + + + (520) + + + 1,971.18 + + + + + + 2º pgo. 1º vencimiento + + + + + + 11/28/2010 + + + + + + + + + 983.96 + + + (520) + + + a + + + + + + + + + 124.41 + + + (6623) + + + a + + + (570) + + + 1,108.37 + + + + + + + + + + + + + + + 3º pgo. 2º vencimiento + + + + + + 12/28/2010 + + + + + + + + + 987.22 + + + (520) + + + a + + + + + + + + + 121.15 + + + (6623) + + + a + + + (570) + + + 1,108.37 + + + + + + + + + + + + + + + Reclasificación l/p a c/p + + + + + + 12/31/2010 + + + + + + + + + 12,594.91 + + + (170) + + + a + + + (520) + + + 12,594.91 + + + + + + + + + etc... + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file diff --git a/sc/qa/unit/data/functions/financial/fods/ispmt.fods b/sc/qa/unit/data/functions/financial/fods/ispmt.fods new file mode 100644 index 000000000000..109dd6693016 --- /dev/null +++ b/sc/qa/unit/data/functions/financial/fods/ispmt.fods @@ -0,0 +1,1938 @@ + + + + 2016-06-28T13:01:57.597000000P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/92a1ad1f36b6d3cc13135a8c0805508933011577 + + + 0 + 0 + 41361 + 24290 + + + view1 + + + 2 + 11 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + 4 + 28 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 90 + 60 + true + false + + + Sheet2 + 1241 + 0 + 90 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + false + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + true + true + 3 + 1 + true + 1 + true + lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== + false + 0 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + ( + + ) + + + + + - + + + + + + + + + + + + £ + + + + - + £ + + + + + £ + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + £ + + + + + - + £ + + + + + + + + + ( + + ) + + + + + + + + ( + + ) + + + + £ + + + + + - + £ + + + + + + £ + + + + + - + £ + + + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + Kč + + + + - + + + Kč + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + € + + + + - + + + € + + + + + + + + - + + + € + + + + + + + / + + / + + + + + + + / + + / + + + + € + + + + + + - + € + + + + + + + Kč + + + - + + Kč + + + + + Kč + + + + - + + Kč + + + + + Kč + + + - + + Kč + + + + + Kč + + + + - + + Kč + + + + + + + - + + + + + + + + + - + + + + + + + + - + + + + + + + + + - + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + Kč + + + - + + + Kč + + + + + - Kč + + + + + + + + + + + + + + + + - + + + + + + + + - + + + + + + + + + + + + + + + Kč + + + - + + + Kč + + + + + - + + Kč + + + + + + + + + + + : + + + + + : + + : + + + + + : + + + + + + + Yes + + + Yes + + + No + + + + + True + + + True + + + False + + + + + On + + + On + + + Off + + + + + ¥€ + + + + + + + + + ( + € + + + + + ) + + + + + + € + + + + - + + + € + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + % + + + + / + + / + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + ??? + + + + Page 1 + + + + + + + ??? (???) + + + 00/00/0000, 00:00:00 + + + + + Page 1 / 99 + + + + + + + + + + + + + + + + + + + + + + + + + + + ISPMT Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple ISPMT formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + + Data + + + Description + + + + Data + + + Description + + + + + + + + + + -214.29 Kč + + + -214.285714285714 + + + TRUE + + + =ISPMT(0.05,5,7,15000) + + + + + 10.00% + + + + + 0.1 + + + Annual interest rate + + + + + + + + + + -20.83 Kč + + + -20.8333333333333 + + + TRUE + + + =ISPMT(0.075/12, 8, 2*12, 5000) + + + + + 1 + + + + 1 + + + Period + + + + + + + + + + Err:504 + + + error + + + TRUE + + + =ISPMT(0.06/52, 30, 4*52, 8000, 0 ,1) + + + + 3 + + + + + 3 + + + Number of years in the investment + + + + + + + + + + -204.75 Kč + + + -204.75 + + + TRUE + + + =ISPMT(0.0525/1, 4, 10*1, 6500) + + + + 8000 + + + + + 8000000 + + + Amount of loan + + + + + + + + + + -64.81 Kč + + + -64.8148148148148 + + + TRUE + + + =ISPMT(I2/12, I3, I4*12,I5) + + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =ISPMT(I2, 3,I4, I5) + + + + + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =ISPMT(0,5,7,15000) + + + + + + + + + + + + -750.00 Kč + + + -750 + + + TRUE + + + =ISPMT(0.05,0,7,15000) + + + + + + + + + #NUM! + + + error + + + TRUE + + + =ISPMT(0.05,5,0,15000) + + + + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =ISPMT(0.05,5,7,0) + + + + + + + + 0.00 Kč + + + 0 + + + TRUE + + + =ISPMT(0.05,5,7,) + + + + + + + + -20.8333333333333 + + + -20.8333333333333 + + + TRUE + + + =ISPMT(0.075/12, 8,2*12, 5000) + + + + + + + + + + + -7.89940828402367 + + + -7.89940828402367 + + + TRUE + + + =ISPMT(0.06/52,30, 4*52,8000) + + + + + + -7.89940828402367 + + + -7.89940828402367 + + + TRUE + + + =ISPMT(0.06/52, 30, 4*52, 8000) + + + + + + + + Err:511 + + + error + + + TRUE + + + =ISPMT(0.05,5,7) + + + + + + + + + + #NUM! + + + error + + + TRUE + + + =ISPMT(0.05,5,,15000) + + + + + + + + Err:504 + + + error + + + TRUE + + + =ISPMT(0.06/52, 30, 4*52, 8000, ,1) + + + + + + Err:504 + + + error + + + TRUE + + + =ISPMT(0.06/52, 30, 4*52, 8000, 0 ) + + + + + + Err:504 + + + error + + + TRUE + + + =ISPMT(0.06/52, 30, 4*52, 8000, 0 ,2) + + + + + + + Err:504 + + + error + + + TRUE + + + =ISPMT(0.06/52, 30, 4*52, 8000, 0 ,-2) + + + + + + -64814.8148148148 + + + -64814.8148148148 + + + TRUE + + + =ISPMT(L2/12,L3,L4*12,L5) + + + + + + + -533333.333333333 + + + -533333.333333333 + + + TRUE + + + =ISPMT(L2,1,L4,L5) + + + + + + + 0 + + + 0 + + + TRUE + + + =ISPMT(L2,1,L4,) + + + + + + + #NUM! + + + error + + + TRUE + + + =ISPMT(L2,1,,L5) + + + + + + -800000 + + + -800000 + + + TRUE + + + =ISPMT(L2,,L4,L5) + + + + + + -800000 + + + -800000 + + + TRUE + + + =ISPMT(L2,0,L4,L5) + + + + + + + + 0 + + + 0 + + + TRUE + + + =ISPMT(0,1,L4,L5) + + + + + + 0 + + + 0 + + + TRUE + + + =ISPMT(,1,L4,L5) + + + + + + + + + + + + ISPMTSummary: Compute the interest payment of an amortized loan for a given period.Syntax: ISPMT( Number Rate ; Number Period ; Number Nper ; Number Pv )Returns: CurrencyConstraints: None.Semantics: Computes the interest payment of an amortized loan for a given period. The parameters are:Rate: the interest rate per period.Period: the period for which the interest is computedNper: the total number of payment periods.Pv: the amount of the investment + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file -- cgit