ZuoTi.Pro
Question

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.

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

  1. Calculate the present values in the table below using the PV Excel function. (6 Points)

Future value

Years

Interest rate

Present value

$19,500

           15

6%

?

$47,390

          8

12%

?

$312,200

         12

11%

?

$629,380

         26

13%

?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
In this part, calculate the present values. Use the Excel PV function to compute the present...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Calculating Present Values [LO2] Suppose you are committed to owning a $245,000 Ferrari. If you believe...

    Calculating Present Values [LO2] Suppose you are committed to owning a $245,000 Ferrari. If you believe your mutual fund can achieve an annual rate of return of 11.2 percent and you want to buy the car in 9 years (on the day you turn 30), how much must you invest today?

  • Problem 5-17 Calculating Present Values (LO2) Suppose you are committed to owning a $191,000 Ferrari. If...

    Problem 5-17 Calculating Present Values (LO2) Suppose you are committed to owning a $191,000 Ferrari. If you believe your mutual fund can achieve an annual rate of return of 11 percent and you want to buy the car in 8 years on the day you turn 30. how much must you invest today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Investment

  • Suppose you are committed to owning a $175,000 Ferrari. If you believe your mutual fund can...

    Suppose you are committed to owning a $175,000 Ferrari. If you believe your mutual fund can achieve an 11.2 percent annual rate of return, and you want to buy the car in 10 years on the day you turn 30, how much must you invest today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Amount to invest

  • Suppose you are committed to owning a $245,000 Ferrari. If you believe your mutual fund can...

    Suppose you are committed to owning a $245,000 Ferrari. If you believe your mutual fund can achieve an annual rate of return of 11.2 percent and you want to buy the car in 9 years (on the day you turn 30), how much must you invest today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

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

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

  • Use the PV function in Excel to calculate what you would have to invest in a...

    Use the PV function in Excel to calculate what you would have to invest in a savings account today if you wanted to accumulate $1,216.65 in five years and could invest at 4% per year with interest paid and compounded annually.

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

  • How to calculate the PV? Explain the number that you put in PV function in excel...

    How to calculate the PV? Explain the number that you put in PV function in excel please! Question 3 A privately run, for-profit, prison is considering ways in which it can cut its monthly costs and therefore increase profit. One idea it is considering is to pay a judge to guarantee convicted prisoners in poor health win their appeals and are set free. The prison believes it can realize the monthly cost savings below over the initial year of the...

  • Using PV function in Excel. Cant get to generate the right answer for PV, Annuity and...

    Using PV function in Excel. Cant get to generate the right answer for PV, Annuity and NPV formulas. It should be 7462.20, just like the sum of All PV. 2) Find the present value of a 10 year annuity due of $1,200 with 12% APR and quarterly compounding Requirement: Calculation and output sections must update automatically with changes in data input. Update shaded cells with formulas and functions. Data Input Cashflow Rate Discount Rate Periods S1,200 12% 12.55% 0.12550881 10...

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