Please Show Work and formulas used inExcel3. A local college is installing steam pipes on their campus and must decide what insulation to use. If no insulationis used, it has been estimated that the heat loss per foot will be $2.10. If 1-inch thick insulation is used, 70% of theheat loss will be eliminated. If 2-inch thick insulation is used, 84% of the heat loss will be eliminated. The 1-inchthick insulation costs $0.30 per foot to install, and the 2-inch thick insulation costs $0.80 per foot to install. Thecampus has 230,000 ft of steam pipe on campus, and a MARR=10%. Assume the insulation has a life of 10 years.(a) Calculate the present worth (PW) of all alternatives.(b) Calculate the future worth (FW) of all alternatives.(c) Calculate the annual worth (AW) of all alternatives.(d) Rank the alternatives by any of the above metrics. Explain your choice using one of the ranking methods(PW/FW/AW), as if you were talking to your boss, a non-engineering economist.(e) What would the company's MARR need to be for options 1 and 2 to be economically equivalent?(f) What would the school's MARR need to be for no insulation to be economically equivalent to option 1?

Note: This question has several subparts. The first three have been answered below.

Answered: Please Show Work and formulas used in…

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

See similar textbooks

Similar questions

A local university decides to install motion detection light switches in the faculty offices. The cost savings associated with these switches is $1.44 per year for each year of a switch’s 15 year life. This gives a total cost savings of $21.60 per switch. The purchase cost of each light switch was $20. What should the university keep in mind about this decision to install motion-detection light switches in the faculty offices?
Parker County Community College (PCCC) is trying to determine whether to use no insulation or to use insulation 1-inch thick or 2-inches-thick on its steam pipes. The heat loss from the pipes without insulation is expected to cost $1.50 per year per foot of pipe. A 1-inch thick insulated covering will eliminate 89% of the loss and will cost $0.40 per foot. A 2-inch thick insulated covering will eliminate 92% of the loss and will cost $0.85 per foot. PCCC Physical Plant Services estimates that there are 250,000 feet of steam pipe on campus. The PCCC Accounting Office requires a 10%/yr return to justify capital expenditures. The insulation has a life expectancy of 10 years. Determine which insulation (if any) should be purchased using an internal rate of return analysis.
A small chemical manufacture company needs to replace an old high-shear mixer. Two different models have been proposed. • Model A costs $250,000 for purchasing and installation. The model has service life of 6 years and at the end of the sixth year has estimated salvage value of $50,000. The model in the first year has an operational and malntenance (O&M) cost of $24,000 and the cost increases each year by 5% over the previous year's O&M cost. • Model B costs $175,000 for purchasing and installation. The model has service life of 3 years and at the end of the third year has estimated salvage value of $30,000. The model in the first year has an operational and maintenance (O&M) cost of $11,000 and the cost increases cach year by 7% over the previous year's O&M cost. If the company has MARR of 10%, select the correct statement. O Select Model A because it has annual equivalent cost of $77,764 which is less than Model B O Select Model B because it has annual equivalent cost of $73,044…
Concordia College is planning a concert. Maximum capacity for the concert venue is 3,000. tickets will be sold for $25 per ticket. The college estimates that costs of producing the concert to be 2,500 plus the cost of the band. Alternative A a fee of $8,000 and $5 per tickets; or Alternative B - $8.00 per ticket sold at what tickets sales level will the two proposal provide the same profite of loss result? 2.What is the breakeven point in terms of tickets sold for Alternative A 3. What is the breakeven point in terms of tickets sold for Alternative B (Use the Equation Method)? 4. If you expect to see 3,000 tickets, which alternative produces the highest profit?
David Byrne Co. owns a warehouse worth $250,000. Lou Reed is the risk manager. David Byrne faces the risk of fire which would completely destroy their warehouse. The probability of a fire is known to be 6%. David Byrne is considering the following risk management options to address the risk of fire to their warehouse: [1] Retention only - no Safety Program [2] Full Insurance - Premium = $16,000 Retention + Safety Program [3] [4] Full Insurance + Safety Program - Premium = $11,000
A new motel with 15 rooms is under construction. The cost of each unit is$323.00. Each unit will require an electrical breaker at $8.25. An electricalwall socket, outlet box, and cover are needed for each unit at $3.97. Eighteenfeet of electrical wire at $0.24 per foot are needed for each unit. The labor toinstall one unit is 4 hours, and the labor is charged at the rate of $31.00 perhour. There is a 6% sales tax on everything. Write a bill for the job of puttinga through-the-wall unit in each room.
A university student painter is considering the purchase of a new air compressor and paint gun to replace an old paint sprayer. (Both items belong to Class 9 and have a 25% CCA rate). These two new items cost $12,000 and have a useful life of four years, at which time they can be sold for $1,600. The old paint sprayer can be sold for $500 and could be scrapped for $250 in four years. The student believes that operating revenues will increase annually by $8,000. Should the purchase be made? The tax rate is 22% and the required rate of return is 15%.. please Show me the steps don't copy from cheggs .
can i have the hand written solution for this?
please answer all parts of the question within 30 minutes. make sure all the parts are answered else i will give negative ratings.
The heat loss through the exterior walls of a certain poultry processing plant is estimated to cost the owner $3,000 next year. A salesperson from Superfiber Insulation, Inc., has told you, the plant engineer, that he can reduce the heat loss by 80% with the installation of $18,000 worth of Superfiber now. If the cost of heat loss rises by $200 per year (uniform gradient) after the next year and the owner plans to keep the present building for 15 more years, what would you recommend if the interest rate is 10% per year?
The Tuff Wheels was getting ready to start its development project for a new product to be added to their small motorized vehicle line for children. The new product is called the Kiddy Dozer. It will look like a miniature bulldozer, complete with caterpillar tracks and a blade. Tuff Wheels has forecasted the demand and the cost to develop and produce the new Kiddy Dozer. The table below contains the relevant information for this project. Development cost $ 1,450,000 Estimated development time 9 months Pilot testing $ 200,000 Ramp-up cost $ 400,000 Marketing and support cost $ 150,000 per year Sales and production volume 60,000 per year Unit production cost $ 100 Unit price $ 225 Interest rate 8 % Tuff Wheels also has provided the project plan shown below. As can be seen in the project plan, the company thinks that the product life will be three years until a new product must be created. Assume all cash flows occur at the end…
A southwestern city that has 170,000 households is required to install treatment systems for the removal of arsenic from drinking water. The annual cost is projected to be $50 per household per year. Assume that one life will be saved every three years as a result of the arsenic removal system andthat the EPA values a human life at $4.8 million. Use a discount rate of 8% per year and assume the life is saved at the end of each three-year period.Utilize a conventional B/C ratio to determine if the project is economically justified.

SEE MORE QUESTIONS

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

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

SEE MORE TEXTBOOKS