Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Financial Accounting

Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta

21st Edition

0077525264, 978-0077525262

More Books

Students also viewed these Accounting questions

Question

Name some causes of poor decisions

Answered: 1 week ago

Question

2 What are the psychological stages of coping with change?

Answered: 1 week ago

Question

6 Why is change considered a central aspect of HRM practice?

Answered: 1 week ago