(Answered) Looking for how to calculate on excelhomework

Finance

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?

View complete question

Basic Finance, Finance

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

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Discuss two types of costs amp two types of

Discuss two types of costs & two types of benefits(excluding tax shield and EPS) that would potentially arise from the leveraged recapitalization (a firm proposed a leveraged recapitalization which could create immediate ...

Project failure rates can be high and one contributing

Project failure rates can be high and one contributing factor can be the failure to plan. Seewhy projects fail, and find one resource that outlines how planning projects contributed to project failure. whatsyour perspect ...

Principals of financial markets group assignment -in groups

Principals of Financial Markets Group Assignment - In groups of 3-4, students should choose firstly an industry and secondly two (2) ASX listed companies in this same industry upon which to undertake a fundamental analys ...

Do we need to separate bid vwap and ask vwap in calculating

Do we need to separate bid VWAP and ask VWAP in calculating VWAP? For example, for my portfolio VWAP, i would separate all the bids and asks and calculating bid VWAP and ask VWAP.

Please show the steps to work out this problem along with

Please show the steps to work out this problem along with the answer. Thank you. What is the accumulated sum of the following stream of payments? $2,747 every year at the end of the year for 4 years at 5.01 percent, comp ...

Johnson family has found that the current cost of attending

Johnson family has found that the current cost of attending college is $27,000 per year. How much lump sum amount they should have in their education account so that the 4 years of college is funded? Assume education inf ...

Dia lucrii inc has 325000 shares of cumulative preferred

Dia Lucrii, Inc. has 325,000 shares of cumulative preferred stock outstanding. The stock is supposed to pay $2.18 in dividends per share each quarter. Due to an unexpected event, the company has missed the last two quart ...

Question - how do book value and market value differ

Question - How do book value and market value differ? Provide an example found in a peer-reviewed journal article.

1 you currently owe 4066 to your credit card that charges

1. You currently owe $4,066 to your credit card that charges an annual interest rate of 22.00%. You make $165 of new charges every month and make a payment of $155 every month. What will your credit card balance be in th ...

Question - discuss common stock valuation and the required

Question - Discuss common stock valuation and the required assumption(s) for zero growth. Relate this discussion to a real-world problem.

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

Recent Questions

Ask Basic Finance Expert