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

  Engineering ethics and ethical issue

what is the engineering ethics course where to write about any engineering ethical case and discuss the ethical issue?

  Engineering ethics and concept and cases

what is the engineering ethics case related to civil engineering with reference and discuss all the engineering ethics issues which covered the "Engineering etics concepte and cases?

  Transportation and management

In the construction management, there is a lot of procurement route that are necessary and suitable for the construction industry.

  Supporting Investment Promotion: ERNST & YOUNG

Ernst & young is currently providing support to various sectors. In this regards it was felt that if this report is able to document good practices currently being adopted or planned in ceramic sector.

  Personalized Cancer Therapy-A step forward

Cancer is the uncontrolled growth of abnormal cells in the body resulting in tumours that can be benign or malignant (cancerous cells). A proper treatment is necessary to fight with this serious disease.

  Discuss the different environmental companies

Discuss the different agencies, institutes, centers, different environmental companies that are active in UAE.

  Develop a simple urban constructed wetland design

Develop a simple urban constructed wetland design.

  Evaluate company performance in relation to GRI standards

Evaluate company performance in relation to GRI standards and comment on Stigler's theory.

  Water system design

Determine the corresponding error in the computed discharge

  Hydraulic behaviour in open channel

Describe how test flumes and associated equipment are used to assess and confirm hydraulic behaviour in open channel

  Write a paper on steel sustainability

Write a paper on steel sustainability.

  Writing case study about bridge collapse

Writing case study about bridge collapse

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