Question: Formula for Excel Please! Beginning three months from now, you want to be able to withdraw $2,200 each quarter from your bank account to cover

Formula for Excel Please!

Beginning three months from now, you want to be able to withdraw $2,200 each quarter from your bank account to cover college expenses over the next five years. If the account pays 0.43 percent interest per quarter, how much do you need to have in your bank account today to meet your expense needs over the next five years? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))

Quarterly Withdrawal- 2,200 (D6)

Quarters Per Year- 4 (D7)

Number of Years- 4 (D8)

Interest Rate Per Quarter- 0.43% (D9)

Amount needed today?

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

provide excel formulas Beginning three months from now, you want to be able to withdraw $2,200 each quarter from your bank account to cover college expenses over the next four years. If the account...

SHOW HOW TO CALCULATE EAR AND HOW TO PUT INTO FINANCIAL CALCULATOR PLEASE!!! Beginning three months from now, you want to be able to withdraw $2,600 each quarter from your bank account to cover...

Need explanation/solution as if you are not using excel. LOI 26 Calculating Annuity Present Values Beginning three months from now. you want to be able to withdraw $2.500 each quarter from your bank...

If someone could teach me how to solve these problems, it would be greatly appreciated! You expect to receive $9,000 at graduation in 2 years. You plan on investing this money at 10 percent until you...

5 Beginning three months from now, you want to be able to withdraw $3,000 each quarter from your bank account to cover college expenses over the next four years. If the account pays .57 percent...

Can you please show me how to complete these using a formula in excel? I know how to solve both, but not in excel. Thank you Problem 6-27 Discounted Cash Flow Analysis. Problem 6-26 Calculating...

Please answer it jn the form of an excel input formula. XB ? 5 X Calculating annuity present values - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in X Calibri 11 H Paste BIU-...

I NEED ASAP HELP! I WILL RATE !! :) Thank you for your help! Solve the following problems using Excel spreadsheet (Excel templates can be found on Canvas under Assignments HW3>HW3 Excel Template.")...

1,450,000 1,900,000 10 2,350,000 11 2,800,000 12 5 0 NO UA W N- 3,250,000 13 3,700,000 14 4, 150,000 15 4,600,000 16 5,050,000 17 5,500,000 18 19 Discount rate 7% 20 21 22 Complete the following...

I need help with the following questions. Can you please show answers using a time line and financial calculator. Your bank balance is $15,000 and your account earns 4.19% interest compounded daily....

Dacosta Corporation had only one job in process on May 1. The job had been charged with $1,800 of direct materials, $6,966 of direct labor, and $9,936 of manufacturing overhead cost. The company...

1. Security education and advisory 2. Risk Management Threats to IT Assets (physical threats and security) 3. Encryption of data/email 4. Standards and compliance 5. Security testing and...

To provide customer support for a cloud native application, which of the following are mandatory requirements? ( choose two ) Support team needs dedicated environment to investigate customer support...

In the case of Buckhorn, Inc. and International Union of Industrial and Independent Workers, the NLRB contended that the unit, limited solely to maintenance employees is not an appropriate unit for...

Describe the business model used by Australian universities. Should Australian universities reconsider their business model?

Describe the situation of casual workers within Australian universities, with reference to various HRM theories.

Understand links between the United Nations Sustainable Development Goals and HRM.