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.

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

Image Transcription

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

Expert Answer

Want to see the step-by-step answer?

See Answer

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

See Answer
*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Related Finance Q&A

Find answers to questions asked by student like you

Q: You have your choice of two investment accounts. Investment A is a 9-year annuity that features end-...

A: All financials below are in $.Characterisitics of Investment A:Monthly annuity, M = 1,780Frequency i...

Q: A $2,000 furniture can be financed by paying $50 per month for 4 years. What is the annual nominal c...

A: Nominal Interest Rate:It is the rate of interest which calculates before taking inflation. It exclud...

Q: Assume that you were recently hired as assistant to Jerry Lehman, financial VP of Coleman Technologi...

A: Note:Since we are entitled to answer up to 3 sub-parts, we shall answer the first 3 as you have not ...

Q: Countess Corp. is expected to pay an annual dividend of $3.97 on its common stock in one year. The c...

A: Calculating the cost of equity using the formula of dividend discounting model. We have,Current pric...

Q: The Alenso corporation's target capital stucture is 50% debt and 50% common equity. The cost of comm...

A:  Formula to calculate WACC:

Q: Walter is investing $5,000in an account paying 6.75 percent annually for three years. What is the in...

A: Principal invested, P = $ 5,000Interest rate, R = 6.75%Time, T = 3 yearsAs a first step, we will fin...

Q: 1. Multinational corporations Why do companies go global? Multinational corporations operate in loca...

A: The best describe reason for Saltwater Corp is “to seek production efficiency”.Justification: The co...

Q: Tomneed to have $15,000 in five years to pay offa home equity loan. If Tom were to invest in an acco...

A: Tom needs $15000 in 5 years. He has to make one deposit now that will get an interest of 5.75% compo...

Q: Relative inflation rates affect interest rates, exchange rates, the overall economic health of a cou...

A: Answer 1:The statement is a “valid” statement.Justification: The interest rate may comprise two segm...