Question

In this part, calculate the interest rates. Use the Excel Rate function to compute the interest...

In this part, calculate the interest rates. Use the Excel Rate function to compute the interest rates.

In 2018, one of the first copper pennies struck at the Philadelphia mint in 1793 was sold for $300,000. What was the rate of return on this investment?

Calculate the interest rates in the table below using the Excel Rate function. Present Value Years Future Value Interest Rate $850 10 $1,380 ? $900 14 $1,750 ? $16,000 25 $142,000 ? $70,500 16 $312,500 ?

Homework Answers

Answer #1

I have answered the question below using excel and have attached the image below.

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
In this part, calculate the present values. Use the Excel PV function to compute the present...
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? Calculate the present values in the table below using the PV Excel function. Future value Years Interest rate Present value $19,500 16 6% ? $47,390...
In this part, calculate the number of periods. Use the Excel Nper function to compute the...
In this part, calculate the number of periods. Use the Excel Nper function to compute the number of periods. G) You expect to receive $20,000 at graduation. You plan on investing it at 6 percent until you have $130,000. How long will you wait from now? Calculate the number of periods in the table below using the Excel Nper function. Present Value Interest Rate Future Value Years $190 6% $870 ? $2,175 12% $3,590 ? $47,850 11% $326,890 ? $38,571...
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...
. Provide the structure of the Excel commands to calculate pv(present value), fv(future value), rate(interest rate),...
. Provide the structure of the Excel commands to calculate pv(present value), fv(future value), rate(interest rate), pmt(payment), nper(number of periods).
Calculate Present Values: For each of the following, compute the present value: Years Interest Rate Future...
Calculate Present Values: For each of the following, compute the present value: Years Interest Rate Future Value 8 7 $13,827 13 15 43,852 17 11 725,380 26 18 590,710 **PLEASE PROVIDE EXCEL FORMULAS
For the Time value of money, I want you to explore the "=RATE(...)" function in Excel....
For the Time value of money, I want you to explore the "=RATE(...)" function in Excel. It calculates the required interest rate your investment has to generate to match your annual contributions to the desired future value. For this exercise you will need to come up with three values (required inputs for RATE function): 1) Number of years until retirement (NPER); 2) How much you are willing to contribute every year (PMT), and the desired amount of money you wish...
PART 2 - HOMEWORK 3 - Time Value of Money (30 pts) Please use Excel to...
PART 2 - HOMEWORK 3 - Time Value of Money (30 pts) Please use Excel to answer the following questions. Print an Excel spreadsheet that presents your answers to these TVM questions and also print the formula sheet that shows how you calculated your answers.   1 Calculate the present value of 120 monthly payments of $300 at an annual rate of 8%. The payments are made at the end of each month. 2 You are financing a new car with...