Answered step by step
Verified Expert Solution
Link Copied!

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

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

Mathematical Finance Core Theory Problems And Statistical Algorithms

Authors: Nikolai Dokuchaev

1st Edition

0415414482, 978-0415414487

More Books

Students also viewed these Finance questions

Question

Design a health and safety policy.

Answered: 1 week ago