1.3 What is a Microsoft Excel spreadsheet? (1)

Ella and Jackson would like to begin saving for their children’s college education. They have two kids, ages 7 and 9. Each child will begin college at 18 and attend a private university for four years. Tuition is currently $25,000 per year and is increasing at 2% per year. They can earn an after-tax rate of return of 8%. How much must they save at the end of each year if they would like to make the last payment at the beginning of their youngest child’s first year of college? Make sure to type in your calculator inputs ( NPV , N, I, PV, PMT, FV ) to receive full credit.

Given a risk event that is of the type below, which way of handling risk (Risk Management Alternative) is most appropriate?   a. High Frequency/High Severity:   b. High Frequency/Low Severity:   c. Low Frequency/High Severity:   d. Low Frequency/Low Severity

SECTION A: THEORY                                                                                                               QUESTION 1:    Choose the correct answer. Only one answer is correct.   

Bob Johnson established a Section 529 Savings Plan for his son Adam several years ago. It is now time to pay Adam’s first-year college costs. The current value of the fund is $80,000. If Bob withdraws $20,000 to pay qualified tuition expenses, how will the distribution be taxed?

Given the following information on each index and its relationship to a Mutual Fund, which index would be best for evaluating that Mutual Fund.     Index A Index B Index C Index D Beta 0.50 1.00 0.80 0.30 R Squared 0.84 0.81 0.76 0.78

Jeff and Heather would like to plan for their son’s college education. They would like their son, who was born today, to attend a private university for 4 years beginning at age 18. Tuition is currently $30,000 per year and has increased at an annual rate of 4%. They can earn an after-tax rate of return of 6%. How much must they save at the end of each year if they would like to make the last payment at the beginning of their son’s first year of college?

Maxwell, age 28, is a single father of one daughter, Emma, age 3. Maxwell works for an advertising agency with an annual income of $40,000. Due to his messy divorce and several student loans that drain his financial resources, Maxwell lives paycheck to paycheck. His doctor recently discovered that he has high blood pressure and Maxwell is worried that his health may fail. He wants to purchase a life insurance policy to protect Emma in the event of his untimely death. Assuming he wants to buy as much coverage as possible for the cheapest price, which of the following policies should he buy?

1.2 Choose the correct scientific term for the following statements.   1.2.1 The study of the interactions of organisms with one another and their physical environment. (1) 1.2.2 The smallest micro-organism that we know of. (1) 1.2.3 The type of symbiotic relationship where one organism benefits and the other is harmed. (1) 1.2.4 The energy molecule released by cellular respiration. (1) 1.2.5 The chemical that can be used to test for starch. (1)

Answer the five following short answer discussion questions.  Use examples to illustrate your answers. Please define and give examples for explaining something  using mythos and logos.