Question

Find the FV of $10,000 33 years in the future if the opportunity cost rate is...

Find the FV of $10,000 33 years in the future if the opportunity cost rate is 8% (use Excel formulas and basic PV/FV techniques). Please show how to do in Excel along with formatting.

Homework Answers

Answer #1

We are given the following information:

Value of account at time 0 PV $     10,000.00
rate of interest r 8.00%
number of years n 33
Annual Compounding frequency 1
Future value FV $ 1,26,760.50

We need to solve the following equation to arrive at the required FV

So the FV is $126760.50

Excel formula asre as follows: =FV(0.08,33,0,-10000)

The PV term is entered in negative because you have to deposit it into the account to get the FV after 33 years. PV is an outflow and FV is an inflow.

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
Find the PV & FV PV FV N (years) interest rate $30,000 5 0.05 $40,000 8...
Find the PV & FV PV FV N (years) interest rate $30,000 5 0.05 $40,000 8 0.15 $40,000 9 0.075 FV PV N (years) interest rate $3,000 4 0.1 $50,000 8 0.6 $20,000 14 0.75 PV FV N (years) interest rate $25,000 6 0.025 $35,000 12 0.03 $45,000 15 0.05 FV PV N (years) interest rate $1,800 10 0.08 $2,600 6 0.04 $3,500 8 0.06
Suppose that you deposit? $10,000 in an account that pays? 6% interest and you want to...
Suppose that you deposit? $10,000 in an account that pays? 6% interest and you want to know how much will be in your account at the end of 10 years. To solve this problem in Microsoft? Excel, you would use which of the following Excel? formulas? =FV?(.06,10,0,10000) B. ?=PV?(.06,10,0,10000) C. ?=PV?(.06,10000,0,10) D. ?=FV?(.06,10000,0,10)
Find QUARTERLY payment. Please show the formula as well: FV = 300,000 Rate = 8.4% compounded...
Find QUARTERLY payment. Please show the formula as well: FV = 300,000 Rate = 8.4% compounded MONTHLY PV = 0 Period = 20 years
Use the Future Value Function (FV) to determine the future value of the monthly investment. Amount...
Use the Future Value Function (FV) to determine the future value of the monthly investment. Amount invested monthly $300 Number of years invested 20 Interest rate earned 7.00% Future value of investement i need to do it with an excel formula
Find the future values of the following ordinary annuities. a. FV of $800 each 6 months...
Find the future values of the following ordinary annuities. a. FV of $800 each 6 months for 5 years at a nominal rate of 8%, compounded semiannually. Do not round intermediate calculations. Round your answer to the nearest cent. $ b. FV of $400 each 3 months for 5 years at a nominal rate of 8%, compounded quarterly. Do not round intermediate calculations. Round your answer to the nearest cent. $
Find the future values of the following ordinary annuities. FV of $400 each 6 months for...
Find the future values of the following ordinary annuities. FV of $400 each 6 months for 4 years at a nominal rate of 8%, compounded semiannually. FV of $200 each 3 months for 4 years at a nominal rate of 8%, compounded quarterly.
You've been offered an investment opportunity that will pay you $10,000 in three years. It is...
You've been offered an investment opportunity that will pay you $10,000 in three years. It is somewhat risky, so you would only take on this investment if you earned a 20% annual return with annual compounding. What is the most that you would pay for this investment today? · are you trying to find a PV or FV? · show your calculations using the formula · show your calculations using the keystrokes for your financial calculator (state which financial calculator...
You've been offered an investment opportunity that will pay you $10,000 in three years. It is...
You've been offered an investment opportunity that will pay you $10,000 in three years. It is somewhat risky, so you would only take on this investment if you earned a 20% annual return with annual compounding. What is the most that you would pay for this investment today? are you trying to find a PV or FV? show your calculations using the formula show your calculations using the keystrokes for your financial calculator (state which financial calculator you are using)...
A bond with a face value of $10,000 that matures in exactly seven years has a...
A bond with a face value of $10,000 that matures in exactly seven years has a price of $10,494.63. The coupon rate is 4.2% p.a. and coupons are paid every six months. Which of the following figures is the closest to the yield to maturity? (a) 4.2% p.a. (b) 5.40% p.a. (c) 3.40% p.a. (d) 1.70% p.a. Please do not use excel. Please show your detailed calculations using formulas. Please show formulas.
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
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT