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.

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 9 12% ? $312,200 13 11% ? $629,380 25 13% ?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

1. FV = -200,000

nper = 15

rate = 10%

PV(rate, nper, pmt, [fv], [type])

(Ignore [type])

PV(10%, 15, 0, -200000)

PV = $47,878.4099

2.

Screenshot with formulas

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
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...
Suppose you are committed to owning a $193152 Ferrari. If you believe your mutual fund can...
Suppose you are committed to owning a $193152 Ferrari. If you believe your mutual fund can achieve a 13.4 percent annual rate of return and you want to buy the car in 10 years, how much must you invest today? Suppose you are committed to owning a $193152 Ferrari. If you believe your mutual fund can achieve a 13.4 percent annual rate of return and you want to buy the car in 10 years, how much must you invest today?...
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...
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...
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
. 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).
Use Excel and the text to calculate the present value of a series of cash flows...
Use Excel and the text to calculate the present value of a series of cash flows if you put $3,500 into a fund at the end of the year for 10 years at 6%, but you won’t start depositing money for 10 years, i.e., will defer your annuity for 10 years? Be prepared to describe how you calculated your answer. Use the two step approach that subtracts values in your Excel work because calculating factors is more difficult in Excel
Present Values: Please provide the calculations in MS Excel for the present value of an $7,000...
Present Values: Please provide the calculations in MS Excel for the present value of an $7,000 goal in 7 years at 7% discounted on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny. Future Values: Please provide the calculations in MS Excel for a future value of an $7,000 investment today in 7 years at 7% compounded on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny. Present Value of an Annuity: Please provide...
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...
Please use Excel to answer the following TVM questions. You can use this spreadsheet to set...
Please use Excel to answer the following TVM questions. You can use this spreadsheet to set up your calculations if you so desire. Unless indicated otherwise, assume that all of the problems are ordinary annuities (payment made at the end of the period).        Part 4 I need $1,000,000 in 20 years if I am going to retire (Fat Chance!!) I currently have $100,000 saved for my retirement (I wish!!). A slick Wallstreet investment expert with the last name of Madoff...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT