The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Gulf Shores has a board-designated building fund to pay for projected facility renovations starting in eight year and lasting for four years (at t = 8, 9, 10, and 11). Current building renovation costs are estimated to be $14,500,000 a year, but they are expected to increase at a rate of 3.5 percent a year. So far, Gulf Shoreshas accumulated $15,000,000 (at t = 0). Gary's long-run financial plan is to add $5,000,000 in each of the next four years (at t = 1, 2, 3, and 4). Then, he plans to make annual contributions in each of the following three years (t = 5, 6, and 7).
Â
Gary will invest the contributions to the board-designated building fund in CDs. How much will the equal annual contributions in years 5, 6, and 7 have to be to ensure the Center will have sufficient funds to pay for projected facility renovations? (Use the CD interest rate offered by the bank you selected for a CD in question 1.) (Hint: Use a time line to lay out the year 0-4 and 8-11 annual cash flows and then use Goal Seek in Excel to solve for the year 5-7 cash flows.) Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
Â
| Â |
Sun Trust Bank |
|
| Â |
Nominal |
Effective |
|
CDs |
6.00% |
6.17% |
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------