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 ...

Coast Jewelers Ch 0701 Solution Present Value Analysis Future need Term in years Interest rate Annui ...

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 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 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 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 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...