Question

How do i do these using excel and its functions 15.       Find the present value of...

How do i do these using excel and its functions

15.       Find the present value of a $1000 annuity that begins at the end of the 3rd year and continues until the end of the 10th year, given a 12% discount rate.

16.       Calculate the value today that is equivalent to $150 at the end of year 1, $450 at the end of year 2, and $300 at the end of year 3, given a discount rate of 10%.

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

15)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
16. Calculate the value today that is equivalent to $150 at the end of year 1,...
16. Calculate the value today that is equivalent to $150 at the end of year 1, $450 at the end of year 2, and $300 at the end of year 3, given a discount rate of 10%. how do i do this using excel and what functions do i use to do it
Solve using excel (show work) What is the total present value of the following amounts: a.)$1000...
Solve using excel (show work) What is the total present value of the following amounts: a.)$1000 received at the end of one year. Use a discount of 2.5% b.) $5000 received at the end of three years. Use a discount of 4.0% c.) $10,000 received at the end of 10 years. Use a discount rate of 9%.
What is the present value of a five-year $20,000 ordinary annuity plus of a lump sum...
What is the present value of a five-year $20,000 ordinary annuity plus of a lump sum of $110,000 at the end of year 5. Discount rate of 12% Can you teach me how to do this on excel?
A.Calculate the present value of an annuity of $5,000 received annually that begins today and continues...
A.Calculate the present value of an annuity of $5,000 received annually that begins today and continues for 10 years, assuming a discount rate of 9%. B. Joan invested $5,000 in an interest-bearing account earning an 8% annual rate of interest compounded monthly. How much will the account be worth at the end of 5 years, assuming all interest is reinvested at the 8% rate? C. Calculate the present value of an ordinary annuity of $5,000 received annually for 10 years,...
What is the present value of a five-year $20,000 ordinary annuity plus of a lump sum...
What is the present value of a five-year $20,000 ordinary annuity plus of a lump sum of $110,000 at the end of year 5. Discount rate of 12% Can you please show me how to do this in excel instead? Thank you!
Find the equivalent present value at year 0 of the following cash flows: An annuity with...
Find the equivalent present value at year 0 of the following cash flows: An annuity with an annual amount of $200, starting from end of year 3 to end of year 8, plus A lump sum cash flow of $1000 at the end of year 6. Use an annual rate of 8%
11. What is the present value of a 10-year annuity with annual payments of 50 and...
11. What is the present value of a 10-year annuity with annual payments of 50 and an interest rate of 5? a. Do this with your calculator, indicating what number you put in each button. b. Do this in Excel, using the annuity formula. 12. What is the present value of a cash flow of 1000 being paid in 10 years with an interest rate of 5%? 13. What is the sum of the calculations in (11) and (12)? What...
Part 2: Present Value In this part, calculate the present values. Use the Excel PV function...
Part 2: Present Value In this part, calculate the present values. Use the Excel PV function to compute the present values. You are committed to owning a $200,000 home. If you believe your mutual fund can achieve an annual return of 10 percent, and you want to buy the home in 15 years, how much must you invest today? (7 Points) Calculate the present values in the table below using the PV Excel function. (7 Points) Future value Years Interest...
PRESENT VALUE OF AN ANNUITY Find the present values of these ordinary annuities. Discounting occurs once...
PRESENT VALUE OF AN ANNUITY Find the present values of these ordinary annuities. Discounting occurs once a year. Round your answers to the nearest cent. $200 per year for 12 years at 4%. $   $100 per year for 6 years at 2%. $   $300 per year for 16 years at 0%. $   Rework previous parts assuming that they are annuities due. Round your answers to the nearest cent. $200 per year for 12 years at 4%. $   $100 per year...
What is the present value of a 3-year annuity of $300 if the discount rate is...
What is the present value of a 3-year annuity of $300 if the discount rate is 7%? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. What is the present value of the annuity in (a) if you have to wait an additional year for the first payment? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT