Topic 2 worksheet - TVM (Compatibility Mode)

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

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

View Full Document Right Arrow Icon
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

Ask a homework question - tutors are online