Scribd
Upload
31 views2 pages

CF Practice

The document compares annuity and lump sum investment options, detailing payment amounts, interest rates, and future values for different scenarios. It includes calculations for present value, net present value, and future value based on varying interest rates and payment periods. Additionally, it outlines costs associated with loans, including down payments and closing expenses.

Uploaded by

Saranya Vs
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
31 views2 pages

CF Practice

The document compares annuity and lump sum investment options, detailing payment amounts, interest rates, and future values for different scenarios. It includes calculations for present value, net present value, and future value based on varying interest rates and payment periods. Additionally, it outlines costs associated with loans, including down payments and closing expenses.

Uploaded by

Saranya Vs
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/ 2

Annuity Lumpsum

PMT 1000 PMT 10000


I 8% 0.67% I 5%
NPER 5 60 N 10
FV ? FV ₹ 16,288.95
FV ₹ 73,476.86 FV(G4,G5,0,-G3,0)

PMT 1000
I 10% 0.83%
N 4 48
FV ?
FV ₹ 58,722.49

Q. Price(PV)

One time cost


Down payment
Taxes
Deal closing expense
Total

Loan amount
I
NPER
PMT
nper(rate,pmt,pv,[fv],[type])

10%
0 1000 PMT(rate,nper,pv,[fv],[type])
1 2000
2 2500
3 4000

NPV ₹ 7,172.32 NPV(J5,J6:J9)


FV ₹ 10,501.00

600000

120000
18000
2000
140000

480000
4% 2.00% Semi-annual
300
₹ 9,625.31

You might also like