Calculating annuity present values

Assignment Help Finance Basics
Reference no: EM132139862

Looking for how to calculate on Excel.

Homework assignment:

Calculating annuity present values. Beginning three months from now, you want to be able to withdraw $2,500 each quarter from your bank account to cover college expenses over the next four years. If the account pays .38 percent interest per quarter, how much do you need to have in your bank account today to meet your expense needs over the next four years?

How do I calculate this in excel?

Reference no: EM132139862

Questions Cloud

Price charles would be willing to pay for this t-bill : The price Charles would be willing to pay for this T-bill is how much (rounded to the nearest dollar)?
Determine kevin annualized yield on this investment : The NCD matures today and Kevin redeems it receiving $1,000,000 and also interest of $25,000. Determine Kevin's annualized yield on this investment.
What will her annualized yield be : If Sara decides to hold this investment to maturity then what will her annualized yield be?
How could you make an arbitrage profit if the coupon : How could you make an arbitrage profit if the coupon bond were trading at $100?
Calculating annuity present values : Calculating annuity present values. Beginning three months from now, you want to be able to withdraw $2,500 each quarter from your bank account
How much money did the attorney think he had in his account : How much money did the attorney think he had in his account before he learned of the fraud?
Determine the bond price elasticity : The required rate of return on a certain bond changes from 12 percent to 8 percent, causing the price of the bond to change from $900 to $1,100.
What is the price of the bond : Investors' required rate of return is 12 percent. What is the price (present value) of the bond?
What rate of return will william earn on this investment : William will hold the bond until it matures. What rate of return will William earn on this investment?

Reviews

Write a Review

Finance Basics Questions & Answers

  Is there any reason why the changing interest rate

Mesa believes international capital flows shift in response to changing interest rate differentials. Is there any reason why the changing interest rate differentials in this example will not necessarily because international capital flows to change s..

  Calculate the coefficient of variation on each alternative

Calculate the coefficient of variation on each alternative.

  Stocks and bonds are traded in securities markets

T/ F Stocks and bonds are traded in securities markets. T/F  Stocks, bonds and mutual fund shares are bought and sold in the capital market.

  Dividends of 225 per share was paid yesterday stock is

dividends of 2.25 per share was paid yesterday. stock is currently sellong for 60 per share. required rate of return

  What would it cost you in canadian dollars

Your Canadian company processes raw sugar for sale in the United States, and the firm has just received a container of raw material from the UK.

  List the Buckinghams financial strengths and weaknesses

FINC 250 Financial Literacy Signature Assignment - Case Study - Nigel and Elizabeth Buckingham. List the Buckinghams' financial strengths and weaknesses

  Develop a static option replication strategy

Consider a down-and-out call option on a foreign currency. - Use DerivaGem to develop a static option replication strategy involving five options.

  If a hospital received 25000 in payments per year at the

if a hospital received 25000 in payments per year at the end of each year for the next six years from an uninsured

  What is net present value of proposed credit policy switch

Polly's Home Accents currently sells 345 units a month at a price of $59 a unit. Polly thinks she can increase her sales by an additional 55 units.

  Investment analysis and taxation of income properties

A property produces a first year NOI of $100,000 which is expected to grow by 2% per year. If the property is expected to be sold in year 10, what is the expected sale price based on a terminal capitalization rate of 9.5% applied to the eleventh y..

  The balance sheet of cpm construction company

The Balance Sheet of CPM Construction Company as of 31 December 2013 is given in Table P4.3. Assume that this company is using the POC method of income recognition. Further, assume that 65% of the projects with total bid price of $850,000 have bee..

  Methods of inventory valuation

Which methods shows the highest costs of goods sold differ under the three methods of inventory valuation. Explain why ending inventory and cost of goods sold differ under the three methods of inventory valuation.

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