Develop an economic feasibility analysis, using payback analysis, ROI, and present value (assume a discount rate...

Develop an economic feasibility analysis, using payback analysis, ROI, and present value (assume a discount rate of 10%) using the table below

	System in place	In-House System	Vertical Software
Year 1	6 hours overtime total $6,480 per employee Support Staff 7 People Plus, new staff member	12 weeks, hourly salary $35 total $16,800 Commercial package $2,500 10 hrs. weekly training $4200 4 hrs. weekly maintenance $22.5 total of 4,320 Hardware Cost $12,500	Vertical package $12,000 4 weeks to install $5,600 10hrs weekly training $4,200 Free Support first year 4 hrs. weekly maintenance $22.5 total of 4,320 Hardware Cost $12,500
Year 2	6 hours overtime total $6,480 per employee	4 hrs. weekly maintenance $22.5 total of 4,320	Technical Support $600 4 hrs. weekly maintenance $22.5 total of 4,320
Year 3	6 hours overtime total $6,480 per employee	4 hrs. weekly maintenance $22.5 total of 4,320	Technical Support $600 4 hrs. weekly maintenance $22.5 total of 4,320
Year 4	6 hours overtime total $6,480 per employee	4 hrs. weekly maintenance $22.5 total of 4,320	Technical Support $600 4 hrs. weekly maintenance $22.5 total of 4,320
Year 5	6 hours overtime total $6,480 per employee	4 hrs. weekly maintenance $22.5 total of 4,320	Technical Support $600 4 hrs. weekly maintenance $22.5 total of 4,320
Total	$259,200	$57,600	$58,300
Saved in 5 years		$201,600	$200,900

Expert Solution

	System in place	In-House System	Vertical Software
year 1	51,840	12 weeks, hourly salary	16800	vetical package	12000	5
	commercial package	2500	installation	5600
	weekly training	4200	weekly training	4200
	weekly maintenace	4320	weekly maintenace	4320
	hardware	12500	hardware	12500
		40,320		38,620

year 2				Technical Support	600
51,840	weekly maintenace	4320	weekly maintenace	4320
				4920

year 3
51,840	weekly maintenace	4320	Technical Support	600
			weekly maintenace	4320
				4920

year 4				Technical Support	600
51,840	weekly maintenace	4320	weekly maintenace	4320
				4920

year 5	51,840			Technical Support	600
	weekly maintenace	4320	weekly maintenace	4320
				4920
	2,59,200		57,600		58,300
saved	-		2,01,600		2,00,900	compared with system in place
Payback period	5 years		3.50		3.45
ROI			64%		63%
Present value			49,103.47		49,287.03
Net Present Value			8,496.53		9,012.97

jeff jeffy answered 1 year ago

Cashflow Payback Amount Payback Year Present Value of cashflows using Discount rate of 12% 13% 13.25%...

Cashflow Payback Amount Payback Year Present Value of cashflows using Discount rate of 12% 13% 13.25% 14% 15% 16% -650,000,000.00 0 -650,000,000.00 -650,000,000.00 -650,000,000.00 -650,000,000.00 -650,000,000.00 -650,000,000.00 80,000,000.00 80,000,000.00 1 $71,428,571.43 $70,796,460.18 $76,638,005.83 $70,175,438.60 $69,565,217.39 $68,965,517.24 121,000,000.00 121,000,000.00 1 $96,460,459.18 $94,760,748.69 $94,337,042.51 $93,105,570.94 $91,493,383.74 $89,922,711.06 162,000,000.00 162,000,000.00 1 $115,308,400.15 $112,274,126.29 111,521,947.37 $109,345,385.62 $106,517,629.65 $103,786,543.11 221,000,000.00 221,000,000.00 1 $140,449,495.33 $135,543,438.82 134,334,030.95 $130,849,741.30 $126,357,467.28 $122,056,332.63 210,000,000.00 138,000,000.00 0.66 $119,159,639.70 $113,979,586.56 112,709,756.39 $109,067,419.52 $104,407,114.41 $99,983,733.24 154,000,000.00 $78,021,192.66 $73,969,053.22 72,981,263.94 $70,160,328.34 $66,578,449.77 $63,208,107.22 108,000,000.00...

Need assistance with Basic ROI, Payback Period, Net Present Value, Internal Rate of Return calculations.

PAYBACK, ACCOUNTING RATE OF RETURN, PRESENT VALUE, NET PRESENT VALUE, INTERNAL RATE OF RETURN All four...

PAYBACK, ACCOUNTING RATE OF RETURN, PRESENT VALUE, NET PRESENT VALUE, INTERNAL RATE OF RETURN All four parts are independent of all other parts. Assume that all cash flows are after-tax cash flows: a. Randy Willis is considering investing in one of the following two projects. Either project will require an investment of $10,000. The expected cash flows for the two projects follow. Assume that each project is depreciable. Year Project A Project B 1 $ 3,000 $3,000 2 ...

Determine the present value of the mixed stream of cash flows using a 6% discount rate....

Determine the present value of the mixed stream of cash flows using a 6% discount rate. DO not place a $ sign front of the number and use 2 decimals. For example 1234.56 CF1 $900 CF2 $800 CF3 $1200 CF4 $1600 CF5 $1900

Calculate the present value of each scenario using a 6% discount rate. Which scenario

S12A-13 Determining present value Your grandfather would like to share some of his fortune with you. He offers to give you money under one of the following scenarios (you get to choose): 1. $8,750 per year at the end of each of the next six years 2. $49,650 (lump sum) now 3. $100,450 (lump sum) six years from now C H A P T E R 1 2 Requirements 1. Calculate the present value of each scenario using a...

1) What is the Present Value using a discount rate of 8% given the following cash...

1) What is the Present Value using a discount rate of 8% given the following cash flows? Year 1: 40,000 Year 2: 42,000 Year 3: 44,000 Year 4: 45,000 Year 5: 37,000 And, a sale occurs at the end of year 5 at a price of $425,000. 2) Same facts as #1. Would you pay the asking price of $502,000 ? Yes or no for NPV being positive or negative. 3) Same facts as...

The discount rate that equates the present value of a project’s cash inflows with the present...

The discount rate that equates the present value of a project’s cash inflows with the present value of the project’s outflows is:

Using a discount rate of 14 percent, calculate the net present value (NPV) of the proposed investment.

Beacon Company is considering automating its production facility. The initial investment in automation would be $9.40 million, and the equipment has a useful life of 8 years with a residual value of $1,000,000. The company will use straight-line depreciation. Beacon could expect a production increase of 38,000 units per year and a reduction of 20 percent in the labor cost per unit. Current (no automation) Proposed (automation) 77,000 units 115,000 units Production and sales volume Per Unit Total...

What is the present value of RM2,400 a year at a discount rate of 8% if...

What is the present value of RM2,400 a year at a discount rate of 8% if the first payment is received 7years from now and you received a total of 25 annual payments?

Solve for maturity value, discount period, bank discount, and proceeds. Assume a bank discount rate of...

Solve for maturity value, discount period, bank discount, and proceeds. Assume a bank discount rate of 9%. Use the ordinary interest method. (Use Days in a year table.) (Do not round intermediate calculations. Round your final answers to the nearest cent.) Face value (principal) Rate of interest Length of note Maturity value Date of note Date note discounted Discount period Bank discount Proceeds $29,600 9% 65 days September 18 October 20

Question