professional documents
home
Upload
docsters
Upload
Excel Spreadsheet

Financial Excel Spreadsheets center doc

 


123456789 10 11 12 13 14 15 16 17 18 A B C D E F G H INFLATION AND THE REAL RATE OF INTEREST Interest rate 12.00% Inflation rate 5.00% Real interest rate 6.67% ( 1 + Interest Rate ) /( 1 + Inflation Rate ) -1 EXAMPLE Cash today 100.00 Plus interest 12.00 Cash next year 112.00 Price today 106.67 Plus inflation 5.33 Price next year 112.00 Page 1123456789 10 11 12 13 14 15 16 17 18 19 A B C D E F INFLATION AND CONSTANT DOLLAR FACTORS Current price 200.00 Inflation rate 5.00% Year 0 1 2 3 Price 200.00 210.00 220.50 231.53 Inflation factor 100.00% 105.00% 110.25% 115.76% Inflation Factor = Previous Inflation Factor x ( 1 + Inflation Rate ) Price 200.00 210.00 220.50 231.53 Constant dollar factor 100.00% 95.24% 90.70% 86.38% Price in constant dollars 200.00 200.00 200.00 200.00 Constant dollar factor = 1 /Inflation Factor Constant dollar factor = Previous Constant Dollar Factor /( 1 + Inflation Rate ) Page 2123456789 10 11 12 13 14 15 16 17 18 19 20 21 A B C D E F G H NPV CAN BE CALCULATED IN NOMINAL OR REAL TERMS Interest rate 12.00% Inflation rate 5.00% Real interest rate 6.67% Year 0 1 2 3 Cash flow (400,000) 100,000 200,000 300,000 PV factor 100% 89% 80% 71% PV of cash flow (400,000) 89,286 159,439 213,534 Cumulative PV (400,000) (310,714) (151,276) 62,259 NPV 62,259 Cash flow (400,000) 100,000 200,000 300,000 Constant dollar factor 100% 95% 91% 86% Real cash flow (400,000) 95,238 181,406 259,151 Cash Flow x Const $ Factor Real PV factor 100% 94% 88% 82% Real PV (400,000) 89,286 159,439 213,534 Real CF x Real PV Factor Cumulative real PV (400,000) (310,714) (151,276) 62,259 NPV 62,259 Page 3
flag this doc
520
32
not rated
0
12/27/2007
English
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 498 | 41 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 829 | 52 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 336 | 28 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 892 | 107 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 360 | 29 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 289 | 19 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 288 | 14 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 460 | 47 | 0 |
Preview

Financial Excel Spreadsheets

shanti12 12/27/2007 | 715 | 81 | 0 |
Preview

Introduction to Excel Spreadsheets

EPADocs 5/13/2008 | 232 | 14 | 0 | legal
Preview

Financial_model_1[3]

GrayLadyIce 2/5/2008 | 170 | 18 | 0 | financial
Preview

Bill_Snow_Financial_Model_2004_03_0 9[3]

GrayLadyIce 2/5/2008 | 87 | 0 | 0 | financial
Preview

Financial Projections Model v6.8.4[3]

GrayLadyIce 2/5/2008 | 301 | 59 | 0 | financial
Preview

Financial History and Ratios1[9]

balazon 1/8/2008 | 65 | 3 | 0 | legal
Preview

Download all the tables in Excel spreadsheets

RMA 6/18/2008 | 61 | 6 | 0 | legal
Preview

A Junior Software engineer

shanti12 3/10/2008 | 460 | 52 | 2 | legal
Preview

1st Sem-Operating systems_1

shanti12 1/19/2008 | 476 | 36 | 1 | educational
Preview

Technological Trends

shanti12 1/18/2008 | 461 | 35 | 0 |
Preview

Useful Material

shanti12 1/18/2008 | 838 | 123 | 0 |
Preview

Professional Ajax

shanti12 1/18/2008 | 3782 | 211 | 7 | business
Preview

Pragmatic AJAX

shanti12 1/18/2008 | 856 | 102 | 2 |
Preview

hoomanLibrary

shanti12 1/18/2008 | 293 | 3 | 0 |
Preview

msnet article

shanti12 1/18/2008 | 267 | 1 | 0 |
Preview

AJAX

shanti12 1/18/2008 | 437 | 39 | 0 |
Preview

ajax-tutorial-08

shanti12 1/18/2008 | 964 | 57 | 0 |
 

review this doc