Create a new Coast Jewelers' Present Value Analysis a. Using the ch7-01 file to start your work,

Question:

Create a new Coast Jewelers' Present Value Analysis
a. Using the ch7-01 file to start your work, modify that worksheet to do the following:
i. Calculate the annuity payment required at the end of each year for the next 3 years such that the value in 3 years is $75,000 and illustrate the annual value of that investment.
ii. Calculate the future value of an investment of $23,000 invested for 3 years at a rate of 6 percent and illustrate the annual value of that investment.
iii. Calculate the future value of an investment of $13,500 each year for 3 years at a rate of 5 percent and illustrate the annual value of that investment.
iv. Calculate the initial investment required to obtain a future value of $16,500, assuming a rate of 7 percent for 3 years and illustrate the annual value of that investment.
b. Save the file as ch7-01_student_name (replacing student_name with your name).
c. Print the resulting worksheet in value view.
d. Print the resulting worksheet in formula view. Annuity
An annuity is a series of equal payment made at equal intervals during a period of time. In other words annuity is a contract between insurer and insurance company in which insurer make a lump-sum payment or a series of payment and, in return,...
Future Value
Future value (FV) is the value of a current asset at a future date based on an assumed rate of growth. The future value (FV) is important to investors and financial planners as they use it to estimate how much an investment made today will be worth...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: