please answer the questions above using excel formulas**

You need $150,000 in 18 years for your daughter's eductation. If you can earn 6% per year, how much do you need to invest today? What are you looking for? FV = NPER = RATE = Use the PV formula: PV(rate,nper,pmt,fv) Compute PV = You have $10,000 to invest. You will need the money in 5 years and you expect to earn 8% per year. How much will you have in 5 years. What are you looking for? PV = NPER = RATE = Use the FV formula: FV(rate,nper,pmt,pv) Compute FV = (Notice that the spreadsheet has the same sign convention as the calculators with positive inflows and negative outflows.) Note that the payment is 0, so a 0 is interested in the appropriate place in the formula