complete these problems using excel spread sheet
ALE VI per month over a 5-year period. If the original cost was estimated to be $2.3 billion 5 years ago, what is the expected cost today? 4.25 The patriot missile, developed by Lockheed Martin, is designed to detect, identify, and shoot down air- craft and other missiles. The Patriot Advanced Capa- bility-3 was originally promised to cost $3.9 billion, but due to extra time needed to develop computer code and scrapped tests (due to high winds) at White Sands Missile Range, the actual cost was much higher. If the total project development time was 10 years and costs increased at a rate of 0.5% per month what was the final cost of the project? The optical products division of Panasonic is plan- ning a $3.5 million building expansion for manu facturing its powerful Lumix DMC digital zoom camera. If the company uses an interest rate of 16% per year, compounded quarterly for all new investments, what is the uniform amount per quar- ter the company must make in order to recover its investment in 3 years? 4.26 Hemisphere, LLC is planning to outsource its 51-person information technology (IT) department to Dyonyx. Hemisphere's president believes this move will allow access to cutting-edge technolo- gies and skill sets that would be cost prohibitive to obtain on its own. If it is assumed that the loaded cost of an IT employee is $100.000 per year and that Hemisphere will save 25% of this cost through outsourcing, determine the present worth of the total savings for a 5-year contract at an interest rate of 6% per year, compounded monthly. Pollution control equipment for a pulverized coal cy- clone furnace is estimated to cost $190,000 two years from now and an additional $120,000 four years from now. If Monongahela Power wants to set aside enough money now to cover these future costs, how much must be invested at an interest rate of 8% per year, compounded semiannually? In an effort to have enough money to finance his pas- sion for top-level off-road racing, a mechanical engi- neering graduate decided to sell some of his "toys." At time , he sold his chopper motorcycle for $18,000. Six months later, he sold his Baja pre-runner SUV for $26,000. At the end of year 1, he got $42,000 for his pro-light race truck. If he invested all of the money in a high-risk commodity hedge fund that camed 24% per year, compounded semiannually, how much did he have in the account at the end of 2 years? Environmental recovery company RexChem Part- ners plans to finance a site reclamation project that will require a 4-year cleanup period. If the com- pany borrows $4.1 million now, how much will the company have to get at the end of each year in order to earn 15% per year, compounded quarterly on its investment? Additionally, what is the spread- sheet function? 4.33 Northwest Iron and Steel is considering getting in- volved in electronic commerce. A modeste-commerce package is available for $30,000. The company wants to recover the cost in 2 years. Find the equivalent amount of new revenue that must be realized every 4.28 Head & Shoulders shampoo insured a spokesman football player's long hair for Si million with
