I am doing a problem in which I have to determine the future value of an investment given the interest rate, period of time, and initial investment amount. The initial investment is $10,000, the interest rate is 5% per year, and I have to find the future value for each year up to 20 years. How do I solve this for the future value using Excel?
You should write to 1 cell you initial investment (let it be the cell B2)inthe cell below write the next formula: =B2+B2*0.05 . To do it you should copy =B2+B2*0.05 and paste it to the cell B3 Then you should move your mouse to the right bottom corner of cell B3 and "stretch" it to the next 20 cells down and your answer will be in the cell B22. that`sall.
The assignments were completed in a timely manner and were complete. I missed a few points on small little nit pick things that my professor didn't like but I still got a rocking grade and was very satisfied! The price and time was what kept me coming back for more assignments! Thanks so much!