The streets and roads maintained by the government have not had an adequate maintenance program. The continuing failure to adequately and promptly repair tailures in the asphalt paving of local, collector, and arterial roadways has caused the government to incur excessive repaving/reconstruction costs for its roadways due to the early failure of their asphalt surfacing and subsequent deterioration of the roadway's base. The Public Works Department's Civil Engineers have recommended the establishment of a dedicated team for the rapid and efficient accomplishment of the repair of potholes and other paving Presently, the annual budget for maintaining and refurbishing failing roadways is $750,000. This amount has historically (over the most recent 10 years) increased by an average 8% annually. The Public Works Engineers estimate that the proposed maintenance program will reduce that budgetary item's cost annually by the following proportions ProgramCost Year Reduction ures 2 10% 10% 10% The accomplishment of this recommendation is expected to require the services of a full-time, dedicated crew of four (4) field personnel: one (1) Crew Foreman and three (3) Maintenance Workers. The efforts of this group will be the constant execution of a job-order report from the Public Works Department's current Road Inventory computer software's Repair Report List. They will accomplish their scheduled work using an automated asphalt patching system for the repair of potholes in major roadways that will be purchased for this purpose. Purchase price estimated a $175,000. The purchase price includes training of three (3) individuals in the operation and maintenance of the equipment. The cost of the crew's year 1 annual salaries and benefits are expected to conform to the following schedule 4 6% The Public Works Engineers also estimate program operating costs for materials, equipment m aintenance, repairs, and fuel as follows Program RoadwayEquipment Year Materials Maintenance Fuel 500 100,000 110,000 115,000 120,000 125,000 125,000 120,000 120,000 110,000 100,000 10,000 10,000 10,000 10,000 10,000 12,000 12,000 12,000 14,000 14,000 Position 2 Individual Cost Total Cost $51,000 115,500 S166,500 500 525 525 525 525 550 550 550 Supervisor 1 (1 S51,000 S38,500 4 Maintenance Worker II (3 Total: Note that salary & benefit costs can be expected to increase approximately 2.5% per year

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.

The streets and roads maintained by the government have not had
an adequate maintenance program. The continuing failure to
adequately and promptly repair tailures in the asphalt paving of
local, collector, and arterial roadways has caused the government
to incur excessive repaving/reconstruction costs for its roadways
due to the early failure of their asphalt surfacing and subsequent
deterioration of the roadway's base. The Public Works
Department's Civil Engineers have recommended the
establishment of a dedicated team for the rapid and efficient
accomplishment of the repair of potholes and other paving
Presently, the annual budget for maintaining and refurbishing
failing roadways is $750,000. This amount has historically
(over the most recent 10 years) increased by an average 8%
annually. The Public Works Engineers estimate that the
proposed maintenance program will reduce that budgetary
item's cost annually by the following proportions
ProgramCost
Year Reduction
ures
2
10%
10%
10%
The accomplishment of this recommendation is expected to
require the services of a full-time, dedicated crew of four (4) field
personnel: one (1) Crew Foreman and three (3) Maintenance
Workers. The efforts of this group will be the constant execution
of a job-order report from the Public Works Department's current
Road Inventory computer software's Repair Report List. They
will accomplish their scheduled work using an automated asphalt
patching system for the repair of potholes in major roadways that
will be purchased for this purpose. Purchase price estimated a
$175,000. The purchase price includes training of three (3)
individuals in the operation and maintenance of the equipment.
The cost of the crew's year 1 annual salaries and benefits are
expected to conform to the following schedule
4
6%
The Public Works Engineers also estimate program operating costs
for materials, equipment m
aintenance, repairs, and fuel as follows
Program RoadwayEquipment
Year Materials Maintenance Fuel
500
100,000
110,000
115,000
120,000
125,000
125,000
120,000
120,000
110,000
100,000
10,000
10,000
10,000
10,000
10,000
12,000
12,000
12,000
14,000
14,000
Position
2
Individual Cost Total Cost
$51,000
115,500
S166,500
500
525
525
525
525
550
550
550
Supervisor 1 (1
S51,000
S38,500
4
Maintenance Worker II (3
Total:
Note that salary & benefit costs can be expected to increase
approximately 2.5% per year
Transcribed Image Text:The streets and roads maintained by the government have not had an adequate maintenance program. The continuing failure to adequately and promptly repair tailures in the asphalt paving of local, collector, and arterial roadways has caused the government to incur excessive repaving/reconstruction costs for its roadways due to the early failure of their asphalt surfacing and subsequent deterioration of the roadway's base. The Public Works Department's Civil Engineers have recommended the establishment of a dedicated team for the rapid and efficient accomplishment of the repair of potholes and other paving Presently, the annual budget for maintaining and refurbishing failing roadways is $750,000. This amount has historically (over the most recent 10 years) increased by an average 8% annually. The Public Works Engineers estimate that the proposed maintenance program will reduce that budgetary item's cost annually by the following proportions ProgramCost Year Reduction ures 2 10% 10% 10% The accomplishment of this recommendation is expected to require the services of a full-time, dedicated crew of four (4) field personnel: one (1) Crew Foreman and three (3) Maintenance Workers. The efforts of this group will be the constant execution of a job-order report from the Public Works Department's current Road Inventory computer software's Repair Report List. They will accomplish their scheduled work using an automated asphalt patching system for the repair of potholes in major roadways that will be purchased for this purpose. Purchase price estimated a $175,000. The purchase price includes training of three (3) individuals in the operation and maintenance of the equipment. The cost of the crew's year 1 annual salaries and benefits are expected to conform to the following schedule 4 6% The Public Works Engineers also estimate program operating costs for materials, equipment m aintenance, repairs, and fuel as follows Program RoadwayEquipment Year Materials Maintenance Fuel 500 100,000 110,000 115,000 120,000 125,000 125,000 120,000 120,000 110,000 100,000 10,000 10,000 10,000 10,000 10,000 12,000 12,000 12,000 14,000 14,000 Position 2 Individual Cost Total Cost $51,000 115,500 S166,500 500 525 525 525 525 550 550 550 Supervisor 1 (1 S51,000 S38,500 4 Maintenance Worker II (3 Total: Note that salary & benefit costs can be expected to increase approximately 2.5% per year
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 9 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