Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

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?

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M93127327
  • Price:- $10

Priced at Now at $10, Verified Solution

Have any Question? 


Related Questions in Basic Finance

What is inventory and why is it important for your business

What is inventory and why is it important for your business, investors or potential lenders?

Briefly summarize the partnership business structure and

Briefly summarize the partnership business structure and the equity rights partners have, both in the context of managerial rights and ownership.

Estimate cost of capital for a 10-year project with a

Estimate cost of capital for a 10-year project with a market risk B=1.2. Assume expected market return is 10%.

A firm has common stock of 15300 total liabilities of 8400

A firm has common stock of $15,300, total liabilities of $8,400, current assets of $5,900, and fixed assets of $21,200. What is the amount of the shareholders' equity?

Question - robert gillman an equity research analyst at

Question - Robert gillman, an equity research analyst at Gillman Advisors, believes in efficient markets, He has been following the mining industry for the past 10 years and needs to determine the constant-growth rate th ...

What are the ways that it can help comply with legal

What are the ways that IT can help comply with legal requirements and social responsibilities surrounding the sales of alcohol?

Please help me with the following homework problemyou are

Please help me with the following homework problem: You are estimating your companies external financing needs for the next year. At the end of next year you expect that owners equity will be $80 million, total assets wi ...

An investor has 5000 invested in a stock which has an

An investor has $5,000 invested in a stock which has an estimated beta of 1.2, and another $15,000 invested in the stock of the company for which she works. The risk-free rate is 6 percent and the market risk premium is ...

Walmart has issued a dividend for the past five years in

Walmart has issued a dividend for the past five years. In 2013 it issued a $1.00 dividend. This year it is expected to issue a $1.50 annual dividend. Please calculate the rate the dividend has grown (two decimals please)

What is the current price of ordinary common shares in amp

What is the current price of ordinary / common shares in AMP superannuation and Commonwealth Bank of Australia? How has each evolved over the past 5-years?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As