Question

In: Finance

what is the ddm and capm for NYSE:AXP (american express) for fiscal year end 2017 and...

what is the ddm and capm for NYSE:AXP (american express) for fiscal year end 2017 and 2018?

Solutions

Expert Solution

CAPM

The CAPM i.e. Capital Asset Pricing Model is used to determine the required rate of return of an asset. It is calculated as follows:

Required Rate of Return (Ke) = Risk Free Rate(Rf) + [Beta of the Stock(b)][Return on the Market(Rm) - Risk Free Rate(Rf)]

2017

Ke = (0.0093875)+(1.04)(.1874-.0093875)

Ke = 0.1945 or 19.45%

2018

Ke = (0.019423) + (1.04)(0.0659--0.019423)

Ke = 0.0677 or 6.77%

DDM

Dividend Discount Model is used to value the price of stocks of the company based on the theory that it is the sum of all the future payments, discounted back to their present value.

2017

growth rate = retention ratio * return on equity

g = 0.81 * .3347 = 0.2711 or 27.11%

2018

g = 0.55 * 0.1365 = 0.0751 or 7.51%

In both the years since the growth rate is more than the cost of equity i.e. Ke, DDM cannot be used as the formula for DDM is:

[Dividend Paid(1+g)]/[Ke-g]

the formula will yield a negative answer.

Note: All the required financials were compiled from Yahoo Finance, for calculating the Risk-free Rate (Rf) Average Return on 3 Months US Treasury Bill was taken for the corresponding periods.


Related Solutions

At the end of its 2017 fiscal year-end Hopkins Corporation had 50,000 shares of preferred stock...
At the end of its 2017 fiscal year-end Hopkins Corporation had 50,000 shares of preferred stock outstanding. The preferred stock has a book value of $30 per share. In addition, Hopkins paid $75,000 in dividends to preferred shareholders in 2017. Hopkins also has $2,500,000 of interest bearing debt outstanding and its after-tax cost of debt is 6.4%. The market value of Hopkins Corporation’s common stock equity at year end is $6,240,000 and the company's cost of common equity is 9.4%....
At June 30, 2017, the end of its most recent fiscal year, Green River Computer Consultants’...
At June 30, 2017, the end of its most recent fiscal year, Green River Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $5,230 Accounts receivable 1,200 Supplies 690 Accounts payable $400 Unearned service revenue 1,120 Common stock 3,600 Retained earnings 2,000 $7,120 $7,120 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Green River conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased...
Conduct a three factor DuPont analysis for Starbucks and Cheesecake Factory for 2016 and 2017 end-of-fiscal-year...
Conduct a three factor DuPont analysis for Starbucks and Cheesecake Factory for 2016 and 2017 end-of-fiscal-year results. Use the information from financial statements provided in the section of the 2017 annual report titled: Item 8. Financial Statements and Supplementary Data. Use your analysis to provide a brief (1-2 paragraph) discussion of the change ROE from 2016 to 2017 for each firm and a comparison of the two firms in 2017. Financials: SBUX (MM) CAKE (000) Year 2017 2016 2017 2016...
West Wing Distribution Corporation has a fiscal year end of December 31. On March 15, 2017,...
West Wing Distribution Corporation has a fiscal year end of December 31. On March 15, 2017, the company’s 2016 financial statements were issued. Between December 31, 2016 and March 15, 2017, the following occurred: 1. On January 22, 2017, the company negotiated a major merger with Blakedon Industries to be completed by the middle of 2017. 2. On February 3, 2017, West Wing negotiated a $10 million long-term note (material amount) with the Credit Bank of Pennsylvania. 3. A flood...
At the end of 2017 fiscal year, L&Z Co. has the following information: Balance Sheets Current...
At the end of 2017 fiscal year, L&Z Co. has the following information: Balance Sheets Current Assets Accounts receivable, net of allowance of $1,076                               $16,194 a)   During 2018, the company wrote off $200 of specific accounts that were deemed uncollectable. Prepare the journal entry to record the write-off of these accounts receivable. (4 pts) b) At the end of 2018 (12/31/2018), management estimate 8% of account receivables balance will likely be difficult to collect. The company’s Accounts Receivable has a...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $5,650 Accounts receivable 1,300 Supplies 750 Accounts payable $430 Unearned service revenue 1,210 Common stock 3,900 Retained earnings 2,160 $7,700 $7,700 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Sheffield conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Sheffield Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $5,650 Accounts receivable 1,300 Supplies 750 Accounts payable $430 Unearned service revenue 1,210 Common stock 3,900 Retained earnings 2,160 $7,700 $7,700 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Sheffield conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Bramble Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Bramble Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $4,080 Accounts receivable 940 Supplies 540 Accounts payable $310 Unearned service revenue 870 Common stock 2,800 Retained earnings 1,580 $5,560 $5,560 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Bramble conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $6,380 Accounts receivable 1,460 Supplies 840 Accounts payable $490 Unearned service revenue 1,370 Common stock 4,400 Retained earnings 2,420 $8,680 $8,680 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing...
At June 30, 2017, the end of its most recent fiscal year, Blue Computer Consultants’ post-closing trial balance was as follows: Debit Credit Cash $6,380 Accounts receivable 1,460 Supplies 840 Accounts payable $490 Unearned service revenue 1,370 Common stock 4,400 Retained earnings 2,420 $8,680 $8,680 The company underwent a major expansion in July. New staff was hired and more financing was obtained. Blue conducted the following transactions during July 2017, and adjusts its accounts monthly. July 1 Purchased equipment, paying...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT