Create schedule cash inflows and outflows of this fund

Assignment Help Financial Management

Reference no: EM131333386

Craig and LaDonna Allen are trying to establish a college fund for their son Spencer, who just turned three today. They plan for Spencer to withdraw $10,000 on his eighteenth birthday and $11,000, $12,000, and $15,000 on his subsequent birthdays. They plan to fund these withdrawals with a 10-year annuity, with the first payment to occur one year from today, and expect to earn an average annual return of 8 percent.

a. How much will the Allens have to contribute each year to achieve their goal?

b. Create a schedule showing the cash inflows (including interest) and outflows of this fund. How much remains on Spencer’s twenty-first birthday.

Reference no: EM131333386

Questions Cloud

Current ratio-quick ratio and debt to total assets ratio : Refer to the Weaver Corporation financial statements. Calculate the following financial ratios for the year 2013 : Current ratio, Quick ratio, Debt -to-total assets ratio, Earnings-per-share (EPS), and Market capitalization.

The planned relaxation of credit standards : A firm is considering relaxing its credit standards which will result in annual sales increasing from $1.50 million to $1.94 million. Costs of goods sold represent 47 percent of sales and the average collection period is expected to increase from 38 ..

The size of the payments for two starting dates : On september 1, 2004, a philanthropist gives a university a fund of $50 000, which is invested at J2=6%. If semi annual scholarships are awarded for 20 years from this grant, what is the size of each scholarship if the first one is awarded on a) Sept..

What is the internal rate of return for investment : An apartment building in your neighborhood is for sale for $140,000. The building has four units, which are rented at $500 per month each. The tenants have long-term leases that expire in 5 years. Maintenance and other expenses for care and upkeep ar..

Create schedule cash inflows and outflows of this fund : Craig and LaDonna Allen are trying to establish a college fund for their son Spencer, who just turned three today. They plan for Spencer to withdraw $10,000 on his eighteenth birthday and $11,000, $12,000, and $15,000 on his subsequent birthdays. Cre..

Debt financing in the companys capital structure : If a company increases the amount of debt financing in the companys capital structure, would the required return for equity holders change? Explain. If a company plans to expand into deeper water that intails more significant more risk than its curre..

What is the expected rate of return on portfolio with beta : Suppose the rate of return on 3-month T-Bill is 4%. Suppose also that the expected rate of return required by the market for a portfolio with a beta of 0.8 is 12%. According to the capital asset pricing model: What is the expected rate of return on a..

Most associated with financing type projects : Which one of the following characteristics is most associated with financing type projects?

Calculate the cpk for machine : C-Spec, Inc., is attempting to determine whether an existing machine is capable of milling an engine part that has a key specification of 3 ± 0.003 inches. After a trial run on this machine, C-Spec has determined that the machine has a sample mean of..

User Account

All Pages