Topic 2 worksheet - TVM (Compatibility Mode)

# A fv formula to make the you need 150000 in 18 years

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

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

## This note was uploaded on 06/28/2010 for the course FINANCE FIN3410 taught by Professor On9 during the Spring '10 term at New England Conservatory.

Ask a homework question - tutors are online