Presented below is the balance sheet of ABC Company as of December 31, 2015: Assets                                                          Liabilities & Equity  Cash                            Php30,400              Income Tax payable    Php   4,800 Accounts receivable         48,000    Inventory                           17,600              Ordinary Shares               256,000 PPE                                  232,000              Retained Earnings              67,200 Total Assets              Php328,000              Total L&E                  Php 328,000   The manager instructs you to update the balances based on the budget below:                                      1st Quarter         2nd Quarter       3rd Quarter       4th Quarter Sales                            Php112,000       Php128,000       Php144,000      Php140,800 Production Costs       76,800                80,000                89,600               80,000 Operating expenses  25,600                27,200                28,800                30,400   Annual depreciation (included in the amounts above):           -Production costs: Php70,400           -Operating expenses: Php19,200 Inventory balances are expected to be:        Mar 31: Php56,000; Jun 30: Php52,000; Sep 30: Php60,000 Dec 31: Php48,000 All production costs and operating expenses, except depreciation, are to be paid during the quarter incurred. Sales are made either through cash or credit. The Company expects quarterly sales to be made 20% in cash and 80% in credit. As to the credit sales, the same are collected 50% in the quarter of sales and 48% in the quarter after the sale. The rest are budgeted to be uncollectible and recognized as bad debts in the quarter incurred. There is no allowance for bad debts as of December 31, 2015. Dividends are paid at the end of June and December. The amount of dividends is 10% of the cash balance available at the end of the 1st quarter for June dividends and the 3rd quarter for December dividends. Income tax is equal to 30% of the quarter’s income and is paid in the following quarter.

Financial & Managerial Accounting
13th Edition
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 15.17EX: Profitability ratios The following selected data were taken from the financial statements of...
icon
Related questions
icon
Concept explainers
Question

40

Presented below is the balance sheet of ABC Company as of December 31, 2015:

Assets                                                          Liabilities & Equity 

Cash                            Php30,400              Income Tax payable    Php   4,800

Accounts receivable         48,000   

Inventory                           17,600              Ordinary Shares               256,000

PPE                                  232,000              Retained Earnings              67,200

Total Assets              Php328,000              Total L&E                  Php 328,000

 

The manager instructs you to update the balances based on the budget below: 

                                    1st Quarter         2nd Quarter       3rd Quarter       4th Quarter

Sales                            Php112,000       Php128,000       Php144,000      Php140,800

Production Costs       76,800                80,000                89,600               80,000

Operating expenses  25,600                27,200                28,800                30,400

 

  • Annual depreciation (included in the amounts above):

          -Production costs: Php70,400

          -Operating expenses: Php19,200

  • Inventory balances are expected to be:

       Mar 31: Php56,000; Jun 30: Php52,000; Sep 30: Php60,000 Dec 31: Php48,000

  • All production costs and operating expenses, except depreciation, are to be paid during the quarter incurred.
  • Sales are made either through cash or credit. The Company expects quarterly sales to be made 20% in cash and 80% in credit. As to the credit sales, the same are collected 50% in the quarter of sales and 48% in the quarter after the sale. The rest are budgeted to be uncollectible and recognized as bad debts in the quarter incurred. There is no allowance for bad debts as of December 31, 2015.
  • Dividends are paid at the end of June and December. The amount of dividends is 10% of the cash balance available at the end of the 1st quarter for June dividends and the 3rd quarter for December dividends.
  • Income tax is equal to 30% of the quarter’s income and is paid in the following quarter.

 

Cash balance as of September 30, 2016:

Group of answer choices
P75,866
P60,800
P110,992
P142,280
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Cost of Capital
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
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
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
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning