Question
In: Finance
Calculate the future value of the following annuity streams: (LG 2-9) a. $5,000 received each year...
Calculate the future value of the following annuity streams: (LG 2-9) a. $5,000 received each year for five years on the last day of each year if your investments pay 6 percent compounded annually. b. $5,000 received each quarter for five years on the last day of each quarter if your investments pay 6 percent compounded quarterly. c. $5,000 received each year for five years on the first day of each year if your investments pay 6 percent compounded annually. d. $5,000 received each quarter for five years on the first day of each quarter if your investments pay 6 percent compounded quarterly.SHOW in excel please.
Solutions
Expert Solution
To solve all the parts of this question, we will use the function FV in excel.
a. $5,000 received each year for five years on the last day of each year if your investments pay 6 percent compounded annually.
Hence, FV = $28,185
b. $5,000 received each quarter for five years on the last day of each quarter if your investments pay 6 percent compounded quarterly
Hence, the FV = $115,618
c. $5,000 received each year for five years on the first day of each year if your investments pay 6 percent compounded annually.
Hence, FV = $29,877
d. $5,000 received each quarter for five years on the first day of each quarter if your investments pay 6 percent
Hence, FV = $117,353
jeff jeffy answered 1 year agoRelated Solutions
Calculate the future value of the following annuity streams: a. $5,000 received each year for 5...
Calculate the future value of the following annuity
streams:
a.
$5,000 received each year for 5 years on the last day of each
year if your investments pay 7 percent compounded annually.
(Do not round intermediate calculations. Round your answer
to 2 decimal places. (e.g., 32.16))
Future value
$
b.
$5,000 received each quarter for 5 years on the last day of each
quarter if your investments pay 7 percent compounded quarterly.
(Do not round intermediate calculations. Round your answer...
Calculate the future value of the following annuity streams: a. $5,000 received each year for 5...
Calculate the future value of the following annuity
streams:
a.
$5,000 received each year for 5 years on the last day of each
year if your investments pay 7 percent compounded annually.
(Do not round intermediate calculations. Round your answer
to 2 decimal places. (e.g., 32.16))
Future value
$
b.
$5,000 received each quarter for 5 years on the last day of each
quarter if your investments pay 7 percent compounded quarterly.
(Do not round intermediate calculations. Round your answer...
Calculate the future value of the following annuity streams: a. $5,000 received each year for 6...
Calculate the future value of the following annuity
streams:
a. $5,000 received each year for 6 years on the
last day of each year if your investments pay 6 percent compounded
annually.
b. $5,000 received each quarter for 6 years on the
last day of each quarter if your investments pay 6 percent
compounded quarterly.
c. $5,000 received each year for 6 years on the
first day of each year if your investments pay 6 percent compounded
annually.
d. $5,000...
Calculate the future value of the following annuity streams: a. $5,000 received each year for five...
Calculate the future value of the following annuity streams:
a. $5,000 received each year for five years on the last day of
each year if your investments pay 6 percent compounded
annually.
b. $5,000 received each quarter for five years on the last day
of each quarter if your investments pay 6 percent compounded
quarterly.
c. $5,000 received each year for five years on the first day of
each year if your investments pay 6 percent compounded
annually.
d. $5,000...
Calculate the present value of the following annuity streams: a. $5,000 received each year for 6...
Calculate the present value of the following annuity
streams:
a. $5,000 received each year for 6 years on the
last day of each year if your investments pay 7 percent compounded
annually.
b. $5,000 received each quarter for 6 years on the
last day of each quarter if your investments pay 7 percent
compounded quarterly.
c. $5,000 received each year for 6 years on the
first day of each year if your investments pay 7 percent compounded
annually.
d. $5,000...
Calculate the future value of the following annuity streams: a. $4,000 received each year for 4...
Calculate the future value of the following annuity
streams:
a. $4,000 received each year for 4 years on the
last day of each year if your investments pay 5 percent compounded
annually.
b. $4,000 received each quarter for 4 years on the
last day of each quarter if your investments pay 5 percent
compounded quarterly.
c. $4,000 received each year for 4 years on the
first day of each year if your investments pay 5 percent compounded
annually.
d. $4,000...
Calculate the present value of the following annuity streams: a. $4,000 received each year for 4...
Calculate the present value of the following annuity
streams:
a. $4,000 received each year for 4 years on the
last day of each year if your investments pay 6 percent compounded
annually.
b. $4,000 received each quarter for 4 years on the
last day of each quarter if your investments pay 6 percent
compounded quarterly.
c. $4,000 received each year for 4 years on the
first day of each year if your investments pay 6 percent compounded
annually.
d. $4,000...
Calculate the present value of the following annuity streams: a. $7,000 received each year for 6...
Calculate the present value of the following annuity
streams:
a. $7,000 received each year for 6 years on the
last day of each year if your investments pay 6 percent compounded
annually.
b. $7,000 received each quarter for 6 years on the
last day of each quarter if your investments pay 6 percent
compounded quarterly.
c. $7,000 received each year for 6 years on the
first day of each year if your investments pay 6 percent compounded
annually.
d. $7,000...
Calculate the present value of the following annuity streams: a. $6,000 received each year for 6...
Calculate the present value of the following annuity streams: a.
$6,000 received each year for 6 years on the last day of each year
if your investments pay 7 percent compounded annually. (Do not
round intermediate calculations. Round your answer to 2 decimal
places. (e.g., 32.16)) Present value $ b. $6,000 received each
quarter for 6 years on the last day of each quarter if your
investments pay 7 percent compounded quarterly. (Do not round
intermediate calculations. Round your answer...
Calculate the following: (LG 15-2) a. What is the amount of the annuity purchase required if...
Calculate the following: (LG 15-2) a. What is the amount of the
annuity purchase required if you wish to receive a fixed payment of
$240,000 for 20 years? Assume that the annuity will earn 7 percent
per year. b. Calculate the annual cash flows from a $2.5 million,
20-year fixed-payment annuity earning a guaranteed return of 7
percent per year if payments are to begin at the end of the current
year. c. Calculate the annual cash flows from a...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- JAVASCRIPT: Please create an array of student names and another array of student grades. - Create...
- Topic - Construction: Structural, loads, tension 1.) Explain why pure tension members are the most efficient...
- Procter and Gamble (PG) paid an annual dividend of $ 1.62$1.62 in 2009. You expect PG...
- locate a recent case of online child pornography. Write a summary of the incident and describe...
- #Python 5. Write function called evaluate() that evaluates the following Python expressions or assignments as specified:...
- Suggest journal, research paper link reference. i need this as reference for writing a research with...
- Cryptography is used heavily in internet communications. True or false? Explain
ADVERTISEMENT