Worksheet_ch5

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

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

View Full Document Right Arrow Icon
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.)
Background image of page 1

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

View Full DocumentRight Arrow Icon
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?
Background image of page 2
What are you looking for? PV =
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
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

This note was uploaded on 10/25/2011 for the course ECON 393 taught by Professor D during the Spring '10 term at Rutgers.

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 Right Arrow Icon
Ask a homework question - tutors are online