Answered step by step
Verified Expert Solution
Link Copied!

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

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?

Multiple Choice

  • None of the options are correct.

  • = F19 + B4 C16

  • = F19 B2

  • = F19 (1 + B2)

  • = F19 + (1 B4) C16

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th edition

1118096894, 978-1-11921511, 978-1118096895

Students also viewed these Accounting questions

Question

2. Have enough shelves so that materials need not be stacked.

Answered: 1 week ago