Use the following table solve the Benefit Cost Ratio , NPV benefits (Please show excel formulas...

Use the following table solve the Benefit Cost Ratio , NPV benefits (Please show excel formulas as well)


						Discount rate	0.08
		0	1	2	3
System A
Costs
	Hardware	14000	3000	3000	3000
	Software	12000	2000	2000	1000
	Services	2500	2500	2500	2500
Benefits
	Increased productivity		15000	10000	5000
	Lower Error rates		18000	5000	6000



System B
Costs
	Hardware	15000	3000	3000	3000
	Software	12000	4000	2000	5000
	Services	7000	3000	3000	1000
Benefits
	Increased productivity		7000	10000	10000
	Reduced Work Force		15000	15000	15000

Expert Solution

jeff jeffy answered 2 years ago

Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel...

Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel formulas) Discount rate 0.08 0 1 2 3 System A Costs Hardware 14000 3000 3000 3000 Software 12000 2000 2000 1000 Services 2500 2500 2500 2500 Benefits Increased productivity 15000 10000 5000 Lower Error rates 18000 5000 6000 System B Costs Hardware 15000 3000 3000 3000 Software 12000 4000 2000 5000 Services 7000 3000 3000 1000 Benefits Increased productivity 7000 10000 10000 Reduced Work...

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$ 26,500 Units started during April ......................................................................................................................................100,000 Units...

USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected...

USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected cash flows: • NOI is expected to be $130,000 in year 1 with 5 percent annual increases. • The purchase price of the property is $720,000. • 100 percent equity financing is used to purchase the property. • The property is sold at the end of year 4 for $860,000 with selling costs of 4 percent. • The required unlevered rate of return is...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

Solve in excel please. Show formulas A manufacturer of raisin bran cereal claims that each box...

Solve in excel please. Show formulas A manufacturer of raisin bran cereal claims that each box of cereal has more than 200 grams of raisins. The firm selects a random sample of 64 boxes and records the amount of raisin (in grams) in each box. a. Identify the null and the alternate hypotheses for this study. b. Is there statistical support for the manufacturer’s claim at a significance level of 5%? What about at 1%? Test your hypothesis using both,...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project...

IN EXCEL< SHOW THE FORMULAS > Determine the Payback period, NPV and IRR for both project A and B (show work). Which Project would you select and why? Be specific. Project A will require an initial investment of $ 200,000 and Project B will require and initial investment of $ 325,000. The cost of capital for both projects is 12%. The cash inflows for the next 5 years are listed below: Project A Project B 0 ($200,000) ($325,000) 1 $50,000...

Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma...

Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma mater, Will Anderson has come up with a scheme to stay around for 5 more years: He has decided to bid on the fast-food concession rights at the football stadium. He feels sure that a bid of $60,000 will win the concession, which gives him the right to sell food at football games for the next 5 years. He estimates that annual operating costs...

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...

Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...

Question