Worksheet_ch5

# Worksheet_ch5 - 30,000 FV = 45,000 Use the RATE formula...

This preview shows pages 1–4. Sign up to view the full content.

What are you looking for? PV = 10,000 NPER = 5 Use the FV formula: RATE = 8%(Same as .08) FV(rate,nper,pmt,pv) Compute FV = \$14,693.28 Note that this problem does not include a payment, so it was entered as 0. 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. (Notice that the spreadsheet has the same sign convention as the calculators with positive inflows and negative outflows. A negative sign was placed before the FV formula to make the result positive.)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
What are you looking for? FV = 150,000 NPER = 18 Use the PV formula: RATE = 6%(Same as .06) PV(rate,nper,pmt,fv) Compute PV = \$52,551.57 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? PV =

This preview has intentionally blurred sections. Sign up to view the full version.

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

Unformatted text preview: 30,000 FV = 45,000 Use the RATE formula: RATE(nper,pmt,pv,fv) NPER = 2 Compute RATE = 22.47% You have \$30,000 to invest and you need \$45,000 for a down payment and closing costs on a house. If you want to buy the house in 2 years, what rate of interest do you need to earn? (Note that the rate will display as a whole percent, you need to format the cell to see the decimal places.) Note a negative sign was entered before the cell reference for the FV to maintain the sign convention. What are you looking for? PV = 15,000 FV = 25,000 Use the NPER formula: RATE = 9%(Same as .09) NPER(rate,pmt,pv,fv) Compute NPER = 5.92759years You have \$15,000 to invest right now and you figure you will need \$25,000 to buy a new car. If you can earn 9% per year, how long before you can buy the car?...
View Full Document

{[ snackBarMessage ]}

### Page1 / 4

Worksheet_ch5 - 30,000 FV = 45,000 Use the RATE formula...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online