A car dealership offered a customer a new car for a down payment of $ 8,000,000 and 36 monthly payments of $ 680,000 each. If an interest rate of 30% compounded monthly is charged, find the cash value of the car.

Now, the money from her one-year lease, which begins today, with an advance monthly fee of $ 300,000, is deposited in a corporation that offers 2.5% per month. Find the accumulated obtained, six months after the expiration of the contract.

Solve with excel and show formulae