Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started