Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete the balance sheet. Please show work. Suppose that you are forecasting the financial statements (income statement and balance sheet) for Boston Industries for

Please complete the balance sheet. Please show work. image text in transcribed
image text in transcribed
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 Balance Sheet: 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 Balance Sheet

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

Value Based Management For Accounts Receivable

Authors: Kimberly Don Ketron

1505911184, 978-1505911183

More Books

Students also viewed these Accounting questions

Question

What is topology? Explain with examples

Answered: 1 week ago

Question

b. Why were these values considered important?

Answered: 1 week ago