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.

Kym plans to deposit $100 in an account at the end of each month for the next five years so that she can take a trip

Finance Aug 24, 2020

Kym plans to deposit $100 in an account at the end of each month for the next five years so that she can take a trip.

(b) How much will be in the account if the deposits are made at the beginning of each month?

Expert Solution

b). We can calculate the future value by using the following formula in excel:-

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

Here,

FV = Future value

Rate = 6%/12 = 0.50% (monthly) (Assume)

Nper = 5*12 = 60 periods (monthly)

Pmt = $100

PV = $0

Type = 1

Substituting the values in formula:

= fv(0.50%,60,-100,0,1)

= $7,011.89

The Opportunity cost of capital is not given in question so I assumed the cost of capital is 6%.

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