Scribd
Upload
12 views4 pages

Module 5 FMV Assignment

The document provides various financial calculations including future value and present value of investments, annuities, and perpetuities. It also includes internal rate of return (IRR) for different projects and details on monthly payments for loans with total paid and interest amounts. Additionally, it features date and time functions with examples of date differences.

Uploaded by

anonymous09841
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
12 views4 pages

Module 5 FMV Assignment

The document provides various financial calculations including future value and present value of investments, annuities, and perpetuities. It also includes internal rate of return (IRR) for different projects and details on monthly payments for loans with total paid and interest amounts. Additionally, it features date and time functions with examples of date differences.

Uploaded by

anonymous09841
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

rate 0.

02
npr 40
pmt 0
Pv -10000

FV of Investment ₹ 22,080.40

rate 0.00583333333
npr 300
pmt 0
fv 1000000
type 0

PV of Future Value ₹ -174,659.73

Annual Payment 500


Rate 0.06

PV of Perpetuity 8333.33333333

rate 0.04
npr 5
pmt -1000
Pv 0

FV of Annuity ₹ 5,416.32
-10000 -250000 -10000 -10000
3000 70000 4000 2000
4000 70000 4000 3000
5000 70000 4000 4000
6000 70000 4000 5000
70000
IRR Project 1 25% IRR Project 2 12% IRR Project A IRR Project B
22% 13%
Rate 0.005 0.004166666667
nper 360 60
Pv -200000 -50000

Monthly Payment ₹ 1,199.10 Monthly Payment ₹ 943.56


Total Paid ₹ 431,676.38 Total Paid 56613.70093203
Total Interest ₹ 231,676.38 Total Interest 6613.700932033
Date & Time Functions
Start End Difference Start End of month Exact date Exact date
3/2/2024 4/3/2024 02/03/2024

6/5/2023 8/8/2023 6/5/2023

12/24/2021 12/25/2021 12/24/2021

You might also like