Question

In: Finance

Calculate the future value of a $4,000 CD earning 5.2% interest for 8 years under the...

Calculate the future value of a $4,000 CD earning 5.2% interest for 8 years under the following scenarios (use a calculator for the algebraic formula answer, check using the =FV function). (in Excel use =FV(i,n,0,(PV),0). Make PV negative because it is a cash out-flow.   (Use the EXP function for the continuous compounding problem.) Show what Algebraic Formula you use. Submit a screenshot of this sheet filled out with the algebraic calculations, and submit your excel spreadsheet with an identifiable name to the class canvas website.

                                                            Algebraic Formula Answer                Spreadsheet

A. Compounded yearly:                                 _____________                      ___________

B. Compounded twice a year                         _____________                      ___________

C. Compounded quarterly:                             _____________                      ___________

D. Compounded monthly                               _____________                      ___________

E. Compounded continuously                        _____________                      ___________

Solutions

Expert Solution

Algebraic formula

Future value = Initial amount*(1+Annual interest rate/Compoundings per year)^(Compoundings per year*Number of years)

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Calculate the future value of a $4,000 CD earning 5.2% interest for 8 years under the...
Calculate the future value of a $4,000 CD earning 5.2% interest for 8 years under the following scenarios (use a calculator for the algebraic formula answer, check using the =FV function). (in Excel use =FV(i,n,0,(PV),0). Make PV negative because it is a cash out-flow. (Use the EXP function for the continuous compounding problem.) Show what Algebraic Formula you use. Submit a screenshot of this sheet filled out with the algebraic calculations, and submit your excel spreadsheet with an identifiable name...
You just received a bonus of $4,000. a. Calculate the future value of $4,000​ given that...
You just received a bonus of $4,000. a. Calculate the future value of $4,000​ given that it will be held in the bank for 5 years and earn an annual interest rate of 7 percent. b. Recalculate part (a​) using a compounding period that is​ (1) semiannual and​ (2) bimonthly. c. Recalculate parts (a​) and (b​) using an annual interest rate of 14 percent. d. Recalculate part (a​) using a time horizon of 10 years at an annual interest rate...
Calculate the future value of $ 9,000 in a. 5 years at an interest rate of...
Calculate the future value of $ 9,000 in a. 5 years at an interest rate of 5 % per year. b. 10 years at an interest rate of 5 % per year. c. 5 years at an interest rate of 10 % per year. d. Why is the amount of interest earned in part ​(a​) less than half the amount of interest earned in part ​(b​)?
You deposit $500 in an account earning 8% compound interest for 3 years. Find the future...
You deposit $500 in an account earning 8% compound interest for 3 years. Find the future value and the interest earned for each of the following compounding frequencies. Frequency Future Value Interest Earned Annually Semiannually Quarterly Monthly Daily
Calculate the future value in six years of $4,000 received today if your investments pay (Do...
Calculate the future value in six years of $4,000 received today if your investments pay (Do not round intermediate calculations, and round answers to 2 decimal places please) A). 6 percent compounded annually B). 8 percent compounded annually C). 10 percent compounded annually D). 10 percent compounded semiannually E). 10 percent compounded quarterly
Calculate the future value of $9,000 in a. four years at an interest rate of 10%...
Calculate the future value of $9,000 in a. four years at an interest rate of 10% per year. b. eight years at an interest rate of 10% per year. c. four years at an interest rate 20% of per year. d. Why is the amount of interest earned in part ​(a​) less than half the amount of interest earned in part ​(b​)?
Calculate the future value of $6,000 in a. 5 years at an interest rate of 10%...
Calculate the future value of $6,000 in a. 5 years at an interest rate of 10% per year (round to the nearest dollar) b. 10 years at an interest rate of 10% per year (round to the nearest dollar) c. 5 years at an interest rate of 20% per year (round to the nearest dollar) d. Why is the amount of interest earned in part (a) less than half the amount of interest earned in part (b)? (choose from the...
What is the future value of $12,857 in 10 years assuming an interest rate of 8...
What is the future value of $12,857 in 10 years assuming an interest rate of 8 percent compounded monthly? Maybepay Life Insurance Co. is selling a perpetual contract that pays $5,849/year. The contract currently sells for $154,173. What is the rate of return on this investment? Enter answer with 4 decimals (e.g. 0.1234).
Calculate the future value of$3,000 in a.Four years at an interest rate of 5 % per...
Calculate the future value of$3,000 in a.Four years at an interest rate of 5 % per year. b.Eight years at an interest rate of 5% per year. c. Four years at an interest rate of 10% per year. d. Why is the amount of interest earned in part ​(a​) less than half the amount of interest earned in part ​(b​)?
B-7. Calculate the future value of $4,000 per year investment (ordinary annuity) ten years from now...
B-7. Calculate the future value of $4,000 per year investment (ordinary annuity) ten years from now if the annual rate of return is: (2 pts each) a. 4% b. 6%c. 10% B-7a. Explain why are results for C is greater than B is greater than A B-8. Calculate the future value of $4,000 per year investment (ordinary annuity) twenty years from now if the annual rate of return is: a. 4% b. 6%c. 10% B-9. Explain why are all of...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT