AutoSave Review View Automate MS7-Financial_Template_Chisick - Saved to my Mac Search (Cmd + Ctrl + U)...

Transcribed Image Text:

AutoSave Review View Automate MS7-Financial_Template_Chisick - Saved to my Mac Search (Cmd + Ctrl + U) AutoSum Fill Clear Sort & Filter Find & Select Sensitivity Add-ins Analyze Data BD Comments Share v T U V W X Y Z AA AB AC Wrap Text General Normal Bad Good Neutral Calculation Merge & Center $ % 0 Conditional .00 0 Format Formatting as Table Check Cell Explanatory T... Input Linked Cell Note Insert Delete Format B C D E F G H | J K L M N O P Q R Home Insert Draw Page Layout Formulas Data Cut Calibri (Body) 12 Copy Paste B I U A Format B23 fx A 1 10% 2 Discount Rate 3 4 Data For Plan A: In-House Development Year 0 Year 1 Year 2 Year 3 Year 4 5 6 Costs: Year 5 Total of Present Value 7 Consultant time to develop system 8 Purchase necessary software platform 9 Hardware 10 Consultant training time 16,800 0 4,200 0 12,500 0 4,500 0 OOOO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 Office staff maintenance, backup and updating 1,560 3,120 3120 3120 3120 3120 12 13 14 Total Costs: Present Value Factor (10%) Present Value 37,860 3120 3120 3120 3120 3120 1.000 0.909 0.826 0.797 0.683 0.621 3786.000 2,836.08 2,577.12 2,486.64 2130.96 1,937.52 15 Benefits: 16 Eliminate overtime 17 Eliminate additional position 3,510 15600 7,020 7020 7020 7020 7020 31,200 31200 31200 31200 31200 18 Eliminate daily errors 1950 3,900 3900 3900 3900 3900 19 Total Benefits: 21060 42120 42120 42120 42120 42120 20 Present Value Factor (10%) 21 Present Value 22 NPV (Net Present Value) PV benefits - PV costs 1.000 2106.000 -16800.000 0.909 38287.08 -3832.92 0.826 34,791.12 -7328.88 0.797 0.683 0.621 33569.64 -8550.36 28,767.96 26,156.52 23 Cash Flow 24 ROI = (Total Benefits - Total Costs) / Total Costs 25 N 26 Data For Plan B: Purchase Vertical Software Package 27 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 28 Costs: 29 Purchase price for vendor package 12,000 0 0 0 0 0 30 Tech support contract 0 600 600 600 600 600 31 Consultant time to install, configure, and test 5,600 0 0 0 0 0 32 Hardware 12,500 0 0 0 0 0 33 Consultant training time 4,500 0 0 0 0 0 34 Office staff maintenance, backup and updating 0 3,120 3120 3120 3120 3120 35 36 Total Costs: Present Value Factor (10%) 37 Present Value 38 39 NPV (Net Present Value) PV benfits - PV costs Benefits: 34,600 1.000 3,460 -31140 3720 3720 3720 3720 3720 0.909 0.826 0.797 0.683 0.621 3381.48 3072.72 -338.52 -647.28 2964.84 -755.16 2540.76 -1,179.24 2310.12 -1,409.88 43 44 45 46 40 Eliminate overtime 41 Eliminate additional position 42 Eliminate daily errors Net Present Value Factor (10%) NPV Net Present Value N/A 3,510 7,020 7020 7020 7020 7020 15600 31,200 31200 31200 31200 31200 1950 3,900 3900 3900 3900 3900 Total Benefits: 42120 1 0.909 0.826 0.797 0.683 0.621 Present Value N/A 38287.08 -3832.92 47 Cash Flow N/A 48 ROI = (Total Benefits - Total Costs) / Total Costs N/A 49 50 51 52 53 54 55 56 57 58 59 60 61 62 CostBenefitSummary Cost-Benefit Ready Accessibility: Good to go S B + 100% AutoSave Formulas Data 12 A Home Insert Draw Page Layout Cut Calibri (Body) Copy Paste B I U Format A15 fx Eliminate additional position A Review View Automate B C MS7-Financial_Template_Chisick S Search (Cmd + Ctrl + U) BD Comments Share v AutoSum Fill Clear Sort & Filter Find & Select Sensitivity Add-ins Analyze Data T U V W X Y Z AA AB AC Wrap Text General Normal Bad Good Neutral Calculation Merge & Center $ % 0 .00 0 Conditional Format Formatting as Table Check Cell Explanatory T... Input Linked Cell Note Insert Delete Format D E F G H | J K L M N O P 1 Cost-Benefit Summary Cost-Benefit Item Plan A: In-House Development Consultant time to develop system 2 3 4 5 6 Plan B: Purchase Vertical Software Package Purchase necessary software platform 7 Purchase price for vendor package Costs Benefits Description 16,800.00 4,200.00 Developmental Developmental 12,000.00 8 Tech support contract 600.00 9 Consultant time to install, configure, and test 5,600.00 10 Cost & Benefits Common to Both Plans 11 Hardware 12 Consultant training time 14 Eliminate overtime 12,500.00 4,500.00 13 Office staff maintenance, backup and updating 3,120.00 15 Eliminate additional position 16 Eliminate daily errors Developmental Operational After Year 1 Developmental Developmental Developmental Per Year Costs (prorate for 1st Year) 7,020.00 Operational (prorate for 1st Year) 31,200.00 Operational (prorate for 1st Year) 3,900.00 Operational (prorate for 1st Year) 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 0 R CostBenefitSummary Cost-Benefit + Ready Accessibility: Good to go BI A + 100% AutoSave Review View Automate MS7-Financial_Template_Chisick - Saved to my Mac Search (Cmd + Ctrl + U) AutoSum Fill Clear Sort & Filter Find & Select Sensitivity Add-ins Analyze Data BD Comments Share v T U V W X Y Z AA AB AC Wrap Text General Normal Bad Good Neutral Calculation Merge & Center $ % 0 Conditional .00 0 Format Formatting as Table Check Cell Explanatory T... Input Linked Cell Note Insert Delete Format B C D E F G H | J K L M N O P Q R Home Insert Draw Page Layout Formulas Data Cut Calibri (Body) 12 Copy Paste B I U A Format B23 fx A 1 10% 2 Discount Rate 3 4 Data For Plan A: In-House Development Year 0 Year 1 Year 2 Year 3 Year 4 5 6 Costs: Year 5 Total of Present Value 7 Consultant time to develop system 8 Purchase necessary software platform 9 Hardware 10 Consultant training time 16,800 0 4,200 0 12,500 0 4,500 0 OOOO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11 Office staff maintenance, backup and updating 1,560 3,120 3120 3120 3120 3120 12 13 14 Total Costs: Present Value Factor (10%) Present Value 37,860 3120 3120 3120 3120 3120 1.000 0.909 0.826 0.797 0.683 0.621 3786.000 2,836.08 2,577.12 2,486.64 2130.96 1,937.52 15 Benefits: 16 Eliminate overtime 17 Eliminate additional position 3,510 15600 7,020 7020 7020 7020 7020 31,200 31200 31200 31200 31200 18 Eliminate daily errors 1950 3,900 3900 3900 3900 3900 19 Total Benefits: 21060 42120 42120 42120 42120 42120 20 Present Value Factor (10%) 21 Present Value 22 NPV (Net Present Value) PV benefits - PV costs 1.000 2106.000 -16800.000 0.909 38287.08 -3832.92 0.826 34,791.12 -7328.88 0.797 0.683 0.621 33569.64 -8550.36 28,767.96 26,156.52 23 Cash Flow 24 ROI = (Total Benefits - Total Costs) / Total Costs 25 N 26 Data For Plan B: Purchase Vertical Software Package 27 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 28 Costs: 29 Purchase price for vendor package 12,000 0 0 0 0 0 30 Tech support contract 0 600 600 600 600 600 31 Consultant time to install, configure, and test 5,600 0 0 0 0 0 32 Hardware 12,500 0 0 0 0 0 33 Consultant training time 4,500 0 0 0 0 0 34 Office staff maintenance, backup and updating 0 3,120 3120 3120 3120 3120 35 36 Total Costs: Present Value Factor (10%) 37 Present Value 38 39 NPV (Net Present Value) PV benfits - PV costs Benefits: 34,600 1.000 3,460 -31140 3720 3720 3720 3720 3720 0.909 0.826 0.797 0.683 0.621 3381.48 3072.72 -338.52 -647.28 2964.84 -755.16 2540.76 -1,179.24 2310.12 -1,409.88 43 44 45 46 40 Eliminate overtime 41 Eliminate additional position 42 Eliminate daily errors Net Present Value Factor (10%) NPV Net Present Value N/A 3,510 7,020 7020 7020 7020 7020 15600 31,200 31200 31200 31200 31200 1950 3,900 3900 3900 3900 3900 Total Benefits: 42120 1 0.909 0.826 0.797 0.683 0.621 Present Value N/A 38287.08 -3832.92 47 Cash Flow N/A 48 ROI = (Total Benefits - Total Costs) / Total Costs N/A 49 50 51 52 53 54 55 56 57 58 59 60 61 62 CostBenefitSummary Cost-Benefit Ready Accessibility: Good to go S B + 100% AutoSave Formulas Data 12 A Home Insert Draw Page Layout Cut Calibri (Body) Copy Paste B I U Format A15 fx Eliminate additional position A Review View Automate B C MS7-Financial_Template_Chisick S Search (Cmd + Ctrl + U) BD Comments Share v AutoSum Fill Clear Sort & Filter Find & Select Sensitivity Add-ins Analyze Data T U V W X Y Z AA AB AC Wrap Text General Normal Bad Good Neutral Calculation Merge & Center $ % 0 .00 0 Conditional Format Formatting as Table Check Cell Explanatory T... Input Linked Cell Note Insert Delete Format D E F G H | J K L M N O P 1 Cost-Benefit Summary Cost-Benefit Item Plan A: In-House Development Consultant time to develop system 2 3 4 5 6 Plan B: Purchase Vertical Software Package Purchase necessary software platform 7 Purchase price for vendor package Costs Benefits Description 16,800.00 4,200.00 Developmental Developmental 12,000.00 8 Tech support contract 600.00 9 Consultant time to install, configure, and test 5,600.00 10 Cost & Benefits Common to Both Plans 11 Hardware 12 Consultant training time 14 Eliminate overtime 12,500.00 4,500.00 13 Office staff maintenance, backup and updating 3,120.00 15 Eliminate additional position 16 Eliminate daily errors Developmental Operational After Year 1 Developmental Developmental Developmental Per Year Costs (prorate for 1st Year) 7,020.00 Operational (prorate for 1st Year) 31,200.00 Operational (prorate for 1st Year) 3,900.00 Operational (prorate for 1st Year) 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 0 R CostBenefitSummary Cost-Benefit + Ready Accessibility: Good to go BI A + 100%