Scribd
Upload
3 views6 pages

Financial Calculations for Annuities and Cash Flow

The document outlines various financial calculations related to single amounts and annuities, including future and present values, rates, and number of periods. It also includes cash flow scenarios for deposits and loan amortization, as well as mixed streams of cash flows with associated interest rates. Key figures and calculations are presented for different financial scenarios, showcasing future and present values over specified periods.

Uploaded by

Zoya Nadeem
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
3 views6 pages

Financial Calculations for Annuities and Cash Flow

The document outlines various financial calculations related to single amounts and annuities, including future and present values, rates, and number of periods. It also includes cash flow scenarios for deposits and loan amortization, as well as mixed streams of cash flows with associated interest rates. Key figures and calculations are presented for different financial scenarios, showcasing future and present values over specified periods.

Uploaded by

Zoya Nadeem
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

1) Single amount

i Future Value
PV
nper
rate
FV

ii Present Value
FV
nper
rate
PV

iii Rate
PV
nper
FV
Rate

iv NPER
FV
Rate
PV
nper

2) Annuity
i Future Value of Ordinary Annuity
CF
Rate
nper
FVA

ii Future Value of Annuity Due


CF
Rate
nper
FVAD

iii Present Value of Ordinary Annuity


CF
Rate
nper
PVA

iv Present Value of Annuity Due


CF
Rate
nper
PVAD

v Rate of ordinary annuity


CF
nper
PVA
Rate

vi Rate of annuity due


CF
nper
PVAD
Rate

vii Nper of Ordinary annuity


CF
Rate
FVA
Nper

viii Nper of Annuity Due


CF
Rate
FVAD
Nper

3) Cash Flow in Deposits to accumulate future sum


FV
90000

4) Cash Flow in Loan Amortization


Principal Amount
-480000
5) Mixed Stream
Years
1
2
3
4
5
Interest
Net Future Value

Years
1
2
3
4
5
Interest
Net Present Value
-50000
34
18%
£13,898,190.26

30000
14
30%
-£761.93

-38000
15
130000
9%

35000
13%
-15000
6.932697365

-4000
8%
28
£381,355.32

-29000
9%
4
£144,556.61

5000
12%
7
-£22,818.78

90000
16%
11
-£524,990.47

9000
13
-28000
31%

23000
5
-54750
62%

-9000
15%
88750
6.496206813

-8800
10%
77620
6.177925493

Nper Interest Rate PMT


5 20% -£12,094.17

Interest Rate Term of Loan ( n ) Loan Payment ( CF )


16% 11 £95,453.16
CF Future Value( end of yearFuture Value ( Beginning of year)
-16000 £33,177.60 £39,813.12
-27000 £46,656.00 £55,987.20
-18000 £25,920.00 £31,104.00
-1000 £1,200.00 £1,440.00
-33000 £33,000.00 £39,600.00
20%
£139,953.60 £167,944.32

CF Present Value( end of yeaPresent Value ( Beginning of year)


13000 -£11,504.42 -£13,000.00
2000 -£1,566.29 -£1,769.91
5000 -£3,465.25 -£3,915.73
7000 -£4,293.23 -£4,851.35
6600 -£3,582.22 -£4,047.90
13%
-£24,411.42 -£27,584.90

You might also like