Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 Forecast 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. Assume that no new equity will be issued in 2018. When the pro formas are completed, which of the following formulas would correctly give the forecast for shareholders' equity in cell G19?
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