Question

Suppose that you are planning to buy a boat in the future for $100,000 [cell B2]...

Suppose that you are planning to buy a boat in the future for $100,000 [cell B2] and you deposit a lump sum of $50,000 CAD [cell B1] that earns an average annually compounding rate of return of 6% per year [cell B3].


(a) How long (in years) would it take [cell B5] until you accumulate the lump sum needed? Use the NPER function.
(b) What is the correct formula (using 18 characters or less) that should be placed in cell B5?
Note: There are to be NO numbers in the function call (apart from a 0 if appropriate), only cell references, or negative cell references where appropriate.

Homework Answers

Answer #1

Number of years  until you accumulate the lump sum needed is calculated using NPER function in Excel as below ;

rate = 6%

pmt = 0 (annual deposit is zero)

pv = -50000 (Amount deposited today. This is entered with a negative sign because it is a cash outflow)

fv = 100000 (Amount required at end. This is entered with a positive sign because it is a cash inflow)

The cell references are given as appropriate.

NPER is calculated to 11.90 years

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT