anual

trimestral

mensual

anual

trimestral

mensual

T

Acumulado

Cuota + Int

Periodicidad de la cuota

Cuota

Interés

Objetivo

Años

Interés anual

Cant. de años

Objetivo

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

K11 = 5
q = 4 (slider from 1 to 12, step 1)
K2: 900
A2 = 1
K5 = 15
r: K5 / 100
A3 = 2
A4: (2 * A3) - A2
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
B3: (K$2 * (1 + r / q)^(A3))
B4: (K$2 * (1 + r / q)^(A4))
B5: (K$2 * (1 + r / q)^(A5))
B6: (K$2 * (1 + r / q)^(A6))
B7: (K$2 * (1 + r / q)^(A7))
B8: (K$2 * (1 + r / q)^(A8))
B9: (K$2 * (1 + r / q)^(A9))
B10: (K$2 * (1 + r / q)^(A10))
B11: (K$2 * (1 + r / q)^(A11))
B12: (K$2 * (1 + r / q)^(A12))
B13: (K$2 * (1 + r / q)^(A13))
B14: (K$2 * (1 + r / q)^(A14))
B15: (K$2 * (1 + r / q)^(A15))
B16: (K$2 * (1 + r / q)^(A16))
B17: (K$2 * (1 + r / q)^(A17))
B18: (K$2 * (1 + r / q)^(A18))
B19: (K$2 * (1 + r / q)^(A19))
B20: (K$2 * (1 + r / q)^(A20))
B21: (K$2 * (1 + r / q)^(A21))
B2: (K$2 * (1 + r / q)^(A2))
C2: B2
C3: C2 + B3
C4: C3 + B4
C5: C4 + B5
C6: C5 + B6
C7: C6 + B7
C8: C7 + B8
C9: C8 + B9
C10: C9 + B10
C11: C10 + B11
C12: C11 + B12
C13: C12 + B13
C14: C13 + B14
C15: C14 + B15
C16: C15 + B16
C17: C16 + B17
C18: C17 + B18
C19: C18 + B19
C20: C19 + B20
C21: C20 + B21
L2: (A2, C2)
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)
A22: (2 * A21) - A20
B22: (K$2 * (1 + r / q)^(A22))
C22: C21 + B22
A23: (2 * A22) - A21
B23: (K$2 * (1 + r / q)^(A23))
C23: C22 + B23
A24: (2 * A23) - A22
B24: (K$2 * (1 + r / q)^(A24))
C24: C23 + B24
A25: (2 * A24) - A23
B25: (K$2 * (1 + r / q)^(A25))
C25: C24 + B25
A26: (2 * A25) - A24
B26: (K$2 * (1 + r / q)^(A26))
C26: C25 + B26
A27: (2 * A26) - A25
B27: (K$2 * (1 + r / q)^(A27))
C27: C26 + B27
A28: (2 * A27) - A26
B28: (K$2 * (1 + r / q)^(A28))
C28: C27 + B28
A29: (2 * A28) - A27
B29: (K$2 * (1 + r / q)^(A29))
C29: C28 + B29
A30: (2 * A29) - A28
B30: (K$2 * (1 + r / q)^(A30))
C30: C29 + B30
A31: (2 * A30) - A29
B31: (K$2 * (1 + r / q)^(A31))
C31: C30 + B31
A32: (2 * A31) - A30
B32: (K$2 * (1 + r / q)^(A32))
C32: C31 + B32
p = 2 (slider from 1 to 3, step 1)
pp: (K11 * q)
A33: (2 * A32) - A31
B33: (K$2 * (1 + r / q)^(A33))
C33: C32 + B33
A34: (2 * A33) - A32
B34: (K$2 * (1 + r / q)^(A34))
C34: C33 + B34
A35: (2 * A34) - A33
B35: (K$2 * (1 + r / q)^(A35))
C35: C34 + B35
A36: (2 * A35) - A34
B36: (K$2 * (1 + r / q)^(A36))
C36: C35 + B36
A37: (2 * A36) - A35
B37: (K$2 * (1 + r / q)^(A37))
C37: C36 + B37
A38: (2 * A37) - A36
B38: (K$2 * (1 + r / q)^(A38))
C38: C37 + B38
A39: (2 * A38) - A37
B39: (K$2 * (1 + r / q)^(A39))
C39: C38 + B39
A40: (2 * A39) - A38
B40: (K$2 * (1 + r / q)^(A40))
C40: C39 + B40
A41: (2 * A40) - A39
B41: (K$2 * (1 + r / q)^(A41))
C41: C40 + B41
A42: (2 * A41) - A40
B42: (K$2 * (1 + r / q)^(A42))
C42: C41 + B42
A43: (2 * A42) - A41
B43: (K$2 * (1 + r / q)^(A43))
C43: C42 + B43
A44: (2 * A43) - A42
B44: (K$2 * (1 + r / q)^(A44))
C44: C43 + B44
A45: (2 * A44) - A43
B45: (K$2 * (1 + r / q)^(A45))
C45: C44 + B45
A46: (2 * A45) - A44
B46: (K$2 * (1 + r / q)^(A46))
C46: C45 + B46
A47: (2 * A46) - A45
B47: (K$2 * (1 + r / q)^(A47))
C47: C46 + B47
A48: (2 * A47) - A46
B48: (K$2 * (1 + r / q)^(A48))
C48: C47 + B48
A49: (2 * A48) - A47
B49: (K$2 * (1 + r / q)^(A49))
C49: C48 + B49
A50: (2 * A49) - A48
B50: (K$2 * (1 + r / q)^(A50))
C50: C49 + B50
A51: (2 * A50) - A49
B51: (K$2 * (1 + r / q)^(A51))
C51: C50 + B51
A52: (2 * A51) - A50
B52: (K$2 * (1 + r / q)^(A52))
C52: C51 + B52
A53: (2 * A52) - A51
B53: (K$2 * (1 + r / q)^(A53))
C53: C52 + B53
A54: (2 * A53) - A52
B54: (K$2 * (1 + r / q)^(A54))
C54: C53 + B54
A55: (2 * A54) - A53
B55: (K$2 * (1 + r / q)^(A55))
C55: C54 + B55
A56: (2 * A55) - A54
B56: (K$2 * (1 + r / q)^(A56))
C56: C55 + B56
A57: (2 * A56) - A55
B57: (K$2 * (1 + r / q)^(A57))
C57: C56 + B57
A58: (2 * A57) - A56
B58: (K$2 * (1 + r / q)^(A58))
C58: C57 + B58
A59: (2 * A58) - A57
B59: (K$2 * (1 + r / q)^(A59))
C59: C58 + B59
A60: (2 * A59) - A58
B60: (K$2 * (1 + r / q)^(A60))
C60: C59 + B60
G21 = If(A21 ≤ pp, 0, 1)
G2 = If(A2 ≤ 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)
G22 = If(A22 ≤ 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)
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
B61: (K$2 * (1 + r / q)^(A61))
G61 = If(A61 ≤ pp, 0, 1)
C61: C60 + B61
B62: (K$2 * (1 + r / q)^(A62))
G62 = If(A62 ≤ pp, 0, 1)
C62: C61 + B62
B63: (K$2 * (1 + r / q)^(A63))
G63 = If(A63 ≤ pp, 0, 1)
C63: C62 + B63
B64: (K$2 * (1 + r / q)^(A64))
G64 = If(A64 ≤ pp, 0, 1)
C64: C63 + B64
B65: (K$2 * (1 + r / q)^(A65))
G65 = If(A65 ≤ pp, 0, 1)
C65: C64 + B65
B66: (K$2 * (1 + r / q)^(A66))
G66 = If(A66 ≤ pp, 0, 1)
C66: C65 + B66
B67: (K$2 * (1 + r / q)^(A67))
G67 = If(A67 ≤ pp, 0, 1)
C67: C66 + B67
B68: (K$2 * (1 + r / q)^(A68))
G68 = If(A68 ≤ pp, 0, 1)
C68: C67 + B68
B69: (K$2 * (1 + r / q)^(A69))
G69 = If(A69 ≤ pp, 0, 1)
C69: C68 + B69
B70: (K$2 * (1 + r / q)^(A70))
G70 = If(A70 ≤ pp, 0, 1)
C70: C69 + B70
B71: (K$2 * (1 + r / q)^(A71))
G71 = If(A71 ≤ pp, 0, 1)
C71: C70 + B71
B72: (K$2 * (1 + r / q)^(A72))
G72 = If(A72 ≤ pp, 0, 1)
C72: C71 + B72
B73: (K$2 * (1 + r / q)^(A73))
G73 = If(A73 ≤ pp, 0, 1)
C73: C72 + B73
B74: (K$2 * (1 + r / q)^(A74))
G74 = If(A74 ≤ pp, 0, 1)
C74: C73 + B74
B75: (K$2 * (1 + r / q)^(A75))
G75 = If(A75 ≤ pp, 0, 1)
C75: C74 + B75
B76: (K$2 * (1 + r / q)^(A76))
G76 = If(A76 ≤ pp, 0, 1)
C76: C75 + B76
B77: (K$2 * (1 + r / q)^(A77))
G77 = If(A77 ≤ pp, 0, 1)
C77: C76 + B77
B78: (K$2 * (1 + r / q)^(A78))
G78 = If(A78 ≤ pp, 0, 1)
C78: C77 + B78
B79: (K$2 * (1 + r / q)^(A79))
G79 = If(A79 ≤ pp, 0, 1)
C79: C78 + B79
B80: (K$2 * (1 + r / q)^(A80))
G80 = If(A80 ≤ pp, 0, 1)
C80: C79 + B80
B81: (K$2 * (1 + r / q)^(A81))
G81 = If(A81 ≤ pp, 0, 1)
C81: C80 + B81
B82: (K$2 * (1 + r / q)^(A82))
G82 = If(A82 ≤ pp, 0, 1)
C82: C81 + B82
B83: (K$2 * (1 + r / q)^(A83))
G83 = If(A83 ≤ pp, 0, 1)
C83: C82 + B83
B84: (K$2 * (1 + r / q)^(A84))
G84 = If(A84 ≤ pp, 0, 1)
C84: C83 + B84
B85: (K$2 * (1 + r / q)^(A85))
G85 = If(A85 ≤ pp, 0, 1)
C85: C84 + B85
B86: (K$2 * (1 + r / q)^(A86))
G86 = If(A86 ≤ pp, 0, 1)
C86: C85 + B86
B87: (K$2 * (1 + r / q)^(A87))
G87 = If(A87 ≤ pp, 0, 1)
C87: C86 + B87
B88: (K$2 * (1 + r / q)^(A88))
G88 = If(A88 ≤ pp, 0, 1)
C88: C87 + B88
B89: (K$2 * (1 + r / q)^(A89))
G89 = If(A89 ≤ pp, 0, 1)
C89: C88 + B89
B90: (K$2 * (1 + r / q)^(A90))
G90 = If(A90 ≤ pp, 0, 1)
C90: C89 + B90
B91: (K$2 * (1 + r / q)^(A91))
G91 = If(A91 ≤ pp, 0, 1)
C91: C90 + B91
B92: (K$2 * (1 + r / q)^(A92))
G92 = If(A92 ≤ pp, 0, 1)
C92: C91 + B92
B93: (K$2 * (1 + r / q)^(A93))
G93 = If(A93 ≤ pp, 0, 1)
C93: C92 + B93
B94: (K$2 * (1 + r / q)^(A94))
G94 = If(A94 ≤ pp, 0, 1)
C94: C93 + B94
B95: (K$2 * (1 + r / q)^(A95))
G95 = If(A95 ≤ pp, 0, 1)
C95: C94 + B95
B96: (K$2 * (1 + r / q)^(A96))
G96 = If(A96 ≤ pp, 0, 1)
C96: C95 + B96
B97: (K$2 * (1 + r / q)^(A97))
G97 = If(A97 ≤ pp, 0, 1)
C97: C96 + B97
B98: (K$2 * (1 + r / q)^(A98))
G98 = If(A98 ≤ pp, 0, 1)
C98: C97 + B98
B99: (K$2 * (1 + r / q)^(A99))
G99 = If(A99 ≤ pp, 0, 1)
C99: C98 + B99
B100: (K$2 * (1 + r / q)^(A100))
G100 = If(A100 ≤ pp, 0, 1)
C100: C99 + B100
B101: (K$2 * (1 + r / q)^(A101))
G101 = If(A101 ≤ pp, 0, 1)
C101: C100 + B101
B102: (K$2 * (1 + r / q)^(A102))
G102 = If(A102 ≤ pp, 0, 1)
C102: C101 + B102
B103: (K$2 * (1 + r / q)^(A103))
G103 = If(A103 ≤ pp, 0, 1)
C103: C102 + B103
B104: (K$2 * (1 + r / q)^(A104))
G104 = If(A104 ≤ pp, 0, 1)
C104: C103 + B104
B105: (K$2 * (1 + r / q)^(A105))
G105 = If(A105 ≤ pp, 0, 1)
C105: C104 + B105
B106: (K$2 * (1 + r / q)^(A106))
G106 = If(A106 ≤ pp, 0, 1)
C106: C105 + B106
B107: (K$2 * (1 + r / q)^(A107))
G107 = If(A107 ≤ pp, 0, 1)
C107: C106 + B107
B108: (K$2 * (1 + r / q)^(A108))
G108 = If(A108 ≤ pp, 0, 1)
C108: C107 + B108
B109: (K$2 * (1 + r / q)^(A109))
G109 = If(A109 ≤ pp, 0, 1)
C109: C108 + B109
B110: (K$2 * (1 + r / q)^(A110))
G110 = If(A110 ≤ pp, 0, 1)
C110: C109 + B110
B111: (K$2 * (1 + r / q)^(A111))
G111 = If(A111 ≤ pp, 0, 1)
C111: C110 + B111
B112: (K$2 * (1 + r / q)^(A112))
G112 = If(A112 ≤ pp, 0, 1)
C112: C111 + B112
B113: (K$2 * (1 + r / q)^(A113))
G113 = If(A113 ≤ pp, 0, 1)
C113: C112 + B113
B114: (K$2 * (1 + r / q)^(A114))
G114 = If(A114 ≤ pp, 0, 1)
C114: C113 + B114
B115: (K$2 * (1 + r / q)^(A115))
G115 = If(A115 ≤ pp, 0, 1)
C115: C114 + B115
B116: (K$2 * (1 + r / q)^(A116))
G116 = If(A116 ≤ pp, 0, 1)
C116: C115 + B116
B117: (K$2 * (1 + r / q)^(A117))
G117 = If(A117 ≤ pp, 0, 1)
C117: C116 + B117
B118: (K$2 * (1 + r / q)^(A118))
G118 = If(A118 ≤ pp, 0, 1)
C118: C117 + B118
B119: (K$2 * (1 + r / q)^(A119))
G119 = If(A119 ≤ pp, 0, 1)
C119: C118 + B119
B120: (K$2 * (1 + r / q)^(A120))
G120 = If(A120 ≤ pp, 0, 1)
C120: C119 + B120
A121: (2 * A120) - A119
B121: (K$2 * (1 + r / q)^(A121))
G121 = If(A121 ≤ pp, 0, 1)
C121: C120 + B121
L22: (A22, C22)
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)
c: x = pp
K8: 30000
CasillaDeEntrada2 = Textfield(K5)
CasillaDeEntrada4 = Textfield(K11)
CasillaDeEntrada3 = Textfield(K8)
CasillaDeEntrada1 = Textfield(K2)
b(x) = ((K2 * (1 + r / q)) * ((1 + r / q)^(x) - 1) / (r / q))
rq: r / q
urq: 1 + rq
aa: (K8 * rq / ((urq * (urq^(pp) - 1))))
n = 0 (slider from 0 to 1, step 1)
M2: (A2, C2 - $K$8)
M3: (A3, C3 - $K$8)
M4: (A4, C4 - $K$8)
M5: (A5, C5 - $K$8)
M6: (A6, C6 - $K$8)
M7: (A7, C7 - $K$8)
M8: (A8, C8 - $K$8)
M9: (A9, C9 - $K$8)
M10: (A10, C10 - $K$8)
M11: (A11, C11 - $K$8)
M12: (A12, C12 - $K$8)
M13: (A13, C13 - $K$8)
M14: (A14, C14 - $K$8)
M15: (A15, C15 - $K$8)
M16: (A16, C16 - $K$8)
M17: (A17, C17 - $K$8)
M18: (A18, C18 - $K$8)
M19: (A19, C19 - $K$8)
M20: (A20, C20 - $K$8)
M21: (A21, C21 - $K$8)
M22: (A22, C22 - $K$8)
M23: (A23, C23 - $K$8)
M24: (A24, C24 - $K$8)
M25: (A25, C25 - $K$8)
M26: (A26, C26 - $K$8)
M27: (A27, C27 - $K$8)
M28: (A28, C28 - $K$8)
M29: (A29, C29 - $K$8)
M30: (A30, C30 - $K$8)
M31: (A31, C31 - $K$8)
M32: (A32, C32 - $K$8)
M33: (A33, C33 - $K$8)
M34: (A34, C34 - $K$8)
M35: (A35, C35 - $K$8)
M36: (A36, C36 - $K$8)
M37: (A37, C37 - $K$8)
M38: (A38, C38 - $K$8)
M39: (A39, C39 - $K$8)
M40: (A40, C40 - $K$8)
M41: (A41, C41 - $K$8)
M42: (A42, C42 - $K$8)
M43: (A43, C43 - $K$8)
M44: (A44, C44 - $K$8)
M45: (A45, C45 - $K$8)
M46: (A46, C46 - $K$8)
M47: (A47, C47 - $K$8)
M48: (A48, C48 - $K$8)
M49: (A49, C49 - $K$8)
M50: (A50, C50 - $K$8)
M51: (A51, C51 - $K$8)
M52: (A52, C52 - $K$8)
M53: (A53, C53 - $K$8)
M54: (A54, C54 - $K$8)
M55: (A55, C55 - $K$8)
M56: (A56, C56 - $K$8)
M57: (A57, C57 - $K$8)
M58: (A58, C58 - $K$8)
M59: (A59, C59 - $K$8)
M60: (A60, C60 - $K$8)
M61: (A61, C61 - $K$8)
M62: (A62, C62 - $K$8)
M63: (A63, C63 - $K$8)
M64: (A64, C64 - $K$8)
M65: (A65, C65 - $K$8)
M66: (A66, C66 - $K$8)
M67: (A67, C67 - $K$8)
M68: (A68, C68 - $K$8)
M69: (A69, C69 - $K$8)
M70: (A70, C70 - $K$8)
M71: (A71, C71 - $K$8)
M72: (A72, C72 - $K$8)
M73: (A73, C73 - $K$8)
M74: (A74, C74 - $K$8)
M75: (A75, C75 - $K$8)
M76: (A76, C76 - $K$8)
M77: (A77, C77 - $K$8)
M78: (A78, C78 - $K$8)
M79: (A79, C79 - $K$8)
M80: (A80, C80 - $K$8)
M81: (A81, C81 - $K$8)
M82: (A82, C82 - $K$8)
M83: (A83, C83 - $K$8)
M84: (A84, C84 - $K$8)
M85: (A85, C85 - $K$8)
M86: (A86, C86 - $K$8)
M87: (A87, C87 - $K$8)
M88: (A88, C88 - $K$8)
M89: (A89, C89 - $K$8)
M90: (A90, C90 - $K$8)
M91: (A91, C91 - $K$8)
M92: (A92, C92 - $K$8)
M93: (A93, C93 - $K$8)
M94: (A94, C94 - $K$8)
M95: (A95, C95 - $K$8)
M96: (A96, C96 - $K$8)
M97: (A97, C97 - $K$8)
M98: (A98, C98 - $K$8)
M99: (A99, C99 - $K$8)
M100: (A100, C100 - $K$8)
M101: (A101, C101 - $K$8)
M102: (A102, C102 - $K$8)
M103: (A103, C103 - $K$8)
M104: (A104, C104 - $K$8)
M105: (A105, C105 - $K$8)
M106: (A106, C106 - $K$8)
M107: (A107, C107 - $K$8)
M108: (A108, C108 - $K$8)
M109: (A109, C109 - $K$8)
M110: (A110, C110 - $K$8)
M111: (A111, C111 - $K$8)
M112: (A112, C112 - $K$8)
M113: (A113, C113 - $K$8)
M114: (A114, C114 - $K$8)
M115: (A115, C115 - $K$8)
M116: (A116, C116 - $K$8)
M117: (A117, C117 - $K$8)
M118: (A118, C118 - $K$8)
M119: (A119, C119 - $K$8)
M120: (A120, C120 - $K$8)
M121: (A121, C121 - $K$8)
a: y = K8
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
B122: (K$2 * (1 + r / q)^(A122))
G122 = If(A122 ≤ pp, 0, 1)
B123: (K$2 * (1 + r / q)^(A123))
G123 = If(A123 ≤ pp, 0, 1)
B124: (K$2 * (1 + r / q)^(A124))
G124 = If(A124 ≤ pp, 0, 1)
B125: (K$2 * (1 + r / q)^(A125))
G125 = If(A125 ≤ pp, 0, 1)
B126: (K$2 * (1 + r / q)^(A126))
G126 = If(A126 ≤ pp, 0, 1)
B127: (K$2 * (1 + r / q)^(A127))
G127 = If(A127 ≤ pp, 0, 1)
B128: (K$2 * (1 + r / q)^(A128))
G128 = If(A128 ≤ pp, 0, 1)
B129: (K$2 * (1 + r / q)^(A129))
G129 = If(A129 ≤ pp, 0, 1)
B130: (K$2 * (1 + r / q)^(A130))
G130 = If(A130 ≤ pp, 0, 1)
B131: (K$2 * (1 + r / q)^(A131))
G131 = If(A131 ≤ pp, 0, 1)
B132: (K$2 * (1 + r / q)^(A132))
G132 = If(A132 ≤ pp, 0, 1)
B133: (K$2 * (1 + r / q)^(A133))
G133 = If(A133 ≤ pp, 0, 1)
B134: (K$2 * (1 + r / q)^(A134))
G134 = If(A134 ≤ pp, 0, 1)
B135: (K$2 * (1 + r / q)^(A135))
G135 = If(A135 ≤ pp, 0, 1)
B136: (K$2 * (1 + r / q)^(A136))
G136 = If(A136 ≤ pp, 0, 1)
B137: (K$2 * (1 + r / q)^(A137))
G137 = If(A137 ≤ pp, 0, 1)
B138: (K$2 * (1 + r / q)^(A138))
G138 = If(A138 ≤ pp, 0, 1)
B139: (K$2 * (1 + r / q)^(A139))
G139 = If(A139 ≤ pp, 0, 1)
B140: (K$2 * (1 + r / q)^(A140))
G140 = If(A140 ≤ pp, 0, 1)
B141: (K$2 * (1 + r / q)^(A141))
G141 = If(A141 ≤ pp, 0, 1)
B142: (K$2 * (1 + r / q)^(A142))
G142 = If(A142 ≤ pp, 0, 1)
B143: (K$2 * (1 + r / q)^(A143))
G143 = If(A143 ≤ pp, 0, 1)
B144: (K$2 * (1 + r / q)^(A144))
G144 = If(A144 ≤ pp, 0, 1)
B145: (K$2 * (1 + r / q)^(A145))
G145 = If(A145 ≤ pp, 0, 1)
B146: (K$2 * (1 + r / q)^(A146))
G146 = If(A146 ≤ pp, 0, 1)
B147: (K$2 * (1 + r / q)^(A147))
G147 = If(A147 ≤ pp, 0, 1)
B148: (K$2 * (1 + r / q)^(A148))
G148 = If(A148 ≤ pp, 0, 1)
B149: (K$2 * (1 + r / q)^(A149))
G149 = If(A149 ≤ pp, 0, 1)
B150: (K$2 * (1 + r / q)^(A150))
G150 = If(A150 ≤ pp, 0, 1)
B151: (K$2 * (1 + r / q)^(A151))
G151 = If(A151 ≤ pp, 0, 1)
B152: (K$2 * (1 + r / q)^(A152))
G152 = If(A152 ≤ pp, 0, 1)
B153: (K$2 * (1 + r / q)^(A153))
G153 = If(A153 ≤ pp, 0, 1)
B154: (K$2 * (1 + r / q)^(A154))
G154 = If(A154 ≤ pp, 0, 1)
B155: (K$2 * (1 + r / q)^(A155))
G155 = If(A155 ≤ pp, 0, 1)
B156: (K$2 * (1 + r / q)^(A156))
G156 = If(A156 ≤ pp, 0, 1)
B157: (K$2 * (1 + r / q)^(A157))
G157 = If(A157 ≤ pp, 0, 1)
B158: (K$2 * (1 + r / q)^(A158))
G158 = If(A158 ≤ pp, 0, 1)
B159: (K$2 * (1 + r / q)^(A159))
G159 = If(A159 ≤ pp, 0, 1)
B160: (K$2 * (1 + r / q)^(A160))
G160 = If(A160 ≤ pp, 0, 1)
B161: (K$2 * (1 + r / q)^(A161))
G161 = If(A161 ≤ pp, 0, 1)
C122: C121 + B122
L122: (A122, C122)
M122: (A122, C122 - $K$8)
C123: C122 + B123
L123: (A123, C123)
M123: (A123, C123 - $K$8)
C124: C123 + B124
L124: (A124, C124)
M124: (A124, C124 - $K$8)
C125: C124 + B125
L125: (A125, C125)
M125: (A125, C125 - $K$8)
C126: C125 + B126
L126: (A126, C126)
M126: (A126, C126 - $K$8)
C127: C126 + B127
L127: (A127, C127)
M127: (A127, C127 - $K$8)
C128: C127 + B128
L128: (A128, C128)
M128: (A128, C128 - $K$8)
C129: C128 + B129
L129: (A129, C129)
M129: (A129, C129 - $K$8)
C130: C129 + B130
L130: (A130, C130)
M130: (A130, C130 - $K$8)
C131: C130 + B131
L131: (A131, C131)
M131: (A131, C131 - $K$8)
C132: C131 + B132
L132: (A132, C132)
M132: (A132, C132 - $K$8)
C133: C132 + B133
L133: (A133, C133)
M133: (A133, C133 - $K$8)
C134: C133 + B134
L134: (A134, C134)
M134: (A134, C134 - $K$8)
C135: C134 + B135
L135: (A135, C135)
M135: (A135, C135 - $K$8)
C136: C135 + B136
L136: (A136, C136)
M136: (A136, C136 - $K$8)
C137: C136 + B137
L137: (A137, C137)
M137: (A137, C137 - $K$8)
C138: C137 + B138
L138: (A138, C138)
M138: (A138, C138 - $K$8)
C139: C138 + B139
L139: (A139, C139)
M139: (A139, C139 - $K$8)
C140: C139 + B140
L140: (A140, C140)
M140: (A140, C140 - $K$8)
C141: C140 + B141
L141: (A141, C141)
M141: (A141, C141 - $K$8)
C142: C141 + B142
L142: (A142, C142)
M142: (A142, C142 - $K$8)
C143: C142 + B143
L143: (A143, C143)
M143: (A143, C143 - $K$8)
C144: C143 + B144
L144: (A144, C144)
M144: (A144, C144 - $K$8)
C145: C144 + B145
L145: (A145, C145)
M145: (A145, C145 - $K$8)
C146: C145 + B146
L146: (A146, C146)
M146: (A146, C146 - $K$8)
C147: C146 + B147
L147: (A147, C147)
M147: (A147, C147 - $K$8)
C148: C147 + B148
L148: (A148, C148)
M148: (A148, C148 - $K$8)
C149: C148 + B149
L149: (A149, C149)
M149: (A149, C149 - $K$8)
C150: C149 + B150
L150: (A150, C150)
M150: (A150, C150 - $K$8)
C151: C150 + B151
L151: (A151, C151)
M151: (A151, C151 - $K$8)
C152: C151 + B152
L152: (A152, C152)
M152: (A152, C152 - $K$8)
C153: C152 + B153
L153: (A153, C153)
M153: (A153, C153 - $K$8)
C154: C153 + B154
L154: (A154, C154)
M154: (A154, C154 - $K$8)
C155: C154 + B155
L155: (A155, C155)
M155: (A155, C155 - $K$8)
C156: C155 + B156
L156: (A156, C156)
M156: (A156, C156 - $K$8)
C157: C156 + B157
L157: (A157, C157)
M157: (A157, C157 - $K$8)
C158: C157 + B158
L158: (A158, C158)
M158: (A158, C158 - $K$8)
C159: C158 + B159
L159: (A159, C159)
M159: (A159, C159 - $K$8)
C160: C159 + B160
L160: (A160, C160)
M160: (A160, C160 - $K$8)
C161: C160 + B161
L161: (A161, C161)
M161: (A161, C161 - $K$8)
texto4: "" + botón3a + "" + botón3b + ""
texto33: "a=\frac{" + (LaTeX[K8]) + "·" + (LaTeX[rq]) + "}{" + (LaTeX[urq]) + "·\left( " + (LaTeX[urq]) + "^{" + (LaTeX[pp]) + "}-1 \right) }"
texto3: "a  \space = \space " + (LaTeX[aa]) + ""