Calculate profit margin total asset turnover equity


Ragan, Inc. was founded nineteen years ago by brother and sister Carrington and Genevieve Ragan. The company manufactures and installs commercial heating, ventilation, and cooling (HVAC) units. Ragan, Inc. has experienced rapid growth because of a proprietary technology that increases the energy efficiency of its units. The company is equally split between the two siblings. The original partnership agreement between them gave each 500,000 shares of stock. The company has since gone public. At that time, the siblings retained their shares and 1,000,000 shares of new stock were issued.

The firm anticipates needing to raise a large amount of capital ($10 million) in the coming year to facilitate further expansion and are evaluating several financing options. The first option is to issue zero-coupon bonds that mature in 20 years. Similar zero-coupon bonds currently have a YTM of 4.5%.

The second option is to issue 4% coupon bonds that mature in 20 years. Similar bonds have a YTM of 4%. The third option is to issue preferred stock with a fixed dividend of $0.85 per share. These preferred stock would have a required return of 7.5%. The firm currently has no preferred stock outstanding. The fourth option is to issue common stock.

The stock is currently trading on the market for $20 per share. The firm most recently paid a dividend on common stock of $0.50 and plans to increase that dividend by 25% per year for the next five years.

After that, the firm will level off at the industry average of 5% per year, indefinitely. Carrington and Genevieve estimate the required return on the stock to be 15%.

In the first case study, your group made a financing recommendation. Assume the company goes with your recommendation and use the financial information provided in the file “Financial_Info_Case2.xlsx” for the past two years to analyze and forecast the firm’s financial position. In doing so, answer the following questions.

1. Calculate the cash flows for 2017 (OCF, NCS, Change in NWC, FCF, CFC, CFS)

2. Calculate Profit Margin, Total Asset Turnover, Equity Multiplier, ROA, ROE, Debt-Equity Ratio, Total Debt Ratio, Plowback Ratio, Dividend Payout Ratio, Internal Growth Rate, and Sustainable Growth Rate.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Calculate profit margin total asset turnover equity
Reference No:- TGS02789839

Expected delivery within 24 Hours