Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

1) How long would it take for you to save an adequate amount for retirement if you deposit $40,000 per year into an account beginning today that pays 12 percent per year if you wish to have a total of $1,000,000 at retirement? 2) When computing an interest or growth rate, the rate will increase the larger the future value, holding present value and the number of periods constant: T/F 3) $1,200 is received at the beginning of year 1, $2,200 is received at the beginning of year 2, and $3,300 is received at the beginning of year 3

Finance Nov 20, 2020

1) How long would it take for you to save an adequate amount for retirement if you deposit $40,000 per year into an account beginning today that pays 12 percent per year if you wish to have a total of $1,000,000 at retirement?

2) When computing an interest or growth rate, the rate will increase the larger the future value, holding present value and the number of periods constant: T/F

3) $1,200 is received at the beginning of year 1, $2,200 is received at the beginning of year 2, and $3,300 is received at the beginning of year 3. If these cash flows are deposited at 12 percent, their combined future value at the end of year 3 is *

1 point

A) $ 6,700.

B) $17,000.

C) $12,510.

  1. D) $ 8,141.

Expert Solution

1) Computation of Time using NPER Function in Excel:

=nper(rate,pmt,pv,-fv,type)

Here,

NPER = Time = ?

Rate = 12%

PMT = $40,000

PV = 0

FV = $1,000,000

Type = 1

Substituting the values in formula:

=nper(12%,40000,0,-1000000,1)

Nper or Time = 11.49 years

So, It will take 11.49 years for you to save an adequate amount for retirement if you deposit $40,000 per year into an account beginning today that pays 12 percent per year if you wish to have a total of $1,000,000 at retirement.

 

2) When computing an interest or growth rate, the rate will increase the larger the future value, holding present value and the number of periods constant. The statement is true.

 

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
Secure Payment