PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
(That the answer not be written, Please do not copy from another bartleby exercise!)
3.- Future value and simple interest. La Costanera, S.A., a pawnshop, would like to know the future or final value and simple interest (360 days per year) of the following amounts owed by its refined clientele.
a) Note #7376 for $57,500.00 for a set of diamond wedding rings, due in 90 days at 14% interest.
b) Note #9425 covering $74,500.00 for a Rolex watch (presumably from a congressman) maturing on September 18, if the promissory note was signed on February 6, considering an interest rate of 10.5%.
c) Note #8836 covering $31,000, for a refrigerator, signed on August 2, maturing on October 3 at 8.25% interest.
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)
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
(That the answer not be written, Please do not copy from another bartleby exercise!)
Extracted text: Valor futuro e intereses a interés simple. La Costanera, S.A., casa de empeño, desea conocer el valor futuro o final y el interés simple (año a 360 días) de las siguientes cantidades, adeudadas por su refinada clientela. a) La boleta #7376 que ampara $57,500.00 por un juego de sortijas de boda con diamante, con vencimiento en 90 días al 14% b) La boleta #9425 que ampara $74,500, por un reloj Rolex (presumiblemente de un diputado) con vencimiento el 18 de septiembre si el pagaré se firmó el 6 de febrero pasado, considerando una tasa de interés del 10.5% c) La boleta #8836 que ampara $31,000, por un refrigerador, firmada el 2 de agosto, con vencimiento el 3 de octubre al 8.25%