Mathew K Analytics

📊 Dataset · XLSX

excel107_finance.xlsx dataset

Download excel107_finance.xlsx free (13 rows × 7 columns, 48.4 KB). Preview the rows and columns, load it in pandas in one line and practise with 1 Python…

Preview (first rows)

The time value of moneyUnnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
YearSimpleCompoundInterest rate0.05
010001000
110501050Rule of 7214.4
211001102.5Exact years14.206699082890461
311501157.625
412001215.5062500000001FV of 10001628.8946267774415
512501276.2815625000003Without the minus-1628.8946267774415

Columns

ColumnTypeMissingExample
The time value of moneytext1Year
Unnamed: 1text1Simple
Unnamed: 2text1Compound
Unnamed: 3decimal13
Unnamed: 4decimal13
Unnamed: 5text8Interest rate
Unnamed: 6decimal80.05

Load it in Python

import pandas as pd
df = pd.read_excel("excel107_finance.xlsx")
df.head()