Question

In: Accounting

Future Value Computation Kate Company deposited $12,000 in the bank today, earning eight percent interest. Kate...

Future Value Computation Kate Company deposited $12,000 in the bank today, earning eight percent interest. Kate plans to withdraw the money in five years. How much money will be available to withdraw assuming that interest is compounded (a) annually, (b) semiannually, and (c) quarterly? Use Excel or a financial calculator for computation. Round answers to the nearest dollar.

(a) Annually...... Answer 0

(b) Semiannually....... Answer 0

(c) Quarterly....... Answer 0

Solutions

Expert Solution

Present Value = $12000

Interest Rate = 8% = 8 / 100 = 0.08

Term = 5 years

(a)

Future Value = Present Value X (1 + Rate) ^n

Number of terms if compounded annually = 5

Therefore, Future value if compounded annually = 12000 X (1 + 0.08) ^5 = 12000 X (1.08) ^5 = 12000 X 1.469328 = $17,631.94 = $17,632.

(b)

Future Value = Present Value X (1 + Rate) ^n

Number of terms if compounded semi-annually = 5 X 2 = 10

Interest Rate if semi-annual = 8% / 2 = 4% = 4 / 100 = 0.04

Therefore, Future value if compounded semi-annually = 12000 X (1 + 0.04) ^10 = 12000 X (1.04) ^10 = 12000 X 1.480244 = $17,762.93 = $17,763.

(c)

Future Value = Present Value X (1 + Rate) ^n

Number of terms if compounded quarterly = 5 X 4 = 20

Interest Rate if quarterly = 8% / 4 = 2% = 2 / 100 = 0.02

Therefore, Future value if compounded quarterly = 12000 X (1 + 0.02) ^20 = 12000 X (1.02) ^20 = 12000 X 1.485947 = $17,831.37 = $17,831.


Related Solutions

Compound Interest 8.) The amount of P 20,000 was deposited in a bank earning an interest...
Compound Interest 8.) The amount of P 20,000 was deposited in a bank earning an interest of 6.5% per annum. Determine the total amount at the end of 17 years if the principal and interest were not withdrawn during this period. 9.) The amount of P 150,000 was deposited in the bank earning ang interest of 7.5% per annum. Determine the total amount at the end of 16 years, if the principal and interest were not withdrawn during the period....
the future value of $676 received today and deposited 5.85 percent compounded annually for five years...
the future value of $676 received today and deposited 5.85 percent compounded annually for five years is closest to
$1770 is deposited today into an account earning a force of interest of 0.03. How long...
$1770 is deposited today into an account earning a force of interest of 0.03. How long will it take for the account to reach $2770 if time t is measured in years?
4. $10,000 is deposited in a savings account earning 1.75% simple interest. What is the future...
4. $10,000 is deposited in a savings account earning 1.75% simple interest. What is the future value (nearest penny) of the $10,000 after 5 years? What is the future value after 5 years if the same account earns 1.75% interest compounded annually?   You borrow $2000 on March 20 at 15% simple interest.   a. How much interest (to the nearest penny) accrues by September 20 (180 days later). Assume ordinary interest.   b. What is the total amount that you must repay?...
What lump some of money deposited today will grow to a future value of $9,280 at...
What lump some of money deposited today will grow to a future value of $9,280 at 9 3/4% compounded monthly for 2 1/2 years? Please show work.
A principal amount P0 is deposited in a bank account earning 3% interest compounded monthly. After...
A principal amount P0 is deposited in a bank account earning 3% interest compounded monthly. After 20 years there is $1000 in the account. What was the principal P0? Suppose you want to buy a house for $300, 000, but you only have $100,000. You are able to make an investment that pays 7.3% annual interest. If the interest is compounded continuously, how long will it take before you can buy your new house? You are made an offer. You...
what is the future value of 1000 deposited for 5 years, if the interest rate is...
what is the future value of 1000 deposited for 5 years, if the interest rate is 10% per annuam compounded, daily, annually, monthly, contuously, weekly, weekly.
If $12,000 is invested at 2.5% for 20 years, find the future value if the interest...
If $12,000 is invested at 2.5% for 20 years, find the future value if the interest is compounded the following ways. (Round your answers to the nearest cent.) (a) annually $   (b) semiannually $   (c) quarterly $   (d) monthly $   (e) daily (N = 360) $   (f) every minute (N = 525,600) $   (g) continuously $   (h) simple (not compounded) $
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT