use excel sheet Q1. Use table 1 to calculate1. Net Profit2. Pay Back Period3. Return on investment4. Net present value for the discount factor of 10 %5. Internal rate of returnTable 1. Projects' Cash Flow DetailsProjectProject ProjectProject ProjectYear13450 2000000 -100000 -120000 -150000-5000001500000200004000050000150000250000025000400005000015000035000001500030000500001000004500000500001000050000100000550000010000100002000010000020000 10000020000 100000350000-20000100007400000100001000085000001500010000200005000040000030000120001000050000102000004000050002000050000

Given that below table Answer 1) for net profit we add all profit

1. Net Profit 2. Pay Back Period 3. Return on investment 4. Net present value for the discount factor of 10 % 5. Internal rate of return Table 1. Projects' Cash Flow Details Project Project Project Project Project 1 2 Year 3 4 5 0 2000000 -100000 -120000 -150000 -500000 1 500000 20000 40000 50000 150000 25000 50000 150000 500000 500000 40000 15000 30000 50000 100000 4 500000 50000 10000 50000 100000 20000 100000 20000 100000 20000 100000 500000 10000 10000 6 350000 -20000 10000 7 400000 10000 10000 8. 500000 15000 10000 20000 50000 400000 30000 12000 10000 50000 10 200000 40000 5000 20000 50000

1. Net Profit 2. Pay Back Period 3. Return on investment 4. Net present value for the discount factor of 10 % 5. Internal rate of return Table 1. Projects' Cash Flow Details Project Project Project Project Project 1 2 Year 3 4 5 0 2000000 -100000 -120000 -150000 -500000 1 500000 20000 40000 50000 150000 25000 50000 150000 500000 500000 40000 15000 30000 50000 100000 4 500000 50000 10000 50000 100000 20000 100000 20000 100000 20000 100000 500000 10000 10000 6 350000 -20000 10000 7 400000 10000 10000 8. 500000 15000 10000 20000 50000 400000 30000 12000 10000 50000 10 200000 40000 5000 20000 50000

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What steps are involved in gathering and compiling data for input?
Define report header
Please submit an Excel file that may be used to calculate imputed interest and taxable social security benefits. The spreadsheet should include formulae to help with the computations.
what are the names of the entities in the system?
Is there a specific technique for processing data? (Please provide specifications.)
what are the names of the entities in the system?
Salesforce Please describe the details when we receive the SOQL 201 Issue in the code. Salesforce Development
What are the principles behind cyclic redundancy checks?
pls code this in python
Quick Answer Please