Excel question please help!!?
if you deposit $10 at the end of every month for 2 years at an annual rate of 12%, to calculate the future value of your investment, you would type into a cell
More Questions From This User See All
if you deposit $10 at the end of every month for 2 years at an annual rate of 12%, to calculate the future value of your investment, you would type into a cell
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
I would type the following formula
=FV(12%/12;24;-10;0)
The first parameter is the rate /12 as it is annual formula and we have monthly deposits.
The second parameter is the period: 24 months
The third parameter is the monthly payment (it should always be negative as it~s a payment).
The 04th is always zero.
Hope it helps.