using a project valuation method OR feasibility study approach, a risk analysis and a cost-benefit analysis

profilelymjhx
CBA-Lahey.doc.xlsx
Home>Business & Finance homework help>Management homework help>using a project valuation method OR feasibility study approach, a risk analysis and a cost-benefit analysis

CBA Cost Breakdown

Project Name
Project Costs Current Yr Assumptions
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Total
Hardware $ - 0 Define CAPEX vs. OPEX
Computer Hardware
Hard Drives
Desktops
Laptops
Printers
Monitors
Maintenance
Other
Total Hardware $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Software $ - 0
Internal Labor (Development) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Application $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
System $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Operating Software $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Communication Software $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
License Fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Software Leases $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Maintenance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Software $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Depreciation Impact
Outside Contractors
Travel Hardware $ - 0
Training Software $ - 0
Internal Labor Labor to install $ - 0
Facility Space-desks, etc
Advertising Total Depreciable Amt $ - 0
Postage Depreciation years 3
Other Depreciation / year $ - 0
Other
Total Other Costs
Total All Costs
Benefits/Savings
Increased Revenue
New Revenue
Increased Profitability for Products/Services
Process Reductions
Lowered Administrative Costs
Increased Cash Flow
Error Rate Reductions
Other
Total all Benefits/Savings $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

&G

Page &P

ROI

Target ROI 15.00% Current Yr Year 1 Year 2 Year 3 Year 4 Year 5
Time Period 0 1 2 3 4 5
Costs
Computer Hardware $0 $0 $0 $0 $0 $0
Hard Drives $0 $0 $0 $0 $0 $0
Desktops $0 $0 $0 $0 $0 $0
Laptops $0 $0 $0 $0 $0 $0
Printers $0 $0 $0 $0 $0 $0
Monitors $0 $0 $0 $0 $0 $0
Maintenance $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0
Total Hardware $0 $0 $0 $0 $0 $0
Application $0 $0 $0 $0 $0 $0
System $0 $0 $0 $0 $0 $0
Operating Software $0 $0 $0 $0 $0 $0
Communication Software $0 $0 $0 $0 $0 $0
License Fees $0 $0 $0 $0 $0 $0
Software Leases $0 $0 $0 $0 $0 $0
Maintenance $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0
Total Software $0 $0 $0 $0 $0 $0
Outside Contractors $0 $0 $0 $0 $0 $0
Travel $0 $0 $0 $0 $0 $0
Training $0 $0 $0 $0 $0 $0
Internal Labor $0 $0 $0 $0 $0 $0
Facility Space-desks, etc $0 $0 $0 $0 $0 $0
Advertising $0 $0 $0 $0 $0 $0
Postage $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0
Total Other $0 $0 $0 $0 $0 $0
Total Costs $0 $0 $0 $0 $0 $0
Savings $0 $0 $0 $0 $0 $0
Increased Revenue $0 $0 $0 $0 $0 $0
New Revenue $0 $0 $0 $0 $0 $0
Increased Profitability for Products/Services $0 $0 $0 $0 $0 $0
Process Reductions $0 $0 $0 $0 $0 $0
Lowered Administrative Costs $0 $0 $0 $0 $0 $0
Increased Cash Flow $0 $0 $0 $0 $0 $0
Error Rate Reductions $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0
Total Benefits & Savings $0 $0 $0 $0 $0 $0
Tax impact of Depreciation $0 $0 $0 $0 $0
Summary Current Yr Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flow Time Period 0 1 2 3 4 5
Total Costs $0 $0 $0 $0 $0 $0
Tax Rate Total Benefits & Savings $0 $0 $0 $0 $0 $0
20.00% Gross Cash Flow $0 $0 $0 $0 $0 $0
Taxes $0 $0 $0 $0 $0
Add Impact of Depreciation $0 $0 $0 $0 $0
After Taxes $0 $0 $0 $0 $0
Cash flow by year $0 $0 $0 $0 $0 $0
Net Present Value (NPV) $0 $0 $0 $0 $0 $0
Annual ROI ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
5-Year ROI ERROR:#DIV/0!
Payback Years ERROR:#DIV/0!
5-year IRR ERROR:#NUM!
5-year NPV 0
Cum NPV/Total Costs ERROR:#REF!
Target ROI 15%
Actual ROI ERROR:#NUM!
Above Below Target ERROR:#NUM!
Payback Years ERROR:#DIV/0!

&G

Budget Impact

Budget Impact
20.12 2013 2014 2015 Assumptions
Additional Costs
Computer Hardware
Hard Drives
Desktops
Laptops
Printers
Monitors
Phones
Leases
Maintenance
Other
Other
Total Hardware $ - 0 $ - 0 $ - 0 $ - 0
Application
System
Operating Software
Communication Software
License Fees
Software Leases
Maintenance
Other
Other
Total Software $ - 0 $ - 0 $ - 0 $ - 0
Outside Contractors
Travel
Training
Internal Labor
Facility Space-desks, etc
Advertising
Postage
Depreciation on Capital Expenses
Other
Other
Total Other Costs $ - 0 $ - 0 $ - 0 $ - 0
Total All Costs $ - 0 $ - 0 $ - 0 $ - 0
Benefits/Savings
Increased Revenue
New Revenue
Increased Profitability for Products/Services
Claims Payable Reductions
Lowered Administrative Costs
Increased Cash Flow
Error Rate Reductions
Other
Other
Total all Benefits/Savings $ - 0 $ - 0 $ - 0 $ - 0
Net Budget Impact $ - 0 $ - 0 $ - 0 $ - 0

&G

&N

Standard Rates

Standard Rates to use in Development of Cost/Benefit Analysis
Hardware
Personal Computers-Laptops $ 2,400
Personal Computers-Desktops
Flat Screen Monitors
Servers
Maintenance 15% of purchase cost (unless quote exists from vendor)
Software
MS Project $ 600
Visio $ 300
MS Office Suite
Maintenance 15% of purchase cost (unless quote exists from vendor)
Other
Training Cost (Outside Training) $1000/day
Training Cost (Lahey Provided) $55/hour
Travel Related-Hotel $150/night
Travel Related-Meals $75/day
Lahey (internal) Labor $55/hr (fully loaded)
Fringe Cost 33%
Sr. Project Manager $26000/mth
Healthcare Consulting $26000/mth
Lahey IT Labor (General) $100/hr

&G

&N