0% found this document useful (0 votes)
29 views10 pages

Hi Pc3e

A person is taking out a loan of S/.250,000 to buy an apartment. The loan has an annual interest rate of 12% and will be paid back over 20 years (240 monthly payments). The document calculates the monthly payment amount as S/.2,646.56 and provides an amortization schedule showing the breakdown of each monthly payment between interest and principal over the full repayment period.

Uploaded by

Erick QH
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
29 views10 pages

Hi Pc3e

A person is taking out a loan of S/.250,000 to buy an apartment. The loan has an annual interest rate of 12% and will be paid back over 20 years (240 monthly payments). The document calculates the monthly payment amount as S/.2,646.56 and provides an amortization schedule showing the breakdown of each monthly payment between interest and principal over the full repayment period.

Uploaded by

Erick QH
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

FUNCIONES FINANCIERAS (6 pts)

Préstamo 250000 Tasa mensual 0.949%


Tasa anual 12% Plazo en meses 240
Plazo en años 20
Cuota S/.2,646.56

Una persona desea hacerse un préstamo para comprar un departamento


por S/.250000, la entidad financiera le ofrece una TEA de 12% por ser
cliente preferencial, y desea pagar en un plazo de 20 años. Calcular la
cuota mensual y el cuadro de amortización.

Periodo Cuota Interes Amortizacion Saldo


1 S/. 2,646.56 S/.2,372.20 S/.274.36 S/.23,589,659.10
2 S/. 2,646.56 S/.2,369.59 S/.276.96 S/.23,563,496.49
3 S/. 2,646.56 S/.2,366.97 S/.279.59 S/.23,537,085.63
4 S/. 2,646.56 S/.2,364.31 S/.282.24 S/.23,510,424.16
5 S/. 2,646.56 S/.2,361.64 S/.284.92 S/.23,483,509.71
6 S/. 2,646.56 S/.2,358.93 S/.287.63 S/.23,456,339.87
7 S/. 2,646.56 S/.2,356.20 S/.290.36 S/.23,428,912.22
8 S/. 2,646.56 S/.2,353.45 S/.293.11 S/.23,401,224.32
9 S/. 2,646.56 S/.2,350.67 S/.295.89 S/.23,373,273.69
10 S/. 2,646.56 S/.2,347.86 S/.298.70 S/.23,345,057.85
11 S/. 2,646.56 S/.2,345.02 S/.301.53 S/.23,316,574.27
12 S/. 2,646.56 S/.2,342.16 S/.304.40 S/.23,287,820.41
13 S/. 2,646.56 S/.2,339.28 S/.307.28 S/.23,258,793.72
14 S/. 2,646.56 S/.2,336.36 S/.310.20 S/.23,229,491.59
15 S/. 2,646.56 S/.2,333.42 S/.313.14 S/.23,199,911.43
16 S/. 2,646.56 S/.2,330.44 S/.316.11 S/.23,170,050.59
17 S/. 2,646.56 S/.2,327.44 S/.319.11 S/.23,139,906.40
18 S/. 2,646.56 S/.2,324.42 S/.322.14 S/.23,109,476.18
19 S/. 2,646.56 S/.2,321.36 S/.325.20 S/.23,078,757.21
20 S/. 2,646.56 S/.2,318.27 S/.328.28 S/.23,047,746.76
21 S/. 2,646.56 S/.2,315.16 S/.331.40 S/.23,016,442.06
22 S/. 2,646.56 S/.2,312.01 S/.334.54 S/.22,984,840.31
23 S/. 2,646.56 S/.2,308.84 S/.337.72 S/.22,952,938.70
24 S/. 2,646.56 S/.2,305.64 S/.340.92 S/.22,920,734.38
25 S/. 2,646.56 S/.2,302.40 S/.344.16 S/.22,888,224.49
26 S/. 2,646.56 S/.2,299.14 S/.347.42 S/.22,855,406.11
27 S/. 2,646.56 S/.2,295.84 S/.350.72 S/.22,822,276.32
28 S/. 2,646.56 S/.2,292.51 S/.354.05 S/.22,788,832.18
29 S/. 2,646.56 S/.2,289.15 S/.357.41 S/.22,755,070.69
30 S/. 2,646.56 S/.2,285.76 S/.360.80 S/.22,720,988.84
31 S/. 2,646.56 S/.2,282.34 S/.364.22 S/.22,686,583.60
32 S/. 2,646.56 S/.2,278.88 S/.367.68 S/.22,651,851.90
33 S/. 2,646.56 S/.2,275.39 S/.371.17 S/.22,616,790.63
34 S/. 2,646.56 S/.2,271.87 S/.374.69 S/.22,581,396.67
35 S/. 2,646.56 S/.2,268.31 S/.378.24 S/.22,545,666.87
36 S/. 2,646.56 S/.2,264.73 S/.381.83 S/.22,509,598.03
37 S/. 2,646.56 S/.2,261.10 S/.385.46 S/.22,473,186.95
38 S/. 2,646.56 S/.2,257.44 S/.389.11 S/.22,436,430.36
39 S/. 2,646.56 S/.2,253.75 S/.392.81 S/.22,399,325.01
40 S/. 2,646.56 S/.2,250.03 S/.396.53 S/.22,361,867.56
41 S/. 2,646.56 S/.2,246.26 S/.400.30 S/.22,324,054.69
42 S/. 2,646.56 S/.2,242.46 S/.404.09 S/.22,285,883.03
43 S/. 2,646.56 S/.2,238.63 S/.407.93 S/.22,247,349.16
44 S/. 2,646.56 S/.2,234.76 S/.411.80 S/.22,208,449.65
45 S/. 2,646.56 S/.2,230.85 S/.415.71 S/.22,169,181.03
46 S/. 2,646.56 S/.2,226.91 S/.419.65 S/.22,129,539.79
47 S/. 2,646.56 S/.2,222.93 S/.423.63 S/.22,089,522.41
48 S/. 2,646.56 S/.2,218.91 S/.427.65 S/.22,049,125.32
49 S/. 2,646.56 S/.2,214.85 S/.431.71 S/.22,008,344.90
50 S/. 2,646.56 S/.2,210.75 S/.435.81 S/.21,967,177.53
51 S/. 2,646.56 S/.2,206.62 S/.439.94 S/.21,925,619.53
52 S/. 2,646.56 S/.2,202.44 S/.444.12 S/.21,883,667.19
53 S/. 2,646.56 S/.2,198.23 S/.448.33 S/.21,841,316.78
54 S/. 2,646.56 S/.2,193.97 S/.452.59 S/.21,798,564.51
55 S/. 2,646.56 S/.2,189.68 S/.456.88 S/.21,755,406.58
56 S/. 2,646.56 S/.2,185.34 S/.461.22 S/.21,711,839.13
57 S/. 2,646.56 S/.2,180.97 S/.465.59 S/.21,667,858.27
58 S/. 2,646.56 S/.2,176.55 S/.470.01 S/.21,623,460.09
59 S/. 2,646.56 S/.2,172.09 S/.474.47 S/.21,578,640.63
60 S/. 2,646.56 S/.2,167.59 S/.478.97 S/.21,533,395.88
61 S/. 2,646.56 S/.2,163.04 S/.483.52 S/.21,487,721.81
62 S/. 2,646.56 S/.2,158.45 S/.488.10 S/.21,441,614.36
63 S/. 2,646.56 S/.2,153.82 S/.492.74 S/.21,395,069.40
64 S/. 2,646.56 S/.2,149.15 S/.497.41 S/.21,348,082.78
65 S/. 2,646.56 S/.2,144.43 S/.502.13 S/.21,300,650.32
66 S/. 2,646.56 S/.2,139.66 S/.506.90 S/.21,252,767.78
67 S/. 2,646.56 S/.2,134.85 S/.511.71 S/.21,204,430.89
68 S/. 2,646.56 S/.2,130.00 S/.516.56 S/.21,155,635.34
69 S/. 2,646.56 S/.2,125.10 S/.521.46 S/.21,106,376.79
70 S/. 2,646.56 S/.2,120.15 S/.526.41 S/.21,056,650.83
71 S/. 2,646.56 S/.2,115.15 S/.531.41 S/.21,006,453.03
72 S/. 2,646.56 S/.2,110.11 S/.536.45 S/.20,955,778.91
73 S/. 2,646.56 S/.2,105.02 S/.541.54 S/.20,904,623.96
74 S/. 2,646.56 S/.2,099.88 S/.546.68 S/.20,852,983.60
75 S/. 2,646.56 S/.2,094.69 S/.551.86 S/.20,800,853.25
76 S/. 2,646.56 S/.2,089.46 S/.557.10 S/.20,748,228.24
77 S/. 2,646.56 S/.2,084.17 S/.562.39 S/.20,695,103.88
78 S/. 2,646.56 S/.2,078.84 S/.567.72 S/.20,641,475.43
79 S/. 2,646.56 S/.2,073.45 S/.573.11 S/.20,587,338.12
80 S/. 2,646.56 S/.2,068.01 S/.578.55 S/.20,532,687.11
81 S/. 2,646.56 S/.2,062.52 S/.584.04 S/.20,477,517.52
82 S/. 2,646.56 S/.2,056.98 S/.589.58 S/.20,421,824.45
83 S/. 2,646.56 S/.2,051.38 S/.595.17 S/.20,365,602.91
84 S/. 2,646.56 S/.2,045.74 S/.600.82 S/.20,308,847.90
85 S/. 2,646.56 S/.2,040.04 S/.606.52 S/.20,251,554.35
86 S/. 2,646.56 S/.2,034.28 S/.612.28 S/.20,193,717.16
87 S/. 2,646.56 S/.2,028.47 S/.618.09 S/.20,135,331.16
88 S/. 2,646.56 S/.2,022.61 S/.623.95 S/.20,076,391.15
89 S/. 2,646.56 S/.2,016.69 S/.629.87 S/.20,016,891.87
90 S/. 2,646.56 S/.2,010.71 S/.635.85 S/.19,956,828.01
91 S/. 2,646.56 S/.2,004.67 S/.641.88 S/.19,896,194.22
92 S/. 2,646.56 S/.1,998.58 S/.647.97 S/.19,834,985.08
93 S/. 2,646.56 S/.1,992.44 S/.654.12 S/.19,773,195.15
94 S/. 2,646.56 S/.1,986.23 S/.660.33 S/.19,710,818.90
95 S/. 2,646.56 S/.1,979.96 S/.666.60 S/.19,647,850.78
96 S/. 2,646.56 S/.1,973.64 S/.672.92 S/.19,584,285.17
97 S/. 2,646.56 S/.1,967.25 S/.679.31 S/.19,520,116.40
98 S/. 2,646.56 S/.1,960.81 S/.685.75 S/.19,455,338.74
99 S/. 2,646.56 S/.1,954.30 S/.692.26 S/.19,389,946.42
100 S/. 2,646.56 S/.1,947.73 S/.698.83 S/.19,323,933.61
101 S/. 2,646.56 S/.1,941.10 S/.705.46 S/.19,257,294.41
102 S/. 2,646.56 S/.1,934.41 S/.712.15 S/.19,190,022.89
103 S/. 2,646.56 S/.1,927.65 S/.718.91 S/.19,122,113.05
104 S/. 2,646.56 S/.1,920.83 S/.725.73 S/.19,053,558.82
105 S/. 2,646.56 S/.1,913.94 S/.732.62 S/.18,984,354.09
106 S/. 2,646.56 S/.1,906.99 S/.739.57 S/.18,914,492.70
107 S/. 2,646.56 S/.1,899.97 S/.746.59 S/.18,843,968.40
108 S/. 2,646.56 S/.1,892.89 S/.753.67 S/.18,772,774.91
109 S/. 2,646.56 S/.1,885.74 S/.760.82 S/.18,700,905.89
110 S/. 2,646.56 S/.1,878.52 S/.768.04 S/.18,628,354.91
111 S/. 2,646.56 S/.1,871.23 S/.775.33 S/.18,555,115.52
112 S/. 2,646.56 S/.1,863.87 S/.782.69 S/.18,481,181.16
113 S/. 2,646.56 S/.1,856.45 S/.790.11 S/.18,406,545.27
114 S/. 2,646.56 S/.1,848.95 S/.797.61 S/.18,331,201.16
115 S/. 2,646.56 S/.1,841.38 S/.805.18 S/.18,255,142.13
116 S/. 2,646.56 S/.1,833.74 S/.812.82 S/.18,178,361.40
117 S/. 2,646.56 S/.1,826.03 S/.820.53 S/.18,100,852.10
118 S/. 2,646.56 S/.1,818.24 S/.828.32 S/.18,022,607.34
119 S/. 2,646.56 S/.1,810.38 S/.836.18 S/.17,943,620.13
120 S/. 2,646.56 S/.1,802.45 S/.844.11 S/.17,863,883.43
121 S/. 2,646.56 S/.1,794.44 S/.852.12 S/.17,783,390.12
122 S/. 2,646.56 S/.1,786.35 S/.860.21 S/.17,702,133.02
123 S/. 2,646.56 S/.1,778.19 S/.868.37 S/.17,620,104.90
124 S/. 2,646.56 S/.1,769.95 S/.876.61 S/.17,537,298.43
125 S/. 2,646.56 S/.1,761.63 S/.884.93 S/.17,453,706.22
126 S/. 2,646.56 S/.1,753.23 S/.893.32 S/.17,369,320.82
127 S/. 2,646.56 S/.1,744.76 S/.901.80 S/.17,284,134.71
128 S/. 2,646.56 S/.1,736.20 S/.910.36 S/.17,198,140.29
129 S/. 2,646.56 S/.1,727.56 S/.919.00 S/.17,111,329.88
130 S/. 2,646.56 S/.1,718.84 S/.927.72 S/.17,023,695.75
131 S/. 2,646.56 S/.1,710.04 S/.936.52 S/.16,935,230.07
132 S/. 2,646.56 S/.1,701.15 S/.945.40 S/.16,845,924.96
133 S/. 2,646.56 S/.1,692.18 S/.954.38 S/.16,755,772.46
134 S/. 2,646.56 S/.1,683.13 S/.963.43 S/.16,664,764.51
135 S/. 2,646.56 S/.1,673.99 S/.972.57 S/.16,572,893.01
136 S/. 2,646.56 S/.1,664.76 S/.981.80 S/.16,480,149.76
137 S/. 2,646.56 S/.1,655.44 S/.991.12 S/.16,386,526.49
138 S/. 2,646.56 S/.1,646.04 S/.1,000.52 S/.16,292,014.85
139 S/. 2,646.56 S/.1,636.54 S/.1,010.02 S/.16,196,606.40
140 S/. 2,646.56 S/.1,626.96 S/.1,019.60 S/.16,100,292.65
141 S/. 2,646.56 S/.1,617.28 S/.1,029.27 S/.16,003,064.99
142 S/. 2,646.56 S/.1,607.52 S/.1,039.04 S/.15,904,914.76
143 S/. 2,646.56 S/.1,597.66 S/.1,048.90 S/.15,805,833.20
144 S/. 2,646.56 S/.1,587.71 S/.1,058.85 S/.15,705,811.48
145 S/. 2,646.56 S/.1,577.66 S/.1,068.90 S/.15,604,840.67
146 S/. 2,646.56 S/.1,567.52 S/.1,079.04 S/.15,502,911.78
147 S/. 2,646.56 S/.1,557.28 S/.1,089.28 S/.15,400,015.69
148 S/. 2,646.56 S/.1,546.94 S/.1,099.62 S/.15,296,143.25
149 S/. 2,646.56 S/.1,536.51 S/.1,110.05 S/.15,191,285.19
150 S/. 2,646.56 S/.1,525.97 S/.1,120.59 S/.15,085,432.15
151 S/. 2,646.56 S/.1,515.34 S/.1,131.22 S/.14,978,574.69
152 S/. 2,646.56 S/.1,504.61 S/.1,141.95 S/.14,870,703.29
153 S/. 2,646.56 S/.1,493.77 S/.1,152.79 S/.14,761,808.31
154 S/. 2,646.56 S/.1,482.83 S/.1,163.73 S/.14,651,880.05
155 S/. 2,646.56 S/.1,471.79 S/.1,174.77 S/.14,540,908.71
156 S/. 2,646.56 S/.1,460.64 S/.1,185.92 S/.14,428,884.38
157 S/. 2,646.56 S/.1,449.39 S/.1,197.17 S/.14,315,797.08
158 S/. 2,646.56 S/.1,438.03 S/.1,208.53 S/.14,201,636.71
159 S/. 2,646.56 S/.1,426.56 S/.1,220.00 S/.14,086,393.10
160 S/. 2,646.56 S/.1,414.99 S/.1,231.57 S/.13,970,055.97
161 S/. 2,646.56 S/.1,403.30 S/.1,243.26 S/.13,852,614.94
162 S/. 2,646.56 S/.1,391.50 S/.1,255.06 S/.13,734,059.53
163 S/. 2,646.56 S/.1,379.59 S/.1,266.96 S/.13,614,379.18
164 S/. 2,646.56 S/.1,367.57 S/.1,278.99 S/.13,493,563.20
165 S/. 2,646.56 S/.1,355.44 S/.1,291.12 S/.13,371,600.83
166 S/. 2,646.56 S/.1,343.19 S/.1,303.37 S/.13,248,481.18
167 S/. 2,646.56 S/.1,330.82 S/.1,315.74 S/.13,124,193.28
168 S/. 2,646.56 S/.1,318.33 S/.1,328.23 S/.12,998,726.03
169 S/. 2,646.56 S/.1,305.73 S/.1,340.83 S/.12,872,068.25
170 S/. 2,646.56 S/.1,293.01 S/.1,353.55 S/.12,744,208.64
171 S/. 2,646.56 S/.1,280.16 S/.1,366.40 S/.12,615,135.80
172 S/. 2,646.56 S/.1,267.20 S/.1,379.36 S/.12,484,838.21
173 S/. 2,646.56 S/.1,254.11 S/.1,392.45 S/.12,353,304.25
174 S/. 2,646.56 S/.1,240.90 S/.1,405.66 S/.12,220,522.20
175 S/. 2,646.56 S/.1,227.56 S/.1,419.00 S/.12,086,480.20
176 S/. 2,646.56 S/.1,214.09 S/.1,432.46 S/.11,951,166.31
177 S/. 2,646.56 S/.1,200.50 S/.1,446.06 S/.11,814,568.45
178 S/. 2,646.56 S/.1,186.78 S/.1,459.78 S/.11,676,674.45
179 S/. 2,646.56 S/.1,172.93 S/.1,473.63 S/.11,537,471.99
180 S/. 2,646.56 S/.1,158.95 S/.1,487.61 S/.11,396,948.68
181 S/. 2,646.56 S/.1,144.83 S/.1,501.73 S/.11,255,091.96
182 S/. 2,646.56 S/.1,130.58 S/.1,515.98 S/.11,111,889.20
183 S/. 2,646.56 S/.1,116.20 S/.1,530.36 S/.10,967,327.61
184 S/. 2,646.56 S/.1,101.67 S/.1,544.88 S/.10,821,394.32
185 S/. 2,646.56 S/.1,087.02 S/.1,559.54 S/.10,674,076.29
186 S/. 2,646.56 S/.1,072.22 S/.1,574.34 S/.10,525,360.38
187 S/. 2,646.56 S/.1,057.28 S/.1,589.28 S/.10,375,233.35
188 S/. 2,646.56 S/.1,042.20 S/.1,604.36 S/.10,223,681.79
189 S/. 2,646.56 S/.1,026.97 S/.1,619.58 S/.10,070,692.19
190 S/. 2,646.56 S/.1,011.61 S/.1,634.95 S/.9,916,250.90
191 S/. 2,646.56 S/.996.09 S/.1,650.47 S/.9,760,344.16
192 S/. 2,646.56 S/.980.43 S/.1,666.13 S/.9,602,958.04
193 S/. 2,646.56 S/.964.62 S/.1,681.94 S/.9,444,078.52
194 S/. 2,646.56 S/.948.66 S/.1,697.90 S/.9,283,691.43
195 S/. 2,646.56 S/.932.55 S/.1,714.01 S/.9,121,782.45
196 S/. 2,646.56 S/.916.29 S/.1,730.27 S/.8,958,337.16
197 S/. 2,646.56 S/.899.87 S/.1,746.69 S/.8,793,340.96
198 S/. 2,646.56 S/.883.30 S/.1,763.26 S/.8,626,779.15
199 S/. 2,646.56 S/.866.56 S/.1,779.99 S/.8,458,636.88
200 S/. 2,646.56 S/.849.67 S/.1,796.88 S/.8,288,899.13
201 S/. 2,646.56 S/.832.62 S/.1,813.93 S/.8,117,550.78
202 S/. 2,646.56 S/.815.41 S/.1,831.15 S/.7,944,576.53
203 S/. 2,646.56 S/.798.04 S/.1,848.52 S/.7,769,960.98
204 S/. 2,646.56 S/.780.50 S/.1,866.06 S/.7,593,688.53
205 S/. 2,646.56 S/.762.79 S/.1,883.77 S/.7,415,743.47
206 S/. 2,646.56 S/.744.92 S/.1,901.64 S/.7,236,109.92
207 S/. 2,646.56 S/.726.87 S/.1,919.69 S/.7,054,771.87
208 S/. 2,646.56 S/.708.66 S/.1,937.90 S/.6,871,713.14
209 S/. 2,646.56 S/.690.27 S/.1,956.29 S/.6,686,917.40
210 S/. 2,646.56 S/.671.70 S/.1,974.85 S/.6,500,368.18
211 S/. 2,646.56 S/.652.97 S/.1,993.59 S/.6,312,048.82
212 S/. 2,646.56 S/.634.05 S/.2,012.51 S/.6,121,942.55
213 S/. 2,646.56 S/.614.95 S/.2,031.61 S/.5,930,032.39
214 S/. 2,646.56 S/.595.68 S/.2,050.88 S/.5,736,301.24
215 S/. 2,646.56 S/.576.21 S/.2,070.34 S/.5,540,731.82
216 S/. 2,646.56 S/.556.57 S/.2,089.99 S/.5,343,306.67
217 S/. 2,646.56 S/.536.74 S/.2,109.82 S/.5,144,008.20
218 S/. 2,646.56 S/.516.72 S/.2,129.84 S/.4,942,818.63
219 S/. 2,646.56 S/.496.51 S/.2,150.05 S/.4,739,720.02
220 S/. 2,646.56 S/.476.11 S/.2,170.45 S/.4,534,694.24
221 S/. 2,646.56 S/.455.51 S/.2,191.05 S/.4,327,723.01
222 S/. 2,646.56 S/.434.72 S/.2,211.84 S/.4,118,787.88
223 S/. 2,646.56 S/.413.73 S/.2,232.82 S/.3,907,870.20
224 S/. 2,646.56 S/.392.55 S/.2,254.01 S/.3,694,951.18
225 S/. 2,646.56 S/.371.16 S/.2,275.40 S/.3,480,011.80
226 S/. 2,646.56 S/.349.57 S/.2,296.99 S/.3,263,032.91
227 S/. 2,646.56 S/.327.77 S/.2,318.78 S/.3,043,995.16
228 S/. 2,646.56 S/.305.77 S/.2,340.79 S/.2,822,879.00
229 S/. 2,646.56 S/.283.56 S/.2,363.00 S/.2,599,664.71
230 S/. 2,646.56 S/.261.14 S/.2,385.42 S/.2,374,332.39
231 S/. 2,646.56 S/.238.50 S/.2,408.06 S/.2,146,861.94
232 S/. 2,646.56 S/.215.65 S/.2,430.90 S/.1,917,233.07
233 S/. 2,646.56 S/.192.59 S/.2,453.97 S/.1,685,425.30
234 S/. 2,646.56 S/.169.30 S/.2,477.26 S/.1,451,417.95
235 S/. 2,646.56 S/.145.80 S/.2,500.76 S/.1,215,190.15
236 S/. 2,646.56 S/.122.07 S/.2,524.49 S/.976,720.84
237 S/. 2,646.56 S/.98.11 S/.2,548.45 S/.735,988.74
238 S/. 2,646.56 S/.73.93 S/.2,572.63 S/.492,972.39
239 S/. 2,646.56 S/.49.52 S/.2,597.04 S/.247,650.10
240 S/. 2,646.56 S/.24.88 S/.2,621.68 S/.0.00
ANÁLISIS Y SI (7 pts)

Con los datos de la hoja Financieras hallar:

TABLA DE DATOS (3 pts) BUSCAR OBJETIVO


Crear una tabla de datos en los que se
varíe el interés del 10% hasta el 15% con
variación de 0.5% Se plantea que la persona solo puede
pagar una cuota de S/. 2500, se debe
resolver entonces qué valor de tasa
debe conseguir en la entidad financiera
para pagar dicho monto.
Y los plazos desde 15 a 30 años en
incrementos de 5 años.

S/. 2,646.56 15 20 25 30 cuota


10%
10.50%
11%
11.50%
12%
12.50%
13%
13.50%
14%
14.50%
SCAR OBJETIVO (2 pts) ESCENARIOS (2 pts)
Plantear 2 escenarios: una mejor
opción y una peor opción,variando los
la persona solo puede datos de la tasa y el tiempo. Mostrar
ta de S/. 2500, se debe un informe resumen de escenarios.
ces qué valor de tasa
r en la entidad financiera
ho monto.

S/. 2,646.56
PROGRAMACIÓN LINEAL - SOLVER (3.5 pts)

D1 D2
A 2 1 2.5
B 3 2 1.45
70 120

Minimizar 87

A 0
B 60

restricciones
180 >= 70
120 >= 120
PROGRAMACIÓN LINEAL - SOLVER (3.5 pts)

benef horas tela maximo


A 40 4 3 9
B 20 3 5
48 60

Maximo 440

A 9
B 4

restricciones
48 <= 48
47 <= 60
9 <= 9

You might also like