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. Which of the following formulas would correctly give the forecast for sales in cell C8?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

 

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. Which of the following formulas would correctly give the forecast for sales in cell C8?

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education