Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Private Funds Where And How

Authors: Dechert LLP

2018 Edition

152650300X,1526503018

More Books

Students also viewed these Finance questions