1)Solve problemA project has a first cost of $10,000, net annual benefits of $2000 and salvage value after 10 years of $3000. The project will be replaced identically at the end of 10 years and again at the end of 20 years. What is the present worth of the entire 30 years of service if the interest rate is 10%.Using spreadsheet and Excel Net Present Value Function (NPV)

2)Cathy, a graduating civil engineering student, is offered a job at a remote construction project overseas. If Cathy is still with the project when it is completed at the end of year 5, she will receive a bonus of $100,000. Her discount rate is 12%. What is the present worth of the bonus? (Answer: $56,740)

3)Determine the down payment that must be made on an automobile that cost $22,000 if payments are limited to $425 per month for 48 months at 8% interest.

4)A consulting firm gives their Engineers a $3000 annual pay increase if they obtain their Professional Engineer license. If Bob obtains his license and then works an additional 25 years what is PW of the pay increase at i=6%. Assume increase is paid as a $3,000 bonus at the end of each year.

5)A company is purchasing an existing warehouse and land for $4 million and will pay off the land in 16 equal annual year-end payments. a. If the interest rate is 10%, how much is each payment. b. If the interest rate is 7.5%, how much is each payment.