How do I calculate this in excel? Calculate the modified B/C ratio for a government project...
How do I calculate this in excel?
Calculate the modified B/C ratio for a government project that is projected to have the following cash flows: costs of $4,400,000 per year; benefits of $5,200,000 per year; dis-benefits of $420,000 per year.
Homework Answers
B/C ratio = expected benefit from the project / cost of project
= 4,780,000 / 4,400,000
= 1.08
expected benefit from the project = benefits - dis-benefit
= 5,200,000 - 420,000
= 4,780,000
Add Answer to:
How do I calculate this in excel?
Calculate the modified B/C ratio for a government project...
The estimated annual cash flows for a proposed municipal government project are costs of $730,000 per...
The estimated annual cash flows for a proposed municipal government project are costs of $730,000 per year, benefits of $890,000 per year, and disbenefits of $160,000 per year. Calculate the conventional B/C ratio at an interest rate of 8% per year, and determine if it is economically justified. The B/C ratio is . The project is economically (Click to select)justifiednot justified .
The estimated annual cash flows for a proposed municipal government project are costs of $830,000 per year, benefits of...
The estimated annual cash flows for a proposed municipal government project are costs of $830,000 per year, benefits of $910,000 per year, and disbenefits of $280,000 per year. Calculate the conventional B/C ratio at an interest rate of 9% per year, and determine if it is economically justified. The B/C ratio is . The project is economically is justified or nonjustified
Use Excel For example.. I want it looks like that 7.21 From the following data, calculate...
Use Excel
For example.. I want it looks like that
7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000...
Problem 09.010 Benefit/Cost Analysis of a Single Project The estimated annual cash flows for a proposed...
Problem 09.010 Benefit/Cost Analysis of a Single Project The estimated annual cash flows for a proposed municipal government project are costs of $710,000 per year, benefits of $910,000 per year, and disbenefits of $160,000 per year. Calculate the conventional B/C ratio at an interest rate of 12% per year, and determine if it is economically justified. The B/C ratio is The project is economically (Click to select) A
Problem 09.010 Benefit/Cost Analysis of a Single Project The estimated annual cash flows for a proposed...
Problem 09.010 Benefit/Cost Analysis of a Single Project The estimated annual cash flows for a proposed municipal government project are costs of $800,000 per year, benefits of $910,000 per year, and disbenefits of $230,000 per year. Calculate the conventional B/C ratio at an interest rate of 9% per year, and determine if It is economically justified. The B/C ratio is The project is economically not justified
3. A consultant, after 3 months of work, reported that the modified B/C ratio for a...
3. A consultant, after 3 months of work, reported that the modified B/C ratio for a city-owned hospital heliport project is 1.4. If the initial cost is $1.4 million and the annual benefits are $120,000, what is the amount of the annual M&O costs used in the calculation? The report stated that a discount rate of 6% per year and an estimated life of 30 years were used.
A federal highway project is expected to have a first cost of $5 million and an...
A federal highway project is expected to have a first cost of $5 million and an annual maintenance cost of S200,000. Shoulder replacement costs of $1,000,000 will be required in 10 years. Benefits to the road-users are expected to be $800,000 per year. If the project will have a 20 year life, please calculate the modified B/C ratio. Is the public project worth undertaking? Why (not)? Hint: Modified B/C ratio: (Benefits-Disbenefits-M&O Costs)/Initial Investment 3)
Q1 ) The Ministry of public health considering a project a the following cash flows: benefits of...
Q1 ) The Ministry of public health considering a project a the following cash flows: benefits of $214,726 in the first years and increase by 3,993 for through year 20, disbenefits of $49,852 in the first year and decreases by $1,148 through year 20, The project first cost $687,400 and M&O costs of $25,000 per year. If the discount rate is 10% and study period is 20 years the modified B/C ratio of the project is closest to Q2) A local government considering two...
3. (16) Find and report the standard or traditional B/C ratio for each project below using...
3. (16) Find and report the standard or traditional B/C ratio for each project below using an interest rate of 7.0% if required. Projects are not substitutes for each other so no comparison analysis is required. Project Purchase/Investment Life yrs 12 Recurring Costs 40,000 (Present Worth) 4000 annually 13,500 annually Benefits of Project 140,000 (Present Worth) 8,800 years 1 thru 5, 7,000 year 6 Dis benefits 1 79,000 8000 (Present Worth) 2 24,000 15,000 6 3 15 136,000 (Present Worth)...
The B/C ratio for a flood control project along the Swanee River was calculated to be...
The B/C ratio for a flood control project along the Swanee River was calculated to be 1.5. If the benefits were $450,000 per year and the maintenance costs were $221,000 per year, determine the initial cost of the project at an interest rate of 7% per year and a 50-year life. The initial cost of the project is
Use Excel
For example.. I want it looks like that
7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000...
Problem 09.010 Benefit/Cost Analysis of a Single Project The estimated annual cash flows for a proposed municipal government project are costs of $710,000 per year, benefits of $910,000 per year, and disbenefits of $160,000 per year. Calculate the conventional B/C ratio at an interest rate of 12% per year, and determine if it is economically justified. The B/C ratio is The project is economically (Click to select) A
Problem 09.010 Benefit/Cost Analysis of a Single Project The estimated annual cash flows for a proposed municipal government project are costs of $800,000 per year, benefits of $910,000 per year, and disbenefits of $230,000 per year. Calculate the conventional B/C ratio at an interest rate of 9% per year, and determine if It is economically justified. The B/C ratio is The project is economically not justified
3. A consultant, after 3 months of work, reported that the modified B/C ratio for a city-owned hospital heliport project is 1.4. If the initial cost is $1.4 million and the annual benefits are $120,000, what is the amount of the annual M&O costs used in the calculation? The report stated that a discount rate of 6% per year and an estimated life of 30 years were used.
A federal highway project is expected to have a first cost of $5 million and an annual maintenance cost of S200,000. Shoulder replacement costs of $1,000,000 will be required in 10 years. Benefits to the road-users are expected to be $800,000 per year. If the project will have a 20 year life, please calculate the modified B/C ratio. Is the public project worth undertaking? Why (not)? Hint: Modified B/C ratio: (Benefits-Disbenefits-M&O Costs)/Initial Investment 3)
3. (16) Find and report the standard or traditional B/C ratio for each project below using an interest rate of 7.0% if required. Projects are not substitutes for each other so no comparison analysis is required. Project Purchase/Investment Life yrs 12 Recurring Costs 40,000 (Present Worth) 4000 annually 13,500 annually Benefits of Project 140,000 (Present Worth) 8,800 years 1 thru 5, 7,000 year 6 Dis benefits 1 79,000 8000 (Present Worth) 2 24,000 15,000 6 3 15 136,000 (Present Worth)...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago