This preview shows page 1. Sign up to view the full content.
Unformatted text preview: FV formula to make the You need $150,000 in 18 years for your daughter's eductation. If you can earn 6% per year, how much d you need to invest today? What are you looking for? Use the PV formula: PV(rate,nper,pmt,fv) Compute FV = NPER = RATE = PV = ur daughter's ar, how much do 150,000 18 6% (Same as .06) $52,551.57 You have $30,000 to invest and you need $45,000 fo closing costs on a house. If you want to buy the hous of interest do you need to earn? What are you looking for? Use the RATE formula: RATE(nper,pmt,pv,fv) (Note that the rate will display as a whole percent, yo cell to see the decimal places.) ,000...
View Full Document
- Spring '10