Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Finance > Formulas and table structures > Flashcards

Formulas and table structures Flashcards

(119 cards)

Start Studying
1
Q

Promissory Notes table structure

A
  • Due Date
  • Payment Date
  • Nominal Value
  • Bank Fee
  • time
  • Annual Discount
  • Days per year
  • Discount interests
  • Fee amount
  • Total discount
  • Proceeds
  • Effective Rate Compound
  • Effective Rate Simple
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Elements given in promissory notes exercises

A
  • Due Date
  • Payment Date
  • Nominal Value
  • Bank Fee
  • Annual Discount
  • Days per year
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

time formula (promissory notes)

A

=Days360(Payment Date; Due Date; TRUE)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Discount interests formula (promissory notes)

A

=Nominal valueAnnual Discounttime/Days per year

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Fee amount formula (promissory notes)

A

=Bank Fee*Nominal Value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Total Discount formula (promissory notes)

A

=ADD(Discount interests:Fee amount)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Proceeds formula (promissory notes)

A

=Nominal Value-Discount interests-Fee amount

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Effective Rate Compound formula (promissory notes)

A

=((N/P)^(B/t))-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Effective Rate Simple formula (promissory notes)

A

=(N/P-1)*(B/t)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

If we are told to calculate profit obtained from a long-term investment, which table do we use?

A
  • FV
  • PV
  • NPER
  • Annual Return
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which elements are we given in annual return exercises?

A
  • FV
  • PV
  • NPER
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Annual Return formula

A

=((FV/PV)^(1/NPER))-1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

If we are told to calculate the time it takes to get from PV to FV, which table do we use?

A
  • interest rate
  • FV
  • PV
  • NPER SIMPLE
  • NPER COMPOUND
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which elements are we given in an NPER exercises?

A
  • interest rate
  • FV
  • PV
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

NPER SIMPLE formula

A

=(FV/PV-1)/i

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

NPER COMPOUND formula

A

=LN(FV/PV)/LN(1+i)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Hamburg method table structure

A
  • Effective Balance
  • Nº of Days
  • Value
  • interest rate
  • Days per year
  • interest rate (30 days)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Elements given in Hamburg method

A
  • Effective balance
  • Nº of days
  • interest rate
  • Days per year
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Value formula (Hamburg method)

A

=Effective Balance*Nº of days

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

interest rate (30 days) formula (Hamburg method)

A

=Total Value/Days per year*i

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Simple/Compound capitalization Future Value table structure

A
  • interest rate
  • Investment
  • Nº of years
  • Years
  • Simple capital
  • Simple interest
  • Simple End of year
  • Compound capital
  • Compound interest
  • Compound End of year
  • TOTAL (column)
  • FV (column)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Elements given in FV capialization exercises

A
  • interest rate
  • Investment
  • Nº of years
  • Years
  • Simple capital
  • Compound capital (Only Co)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Simple interest formula (FV capitalization)

A

=i*Cn

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Simple End of Year formulas (FV capitalization)

A

=ADD(Co;i)

=End of Year-1+Simple interestn

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Compound capital formula (FV capitalization)
=Compound capital-1+Compound interest-1
26
Compound interest formula (FV capitalization)
=i*Cn
27
Compound End of Year formula (FV capitalization)
=ADD(Cn:i)
28
TOTAL column calculations (FV capitalization)
=ADD(simple interest row) | =ADD(compound interest row)
29
FV column calculations (FV capitalization)
- Simple End of Year =FV(i;Nº Years;i;Investment;0) | - Compound End of Year =FV (i;Nº Years;;-Investment;0)
30
PV/FV (CF given) table structure
- interest rate - Year - Cash Flow - PV - FV - Nº of Years - NPV
31
PV/FV (CF given) given elements
- interest rate - Year - Cash Flow - Nº of Years
32
PV formula
=CFn/(1+i)^Yearn
33
FV formula
=CFn*(1+i)^(Years-Yearn)
34
NPV formulas
=CFn/(1+i)^n | =NPV(i;CF row)-TOTAL NPV
35
Deposits table structure
- Co - n - EAR - m - Capitalization frequency - APR - im - Cf - I - HPR - Global m - Global EAR - Total Return - Global EAR
36
Given elements in deposits exercises
- Co - n - EAR - Capitalization frequency
37
m formula (deposits)
=Capitalization frequency/n
38
APR formula (deposits)
=((EAR+1)^(1/Capitalization frequency)-1)*Capitalization frequency
39
im formula (deposits)
=APR/m
40
Cf formula (deposits)
=Co*(1+im)
41
I formula (deposits)
=Cf-Co
42
HPR formula (deposits)
=(1+im)*(1+im)..... (1+im)-1
43
Global m formula (deposits)
=(n1+n2)/months
44
Global EAR formula 1 (deposits)
=((1+HPR)^(1/Global m))-1
45
Total Return formula (deposits)
=Cf/Co-1
46
Global EAR formula 2 (deposits)
=((1+Total Return)^(1/Global m))-1
47
PV/FV (APR given) table structure
- APR - m - im - Cash Flow - PV - FV
48
Given elements in PV/FV (APR given) exercises
- APR - m - Cash Flow
49
im formula (PV/FV (APR given))
=APR/m
50
PV formula (PV/FV (APR given))
=CFn/(1+in)^monthn
51
FV formula (PV/FV (APR given))
=CFn*(1+in)^(months-monthn)
52
IRR investment table structure
- Year - Cash Flow - IRR - FV
53
Given elements in IRR investment exercises
- Year | - Cash Flow
54
IRR formula (IRR investment)
=IRR(Cash Flow row)
55
FV formulas (IRR investment)
=FV(IRR;Years;;Co) | =Co*(1+IRR)^Years
56
RIRR investment table structure
- IRR - RIRR - Years - Cash Flow - FV with IRR - Project with implicit IRR - FV with RIRR - Project with RIRR
57
Given elements in RIRR
- IRR - RIRR - Years - Cash Flow
58
FV with IRR formula (RIRR)
=CFn*(1+IRR)^(Years-Yearn)
59
Project with IRR formula (RIRR)
=ADD(FV with IRR row)
60
FV with RIRR formula (RIRR)
=CFn*(1+RIRR)^(Years-Yearn)
61
Project with RIRR formula (RIRR)
=ADD(FV with RIRR row)
62
French Loan table structure
- Interest rate - Annuity - Years - Pending capital - Interest - Capital repayment - Annuity
63
Given elements in French Loan
- Interest rate - Years - Co
64
Annuity formula 1 (French Loan)
=Co*(i/(1-(1+i)^(-Years)))
65
Pending capital formula (French Loan)
=C-1-Capital repayment-1
66
Interest formula (French Loan)
=Cn*i
67
Capital repayment formula (French Loan)
=Annuity-Interests
68
Annuity formula 2 (French Loan)
=Annuity (Constant value)
69
Italian Loan table structure
- Interest rate - Repayment - Year - Pending capital - Interests - Capital Repayment - Annuity
70
Given elements in Italian Loans
- Interest rate - Year - Co
71
Repayment formula (Italian Loan)
=Co/Years
72
Pending capital formula (Italian Loan)
=C-1-Capital repayment-1
73
Interests formula (Italian Loan)
=Cn*i
74
Capital repayment formula (Italian Loan)
=Annuityn-Interestsn (Constant value)
75
Annuity formula (Italian Loan)
=Interestsn+Repaymentn
76
American Loans table structure
- Interest rate - Amortization - Year - Outstanding capital - Interests - Capital repayment - Annuity
77
Given elements in American Loan
- Interest rate - Amortization - Year - Co (Constant value)
78
Interests formula (American Loan)
=Cn*i
79
Capital repayment formula (American Loan)
=Amortization
80
Annuity formula (American Loan)
=Interestsn+Amortizationn
81
Annuities table structure
- Years - CF - i - PV - i - FV
82
Given elements in Annuities
- Years - CF - i
83
PV formulas (Annuities)
- i1 - Co =Co =CFn/(1+i1)^Yearn - i2 =CFn/((1+i1)^Years i1)*((1+i2)^(Yearn-Years i1))
84
FV formulas (Annuities)
- i1 =CF*((1+i1)^(Years i1-Yearn))*((1+i2)^(Years-Years i1)) | - i2 =CFn*(1+i2)^(Years-years i1)
85
Ways of financing companies tables order
- Stocks - Reserves - Loans - Bonds - WACC
86
Stocks (WACC) table structure
- Shares number - Nominal Value - Issue premium - Dividend - Growth Rate - Issue Value - Cost of Equity Common Shares - Nominal Value Common Shares - Value Common Shares
87
Given elements in Stocks section
- Shares number - Nominal Value - Issue premium - Dividend - Growth Rate
88
Issue Value formula (Stocks section)
=Nominal Value*Issue Premium
89
Cost of Equity Common Shares formula (Stocks section)
=(Dividend/Issue Value)+Growth Rate
90
Face Value Common Shares formula (Stocks section)
=Shares number*Nominal Value
91
Value Common Shares formula (Stocks section)
=Shares number*Issue Value
92
Reserves (WACC) table structure
- Amount | - Cost of equity reserves
93
Cost of equity reserves formula (Reserves section)
=Cost of Equity Common Shares
94
Loans (WACC) table structure
- Annual Interest Rate - Years - PV - Capital repayment - Outsanding capital - Interest - General Installment - Fees - Total Installment w/Fees - Cost of Loan
95
Given elements in Loans section
- Annual interest rate - Years - PV
96
Capital repayment formula (Loans section)
=PV/Year
97
Outstanding capital (Loans section)
= PV | =Outstanding capital-1-capital repaymentn
98
Interest formula (Loans section)
=Outstanding capital*Annual Interest Rate
99
General Installment formula (Loans section)
=-(Capital repayment+Interest)
100
Fees formula (Loans section)
=Opening Fee
101
Total Installment formula (Loans section)
=SUMA(General installment:Fees)
102
Cost of Loan formula (Loans section)
=IRR(Total installment row)
103
Bonds (WACC) table structure
- Bonds number - Nominal value - Issue premium - Issue Value - Issue Value - Coupon - Year - PV - Installment - Oustanding capital - Interests - Issue premium - Total - Cost of bonds
104
Given elements Bonds section
- Bonds number - Nominal value - Issue premium - Issue value - Year
105
Issue Value formula (Bonds section)
=Issue Value*Bonds Number
106
Coupon formula (Bonds section)
=Issue premium
107
PV formula (Bonds section)
=Bonds number*Nominal value
108
Installments formula (Bonds section)
=Outstanding capital
109
Outstanding capital formula (Bonds section)
=PV | =Intallments-Outstanding capital
110
Interests formula (Bonds section)
=Coupon*Bonds number
111
Issue premium formula (Bonds section)
=-Issue premium*Bonds number
112
Total formula (Bonds section)
=-(Installments+Interests)
113
Cost of Bonds formula (Bonds section)
=IRR(Total row)
114
WACC table structure (by columns)
- Amount - Cost - Proportion - Weight
115
Amount column structure (WACC)
- Value common Shares - Amount reserves - PV - Issue value - ADD
116
Cost column structure (WACC)
- Cost of equity common shares - Cost common stocks - Cost of loan - Cost of bonds - AVERAGE
117
Proportion column structure (WACC)
=Common stocks/TOTAL =Reserves/TOTAL =Loans/TOTAL =Bonds/TOTAL
118
Weight column structure (WACC)
=Cost*Proportion
119
WACC formula
=SUMPRODUCT(Cost column;Proportion column)

Finance (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions