Solution-Set up a spreadsheet for bc sensitivity analysis

Set up a spreadsheet for bc sensitivity analysis

Assignment Help Finance Basics

Reference no: EM13882148

Three engineers made the estimates shown below for two optional methods by which new construction technology would be implemented at a site for public housing. Either one of the two options or the current method may be selected. Set up a spreadsheet for B/C sensitivity analysis and determine if option 1, option 2 or the do-nothing option is selected by each of the three engineers. Use a life of 5 years and a discount rate of 10% per year for all analyses.

	Engineer Bob		Engineer Judy		Engineer Chen
	Option 1	Option 2	Option 1	Option 2	Option 1	Option 2
Initial cost, $	50,000	90,000	75,000	90,000	60,000	70,000
Cost, $/year	3,000	4,000	3,800	3,000	6,000	3,000
Benefits, $/year	20,000	29,000	30,000	35,000	30,000	35,000
Dis benefits, $/year	500	1,500	1,000	0	5,000	1,000

Reference no: EM13882148

Questions Cloud

Makes minimum monthly payment and makes no other charges : Paying off credit cards Simon recently received a credit card with an 13% nominal interest rate. With the card, he purchased an Apple iPhone 5 for $400. The minimum payment on the card is only $10 per month. If Simon makes the minimum monthly payment..

Prepare an adjusted income statement and balance sheet : Prepare an adjusted Income Statement and Balance Sheet. Use a statutory tax rate of 35% to record income taxes payable and income tax expense - demonstrates the flexibility management has in determining Net Income under Generally Accepted Accounting..

Contemplating replacing-use the opportunity cost : Fluid Dynamics Company owns a pump that it is contemplating replacing. The old pump has annual operating and maintenance costs of $8,000/year: it can be kept for 4 years more and will have a zero salvage value at that time. The old pump can be traded..

Which will you use as the regressand : Plot the CPI on the vertical axis and the WPI on the horizontal axis. A priori, what kind of relationship do you expect between the two indexes? Why?

Set up a spreadsheet for bc sensitivity analysis : Set up a spreadsheet for B/C sensitivity analysis and determine if option 1, option 2 or the do-nothing option is selected by each of the three engineers.

The price of a non-dividend paying stock : The price of a non-dividend paying stock is $18 and the price of a 3-month European call option on the stock with a strike price of $20 is $1. The risk-free is 4% per annum, continuously compounded. What should be the price of a 3-month European put ..

What is the yield to maturity for these bonds : Atlantis Fisheries issues zero coupon bonds on the market at a price of $415 per bond. Each bond has a face value of $1,000 payable at maturity in 17 years. What is the yield to maturity for these bonds?

The term commonly used for a chain of amino acids 100 units : Normal 0 false false false EN-US X-NONE X-NONE The term commonly used for a c..

User Account

All Pages

Set up a spreadsheet for bc sensitivity analysis

Reference no: EM13882148

Reference no: EM13882148

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT