**Assignment: Case Study -Bond and Stock Valuation**

Caterpillar Inc. generates a lot of cash from operations. They have a current cash policy of maintaining a strong financial position to support their credit rating, provide capital for growth, appropriately fund employee benefit plans, pay dividends and repurchase stock.

They want to maintain their long-term debt-to-capital ratio below 50%.

They invest annually about $1B in capital expenditures.

They fund approximately $500M per year contributions to the pension plan.

The dividend per year has increased every year but the rate of increase has declined from 16.4% to 1% and back up in 2018 to 8% growth year over year. Their current dividend yield is about 2.6%.

The company purchased $3.8B of its own stock in 2018. Starting January 1, 2019 a new $10B buyback has been announced.

Long-term Debt equals $30.8B with $5.8B to be paid within the next year.

You've been asked to make recommendations as to whether the company should spend its free cash flow on paying higher dividends, retiring debt (buy back bonds), or to use the funds to repurchase stock.

You will need to forecast the growth of the company for the next 3 years and then use a standard rate of growth until perpetuity by using industry information. The global construction equipment is supposed to grow from $69.8B to $99.3B from 2020 to 2024. Calculate the CAGR and use this as your long term growth rate.

Assumptions:

Inflation will stay flat.

Interest rates will increase .5% every year.

The company will only buy back stock if it is undervalued.

Only bond issues listed on the front page of the 10K are to be considered for retirement of debt.

That the cash flow per share will be the free cash flow of Caterpillar Inc.

To do the analysis first calculate the current value of the stock using 2018 ROE and plowback ratio. Then calculate the current value of the stock using the discounted dividend method with a market required return of 12% and the EPS growth rates from 2019 to 2021 and the industry growth rate from 2021 on to calculate the future dividends. A horizon value must be calculated. Compare these 2 values to the currently traded stock price average over the last 10 days.

Look up Caterpillar Inc. bonds. Only do the analysis on the 3 bond issues listed on Caterpillar's 10K front page. If interest rates increase every year assume the current yield to maturity will increase by the same amount every year. Calculate bond prices for each debenture from 2019 through 2021 to see if retirement would make sense. Consider all factors.

Create a table with historical and projected dividends through 2021. Calculate the growth rate. Compare this to EPS and net income growth rate. Make your recommendations on future dividends.

All recommendations need to be supported.

All analysis is to be done on an excel sheet. One workbook is to be submitted.

Use 2 decimal format and $ and % where appropriate.

Note - It's a corporate finance case study to be done on excel. Need report of 2 pages

**Attachment:-** Case Study.rar

## len2231176Instructions: It’s a corporate finance case study to be done on excel. Most of the information is said on the case, but there is some information to be collected online. I don’t know how start and put the things on excel. So I would like a model of my case on excel. Need report of 2 pages. All recommendations need to be supported. All analysis is to be done on an excel sheet. One workbook is to be submitted. Use 2 decimal format and $ and % where appropriate. Cite plug in numbers. It will be formatted for easy reading and understanding. Make sure you support your recommendation. |

## You want to by a boat and can afford payments of 350 peryou want to by a boat and can afford payments of 350 per month for six years. the annual interest rate is 7 compounded |

## Comprehensive summary of the firmIt is now time to prepare your final report, summarizing the findings and analysis. Your report should include the following: |

## How would you explain the value of financial planningHow would you explain the value of financial planning to friends or family - Which topics will you discuss with children in your life? |

## Explain what working capitalExplain what working capital, net working capital, and the working capital cycle mean in terms of this example. |

## Determine monthly mortgage paymentSuppose you plane to buy your dream house three years from now. Today your dream house costs $329,500. You expect housing prices to rise an average of 3.25 percent per year over the next three years. |

## Determine the company critical success factorsIn researching the company, determine the company's critical success factors. In a thread of at least 400 words, explain what you believe the critical success factors are, and what the company needs to do to either gain a competitive advantage, or.. |

## Question regarding the normal distribution tableIf you want to find out the probability that a randomly picked student has scored 85 or above, what is the z value that you should look up on the normal distribution table? Show work |

## How many contracts should you enterIf your equity holdings are invested in a market-index fund (beta = 1), into how many contracts should you enter? The S&P 500index is now at 1, 650. |

## Examine the key information you would look for in a companyImagine you are considering investing in a corporation. Examine the key information you would look for in a company's financial statements and explain why this information would be important to you. |

## What is its current yieldA bond with a par value of $1,000.00 and a semiannual coupon has a nominal yield to maturity of 5.30% and a current price of $920.00. If the bond has 6 years to maturity, what is its current yield? |

## How much would you need to save at the end of each yearHow much will you need to have saved by your retirement date to be able to afford this? Alternatively, suppose you already have 50,000 in savings today. |

## Romano inc has the following data what is the firms cashromano inc. has the following data. what is the firms cash conversion cycle?inventory conversion period 38 daysaverage |

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd