Question: please show the excel reference Problem #2: Suppose that you are planning to buy a boat in the future for $100,000 (cell B2] and you

please show the excel reference

please show the excel reference Problem #2: Suppose that you are planning

Problem #2: Suppose that you are planning to buy a boat in the future for $100,000 (cell B2] and you deposit a lump sum of $30,000 CAD (cell B1] that earns an average annually compounding rate of return of 14% per year [cell B3]. B A 1 Present value 2 Future value 3 Annual rate 4 5 Number of years 6 (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. Problem #2(a): Answer correct to 2 decimals Problem #2(b): Just Save Submit Problem #2 for Grading Problem #2 Attempt #1 Your Answer: 2(a) 2(b) Your Mark: 2(a) 2(b) Attempt #2 2(a) 2(b) 2(a) 2(b) Attempt #3 2(a) 2(b) 2(a) 2(b) Attempt #4 2(a) 2(b) 2(a) 2(b) Attempt #5 2(a) 2(b) 2(a) 2(b)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!