Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a financial analysis of your project using NPV in an Excel spreadsheet. Include the Excel file to this submission, and a screenshot of the

Create a financial analysis of your project using NPV in an Excel spreadsheet. Include the Excel file to this submission, and a screenshot of the NPV table to this file.

The following NPV items are calculated as follow:

The initial investment in year 0: 250K Discount rate per year: 8% Capital Expenses: Itemize and add all devices cost per year Capital depreciation: 10% of the sum of total capital in previous years Operation Expenses: You need to itemize and estimate these expenses per year Revenue: You need to estimate the business revenue per year because using the network

Devices Price Quantity Amount
Routers $3,900 3 11700
Switches $3,600 4 14400
Firewalls $3,300 2 6600
IDS $8,000 2 16000
Desktops $699 18 12582
Laptops $650 6 3900
IP-phones $40 10 400
Servers $2,300 4 9200
Printers $400 2 800

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

Mergers Acquisitions And Other Restructuring Activities

Authors: Donald DePamphilis

11th Edition

012819782X, 978-0128197820

More Books

Students also viewed these Finance questions

Question

What provisions should be made for dispute resolution?

Answered: 1 week ago