The stated interest rate for a bank account is 4% p

Finance May 27, 2021

The stated interest rate for a bank account is 4% p.a. and the interest is paid semi-annually. How many years will it take for the initial deposit to double its value?
28

Expert Solution

Computation of Number of Years using NPER Function in Excel:

=nper(rate,pmt,-pv,fv)/2

Here,

Number of Years = ?

Rate = 4%/2 = 2%

PMT = 0

PV = $100 (Assumed)

FV = $100*2 = $200

Substituting the values in formula:

=nper(2%,0,-100,200)/2

NPER or Number of Years = 17.50 years

Archived Solution

Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In

Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution

Get Custom Quote