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

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
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
Transcribed Image Text: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 Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps

Blurred answer
Knowledge Booster
Valuing Decision
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education