Use the PV function in Excel to calculate what you would have to invest in a...
Homework Answers
To access the PV function in excel, go to formulas, financial and select PV function.
Amount to be invested today in the savings account
$ 1040
Add Answer to:
Use the PV function in Excel to calculate what you would have
to invest in a...
If you invest $2,500 today, $3,600 in 2 years, $4,500 in 5 years, and $1,600 in...
If you invest $2,500 today, $3,600 in 2 years, $4,500 in 5 years, and $1,600 in 7 years, how much will be in the bank 15 years from today if interest is 8.5% compounded annually? 2. Charlie hopes to accumulate $83,000 in a savings account in 10 years. If he wishes to make a single deposit today and the bank pays 3 percent compounded annually on deposits of this size, how much should Charlie deposit in the account? 3. If...
Show the excel formulas used Ex. 1 You have $5,000 in your savings account that pays...
Show the excel formulas used
Ex. 1 You have $5,000 in your savings account that pays 4% interest. How much will you have in your account after 20 years, a) if your bank pays annually compounded interest? b) if your bank pays monthly compounded interest? c) if your bank pays daily compounded interest? Current balance Interest Years Compounding Annually Monthly Daily a) FV b) FV c) FV Ex. 2 If you need $10,000 in 7 years and you can earn...
Show the excel formulas used and answer all questions Ex. 1 You have $5,000 in your...
Show the excel formulas used and answer all questions
Ex. 1 You have $5,000 in your savings account that pays 4% interest. How much will you have in your account after 20 years, a) if your bank pays annually compounded interest? b) if your bank pays monthly compounded interest? c) if your bank pays daily compounded interest? Current balance Interest Years Compounding Annually Monthly Daily a) FV b) FV c) FV Ex. 2 If you need $10,000 in 7 years...
A) Use Excel to calculate how much would accumulate in a savings account at the end...
A) Use Excel to calculate how much would accumulate in a savings account at the end of 5 years if the account paid 6% compound interest per year and you deposited $5,000 per year at the end of each year. explain how you calculated your answers. B) Use Excel to recalculate your answer assuming you deposited the $5,000 at the beginning of each year? explain how you calculated your answers
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 $180,000 Ferrari. If you believe your mutual fund can achieve an annual return of 10 percent, and you want to buy the car in 12 years, how much must you invest today? (6 Points) Calculate the present values in the table below using the PV Excel function. (6 Points) Future value Years Interest rate Present value $19,500...
1. You have $200 to invest. If you put the money into an account earning 4%...
1. You have $200 to invest. If you put the money into an account earning 4% interest compounded annually, how much money will you have in 10 years? How much money will you have in 10 years if the account pays 4% simple interest? 2. You have $1,300 to invest today at 5% interest compounded annually. a. Find how much you will have accumulated in the account at the end of (1) 6 years, (2) 12 years, and (3)...
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...
6 If you invest $6,000 today in a savings account at an interest rate of 4%...
6 If you invest $6,000 today in a savings account at an interest rate of 4% compounded anually, how much principal and interest would you accumulate in 10 years?
1. Shroug w rok wants to invest AED 800.000 in cash to buy a new car...
1. Shroug w rok wants to invest AED 800.000 in cash to buy a new car 4 years from today. She expects to cam 7 percent per year, compounded annually on her savings. How much should she get to meet this purpose? 2. What is the present value of AED 45.000 deposited for 6 years at 10 percent per annum interest compounded annually? 3. If you wish to accumulate AED 200,000 in 5 years, how much must you deposit today...
5. You have some savings you’d like to invest. You can invest it in a bank...
5. You have some savings you’d like to invest. You can invest it in a bank account paying fixed 5% compounded monthly. Your plan is to leave the principal but take out the interest at the end of every year to help cover expenses. If you wanted to be sure that your savings invested at the bank allowed you to take out $5,000 per year for as long as you wanted to, how much savings would you have to have?
Show the excel formulas used
Ex. 1 You have $5,000 in your savings account that pays 4% interest. How much will you have in your account after 20 years, a) if your bank pays annually compounded interest? b) if your bank pays monthly compounded interest? c) if your bank pays daily compounded interest? Current balance Interest Years Compounding Annually Monthly Daily a) FV b) FV c) FV Ex. 2 If you need $10,000 in 7 years and you can earn...
Show the excel formulas used and answer all questions
Ex. 1 You have $5,000 in your savings account that pays 4% interest. How much will you have in your account after 20 years, a) if your bank pays annually compounded interest? b) if your bank pays monthly compounded interest? c) if your bank pays daily compounded interest? Current balance Interest Years Compounding Annually Monthly Daily a) FV b) FV c) FV Ex. 2 If you need $10,000 in 7 years...
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...
6 If you invest $6,000 today in a savings account at an interest rate of 4% compounded anually, how much principal and interest would you accumulate in 10 years?
1. Shroug w rok wants to invest AED 800.000 in cash to buy a new car 4 years from today. She expects to cam 7 percent per year, compounded annually on her savings. How much should she get to meet this purpose? 2. What is the present value of AED 45.000 deposited for 6 years at 10 percent per annum interest compounded annually? 3. If you wish to accumulate AED 200,000 in 5 years, how much must you deposit today...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago