Question

Suppose you obtain a $3,000 Certificate of Deposit (CD) with a 3% annual rate, paid quarterly,...

Suppose you obtain a $3,000 Certificate of Deposit (CD) with a 3% annual rate, paid quarterly, with maturity in 5 years.

a. What is the future value of the CD in 5 years?
b. How much interest will you earn?
c. What percent of the balance is interest?

Please show work, if possible in excel showing formulas used

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

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
1. You currently have AED40,000 and plans to purchase a 5-year certificate of deposit (CD). a....
1. You currently have AED40,000 and plans to purchase a 5-year certificate of deposit (CD). a. How much will you have when the CD matures if it pays 7% interest, compounded annually? b. How much will you have when the CD matures if it pays 6%, or 20% interest, compounded annually? c. How much will you have when the CD matures if it pays 6%, or 20% interest, compounded semiannually? d. Why does the annual compounding and semiannual compounding give...
You purchase a three year certificate of deposit (CD) for $100,000 on January 1st, 2000. This...
You purchase a three year certificate of deposit (CD) for $100,000 on January 1st, 2000. This CD has an annual interest rate of 5%. The interest compounds continuously. What is the balance for the CD account on July 1, 2001? $105,000 $107,500 $107,593 $110,250
Bank A offers a 2-year certificate of deposit (CD) that pays 10 percent compounded annually. Bank...
Bank A offers a 2-year certificate of deposit (CD) that pays 10 percent compounded annually. Bank B offers a 2-year CD that is compounded semi-annually. The CDs have identical risk. What is the stated, or nominal, rate that Bank B would have to offer to make you indifferent between the two investments? show work on excel*
If you purchased a $10,000 certificate of deposit today with an APR of 12% with monthly...
If you purchased a $10,000 certificate of deposit today with an APR of 12% with monthly compounding, what would the CD be worth when it matures in six years? must show work/calculation
Find the future value of a $18,000 Certificate of Deposit that pays compounded interest every three...
Find the future value of a $18,000 Certificate of Deposit that pays compounded interest every three months at the rate of 6% per year. The CD has a term of 4 years. a) Calculate the FV (Future Value) using the “Future Value or Compound Amount of $1.00” table in your textbook. Reminder: To use Table 13-1, you need to calculate the Number of Periods and the Interest Rate per Period. b)Calculate the FV (Future Value) using the formula: FV =...
Merser company plans on eight annual concerts. The concerts would raise funds for an endowment of...
Merser company plans on eight annual concerts. The concerts would raise funds for an endowment of $32,000,000 per year into perpetuity. The endowment will be finalized at the end of the eighth year. The rate of interest is expected to be 4.25 percent p.a. in all future periods. How much must the company earn and deposit in each of the next eight years to accumulate the required amount? please show all work in excel (formulas)
Please show work and formulas: A: You deposit $100 for the next 15 years earning 10%...
Please show work and formulas: A: You deposit $100 for the next 15 years earning 10% per year. What would your balance be at the end of the 15 Years? B: You borrow $100,000 for 18 years at an annual rate of 7%. What would be your fixed QUARTERLY loan payment? C: For the loan in #5 above, what percent of your first payment would apply to the principal?
3. Calculate the compounded interest payment for each year for a total of 5 years. You...
3. Calculate the compounded interest payment for each year for a total of 5 years. You will fill in the row for Interest Payment Distributed for each year, the Ending Balance and the Total Interest You should have a separate amount for each month. I would recommend doing this in Excel. Make sure you show your work. Deposit- $3,000 Annual Interest Rate: 7% Maturity Principal Balance Interest Payment- Distributed 1 year $3,000 2 year $3,000 3 year 4 year 5...
PART 2: FINANCE a) If you deposit $23,596.00 at 13.23% annual interest compounded quarterly, how much...
PART 2: FINANCE a) If you deposit $23,596.00 at 13.23% annual interest compounded quarterly, how much money will be in the account after 4 years? b) If you deposit $1036.00 into an account paying 5.46% annual interest compounded monthly, how many years until there is $19,912.00 in the account? c) What is the value today of receiving a single payment of $55,961.00 13 years if your required rate of return on this investment is 14.25% compounded semi-annually? d) If you...
Gordon invested $43,000 into a CD compounded quarterly with an annual interest rate of 3.05%. Determine...
Gordon invested $43,000 into a CD compounded quarterly with an annual interest rate of 3.05%. Determine how much money Gordon would have after 8 years. Round your answer to the nearest cent. Provide only a numerical answer (For example, if the final amount came to $5,023.97, then you would input 5023.97).