1. Business
  2. Economics
  3. this is for engineering economics class we use the excel...

Question: this is for engineering economics class we use the excel...

Question details
This is for engineering economics class. We use the excel software. Below is exercise 5, and I really need help with it. Below that is my work on excel. I got part a correct for the answer matches the professor; however, my equation could be wrong. My equation shows in the picture but I also wrote it down on the paper too. A good thing for me to clarify is that the only things that I used an equation for thus far was the cost at times 13 through 16, everything else is hardcoded in.

Please help and include all formulas, thank you very very much!

Exercise 5 - Help me with the following: My son is currently in Kindergarten. When he was born, we opened a college savings plan and currently have $5000 in his account. Assuming he starts college after he graduates from high school, how much must I put in his account each year, including the 4 years he is in college, such that $0 remain in his account upon graduation. a) What will be the cost of education (tuition only) when he is ready to start college? :F Cen,men) institution is $6,000. It is increasing at a rate of 6% per year. What will the cost Lets make the following assumptions. The current tuition for college in a public be in each of the 4 years he is in college? 13 |.jw.J7q b) Create the cash flow diagram, starting with the $5000 currently in the account 15 Fv, c%,G,e,-6eco. ) -) and noting the annual installments I will make starting at the end of year 1 through his last year in college, and note the cash outflows from the account for the 4 years he is in college. c) Determine the annual installments that I must put into his account such that so will remain in his account upon graduation. Assume a 6% interest ra ) What are the annual installments if college tuition increases at 9% per year? e) What are the annual installments if college tuition increases 9% per year, but the te. college savings plan returns only 5% per year?
File Insert Page Layout Formulas Data Review ViewH Cut Format Painter Blu·田 Font Paste Copy . Clipboard E48 9 college $6,000 inflation Pv 29 Ex 5 Guess $1,880 6% 6% investmen Cost 31 Age Time $5,000 10 12 13 14 10 12 13 14 15 16 (S12,798) (S13,565) S14.379 ($15,242) Sheet1
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution