PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
9.-
Textiles del Desierto, S.A., negotiates an industrial equipment worth $650,000.00 (20.35) cash is sold in installments, with an advance payment of 15% and the balance in a year and a half with equal semi-annual payments, charging 16½ % interest. Find the value of each of the semiannual payments or annuities.
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.
please... understand the context of the exercise in Spanish, it is easy to understand.
Extracted text: Textiles del Desierto, S.A., negocia un equipo industrial con valor de $650,000 dólares (20.35) de contado se vende a plazos, con un anticipo del 15% y el saldo en año y medio con pagos iguales semestrales, cargando el 162 % de interés. Hallar el valor de cada uno de los pagos semestrales o anualidades.