Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the balance sheet. Please show work. Suppose that you are forecasting the financial statements (income statement and balance sheet) for Boston Industries for 2020.
Complete the balance sheet. Please show work.
Suppose that you are forecasting the financial statements (income statement and balance sheet) for Boston Industries for 2020. You will use their income statement and balance sheet for 2019 as a starting point along with the following assumptions: Sales will grow by 15%; Operating (EBIT) margin will be 30%; Interest expense will remain $200, regardless of any changes in debt outstanding as interest rates are expected to decline. Dividend payout will be 33%; Cash will be 12% of sales; Accounts receivable days will be 60. Inventory period will be 150 days. Fixed asset turnover will be 0.8x. Accounts payable period will be 120 days. They intend to add $100 of long-term debt. They will borrow $10 in short- term debt. They will repurchase $500 in common stock; and depreciation expense will be $100. (Depreciation is included in actual and forecast COGS but not listed separately on the income statement). If needed, marketable securities can serve as excess cash. If forecast total assets exceed forecast total liabilities and equity, assume the shortfall will be financed by a line of credit. Use a 365-day year and whatever other assumptions you need to make your statements consistent. 2019 2019 Sales 4,000 Cash 400 Accounts Payable 1000 COGS (incl. Dep.) 3,000 Accounts Receivable 800 Notes payable 600 EBIT 1,000 Inventory 1600 Total Current Liabilities 1600 Interest expense 200 Total Current Assets 2800 Long term debt 1400 Taxable income 800 Common stock 2000 Taxes (40%) 320 Fixed Assets 5200 Retained earnings 3000 Net Income 480 Total Equity 5000 Dividends 96 Total Assets 8000 Total liabilities and equity 8000 Assume: Inventory = Cost of goods sold per day x Inventory Days Accounts receivable = Sales per day x Accounts Receivable Days Accounts payable = COGS per day x Accounts Payable Days Fixed assets = Sales/Fixed assets turnover Suppose that you are forecasting the financial statements (income statement and balance sheet) for Boston Industries for 2020. You will use their income statement and balance sheet for 2019 as a starting point along with the following assumptions: Sales will grow by 15%; Operating (EBIT) margin will be 30%; Interest expense will remain $200, regardless of any changes in debt outstanding as interest rates are expected to decline. Dividend payout will be 33%; Cash will be 12% of sales; Accounts receivable days will be 60. Inventory period will be 150 days. Fixed asset turnover will be 0.8x. Accounts payable period will be 120 days. They intend to add $100 of long-term debt. They will borrow $10 in short- term debt. They will repurchase $500 in common stock; and depreciation expense will be $100. (Depreciation is included in actual and forecast COGS but not listed separately on the income statement). If needed, marketable securities can serve as excess cash. If forecast total assets exceed forecast total liabilities and equity, assume the shortfall will be financed by a line of credit. Use a 365-day year and whatever other assumptions you need to make your statements consistent. 2019 2019 Sales 4,000 Cash 400 Accounts Payable 1000 COGS (incl. Dep.) 3,000 Accounts Receivable 800 Notes payable 600 EBIT 1,000 Inventory 1600 Total Current Liabilities 1600 Interest expense 200 Total Current Assets 2800 Long term debt 1400 Taxable income 800 Common stock 2000 Taxes (40%) 320 Fixed Assets 5200 Retained earnings 3000 Net Income 480 Total Equity 5000 Dividends 96 Total Assets 8000 Total liabilities and equity 8000 Assume: Inventory = Cost of goods sold per day x Inventory Days Accounts receivable = Sales per day x Accounts Receivable Days Accounts payable = COGS per day x Accounts Payable Days Fixed assets = Sales/Fixed assets turnover Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started