Financial Statement Forecasting Percent of Sales Analyze Historical Ratios Percent sales method will be some specified percentage of sales. Using historical ratio of costs to sales (preferably at least 5 years back), and other ratios to sales, an estimate of the percentage of sales in the future can be made. Depreciation is better viewed as a percent of net plant and equipment because it depends on the asset base. Proper forecasting also analyzes the industry averages in deriving pro forma statements. Cost to sales Cash to sales AR to sales Inventory to sales Net plant and equipment to sales AP to sales Accruals to sales Depreciation to net plant and equipment Table 1: Historical Ratios for Craig Incorporated Ratio Actual 2018 Actual 2019 Historical Ave Industry Ave (%) 872 09 11.1 12.5 100 11.8 17.5 14.6 20.5 Cost/Sales Cash/Sales AR / Sales Inventory / Sales Net PPE / Sales AP/ Sales Accruals/ Sales Depreciation/PPE 30.5 33.3 1.1 31.9 1.5 2.0 4.7 2.0 10.2 10.3 10.2 Forecast the Income Statement Using the percent of sales method you can forecast the income statement. Items to note: growth = loi Trent Interest Expense Specify the balance of debt for computing interest expense Use the debt at the beginning of the year Specify the interest rate o Use an interest rate higher than the expected rate to account for increases in loan balances throughout the year. 0.5% is acceptable. O Short term rate - use current market rates - assume 8.5% for this example o Long term rate-average rates of current long-term debt - assume 10.5% for this example Acthal dent Calculate the interest expense o Interest expense - interest income...there is no interest income in this example o Short term - use interest rates and notes payable O Long-term - use value from balance sheet and interest rate Dividends Deprecich Preferred stock pays a dividend of 10% PPE Common share dividend expected to increase 8% Nel PE/Sales growth lol Forecast 2020 (S000,000) 2. 8 7 . Table 2: Craig Incorporated Income Statement for 2019 and 2020E Actual Forecast Basis 2019 (S000,000) Boo Sales 3,000.0 Cost excluding depe 2.616.2 3300 x.8723 Depreciation 100.0 Total Op Costs 2.716.2 EBIT 283.8 Interest 88.0 EBT 195.8 Tax 78.3 NI before pref. dividends 117.5 Preferred dividends 4.0 NI available to common 113.5 # Shares common equity Dividend per share (S) 1.15 Dividends to common 57.5 Additions to RE Please show your work Forecast Basis Forecast 2020 (S000.000) Table 3: Craig Incorporated Balance Sheet for 2019 and 2020E Actual 2019 (S000,000) ASSETS Cash 10.0 Short-term investments 0.0 375.0 Inventory 615.0 Total CA 1.000.0 Net PPE 1.000.0 Total Assets 2,000.0 AR LIABILITIES & EQUITY AP Accruals. NP Total CL... Long-term debt Total Liabilities Preferred Stock Common Stock Retained Earnings Total Common Equity Total Liabilities & Equity Required assets Specified sources of funding Additional Funds Needed Required add. NP Additional ST investments 60.0 140.0 110.0 310.0 754.0 1,064.0 40.0 130.0 766,0 896.0 2,000.0 Financial Statement Forecasting Percent of Sales Analyze Historical Ratios Percent sales method will be some specified percentage of sales. Using historical ratio of costs to sales (preferably at least 5 years back), and other ratios to sales, an estimate of the percentage of sales in the future can be made. Depreciation is better viewed as a percent of net plant and equipment because it depends on the asset base. Proper forecasting also analyzes the industry averages in deriving pro forma statements. Cost to sales Cash to sales AR to sales Inventory to sales Net plant and equipment to sales AP to sales Accruals to sales Depreciation to net plant and equipment Table 1: Historical Ratios for Craig Incorporated Ratio Actual 2018 Actual 2019 Historical Ave Industry Ave (%) 872 09 11.1 12.5 100 11.8 17.5 14.6 20.5 Cost/Sales Cash/Sales AR / Sales Inventory / Sales Net PPE / Sales AP/ Sales Accruals/ Sales Depreciation/PPE 30.5 33.3 1.1 31.9 1.5 2.0 4.7 2.0 10.2 10.3 10.2 Forecast the Income Statement Using the percent of sales method you can forecast the income statement. Items to note: growth = loi Trent Interest Expense Specify the balance of debt for computing interest expense Use the debt at the beginning of the year Specify the interest rate o Use an interest rate higher than the expected rate to account for increases in loan balances throughout the year. 0.5% is acceptable. O Short term rate - use current market rates - assume 8.5% for this example o Long term rate-average rates of current long-term debt - assume 10.5% for this example Acthal dent Calculate the interest expense o Interest expense - interest income...there is no interest income in this example o Short term - use interest rates and notes payable O Long-term - use value from balance sheet and interest rate Dividends Deprecich Preferred stock pays a dividend of 10% PPE Common share dividend expected to increase 8% Nel PE/Sales growth lol Forecast 2020 (S000,000) 2. 8 7 . Table 2: Craig Incorporated Income Statement for 2019 and 2020E Actual Forecast Basis 2019 (S000,000) Boo Sales 3,000.0 Cost excluding depe 2.616.2 3300 x.8723 Depreciation 100.0 Total Op Costs 2.716.2 EBIT 283.8 Interest 88.0 EBT 195.8 Tax 78.3 NI before pref. dividends 117.5 Preferred dividends 4.0 NI available to common 113.5 # Shares common equity Dividend per share (S) 1.15 Dividends to common 57.5 Additions to RE Please show your work Forecast Basis Forecast 2020 (S000.000) Table 3: Craig Incorporated Balance Sheet for 2019 and 2020E Actual 2019 (S000,000) ASSETS Cash 10.0 Short-term investments 0.0 375.0 Inventory 615.0 Total CA 1.000.0 Net PPE 1.000.0 Total Assets 2,000.0 AR LIABILITIES & EQUITY AP Accruals. NP Total CL... Long-term debt Total Liabilities Preferred Stock Common Stock Retained Earnings Total Common Equity Total Liabilities & Equity Required assets Specified sources of funding Additional Funds Needed Required add. NP Additional ST investments 60.0 140.0 110.0 310.0 754.0 1,064.0 40.0 130.0 766,0 896.0 2,000.0