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 _____________ ___________

Assume you just inherited $2,500 from a deceased relative and you choose to invest it to start saving for the down payment on a vehicle you plan to purchase 4 years from now. You are considering the following choices:   Your credit union offers a certificate paying 2% simple interest; a local bank is offering a certificate paying 1.95% compounded quarterly; and a reputable investment firm is offering a certificate paying 1.90% compounded monthly.   Ignoring for now taxes and other special considerations, carefully evaluate your opportunities. Choose an investment and defend your choice. (solve each using algebra formulas, then check with spreadsheet function and include in the spreadsheet you submit for this assignment.)

Credit Union:

Bank:

Investment firm:

Your Conclusion:

Solutions

Expert Solution

1.

2.

Your Conclusion: Bank is Offering higher value for the investment. Thus Deposit in Bank is recommended

Please comment if you face any difficulty and please dont forget to upvote


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
ADVERTISEMENT
ADVERTISEMENT