Question: I need help in this on excel 4. How much would you have to deposit today to have $10,000 in five years at 6% interest

I need help in this on excel

4. How much would you have to deposit today to have $10,000 in five years at 6% interest discounted quarterly?

5. Ally deposited $2,500 in an account that pays 6% simple interest. How much money will she have at the end of 4 years?

6. If you deposit $200 monthly into a savings account that pays 2% interest, compounded monthly, how much will you have at the end of five years?

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 Accounting Questions!

Q:

Question 1 10 out of 10 points A credit card company charges you an effective interest rate of 1.25% monthly. The annual percentage rate (compounded monthly) is _ and the effective annual rate is...

Q:

Question 2 0 l 1 point Asurplus unit is E\" A) income for the period exceeds expenditures. B} income and expenditures for the period are equal. C) spending is entirely financed by borrowing. 3' 3 Di...

Q:

i would like to see the work/formulas done on these too! thank you! here is number 2 if you could not read 5 1 Problem 1 Calculate the expected Returns and Standard Deviations for Both Stocks. 12...

Q:

1. You deposited $200 in Bank of America back in year 2007, and the account balance became $250 in 2018 when you withdrew it. Which one is present value? Which one is future value? 2. What is the...

Q:

if you can do it in excel format and show your work. thnak you (for number 2 use 4 years for time maturity) typed would be apprieciated. 8 10 1 Problem 1 Calculate the expected Returns and Standard...

Q:

You deposited $200 in Bank of America back in year 2006. and the account balance bccamc $250 in 2015 when you withdrew it. Which one is present value? Which one is future value? 2. What is the future...

Q:

FIN 320 Create in Excel. Enjoy the problems! Chapter 5 1. You invested $1,650 in an account that pays 6 percent simple interest. How much more could you have earned over a 20-year period if the...

Q:

The following five situations require the use of future and present values. requested, rounding all answers to the nearest dollar. Calculate the amounts TIME VALUE OF MONEY PROBLEMS (1) |If you...

Q:

A. Melissa Wong is selling a piece of land. A real estate developer offers $100,000 now as a down payment and payments of $12,000 at the end of each quarter for the next 6 years. Assume that money...

Q:

Question 4 {1 point] Steyen has deposited $6,646 in 13.0% p.a. simple interest rate for 4 months. HO\" much is his outstanding balance at the end of 4 months? Your Answer: Answer Question 5 {1 point]...

Q:

With regard to a use case, what is an activity diagram used for?

Q:

Find the Fourier transform of the function f (t) = e-a|t|.

Q:

Find the interest rate needed for the sinking fund to reach the required amount. Assume that the compounding period is the same as the payment period. (Note. A sinking fund is an account created to...

Q:

The benefits of diversification occur as long as the investments in a portfolio are not perfectly positively correlated. Group of answer choices True False

Q:

If so, what should such a system cover? How would you suggest it enforce certain restrictions, such as employees food consumption at the front counter? Being in the laundering business, the Carters...

Q:

How would you deal with the store manager, who failed to enforce the store policy by allow-ing employees to lunch at the front counter? Being in the laundering business, the Carters feel strongly...

Q:

How would you suggest the Carters get all employ-ees to behave moresafely at work? Suggest how you might be able to encourage compliance with safety equipment, such as the use of safety goggles?...