Question

Problem 1: What will a deposit of $500 at 7% annual interest be worth if left in the bank for ten years? Problem 2: How much must you deposit at the end of each year in an account that pays an annual interest rate of 20 percent, if at the end of 5 years you want S10,000 in the account? Problem 3: If you invest $2,500 in a bank account that pays 6% interest compounded monthly, how much will you have in your account in one year?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

AS ASKED BY YOU, BOTH METHODS DONE : EXCEL AND FORMULAS

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text General aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard NY112 NW Font Alignment Number Styles Cells NX NY NZ OA OB OC OD OE OF OG OH Ol 94 95 96 97 98 PV*(1+r)An 5500 (1+0.07)A10 FV= FUTURE VALUE FORMULA 10819.33 FVAA/r ((1+r)An- 1) 10000- A/0.20* ((1+0.20)A5-1) 10000A/0.20+ (1.48832) 100 101 102 103 104 105 106 107 108 109 110 FUTURE VALUE ANNUITY FORMULA 1343.80 V (1+r/m)Anm FV2500*(1+0.06/12)A(1 12) 2654.19 FUTURE VALUE FORMULA FV = 112 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity 1 CAP STRU VALUE BOX DILUTIONDOLLAR COST AVG MORTGAGE EXPO SheetiSheet Sh rences: x261 07:40 04-01-2019

Add a comment
Know the answer?
Add Answer to:
Problem 1: What will a deposit of $500 at 7% annual interest be worth if left...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. What is the formula to calculate how much a savings account would be worth if...

    1. What is the formula to calculate how much a savings account would be worth if the initial balance is $1000 with monthly deposits of $75 for 10 years at 4.3 percent annual interest compounded monthly? What is the formula result? 2.  You want a savings account to grow from $1,000 to $5,000 within two years. Assume the bank provides a 3.2 percent annual interest rate compounded monthly. What is the formula to calculate how much you must deposit each month...

  • 1. You are going to deposit $3,400 in an account that pays .40 percent interest compounded...

    1. You are going to deposit $3,400 in an account that pays .40 percent interest compounded monthly. How much will you have in 5 years? a. $4,320.18 b. $4,337.46 c. $4,298.19 d. $4,324.50 e. $4,302.97 2. Your bank will pay you an interest rate of .102 percent per week. You want to have $22,500 in 10 years. How much will you have to deposit today? Assume 52 weeks per year. a. $13,418.45 b. $13,419.42 c. $13,536.16 d. $21,338.27 e. $13,241.89...

  • I need help on question 7. Time Value of Money Exercise: Question 1: Assume you deposit...

    I need help on question 7. Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest...

  • Problem 1- Saving Money You want to deposit money into a bank account that pays 1.5%...

    Problem 1- Saving Money You want to deposit money into a bank account that pays 1.5% compounded monthly. Answer the following questions: f depositing $4000, how much is avaiable in the account at the end of S years? .How much do you have to deposit now in order to have $5000 available at the end of 5 years? Instead of depositing one sum of money at the beginning of the 5-year period, suppose you wish to make monthly payments. How...

  • Problem 1: If you deposit $4000 into an account paying 6% annual interest compounded quarterly, howmuch...

    Problem 1: If you deposit $4000 into an account paying 6% annual interest compounded quarterly, howmuch money will be in the account after 5 years? Problem 2: If you deposit $6500 into an account paying 8% annual interest compounded monthly, how much money will be in the account after 7 years?

  • You plan to invest an amount of money in five-year certificate of deposit (CD) at your...

    You plan to invest an amount of money in five-year certificate of deposit (CD) at your bank. The stated interest rate applied to the CD is 12 percent, compounded monthly. How much must you invest if you want the balance in the CD account to be $8,500 in five years? Please explain the formula.

  • 21. You are about to deposit $139 into one of the following saving accounts to be left on deposit for 25 years, each ban...

    21. You are about to deposit $139 into one of the following saving accounts to be left on deposit for 25 years, each bank offers an account with a different interest rate and compounding period. Assuming you want to maximize your wealth, how much money would be in the bank account that offers the best effective rate of return after 25 years? Bank A. 9.5 percent rate compounded semi annually Bank B. 9.4 percent rate compounded monthly Bank C. 9.3...

  • I need help on question 3. Time Value of Money Exercise: Question 1: Assume you deposit...

    I need help on question 3. Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest...

  • I need help on question 8. Time Value of Money Exercise: Question 1: Assume you deposit...

    I need help on question 8. Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest...

  • I need help on question 10. Time Value of Money Exercise: Question 1: Assume you deposit...

    I need help on question 10. Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT