Spooky Company's sales, current assets and current liabilities (all in thousands of pesos) have been reported as follows over the last five years (Year 5 is the most recent year): Year 5 Year 4 Year 3 Year 2 Year I Sales. P5,625 P5,400 P4.950 P4,725 P4,500 ....... Current assets: Cash .. Accounts receivable.. Inventory. P 64 560 896 P 72 P 84 496 880 P 88 P 80 432 816 416 400 864 800 Total current assets...... PL520 PL448 P1.332 PL368 P1.280 Currerit liabilities. .. P390 P 318 P 324 P_330 P 300

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
41 11:35 0.20 (-)
46 4 30
KB/s
Financial Statement.
studocu.com
= StuDocuU
Problem 2
Spooky Company's sales, current assets and current liabilities (all in
thousands of pesos) have been reported as follows over the last five years
(Year 5 is the most recent year):
Year 5
P5,625
Year 2
P4,725
Year 4
Year 3
Year I
P4,500
Sales
P5.400
P4.950
Current assets:
Cash
Accounts receivable
Inventory
P
64
P 72
P 88
80
560
496
432
416
400
896
880
816
864
800
Total current assets. .
PL.520
PL.448
P1.332
PL.368
P1.280
Current liabilities
.... P 390
P 318
P 324
P_330
P 300
Requirements:
1. Express all of the asset, liability, and sales in trend percentages. (Show percentages for each
item.) Use Year 1 as the base year, and carry computations to one decimal place.
2. Comment on the result of your analysis.
3 out of 4
Transcribed Image Text:41 11:35 0.20 (-) 46 4 30 KB/s Financial Statement. studocu.com = StuDocuU Problem 2 Spooky Company's sales, current assets and current liabilities (all in thousands of pesos) have been reported as follows over the last five years (Year 5 is the most recent year): Year 5 P5,625 Year 2 P4,725 Year 4 Year 3 Year I P4,500 Sales P5.400 P4.950 Current assets: Cash Accounts receivable Inventory P 64 P 72 P 88 80 560 496 432 416 400 896 880 816 864 800 Total current assets. . PL.520 PL.448 P1.332 PL.368 P1.280 Current liabilities .... P 390 P 318 P 324 P_330 P 300 Requirements: 1. Express all of the asset, liability, and sales in trend percentages. (Show percentages for each item.) Use Year 1 as the base year, and carry computations to one decimal place. 2. Comment on the result of your analysis. 3 out of 4
491 11:34 10 (-)
46 4 29
KB/s
Financial Statement.
studocu.com
= StuDocuU
Part 2
Problem 1
The following data are available for XYZ Corporation for years 2014 and
2013.
XYZ Corporation
Statement of Financial Position
As of December 31
Change
Peso
2013
2014
Assets
14,000
28,800
54,000
4.800
101,600
16,000
55,600
85,600
7.400
164,600
2,000
26,800
Cash and equivalents
Receivables
Inventories
Prepayments and others
Total Current Assets
93.06%
?
2,600
54.17%
62.01%
Property, Plant & Equipment
- net of depreciation
Total Assets
30,200
131.800
73.400
238.000
43,200
143.05%
Liabilities and Equity
Notes payable to banks
Accounts payable
44,000
23,800
2,600
10,000
31,600
4,200
5,800
51,600
44,600
35.600
80,200
131.800
54,000
55,400
6,800
7,000
123,200
44,600
70,200
114.800
238,000
440.00%
61.90%
Accrued liabilities
Income taxes payable
Total current liabilities
Share capital
Retained earnings
Total equity
Total liabilities and equity
0.00%
34,600
34,600
43.14%
XYZ Corporation
Income Statement
Years ended December 31
(P thousands)
Change
Peso
2013
266,400
191,400
75.000
2014
424,000
314,600
109,400
157,600
123.200
Net sales
Cost of goods sold
Gross profit
Selling, general and
administrative expenses
Income before income taxes
64.37%
?
35,500
39,500
12,300
27,200
64.51%
58,400
51,000
16,400
34,600
29.11%
11,500
4,100
Income taxes
33.33%
Net Income
Requirements:
1. Compute the missing changes in peso amounts and percentages in the above statements.
2. Evaluate the company's short-term financial position, leverage, managerial efficiency and
profitability using the Horizontal Analysis method.
2 out of 4
Transcribed Image Text:491 11:34 10 (-) 46 4 29 KB/s Financial Statement. studocu.com = StuDocuU Part 2 Problem 1 The following data are available for XYZ Corporation for years 2014 and 2013. XYZ Corporation Statement of Financial Position As of December 31 Change Peso 2013 2014 Assets 14,000 28,800 54,000 4.800 101,600 16,000 55,600 85,600 7.400 164,600 2,000 26,800 Cash and equivalents Receivables Inventories Prepayments and others Total Current Assets 93.06% ? 2,600 54.17% 62.01% Property, Plant & Equipment - net of depreciation Total Assets 30,200 131.800 73.400 238.000 43,200 143.05% Liabilities and Equity Notes payable to banks Accounts payable 44,000 23,800 2,600 10,000 31,600 4,200 5,800 51,600 44,600 35.600 80,200 131.800 54,000 55,400 6,800 7,000 123,200 44,600 70,200 114.800 238,000 440.00% 61.90% Accrued liabilities Income taxes payable Total current liabilities Share capital Retained earnings Total equity Total liabilities and equity 0.00% 34,600 34,600 43.14% XYZ Corporation Income Statement Years ended December 31 (P thousands) Change Peso 2013 266,400 191,400 75.000 2014 424,000 314,600 109,400 157,600 123.200 Net sales Cost of goods sold Gross profit Selling, general and administrative expenses Income before income taxes 64.37% ? 35,500 39,500 12,300 27,200 64.51% 58,400 51,000 16,400 34,600 29.11% 11,500 4,100 Income taxes 33.33% Net Income Requirements: 1. Compute the missing changes in peso amounts and percentages in the above statements. 2. Evaluate the company's short-term financial position, leverage, managerial efficiency and profitability using the Horizontal Analysis method. 2 out of 4
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Receivables Management
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