Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started