You are a financial consultant. You are hired by a manufacturing company to assess its performance Based on financial ratios. Your task is to come up with the following: (1) financial analysis using financial ratios on liquidity, solvency or stability, and profitability; (2) trend analysis, both vertical and horizontal; and (3) comparative financial statements. The analysis should be benchmarked with competitors. Prepare a report indicating your comments on the financial health and performance of the company (as benchmarked with competitors) using the following liquidity ratios: (1) current ratio, (2) receivable turnover, (3) inventory turnover, and (4) quick ratio. Give your insights into the relative solvency or stability of the company (as benchmarked with the competitors) using the following ratios: (1) debt ratio, (2) times interest earned ratio, and (3) debt - equity ratio, Also, assess the relative profitability of the company (as benchmarked with competitors) using the following ratios: (1) gross profit margin, (2) net profit margin, (3) return on assets, and (4) return on equity, Compare the resulting ratios of P and P Manufacturing Company for 2018 (per your computation) with its competitors in the table given below. Conduct a trend analysis (horizontal) for the company over the current and last two years based on Comparative SFP. Aside from the horizontal analysis, conduct also a vertical analysis (common-size financial statements). Comment on the components of the financial statements by year and its trend for the last three years.
You are a financial consultant. You are hired by a manufacturing company to assess its performance Based on financial ratios. Your task is to come up with the following: (1) financial analysis using financial ratios on liquidity, solvency or stability, and profitability; (2) trend analysis, both vertical and horizontal; and (3) comparative financial statements. The analysis should be benchmarked with competitors. Prepare a report indicating your comments on the financial health and performance of the company (as benchmarked with competitors) using the following liquidity ratios: (1) current ratio, (2) receivable turnover, (3) inventory turnover, and (4) quick ratio. Give your insights into the relative solvency or stability of the company (as benchmarked with the competitors) using the following ratios: (1) debt ratio, (2) times interest earned ratio, and (3) debt - equity ratio, Also, assess the relative profitability of the company (as benchmarked with competitors) using the following ratios: (1) gross profit margin, (2) net profit margin, (3) return on assets, and (4) return on equity, Compare the resulting ratios of P and P Manufacturing Company for 2018 (per your computation) with its competitors in the table given below. Conduct a trend analysis (horizontal) for the company over the current and last two years based on Comparative SFP. Aside from the horizontal analysis, conduct also a vertical analysis (common-size financial statements). Comment on the components of the financial statements by year and its trend for the last three years.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
You are a financial consultant. You are hired by a manufacturing company to assess its performance
Based on financial ratios. Your task is to come up with the following: (1) financial analysis using financial ratios
on liquidity, solvency or stability, and profitability; (2) trend analysis, both vertical and horizontal; and (3)
comparative financial statements. The analysis should be benchmarked with competitors.
Prepare a report indicating your comments on the financial health and performance of the company
(as benchmarked with competitors) using the following liquidity ratios: (1) current ratio , (2) receivable
turnover, (3) inventory turnover, and (4) quick ratio.
Give your insights into the relative solvency or stability of the company (as benchmarked with the
competitors) using the following ratios: (1) debt ratio, (2) times interest earned ratio, and (3) debt - equity
ratio,
Also, assess the relative profitability of the company (as benchmarked with competitors) using the
following ratios: (1) gross profit margin, (2) net profit margin, (3) return on assets, and (4) return on equity,
Compare the resulting ratios of P and P Manufacturing Company for 2018 (per your computation)
with its competitors in the table given below.
Conduct a trend analysis (horizontal) for the company over the current and last two years based on
Comparative SFP.
Aside from the horizontal analysis, conduct also a vertical analysis (common-size financial
statements). Comment on the components of the financial statements by year and its trend for the last three
years.

Transcribed Image Text:PERFORMANCE TASK
You are a financial consultant, You are hired by a manufacturing company to assess its performance
Based on financial ratios. Your task is to come up with the following: (1) financial analysis using financial ratios
on liquidity, solvency or stability, and profitability; (2) trend analysis, both vertical and horizontal; and (3)
comparative financial statements. The analysis should be benchmarked with competitors.
Prepare a report indicating your comments on the financial health and performance of the company
(as benchmarked with competitors) using the following liquidity ratios: (1) current ratio, (2) receivable
turnover, (3) inventory turnover, and (4) quick ratio.
Give your insights into the relative solvency or stability of the company (as benchmarked with the
competitors) using the following ratios: (1) debt ratio, (2) times interest earned ratio, and (3) debt - equity
ratio.
Also, assess the relative profitability of the company (as benchmarked with competitors) using the
following ratios: (1) gross profit margin, (2) net profit margin, (3) return on assets, and (4) return on equity.
Compare the resulting ratios of P and P Manufacturing Company for 2018 (per your computation)
with its competitors in the table given below.
P& P Mfg. Co.
9.31:1
6.9:1
18.9 times
7.8 times
0.15:1
0.17:1
3.4 times
Competitor C
4.5:1
3.625:1
7 times
5.3 times
0.075:1
0.825:1
2.6 times
38.5%
14.5%
Competitor B
6:1
Financial Ratios for 2018
Current Ratio
Quick ratio
Receivable Turnover
Inventory Turnover
Debt Ratio
Debt-equity Ratio
Times Interest Earned Ratio
Gross Profit Margin Ratio
Net Profit Margin Ratio
4.25:1
20 times
8.6 times
0.2:1
1.75:1
4.5 times
51.2%
22.5%
24%
22%
49.4%
17.6%
26.9%
31.5%
16%
12%
Return on Assets
Return on Equity
Conduct a trend analysis (horizontal) for the company over the current and last two years based on
Comparative SFP.
Aside from the horizontal analysis, conduct also a vertical analysis (common-size financial
statements). Comment on the components of the financial statements by year and its trend for the last three
years.
P and P Manufacturing Company
Comparative Statements of Financial Position
As of 31 December 2018, 2017, and 2016
In Peso
2017
P290,000.00
340,000.00
270,000.00
225,000.00
895,000.00
825,000.00
P2,845,000.00
P165,000.00
550,000.00
2,130,000.00
P2,845,000.00
2016
P215,000.00
130,000.00
0.00
350,000.00
945,000.00
290,000.00
P1,930,000.00
P200,000.00
750,000.00
980,000.00
P1,930,000.00
Account
Cash
Accounts Receivable
Inventories
Land
Buildings, Net
Equipment, Net
Total Assets
Accounts Payable
Long-term Debt
Capital Stock
Liabilities
2018
P581, 970.00
686,725.00
450,470.00
225,000.00
845,000.00
854,500.00
P3,643,665.00
P184,620.00
350,000.00
3,109,045.00
P3,643,665.00
Total
Shareholders' Equity
and
FUNDAMENTALS OF ACCOUNTANCY, BUSINESS, AND MANAGEMENT 2
ni Dago 1 of 75
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps

Knowledge Booster
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.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education