¿Enséñeme cómo calcular el interés del préstamo del fondo de previsión y cómo calcular el monto del pago mensual?
Utilice la función de Excel PMT (=PMT(4.9%/12,360,300000))=1592 el interés es (ipmt): el cálculo mensual es el siguiente, ***calculado
-￥ 273.184,86
-￥1.225,00
-￥1.223,50
-￥1.222,00
-￥1.220,48
-￥ 1.218,97
-￥1.217,44
-￥1.215,91
-￥1.214,38
-￥1.212,83
-￥ 1.211,28
-￥1.209,73
-￥1.208,17
-￥1.206,60
-￥1.205,02
-￥ 1.203,44
-￥1.201,86
-￥1.200,26
-￥1.198,66
-￥1.197,05
-￥ 1.195,44
-￥1.193,82
-￥1.192,19
-￥1.190,56
-￥1.188,92
-￥ 1.187,27
-￥1.185,62
-￥1.183,96
-￥1.182,29
-￥1.180,62
-￥ 1.178,94
-￥1.177,25
-￥1.175,56
-￥1.173,86
-￥1.172,15
-￥ 1.170,43
-￥1.168,71
-￥1.166,98
-￥1.165,25
-￥1.163,50
-￥ 1.161,75
-￥1.160,00
-￥1.158,23
-￥1.156,46
-￥1.154,68
-￥ 1.152,89
-￥1.151,10
-￥1.149,30
-￥1.147,49
-￥1.145,67
-￥ 1.143,85
-￥1.142,02
-￥1.140,18
-￥1.138,34
-￥1.136,48
-￥ 1.134,62
-￥1.132,75
-￥1.130,88
-￥1.128,99
-￥1.127,10
-¥ 1.125,20
-¥1.123,30
-¥1.121,38
-¥1.119,46
-¥1.117,53
-￥ 1.115,59
-￥1.113,65
-￥1.111,69
-￥1.109,73
-￥1.107,76
-¥ 1.105,78
-¥1.103,80
-¥1.101,80
-¥1.099,80
-¥1.097,79
-￥ 1.095,77
-￥1.093,74
-￥1.091,71<
/p>
-¥1.089,66
-¥1.087,61
-¥1.085,55
-¥1.083,48
-¥1.081,41
-¥1.079,32
-¥1.077,23
-¥1.075,12
-¥1.073,01
-¥1.070,89
-¥1.068,76
-¥1.066,63
-¥1.064,48
-¥1.062,32
-¥1.060,16
-¥1.057,99
-¥1.055,81
-¥1.053,62
-¥1.051,42
-¥1.049,21
-¥1.046,99
-¥1.044,77
-¥1.042,53
-¥1.040,29
-¥1.038,03
-¥1.035,77
-¥1.033,50
-¥1.031,22
-¥1.028,93
-¥1.026,63
-¥1.024,32
-¥1.022,00
-¥1.019,67
-¥1.017,33
-¥1.014,99
-¥1.012,63
-¥1.010,26
-¥1.007,89
-¥1.005,50
-¥1.003,10
-¥1.000,70
-¥998,28
-¥995,86
-¥993,42
-¥990,98
-¥988,52
-¥986,06
-¥983,58
-¥981,10
-¥978,60
-¥976.10
-¥973.58
-¥971.06
-¥968.52
-¥965.97
-¥963.42
-¥960.85
-¥958.27
-¥955.68
-¥953.08
-¥950.47
-¥947.85
-¥945.22
-¥942.58
-¥939.93
-¥937,27
-¥934,59
-¥931,91
-¥929,21
-¥926,50
-¥923.78
-¥921.06
-¥918.31
-¥915.56
-¥912.80
-¥910.03
-¥907.24
-¥904.44
-¥901.64
-¥898.82
-¥895.98
-¥893.14
-¥890.29
-¥887.42
-¥884.54
-¥881.65
-¥878.75
-¥875.84
-¥872.91
-¥869.98
-￥867.03
-￥864.07
-￥861.09
-￥858.11
-￥
855.11
-￥852.10
-￥849.08
-￥846.05
-￥843.00
-￥ 839,94
-￥836,87
-￥833,78
-￥830,69
-￥827,58
-￥ 824,46
-￥821,32
-￥818,17
-￥815,01
-￥811,84
-￥ 808.65
-￥805.45
-￥802.24
-￥799.02
-￥795.78
-￥ 792,52
-¥789,26
-¥785,98
-¥782,69
-¥779,38
-¿ 776.06
-￥772.73
-￥769.39
-￥766.03
-￥762.65
-￥ 759,27
-¥755,86
-¥752,45
-¥749,02
-¥745,58
-¿ 742,12
-¥738,65
-¥735,16
-¥731,66
-¥728,15
-￥ 724,62
-¥721,08
-¥717,52
-¥713,95
-¥710,37
-¿ 706,76
-¥703,15
-¥699,52
-¥695,87
-¥692,21
-¿ 688,54
-￥684,85
-￥681,14
-￥677,42
-￥673,69
-￥ 669,94
-￥666,17
-￥662,39
-￥658,60
-￥654,78
-￥ 650,96
-￥647,11
-￥643,25
-￥639,38
-￥635,49
-￥ 631,58
-￥627,66
-￥623,72
-￥619,77
-￥615,79
-￥ 611,81
-￥607,80
-￥603,79
-￥599,75
-￥595,70
-￥ 591,63
-￥587,54
-￥583,44
-￥579,32
-￥575,19
-￥ 571,03
-￥566,86
-￥562,68
-￥558,47
-￥554,25
-￥ 550.01
-￥545.76
-￥541.48
-￥537.19
-￥532.89
-￥ 528,56
-￥524,22
-￥519,86
-￥515,48
-￥511,08
-￥ 506,67
-￥502,23
-￥497,78
-￥493,32
-￥488,83
-￥
484,32
-￥479,80
-￥475,26
-￥470,70
-￥466,12
-￥ 461,52
-¥456,90
-¥452,27
-¥447,61
-¥442,94
-¿ 438,25
-¥433,53
-¥428,80
-¥424,05
-¥419,28
-¿ 414,49
-¥409,68
-¥404,86
-¥400,01
-¥395,14
-¿ 390,25
-¥385,34
-¥380,42
-¥375,47
-¥370,50
-¥ 365,51
-¥360,50
-¥355,47
-¥350,42
-¥345,35
-¥ 340,26
-¥335,15
-¥330,02
-¥324,86
-¥319,69
-¿ 314,49
-¥309,27
-¥304,04
-¥298,78
-¥293,49
-¿ 288,19
-¥282,87
-¥277,52
-¥272,15
-¥266,76
-¿ 261,35
-¥255,92
-¥250,46
-¥244,98
-¥239,48
-¿ 233,96
-¥228,41
-¥222,84
-¥217,25
-¥211,63
-¿ 206,00
-¥200,34
-¥194,65
-¥188,95
-¥183,22
-¥ 177,46
-¥171,69
-¥165,89
-¥160,06
-¥154,22
-¿ 148,34
-¥142,45
-¥136,53
-¥130,58
-¥124,62
-¿ 118,62
-¥112,61
-¥106,57
-¥100,50
-¥94,41
-¥ 88,29
-￥82,15
-￥75,98
-￥69,79
-￥63,58
-￥ 57,34
-￥51,07
-￥44,78
-￥38,46
-￥32,11
-￥ 25,74
-¥19,35
-¥12,92
-¥6,47