anual

trimestral

mensual

anual

trimestral

mensual

T

Acumulado

Cuota+Int.

Periodicidad de la cuota

Cuota

Interés

Años

Interés anual :

Cant. de años:

Préstamo :

Estima la cuota:

C=\frac{a·\left(  1+\frac{r}{k} \right) ·\left [   \left(  1+\frac{r}{k} \right) ^{k·t} -1 \right ]}{\frac{r}{k}}

Cálculo de la cuota

Ver

Ocultar

K3 = 2500
K6 = 8
r: K6 / 100
A4 = 2
A3 = 1
A5: (2 * A4) - A3
A6: (2 * A5) - A4
A7: (2 * A6) - A5
A8: (2 * A7) - A6
A9: (2 * A8) - A7
A10: (2 * A9) - A8
A11: (2 * A10) - A9
A12: (2 * A11) - A10
A13: (2 * A12) - A11
A14: (2 * A13) - A12
A15: (2 * A14) - A13
A16: (2 * A15) - A14
A17: (2 * A16) - A15
A18: (2 * A17) - A16
A19: (2 * A18) - A17
A20: (2 * A19) - A18
A21: (2 * A20) - A19
A22: (2 * A21) - A20
A23: (2 * A22) - A21
A24: (2 * A23) - A22
A25: (2 * A24) - A23
A26: (2 * A25) - A24
A27: (2 * A26) - A25
A28: (2 * A27) - A26
A29: (2 * A28) - A27
A30: (2 * A29) - A28
A31: (2 * A30) - A29
A32: (2 * A31) - A30
A33: (2 * A32) - A31
A34: (2 * A33) - A32
A35: (2 * A34) - A33
A36: (2 * A35) - A34
A37: (2 * A36) - A35
A38: (2 * A37) - A36
A39: (2 * A38) - A37
A40: (2 * A39) - A38
A41: (2 * A40) - A39
A42: (2 * A41) - A40
A43: (2 * A42) - A41
A44: (2 * A43) - A42
A45: (2 * A44) - A43
A46: (2 * A45) - A44
A47: (2 * A46) - A45
A48: (2 * A47) - A46
A49: (2 * A48) - A47
A50: (2 * A49) - A48
A51: (2 * A50) - A49
A52: (2 * A51) - A50
A53: (2 * A52) - A51
A54: (2 * A53) - A52
A55: (2 * A54) - A53
A56: (2 * A55) - A54
A57: (2 * A56) - A55
A58: (2 * A57) - A56
A59: (2 * A58) - A57
A60: (2 * A59) - A58
A61: (2 * A60) - A59
A62: (2 * A61) - A60
A63: (2 * A62) - A61
A64: (2 * A63) - A62
A65: (2 * A64) - A63
A66: (2 * A65) - A64
A67: (2 * A66) - A65
A68: (2 * A67) - A66
A69: (2 * A68) - A67
A70: (2 * A69) - A68
A71: (2 * A70) - A69
A72: (2 * A71) - A70
A73: (2 * A72) - A71
A74: (2 * A73) - A72
A75: (2 * A74) - A73
A76: (2 * A75) - A74
A77: (2 * A76) - A75
A78: (2 * A77) - A76
A79: (2 * A78) - A77
A80: (2 * A79) - A78
A81: (2 * A80) - A79
A82: (2 * A81) - A80
A83: (2 * A82) - A81
A84: (2 * A83) - A82
A85: (2 * A84) - A83
A86: (2 * A85) - A84
A87: (2 * A86) - A85
A88: (2 * A87) - A86
A89: (2 * A88) - A87
A90: (2 * A89) - A88
A91: (2 * A90) - A89
A92: (2 * A91) - A90
A93: (2 * A92) - A91
A94: (2 * A93) - A92
A95: (2 * A94) - A93
A96: (2 * A95) - A94
A97: (2 * A96) - A95
A98: (2 * A97) - A96
A99: (2 * A98) - A97
A100: (2 * A99) - A98
A101: (2 * A100) - A99
A102: (2 * A101) - A100
A103: (2 * A102) - A101
A104: (2 * A103) - A102
A105: (2 * A104) - A103
A106: (2 * A105) - A104
A107: (2 * A106) - A105
A108: (2 * A107) - A106
A109: (2 * A108) - A107
A110: (2 * A109) - A108
A111: (2 * A110) - A109
A112: (2 * A111) - A110
A113: (2 * A112) - A111
A114: (2 * A113) - A112
A115: (2 * A114) - A113
A116: (2 * A115) - A114
A117: (2 * A116) - A115
A118: (2 * A117) - A116
A119: (2 * A118) - A117
A120: (2 * A119) - A118
A121: (2 * A120) - A119
A122: (2 * A121) - A120
A123: (2 * A122) - A121
A124: (2 * A123) - A122
A125: (2 * A124) - A123
A126: (2 * A125) - A124
A127: (2 * A126) - A125
A128: (2 * A127) - A126
A129: (2 * A128) - A127
A130: (2 * A129) - A128
A131: (2 * A130) - A129
A132: (2 * A131) - A130
A133: (2 * A132) - A131
A134: (2 * A133) - A132
A135: (2 * A134) - A133
A136: (2 * A135) - A134
A137: (2 * A136) - A135
A138: (2 * A137) - A136
A139: (2 * A138) - A137
A140: (2 * A139) - A138
A141: (2 * A140) - A139
A142: (2 * A141) - A140
A143: (2 * A142) - A141
A144: (2 * A143) - A142
A145: (2 * A144) - A143
A146: (2 * A145) - A144
A147: (2 * A146) - A145
A148: (2 * A147) - A146
A149: (2 * A148) - A147
A150: (2 * A149) - A148
A151: (2 * A150) - A149
A152: (2 * A151) - A150
A153: (2 * A152) - A151
A154: (2 * A153) - A152
A155: (2 * A154) - A153
A156: (2 * A155) - A154
A157: (2 * A156) - A155
A158: (2 * A157) - A156
A159: (2 * A158) - A157
A160: (2 * A159) - A158
A161: (2 * A160) - A159
A162: (2 * A161) - A160
q = 4 (slider from 1 to 12, step 1)
rq: r / q
K12 = 5
pp: (K12 * q)
H162: pp - A162
H161: pp - A161
H160: pp - A160
H159: pp - A159
H158: pp - A158
H157: pp - A157
H156: pp - A156
H155: pp - A155
H154: pp - A154
H153: pp - A153
H152: pp - A152
H151: pp - A151
H150: pp - A150
H149: pp - A149
H148: pp - A148
H147: pp - A147
H146: pp - A146
H145: pp - A145
H144: pp - A144
H143: pp - A143
H142: pp - A142
H141: pp - A141
H140: pp - A140
H139: pp - A139
H138: pp - A138
H137: pp - A137
H136: pp - A136
H135: pp - A135
H134: pp - A134
H133: pp - A133
H132: pp - A132
H131: pp - A131
H130: pp - A130
H129: pp - A129
H128: pp - A128
H127: pp - A127
H126: pp - A126
H125: pp - A125
H124: pp - A124
H123: pp - A123
H122: pp - A122
H121: pp - A121
H120: pp - A120
H119: pp - A119
H118: pp - A118
H117: pp - A117
H116: pp - A116
H115: pp - A115
H114: pp - A114
H113: pp - A113
H112: pp - A112
H111: pp - A111
H110: pp - A110
H109: pp - A109
H108: pp - A108
H107: pp - A107
H106: pp - A106
H105: pp - A105
H104: pp - A104
H103: pp - A103
H102: pp - A102
H101: pp - A101
H100: pp - A100
H99: pp - A99
H98: pp - A98
H97: pp - A97
H96: pp - A96
H95: pp - A95
H94: pp - A94
H93: pp - A93
H92: pp - A92
H91: pp - A91
H90: pp - A90
H89: pp - A89
H88: pp - A88
H87: pp - A87
H86: pp - A86
H85: pp - A85
H84: pp - A84
H83: pp - A83
H82: pp - A82
H81: pp - A81
H80: pp - A80
H79: pp - A79
H78: pp - A78
H77: pp - A77
H76: pp - A76
H75: pp - A75
H74: pp - A74
H73: pp - A73
H72: pp - A72
H71: pp - A71
H70: pp - A70
H69: pp - A69
H68: pp - A68
H67: pp - A67
H66: pp - A66
H65: pp - A65
H64: pp - A64
H63: pp - A63
H62: pp - A62
H61: pp - A61
H60: pp - A60
H59: pp - A59
H58: pp - A58
H57: pp - A57
H56: pp - A56
H55: pp - A55
H54: pp - A54
H53: pp - A53
H52: pp - A52
H51: pp - A51
H50: pp - A50
H49: pp - A49
H48: pp - A48
H47: pp - A47
H46: pp - A46
H45: pp - A45
H44: pp - A44
H43: pp - A43
H42: pp - A42
H41: pp - A41
H40: pp - A40
H39: pp - A39
H38: pp - A38
H37: pp - A37
H36: pp - A36
H35: pp - A35
H34: pp - A34
H33: pp - A33
H32: pp - A32
H31: pp - A31
H30: pp - A30
H29: pp - A29
H28: pp - A28
H27: pp - A27
H26: pp - A26
H25: pp - A25
H24: pp - A24
H23: pp - A23
H22: pp - A22
H21: pp - A21
H20: pp - A20
H19: pp - A19
H18: pp - A18
H17: pp - A17
H16: pp - A16
H15: pp - A15
H14: pp - A14
H13: pp - A13
H12: pp - A12
H11: pp - A11
H10: pp - A10
H9: pp - A9
H8: pp - A8
H7: pp - A7
H6: pp - A6
H5: pp - A5
H4: pp - A4
K9 = 60000
C2: (K9 * (1 + rq)^(pp))
H3: pp - A3
B3: (K$3 * (1 + rq)^(H3))
C3: C2 - B3
B4: (K$3 * (1 + rq)^(H4))
C4: C3 - B4
B5: (K$3 * (1 + rq)^(H5))
C5: C4 - B5
B6: (K$3 * (1 + rq)^(H6))
C6: C5 - B6
B7: (K$3 * (1 + rq)^(H7))
C7: C6 - B7
B8: (K$3 * (1 + rq)^(H8))
C8: C7 - B8
B9: (K$3 * (1 + rq)^(H9))
C9: C8 - B9
B10: (K$3 * (1 + rq)^(H10))
C10: C9 - B10
B11: (K$3 * (1 + rq)^(H11))
C11: C10 - B11
B12: (K$3 * (1 + rq)^(H12))
C12: C11 - B12
B13: (K$3 * (1 + rq)^(H13))
C13: C12 - B13
B14: (K$3 * (1 + rq)^(H14))
C14: C13 - B14
B15: (K$3 * (1 + rq)^(H15))
C15: C14 - B15
B16: (K$3 * (1 + rq)^(H16))
C16: C15 - B16
B17: (K$3 * (1 + rq)^(H17))
C17: C16 - B17
B18: (K$3 * (1 + rq)^(H18))
C18: C17 - B18
B19: (K$3 * (1 + rq)^(H19))
C19: C18 - B19
B20: (K$3 * (1 + rq)^(H20))
C20: C19 - B20
B21: (K$3 * (1 + rq)^(H21))
C21: C20 - B21
B22: (K$3 * (1 + rq)^(H22))
C22: C21 - B22
L3: (A3, C3)
L4: (A4, C4)
L5: (A5, C5)
L6: (A6, C6)
L7: (A7, C7)
L8: (A8, C8)
L9: (A9, C9)
L10: (A10, C10)
L11: (A11, C11)
L12: (A12, C12)
L13: (A13, C13)
L14: (A14, C14)
L15: (A15, C15)
L16: (A16, C16)
L17: (A17, C17)
L18: (A18, C18)
L19: (A19, C19)
L20: (A20, C20)
L21: (A21, C21)
L22: (A22, C22)
B23: (K$3 * (1 + rq)^(H23))
C23: C22 - B23
B24: (K$3 * (1 + rq)^(H24))
C24: C23 - B24
B25: (K$3 * (1 + rq)^(H25))
C25: C24 - B25
B26: (K$3 * (1 + rq)^(H26))
C26: C25 - B26
B27: (K$3 * (1 + rq)^(H27))
C27: C26 - B27
B28: (K$3 * (1 + rq)^(H28))
C28: C27 - B28
B29: (K$3 * (1 + rq)^(H29))
C29: C28 - B29
B30: (K$3 * (1 + rq)^(H30))
C30: C29 - B30
B31: (K$3 * (1 + rq)^(H31))
C31: C30 - B31
B32: (K$3 * (1 + rq)^(H32))
C32: C31 - B32
B33: (K$3 * (1 + rq)^(H33))
C33: C32 - B33
p = 2 (slider from 1 to 3, step 1)
B34: (K$3 * (1 + rq)^(H34))
C34: C33 - B34
B35: (K$3 * (1 + rq)^(H35))
C35: C34 - B35
B36: (K$3 * (1 + rq)^(H36))
C36: C35 - B36
B37: (K$3 * (1 + rq)^(H37))
C37: C36 - B37
B38: (K$3 * (1 + rq)^(H38))
C38: C37 - B38
B39: (K$3 * (1 + rq)^(H39))
C39: C38 - B39
B40: (K$3 * (1 + rq)^(H40))
C40: C39 - B40
B41: (K$3 * (1 + rq)^(H41))
C41: C40 - B41
B42: (K$3 * (1 + rq)^(H42))
C42: C41 - B42
B43: (K$3 * (1 + rq)^(H43))
C43: C42 - B43
B44: (K$3 * (1 + rq)^(H44))
C44: C43 - B44
B45: (K$3 * (1 + rq)^(H45))
C45: C44 - B45
B46: (K$3 * (1 + rq)^(H46))
C46: C45 - B46
B47: (K$3 * (1 + rq)^(H47))
C47: C46 - B47
B48: (K$3 * (1 + rq)^(H48))
C48: C47 - B48
B49: (K$3 * (1 + rq)^(H49))
C49: C48 - B49
B50: (K$3 * (1 + rq)^(H50))
C50: C49 - B50
B51: (K$3 * (1 + rq)^(H51))
C51: C50 - B51
B52: (K$3 * (1 + rq)^(H52))
C52: C51 - B52
B53: (K$3 * (1 + rq)^(H53))
C53: C52 - B53
B54: (K$3 * (1 + rq)^(H54))
C54: C53 - B54
B55: (K$3 * (1 + rq)^(H55))
C55: C54 - B55
B56: (K$3 * (1 + rq)^(H56))
C56: C55 - B56
B57: (K$3 * (1 + rq)^(H57))
C57: C56 - B57
B58: (K$3 * (1 + rq)^(H58))
C58: C57 - B58
B59: (K$3 * (1 + rq)^(H59))
C59: C58 - B59
B60: (K$3 * (1 + rq)^(H60))
C60: C59 - B60
B61: (K$3 * (1 + rq)^(H61))
C61: C60 - B61
G22 = If(A22 ≤ pp, 0, 1)
G3 = If(A3 ≤ pp, 0, 1)
G4 = If(A4 ≤ pp, 0, 1)
G5 = If(A5 ≤ pp, 0, 1)
G6 = If(A6 ≤ pp, 0, 1)
G7 = If(A7 ≤ pp, 0, 1)
G8 = If(A8 ≤ pp, 0, 1)
G9 = If(A9 ≤ pp, 0, 1)
G10 = If(A10 ≤ pp, 0, 1)
G11 = If(A11 ≤ pp, 0, 1)
G12 = If(A12 ≤ pp, 0, 1)
G13 = If(A13 ≤ pp, 0, 1)
G14 = If(A14 ≤ pp, 0, 1)
G15 = If(A15 ≤ pp, 0, 1)
G16 = If(A16 ≤ pp, 0, 1)
G17 = If(A17 ≤ pp, 0, 1)
G18 = If(A18 ≤ pp, 0, 1)
G19 = If(A19 ≤ pp, 0, 1)
G20 = If(A20 ≤ pp, 0, 1)
G21 = If(A21 ≤ pp, 0, 1)
G23 = If(A23 ≤ pp, 0, 1)
G24 = If(A24 ≤ pp, 0, 1)
G25 = If(A25 ≤ pp, 0, 1)
G26 = If(A26 ≤ pp, 0, 1)
G27 = If(A27 ≤ pp, 0, 1)
G28 = If(A28 ≤ pp, 0, 1)
G29 = If(A29 ≤ pp, 0, 1)
G30 = If(A30 ≤ pp, 0, 1)
G31 = If(A31 ≤ pp, 0, 1)
G32 = If(A32 ≤ pp, 0, 1)
G33 = If(A33 ≤ pp, 0, 1)
G34 = If(A34 ≤ pp, 0, 1)
G35 = If(A35 ≤ pp, 0, 1)
G36 = If(A36 ≤ pp, 0, 1)
G37 = If(A37 ≤ pp, 0, 1)
G38 = If(A38 ≤ pp, 0, 1)
G39 = If(A39 ≤ pp, 0, 1)
G40 = If(A40 ≤ pp, 0, 1)
G41 = If(A41 ≤ pp, 0, 1)
G42 = If(A42 ≤ pp, 0, 1)
G43 = If(A43 ≤ pp, 0, 1)
G44 = If(A44 ≤ pp, 0, 1)
G45 = If(A45 ≤ pp, 0, 1)
G46 = If(A46 ≤ pp, 0, 1)
G47 = If(A47 ≤ pp, 0, 1)
G48 = If(A48 ≤ pp, 0, 1)
G49 = If(A49 ≤ pp, 0, 1)
G50 = If(A50 ≤ pp, 0, 1)
G51 = If(A51 ≤ pp, 0, 1)
G52 = If(A52 ≤ pp, 0, 1)
G53 = If(A53 ≤ pp, 0, 1)
G54 = If(A54 ≤ pp, 0, 1)
G55 = If(A55 ≤ pp, 0, 1)
G56 = If(A56 ≤ pp, 0, 1)
G57 = If(A57 ≤ pp, 0, 1)
G58 = If(A58 ≤ pp, 0, 1)
G59 = If(A59 ≤ pp, 0, 1)
G60 = If(A60 ≤ pp, 0, 1)
G61 = If(A61 ≤ pp, 0, 1)
G62 = If(A62 ≤ pp, 0, 1)
B62: (K$3 * (1 + rq)^(H62))
C62: C61 - B62
G63 = If(A63 ≤ pp, 0, 1)
B63: (K$3 * (1 + rq)^(H63))
C63: C62 - B63
G64 = If(A64 ≤ pp, 0, 1)
B64: (K$3 * (1 + rq)^(H64))
C64: C63 - B64
G65 = If(A65 ≤ pp, 0, 1)
B65: (K$3 * (1 + rq)^(H65))
C65: C64 - B65
G66 = If(A66 ≤ pp, 0, 1)
B66: (K$3 * (1 + rq)^(H66))
C66: C65 - B66
G67 = If(A67 ≤ pp, 0, 1)
B67: (K$3 * (1 + rq)^(H67))
C67: C66 - B67
G68 = If(A68 ≤ pp, 0, 1)
B68: (K$3 * (1 + rq)^(H68))
C68: C67 - B68
G69 = If(A69 ≤ pp, 0, 1)
B69: (K$3 * (1 + rq)^(H69))
C69: C68 - B69
G70 = If(A70 ≤ pp, 0, 1)
B70: (K$3 * (1 + rq)^(H70))
C70: C69 - B70
G71 = If(A71 ≤ pp, 0, 1)
B71: (K$3 * (1 + rq)^(H71))
C71: C70 - B71
G72 = If(A72 ≤ pp, 0, 1)
B72: (K$3 * (1 + rq)^(H72))
C72: C71 - B72
G73 = If(A73 ≤ pp, 0, 1)
B73: (K$3 * (1 + rq)^(H73))
C73: C72 - B73
G74 = If(A74 ≤ pp, 0, 1)
B74: (K$3 * (1 + rq)^(H74))
C74: C73 - B74
G75 = If(A75 ≤ pp, 0, 1)
B75: (K$3 * (1 + rq)^(H75))
C75: C74 - B75
G76 = If(A76 ≤ pp, 0, 1)
B76: (K$3 * (1 + rq)^(H76))
C76: C75 - B76
G77 = If(A77 ≤ pp, 0, 1)
B77: (K$3 * (1 + rq)^(H77))
C77: C76 - B77
G78 = If(A78 ≤ pp, 0, 1)
B78: (K$3 * (1 + rq)^(H78))
C78: C77 - B78
G79 = If(A79 ≤ pp, 0, 1)
B79: (K$3 * (1 + rq)^(H79))
C79: C78 - B79
G80 = If(A80 ≤ pp, 0, 1)
B80: (K$3 * (1 + rq)^(H80))
C80: C79 - B80
G81 = If(A81 ≤ pp, 0, 1)
B81: (K$3 * (1 + rq)^(H81))
C81: C80 - B81
G82 = If(A82 ≤ pp, 0, 1)
B82: (K$3 * (1 + rq)^(H82))
C82: C81 - B82
G83 = If(A83 ≤ pp, 0, 1)
B83: (K$3 * (1 + rq)^(H83))
C83: C82 - B83
G84 = If(A84 ≤ pp, 0, 1)
B84: (K$3 * (1 + rq)^(H84))
C84: C83 - B84
G85 = If(A85 ≤ pp, 0, 1)
B85: (K$3 * (1 + rq)^(H85))
C85: C84 - B85
G86 = If(A86 ≤ pp, 0, 1)
B86: (K$3 * (1 + rq)^(H86))
C86: C85 - B86
G87 = If(A87 ≤ pp, 0, 1)
B87: (K$3 * (1 + rq)^(H87))
C87: C86 - B87
G88 = If(A88 ≤ pp, 0, 1)
B88: (K$3 * (1 + rq)^(H88))
C88: C87 - B88
G89 = If(A89 ≤ pp, 0, 1)
B89: (K$3 * (1 + rq)^(H89))
C89: C88 - B89
G90 = If(A90 ≤ pp, 0, 1)
B90: (K$3 * (1 + rq)^(H90))
C90: C89 - B90
G91 = If(A91 ≤ pp, 0, 1)
B91: (K$3 * (1 + rq)^(H91))
C91: C90 - B91
G92 = If(A92 ≤ pp, 0, 1)
B92: (K$3 * (1 + rq)^(H92))
C92: C91 - B92
G93 = If(A93 ≤ pp, 0, 1)
B93: (K$3 * (1 + rq)^(H93))
C93: C92 - B93
G94 = If(A94 ≤ pp, 0, 1)
B94: (K$3 * (1 + rq)^(H94))
C94: C93 - B94
G95 = If(A95 ≤ pp, 0, 1)
B95: (K$3 * (1 + rq)^(H95))
C95: C94 - B95
G96 = If(A96 ≤ pp, 0, 1)
B96: (K$3 * (1 + rq)^(H96))
C96: C95 - B96
G97 = If(A97 ≤ pp, 0, 1)
B97: (K$3 * (1 + rq)^(H97))
C97: C96 - B97
G98 = If(A98 ≤ pp, 0, 1)
B98: (K$3 * (1 + rq)^(H98))
C98: C97 - B98
G99 = If(A99 ≤ pp, 0, 1)
B99: (K$3 * (1 + rq)^(H99))
C99: C98 - B99
G100 = If(A100 ≤ pp, 0, 1)
B100: (K$3 * (1 + rq)^(H100))
C100: C99 - B100
G101 = If(A101 ≤ pp, 0, 1)
B101: (K$3 * (1 + rq)^(H101))
C101: C100 - B101
G102 = If(A102 ≤ pp, 0, 1)
B102: (K$3 * (1 + rq)^(H102))
C102: C101 - B102
G103 = If(A103 ≤ pp, 0, 1)
B103: (K$3 * (1 + rq)^(H103))
C103: C102 - B103
G104 = If(A104 ≤ pp, 0, 1)
B104: (K$3 * (1 + rq)^(H104))
C104: C103 - B104
G105 = If(A105 ≤ pp, 0, 1)
B105: (K$3 * (1 + rq)^(H105))
C105: C104 - B105
G106 = If(A106 ≤ pp, 0, 1)
B106: (K$3 * (1 + rq)^(H106))
C106: C105 - B106
G107 = If(A107 ≤ pp, 0, 1)
B107: (K$3 * (1 + rq)^(H107))
C107: C106 - B107
G108 = If(A108 ≤ pp, 0, 1)
B108: (K$3 * (1 + rq)^(H108))
C108: C107 - B108
G109 = If(A109 ≤ pp, 0, 1)
B109: (K$3 * (1 + rq)^(H109))
C109: C108 - B109
G110 = If(A110 ≤ pp, 0, 1)
B110: (K$3 * (1 + rq)^(H110))
C110: C109 - B110
G111 = If(A111 ≤ pp, 0, 1)
B111: (K$3 * (1 + rq)^(H111))
C111: C110 - B111
G112 = If(A112 ≤ pp, 0, 1)
B112: (K$3 * (1 + rq)^(H112))
C112: C111 - B112
G113 = If(A113 ≤ pp, 0, 1)
B113: (K$3 * (1 + rq)^(H113))
C113: C112 - B113
G114 = If(A114 ≤ pp, 0, 1)
B114: (K$3 * (1 + rq)^(H114))
C114: C113 - B114
G115 = If(A115 ≤ pp, 0, 1)
B115: (K$3 * (1 + rq)^(H115))
C115: C114 - B115
G116 = If(A116 ≤ pp, 0, 1)
B116: (K$3 * (1 + rq)^(H116))
C116: C115 - B116
G117 = If(A117 ≤ pp, 0, 1)
B117: (K$3 * (1 + rq)^(H117))
C117: C116 - B117
G118 = If(A118 ≤ pp, 0, 1)
B118: (K$3 * (1 + rq)^(H118))
C118: C117 - B118
G119 = If(A119 ≤ pp, 0, 1)
B119: (K$3 * (1 + rq)^(H119))
C119: C118 - B119
G120 = If(A120 ≤ pp, 0, 1)
B120: (K$3 * (1 + rq)^(H120))
C120: C119 - B120
G121 = If(A121 ≤ pp, 0, 1)
B121: (K$3 * (1 + rq)^(H121))
C121: C120 - B121
G122 = If(A122 ≤ pp, 0, 1)
B122: (K$3 * (1 + rq)^(H122))
C122: C121 - B122
L23: (A23, C23)
L24: (A24, C24)
L25: (A25, C25)
L26: (A26, C26)
L27: (A27, C27)
L28: (A28, C28)
L29: (A29, C29)
L30: (A30, C30)
L31: (A31, C31)
L32: (A32, C32)
L33: (A33, C33)
L34: (A34, C34)
L35: (A35, C35)
L36: (A36, C36)
L37: (A37, C37)
L38: (A38, C38)
L39: (A39, C39)
L40: (A40, C40)
L41: (A41, C41)
L42: (A42, C42)
L43: (A43, C43)
L44: (A44, C44)
L45: (A45, C45)
L46: (A46, C46)
L47: (A47, C47)
L48: (A48, C48)
L49: (A49, C49)
L50: (A50, C50)
L51: (A51, C51)
L52: (A52, C52)
L53: (A53, C53)
L54: (A54, C54)
L55: (A55, C55)
L56: (A56, C56)
L57: (A57, C57)
L58: (A58, C58)
L59: (A59, C59)
L60: (A60, C60)
L61: (A61, C61)
L62: (A62, C62)
L63: (A63, C63)
L64: (A64, C64)
L65: (A65, C65)
L66: (A66, C66)
L67: (A67, C67)
L68: (A68, C68)
L69: (A69, C69)
L70: (A70, C70)
L71: (A71, C71)
L72: (A72, C72)
L73: (A73, C73)
L74: (A74, C74)
L75: (A75, C75)
L76: (A76, C76)
L77: (A77, C77)
L78: (A78, C78)
L79: (A79, C79)
L80: (A80, C80)
L81: (A81, C81)
L82: (A82, C82)
L83: (A83, C83)
L84: (A84, C84)
L85: (A85, C85)
L86: (A86, C86)
L87: (A87, C87)
L88: (A88, C88)
L89: (A89, C89)
L90: (A90, C90)
L91: (A91, C91)
L92: (A92, C92)
L93: (A93, C93)
L94: (A94, C94)
L95: (A95, C95)
L96: (A96, C96)
L97: (A97, C97)
L98: (A98, C98)
L99: (A99, C99)
L100: (A100, C100)
L101: (A101, C101)
L102: (A102, C102)
L103: (A103, C103)
L104: (A104, C104)
L105: (A105, C105)
L106: (A106, C106)
L107: (A107, C107)
L108: (A108, C108)
L109: (A109, C109)
L110: (A110, C110)
L111: (A111, C111)
L112: (A112, C112)
L113: (A113, C113)
L114: (A114, C114)
L115: (A115, C115)
L116: (A116, C116)
L117: (A117, C117)
L118: (A118, C118)
L119: (A119, C119)
L120: (A120, C120)
L121: (A121, C121)
L122: (A122, C122)
c: x = pp
CasillaDeEntrada2 = Textfield(K6)
CasillaDeEntrada4 = Textfield(K12)
CasillaDeEntrada3 = Textfield(K9)
CasillaDeEntrada1 = Textfield(K3)
urq: 1 + rq
aa: (K9 * rq / ((urq * (urq^(pp) - 1))))
n = 1 (slider from 0 to 1, step 1)
M3: (A3, C3 - $K$9)
M4: (A4, C4 - $K$9)
M5: (A5, C5 - $K$9)
M6: (A6, C6 - $K$9)
M7: (A7, C7 - $K$9)
M8: (A8, C8 - $K$9)
M9: (A9, C9 - $K$9)
M10: (A10, C10 - $K$9)
M11: (A11, C11 - $K$9)
M12: (A12, C12 - $K$9)
M13: (A13, C13 - $K$9)
M14: (A14, C14 - $K$9)
M15: (A15, C15 - $K$9)
M16: (A16, C16 - $K$9)
M17: (A17, C17 - $K$9)
M18: (A18, C18 - $K$9)
M19: (A19, C19 - $K$9)
M20: (A20, C20 - $K$9)
M21: (A21, C21 - $K$9)
M22: (A22, C22 - $K$9)
M23: (A23, C23 - $K$9)
M24: (A24, C24 - $K$9)
M25: (A25, C25 - $K$9)
M26: (A26, C26 - $K$9)
M27: (A27, C27 - $K$9)
M28: (A28, C28 - $K$9)
M29: (A29, C29 - $K$9)
M30: (A30, C30 - $K$9)
M31: (A31, C31 - $K$9)
M32: (A32, C32 - $K$9)
M33: (A33, C33 - $K$9)
M34: (A34, C34 - $K$9)
M35: (A35, C35 - $K$9)
M36: (A36, C36 - $K$9)
M37: (A37, C37 - $K$9)
M38: (A38, C38 - $K$9)
M39: (A39, C39 - $K$9)
M40: (A40, C40 - $K$9)
M41: (A41, C41 - $K$9)
M42: (A42, C42 - $K$9)
M43: (A43, C43 - $K$9)
M44: (A44, C44 - $K$9)
M45: (A45, C45 - $K$9)
M46: (A46, C46 - $K$9)
M47: (A47, C47 - $K$9)
M48: (A48, C48 - $K$9)
M49: (A49, C49 - $K$9)
M50: (A50, C50 - $K$9)
M51: (A51, C51 - $K$9)
M52: (A52, C52 - $K$9)
M53: (A53, C53 - $K$9)
M54: (A54, C54 - $K$9)
M55: (A55, C55 - $K$9)
M56: (A56, C56 - $K$9)
M57: (A57, C57 - $K$9)
M58: (A58, C58 - $K$9)
M59: (A59, C59 - $K$9)
M60: (A60, C60 - $K$9)
M61: (A61, C61 - $K$9)
M62: (A62, C62 - $K$9)
M63: (A63, C63 - $K$9)
M64: (A64, C64 - $K$9)
M65: (A65, C65 - $K$9)
M66: (A66, C66 - $K$9)
M67: (A67, C67 - $K$9)
M68: (A68, C68 - $K$9)
M69: (A69, C69 - $K$9)
M70: (A70, C70 - $K$9)
M71: (A71, C71 - $K$9)
M72: (A72, C72 - $K$9)
M73: (A73, C73 - $K$9)
M74: (A74, C74 - $K$9)
M75: (A75, C75 - $K$9)
M76: (A76, C76 - $K$9)
M77: (A77, C77 - $K$9)
M78: (A78, C78 - $K$9)
M79: (A79, C79 - $K$9)
M80: (A80, C80 - $K$9)
M81: (A81, C81 - $K$9)
M82: (A82, C82 - $K$9)
M83: (A83, C83 - $K$9)
M84: (A84, C84 - $K$9)
M85: (A85, C85 - $K$9)
M86: (A86, C86 - $K$9)
M87: (A87, C87 - $K$9)
M88: (A88, C88 - $K$9)
M89: (A89, C89 - $K$9)
M90: (A90, C90 - $K$9)
M91: (A91, C91 - $K$9)
M92: (A92, C92 - $K$9)
M93: (A93, C93 - $K$9)
M94: (A94, C94 - $K$9)
M95: (A95, C95 - $K$9)
M96: (A96, C96 - $K$9)
M97: (A97, C97 - $K$9)
M98: (A98, C98 - $K$9)
M99: (A99, C99 - $K$9)
M100: (A100, C100 - $K$9)
M101: (A101, C101 - $K$9)
M102: (A102, C102 - $K$9)
M103: (A103, C103 - $K$9)
M104: (A104, C104 - $K$9)
M105: (A105, C105 - $K$9)
M106: (A106, C106 - $K$9)
M107: (A107, C107 - $K$9)
M108: (A108, C108 - $K$9)
M109: (A109, C109 - $K$9)
M110: (A110, C110 - $K$9)
M111: (A111, C111 - $K$9)
M112: (A112, C112 - $K$9)
M113: (A113, C113 - $K$9)
M114: (A114, C114 - $K$9)
M115: (A115, C115 - $K$9)
M116: (A116, C116 - $K$9)
M117: (A117, C117 - $K$9)
M118: (A118, C118 - $K$9)
M119: (A119, C119 - $K$9)
M120: (A120, C120 - $K$9)
M121: (A121, C121 - $K$9)
M122: (A122, C122 - $K$9)
a: y = K9
A2 = 0
L2: (A2, C2)
M2: (A2, C2 - $K$9)
G123 = If(A123 ≤ pp, 0, 1)
B123: (K$3 * (1 + rq)^(H123))
C123: C122 - B123
G124 = If(A124 ≤ pp, 0, 1)
B124: (K$3 * (1 + rq)^(H124))
C124: C123 - B124
G125 = If(A125 ≤ pp, 0, 1)
B125: (K$3 * (1 + rq)^(H125))
C125: C124 - B125
G126 = If(A126 ≤ pp, 0, 1)
B126: (K$3 * (1 + rq)^(H126))
C126: C125 - B126
G127 = If(A127 ≤ pp, 0, 1)
B127: (K$3 * (1 + rq)^(H127))
C127: C126 - B127
G128 = If(A128 ≤ pp, 0, 1)
B128: (K$3 * (1 + rq)^(H128))
C128: C127 - B128
G129 = If(A129 ≤ pp, 0, 1)
B129: (K$3 * (1 + rq)^(H129))
C129: C128 - B129
G130 = If(A130 ≤ pp, 0, 1)
B130: (K$3 * (1 + rq)^(H130))
C130: C129 - B130
G131 = If(A131 ≤ pp, 0, 1)
B131: (K$3 * (1 + rq)^(H131))
C131: C130 - B131
G132 = If(A132 ≤ pp, 0, 1)
B132: (K$3 * (1 + rq)^(H132))
C132: C131 - B132
G133 = If(A133 ≤ pp, 0, 1)
B133: (K$3 * (1 + rq)^(H133))
C133: C132 - B133
G134 = If(A134 ≤ pp, 0, 1)
B134: (K$3 * (1 + rq)^(H134))
C134: C133 - B134
G135 = If(A135 ≤ pp, 0, 1)
B135: (K$3 * (1 + rq)^(H135))
C135: C134 - B135
G136 = If(A136 ≤ pp, 0, 1)
B136: (K$3 * (1 + rq)^(H136))
C136: C135 - B136
G137 = If(A137 ≤ pp, 0, 1)
B137: (K$3 * (1 + rq)^(H137))
C137: C136 - B137
G138 = If(A138 ≤ pp, 0, 1)
B138: (K$3 * (1 + rq)^(H138))
C138: C137 - B138
G139 = If(A139 ≤ pp, 0, 1)
B139: (K$3 * (1 + rq)^(H139))
C139: C138 - B139
G140 = If(A140 ≤ pp, 0, 1)
B140: (K$3 * (1 + rq)^(H140))
C140: C139 - B140
G141 = If(A141 ≤ pp, 0, 1)
B141: (K$3 * (1 + rq)^(H141))
C141: C140 - B141
G142 = If(A142 ≤ pp, 0, 1)
B142: (K$3 * (1 + rq)^(H142))
C142: C141 - B142
G143 = If(A143 ≤ pp, 0, 1)
B143: (K$3 * (1 + rq)^(H143))
C143: C142 - B143
G144 = If(A144 ≤ pp, 0, 1)
B144: (K$3 * (1 + rq)^(H144))
C144: C143 - B144
G145 = If(A145 ≤ pp, 0, 1)
B145: (K$3 * (1 + rq)^(H145))
C145: C144 - B145
G146 = If(A146 ≤ pp, 0, 1)
B146: (K$3 * (1 + rq)^(H146))
C146: C145 - B146
G147 = If(A147 ≤ pp, 0, 1)
B147: (K$3 * (1 + rq)^(H147))
C147: C146 - B147
G148 = If(A148 ≤ pp, 0, 1)
B148: (K$3 * (1 + rq)^(H148))
C148: C147 - B148
G149 = If(A149 ≤ pp, 0, 1)
B149: (K$3 * (1 + rq)^(H149))
C149: C148 - B149
G150 = If(A150 ≤ pp, 0, 1)
B150: (K$3 * (1 + rq)^(H150))
C150: C149 - B150
G151 = If(A151 ≤ pp, 0, 1)
B151: (K$3 * (1 + rq)^(H151))
C151: C150 - B151
G152 = If(A152 ≤ pp, 0, 1)
B152: (K$3 * (1 + rq)^(H152))
C152: C151 - B152
G153 = If(A153 ≤ pp, 0, 1)
B153: (K$3 * (1 + rq)^(H153))
C153: C152 - B153
G154 = If(A154 ≤ pp, 0, 1)
B154: (K$3 * (1 + rq)^(H154))
C154: C153 - B154
G155 = If(A155 ≤ pp, 0, 1)
B155: (K$3 * (1 + rq)^(H155))
C155: C154 - B155
G156 = If(A156 ≤ pp, 0, 1)
B156: (K$3 * (1 + rq)^(H156))
C156: C155 - B156
G157 = If(A157 ≤ pp, 0, 1)
B157: (K$3 * (1 + rq)^(H157))
C157: C156 - B157
G158 = If(A158 ≤ pp, 0, 1)
B158: (K$3 * (1 + rq)^(H158))
C158: C157 - B158
G159 = If(A159 ≤ pp, 0, 1)
B159: (K$3 * (1 + rq)^(H159))
C159: C158 - B159
G160 = If(A160 ≤ pp, 0, 1)
B160: (K$3 * (1 + rq)^(H160))
C160: C159 - B160
G161 = If(A161 ≤ pp, 0, 1)
B161: (K$3 * (1 + rq)^(H161))
C161: C160 - B161
G162 = If(A162 ≤ pp, 0, 1)
B162: (K$3 * (1 + rq)^(H162))
C162: C161 - B162
L123: (A123, C123)
M123: (A123, C123 - $K$9)
L124: (A124, C124)
M124: (A124, C124 - $K$9)
L125: (A125, C125)
M125: (A125, C125 - $K$9)
L126: (A126, C126)
M126: (A126, C126 - $K$9)
L127: (A127, C127)
M127: (A127, C127 - $K$9)
L128: (A128, C128)
M128: (A128, C128 - $K$9)
L129: (A129, C129)
M129: (A129, C129 - $K$9)
L130: (A130, C130)
M130: (A130, C130 - $K$9)
L131: (A131, C131)
M131: (A131, C131 - $K$9)
L132: (A132, C132)
M132: (A132, C132 - $K$9)
L133: (A133, C133)
M133: (A133, C133 - $K$9)
L134: (A134, C134)
M134: (A134, C134 - $K$9)
L135: (A135, C135)
M135: (A135, C135 - $K$9)
L136: (A136, C136)
M136: (A136, C136 - $K$9)
L137: (A137, C137)
M137: (A137, C137 - $K$9)
L138: (A138, C138)
M138: (A138, C138 - $K$9)
L139: (A139, C139)
M139: (A139, C139 - $K$9)
L140: (A140, C140)
M140: (A140, C140 - $K$9)
L141: (A141, C141)
M141: (A141, C141 - $K$9)
L142: (A142, C142)
M142: (A142, C142 - $K$9)
L143: (A143, C143)
M143: (A143, C143 - $K$9)
L144: (A144, C144)
M144: (A144, C144 - $K$9)
L145: (A145, C145)
M145: (A145, C145 - $K$9)
L146: (A146, C146)
M146: (A146, C146 - $K$9)
L147: (A147, C147)
M147: (A147, C147 - $K$9)
L148: (A148, C148)
M148: (A148, C148 - $K$9)
L149: (A149, C149)
M149: (A149, C149 - $K$9)
L150: (A150, C150)
M150: (A150, C150 - $K$9)
L151: (A151, C151)
M151: (A151, C151 - $K$9)
L152: (A152, C152)
M152: (A152, C152 - $K$9)
L153: (A153, C153)
M153: (A153, C153 - $K$9)
L154: (A154, C154)
M154: (A154, C154 - $K$9)
L155: (A155, C155)
M155: (A155, C155 - $K$9)
L156: (A156, C156)
M156: (A156, C156 - $K$9)
L157: (A157, C157)
M157: (A157, C157 - $K$9)
L158: (A158, C158)
M158: (A158, C158 - $K$9)
L159: (A159, C159)
M159: (A159, C159 - $K$9)
L160: (A160, C160)
M160: (A160, C160 - $K$9)
L161: (A161, C161)
M161: (A161, C161 - $K$9)
L162: (A162, C162)
M162: (A162, C162 - $K$9)
b(x) = (K9 * (1 + rq)^(pp)) - (K3 * ((1 + rq)^(pp) - (1 + rq)^(pp - x)) / rq)
urqqt: urq^(pp)
am: ((K9 * rq) * urqqt / (urqqt - 1))
d: y = C2
G2 = NaN
texto7: "a=\frac{ " + (LaTeX[K9]) + "·" + (LaTeX[rq]) + "·" + (LaTeX[urqqt]) + "}{" + (LaTeX[urqqt]) + "-1 }"
texto3: "a= " + (LaTeX[am]) + ""