Scribd
Upload
9 views31 pages

Invesment Analysis

pdf

Uploaded by

keshav181
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
9 views31 pages

Invesment Analysis

pdf

Uploaded by

keshav181
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

investment Analysis

Product
Author
Company
Telephone
Fax
Email:

Investment Analysis
Alastair Day
Systematic Finance
9876543210
9876543210
Info@[Link]

Objective Investment Analysis Feature (Calculation of NPV)


File Name: New Microsoft Excel -Investment analysis
Version
v1.0 30-Jun-2007
Select

Combo Workings
Menu
Original
Formats
Number_Formats
Layout
Borders
Colours
Input_Colours
Validation_List
Validation_ComboBox
Scroll_Bar
Conditional_Formatting
NPV_Function
Add-In_Functions
Text

Dynamic_Graph
Data_Tables

Present Value
0

Capital Value
Cash Flows

###
28000

28000

28000

28000

28000

Total

### 28000

28000

28000

28000

28000

Factor

1.00

0.91

0.83

0.75

0.68

0.62

Net Cash Flo

### 25455

23140

21037

19124

17386

NPV

6142

Present Value
Capital Value
Preiodic Cash Flow
Discount Rate

100,000.00
28,000.00
10%

Management Summary
NPV
6,142.03

Capital Value
Cash Flows

($100,000.00)

Total

($100,000.00) 28,000.00 28,000.00 28,000.00 28,000.00

Factor
Net Cash Flow
NPV

28,000.00 28,000.00 28,000.00 28,000.00

1.00

0.91

0.83

0.75

0.68

($100,000.00) 25,454.55 23,140.50 21,036.81 19,124.38


6,142.03

nt Summary

28,000.00
28,000.00
0.62
17,385.80

Title

Inputs

Calculations

Answer

Workings

Management Summary

Present Value
Capital Value
Preiodic Cash Flow
Discount Rate

100,000.00
28,000.00
10.00%

0.00

1.00

2.00

28,000.00

28,000.00

Capital Value
Cash Flows

-100,000.00

Total

-100,000.00

28,000.00

28,000.00

1.00

0.91

0.83

-100,000.00

25,454.55

23,140.50

Factor
Net Cash Flow
NPV

6,142.03

Management Summary
NPV
6,142.03

3.00

4.00

5.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

0.75

0.68

0.62

21,036.81

19,124.38

17,385.80

Present Value

Capital value

100,000.00

Periodic cash flo

Management Summary

28,000.00

NPV

6,142.03

Discount rate:

Capital valu (100,000.00)


Periodic cash flow

28,000.00

28,000.00

28,000.00

Total

28,000.00

28,000.00

28,000.00

0.91

0.83

0.75

25,454.55

23,140.50

21,036.81

(100,000.00)

Factor

1.00

Net cash flow

NPV

(100,000.00)

6,142.03

Workings

interval

0.50%
8%

8.50%
9.00%
9.50%
10.00%
10.50%
11.00%
11.50%
12.00%

10.00%

28,000.00

28,000.00

28,000.00

28,000.00

0.68

0.62

19,124.38

17,385.80

Present Value

Capital value
Periodic cash f

100,000.00

Management Summary

28,000.00

NPV

3,485.12

Select
Discount rate:

11.00%
0

Capital val (100,000.00)


Periodic cash flow
28,000.00

28,000.00

28,000.00

28,000.00

Total

28,000.00

28,000.00

28,000.00

0.90

0.81

0.73

0.66

25,225.23

22,725.43

20,473.36

18,444.47

(100,000.00) 28,000.00

Factor

1.00

Net cash flow

NPV

(100,000.00)

3,485.12

Workings
0.50%
8%

8.50%
9.00%
9.50%
10.00%
10.50%
11.00%
11.50%
12.00%

11.00%

28,000.00
28,000.00
0.59
16,616.64

Present Value

Capital value

100,000.00

Periodic cash f

28,000.00

Minimum NPV

7,000.00

Discount rate:

Management Summary

2,196.58

NPV

10.00%
0

Capital val (100,000.00)


Periodic cash flow

28,000.00

28,000.00

28,000.00

28,000.00

Total

28,000.00

28,000.00

28,000.00

28,000.00

0.90

0.80

0.72

0.65

25,112.11

22,522.07

20,199.17

18,115.84

(100,000.00)

Factor

1.00

Net cash flow

(100,000.00)

2,196.58

NPV

Workings
0.50%
8%

8.50%
9.00%
9.50%
10.00%
10.50%
11.00%
11.50%
12.00%

12%

28,000.00
28,000.00
0.58
16,247.39

Present Value

Capital value

100,000.00

Periodic cash f

28,000.00

Minimum NPV

7,000.00

Management Summary

7,511.85

NPV

Discount rate:

Capital val (100,000.00)


Periodic cash flow
28,000.00
Net cash flow

(100,000.00)

7,511.85

NPV

Workings

interval

0.50%
8%

8.50%
9.00%
9.50%
10.00%
10.50%
11.00%
11.50%
12.00%

9.50%

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00
28,000.00

Present Value

Capital value

100,000.00

Periodic cash f

28,000.00

Minimum NPV

7,000.00

Start Date

1/1/2010

Management Summary

###

NPV

Interval
Discount rate:

1-Jan-10
1-Jan-11
1-Jan-12
1-Jan-13
1-Jan-14
Capital val (100,000.00)
Periodic cash flow
28,000.00 28,000.00 28,000.00 28,000.00
Net cash flow

(100,000.00)

28,000.00

28,000.00

28,000.00

28,000.00

12
4
2
1

4
1
12

10,337.98

NPV

Workings

Interval

0.50%
8%

8.50%
9.00%
9.50%
10.00%
10.50%
11.00%
11.50%
12.00%

8.50%

Monthly
Quaterly
Bi-Annual
Annual

1-Jan-15
28,000.00
28,000.00

Present Value

Capital value

100,000.00

Periodic cash f

28,000.00

Minimum NPV

7,000.00

Start date

1-Jan-10

Management Summary

###

NPV at 9.50%
NPV is above the limit of 7000

interval
Discount rate:

1-Jan-10

01-Jan-11

1-Jan-12

1-Jan-13

1-Jan-14

Capital val (100,000.00)


Periodic cash flow
28,000.00
Net cash flow

NPV at 8.50%

(100,000.00)

37,071.90

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

28,000.00

NPV is above the limit of 7,000

Workings

Interval

0.50%
8%

0.71%
8.50%
9.00%
9.50% Annual Rate:
8.50%
10.00%
10.50%
11.00%
11.50%
12.00%

Monthly
Quarterly
Bi-annual
Annual

12
4
2
1

1
12
1

5
1-Jan-15

28,000.00
28,000.00

Presnet Value

Capital value

100,000.00

Periodic cash f

Management Summary

28,000.00

Minimum NPV

7,000.00

Start Date

1-Jan-10

###

NPV at 8.50%
NPV is above the limit of 7,000

Interval
Discount rate:

1-Jan-10

1-Apr-10

1-Jul-10

1-Oct-10

1-Jan-11

Capital val 100,000.00


Periodic cash flow
28,000.00

28,000.00

28,000.00

28,000.00

Net cash flow

(100,000.00)

28,000.00

28,000.00

28,000.00

28,000.00

Cumulative tota

(100,000.00)

(72,000.00)

(44,000.00)

(16,000.00)

12,000.00

###

NPV at 8.50%

NPV is above the limit of 7,000

Cumulative total

60,000.00
40,000.00
20,000.00
(20,000.00)
(40,000.00)
(60,000.00)
(80,000.00)
(100,000.00)
(120,000.00)

Workings

Cumulative tota

Interval

Monthly
Quarterly
Bi-annual
Annual

0.50%
8%

8.50%
9.00%
9.50% Annual rate:
8.50%
10.00%
10.50%
11.00%
11.50%
12.00%

2.13%

Documentation
Version number
Author
Company
Telephone

v1.0 30-Jun-2007
Alastair Day
Systematic Finance plc
Tel: +44 (0)1483 532929

12
4
2
1

4
4
3

5
1-Apr-11

28,000.00
28,000.00

40,000.00

6
Cumulative total

Present Value

Capital value

100,000.00

Periodic cash flow

Management Summary

28,000.00

Minimum NPV

7,000.00

Start Date

1-Jan-10

NPV at 10.00%
NPV is above the limit of 7,000

Interval
Discount rate:

1-Jan-10

1-May-10

1-Sep-10

1-Jan-11

Capital value (100,000.00)


Periodic cash flow

100,000.00

100,000.00

100,000.00

Net cash flow

(100,000.00)

100,000.00

100,000.00

100,000.00

Cumulative total

(100,000.00)

100,000.00

200,000.00

355,100.47

NPV at 10.00%

NPV is above the limit of 7,000

Sensitivity Table for the Discount Rate

Interval

0.50%

355,100.47
Variance to 35

9.50%

9.50%

10,324.40

8,896.15

7,497.28

6,127.00

(10,324.40)

(8,896.15)

(7,497.28)

(6,127.00)

9.50%

9.50%

Systematic Finance plc : Tel: +44 (0)1483 532929

Workings

Interval

0.50%
8%

10.00%
8.50%
9.00%
9.50% Annual rate:
10.00%
10.00%
10.50%

Monthly
Quarterly
Bi-annual
Annual

12
4
2
1

11.00%
11.50%
12.00%

Documentation
Version Number

v1.0 30-Jun-2007

Author

Alastair Day

Company

Systematic Finance plc

Contact

Tel: +44 (0)1483 532929

Notes

This is simple net present model designed to show the implementation of


various Excel features on a simple model.

355,100.47

1-May-11

1-Sep-11

100,000.00

100,000.00

100,000.00

100,000.00

300,000.00

400,000.00

9.50%

9.50%

4,784.57

3,469.24

(4,784.57)

(3,469.24)

4
4
12

You might also like