Đã Đóng

Project Business Case template in Excel

I would like to get an Excel-based business case template that allows us to determine ROI on technology investment projects (I.e. building a data warehouse, custom software development, etc). The template would need a summary page that can easily be copied to PowerPoint if needed (example summary screenshot attached) . The spreadsheet also needs a tab for key assumptions (discount rate, capitalization term, capitalization minimum, etc). The template will need another tab to enable entry of costs, benefits (financial and non/financial), and capital expenses over a times series of 3-5 years on a separate tab. The data entry tab needs to be structured as follows:

• Allow for entry of cash and/or capital costs (labor, license, etc) on as monthly basis for up to 24 months

• Allow for entry of ongoing expenses on an annual basis (I.e. yearly license or maintenance)

• Benefits on a yearly basis for 5 years

The data entry page should have a section of rows for key common costs and allow for the addition of rows without breaking calculations (each of these could be more than one row):

• Hardware/cloud resources (storage, compute, etc)

• Software license / maintenance

• People (associate, consultant, contract) resources to build processes and capabilities

• Other (catch all for any other expenses not called out above)

The data entry page should have a section of rows for categories of financial benefits and allow for the addition of rows without breaking calculations (each of these could be more than one row):

• Revenue increases (new clients, better retention, new products, etc)

• Reduced costs (headcount reduction, license reduction, maintenance reduction, etc)

• Lower losses (credit loss, fraud, claims, etc).

• Better use of cash (I.e. timing, lower reserves, etc)

• Other (catch all for any benefits not called out above)

The data entry page should also have a section to capture key non-financial benefits we can show on the summary page such as:

• Employee satisfaction

• Customer satisfaction

• Regulatory Compliance

From a calculation and chart perspective, the summary page would need the following:

• Break even period (months)


• Net Present Value

• Chart of annual cash flows

• Chart of internal versus external expenses

Kĩ năng: Excel, Nhập liệu

Về khách hàng:
( 0 nhận xét ) Silver Spring, United States

ID dự án: #33562507

43 freelancer chào giá trung bình$452 cho công việc này


Hi, I am ready to start right now ! Ok understood, Honestly, since I don't have a job at the moment, this would mean a lot to me, and I have free time.. * I assure you of smooth communication and high-quality work. * Thêm

$500 USD trong 7 ngày
(156 Nhận xét)
(193 Nhận xét)
(36 Nhận xét)

"Sir, You will get Business case template I am Excel, Accounting, Finance Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with mor Thêm

$250 USD trong 1 ngày
(175 Nhận xét)
(44 Nhận xét)
(136 Nhận xét)

Here sir, I have read your job decription very very carefully, I am expert in creating customize templates.I have scatched your excel spreasheet into my mind based on your requirement... I would love to implement all t Thêm

$300 USD trong 3 ngày
(28 Nhận xét)

''Business Case template in Excel'' Hi, this is Bryson Henniger here. I can't see the example summary screenshot that you're referring. Could you please share it over the chat box? Please dissect my precursory case fl Thêm

$400 USD trong 10 ngày
(5 Nhận xét)

Hi As a financial analyst, I have helped many businesses with creating their business models and cases. I got extensive exposure of the industry and can show my past models to you to gain your confidence. I am well Thêm

$750 USD trong 7 ngày
(9 Nhận xét)
(3 Nhận xét)

Hello, I am a PhD Industrial Engineer and apart my Engineering experience I also have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrams, Thêm

$500 USD trong 7 ngày
(10 Nhận xét)

Hi there, I have read your project entitled “Project Business Case template in Excel ” I am a Certified Chartered Accountant and a duly certified mentor of ACCA (UK). I have already done numerous projects of this sort Thêm

$500 USD trong 7 ngày
(10 Nhận xét)

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta Thêm

$250 USD trong 1 ngày
(9 Nhận xét)

Hi, I will be happy to do the needful! Please see reviews of similar projects on my profile. Regards, Furqan

$500 USD trong 7 ngày
(3 Nhận xét)

i seen the details which u wrote in project and understand your requirement sir please inbox with me so i can ask some important questions and do as u need sir please award me and discuss with me please

$500 USD trong 7 ngày
(2 Nhận xét)
(1 Nhận xét)

Hi, I am a very talented software programmer with 13+ years of development experience (5+ years professional work experience). I am a results-oriented professional and possess experience using cutting-edge development Thêm

$500 USD trong 5 ngày
(1 Nhận xét)

Hi I had read your requirement and i can create automation project business case templates in excel through vba macros. I have 5+ years of experience in this field. I had done similar projects. Im expert in advanced ex Thêm

$250 USD trong 7 ngày
(5 Nhận xét)

Hey, I read about your project details and can easily create a excel business case template for it. I come with 8+ years of experience in project financing. Can start immediately.

$700 USD trong 7 ngày
(1 Nhận xét)

Good afternoon, my name is Víctor de la Rosa. For the day, I will satisfy your needs. I have the necessary bases to carry out your project. If you wish, we can speak internally to discuss the matter.

$400 USD trong 3 ngày
(0 Nhận xét)