Reference no: EM131988459
How to solve these questions in excel?
Answer the following questions:
a. Assuming a rate of 10% annually, find the FV of $1,000 after 5 years.
b. What is the investment's FV at rates of 0%, 5%, and 20% after 0, 1, 2, 3, 4, and 5 years?
c. Find the PV of $1,000 due in 5 years if the discount rate is 10%.
d. What is the rate of return on a security that costs $1,000 and returns $2,000 after 5 years?
e. Suppose California's population is 36 5 million people and its population is expected to grow by 2% annually. How long will it take for the population to double?
f. Find the PV of an ordinary annuity that pays $1,000 each of the next 5 years if the interest rate is 15%. What is the annuity's FV?
g. How will the PV and FV of the annuity in Part f change if it is an annuity due?
h. What will the FV and the PV be for $1,000 due in 5 years if the interest rate is 10%, semiannual compounding?
i. What will the annual payments be for an ordinary annuity for 10 years with a PV of $1,000 if the interest rate is 8%? What will the payments be if this is an annuity due?
|
Approximately how long ago did the man die
: If the half-life of carbon 14 is 5600 years, approximately how long ago did the man die?
|
|
Why do free trade areas develop rules of origin
: Why do free trade areas develop rules of origin? What would happen if rules of origin were removed? What does this crisis tell us about the weaknesses of euro?
|
|
Under what conditions will company change its payment terms
: Under what conditions will a company change its payment terms? Why? Limit the breadth of your essay to what you think
|
|
What is the average amount of receivables
: Snider Industries sells on terms of 3/10, net 40. Total sales for the year are $584,000. What is the average amount of receivables?
|
|
How long will it take for the population to double
: Suppose California's population is 36 5 million people and its population is expected to grow by 2% annually. How long will it take for the population to double
|
|
Identify candidate you would like to hire for this position
: Create a 625- to 800-word new hire acceptance letter to send to the candidate of your choice. This is inclusive of the preview and conclusion of the assignment
|
|
How factors such as culture inform the various dimensions
: How factors such as culture, ethnicity, gender, race, age, religion, and/or sexual orientation inform the various dimensions of your chosen problem or topic.
|
|
What is snoopys total monthly outlay
: Snoopy borrows $7200 at 8.1% nominal convertible monthly to pay for his new super-deluxe doghouse.
|
|
What is the largest simple interest rate as an annual rate
: Smith does not have the cash on hand 7 days later, but decides to borrow the 975 to take advantage of the discount.
|