ZuoTi.Pro
Question
show work on excel
show steps on excel

Exercise 3.4. How much should you deposit into an account that pays 4% interest compounded semi-annually so that you end up w
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Given - rate of interest(o) = 4% semi annualy total time(t) = 10 years amount paid after 10 years(P) = $30,000 | We know compplease rate it if you find it helpful . Thank you

For any doubt use comment section

0 0
Add a comment
Know the answer?
Add Answer to:
show work on excel show steps on excel Exercise 3.4. How much should you deposit into...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • How much interest is earned in an account by the end of 5 years if $30,000...

    How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? What is the balance in an account at the end of 10 years if $6,500 is deposited today and the account earns 3% interest compounded annually? If you wish to accumulate $50,000 in 10 years, how much must you deposit today in an account that pays annual interest rate of 8%, with semi-annual compounding...

  • Answer in Excel If I deposit $8,000 in a bank account that pays interest of 1.5%,...

    Answer in Excel If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest of 1.5%, how much will I have in the account after 10 years? How would you explain the difference in the answers to the foregoing two problems, given that both banks pay interest at the same rate? Be specific....

  • Can the work be shown in excel using formulas? You deposit $10,000 in an account that...

    Can the work be shown in excel using formulas? You deposit $10,000 in an account that earns 5.5% compounded continuously and your friend deposits $10,000 in an account that earns 5.5% annually. a. How much more will you have in the account in 10 years? b. How much more interest did you earn in the 10 years?

  • You are planning to deposit $100 in an account earning 6% interest rate. a. How much...

    You are planning to deposit $100 in an account earning 6% interest rate. a. How much money do you have at the end of three years if interest is compounded annually? b. How much money do you have at the end of three years if interest is compounded semiannually? c. How much money do you have at the end of three years if interest is compounded quarterly? d. How much money do you have at the end of three years...

  • How much should you deposit at the end of each month into an investment account that...

    How much should you deposit at the end of each month into an investment account that pays 6% compounded monthly to have $3 million when you retire in 40 years? How much of the $3 million comes from​ interest? In order to have $3 million in 40 years, you should deposit how much each month? ___ round to the nearest dollar. $___ of the $3 million comes from interest. use the answer from part a to find this answer round...

  • You deposit $1,000 at the end of the year (k = 0) into an account that...

    You deposit $1,000 at the end of the year (k = 0) into an account that pays interest at a rate of 6% compounded annually. Two years after your deposit, the savings account interest rate changes to 12% nominal interest compounded monthly. Five years after your deposit, the savings account again changes its interest rate, this time the interest rate becomes 8% nominal interest compounded quarterly. Eight years after your deposit, the saving account changes its rate once more to...

  •   2. How much interest is earned in an account by the end of 8 years...

      2. How much interest is earned in an account by the end of 8 years if $24,000 is deposited at the beginning of year 1 and interest is 4.4% per year, compounded semi-annually?   3. If you wish to accumulate $53,000 in 7 years, how much must you deposit today in an account that pays annual interest rate of 8%, with quarterly compounding of interest?   4. If you deposit $9,000 at the end of each year for 9...

  • please show all steps 4. A company deposits $20000 in a bank at the end of...

    please show all steps 4. A company deposits $20000 in a bank at the end of every year for 10 years, The company makes no subsequent payment for the next 8 years but withdraws $25000 at the end of 18 years. How much would be in the account at the end of 20 years? The bank pays 8% interest compounded annually. (ii) How much annual deposit should be made if your goal is to have $25,000 at the end of...

  • You deposit $3,000 at the end of the year (k = 0) into an account that pays interest at a rate of 7% compounded annually. A year after your deposit, the savings account interest rate changes to 1 2%...

    You deposit $3,000 at the end of the year (k = 0) into an account that pays interest at a rate of 7% compounded annually. A year after your deposit, the savings account interest rate changes to 1 2% nominal interest compounded month y Five years after ur de o the savings account aga changes it interest rate this time e interest rate becomes 8% nominal interest compounded quarterly. Eight years after your deposit, the saving account changes its rate...

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