Selected assumptions for 2018 Sales growth rate 9 % Cost of goods sold/Sales 62 % Dividends/Net income 40 % Income Statement Balance Sheet Actual Forecast Actual 2017 2018 2017 2018 Sales $ 1,000 Cash $ 100 Cost of goods sold 600 Accounts receivable 200 Operating expense 200 Inventory 500 Depreciation expense 100 Total Current Assets 800 EBIT 100 Net PP&E 1,000 Interest expense 35 Total Assets 1,800 Pre-tax income 65 Accounts payable 300 Tax 26 Bank loan 100 Net Income $39 Total Current Liabilities 400 Long-Term Debt 400 Shareholders' Equity 1,000 Total Liabilities & Equity $ 1,800 Please refer to the spreadsheet above. Selected assumptions are given for preparing pro forma financial statements for 2018. Which of the following formulas would correctly give the forecast for sales in cell C8? Forecast

Selected assumptions for 2018 Sales growth rate 9 % Cost of goods sold/Sales 62 % Dividends/Net income 40 % Income Statement Balance Sheet Actual Forecast Actual 2017 2018 2017 2018 Sales $ 1,000 Cash $ 100 Cost of goods sold 600 Accounts receivable 200 Operating expense 200 Inventory 500 Depreciation expense 100 Total Current Assets 800 EBIT 100 Net PP&E 1,000 Interest expense 35 Total Assets 1,800 Pre-tax income 65 Accounts payable 300 Tax 26 Bank loan 100 Net Income $39 Total Current Liabilities 400 Long-Term Debt 400 Shareholders' Equity 1,000 Total Liabilities & Equity $ 1,800 Please refer to the spreadsheet above. Selected assumptions are given for preparing pro forma financial statements for 2018. Which of the following formulas would correctly give the forecast for sales in cell C8? Forecast

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter9: Corporate Valuation And Financial Planning

Section: Chapter Questions

Problem 4P: Sales Increase Maggies Muffins Bakery generated 5 million in sales during 2018, and its year-end...

See similar textbooks

Similar questions

Profitability ratios The following selected data were taken from the financial statements of Robinson Inc. for December 31, 2016, 2015 and 2014: December31 2016 2015 2014 Total assets......................................... 4,800,000 4,400,000 4,000,000 Notes payable (8% interest)........................... 2,250,000 2,250,000 2,250,000 Common stock...................................... 250,000 250,000 250,000 Preferred 4% stock, 100 par (no change during year)........................... 500,000 500,000 500,000 Retained earnings................................... 1,574,000 1,222,000 750,000 The 2016 net income was 372,000, and the 2015 net income was 492,000. No dividends on common stock were declared between 2014 and 2016. a. Determine the rate earned on total assets, the rate earned on stockholders equity, and the rate earned on common Stockholders equity for the years 2015 and 2016. Round to one decimal place. b. What conclusions can be drawn from these data as to the companys profitability?
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Return on assets The following data (in millions) were adapted from recent financial statements of Tootsie Roll Industries Inc. (TR): The percent a company adds to its cost of sales to determine selling price is called a markup. What is Tootsie Roll’s markup percent? Round to one decimal place.
Financial leverage MicrosoCortrepotied (MSFT) reported the following data (in millions) for a tern year Compute the profit margin, asset turnover, and financial leverage metrics using the expandedDuPont formula. Round profit margin, asset turnover, and financial leverage to two decimalplaces.Round return on stockholders’ equity to one decimal place.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Price-earnings ration
Sales Increase Maggies Muffins Bakery generated 5 million in sales during 2018, and its year-end total assets were 2.5 million. Also, at year-end 2018, current liabilities were 1 million, consisting of 300,000 of notes payable, 500,000 of accounts payable, and 200,000 of accruals. Looking ahead to 2019, the company estimates that its assets must increase at the same rate as sales, its spontaneous liabilities will increase at the same rate as sales, its profit margin will be 7%, and its payout ratio will be 80%. How large a sales increase can the company achieve without having to raise funds externallythat is, what is its self-supporting growth rate?