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
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
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





