Question: everything is in order please ccomplete if need ill edit abd post excel sheet Directions: Work with a partner or small group to calculate the

everything is in order please ccomplete if need ill edit abd post excel sheet
everything is in order please ccomplete if need ill edit abd post
excel sheet Directions: Work with a partner or small group to calculate
the future value of a one-time investment using the formula for compound

Directions: Work with a partner or small group to calculate the future value of a one-time investment using the formula for compound interest. Follow your instructor's guidelines; he or she may have you do all three ways of calculating future value or just one way. The calculations will be based on three different interest rates (5%,12% and 18%). Then create a graph to show how the rate of return affects the future value. To make it more practical, use a small initial investment of $250. Use 40 years as the time frame, since that is the best representation of how much time you'll have to invest for retirement if you start now. After computing the one-time investment of $250 using the three different interest rates, repeat the calculations using $500 and $1,000. Three Methods of Computation 1 Manually calculate the Future Value using a calculator. FV=PV[1+r/m]mtFV=FutureValueoftheinvestmentPV=PresentValueoftheinvestment(theone-timedeposit)r=annualrateofinterestasadecimal[5%isexpressedasthedecimal0.05)m=numberoftimesperyeartheinterestiscompounded[onceperyear]t=numberofyearsyouleaveitinvested(40years) Rate = interest rate (use 12% ) Nper = total number of payment periods/total years invested [40] Pmt= the payment made each period (use 0 because it is a one-time investment) PV= present value or the initial investment Type w when payments are due beginning or end of period luse 1) 3. Use the online investing calculator at the www.foundationsU.com website. When you find the calculator, use the "Advanced version." TIP: If you have trouble finding the calculator, search for "investment calculator" using the search box at the top of the site

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!