Question: Using Formulas you have learned, find the future value of the account for interest compounded anually, semi annually, quarterly, monthly, weekly, daily, and continuously. Suppose
Suppose that you have $1,000 to invest in a ten-year CD that earns 4%. Using the formulas you have learned, find the future value of the account for interest compounded annually, semiannually, quarterly, monthly, weekly, daily, and continuously. Start by constructing this table in Excel: In order to compute these different periods, use the corresponding number (i.e., 1, 2, 4, etc.) Term Principal Interest Rate $1,000 0.04 Future Value Make sure to use a formula to compute, such as 0.04 Number of times compounded/per year annually semiannually quarterly monthly weekly daily continuously $1,000 $1,000 $1,000 $1,000 $1,000 wa1*(1 +b1/c1}^(ci*d1) 0.04 0.04 0.04 0.04 0.04
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
