Does anyone know how this would get plugged into excel

Assignment Help Finance Basics
Reference no: EM132130990

Today you opened up a local bank account. Your plan is to make five $4,000 contributions to this account. The first $4,000 contribution will occur today and then every six months you will contribute another $4,000 to the account. (So your final $4,000 contribution will be made two years from today). The bank account pays a 6% APR that is compounded monthly. After two years, you plan to leave the money in the account earning interest, but you will not make any further contributions to the account. How much will you have in the account 6 years from today?

Does anyone know how this would get plugged into excel?

Reference no: EM132130990

Questions Cloud

What is xyz roe : Currently it has sales of $2,500,000, total fixed costs of $1,000,000, and EBIT of $50,000. If XYZ pays 6% interest on debt, what is XYZ's ROE?
Inflation rate change : Prior to the inflation rate change, how many bonds must your company sell to raise the required capital? (rounded to nearest whole integer)
Stock required rate of return : The stock's required rate of return is 15%. If you are an analyst who believes in efficient markets, what is your forecast of g?
What is the price difference if the interest rates rose : What is the price difference if the interest rates rose 2%? (rounded to 2 decimal places)
Does anyone know how this would get plugged into excel : How much will you have in the account 6 years from today? Does anyone know how this would get plugged into excel?
Determine the number of common stock shares outstanding : How do you determine the number of common stock shares outstanding?
What is the estimated beta for abc stock : Standard deviation on returns on ABC stock is 25.00 %, the standard deviation on returns on the market is 20.00%, and their correlation is 0.15.
Considering investing in one of these three stocks : You are considering investing in one of these three stocks:
What is the payback period if the firm distributes : What is the payback period if the firm distributes all of its earnings as dividends?

Reviews

Write a Review

Finance Basics Questions & Answers

  What was the change in its net debt position during period

Applying Cash Flow Relations (Easy) A firm reported free cash flow of $430 million and operating income of $390 million.

  What is the new portfolio return

The risk free rate is 5% and the market risk premium is 8%. What is the new portfolio's return?

  What is the reward-to-volatility ratio

Assume that you manage a risky portfolio with an expected rate of return of 17% and a standard deviation of 28%. The T-bill rate is 7%. Your client chooses to invest 60% of a portfolio in your fund and 40% in a T-bill money market fund.

  Define the term constraints and give an example

Define the term constraints and give an example. For a manufacture what product should be made first when resource constraints exist?

  Interest on investment in special college fund

Cynthia will begin college in 10 years and Don's financial advisor says that she can earn 8% interest on an investment in a special college fund. How much will Don have in the fund when Cynthia begins college?

  What is the future value

The Great Giant Corp. has a management contract with its newly hired president. The contract requires a lump sum payment of $24,100,000 be paid to the president upon the completion of her first 9 years of service. The company wants to set aside an eq..

  International hrm case study - strategic management

Prepare case analysis on the topic of strategic management and why it is critical to the success of an organization in meeting its goals and mission.

  Determine the total cost to company

Pension Fund project which will be offered in 5 years, company purchases zero coupon U.S. Treasury Trust Certificates which mature in five years, when originally issued they were 12 percent coupons.

  Journal entries-bond issuance and premium amortization

Celine Dion Company issued $600,000 of 10% 20-year bonds on January 1, 2008, at 102. Prepare the journal entries to record the following.

  Name two important aspects of the clamping force

When choosing a bolting material we must consider its affect on the clamping force to be created by those bolts in service. Name two important aspects of the clamping force which will be affected, in part at least, by the choice of bolt material.

  What is the salvage value

A steel pedestrian overpass must either be reinforced or replaced. Reinforcement would cost $25,000 and would make the overpass adequate for an additional.

  Compute the companys net profits

Compute the companys net profits and EPS for each of the next 3 years - What do you think of his investment program? What do you see as its strengths

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd