note: please make sure to properly format your answers. all dollar figures in the answers need to include a…

note: please make sure to properly format your answers. all dollar figures in the answers need to include a dollar sign and any comma ($2,354.67). all percentage values in the answers need to include a percentage sign (%). for all items without specific round two decimal places, show both decimal places (5.06).\nmax created a spreadsheet for installment purchase calculations.\n| | a | b | c | d | e | f | g | h |\n|--|--|--|--|--|--|--|--|--|\n| 1 | purchase price | down payment percentage as a decimal | down payment | monthly payment | time in years | time in months | total of monthly payments | finance charge (interest) |\n| 2 | $1,200 | 0.20 | f. | $97.01 | 1 | j. | n. | s. |\n| 3 | $1,750 | 0.10 | g. | $71.12 | 2 | k. | p. | t. |\n| 4 | $1,340 | 0.15 | h. | $77.23 | 1.5 | l. | q. | u. |\n| 5 | $980 | 0.10 | i. | $165.51 | 0.5 | m. | r. | v. |\na. write a spreadsheet formula to compute the down payment in cell c2. a2*b2\nb. write a spreadsheet formula to compute the time in months in cell f2. e2*12\nc. write a spreadsheet formula to compute the total of monthly payments in cell g2. d2*f2\nd. write the spreadsheet formula to compute the finance charge in cell h2. g2 - (a2 - c2)\ne. use your answers to a - d to fill in the missing entries f - v.

note: please make sure to properly format your answers. all dollar figures in the answers need to include a dollar sign and any comma ($2,354.67). all percentage values in the answers need to include a percentage sign (%). for all items without specific round two decimal places, show both decimal places (5.06).\nmax created a spreadsheet for installment purchase calculations.\n| | a | b | c | d | e | f | g | h |\n|--|--|--|--|--|--|--|--|--|\n| 1 | purchase price | down payment percentage as a decimal | down payment | monthly payment | time in years | time in months | total of monthly payments | finance charge (interest) |\n| 2 | $1,200 | 0.20 | f. | $97.01 | 1 | j. | n. | s. |\n| 3 | $1,750 | 0.10 | g. | $71.12 | 2 | k. | p. | t. |\n| 4 | $1,340 | 0.15 | h. | $77.23 | 1.5 | l. | q. | u. |\n| 5 | $980 | 0.10 | i. | $165.51 | 0.5 | m. | r. | v. |\na. write a spreadsheet formula to compute the down payment in cell c2. a2*b2\nb. write a spreadsheet formula to compute the time in months in cell f2. e2*12\nc. write a spreadsheet formula to compute the total of monthly payments in cell g2. d2*f2\nd. write the spreadsheet formula to compute the finance charge in cell h2. g2 - (a2 - c2)\ne. use your answers to a - d to fill in the missing entries f - v.

Answer

Explanation:

Step1: Calcular pago inicial en C2

Para la fila 2, el pago inicial (f) se calcula como $A2B2$. Entonces, $f = 12000.20=$240$.

Step2: Calcular tiempo en meses en F2

Para la fila 2, el tiempo en meses (j) se calcula como $E212$. Entonces, $j = 112 = 12$ meses.

Step3: Calcular total de pagos mensuales en G2

Para la fila 2, el total de pagos mensuales (n) se calcula como $D2F2$. Entonces, $n=97.0112=$1164.12$.

Step4: Calcular cargo financiero en H2

Para la fila 2, el cargo financiero (s) se calcula como $G2-(A2 - C2)$. Entonces, $s=1164.12-(1200 - 240)=$204.12$.

Para la fila 3:

Step5: Calcular pago inicial en C3

El pago inicial (g) se calcula como $A3B3$. Entonces, $g = 17500.10=$175$.

Step6: Calcular tiempo en meses en F3

El tiempo en meses (k) se calcula como $E312$. Entonces, $k = 212 = 24$ meses.

Step7: Calcular total de pagos mensuales en G3

El total de pagos mensuales (p) se calcula como $D3F3$. Entonces, $p=71.1224=$1706.88$.

Step8: Calcular cargo financiero en H3

El cargo financiero (t) se calcula como $G3-(A3 - C3)$. Entonces, $t=1706.88-(1750 - 175)=$131.88$.

Para la fila 4:

Step9: Calcular pago inicial en C4

El pago inicial (h) se calcula como $A4B4$. Entonces, $h = 13400.15=$201$.

Step10: Calcular tiempo en meses en F4

El tiempo en meses (l) se calcula como $E412$. Entonces, $l = 1.512 = 18$ meses.

Step11: Calcular total de pagos mensuales en G4

El total de pagos mensuales (q) se calcula como $D4F4$. Entonces, $q=77.2318=$1390.14$.

Step12: Calcular cargo financiero en H4

El cargo financiero (u) se calcula como $G4-(A4 - C4)$. Entonces, $u=1390.14-(1340 - 201)=$251.14$.

Para la fila 5:

Step13: Calcular pago inicial en C5

El pago inicial (i) se calcula como $A5B5$. Entonces, $i = 9800.10=$98$.

Step14: Calcular tiempo en meses en F5

El tiempo en meses (m) se calcula como $E512$. Entonces, $m = 0.512 = 6$ meses.

Step15: Calcular total de pagos mensuales en G5

El total de pagos mensuales (r) se calcula como $D5F5$. Entonces, $r=165.516=$993.06$.

Step16: Calcular cargo financiero en H5

El cargo financiero (v) se calcula como $G5-(A5 - C5)$. Entonces, $v=993.06-(980 - 98)=$111.06$.

Answer:

f. $240 j. 12 n. $1164.12 s. $204.12 g. $175 k. 24 p. $1706.88 t. $131.88 h. $201 l. 18 q. $1390.14 u. $251.14 i. $98 m. 6 r. $993.06 v. $111.06