Scribd
Upload
11 views5 pages

FinModelling Classwork

The document presents a financial analysis of a capital investment of $100,000 with periodic cash flows of $100,000, resulting in a net present value (NPV) of $283,970.88 at an interest rate of 8%. The analysis includes cash flow projections, cumulative totals, and various interest rate scenarios. It provides a detailed breakdown of cash flows over time, indicating the financial viability of the investment.

Uploaded by

simar nayyar
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
11 views5 pages

FinModelling Classwork

The document presents a financial analysis of a capital investment of $100,000 with periodic cash flows of $100,000, resulting in a net present value (NPV) of $283,970.88 at an interest rate of 8%. The analysis includes cash flow projections, cumulative totals, and various interest rate scenarios. It provides a detailed breakdown of cash flows over time, indicating the financial viability of the investment.

Uploaded by

simar nayyar
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
You are on page 1/ 5

Present Value

Author Name

Capital Investment 100,000.00 Management Summary


Periodic Cash Flows 100,000.00 NPV 283,970.88
Minimum NPV 7,000.00
Start Date 1/Jun/10
Interval 31/Dec/99
Interest Rate 8%

0 1 2 3
1/Jun/10 1/Jul/10 1/Aug/10 1/Sep/10
Capital value ( 100,000.00 )
Periodic Cash flows 100,000.00 100,000.00 100,000.00

Total ( 100,000.00 ) 100,000.00 100,000.00 100,000.00

Factor 1.00 0.91 0.83 0.76

Net cash flow ( 100,000.00 ) 91,324.20 83,401.10 76,165.39


Cummalative Total ( 100,000.00 ) ( 8,675.80 ) 74,725.30 150,890.68
NPV 283,970.88

7000 7000 7000 7000


Workings
Interval 0.50% 283,970.88 80000
8.00% 4 8% 319271.003708
8.50% 0.095 9% 308965.126335
9.00% 10% 299078.676941
9.50% 11% 289589.701765
10.00% 12% 280477.620235
10.50% 13% 271723.126154
11.00% 14% 263308.096886
11.50% 15% 255215.509801
12.00%
12.50%

Char t Title

6 283,970.88

5 220,448.11

4 150,890.68

3 74,725.30

( 8,675.80
2 )

( 100,000.00 )1

( 100,000.00 ) 0.00 100,000.00 200,000.00


4 150,890.68

3 74,725.30

( 8,675.80
2 )

( 100,000.00 )1

( 100,000.00 ) 0.00 100,000.00 200,000.00


Logo
Version 2024.12.11
3

8
9
10
12 Formula auditing
15.5 Formats
Layout
Lines and Borders
4 5 Colors and Patterns
1/Oct/10 1/Nov/10 Data validation
Controls Combo box, offset function
100,000.00 100,000.00 Scroll bar
Conditional formatting
100,000.00 100,000.00 Use of functions
Text and Updated labels
0.70 0.64 Version number, author, etc
Names to cells
69,557.43 63,522.77 Comment cells
220,448.11 283,970.88 Graphics
Dynamic graphs
Data tables
7000 7000

100000 120000
299271.00371 279,271.00
288965.12634 268,965.13
279078.67694 259,078.68
269589.70176 249,589.70
260477.62023 240,477.62
251,723.13 231,723.13
243,308.10 223,308.10
235,215.51 215,215.51

Scenarios
Goal seek
Solver

t Title
283,970.88

20,448.11

68

000.00 200,000.00 300,000.00


68

000.00 200,000.00 300,000.00

You might also like