rporation recently reported the the following 2019 balance sheet and 2019 income statement (in pesos): For the coming year, the company's CFO has assembled this information: - The company is forecasting a 25% increase in sales - It expects that its cost of goods sold, operating expenses, assets and current liabilities will increase at the same rate as sales - Interest expense, long term debt and capital stock are expected to remain constant. -Tax rate is expected to remain at 30%. - No dividends will be declared. Prepare the statement of cash flows for the year 2020 using the percent of sales method (estimation method) ECL CORPORATION

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter11: The Statement Of Cash Flows
Section: Chapter Questions
Problem 27BE
icon
Related questions
Question

ECL Corporation recently reported the the following 2019 balance sheet and 2019 income statement (in pesos):

For the coming year, the company's CFO has assembled this information:

- The company is forecasting a 25% increase in sales

- It expects that its cost of goods sold, operating expenses, assets and current liabilities will increase at the same rate as sales

- Interest expense, long term debt and capital stock are expected to remain constant.

-Tax rate is expected to remain at 30%.

- No dividends will be declared.

Prepare the statement of cash flows for the year 2020 using the percent of sales method (estimation method)

ECL CORPORATION  
BALANCE SHEET  
DECEMBER 31, 2019  
   

ASSETS

 
CURRENT ASSETS  
  CASH               114,690
  ACCOUNTS RECEIVABLE                     1,000

  INVENTORY

                    1,000
TOTAL CURRENT ASSETS               116,690
   

FIXED ASSETS

 
  NET FIXED ASSETS                  40,000
   
TOTAL ASSETS               156,690
   
LIABILITIES  
CURRENT LIABILITIES  
  ACCOUNTS PAYABLE                     2,000
  NOTES PAYABLE  
TOTAL CURRENT LIABILITIES                     2,000
   
LONG TERM DEBT                  13,000
   
TOTAL LIABILITIES                   15,000
   
STOCKHOLDERS' EQUITY  
  CAPITAL STOCK                  60,000
   
  RETAINED EARNINGS, BEGINNING                  32,130
  ADD: NET INCOME (LOSS)                   49,560
  LESS: DIVIDENDS -
  RETAINED EARNINGS, END                  81,690
   
TOTAL STOCKHOLDERS EQUITY                141,690
 TOTAL LIABILITIES AND STOCKHOLDERS EQUITY

              156,690

 

ECL CORPORATION  
INCOME STATEMENT  
FOR THE YEAR ENDED  DECEMBER 31, 2019
   
SALES (NET) 200,000
COST OF GOODS SOLD 100,000
GROSS PROFIT 100,000
LESS: OPERATING EXPENSES  
  SALARIES 12,000
  GASOLINE/TRAVEL 2,000
  UTILITIES 4,000
  DEPRECIATION 10,000
TOTAL OPERATING EXPENSES 28,000
INCOME (LOSS) FROM OPERATIONS 72,000
LESS: INTEREST 1,200
INCOME BEFORE TAXES 70,800
LESS: TAXES (30%) 21,240
NET INCOME AFTER TAXES 49,560

 

 

ECL CORPORATION  
PROJECTED INCOME STATEMENT  
FOR THE YEAR ENDED  DECEMBER 31, 2020
   
SALES (NET) 250,000
COST OF GOODS SOLD 125,000
GROSS PROFIT 125,000
LESS: OPERATING EXPENSES  
  SALARIES 15,000
  GASOLINE/TRAVEL 2,500
  UTILITIES 5,000
  DEPRECIATION 12,500
TOTAL OPERATING EXPENSES 35,000
INCOME (LOSS) FROM OPERATIONS 90,000
LESS: INTEREST 1,200
INCOME BEFORE TAXES 88,800
LESS: TAXES (30%) 26,640
NET INCOME AFTER TAXES 62,160

 

ECL CORPORATION  
PROJECTED BALANCE SHEET  
DECEMBER 31, 2020  
   

ASSETS

 
CURRENT ASSETS  
  CASH           143,362.50
  MARKETABLE SECURITIES             23,487.50
  ACCOUNTS RECEIVABLE                     1,250

  INVENTORY

                    1,250
TOTAL CURRENT ASSETS               169,350
   

FIXED ASSETS

 
  NET FIXED ASSETS                 50,000
   
TOTAL ASSETS               219,350
   
LIABILITIES  
CURRENT LIABILITIES  
  ACCOUNTS PAYABLE                     2,500
  NOTES PAYABLE -
TOTAL CURRENT LIABILITIES                     2,500
   
LONG TERM DEBT                  13,000
   
TOTAL LIABILITIES                   15,500
   
STOCKHOLDERS' EQUITY  
  CAPITAL STOCK                  60,000
   
  RETAINED EARNINGS, BEGINNING                 81,690
  ADD: NET INCOME (LOSS)                 62,160
  LESS: DIVIDENDS -
  RETAINED EARNINGS, END                         143,850
   
TOTAL STOCKHOLDERS EQUITY              203,850
 TOTAL LIABILITIES AND STOCKHOLDERS EQUITY

              219,350

 

 

 

ECL CORPORATIÓN
PROJECTED STATEMENT OF CASH FLOWS
FOR THE YEAR ENDING DECEMBER 31, 2020
(IN PESOS)
Cash Flow From Operating Activities
Net Income After Tax
Add: Depreciation Expense
Increase (decrease) in Accounts Receivable
-(+)
Increase (decrease) in Inventories
-(+)
Increase (decrease) in Other Current Assets
-(+)
Increase (decrease) in Accounts Payable
+(-)
Increase (decrease) in Accruals
+(-)
Increase (decrease) in Other Current Liabilities
+(-)
Total Cash Flow from Operating Activities
Cash Flow From Investing Activities
Increase (decrease) in Gross Fixed Assets
-(+)
Increase (decrease) in Investments
|-(+)
Total Cash Flow From Investing Activities
Cash Flow From Financing Activities
Increase (decrease) in Short Term Debt
+(-)
Increase (decrease) in Long Term Debt
+(-)
Increase (decrease) in Capital Stock
+(-)
Dividends Paid (Withdrawals)
(-)
Total Cash Flow From Financing Activities
Change In Cash
Add: Cash Beginning (January 1, 2020)
Equals Cash Ending (December 31, 2020)
Transcribed Image Text:ECL CORPORATIÓN PROJECTED STATEMENT OF CASH FLOWS FOR THE YEAR ENDING DECEMBER 31, 2020 (IN PESOS) Cash Flow From Operating Activities Net Income After Tax Add: Depreciation Expense Increase (decrease) in Accounts Receivable -(+) Increase (decrease) in Inventories -(+) Increase (decrease) in Other Current Assets -(+) Increase (decrease) in Accounts Payable +(-) Increase (decrease) in Accruals +(-) Increase (decrease) in Other Current Liabilities +(-) Total Cash Flow from Operating Activities Cash Flow From Investing Activities Increase (decrease) in Gross Fixed Assets -(+) Increase (decrease) in Investments |-(+) Total Cash Flow From Investing Activities Cash Flow From Financing Activities Increase (decrease) in Short Term Debt +(-) Increase (decrease) in Long Term Debt +(-) Increase (decrease) in Capital Stock +(-) Dividends Paid (Withdrawals) (-) Total Cash Flow From Financing Activities Change In Cash Add: Cash Beginning (January 1, 2020) Equals Cash Ending (December 31, 2020)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Forecasting Financial Statement
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
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage