I need make an excel. I have an example, please follow the example. Change the company name the background and the industry; it doesn't need a clear name, so just a new york based starting company x would be fine, and as to the background, we are only doing 100 employees, as to the industry, just make up one, as long as it' an industry that uses computers and that sort of technology equipment.

As you can see from the example, at the end of the excel spreadsheet, you need to do three calculations to get the Net Present Value, the Benefit Cost Ratio and the Internal Rate of Return; The Net Present Value should be greater than $0, the Benefit Cost Ratio should be greater than $1, the Internal Rate of Return should be at least higher than $1

As for the calculations that you need to use to fill in the spreadsheet, please use 15% discount rate, 5 years' plan and reasonable cost on technology and equipment(that means, you can make up numbers for the spreadsheet and do the calculations from there, but please make up some reasonable numbers

Career Resource Center (CRC) - Cost/Benefit Analysis ASSUMPTIONS Company description Average salaries Reduced turnover Reduced training costs Allocated expenses PERIOD 0 1 2 3 4 2016 2017 2018 2019 2020 Total direct costs 0 0 0 0 0 Total salvage value 0 0 0 0 0 YEAR TOTAL ANNUAL SALARIES CAREER RESOURCE CENTER COSTS Plant and equipment Preliminary engineering Online training setup costs Information Security and Testing BENEFITS Reduced turnover costs Reduced training costs Total direct benefits EXPENSES On-site assistance Career counselor fees Allocated expenses Depreciation Total direct expenses Additional inc before tax Tax at 35% Additional inc after tax Add back depreciation After-tax cash flow 1 - FREE CASH FLOW 0 Discount Rate 15% Net Present Value @15% $0 Benefit Cost Ratio #DIV/0! Internal Rate of Return Err:523 0 0 Indirect benefits - higher morale, better company reputation, just-in-time training available Indirect costs - employees upset by moving lounge space into cafeteria, employees avoiding computers for training 2 0 0 5 2021 0 0 3 0 4 5 Career Resource Center (CRC) - Cost/Benefit Analysis ASSUMPTIONS Company description New York City-based bank with 5,000 employees Average salaries Reduced turnover $40,000 annually for 2017 with 2% annual increases Saving turnover costs of 20% of average salaries for 5% of staff (250 employees) assuming reduction of turnover from 10% to 5% annually Reduced training costs Saving $600 per employee in 2017 (from $1,200 to 600); expected to grow by 10% annaully Allocated expenses Shared costs of technical support, rent, utilities and security PERIOD YEAR 0 1 2 3 4 5 2016 2017 2018 2019 2020 2021 200,000,000 204,000,000 208,080,000 212,241,600 216,486,432 TOTAL ANNUAL SALARIES CAREER RESOURCE CENTER COSTS Plant and equipment -3,500,000 -1,600,000 Preliminary engineering -1,719,000 -400,000 -900,000 -350,000 Online training setup costs Information Security and Testing Total direct costs -800,000 -250,000 -6,919,000 0 0 -2,600,000 0 0 0 0 0 0 0 0 Reduced turnover costs 2,000,000 2,040,000 2,080,800 2,122,416 2,164,864 Reduced training costs 3,000,000 3,300,000 3,630,000 3,993,000 4,392,300 Total direct benefits 5,000,000 5,340,000 5,710,800 6,115,416 6,557,164 On-site assistance -40,000 -40,800 -41,616 -42,448 -43,297 Career counselor fees -50,000 -55,000 -60,500 -66,550 -73,205 Allocated expenses -10,000 -11,000 -12,100 -13,310 -14,641 Total salvage value BENEFITS EXPENSES Depreciation -700,000 -700,000 -700,000 -1,500,000 -1,500,000 Total direct expenses -800,000 -806,800 -814,216 -1,622,308 -1,631,143 4,200,000 4,533,200 4,896,584 4,493,108 4,926,021 -1,470,000 -1,586,620 -1,713,804 -1,572,588 -1,724,107 Additional inc after tax 2,730,000 2,946,580 3,182,780 2,920,520 3,201,914 Add back depreciation 700,000 700,000 700,000 1,500,000 1,500,000 3,430,000 3,646,580 3,882,780 4,420,520 4,701,914 3,430,000 3,646,580 1,282,780 4,420,520 4,701,914 Additional inc before tax Tax at 35% After-tax cash flow FREE CASH FLOW Discount Rate Net Present Value @15% -6,919,000 15% $4,529,524 Benefit Cost Ratio 1.65 Internal Rate of Return 39% Indirect benefits - higher morale, better company reputation, just-in-time training available Indirect costs - employees upset by moving lounge space into cafeteria, employees avoiding computers for training \fSuggested Resources American Society for Training and Development astd.org Businessweek businessweek.com Bloomberg (business news service) bloomberg.com CNBC (business network) cnbc.com CNN (cable news network) cnn.com Financial Times (financial news service) ft.com/home/us Investopedia Investopedia.com New York Times (Career Corner and Corner Office columns) nyt.com Society for Human Resources Management shrm.org New Jersey Star Ledger Newspaper (Job Finder section) nj.com/starledger Wall Street Journal wsj.com Company websites and career sections ASSESSMENT CENTER Michael Nguyen; Yiling Chen; Matthias Gregitis; Xinge INTRODUCTIO N NJArchitectural Company 100 employees Average salaries $47,000 annually for 2017 with 3.14% annual increases -- Company Information INTRODUCTIO N Training -- Functions Development On-boarding Tracking and Observation Coaching and Mentoring Intervie wing MODEL Cost PERIOD YEAR 0 1 2 3 4 5 2016 2017 2018 2019 2020 2021 0 0 COSTS Plant and equipment -600,640 -620,775 Preliminary engineering -218,000 -225,308 Online training setup costs -235,000 -242,878 Information Security and Testing -155,000 -160,196 Total direct costs -1,208,640 0 0 -1,249,156 Benefits Reduced turnover Reduced training costs Saving turnover costs of 16% of average salaries for 7% of staff (7 employees) assuming reduction of turnover from 8% to 3% annually Saving $200 per employee in 2017 (from $400 to 200); expected to grow by 12% annually BENEFITS Reduced turnover costs 752,000 801,613 854,499 910,874 970,969 Reduced training costs 20,000 22,400 25,088 28,099 31,470 772,000 824,013 879,587 Total direct benefits 938,973 1,002,439 Overall Cash Flow EXPENSES On-site assistance -40,000 -40,800 -41,616 -42,448 -43,297 -50,000 -55,000 -60,500 -66,550 -73,205 Allocated expenses Net Present Value (NPV) -10,000 -11,000 $4,529,524 -12,100 -13,310 -14,641 Depreciation -39,444 -39,444 -40,233 1.65 -40,233 -146,244 -153,660 -162,541 -171,376 677,769 725,927 39% 776,432 831,063 -6,349 -6,549 -6,754 -6,966 -7,185 Additional inc after tax 626,207 671,220 719,173 769,465 823,878 Add back depreciation -39,444 -39,444 -39,444 -40,233 -40,233 After-tax cash flow FREE CASH FLOW 586,763 631,776 679,729 729,233 783,645 Discount Rate Career counselor fees -39,444 Benefit Cost Ratio (BCR) Total direct expenses -139,444 Rate of Return (IRR) Additional inc beforeInternal tax 632,556 Tax at 35% -1,208,640 586,763 631,776 -569,427 15% 729,233 783,645 References https://www.google.com/intl/en/about/ https://www.officelovin.com/2014/09/27/look-i nside-ticketmasters-london-offices/ Yahoo Finance NASDAQ ASSESSMENT CENTER Michael Nguyen; Yiling Chen; Matthias Gregitis; Xinge INTRODUCTIO N NJArchitectural Company 100 employees Average salaries $47,000 annually for 2017 with 3.14% annual increases -- Company Information INTRODUCTIO N Training -- Functions Development On-boarding Tracking and Observation Coaching and Mentoring Intervie wing MODEL Cost PERIOD YEAR 0 1 2 3 4 5 2016 2017 2018 2019 2020 2021 0 0 COSTS Plant and equipment -600,640 -620,775 Preliminary engineering -218,000 -225,308 Online training setup costs -235,000 -242,878 Information Security and Testing -155,000 -160,196 Total direct costs -1,208,640 0 0 -1,249,156 Benefits Reduced turnover Reduced training costs Saving turnover costs of 16% of average salaries for 7% of staff (7 employees) assuming reduction of turnover from 8% to 3% annually Saving $200 per employee in 2017 (from $400 to 200); expected to grow by 12% annually BENEFITS Reduced turnover costs 752,000 801,613 854,499 910,874 970,969 Reduced training costs 20,000 22,400 25,088 28,099 31,470 772,000 824,013 879,587 Total direct benefits 938,973 1,002,439 Overall Cash Flow EXPENSES On-site assistance -40,000 -40,800 -41,616 -42,448 -43,297 -50,000 -55,000 -60,500 -66,550 -73,205 Allocated expenses Net Present Value (NPV) -10,000 -11,000 $4,529,524 -12,100 -13,310 -14,641 Depreciation -39,444 -39,444 -40,233 1.65 -40,233 -146,244 -153,660 -162,541 -171,376 677,769 725,927 39% 776,432 831,063 -6,349 -6,549 -6,754 -6,966 -7,185 Additional inc after tax 626,207 671,220 719,173 769,465 823,878 Add back depreciation -39,444 -39,444 -39,444 -40,233 -40,233 After-tax cash flow FREE CASH FLOW 586,763 631,776 679,729 729,233 783,645 Discount Rate Career counselor fees -39,444 Benefit Cost Ratio (BCR) Total direct expenses -139,444 Rate of Return (IRR) Additional inc beforeInternal tax 632,556 Tax at 35% -1,208,640 586,763 631,776 -569,427 15% 729,233 783,645 References https://www.google.com/intl/en/about/ https://www.officelovin.com/2014/09/27/look-i nside-ticketmasters-london-offices/ Yahoo Finance NASDA