Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Finance > Formulas and table structures > Flashcards

Formulas and table structures Flashcards

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
Q

Compound capital formula (FV capitalization)

A

=Compound capital-1+Compound interest-1

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

Compound interest formula (FV capitalization)

A

=i*Cn

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

Compound End of Year formula (FV capitalization)

A

=ADD(Cn:i)

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

TOTAL column calculations (FV capitalization)

A

=ADD(simple interest row)

=ADD(compound interest row)

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

FV column calculations (FV capitalization)

A
  • Simple End of Year =FV(i;Nº Years;i;Investment;0)

- Compound End of Year =FV (i;Nº Years;;-Investment;0)

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

PV/FV (CF given) table structure

A
  • interest rate
  • Year
  • Cash Flow
  • PV
  • FV
  • Nº of Years
  • NPV
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

PV/FV (CF given) given elements

A
  • interest rate
  • Year
  • Cash Flow
  • Nº of Years
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

PV formula

A

=CFn/(1+i)^Yearn

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

FV formula

A

=CFn*(1+i)^(Years-Yearn)

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

NPV formulas

A

=CFn/(1+i)^n

=NPV(i;CF row)-TOTAL NPV

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

Deposits table structure

A
  • Co
  • n
  • EAR
  • m
  • Capitalization frequency
  • APR
  • im
  • Cf
  • I
  • HPR
  • Global m
  • Global EAR
  • Total Return
  • Global EAR
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Given elements in deposits exercises

A
  • Co
  • n
  • EAR
  • Capitalization frequency
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

m formula (deposits)

A

=Capitalization frequency/n

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

APR formula (deposits)

A

=((EAR+1)^(1/Capitalization frequency)-1)*Capitalization frequency

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

im formula (deposits)

A

=APR/m

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

Cf formula (deposits)

A

=Co*(1+im)

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

I formula (deposits)

A

=Cf-Co

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

HPR formula (deposits)

A

=(1+im)*(1+im)….. (1+im)-1

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

Global m formula (deposits)

A

=(n1+n2)/months

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

Global EAR formula 1 (deposits)

A

=((1+HPR)^(1/Global m))-1

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

Total Return formula (deposits)

A

=Cf/Co-1

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

Global EAR formula 2 (deposits)

A

=((1+Total Return)^(1/Global m))-1

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

PV/FV (APR given) table structure

A
  • APR
  • m
  • im
  • Cash Flow
  • PV
  • FV
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q

Given elements in PV/FV (APR given) exercises

A
  • APR
  • m
  • Cash Flow
49
Q

im formula (PV/FV (APR given))

50
Q

PV formula (PV/FV (APR given))

A

=CFn/(1+in)^monthn

51
Q

FV formula (PV/FV (APR given))

A

=CFn*(1+in)^(months-monthn)

52
Q

IRR investment table structure

A
  • Year
  • Cash Flow
  • IRR
  • FV
53
Q

Given elements in IRR investment exercises

A
  • Year

- Cash Flow

54
Q

IRR formula (IRR investment)

A

=IRR(Cash Flow row)

55
Q

FV formulas (IRR investment)

A

=FV(IRR;Years;;Co)

=Co*(1+IRR)^Years

56
Q

RIRR investment table structure

A
  • IRR
  • RIRR
  • Years
  • Cash Flow
  • FV with IRR
  • Project with implicit IRR
  • FV with RIRR
  • Project with RIRR
57
Q

Given elements in RIRR

A
  • IRR
  • RIRR
  • Years
  • Cash Flow
58
Q

FV with IRR formula (RIRR)

A

=CFn*(1+IRR)^(Years-Yearn)

59
Q

Project with IRR formula (RIRR)

A

=ADD(FV with IRR row)

60
Q

FV with RIRR formula (RIRR)

A

=CFn*(1+RIRR)^(Years-Yearn)

61
Q

Project with RIRR formula (RIRR)

A

=ADD(FV with RIRR row)

62
Q

French Loan table structure

A
  • Interest rate
  • Annuity
  • Years
  • Pending capital
  • Interest
  • Capital repayment
  • Annuity
63
Q

Given elements in French Loan

A
  • Interest rate
  • Years
  • Co
64
Q

Annuity formula 1 (French Loan)

A

=Co*(i/(1-(1+i)^(-Years)))

65
Q

Pending capital formula (French Loan)

A

=C-1-Capital repayment-1

66
Q

Interest formula (French Loan)

67
Q

Capital repayment formula (French Loan)

A

=Annuity-Interests

68
Q

Annuity formula 2 (French Loan)

A

=Annuity (Constant value)

69
Q

Italian Loan table structure

A
  • Interest rate
  • Repayment
  • Year
  • Pending capital
  • Interests
  • Capital Repayment
  • Annuity
70
Q

Given elements in Italian Loans

A
  • Interest rate
  • Year
  • Co
71
Q

Repayment formula (Italian Loan)

72
Q

Pending capital formula (Italian Loan)

A

=C-1-Capital repayment-1

73
Q

Interests formula (Italian Loan)

74
Q

Capital repayment formula (Italian Loan)

A

=Annuityn-Interestsn (Constant value)

75
Q

Annuity formula (Italian Loan)

A

=Interestsn+Repaymentn

76
Q

American Loans table structure

A
  • Interest rate
  • Amortization
  • Year
  • Outstanding capital
  • Interests
  • Capital repayment
  • Annuity
77
Q

Given elements in American Loan

A
  • Interest rate
  • Amortization
  • Year
  • Co (Constant value)
78
Q

Interests formula (American Loan)

79
Q

Capital repayment formula (American Loan)

A

=Amortization

80
Q

Annuity formula (American Loan)

A

=Interestsn+Amortizationn

81
Q

Annuities table structure

A
  • Years
  • CF
  • i
  • PV
  • i
  • FV
82
Q

Given elements in Annuities

A
  • Years
  • CF
  • i
83
Q

PV formulas (Annuities)

A
  • i1 - Co =Co
    =CFn/(1+i1)^Yearn
  • i2 =CFn/((1+i1)^Years i1)*((1+i2)^(Yearn-Years i1))
84
Q

FV formulas (Annuities)

A
  • i1 =CF((1+i1)^(Years i1-Yearn))((1+i2)^(Years-Years i1))

- i2 =CFn*(1+i2)^(Years-years i1)

85
Q

Ways of financing companies tables order

A
  • Stocks
  • Reserves
  • Loans
  • Bonds
  • WACC
86
Q

Stocks (WACC) table structure

A
  • Shares number
  • Nominal Value
  • Issue premium
  • Dividend
  • Growth Rate
  • Issue Value
  • Cost of Equity Common Shares
  • Nominal Value Common Shares
  • Value Common Shares
87
Q

Given elements in Stocks section

A
  • Shares number
  • Nominal Value
  • Issue premium
  • Dividend
  • Growth Rate
88
Q

Issue Value formula (Stocks section)

A

=Nominal Value*Issue Premium

89
Q

Cost of Equity Common Shares formula (Stocks section)

A

=(Dividend/Issue Value)+Growth Rate

90
Q

Face Value Common Shares formula (Stocks section)

A

=Shares number*Nominal Value

91
Q

Value Common Shares formula (Stocks section)

A

=Shares number*Issue Value

92
Q

Reserves (WACC) table structure

A
  • Amount

- Cost of equity reserves

93
Q

Cost of equity reserves formula (Reserves section)

A

=Cost of Equity Common Shares

94
Q

Loans (WACC) table structure

A
  • Annual Interest Rate
  • Years
  • PV
  • Capital repayment
  • Outsanding capital
  • Interest
  • General Installment
  • Fees
  • Total Installment w/Fees
  • Cost of Loan
95
Q

Given elements in Loans section

A
  • Annual interest rate
  • Years
  • PV
96
Q

Capital repayment formula (Loans section)

97
Q

Outstanding capital (Loans section)

A

= PV

=Outstanding capital-1-capital repaymentn

98
Q

Interest formula (Loans section)

A

=Outstanding capital*Annual Interest Rate

99
Q

General Installment formula (Loans section)

A

=-(Capital repayment+Interest)

100
Q

Fees formula (Loans section)

A

=Opening Fee

101
Q

Total Installment formula (Loans section)

A

=SUMA(General installment:Fees)

102
Q

Cost of Loan formula (Loans section)

A

=IRR(Total installment row)

103
Q

Bonds (WACC) table structure

A
  • Bonds number
  • Nominal value
  • Issue premium
  • Issue Value
  • Issue Value
  • Coupon
  • Year
  • PV
  • Installment
  • Oustanding capital
  • Interests
  • Issue premium
  • Total
  • Cost of bonds
104
Q

Given elements Bonds section

A
  • Bonds number
  • Nominal value
  • Issue premium
  • Issue value
  • Year
105
Q

Issue Value formula (Bonds section)

A

=Issue Value*Bonds Number

106
Q

Coupon formula (Bonds section)

A

=Issue premium

107
Q

PV formula (Bonds section)

A

=Bonds number*Nominal value

108
Q

Installments formula (Bonds section)

A

=Outstanding capital

109
Q

Outstanding capital formula (Bonds section)

A

=PV

=Intallments-Outstanding capital

110
Q

Interests formula (Bonds section)

A

=Coupon*Bonds number

111
Q

Issue premium formula (Bonds section)

A

=-Issue premium*Bonds number

112
Q

Total formula (Bonds section)

A

=-(Installments+Interests)

113
Q

Cost of Bonds formula (Bonds section)

A

=IRR(Total row)

114
Q

WACC table structure (by columns)

A
  • Amount
  • Cost
  • Proportion
  • Weight
115
Q

Amount column structure (WACC)

A
  • Value common Shares
  • Amount reserves
  • PV
  • Issue value
  • ADD
116
Q

Cost column structure (WACC)

A
  • Cost of equity common shares
  • Cost common stocks
  • Cost of loan
  • Cost of bonds
  • AVERAGE
117
Q

Proportion column structure (WACC)

A

=Common stocks/TOTAL
=Reserves/TOTAL
=Loans/TOTAL
=Bonds/TOTAL

118
Q

Weight column structure (WACC)

A

=Cost*Proportion

119
Q

WACC formula

A

=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