How was the amount in cell e22 determined

Assignment Help Civil Engineering
Reference no: EM13561446

For the cash flow data provided above the three mutually exclusive investment alternatives, please  answer the following questions showing all your work on your own paper. please number each of your answers carfully and show every step used in the analysis note row 23-64 are omitted for space considerations however the amounts in the missing rows are the same with the exception oth the discounted individual cash flows colums. these values represent the present value of the net annual benefit at the MARR provided in Cell B8

1. How was the amount in cell E20 determined?

2. How was the amount in cell E21 determined?

3. How was the amount in cell E22 determined?

4. is option 1 an acceptable alternative at a MARR of 10% why or why not

5. is option 2 an acceptable alternative at a MARR of 10% why or why not

6. Assume the data above was a pre-tax cash flow what would be the effect on the cash flow data ONLY as a result of the depreciation only: if you were allowed to use the SL depreciation method for 50 years? if you used the DB method of Depreciation ? Provide at least on example of the amount the cash flow would change for both depreciation methods

7. Show the work needed to  calculate the values in cell B71

8. show the work needed to calculate the values in cell B69

9. is option 1 an acceptable altenative at MARR of 15% why or why not ?

10. Is option 2 an acceptable alternative at a MARR of 15% why or why not?

Reference no: EM13561446

Questions Cloud

Solve to find volume and diameter : Your home town is growing so rapidly that another water tower is necessary to meet the needs of the community. Civil and environmental engineers predict that the water tower will need to hold 1.00 X 10.0^6 kilograms of water.
Calculate what is the mass of the second ball : A ball of mass m makes a head-on elastic collision with asecond ball (at rest) and rebounds with a speed equal toone-fifth its original speed. What is the mass of the second ball
Compute the magnitudes of the normal stresses : Compute the magnitudes of the normal stresses (sigma,x) and (sigma,y) in front of a surface crack of length 2.0 mm in response to a nominal tensile stress of 100 MPa at the following positions:
Calculate what was the muzzle speed of the bullet : A 25 g bullet strikes and becomes embedded in a 1.35 kg block of wood placed on a horizontalsurface just in front of the gun. what was the muzzle speed of the bullet
How was the amount in cell e22 determined : Assume the data above was a pre-tax cash flow what would be the effect on the cash flow data ONLY as a result of the depreciation only: if you were allowed to use the SL depreciation method for 50 years?
Study of african-american literature : In the study of African-American literature, why is it important to pay close attention to the vernacular tradition of spirituals, songs, and folktales?
What is a trajectory diagram : A Carnot heat engine is supplied with a high temperature heat source at a rate of 200 kW. If the power output of the heat engine is 120 kW, determine the required source temperature if the heat sink temperature is 20 °C.
The allegory of the cave : According to "Kaspar Hauser Speaks" by Steven Millhauser, Did Kaspar become enlightened in the way Plato "The Allegory of the Cave" describes? How do you know?
Create comprehensive checklist for a three day camping trip : How similar were your lists? Did you have something they didn't, and vice versa - Create a comprehensive checklist for a Three Day Camping Trip. Be sure not to leave anything out

Reviews

Write a Review

Civil Engineering Questions & Answers

  Explain how to prepare-check and adjust the notes

The plus sight and minus sight distances were kept approximately equal. Readings (in feet) listed in the order taken are 5.06 (+s) on BM tree, 8.99 (-s) and 7.33 (+s) on TPI, 2.52 (-s) and 4.85 (+s) on BM X, 3.61(-s) and 5.52 (+s) on TP2, and 7.60..

  Calculate what slope will produce at a canal cut in rock

A canal cut in rock (n= 0.030 is trapezoidal in section with the bottom width of 6.10m and side slopes of 1 on 1. The allowable average velocity is 0.76 m/s. What slope will produce 5.66 m^3/s

  What is the minimum number of filters required by plant

A conventional water treatment plant treats 2.40m^3*s^-1 of river water. The filters in the plant are 8.0x8.0m surface area and operate on the following schedule. A filter is cleaned once in each 24-hr period

  What must be the radius of the steel wire

What must be the radius of the steel wire if it is to stretch the same distance as the aluminium wire, so that the two wires maintain equal lengths after the masses are attached?

  Establish a horizontal distance

a tape is calibrated and found to measure 100.04ft between the 0- and 100-ft marks. what measurements should be laid out to establish a horizontal distance of 682.25ft?

  What fraction of the herbicide is adsorbed

The herbicide 2,4,D, is applied to a golf course at a rate of 1.2 kg/ha. The organic matter content of the soil is 1%, bulk density is 1.3 g/cm3, and water content is 0.3.

  Define flow at a hydraulic jump in terms of flow

Define flow at a hydraulic jump (upstream and downstream) in terms of the types of flow and corresponding Froude number. What is the depth of water at each section (upstream and downstream) compared to critical depth

  Find all contact forces

Cylinders A & B weigh 500N each and cylinder C weighs 1000N. Assuming frictionless contact between all surfaces, find all contact forces. Diameters A&B= 1, C=2

  Determine the force exerted on the cable by the man

The man has a mass of 75 kg, and the beam has a mass of 40 kg. The beam is in equilibrium with the man standing at the end and pulling on the cable. Determine the force exerted on the cable by the man and the reactions at pinned support C.

  What minimum concentration must be achieved in tin pot

To study mixing of the stream and river, a conservative tracer is to be added to Tin Pot Run. If the instruments that measure the tracer can detect a concentration of 1.0 mg/L, what minimum concentration must be achieved

  How to determine the two possible depths of flow

A 200 m wide natural stream, whose cross-section can be approximated by a rectangular cross-section, contains a dischargeof 80 cumecs. If the specific energy of the flow is 1.5 timesthe minimum specific energy

  Determine the average normal stress at the critical section

two 10 mm thick steel plates are fastened together by means of two 20mm bolts that fit tightly into the holes. if the joint transmits a tensile force of 45 kn determine the average normal stress in the plates at a section where no holes occur

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd