Question

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

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Case-1
Future value 13827
Multiply: PVF at 7% for 8yrs 0.582009
Present value of amount 8047.438
Ccase-2
Future value 43852
Multiply: PVF at 15% for 13yrs 0.162528
Present value of amount 7127.178
Case-3
Future value 725380
Multiply: PVF at 11% for 17yrs 0.169633
Present value of amount 123048.4
Case-4
Future value 590710
Multiply: PVF at 18% for 26yrs 0.013523
Present value of amount 7988.171
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
Calculating Future Values. For each of the following, compute the future value. PRESENT VALUE YEARS INTEREST...
Calculating Future Values. For each of the following, compute the future value. PRESENT VALUE YEARS INTEREST RATE FUTURE VALUE 5 510 10 12.7% 14 790 30 11 156 280 22 10 397 920 36 7
2- Compute the future value for the following: Present Value: 107954 Years: 13 Interest rate: 10...
2- Compute the future value for the following: Present Value: 107954 Years: 13 Interest rate: 10 (Provide answer to two decimals, i.e. 32.16) 3- Compute the future value for the following: Present Value: 62132 Years: 11 Interest rate: 6 (Provide answer to two decimals, i.e. 32.16) 4- Compute the future value for the following: Present Value: 203739 Years: 32 Interest rate: 8 (Provide answer to two decimals, i.e. 32.16) 5- Compute the present value for the following: Future Value: 230374...
Compute Future Value: Present Value, Years, Interest Rate= Future Value 2350, 12, 12%= ? 8952, 6,...
Compute Future Value: Present Value, Years, Interest Rate= Future Value 2350, 12, 12%= ? 8952, 6, 10%=? 78355, 13, 11%=? 185796, 7, 7%=?   
Please compute the following present values and future values: 1) The future value of $500 invested...
Please compute the following present values and future values: 1) The future value of $500 invested for 10 years at 10% interest. 2) The future value of $800 invested for 5 years at 15% interest. 3) The future value of $30,000 invested for 20 years at 6%. 1) The present value of $200,000 to be received in 20 years, if discounting at 5%. 2) The present value of $80,000 to be received in 10 years, if discounting at 8%. 3)...
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...
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...
3.         Solve for the unknown interest rate in each of the following: Present Value Years Future...
3.         Solve for the unknown interest rate in each of the following: Present Value Years Future Value $175 7 $317 $325 12 $1,080 $53,000 13 $165,200 $32,300 30 $685,000
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 each of the following annuities, calculate the future value.   Future Value Annual Payment Years Interest...
For each of the following annuities, calculate the future value.   Future Value Annual Payment Years Interest Rate ?????? $1,730 10 10% ?????? 8,080 33 11 ????? 4,130 9 8 ?????? 8,890 28 12
. 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).
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT