You recently graduated from the College of Charleston and have been hired as an analyst at Galeon Financial Group. On your first day at work your boss approaches you and presents your team with the following problem. The Context Maria Yamada is a 40 year old woman with three children, ages 3, 6 and 8. Her husband, Timothy, who is five years older than her, was recently laid off from a large corporation. At this time his job prospects look bleak since his career was oriented toward an industry which has been adversely impacted by the recent recession. Maria holds the Chartered Financial Analyst designation and has recently accepted a position as the Treasurer of Gamma Health Care, a large organization based in downtown Charleston that specializes in providing healthcare services to residents in Charleston and its environs. Until recently, Maria worked for 5 years for a large financial firm in St. Louis where he had a variety of clients. Maria was tired of the long hours and the two hours commute to work while working in St. Louis. She believes that working in the Charleston area would be relatively stress-free and that the hours would be more predictable. Yamadas Decision Problem The Yamada family is relocating to the Charleston area and plan on purchasing a 4 bedroom 2.5 baths home but is undecided on which area to buy their new home. After a considerable house hunting, the family narrowed down to homes in the following areas: James Island, Mt. Pleasant, and West Ashley. The family has a budget of $375,000 and is capable of making up to 15% down payment on their new home. Required A. Where should the family buy their new home and how much down payment should they make? B. Identify at least three alternatives locations that the family should consider. Discuss the alternatives and factors that the family should consider in making their decisions. C. What should the family do? Explain why the alternative that you selected might be preferable to

Please solve and provide formulas used in excel, also table goes down to 380. Thank you.

File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Times New Roman 12 ~ A = V a Wrap Text General X Cut [Copy Format Painter Paste BIU av A = = = Merge & Center $ - % 6000 00 20 Clipboard Font Alignment Number B2 X fic Problem2 B E F G . - J K Problem2 2 3 4 Home value % Down Payment Loan amont Interest rate Number of years Number of payments per year Monthly Interest rate PMT Period Beginning balance PMT Interest Payment Principle Payment Ending Balance 5 6 7 8 9 40 10 11 40 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45