Question

What would be the future value of $15,555 invested now if it earns interest at 14.5...

What would be the future value of $15,555 invested now if it earns interest at 14.5 percent for seven years? Using a financial calculator, enter 15555 and press PV, enter 14.5 and press %i, and enter 7 and press N. Then, press CPT and FV which gives an answer of 40133.63 or $40,133.63. Using Excel, click financial wizard, then FV, enter 0.14 for rate, 7 for nper, 0 for pmt, 15,555 for PV, 0 for type. Press enter answer is ($40,133.63) in RED.

What would be the future value of $19,378 invested now if the money remains deposited for eight years and the annual interest rate is 18 percent?

              Using a financial calculator, enter 19378 and press PV, enter 18 and press %i, and enter 8 and press N. Then, press CPT and FV which gives an answer of 72839.17 or $72,839.17.

Using Excel, click financial wizard, then FV, enter 0.18 for rate, 8 for nper, 0 for pmt, 19,378 for PV, 0 for type. Press enter, answer is ($72,839.17) in RED.

Homework Answers

Answer #1

Via EXCEL :

i)click financial wizard, then FV, enter 0.14 for rate, 7 for nper, 0 for pmt, 15,555 for PV, 0 for type. Press enter answer is ($40,133.63) in RED.

ii).click financial wizard, then FV, enter 0.18 for rate, 8 for nper, 0 for pmt, 19,378 for PV, 0 for type. Press enter, answer is ($72,839.17) in RED.

Via Financial Calculator:

i) enter 15555 and press PV, enter 14.5 and press i/y, and enter 7 and press N. Then, press CPT and FV which gives an answer of 40133.63 or $40,133.63.

ii).enter 19378 and press PV, enter 18 and press i/y, and enter 8 and press N. Then, press CPT and FV which gives an answer of 72839.17 or $72,839.17.

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
. 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).
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to...
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial. You will submit your spreadsheet through D2L, and...
Time Value of Money Overview: In corporate finance, students need to be able to calculate present...
Time Value of Money Overview: In corporate finance, students need to be able to calculate present and future values of investments. Purpose: The purpose for this project is to demonstrate an understanding of how to calculate present and future values. Requirements: Review the examples then answer all of the questions below. Example 1: What is the present value of the $800 to be received 10 years from now discounted back to the present at 10%. Use your financial calculator to...
18-a) What would be the future value of $18,000 invested now if the money remains deposited...
18-a) What would be the future value of $18,000 invested now if the money remains deposited for eight years, the annual interest rate is 18 percent, and interest on the investment is compounded semi-annually? b) How would your answer for (a) change if quarterly compounding were used?
I don't really need the answer since I have the answer. I just need to know...
I don't really need the answer since I have the answer. I just need to know how to solve them, like what buttons to click on the financial calculator. Please go based on the answer I have provided. Don't use r or c to explain. Only explain using n, i, pv, fv, pmt. 1.)You are 40 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now...
To the closest year, how long will it take $200 to double if it is deposited...
To the closest year, how long will it take $200 to double if it is deposited and earns the following rates? [Notes: (1) If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can “override” the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the...
Are you able to answer this in terms of how to solve using a financial calculator?...
Are you able to answer this in terms of how to solve using a financial calculator? What to enter for [N, I/YR, PV, PMY, FV] as well as how you determined these numbers? Please verify answer below and explain any discrepancies. Question: You just inherited $1,000,000. Instead of taking a lump sum, a financial planner has suggested two additional options. First, you invest in an annuity that will pay you $125,000 per year for 10 years. The discount rate is...
Time Value of Money The following situations test your comprehension of time value of money concepts....
Time Value of Money The following situations test your comprehension of time value of money concepts. You will need your financial calculator. For each problem write the variable from the problem next to the variable in your calculator menu. Put a question mark next to the variable we are solving for, and put the answer to that variable on the “Answer” line. Remember that there has to be a negative number in your calculations for the formulas to work. If...
(Bond valuation) ExxonMobil 20-year bonds pay 6 percent interest annually on a $1,000 par value. If...
(Bond valuation) ExxonMobil 20-year bonds pay 6 percent interest annually on a $1,000 par value. If bonds sell at $945, what is the bonds’ expected rate of return? Please answer it without a financial calculator or Excel. Possibly with this formula: PV= PMT x ((1-(1+r)^-n)/(r)) + Face Value x (1/(1+r)^n)
4. Find the future value of the following annuities. The first payment in these annuities is...
4. Find the future value of the following annuities. The first payment in these annuities is made at the end of Year 1, so they are ordinary annuities. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for...