Question

Part 3: Interest Rate In this part, calculate the interest rates. Use the Excel Rate function...

Part 3: Interest Rate

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

  1. 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? (7 Points)

  1. Calculate the interest rates in the table below using the Excel Rate function. (7 Points)

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

?

Part 3: (See https://support.office.com/en-US/article/RATE-function-9F665657-4A7E-4BB7-A030-83FC59E748CE)
E)
Nper Pmt PV FV Rate
F)
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
0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Part 3: Interest Rate In this part, calculate the interest rates. Use the Excel Rate function...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 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? (6 Points) Calculate the interest rates in the table below using the Excel Rate function. (6 Points) Present Value Years Future Value Interest Rate $750 10 $1,380 ? $900 12 $1,750 ? $16,000 25 $142,800...

  • 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. You expect to receive $30,000 at graduation. You plan on investing it at 4 percent until you have $130,000. How long will you wait from now? (6 Points) Calculate the number of periods in the table below using the Excel Nper function. (6 Points) Present Value Interest Rate Future Value Years $190 7% $870 ? $2,175 11% $3,590 ? $47,850 10%...

  • Which Excel function is used to calculate the amount of each annuity payment? FV NPV PMT...

    Which Excel function is used to calculate the amount of each annuity payment? FV NPV PMT PV Which fields are required to calculate the rate of return (RATE) for a present value calculation in Excel? Nper, PMT, and NPV Nper, PMT, and PV Type, PMT, and FV PMT, Type, and NPV

  • You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

    You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...

  • An investment adviser has promised to double your money. If the interest rate is 7% a...

    An investment adviser has promised to double your money. If the interest rate is 7% a year, how many years will she take to do so? We have entered the data vou need in cells H9 to HI1: Present value (PV) Future value (FV) Interest rate (r) 1 2 0,06 You can use the present value formula to value an annuity You can either find the answer by taking logs of the present value formula or you can use Excel's...

  • 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 $180,000 Ferrari. If you believe your mutual fund can achieve an annual return of 10 percent, and you want to buy the car in 12 years, how much must you invest today? (6 Points) Calculate the present values in the table below using the PV Excel function. (6 Points) Future value Years Interest rate Present value $19,500...

  • You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...

    You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000 per year for 30 years? To help you in your decision, estimate the present value of the second option assuming constant annual interest rates of 6%, 8%, and 10%. Expound on your decision within a text box. (You may use the built-in PV function within Excel) Loans: where: and, interest due at the end of each month A = payment P = principal (amount...

  • Calculating Interest Rates: Solve for the unknown interest rate in each of the following: Present Value...

    Calculating Interest Rates: Solve for the unknown interest rate in each of the following: Present Value Years Interest Rate Future Value               217 3                 293               432 10             1,053         41,000 16         162,181         54,382 19         483,500 Calculating Future Values: Compute the future value of $3550 compounded annually for a. 10 years at 6% b. 10 years at 8% c. 20 years at 6% d. Why is the interest earned in part (c) not twice the...

  • part 1 given info present value = periodic interest rate = number of compounding periods =...

    part 1 given info present value = periodic interest rate = number of compounding periods = 190.00 0.080 6.00 What is the future value (single payment)? part 2 future value periodic interest rate = number of compounding periods = 301.51 0.080 6.00 what is the present value (single payment)? part 3 periodic payment periodic interest rate = number of compounding periods = 340.00 0.02 8.00 What is the future value of this annuity? part 4 present value (amount borrowed) =...

  • how doni do this in excel and what is the interest rate? Suppose that you wish to purchase a car and that your bank...

    how doni do this in excel and what is the interest rate? Suppose that you wish to purchase a car and that your bank is offering to you a loan. You wish to explore the nature of this loan and the payments that you would have to make given certain circumstances such as the amount that you borrow. Fortunately, Excel offers a function (PMT) that calculates the payment for a loan based on constant payments and a constant interest rate....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT