PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
3.- Andres Rosas wants to know how much he must deposit today, so that in 5 years he will have the amount (FV) of 88,180.00, which he needs to pay for a trip, a) if the account pays 6.125% interest compoundable semiannually; b) if the account pays 7.65% compoundable monthly. The formula must be cleared to find the initial value (PV).
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.
TO CONSIDER THE YEAR AS 360 DAYS (WHICH IS COMMERCIAL) (only if required)
Extracted text: 3. Andrés Rosas quiere saber cuánto debe depositar el día de hoy, para que dentro de 5 años tener la cantidad (VF) de 88,180.00, que ocupa para hacer el pago de un viaje, a) si la cuenta paga el 6.125% de interés capitalizable semestralmente; b) si la cuenta paga el 7.65% capitalizable mensualmente. Hay que despejar la fórmula para encontrar el valor inicial (VP).