Homework Answers
Add Answer to:
1.
If we place $7,654 in a savings account paying 7.5 percent interest
compounded annually, how...
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....
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...
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,...
17. Which formula in B5 will allow you to determine how many years it will take...
17. Which formula in B5 will allow you to determine how many years it will take to quadruple your savings at 11% compounded quarterly? a)NPER(B3/B4,0.-BI,B2)/B4 b) NPER(B3/B4,0-B1,B2) c)NPER(B3 B4,0-BI,B2/B4 d)NPER(B3/B4,0-B2,B1) B4 Present Value 2 Future Value 3 Interest Rate 4 Compounding Frequency 5 Number of Years s 3,000 12,000 11% 18. What solution would you get in cell B36? 3s Variable 4 Variable2 35 Variable 3 36 a) 3.333333 b) 1462.96 c) 123.703 d) -2453.85 e) 7606629.6 833 834-835 833/834...
You have a savings account that earns 5% Interest, compounded annually. A friend has offered you...
You have a savings account that earns 5% Interest, compounded annually. A friend has offered you an investment opportunity, he says that if you invest In his new business, he will pay you $34,000 a year for the next five years. What is the maximum amount you would be willing to invest in your friend's business? (Future Value of $1. Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1.) (Use appropriate factor from the PV...
please help Sophia invested $13,480 into an account that earns 3.34% interest compounded monthly. How long...
please help
Sophia invested $13,480 into an account that earns 3.34% interest compounded monthly. How long will it take (in years and days) to accumulate to $19,750. Round up the value of N to the next higher whole number (e.g. N = 5.31 rounds up to N = 6), similarly days are rounded up to the next days. If years is a whole number, you must enter a zero for days for the answer to be marked as correct. All...
6. If $40,000 is put in a savings account paying interest of4% compounded annually, what amount...
6. If $40,000 is put in a savings account paying interest of4% compounded annually, what amount will be in the account at the end of 5 years? A) $48,666 B) $32,878 C) $48,000 D) $48,620 7. Suzy Douglas has been offered the opportunity of investing $73,540 now. The investment will earn 8% How many years must Suzy wait to receive the $200,000? A) 13 B) 10 C) 11 D) 12 per year and at the end of its life will...
Project: Assume that you are 18 years old and you would like to have $10000001000000 in...
Project:
Assume that you are 18 years old and you would like to have
$10000001000000 in your account by the time you are 6060 years old.
A list of various savings accounts was compiled in your Excel file.
Calculate the required initial (present value) deposit to the
savings accounts based on the interest rates in column
C compounded based on the values in column
D. Choose the savings account id (column
A) that requires the minimum initial investment. When you...
Bob deposited $409274 into an account paying 2% interest compounded annually with the goal of letting...
Bob deposited $409274 into an account paying 2% interest compounded annually with the goal of letting the money accrue interest until the end of year 34. Unfortunately, Bob had a small health crisis at the end of year 8 and had to use the money in the account for several years to help with expenses. Bob made an annual withdrawal of $30128 at the end of each year for 4 years. Bob's health improved and he was able to let...
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...
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....
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...
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,...
17. Which formula in B5 will allow you to determine how many years it will take to quadruple your savings at 11% compounded quarterly? a)NPER(B3/B4,0.-BI,B2)/B4 b) NPER(B3/B4,0-B1,B2) c)NPER(B3 B4,0-BI,B2/B4 d)NPER(B3/B4,0-B2,B1) B4 Present Value 2 Future Value 3 Interest Rate 4 Compounding Frequency 5 Number of Years s 3,000 12,000 11% 18. What solution would you get in cell B36? 3s Variable 4 Variable2 35 Variable 3 36 a) 3.333333 b) 1462.96 c) 123.703 d) -2453.85 e) 7606629.6 833 834-835 833/834...
You have a savings account that earns 5% Interest, compounded annually. A friend has offered you an investment opportunity, he says that if you invest In his new business, he will pay you $34,000 a year for the next five years. What is the maximum amount you would be willing to invest in your friend's business? (Future Value of $1. Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1.) (Use appropriate factor from the PV...
please help
Sophia invested $13,480 into an account that earns 3.34% interest compounded monthly. How long will it take (in years and days) to accumulate to $19,750. Round up the value of N to the next higher whole number (e.g. N = 5.31 rounds up to N = 6), similarly days are rounded up to the next days. If years is a whole number, you must enter a zero for days for the answer to be marked as correct. All...
6. If $40,000 is put in a savings account paying interest of4% compounded annually, what amount will be in the account at the end of 5 years? A) $48,666 B) $32,878 C) $48,000 D) $48,620 7. Suzy Douglas has been offered the opportunity of investing $73,540 now. The investment will earn 8% How many years must Suzy wait to receive the $200,000? A) 13 B) 10 C) 11 D) 12 per year and at the end of its life will...
Project:
Assume that you are 18 years old and you would like to have
$10000001000000 in your account by the time you are 6060 years old.
A list of various savings accounts was compiled in your Excel file.
Calculate the required initial (present value) deposit to the
savings accounts based on the interest rates in column
C compounded based on the values in column
D. Choose the savings account id (column
A) that requires the minimum initial investment. When you...
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...
Most questions answered within 3 hours.
-
Create a balanced compensation plan that you feel would
encourage a restaurant manager to be more...
asked 27 seconds ago -
Re: Human Physiology
Comment on the differences between representing V02 max as an
absolute number and...
asked 3 minutes ago -
A firm with a WACC of 10% is considering the following mutually
exclusive projects:
0
1...
asked 7 minutes ago -
. A 100.0 mL sample of 0.18 M HClO4 is titrated with 0.27 M
LiOH. Determine...
asked 30 minutes ago -
A regression equation that describes the relationship between
the amount of the bill ($) at a...
asked 1 hour ago -
exercise on VSEPR and molecular structrue.
octahedral
SeCl62-
TeCl62-
ClF62-
distorted
SeF62–
IF6–
asked 1 hour ago -
284 mL of a 0.52 M potassium hydroxide solution is added to 467
mL of a...
asked 1 hour ago -
Little’s Law: Val d’Costa is a world famous ski village in the
French Alps. Because of...
asked 2 hours ago -
Find the absolute error D for the calculation if A + B/C=D A=
9.4 +/- 0.4...
asked 3 hours ago -
New Air Heating and Cooling, manufactures furnaces and central
air units. The company pride itself on...
asked 3 hours ago -
A coach uses a new technique to train gymnasts. Seven
gymnasts were randomly selected and their...
asked 5 hours ago -
While rotating the tires on your car you notice a rock [mass =
0.1 Kg] stuck...
asked 7 hours ago