(Answered) There are four children ages 543 20 each child will have

Finance

There are four children ages 5,4,3, 2,0. Each child will have 100,000 dollars purchasing power at age 18. Education cost have been increasing at a rate of 7%. Inflation has been steady at 3%. How much must I set aside today to fund my goal for my grandchildren if I can earn a rate of 9% on my return. Please help me understand how to calculate this in excel.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92779850
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

Gracchus inc stock is selling for 4181 a share based on a

Gracchus, Inc. stock is selling for $41.81 a share based on a 8.2 percent rate of return. What is the amount of the next annual dividend if the dividends are increasing by 3.8 percent annually?

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?

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

Answer as thorough as possible include an explanation of

Answer as thorough as possible, Include an explanation of your recommendations or trading strategies. Should you early exercise the following American-style put option? If not always, under what situation would you early ...

Super growth co is growing quickly dividends are expected

Super Growth Co. is growing quickly. Dividends are expected to grow at a 32 percent rate for the next three years, with the growth rate falling off to a constant 7 percent thereafter. If the required return is 15 percent ...

A couple thinking about retirement decide to put aside 3700

A couple thinking about retirement decide to put aside $3,700 each year in a savings plan that earns 7% interest. In 10 years they will receive a gift of $17,000 that also can be invested. a. How much money will they hav ...

Question - just today fawlty foods incs common stock paid a

Question - Just today, Fawlty Foods, Inc.'s common stock paid a $1.40 annual dividend per share and had a closing price of $21. Assume that the market's required return, or capitalization rate, for this investment is 12 ...

If you deposit 600 every year for the next 9 years with

If you deposit $600 every year for the next 9 years, with first deposit to be made today and all deposits to be made at the beginning of every year, in an account that pays 6.12% APR with annual compounding, how much mon ...

How can health systems developers ensure the protection of

How can Health systems developers ensure the protection of patient health information during the system development process

1 consider an investment which has the following cash

1. Consider an investment which has the following cash flows: Year Cash flow ($) 0 (31,000) 1 10,000 2 20,000 3 10,000 4 10,000 5 5,000 Compute the: (a) payback period; (b) NPV at 14 percent cost of capital; and (c) IRR. ...

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