# It has long been a contention of civic leaders that the ambiance of the local area's residential areas would be substantially enhanced if they were provided sidewalks and curb-and-gutter drainage appurtenances Without question, the majority of neighborhoods would be more attractive and the proposed enhancements would also increase the residences market values. The increase in market value would subsequently be accompanied by an increase in the taxable values of residential properties that are currently without these features. The local government has, for some time now, required uniform street signage in all subdivisions and taken.action to install upgraded signs wherever they did not presently exist. A review, conducted by the government's Planning and Development Review Department, of all subdivisions within the government's purview reports that adequate dedicated rights- of-way that exists to allow the construction of sidewalks without acquisition of additional land from homeowners; either by purchase or by eminent domain. following project data. The cost of the crew's year 1 annual salaries and benefits are expected to conform to the following schedule Individual Cost Total Cost S51,000 Position Superviso Maintenance Worker II (5 $38,500 Note that salary &benefit costs can be expected to increase approximately 2.5% per year The current taxable value of the residential property without sidewalks and curb-and-gutter roadway drainage is approximately$12,000,000,000. These properties' taxable value has increased an average of 5% per year, over the previous 10 years. The addition of the proposed features is projected to increase both the market and taxable values of the properties being improved by an average of 2%. The current general fund millage rate for residential property is 7.2 mils. The projected growth in tax revenues should be expected to increase by 1/10t of the total each fiscal year In order to provide sidewalks and curb-and-gutter roadway drainage, the Public Works Department's Civil Engineers have recommended the establishment of a dedicated construction team for the efficient accomplishment of this project. A full-time construction project effort is projected to take approximately 10 years to complete installation in the existing neighborhoods. Development regulations have already been revised to require these features in all newly approved subdivisions and expansions of existing subdivisions. The Public Works Engineers also estimate program operating costs for materials, equipment maintenance, repairs, and fuel as follows Program Roadway Equipment Removal & The accomplishment of this recommendation is expected to require the services of a full-time, dedicated crew of six (6) field personnel: one (1) Crew Foreman and five (5) Maintenance Workers. The efforts of this group will be the constant execution of a project iob-order from the Public Works Department's current Road Inventory computer software's Roadway Features Report List. They will accomplish their scheduled work using an automated concrete curb and sidewalk forming equipment package. The purchase price of this equipment is estimated Year Materials Maintenance Surveving Fuel 15,000 350 100,000 110,000 115,000 120,000 125,000 125,000 120,000 120,000 110,000 100,000 10.000 10.000 350 10.000 350 10.000 10.000 400 12.000 400 12.000 400 12.000 14.000 425 14.000 425 400 2,000 22,000 2,000 \$210,000. The purchase price includes training of two (2) individuals in the operation and maintenance of the equipment. Sod removal and surveying services are available in-house and are accounted for in the 425 5,000

Question

Solve the following problem using excel: The program is estimated to require a 10-year commitment to fully achieve the desired result. Analyze the following information using both the Net Present Value (NPV) method and the Internal Rate of Return (IRR) method.
(I have already worked and solved this problem, however as it is complex and contains a large number of values to be calculated, I want to be sure that I applied all appropriate concepts correctly.)
I have attached the directions and problem in a screenshot.