Find the Present Value of $2000 due in 10 years if the discount rate is 15%...
Find the Present Value of $2000 due in 10 years if the discount rate is 15% per year
| Inputs: | NPER | ||
| RATE | |||
| PMT | |||
| PV | ?? | ||
| FV | ** negative # | ||
| TYPE |
Homework Answers
here,
rate = discount rate = 15%
nper = number of periods = 10 (given in question)
pmt = payment = 0
fv = future value = 2000(we have to use negative sign)
so the present value = 494.37(rounded to two decimals)
we can ignore type
Add Answer to:
Find the Present Value of $2000 due in 10 years if the discount
rate is 15%...
Find the Future Value of $2,000 invested to earn 15% annually 10 years from today. Please...
Find the Future Value of $2,000 invested to earn 15% annually 10 years from today. Please fill out this table: INPUTS NPER RATE PMT PV (Negative #) FV TYPE ANSWER
What is the present value of $929 to be received in 13.5 years from today if...
What is the present value of $929 to be received
in 13.5 years from today if our discount rate is 3.5
percent?
PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A
PICTURE FOR AN EXAMPLE!
Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of each period only....
Analyze the following scenarlos that will require you to compute elther the present value, future value,...
Analyze the following scenarlos that will require you to compute elther the present value, future value, and/or the a payment amount. Indicate the inputs that you will use to perform your analyses in the spaces provided. Perform your calculation in the space provided for that amount. For example, if you need to compute that present value, present that calculation in the PV space. You recelved a surprise notification from an attorney that you are the beneficlary of a payout from...
An investment adviser has promised to double your money. If the interest rate is 7% a...
An investment adviser has promised to double your money. If the interest rate is 7% a year, how many years will she take to do so? We have entered the data vou need in cells H9 to HI1: Present value (PV) Future value (FV) Interest rate (r) 1 2 0,06 You can use the present value formula to value an annuity You can either find the answer by taking logs of the present value formula or you can use Excel's...
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer...
a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and also by using the Excel function wizard. Inputs: PV = 1000 I/YR = 10% N = 5 Formula: FV = PV(1+I)^N = Wizard (FV): $1,610.51 Note: When you use the wizard and fill in the menu items, the result is the formula you see on the formula line if you click on cell E12. Put the...
You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
1. What is the Present Value of a $1,000 payment due in 10 years with a...
1. What is the Present Value of a $1,000 payment due in 10 years with a stated annual rate of return of 8%? 2. What is the Future Value of $1,000 in 6 years, assuming an annual rate of return of 5%? Help: FV = PV (1 + i)^n PV = FV x 1/(1 + i) n
What is the present value of $1,250 due in 10 years at a 8% discount rate?
What is the present value of $1,250 due in 10 years at a 8% discount rate?
If you bought a stock for $53 dollars and could sell it 16 years later for...
If
you bought a stock for $53 dollars and could sell it 16 years later
for three times what you originally paid. What was your return on
owning this stock?
PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A
PICTURE FOR AN EXAMPLE!
Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is...
What is the present value of $929 to be received
in 13.5 years from today if our discount rate is 3.5
percent?
PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A
PICTURE FOR AN EXAMPLE!
Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of each period only....
Analyze the following scenarlos that will require you to compute elther the present value, future value, and/or the a payment amount. Indicate the inputs that you will use to perform your analyses in the spaces provided. Perform your calculation in the space provided for that amount. For example, if you need to compute that present value, present that calculation in the PV space. You recelved a surprise notification from an attorney that you are the beneficlary of a payout from...
An investment adviser has promised to double your money. If the interest rate is 7% a year, how many years will she take to do so? We have entered the data vou need in cells H9 to HI1: Present value (PV) Future value (FV) Interest rate (r) 1 2 0,06 You can use the present value formula to value an annuity You can either find the answer by taking logs of the present value formula or you can use Excel's...
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
1. What is the Present Value of a $1,000 payment due in 10 years with a stated annual rate of return of 8%? 2. What is the Future Value of $1,000 in 6 years, assuming an annual rate of return of 5%? Help: FV = PV (1 + i)^n PV = FV x 1/(1 + i) n
If
you bought a stock for $53 dollars and could sell it 16 years later
for three times what you originally paid. What was your return on
owning this stock?
PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A
PICTURE FOR AN EXAMPLE!
Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is...
Most questions answered within 3 hours.
-
For the following reaction, 0.128 moles of
potassium hydrogen sulfateare mixed with
0.504 moles of potassium...
asked 2 hours ago -
1. What is the present value of $400, three years in the future
if the interest...
asked 3 hours ago -
The labor force minus the number of employed equals the number
of unemployed.
a. True
b....
asked 5 hours ago -
Determine the mass in units of grams​ [g] of 0.49 moles​ [mol]
of a new fictitious...
asked 5 hours ago -
A horizontal mass of M=5kg is on a spring and stretched to
x=0.5m when released from...
asked 7 hours ago -
26 of 50
"I have worked at the Arizona Humane Society for ten years, and
have...
asked 7 hours ago -
Compare and contrast zero based budgeting and incremental (or
base year) budgeting.
asked 7 hours ago -
4 pts 10. Which of the following hypothesis would be MOST
difficult to test experimentally? Group...
asked 7 hours ago -
A business owner makes 1,000 items a day. Each day he or she
contributes eight hours...
asked 7 hours ago -
A
circular loop in the plane of a paper lies inca0.65 T magnetic
field pointing into...
asked 7 hours ago -
A business owner is trying to decide whether to buy, rent, or
lease office space and...
asked 7 hours ago -
Thermal Storage Solar heating of a house is much more efficient
if there is a way...
asked 7 hours ago