Prepare a financial analysis to assist in determining the present worth between 1) replacing the present laptops with new laptops

Prepare a financial analysis to assist in determining the Show more 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 Data Block Laptop Replacement Laptop Replacement Laptop Replacement Laptop Replacement Laptop Replacement Tablet Proposal Tablet Proposal Tablet Proposal Tablet Proposal Tablet Proposal Year 0 Year 3 Year 0 Year 3 Investment Investment Depreciable Investment Investment Depreciable Replacement Laptops $1000 each nurse yes Replacement Tablets $750.00 each nurse Yes Laptop Conversion $5000 total cost Yes Database Conversion $30000.00 total cost Yes Nurse Training Nurse Training $500.00 each nurse No Staff Training Staff Training $10000.00 total cost No Nurse Staffing Nurse Staffing Year 0 Year 1 Year 2 Year 3 Nurse Staffing 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) 4320 7200 10080 Addl.Visits per year (calculated) 3840 7680 9600 Nursing Salaries ea. incl. benefits $95000 $95000 $95000 Nursing Salaries ea. incl. benefits $95000 $95000 $95000 Office Staffing Office Staffing Office Staffing Office Staffing Added staff 0 0 0 0 Added staff 1 1 1 Staff Salary incl. benefits Staff Salary incl. benefits $60000 $60000 $60000 $60000 Revenue Revenue Revenue Revenue Average revenue per visit $112.00 all years Average revenue per visit $112.00 all years Cost per visit Cost per visit 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 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 $40000.00 annually- all all years Site Maintenance contract $45000.00 annually- all all years Site Maintenance contract $35000.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 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 Show less