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
expand button
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

Want to see the full answer?

Check out a sample Q&A here
Blurred answer
Students who’ve seen this question also like:
Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Not helpful? See similar books
Essentials Of Investments
Essentials Of Investments
Investments: Background And Issues. 1PS
marketing sidebar icon
Want to see this answer and more?
Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*
*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.

Related Finance Q&A

Find answers to questions asked by students like you.

Q: Your city is expanding. There have been several problems with street flooding,which is affecting…

A: Given: In the given case, the city is facing several problems mainly with the street flooding.Hence…

Q: A city constructs curbing in a new neighborhood and finances it as a special assessment. Under what…

A: Governmental accounting's constant goal is control and accountability. It provides evaluating…

Q: Suppose your city is debating a change in policy from illegal use to legalizing recreational use of…

A: Yes, the local crime should be considered as a cost since it will have an impact on the costing…

Q: The Lake Placid Town Council decided to build a new community center to be used for conventions,…

A: Given:

Q: A local citizen gives the City of Salem a painting by Picasso to display in city hall. Under what…

A: Definition:   Depreciation: Depreciation is a method of reducing the capitalized cost of long-lived…

Q: A city constructs curbing in a new neighborhood and finances it as a special assessment. Under what…

A: Financial accounting: Financial accounting is the process of recording, summarizing, and reporting…

Q: The Lake Placid Town Council has decided to build a new community center to be used for conventions…

A: a)Expected value approach: Excel computation: (In thousand dollars)The medium or large can be…

Q: The road development authority is evaluating the costs and benefits of three alternative routes for…

A: Benefit cost ratio is ratio of present value of benefits to the initial investment done.

Q: The Department of Transportation wishes to choose between two alternative accident prevention…

A: All amounts are in dollar ($).

Q: The Department of Transportation wishes to choose between two alternative accident prevention…

A: Benefit Cost is an integral part of Accounting Analysis  which determines how the downsides compare…

Q: Officials for the City of Artichoke, West Virginia, have recently formed a transit authority to…

A: Write a memo on the component unit and its recording in the financial statements. Component unit:…

Q: Which one of the following costs is most likely to be deductible? Group of answer choices Fines paid…

A: Solution: Following costs are not deductible as they related to violation of laws or illegal…

Q: If the government intends to increase the welfare of certain groups through special programs…

A: Efficiency means to make the best use of the resources or to make use of minimum inputs for the…

Q: ABC Cooperative paid municipal taxes and license fees to the city government unaware that under a…

A: The answer is stated below:

Q: Based on a cost-benefit analysis, management at First CommunityBank decided to contract with…

A: Cost-benefit analysis is a process wherein analysts add all the benefits associated with the…

Q: Assume in question (9) that the city does not choose to report the painting on the government-wide…

A: Revenues: Revenues are earnings from operations of a business. The operating activities are sale of…

Q: Is it ethical for state and city governments to entice specific businesses to relocate their…

A: A business entity has complete freedom to operate their business in any state and city, irrespective…

Q: The Sage Company has the opportunity to purchase a building located next to its office. Sage would…

A: Taxes are the amount of dues or liabilities that are to be paid by the individual to the government…

Q: The board of directors of Earth Rock's!, a nonprofit organization focused on environmental…

A: Earth rocks can calculate % of Program expenditure to total cost.

Q: The Great White Hall: Flatland Views city council has advertised for proposals to build a new…

A: The city council has initiated a useful step for the public purpose of a new community center, a…

Q: 1) Determine whether each of the following elements should be classified as taxes, licenses,…

A: “Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: The private property of Mina will be affected by the upcoming road improvement in their barangay.…

A: Given case is: The private property of Mina will be affected by the upcoming road improvement in…

Q: The City of Miami is about to replace an old fire truck with a new vehicle in an effort to save…

A: Replacing the asset with the new one is a good decision but the management should choose wisely the…

Q: Marvin is a state legislator. Bases on his belief that a certain infrastructure project in the…

A: A bribe is an illegal or unethical gift or lobbying effort bestowed to influence the recipient's…

Q: State whether each of the following items should be classified as taxes, licences and permits,…

A: Sales and use taxes levied by the government should be classified as taxes. Payments by citizens for…

Q: Review the scenario below and answer the following questions: Western Bank & Trust purchased land…

A: Land and building are the fixed assets of a company. These are recorded as non-current assets in the…

Q: A developer wants to build a shopping mall on land that is made up of many privately owned parcels.…

A: Here in this situation the developer want to build the shopping mall from the and which was owned by…

Q: Congress uses the tax code to influence our behavior. Examples include deductions for mortgage…

A: Following are the other tax deductions or tax credits that encourage particular behaviours:   (1) :…

Q: Based on what you have learned about the SAFE Act and the role of the NMLS, how has the SAFE Act and…

A: Meaning of SAFE Act-  The Secure and Fair Enforcement for Mortgage licensing Act.of 2008(SAFE Act) .…

Q: Based on my understanding, the operating process in a property developer starts from: a. Setting up…

A: Revenue is described as the fee charged from the customer for providing services or goods. It can be…

Q: State whether each of the following items should be classified as taxes, licences and permits,…

A: Revenue includes all financial resources which inflow to the government fund. There are mainly 5…

Q: Ito Ltd. receives a local government grant to help defray the cost of its plant facilities. The…

A: Government Grant for Plant: a financial assistance award made by the federal government to a…

Q: An employment agency for individuals with disabilities works closely with the City of Hanover. The…

A: The government uses a different way to report their financial statements than the private sector…

Q: According to PAS 20 Accounting for Government Grants and Disclosure of Government Assistance, which…

A: A government grant is a benefit that is provided by the government to the company, it may be in…

Q: Recently, a group of university students decided to incorporate for the purposes of selling a…

A: Start-up Cost: Start-up cost is a cost or amount of money incurred in setting up or starting a…

Q: Recently, a group of university students decided to incorporate for the purposes of selling a…

A: Start-up Cost: Start-up cost is a cost or amount of money incurred to setting up or starting a…

Q: 1) State whether each of the following items should be classified as taxes, licences and permits,…

A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…

Q: The city of Papagos, Arizona, had a deteriorating bridge in need of repair on a prominent public…

A: Contract: A contract is a legally enforceable agreement between two or more entities to perform an…

Q: Discussion Details Review the scenario below and answer the following questions: Western Bank &…

A: The answer are as follows.

Q: Your client is in the planning phase for a major plant expansion, which will involve the…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: Why might a company’s board of directors decide tolease office space even though it would be more…

A: Financial management deals with the financial decision regarding the buying of a capital asset. It…

Q: Why might a company’s board of directors decide tolease office space even though it would be more…

A: A Lease is a contract outlining the terms under which one party agrees to rent property owned by…

Q: The City of Bacon is located in the County of Pork. The city has a school system and reports…

A: Formula to calculate merged building value: Merged building value = Book value in entity 1 + Book…

Q: axation is described as a symbiotic relationship whereby in exchange of the benefits and protection…

A: Tax represents the liability for an individual or company that has to be paid to the government. It…

Q: Differentiate between purpose-type restrictions and time restrictions with regards to the use of…

A: Not-for Profit Organization: A not for profit organization, is a business type operated by…

Q: Assume that Congress changes the tax code to allow single-family rental income to be taxed at a…

A: Introduction A capitalization rate is a metric for comparing the market prices of different real…

Q: A Veterans Administration (VA) hospital needs to decide which type of boiler fuel system will most…

A: a.

Q: Why might a company’s board of directors decide to lease office space even though it would be more…

A: Leasing : Leasing can be described as an agreement where a lessee uses a property or an equipment…

Q: Bob, risk manager from Travelers, mentioned that Travelers has the following two insurance programs,…

A: Here provide the details of the insurance coverage which are incurred for the Travelers company for…

Q: The Environmental Protection Agency (EPA) is in the process of investigating a possible water…

A: Click to see the answer

Knowledge Booster
Finance
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.
Recommended textbooks for you
  • Essentials Of Investments
    Finance
    ISBN:9781260013924
    Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
    Publisher:Mcgraw-hill Education,
    FUNDAMENTALS OF CORPORATE FINANCE
    Finance
    ISBN:9781260013962
    Author:BREALEY
    Publisher:RENT MCG
    Financial Management: Theory & Practice
    Finance
    ISBN:9781337909730
    Author:Brigham
    Publisher:Cengage
  • Foundations Of Finance
    Finance
    ISBN:9780134897264
    Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
    Publisher:Pearson,
    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...
    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
  • Essentials Of Investments
    Finance
    ISBN:9781260013924
    Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
    Publisher:Mcgraw-hill Education,
    FUNDAMENTALS OF CORPORATE FINANCE
    Finance
    ISBN:9781260013962
    Author:BREALEY
    Publisher:RENT MCG
    Financial Management: Theory & Practice
    Finance
    ISBN:9781337909730
    Author:Brigham
    Publisher:Cengage
    Foundations Of Finance
    Finance
    ISBN:9780134897264
    Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
    Publisher:Pearson,
    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...
    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