COST BENEFIT ANALYSIS (ROI and NPV) TEMPLATE FOR SOFTWARE PROJECTS ITEM BENEFITS Numerous security/data/integration Reduced Inventory...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
COST BENEFIT ANALYSIS (ROI and NPV) TEMPLATE FOR SOFTWARE PROJECTS ITEM BENEFITS Numerous security/data/integration Reduced Inventory Costs Total Benefits Present Value (PV) of Benefits Cumulative PV of All Benefits DEVELOPMENT COSTS Development Server Training Software Licenses Server Software Development Labor Total Development Costs OPERATIONAL COSTS Forms Server Operational Labor TOTAL OPERATIONAL COSTS TOTAL COSTS Present Value (PV) of Costs Cumulative PV of All Costs TOTAL BENEFITS - TOTAL COSTS Yearly NPV Cumulative NPV ROI NPV (Net Present value) Break-even Point Intangible Benefits $ $ 6A 15n S $ $ $ 69 69 $ 69 196 $ $ $ LA LA LA L $ 69 $ $ $ SSS $ SSS 2007 (S) 62,000.00 $ 30,000.00 $ 92,000.00 $ 84,403.67 $ 84,403.67 S 18,700.00 14,000.00 15,650.00 94,925.00 143,275.00 $ 3,300.00 $ 1,520.00 $ 9,050.00 $ 13,870.00 S 157,145.00 $ 144,169.72 $ 144,169.72 $ (65,145.00) S (59,766.06) S (59,766.06) S 2008 (S) YEAR 68,200.00 $ 30,000.00 $ 98,200.00 $ 82,652.98 $ 167,056.65 $ $ 3,300.00 $ 1,520.00 $ 9,050.00 $ 13,870.00 $ 13,870.00 $ 11,674.10 $ 155,843.83 $ 84,330.00 $ 70,978.87 $ 11,212.82 $ 2009 (S) 75,020.00 $ 30,000.00 $ 105,020.00 $ 81,094.71 S 248,151.35 $ S 3,300.00 $ 1,520.00 $ 9,050.00 $ 13,870.00 $ 13,870.00 S 10,710.18 S 166,554.01 $ 91,150.00 S 70,384.52 S 81,597.34 S 2010 (S) 82,522.00 30,000.00 112,522.00 79,713.42 327,864.78 3,300.00 1,520.00 9,050.00 13,870.00 13,870.00 9,825.86 176,379.87 98,652.00 69,887.56 151,484.91 Improved security and data integration which is currently offered from ot S SSSS S S S S $ S $ S S $ $ 2011 ($) 90,774.20 30,000.00 120,774.20 78,494.94 $ 406,359.72 3,300.00 1,520.00 9,050.00 13,870.00 13,870.00 9,014.55 $ 185,394.42 106,904.20 69,480.39 $ 220,965.30 ther companies S Total ($) 406,359.72 185,394.42 220,965.30 1.19 1.84 Development Costs: Personnel 2 Systems Analysts 400 hours/ea @ $50/hour 4 Programmer Analysts 250 hours/ea @ $35/hour 1 GUI Designer 200 hours/ea @ $40/hour 1 Telecommunications Specialist 50 hours/ea @ $50/hour 1 System Architect 100 hours/ea @ $50/hour 1 Database Specialist 15 hours/ea @ $45/hour 1 System Librarian 250 hours/ea @ $15/hour Development Costs: Training 4 team members need Oracle training registration @ $3,500/person Development Costs: New Hardware and Software 1 Development server $18,700 1 Server software (OS, misc.) $1,500 1 DBMS server software $7,500 7 DBMS client software $950/client Annual Operating Costs: Personnel 2 Programmer Analysts 125 hours/ea @ $35/hour 1 System Librarian 20 hours/ea @ $15/hour Annual Operating Costs: Hardware, Software, and Miscel 1 Maintenance agreement for server $995 1 Maintenance agreement for server $525 Pre-printed forms 15,000/year @ $0.22/form The benefits of the new system are expected to come from a few sources: data consistency, increased integration with suppliers, and improved security. These benefits are estimated to be $62,000 in the first year of the system's operation and will grow at a rate of 10% each year thereafter. An additional benefit from the system is based on lower inventory levels (due to improved integration). Savings from lower inventory levels are expected to be $30,000 per year for each year of the project's life. Using a format similar to the cost-benefit analysis spreadsheet (given in the resources) that summarizes this project's cash flow and assuming a five-year useful life after the project is developed, develop a cost- benefit analysis of the project. Compute the present value of the cash flows using an interest rate of 9%. What is the NPV for this project? What is the ROI for this project? What is the break-even point? Based on the economic analysis, should this project be approved to proceed further? COST BENEFIT ANALYSIS (ROI and NPV) TEMPLATE FOR SOFTWARE PROJECTS ITEM BENEFITS Numerous security/data/integration Reduced Inventory Costs Total Benefits Present Value (PV) of Benefits Cumulative PV of All Benefits DEVELOPMENT COSTS Development Server Training Software Licenses Server Software Development Labor Total Development Costs OPERATIONAL COSTS Forms Server Operational Labor TOTAL OPERATIONAL COSTS TOTAL COSTS Present Value (PV) of Costs Cumulative PV of All Costs TOTAL BENEFITS - TOTAL COSTS Yearly NPV Cumulative NPV ROI NPV (Net Present value) Break-even Point Intangible Benefits $ $ 6A 15n S $ $ $ 69 69 $ 69 196 $ $ $ LA LA LA L $ 69 $ $ $ SSS $ SSS 2007 (S) 62,000.00 $ 30,000.00 $ 92,000.00 $ 84,403.67 $ 84,403.67 S 18,700.00 14,000.00 15,650.00 94,925.00 143,275.00 $ 3,300.00 $ 1,520.00 $ 9,050.00 $ 13,870.00 S 157,145.00 $ 144,169.72 $ 144,169.72 $ (65,145.00) S (59,766.06) S (59,766.06) S 2008 (S) YEAR 68,200.00 $ 30,000.00 $ 98,200.00 $ 82,652.98 $ 167,056.65 $ $ 3,300.00 $ 1,520.00 $ 9,050.00 $ 13,870.00 $ 13,870.00 $ 11,674.10 $ 155,843.83 $ 84,330.00 $ 70,978.87 $ 11,212.82 $ 2009 (S) 75,020.00 $ 30,000.00 $ 105,020.00 $ 81,094.71 S 248,151.35 $ S 3,300.00 $ 1,520.00 $ 9,050.00 $ 13,870.00 $ 13,870.00 S 10,710.18 S 166,554.01 $ 91,150.00 S 70,384.52 S 81,597.34 S 2010 (S) 82,522.00 30,000.00 112,522.00 79,713.42 327,864.78 3,300.00 1,520.00 9,050.00 13,870.00 13,870.00 9,825.86 176,379.87 98,652.00 69,887.56 151,484.91 Improved security and data integration which is currently offered from ot S SSSS S S S S $ S $ S S $ $ 2011 ($) 90,774.20 30,000.00 120,774.20 78,494.94 $ 406,359.72 3,300.00 1,520.00 9,050.00 13,870.00 13,870.00 9,014.55 $ 185,394.42 106,904.20 69,480.39 $ 220,965.30 ther companies S Total ($) 406,359.72 185,394.42 220,965.30 1.19 1.84 Development Costs: Personnel 2 Systems Analysts 400 hours/ea @ $50/hour 4 Programmer Analysts 250 hours/ea @ $35/hour 1 GUI Designer 200 hours/ea @ $40/hour 1 Telecommunications Specialist 50 hours/ea @ $50/hour 1 System Architect 100 hours/ea @ $50/hour 1 Database Specialist 15 hours/ea @ $45/hour 1 System Librarian 250 hours/ea @ $15/hour Development Costs: Training 4 team members need Oracle training registration @ $3,500/person Development Costs: New Hardware and Software 1 Development server $18,700 1 Server software (OS, misc.) $1,500 1 DBMS server software $7,500 7 DBMS client software $950/client Annual Operating Costs: Personnel 2 Programmer Analysts 125 hours/ea @ $35/hour 1 System Librarian 20 hours/ea @ $15/hour Annual Operating Costs: Hardware, Software, and Miscel 1 Maintenance agreement for server $995 1 Maintenance agreement for server $525 Pre-printed forms 15,000/year @ $0.22/form The benefits of the new system are expected to come from a few sources: data consistency, increased integration with suppliers, and improved security. These benefits are estimated to be $62,000 in the first year of the system's operation and will grow at a rate of 10% each year thereafter. An additional benefit from the system is based on lower inventory levels (due to improved integration). Savings from lower inventory levels are expected to be $30,000 per year for each year of the project's life. Using a format similar to the cost-benefit analysis spreadsheet (given in the resources) that summarizes this project's cash flow and assuming a five-year useful life after the project is developed, develop a cost- benefit analysis of the project. Compute the present value of the cash flows using an interest rate of 9%. What is the NPV for this project? What is the ROI for this project? What is the break-even point? Based on the economic analysis, should this project be approved to proceed further?
Expert Answer:
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these accounting questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Sketch the graph of the function and state its domain. f (x) = ln |x|
-
Revise this message so that it follows this chapter's guidelines. I'm writing to let you know about my availability for the brand manager job you advertised. As you can see from my enclosed...
-
Examine the empirical evidence on the benefits and costs of currency pegs. First, identify the potential costs and benefits, and then evaluate each based on the empirical analysis presented in the...
-
True or False: If \(E R R>M A R R\), then MIRR \(>\) MARR.
-
(Determine Proper Amounts in Account Balances) Presented below are three independent situations. (a) Chinook Corporation incurred the following costs in connection with the issuance of bonds: (1)...
-
Describe Edgar F. Codd's accomplishments and contributions to the relational model.?
-
Sixty-two percent of cancer survivors are ages 65 years or older. You randomly select six cancer survivors and ask them whether they are 65 years of age or older. Construct a probability distribution...
-
Financing Decisions and Firm Value What rule should a firm follow when making financing decisions? How can firms create valuable financing opportunities?
-
WACC and Taxes If I use the after-tax cost of debt for my project analysis then I should use the after-tax cost of equity as well. Do you agree with this statement? Explain.
-
Eurasian Natural Resources plc, a Kazakhstani firm listed on the London Stock Exchange, has total non-current assets of $4,938 million. Non-current liabilities are $1,038 million. Current assets,...
-
Preference shares do not offer a corporate tax shield on the dividends paid. Why do we still observe some firms issuing preference shares?
-
Explain what is meant by the cost of equity capital. How is the cost of equity capital linked to the risk of the assets of a firm? How would you use cost of equity in a capital budget analysis?
-
Complete the following tables: Speech Form Term Description Example Loose Association Incoherence Tangentially Illogical Speech Clang association The poverty of content of speech Neologism...
-
What tools are available to help shoppers compare prices, features, and values and check other shoppers opinions?
-
Kentwood Electronics manufactures three components for stereo systems: CD players, tape decks, and stereo tuners. The wholesale price and manufacturing cost of each item are shown in the following...
-
When interest rates decline, Patriot Bank has found that they get inundated with requests to refinance home mortgages. To better plan its staffing needs in the mortgage processing area of its...
-
a. Create a network flow model for this problem. (Consider inserting intermediate nodes in your network to assist in meeting the minimum monthly purchase restrictions for each supplier and the...
-
Haydn is a postgraduate MSc Management and Entrepreneurship student and as part of his studies he needs to complete a research project. Haydn has set his sights on studying a concept called 'entre-...
-
You have decided to undertake a project and have defined the main research question as What are the opinions of consumers on a 10 per cent reduction in weight, with the price remaining the same, of...
-
What are the characteristics of access and why is it important to differentiate between them?
Study smarter with the SolutionInn App