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 ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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 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