Bank account to cover college expenses over next four years

Assignment Help Financial Management

Reference no: EM13923025

Beginning three months from now, you want to be able to withdraw $3,700 each quarter from your bank account to cover college expenses over the next four years. Required: If the account pays .77 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? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

Please answer in PV formula in Excel if possible.

Reference no: EM13923025

Questions Cloud

What is the appropriate cost for retained earnings : The Yo-Yo Corporation tries to determine the appropriate cost for retained earnings to be used in capital budgeting analysis. The firm’s beta is 1.80. The rate on six-month T-bills is 2.30%, and the return on the S&P 500 index is 5.01%. What is the a..

About the sales increase : Pierce Furnishings generated $4 million in sales during 2012, and its year-end total assets were $2.6 million. Also, at year-end 2012, current liabilities were $500,000, consisting of $200,000 of notes payable, $200,000 of accounts payable, and $100,..

What is the effective cost of borrowing in this case : Your firm has an average collection period of 53 days. Current practice is to factor all receivables immediately at a 2 percent discount. What is the effective cost of borrowing in this case? Assume that default is extremely unlikely.

Calculate economic order quantity : Cheeseburger and Taco Company purchases 9,497 boxes of cheese each year. It costs $18 to place and ship each order and $8.83 per year for each box held as inventory. The company is using Economic Order Quantity model in placing the orders. Calculate ..

Bank account to cover college expenses over next four years : Beginning three months from now, you want to be able to withdraw $3,700 each quarter from your bank account to cover college expenses over the next four years. Required: If the account pays .77 percent interest per quarter, how much do you need to ha..

What is the future value of the cash flows five years : Consider the following cash flow: Year Cash Flow 2) $22,300 3)$40,300 5) $58,300. Assume an interest rate of 9.1 percent per year. what is the future value of the cash flows five years from now?

What is the effective annual cost of trade credit under term : Pet Store Inc. sells on terms of 2/10, net 50. What is the effective annual cost of trade credit under these terms? Use a 365-day year. Please show formula and explain step by step. I've tried other formulas on here and continue to get the wrong answ..

Random processes : Theme: Random Processes, Compute and plot separate correlation functions of white noise data and of sinusoidal data. Do this using both the biased and unbiased autocorrelation functions. Are the results what you expected?

Have apollo and rocky breached their directors duties : Have Apollo and Rocky breached their directors' duties? Do Apollo and Rocky have an arguable defence? Have the directors of Citrus Ltd breached their directors' duties (in particular duty to act for good faith in the best interests of the company and..

User Account

All Pages