Question: please do all the steps in excel 1. If you deposit $2,000 in an account that earns 5% per year what would be the balance

please do all the steps in excel

1. If you deposit $2,000 in an account that earns 5% per year what would be the balance in the account at the end of 5 years if interest compounds annually and monthly (two answers)? 2. Ten years ago, you put $200,000 into an interest-earning account. Today it is worth $375,500. What is the effective annual interest earned on the account? 3. The future value of a single deposit of $1,000 will be greater when this amount is compounded: (A) Annually (B) Semi-annually (C) Quarterly (D) Monthly

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

You have just turned 26 years of age and accepted your first job. However, you would like to retire at 58 years of age. Having paid attention in your business courses, you have calculated that you...

Your employer has agreed to place year-end deposits of $1000, $2000, and $3000 into your retirement account. The $1000 deposit will be one year from today, the $2000 deposit two years from today, and...

I would like to know how to solve this problem by inserting the n,i/y,pv,pmt,fv into my ba ii plus calculator please. 11. Your employer has agreed to place year-end deposits of $1,000,$2,000 and...

1. Assume you deposit $1,000 in an account that earns 6% per year. a. What would the balance in the account be at the end of 5 years if interest is compounded annually? b. What would be the balance...

You are planning to invest $ 2 comma 000 in an account earning 5% per year for retirement. a. If you put the $ 2 comma 000 in an account at age 23, and withdraw it 35 years later, how much will you...

Investment Research Assignment Imagine that you have $100,000 to invest. You are going to invest it all in one investment for the next 5 years, at least, at which point you will reevaluate both your...

An account earns 5% per year, compounded monthly. If $953 is deposited into the account, what is the balance after 12 years? (Round your answer to 2 decimal places)

Which of the following statements is (are) correct? (x) The longer money can earn interest, the smaller the present value must be to reach a financial goal. (y) In the calculation of present values,...

1. Vincent Van Gogh sold only one painting during his lifetime, for about $30. A sunflower still life he painted in 1888 sold for $39.85 million in 1988, more than three times the highest price paid...

The haemoglobin from the red blood corpuscles of most mammals contains approximately 0.33% of iron by weight. The molecular weight of haemoglobin as 67,200. The number of iron atoms in each molecule...

Ray Corporation (AC) has the opportunity to buy or lease its next equipment installation. The purchase cost is $120,000 for the equipment, transportation and installation. The corporate cost of debt...

What does a negative sloping yield curve most likely indicate?

Balance Sheet June 30th, Year 5 Assets Liabilities and Equity Cash 10,000 Accounts Payable 19,000 Accounts receivables 34,000 Wages Payable 4,000 Inventory 60,000 Income Tax Payable 1,000 Prepaid...

10-14 In MyMISLab, you will find a Collaboration and Teamwork Project dealing with the concepts in this chapter. You will be able to use Google Drive, Google Docs, Google Sites, Google+, or other...

10-7 How does the Internet change consumer and supplier relationships?

10-10 Columbiana is a small, independent island in the Caribbean that has many historical buildings, forts, and other sites, along with rain forests and striking mountains. A few first-class hotels...