Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the following data, calculate the Net Present Value and ROI Project Benefit Expectations Benefits Year o Year 1 Year 2 Year 3 Greater margin

Using the following data, calculate the Net Present Value and ROI

image text in transcribedimage text in transcribed

Project Benefit Expectations Benefits Year o Year 1 Year 2 Year 3 Greater margin driven by higher production capacity $500,000 $1,500,000 $1,950,000 Improved logistics: Reduced AR receivable time 125,000 155,000 175,000 Improved Inventory Tracking 500,000 590,000 570,000 Fewer accidents, resulting in less workers' compensation 100,000 140,000 130,000 Improved quality benefits: Fewer defects, resulting in fewer warrenty cost 250,000 350,000 350,000 Fewer customer returns, resulting in less reprocessing costs 50,000 79,000 79,000 50,000 79,000 79,000 $0 Reduced time spent handling customer complaints Costs Initial investment Implementation costs Ongoing support costs Training costs Other costs $1,300,000 440,000 0 $0 0 0 $0 0 100,000 35,000 0 60,000 100,000 25,000 0 100,000 35,000 0 0 YEAR 1 $500,000 2 $1,000,000 3 $1,250,000 125,000 500,000 100,000 125,000 500,000 100,000 125,000 500,000 100,000 250,000 50,000 50,000 300,000 75,000 75,000 300,000 75,000 75,000 Capital budgeting-return-on-investment (ROI) analysis Data cell key User data entry or item description Formula cells: Totals are calculated and filled in automatically. Investment overview Project name: Project sponsor: Date of request: General description of benefits: Cash flow and ROI statement BENEFIT DRIVERS Greater margin driven by higher production capacity Improved cycle time benefits: Reduced energy cost due to less running time Reduced labor cost due to less running time Fewer accidents, resulting in less workers' compensation Improved quality benefits: Fewer defects, resulting in less rework Fewer customer returns, resulting in less reprocessing costs Reduced time spent handling customer complaints Capital budgeting-return-on-investment (ROI) analysis Data cell key User data entry or item description Formula cells: Totals are calculated and filled in automatically. Investment overview Project name: Project sponsor: Date of request: General description of benefits: Cash flow and ROI statement BENEFIT DRIVERS Greater margin driven by higher production capacity Improved cycle time benefits: Reduced energy cost due to less running time Reduced labor cost due to less running time Fewer accidents, resulting in less workers' compensation Improved quality benefits: Fewer defects, resulting in less rework Fewer customer returns, resulting in less reprocessing costs Reduced time spent handling customer complaints

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Theory And Practice

Authors: Prasanna Chandra

11th Edition

9355322208, 978-9355322203

More Books

Students also viewed these Finance questions