Need help with the question below: Thanks

Prepare a financial analysis to assist in determining the present worth between 1) replacing the present laptops with new laptops, or 2) to replace them with tablet computers

Data Block
	Laptop Replacement							Tablet Proposal
		Year 0			Year 3				Year 0			Year 3
Investment				Depreciable			Investment				Depreciable
	Replacement Laptops	$1,000	each nurse	yes				Replacement Tablets	$750.00	each nurse	Yes
	Laptop Conversion	$5,000	total cost	Yes				Database Conversion	$30,000.00	total cost	Yes
	Nurse Training							Nurse Training	$500.00	each nurse	No
	Staff Training							Staff Training	$10,000.00	total cost	No
Nurse Staffing		Year 0	Year 1	Year 2	Year 3		Nurse Staffing		Year 0	Year 1	Year 2	Year 3
	Nurses	40	43	45	47			Nurses	40	40	40	40
	Change in # of nursesNurses	0	3	5	7			Change in # of nursesNurses	0	0	0	0
	Visits per week	30	30	30	30			Visits per week	30	32	34	35
	Change in Visits per week		0	0	0			Change in Visits per week		2	4	5
	Weeks per year		48	48	48			Weeks per year		48	48	48
	Addl.Visits per year (calculated)		4,320	7,200	10,080			Addl.Visits per year (calculated)		3,840	7,680	9,600
	Nursing Salaries ea. incl. benefits		$95,000	$95,000	$95,000			Nursing Salaries ea. incl. benefits		$95,000	$95,000	$95,000
Office Staffing							Office Staffing
	Added staff	0	0	0	0			Added staff		1	1	1
	Staff Salary incl. benefits							Staff Salary incl. benefits	$60,000	$60,000	$60,000	$60,000
Revenue							Revenue
	Average revenue per visit	$112.00	all years					Average revenue per visit		$112.00	all years
Cost per visit							Cost per visit
	Travel cost	$6.50	per visit	all years				Travel cost		$6.50	per visit	all years
	Cloud Processing cost	$0.00	per visit	all years				Cloud Processing cost		$3.00	per visit	all years
	Supplies	$8.00	per visit	all years				Supplies		$8.00	per visit	all years
Annual Expenses							Annual Expenses
	Tablet Software Licenses	$0.00	annually per nurse	all years				Tablet Software Licenses		$50.00	annually per nurse	all years
	Site Office software	$0.00	annually- all	all years				Site Office software		$40,000.00	annually- all	all years
	Site Maintenance contract	$45,000.00	annually- all	all years				Site Maintenance contract		$35,000.00	annually- all	all years
	Wireless contract	$0.00	Monthly per nurse	all years				Wireless contract		$500.00	Monthly per nurse	all years
Other							Other
	Present Laptops Book Value	$0.00	each					Present Laptops Book Value	$0.00	each
	Time horizon	3	Years					Time horizon	3	Years
	Tax Rate	22%						Tax Rate	22%
	MARR	14%						MARR	14%
	MACRS	3	years					MACRS	3	years