FIN320ProjectTwoFinancialFormulas.pdf

ACCOUNTING & FINANCIAL RATIOS

CURRENT RATIO (Current Assets / Current Liabilities)

Current Assets

Current Liabilities

WORKING CAPITAL (Current Assets - Current Liabilities)

Current Assets

Current Liabilities 0

DEBT RATIO (Total Debt / Total Assets)

Total Debt

Total Assets

EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding)

Net Income Shares Outstanding

PRICE EARNINGS RATIO (Share Price (end of quarter / EPS)

Stock Price EPS

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

ACCOUNTING & FINANCIAL RATIOS

TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets)

Total Revenue

Total Assets

FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity)

Total Assets

Shareholder's Equity

NET PROFIT MARGIN (Net Income / Total Revenue)

Net Income

Total Revenue

RETURN ON ASSETS (Net Income / Total Assets)

Net Income Total Assets

RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity)

NI - Pref. Div. Shareholder's Equity

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

�67

�68

�69

�70

�71

�72

�73

�74

�75

�76

�77

�78

�79

�80

�81

�82

�83

�84

�85

�86

�87

�88

�89

�90

�91

�92

�93

�94

�95

�96

�97

�98

�99

Time Value of Money - Monthly Compounding Rate of Return Year 1 Initial Investment Month 1 2 3 4

Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 2 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 3 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 4 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 5 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 6 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 7 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 8 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 9 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

Year 10 Month 1 2 3 4 Interest $0 $0 $0 $0 Investment Value $0 $0 $0 $0

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

Time Value of Money - Monthly Compounding Year 1

5 6 7 8 9 10 11 12 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 2 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 3 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 4 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 5 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 6 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 7 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 8 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 9 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 10 5 6 7 8 9 10 11 12

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

�25

�26

�27

�28

�29

�30

�31

�32

�33

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

�67

�68

�69

�70

�71

�72

Time Value of Money - Annual Compounding Rate of Return Year 1 2 3 4 5 6 7 8 Initial Investment Interest $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

Time Value of Money - Annual Compounding 9 10

$0 $0 $0 $0

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

Time Value of Money - Present Value Annuity Number of Years Rate of Return $0.00 Payment

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

Time Value of Money - Future Value Annuity Number of Years Rate of Return $0.00 Payment

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

Time Value of Money - Present Value of Lump Sum Rate

Years $0.00 Initial Investment

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

�67

�68

�69

�70

�71

�72

Time Value of Money - Future Value of Lump Sum Rate

Years $0.00 Initial Investment

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

Net Present Value (NPV) Calculator Building

Initial Investment Year 1 2 Annual Cash Inflows Cash Flows $0 $0

Discount Rate NPV = $0 Year 11 12 Number of Years Cash Flows $0 $0 Salvage Value

Equipment

Initial Investment Year 1 2 Annual Cash Inflows Cash Flows $0 $0

Discount Rate NPV = $0 Year 11 12 Number of Years Cash Flows $0 $0 Salvage Value

Bonds

Initial Investment Annual Cash Inflows Discount Rate NPV = $0 Year 1 2 Number of Years Cash Flows $0 $0 Principal Returned

�1

�2

�3

�4

�5

�6

�7

�8

�9

�10

�11

�12

�13

�14

�15

�16

�17

�18

�19

�20

�21

�22

�23

�24

�25

�26

�27

�28

�29

�30

�31

�32

�33

Net Present Value (NPV) Calculator Building

3 4 5 6 7 8 9 10 $0 $0 $0 $0 $0 $0 $0 $0

13 14 15 16 17 18 19 20 $0 $0 $0 $0 $0 $0 $0 $0

Equipment

3 4 5 6 7 8 9 10 $0 $0 $0 $0 $0 $0 $0 $0

13 14 15 16 17 18 19 20 $0 $0 $0 $0 $0 $0 $0 $0

Bonds

3 4 5 6 7 8 9 10 $0 $0 $0 $0 $0 $0 $0 $0

�34

�35

�36

�37

�38

�39

�40

�41

�42

�43

�44

�45

�46

�47

�48

�49

�50

�51

�52

�53

�54

�55

�56

�57

�58

�59

�60

�61

�62

�63

�64

�65

�66

�67

�68

�69

�70

�71

�72

�73

�74

�75

�76

�77

�78

�79

�80

�81

�82

�83

�84

�85

�86

�87

�88

�89

�90

�91

�92

�93

�94

�95

�96

�97

�98

�99