Question

In: Finance

Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the...

Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the end of each payment period. The interest rate and the payment period information are given in the following table. How much will the company have after 5 years in the bank account? Assume each year contains 52 weeks/365 days, each quarter contains 13 weeks/90 days, each month contains 4 weeks/30 days.

$1500 will be paid... (PP)

Rate is 12 % per year with the compounding period below (CP)

Future Value At the end of year 5

5

Yearly

Daily (365 days/year)

6

Yearly

Continuously

Yearly

Quarterly

7

Simi Annually

Yearly

8

Simi Annually

Simi Annually

Simi Annually

Quarterly

9

Simi Annually

Monthly

10

Simi Annually

Weekly

11

Simi Annually

Daily

12

Simi Annually

Continuously

13

Quarterly

Yearly

Solutions

Expert Solution

The final solution is as shown below:

formula sheet used in excel is as shown below:

Output of the above formula implementation is as shown below:

jeff jeffy answered 3 months ago
Next > < Previous

Related Solutions

Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the...
Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the end of each payment period. The interest rate and the payment period information are given in the following table.How much will the company have after 5 years in the bank account? Assume each year contains 52 weeks/365 days, each quarter contains 13 weeks/90 days, each month contains 4 weeks/30 days. $1500 will be paid... (PP) Rate is 12 % per year with the compounding...
A company wishes to deposit $5000 in the bank today and to make ten additional deposits...
A company wishes to deposit $5000 in the bank today and to make ten additional deposits every six months beginning six months from now, the first of which will be $5000 and increasing $1000 per deposit after that. Immediately after making the last deposit, the company decides to withdraw all the money deposited. If the bank pays 12% nominal interest compounded semi-annually, how much money will the company receive?
Nemo deposits $7500 now, $5000 three years from now, and $1500 six years from now into...
Nemo deposits $7500 now, $5000 three years from now, and $1500 six years from now into a fund paying 8% compounded quarterly: What equal deposit of size A, made every 3 months (with the first deposit at t=0 and last deposit at the end of the 7th year) are equal to the 3 deposits?
A students deposits 1500 pesos in a 9% compounded semi-annuallyaccount today.He intends to deposit another...
A students deposits 1500 pesos in a 9% compounded semi-annually account today.He intends to deposit another 3000 pesos at the end of two years. He plans to purchase in five years his favorite shoes worth 5000 pesos. calculate the money that will be left in his account one year after the purchase
Suppose you deposit $1500 cash into your checking account. By how much will checking deposits in...
Suppose you deposit $1500 cash into your checking account. By how much will checking deposits in the banking system increase as a result when the required reserve ratio is 0.50?
decided to invest in the Bank of America in a $ 10,000 certificate of deposit for...
decided to invest in the Bank of America in a $ 10,000 certificate of deposit for 5 years that pays an interest rate of 3.5% annually (simple interest). Suppose that the interest payment is sent annually to your home by check and that this money is taxable. When the certificate matures, he will receive his $ 10,000 back (non-taxable amount). Wesley's marginal tax rate is 24% and headline inflation is expected to be 2% per year. Determine for this investment...
The Bank Statement Balance is $10,000. The Book Balance is $12,000. The is a Deposit in...
The Bank Statement Balance is $10,000. The Book Balance is $12,000. The is a Deposit in Transit of $2000. There is an Outstanding Check of $1000. There is an NSF Check from a customer of $1000. Based on this data, complete a bank reconciliation
Wesley decided to invest in the Bank of America in a $ 10,000 certificate of deposit...
Wesley decided to invest in the Bank of America in a $ 10,000 certificate of deposit for 5 years that pays an interest rate of 3.5% annually (simple interest). Suppose that the interest payment is sent annually to your home by check and that this money is taxable. When the certificate matures, he will receive his $ 10,000 back (non-taxable amount). Wesley's marginal tax rate is 24% and headline inflation is expected to be 2% per year. Determine for this...
A bank currently has $70,000 in deposits, $6,000 in cash in the vault, $12,000 on deposit...
A bank currently has $70,000 in deposits, $6,000 in cash in the vault, $12,000 on deposit with the Fed, and $7,000 in government securities. The required reserve ratio is 20 percent. Answer these questions: 1) What is the maximum amount the money supply can increase, assuming this bank is the only bank in the system that has excess reserves? 2) An individual deposits a $750,000 check into the bank. That individual had just converted foreign currency into dollars so the...
If Tony deposits $1,000 three years from now and then increases the deposit by $500 each...
If Tony deposits $1,000 three years from now and then increases the deposit by $500 each year through year 10, calculate the amount that will be in the account in year 10 at an interest rate of 10% per year.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT