PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
Problem 3:
A soda corking machine worth $250,000 dollars (20.9035) cash is sold in installments to Embotelladora Del Valle, S.A., with a down payment of $30,000 dollars and the balance in two and a half years with monthly payments in pesos, charging 12¼% interest.
(one dollar is worth 20.9035 pesos)
e) Find the value of each of the monthly payments in pesos.
f) Find the total amount paid in pesos.
g) Find the total amount of interest paid in pesos.
h) Find the effective rate.
Note:
In the image, this is the original exercise, it is in Spanish, but it is easy to understand.
Very important Note:
It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.
ONLY ANSWER EXERCISE H) Find the effective rate.
Extracted text: Problema 3: Una máquina corchadora de gaseosas que vale $250,000 dólares (20.9035) de contado se vende a plazos a Embotelladora Del Valle, S.A., con un anticipo de $30,000 dólares y el saldo en dos años y medio con pagos mensuales en pesos, cargando el 12%% de interés. e) Hallar el valor de cada uno de los pagos mensuales en pesos. f) Hallar el monto total pagado en pesos. g) Hallar el monto total de los intereses pagados en pesos. h) Hallar la tasa efectiva.