In excel using the formulas, do the next questions: 1. If you save 10,000 at the...
In excel using the formulas, do the next questions:
1. If you save 10,000 at the end of every year for 8 years at 8%
interest - how much will you have at the end of that period?
2. If you start with 10,000 and save 3,000 every year for 10 years
at 7.5% interest - how much will you have at the end of that
period?
3. You deposit 8,000 and receive 8% annual interest (compounded
semi annually) for 5 years. What is the total at the end of that
period?
4. How much do you need to save annually at 7% to get to 200,000
after 20 years?
5. What is the required interest rate if you save 3,000 annually
for 15 years to get to 150,000?
Homework Answers
Add Answer to:
In excel using the formulas, do the next questions:
1. If you save 10,000 at the...
Can the work be shown in excel using formulas? You deposit $10,000 in an account that...
Can the work be shown in excel using formulas? You deposit $10,000 in an account that earns 5.5% compounded continuously and your friend deposits $10,000 in an account that earns 5.5% annually. a. How much more will you have in the account in 10 years? b. How much more interest did you earn in the 10 years?
ANSWERS ARE GIVEN, PLEASE GIVE EXCEL FORMULAS!!! Suppose you have the option to buy a parcel...
ANSWERS ARE GIVEN, PLEASE GIVE EXCEL FORMULAS!!! Suppose you have the option to buy a parcel of vacant land to build your first home. The option is for a 10-year period, and the purchase price is $105,000. You do not intend to exercise the option until the end of the 10th year, which means you have 10 years to accumulate the required $105,000 in cash to buy the land. Given you have access to a savings account that pays 3...
8.3-8.6. Using the Finance Formulas potage 2 of 21 15. Suppose you invest $5,000 in a...
8.3-8.6. Using the Finance Formulas potage 2 of 21 15. Suppose you invest $5,000 in a savings account that pays an annual interest rate of 4%. If the interest is compounded monthly, what is the balance in the account after 10 years? 16. You invest $5000 at 2.2% annual interest compounded quarterly. How much do you have after 5 years? 17. Against expert advice, you begin your retirement savings at age 40. You plan on retiring at age 65. How...
1. You would like to save $70 000 in 10 years. To accumulate this amount, you...
1. You would like to save $70 000 in 10 years. To accumulate this amount, you plan to make a regular deposit with an equal amount of cash into a saving account at the end of each year. This account will earn 6% p.a interest compounded annually. Your first payment will be made at the end of this year. a. How much must you deposit annually to accumulate this amount in 10 years? b. If you decide to make a...
1. You won $100 000 in a lottery and you want to set some of that...
1. You won $100 000 in a lottery and you want to set some of that sum aside for 10 years. After 10 years, you would like to receive $2400 at the end of every 3 months for 8 years. How much of your winnings must you set aside if interest is 5.5% compounded quarterly? 2. A sum of money is deposited at the end of every month for 10 years at 7.5% compounded monthly. After the last deposit, interest...
You are going to save money for your son’s education. You have decided to place $1,915...
You are going to save money for your son’s education. You have decided to place $1,915 every half year at the end of the period into a saving account earning 5.95 percent per year, compounded semi-annually for the next 11 years. How much money will be in the account at the end of that time period?
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...
You are going to save money for your son's education. You have decided to place $2,667...
You are going to save money for your son's education. You have decided to place $2,667 every half year at the end of the period into a saving account earning 8.58 percent per year, compounded semi-annually for the next 3 years. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
You are going to save money for your son’s education. You have decided to place $1,192...
You are going to save money for your son’s education. You have decided to place $1,192 every half year at the end of the period into a saving account earning 9.21 percent per year, compounded semi-annually for the next 9 years. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
1) Carlos has borrowed $8,000 for 8 years at 6% compounded semi-annually. He will repay interest...
1) Carlos has borrowed $8,000 for 8 years at 6% compounded semi-annually. He will repay interest every 6 months plus principal at maturity. He will also deposit X every 6 months into a sinking fund paying 5% compounded semi-annually to pay off the principal at maturity. a) Find X. Carlos goes bankrupt at the end of year 6, just after making his interest payment and sinking fund deposit. The bank confiscates the money in the sinking fund but gets no...
8.3-8.6. Using the Finance Formulas potage 2 of 21 15. Suppose you invest $5,000 in a savings account that pays an annual interest rate of 4%. If the interest is compounded monthly, what is the balance in the account after 10 years? 16. You invest $5000 at 2.2% annual interest compounded quarterly. How much do you have after 5 years? 17. Against expert advice, you begin your retirement savings at age 40. You plan on retiring at age 65. How...
1. You would like to save $70 000 in 10 years. To accumulate this amount, you plan to make a regular deposit with an equal amount of cash into a saving account at the end of each year. This account will earn 6% p.a interest compounded annually. Your first payment will be made at the end of this year. a. How much must you deposit annually to accumulate this amount in 10 years? b. If you decide to make a...
1. You won $100 000 in a lottery and you want to set some of that sum aside for 10 years. After 10 years, you would like to receive $2400 at the end of every 3 months for 8 years. How much of your winnings must you set aside if interest is 5.5% compounded quarterly? 2. A sum of money is deposited at the end of every month for 10 years at 7.5% compounded monthly. After the last deposit, interest...
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 are going to save money for your son's education. You have decided to place $2,667 every half year at the end of the period into a saving account earning 8.58 percent per year, compounded semi-annually for the next 3 years. How much money will be in the account at the end of that time period? Round the answer to two decimal places.
1) Carlos has borrowed $8,000 for 8 years at 6% compounded semi-annually. He will repay interest every 6 months plus principal at maturity. He will also deposit X every 6 months into a sinking fund paying 5% compounded semi-annually to pay off the principal at maturity. a) Find X. Carlos goes bankrupt at the end of year 6, just after making his interest payment and sinking fund deposit. The bank confiscates the money in the sinking fund but gets no...
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