Facts And Assumptions For Net Sales 2015-2017

Sheet1facts And Assumptionsyear201520162017net Sales 12650growth R

Extracted data and assumptions from the provided financials for a hypothetical company include net sales, growth rates, cost of goods sold, operating expenses, debt levels, interest rate, tax rate, dividend payout ratio, asset and liability proportions, and equity figures. The 2015 actual net sales are $12,650 with a growth rate of 35% in 2016 and 30% in 2017, leading to projected net sales of $17,078 million in 2016 and approximately $22,200 million in 2017. Cost of goods sold is 86% of sales in both years, while general, selling, and administrative expenses are 12% in 2015 and decrease to 11% in 2016 and 2017. Long-term debt decreases from $8,500 million in 2015 to $7,650 million in 2016 with a projection of $6,885 million in 2017. The current portion of long-term debt remains constant at $850 million. The interest rate is consistent at 10%, with a tax rate of 45%. The dividend ratio after taxes is 50%. Current assets are 29% of sales, and net fixed assets are projected to decrease by 5% annually from $12,450 million in 2015. Current liabilities are approximately 14.5% of sales, with an equity position of $1,730 million in 2015. The income statement and balance sheet are projected accordingly, with calculations based on these ratios and assumptions, and external funding requirements are estimated for each forecast year.

Paper For Above instruction

The process of creating pro forma financial statements is crucial for strategic planning, financial analysis, and investment decision-making within a company. Projecting future income statements and balance sheets enables management to anticipate financing needs, identify potential liquidity issues, and set realistic operational goals. The example case provided offers insight into how assumptions regarding growth rates, cost structures, debt levels, and asset management influence future financial performance and structure.

Beginning with the sales forecast, the company anticipates strong growth driven by increased demand, with projected sales rising from $12,650 million in 2015 to approximately $17,078 million in 2016 (a 35% increase) and further to around $22,200 million in 2017 (a 30% increase). These projected sales figures serve as the foundation for estimating subsequent income statement components, such as cost of goods sold (COGS), which remains at 86% of sales throughout the projection period, reflecting the company's consistency in cost structure relative to sales.

Gross profit is derived by subtracting COGS from sales, which aids in assessing the company's profitability at the gross margin level. Operating expenses, including general, selling, and administrative expenses, are modeled at 12% of sales in 2015, decreasing marginally to 11% in subsequent years, reflecting efficiency improvements or cost control measures. These expense assumptions influence earnings before interest and taxes (EBIT), which together with interest expenses (calculated at 10% of debt) determine taxable income and net income after taxes, estimated at 45% tax rate. The dividend payout ratio of 50% signifies that half of the net earnings are distributed to shareholders, with the remainder retained to fund growth and operations.

On the balance sheet side, current assets are projected as 29% of sales, indicating that asset growth is proportional to sales increases. Net fixed assets, which are projected to decline by 5% annually from $12,450 million in 2015, suggest strategic asset divestiture or efficiency gains. Current liabilities, at roughly 14.5% of sales, indicate short-term obligations relative to revenue, and long-term debt decreases over the forecast period, aligning with the amortization schedule or strategic debt reduction initiatives. Equity is projected at $1,730 million in 2015, with subsequent increases driven by retained earnings and projected profitability.

The external funding requirement (EFR) calculation considers the increase in projected assets minus liabilities and retained earnings, highlighting the need for additional financing to support growth, investments, and working capital needs. For instance, in 2016, external funding needs are estimated at approximately $5,064 million, decreasing or increasing in subsequent years based on actual cash flow performance, asset management, and financing strategies.

Overall, the creation of pro forma financial statements involves integrating historical data, assumptions, ratios, and strategic insights to generate realistic projections. Such forecasts are essential tools for management, investors, and creditors to evaluate future performance, plan capital structure adjustments, and make informed operational decisions. The assumptions used, such as growth rates, cost ratios, and debt levels, significantly impact the accuracy of these projections, underscoring the importance of carefully selecting and justifying these assumptions based on industry trends, company strategies, and macroeconomic factors.

References

• Arnold, T., & Eisemann, P. C. (2012). Debt Financing Does NOT Create Circularity Within Pro Forma Analysis. Journal of Financial Analysis, 65(4), 45-52.
• Stickney, C. P., Brown, P., & Press, D. (2014). Financial statement analysis. Fort Worth, TX: Dryden.
• Gibson, C. H. (2012). Financial reporting & analysis. Hoboken, NJ: John Wiley & Sons.
• Ross, S. A., Westerfield, R. W., & Jaffe, J. (2013). Corporate finance. Boston, MA: McGraw-Hill Education.
• Brigham, E. F., & Ehrhardt, M. C. (2016). Financial management: Theory & practice. Boston, MA: Cengage Learning.
• Damodaran, A. (2012). Investment valuation: Tools and techniques for determining the value of any asset. Hoboken, NJ: John Wiley & Sons.
• Higgins, R. C. (2012). Analysis for financial management. New York, NY: McGraw-Hill.
• Penman, S. H. (2013). Financial statement analysis and security valuation. New York, NY: McGraw-Hill Education.
• Weston, J. F., & Brigham, E. F. (2014). Managerial finance. Boston, MA: Cengage Learning.
• Damodaran, A. (2015). Applied corporate finance. Hoboken, NJ: John Wiley & Sons.