MGT 325 Module 5 Spreadsheet Exam This Is One Long Pro
Sheet1mgt 325 Module 5 Spreadsheet Exam This Is One Long Problem Or
This problem involves analyzing a company's capital structure, calculating cost of capital components, and determining funding strategies for new projects based on given financial data. The firm, Saint Leo Manufacturing, plans to invest $100 million in four projects with specified investments and expected returns, and its current capital structure includes debt, preferred stock, and common stock, each with specific market values and costs. The analysis requires calculating the current cost of debt (before tax), the cost of preferred stock, and the cost of equity, then adjusting these for new issue scenarios and understanding how the firm’s retained earnings impact its ability to finance projects internally versus issuing new stock. The problem spans multiple parts, each building on the previous, including calculating current costs, determining new costs with additional issuance, and analyzing the marginal cost of capital and impact on financing options.
Paper For Above instruction
Saint Leo Manufacturing is at a critical juncture as it seeks to finance a substantial $100 million investment in a new product line through a combination of debt, preferred stock, and common equity. The company's existing capital structure and market conditions significantly influence its cost of capital, which in turn determines whether internal funds suffice or new capital must be raised through issuing preferred or common stock. This analysis explores the various components of the firm's cost of capital, starting with calculating the current costs assuming no new issuance, then considering the effects of new preferred stock issues, and finally assessing the point at which retained earnings are depleted and external equity issuance becomes necessary.
Initially, we focus on determining the current cost of debt (K_d), preferred stock (K_p), and equity (K_e) without accounting for new issues. The current debt is valued at $20 million, with an annual interest rate of 6.00%, and the debt's market price and maturity are specified. Since tax considerations affect the after-tax cost of debt, we apply the corporate tax rate of 35% to find the effective after-tax cost, which is the relevant measure for company valuation. For preferred stock, the current market price, dividend, and flotation costs are used to compute the cost of preferred stock, considering the dividend as a percentage of the price, adjusted for flotation costs. The cost of equity is derived using the dividend discount model, considering the last dividend, growth rate, and current stock price.
Moving forward, the analysis considers the scenario where any new capital must be raised through issuing preferred stock, leading to adjustments in the cost of preferred stock and the overall weighted average cost of capital (WACC). The premiums and flotation costs associated with issuing new preferred stock influence the calculation of the new required returns. These adjustments reflect investor expectations and the costs associated with raising additional funds.
Furthermore, assessing the firm's internal capacity to fund investments involves analyzing how much retained earnings can support before external equity is required. As retained earnings are utilized, the marginal cost of capital (MCC) increases, eventually forcing the company to issue new common stock. By modeling the depletion of retained earnings, based on the growth rate and dividend reinvestment, the analysis identifies the threshold where external financing becomes unavoidable.
Finally, if new common stock issuance becomes necessary, the expected required return (K_ne) is likely to be higher due to increased risk perceptions among shareholders and market conditions. The new cost of capital incorporates these increased return expectations, and the firm's overall financing strategy must adapt accordingly to maintain an optimal capital structure and ensure cost-effective investment in growth opportunities.
References
- Brigham, E. F., & Ehrhardt, M. C. (2016). Financial Management: Theory & Practice (15th ed.). Cengage Learning.
- Ross, S. A., Westerfield, R. W., & Jaffe, J. (2019). Corporate Finance (12th ed.). McGraw-Hill Education.
- Brealey, R. A., Myers, S. C., & Allen, F. (2020). Principles of Corporate Finance (13th ed.). McGraw-Hill Education.
- Damodaran, A. (2015). Applied Corporate Finance (4th ed.). John Wiley & Sons.
- Koller, T., Goedhart, M., & Wessels, D. (2010). Valuation: Measuring and Managing the Value of Companies. Wiley Finance.
- Copeland, T., Weston, J. F., & Shastri, K. (2005). Financial Theory and Corporate Policy (4th ed.). Pearson.
- Principles of Financial Modelling. (2020). CFA Institute. Retrieved from https://www.cfainstitute.org
- Jorion, P. (2007). Financial Risk Manager Handbook (5th ed.). Wiley.
- Lintner, J. (1956). "Distribution of Income of Corporations among Dividends, Retained Earnings, and Taxes." The American Economic Review, 46(2), 97-113.
- Fama, E. F., & French, K. R. (2002). "The Capital Asset Pricing Model: Theory and Evidence." The Journal of Economic Perspectives, 16(3), 25-46.