BusinessCourse

Course Content $/$ Module $15/$ Module $15$ Homework

Module $15$ Homework

Computing Key Metrics from Financial Data

For each of the following company stocks, listed among the Dow Jones Industrials, use the information provided to compute the measures a through d$.$

$\backslash$table$[[$Company$,\backslash$table$[[$Market$],[$Cap$],[($$ mil$)]],\backslash$table$[[$Stock$],[$Price$]],\backslash$table$[[$PB$],[$Current$]],\backslash$table$[[$BV per$],[$Share$]],\backslash$table$[[$Trailing$],[4-$Quarter PE$]]],[3M(MMM),$$$104,540,$$$172\mathrm{.}96,8\mathrm{.}79,$$$19\mathrm{.}68,22\mathrm{.}06],[$Apple $($AAPL$),612,130,113\mathrm{.}60,4\mathrm{.}84,23\mathrm{.}46,13\mathrm{.}26],[$Caterpillar $($CAT$),51,680,88\mathrm{.}45,3\mathrm{.}39,26\mathrm{.}07,46\mathrm{.}80],[$Coca$-$Cola $($KO$),180,430,41\mathrm{.}80,6\mathrm{.}77,6\mathrm{.}16,24\mathrm{.}03],[$Disney $($DIS$),148,740,92\mathrm{.}55,3\mathrm{.}37,27\mathrm{.}24,16\mathrm{.}62],[$Exxon Mobil $($XOM$),360,390,86\mathrm{.}91,2\mathrm{.}11,41\mathrm{.}14,34\mathrm{.}49],[$Johnson & Johnson $($JNJ$),326,390,119\mathrm{.}30,4\mathrm{.}50,26\mathrm{.}35,22\mathrm{.}42],[$Walmart $($WMT$),212,820,68\mathrm{.}80,2\mathrm{.}78,24\mathrm{.}71,14\mathrm{.}76]]$

Rounding instructions:

a$.$ Round common shares outstanding to one decimal place $($in millions$).$

b$.$ Round total book value of equity to the nearest whole number $($in millions$).$

c$.$ Round trailing four quarters EPS to two decimal places.

d$.$ Round trailing four quarters ROE to one decimal place $($ex: $0\mathrm{.}2345=23\mathrm{.}5\%).$

$\backslash$table$[[,$MMM$,$AAPL,CAT,KO$,$DIS,XOM,JNJ$,$WMT$],[$a$.$ Common shares outstanding,$604\mathrm{.}4vv,5,388\mathrm{.}5,584\mathrm{.}3vv,2,594,1,607\mathrm{.}1vv,4,146\mathrm{.}7vv,2,735\mathrm{.}9vv,3,093\mathrm{.}1x$