Chapter 20, Problem 53P

To determine

Assess BPP as a corporation using an application of financial ratios.

Explanation of Solution

Management benefit programs are manager-compensation policies and procedures. This contains one or more: pay, incentives, and benefits. The main objective of the company is to establish management compensation strategies that support its strategic priorities, as set out by management and owners.

• Motivate managers to demonstrate a high degree of commitment to meet the goals set by top management.
• To include opportunities for managers, to function independently and to make decisions in accordance with the priorities set by top management.
• Evaluate equally the bonuses managers receive for their contributions and abilities and the efficiency of their decision making.

Operational control is the power to carry out those functions of orders over subordinate forces concerning the organization and use of instructions and compels the assignment of tasks, the assignment of goals and the giving of the instructive path requisite for the task.

Business assessment values the firm by estimating its value total market value, which can be compared with the market value for previous periods or for comparable companies.

The market value of the firm is determined by multiplying the number of outstanding shares by the equity's current market price.

The balance sheet of the Incorporation, BPP is shown below:

Balance Sheet	2016	2015
Current assets	$176,363,659	$150,634,643
Long-lived assets	100,620,809	95,887,302
Total assets	$276,984,468	$246,521,945
Current liabilities	$119,045,766	$120,995,274
Long-term Debt	31,997,364	37,885,302
Shareholder Equity	125,941,468	87,641,369
Total debt and equity	$276,984,468	$246,521,945

Calculate net income:

Income Statement	2016	2015
Sales	$667,534,771	$638,776,465
Less: Cost of sales	498,657,788	477,491,001
Gross Margin	168,876,983	161,285,464
Less: Operating expenses	102,667,355	134,765,229
Operating Income	$66,209,628	$26,520,235
Less: Tax expense	25,159,659	10,077,689
Net Income	$41,049,969	$16,442,546

Calculate free cash flow from operations:

Cash flow From Operations	2016	2015
Net Income	$41,049,969	$16,442,546
Plus Depreciation Expense	18,766,493	15,664,254
Add: Decrease (−Inc) in AccRec and Inv	50,734,535	—
Add: Increase (−Dec) in Cur. Liabl.	(1,949,508)	—
Cash Flow from Operations	$108,601,489	$32,106,800
Free Cash Flow
Less: Capital Expenditures	23,500,000	12,990,336
Less: Dividends	2,750,000	1,250,000
Free Cash Flow	$82,351,489	$17,866,464

Analysis of the financial ratio utilizes the ratios of financial statements to evaluate the performance of the firm. Two common performance measures include liquidity and profitability. Liquidity is the ability of the firm to pay its current operating expenses (usually for one year or less) and debt maturity. The six key liquidity measures are accounts receivable turnover, stock turnover, current ratio, quick ratio, and two cash flow ratios. The greater the ratio, the better a corporation's ability to pay off its obligations in a timely manner. The four key profitability ratios are the percentage of the gross margin, return on assets, return on equity, and profit per share.

Profitability ratios are a category of accounting measures that are calculated over period to measure the ability of a company to produce income compared to its sales, operating expenses, balance sheet assets, and shareholders' equity, using data from a particular point in time.

The cash flow ratio for operating is a calculation of how often current liabilities are protected by the funds generated from operations of a business. The ratio will help assess the profitability of a organization in the short run.

The financial ratios are as follows:

Financial Ratios	2016	2015	Industry
Liquidity Ratios
Accounts Receivable Turnover	9.27	7.32	5.50
Inventory Turnover	10.02	7.97	8.60
Current Ratio	1.48	1.24	1.90
Quick Ratio	1.15	0.75	1.10
Cash Flow Ratios
Cash Flow from Operations	0.91	0.27	1.40
Free Cash Flow	0.69	0.15	1.10
Profitability Ratios
Gross Margin Percentage	25.3%	25.2%	33%
Return on Assets (Net Book Value)	14.8%	6.7%	19%
Return on Equity	32.6%	18.8%	28%
Earnings per Share	$ 1.6	$ 0.722	$ 2.33

Working notes:

Liquidity ratios:

• Accounts receivable turnover is a productivity ratio or operation ratio that calculates how many times a company is capable of turning its receivable accounts into cash over a period. This shows how successful a company is in receiving its credit sales from customers.

The formula to calculate accounts receivable turnover ratio is:

$\text{Accounts receivable turnover ratio}=\frac{\text{Net credit sales}}{\text{Average AR}}$

For 2016:

Accounts receivable for 2016 is 56,778,465 and for 2015 is $87,294,771.

Net credit sales for 2016 are $667,534,771.

Calculate average AR:

$\begin{array}{c}\text{Average AR}=\frac{\$\text{56},\text{778},\text{465}+\$\text{87},\text{294},\text{771}}{2}\\ =\$72,036,618\end{array}$

$\begin{array}{c}\text{Accounts receivable turnover ratio for 2016}=\frac{\$667,534,771}{\text{\$72,036,618}}\\ =9.27\end{array}$

Hence, the accounts receivable turnover ratio for 2016 is 9.27.

For 2015:

Accounts receivable for 2015 is $87,294,771 and for 2014 is $87,294,771.

Net credit sales for 2015 are $638,776,465.

Calculate average AR:

$\begin{array}{c}\text{Average AR}=\frac{\$\text{87},\text{294},\text{771}+\$\text{87},\text{294},\text{771}}{2}\\ =\$\text{87},\text{294},\text{771}\end{array}$

$\begin{array}{c}\text{Accounts receivable turnover ratio for 2015}=\frac{\text{\$638},\text{776},\text{465}}{\text{\$87},\text{294},\text{771}}\\ =7.32\end{array}$

Hence, the accounts receivable turnover ratio for 2015 is 7.32.

• Inventory turnover shows how many times a company is selling and replacing its stock of goods over a given period. The inventory turnover ratio formula is the cost of the goods sold divided over the same time period by the average inventory.

Calculate inventory turnover ratio for 2016:

For 2016,

Inventory for 2016 is 39,665,416 and for 2015 is $59,883,645.

Cost of goods sold for 2016 is $498,657,788.

Calculate average inventory:

$\begin{array}{c}\text{Average Inventory}=\frac{\$\text{39},\text{665},\text{416}+\$\text{59},\text{883},\text{645}}{2}\\ =\$49,774,530.5\end{array}$

$\begin{array}{c}\text{Inventory turnover ratio for 2016}=\frac{\text{Cost of goods sold}}{\text{Average inventory}}\\ =\frac{\$\text{498},\text{657},\text{788}}{\$49,774,530.5}\\ =10.02\end{array}$

Hence, the inventory turnover ratio for 2016 is 10.02.

For 2015,

Inventory for 2015 is 59,883,645 and for 2014 is $59,883,645.

Cost of goods sold for 2015 is $477,491,001.

Calculate average inventory:

$\begin{array}{c}\text{Average Inventory}=\frac{\$\text{59},\text{883},\text{645}+\$\text{59},\text{883},\text{645}}{2}\\ =\$\text{59},\text{883},\text{645}\end{array}$

$\begin{array}{c}\text{Inventory turnover ratio for 2015}=\frac{\text{Cost of goods sold}}{\text{Average inventory}}\\ =\frac{\$\text{477},\text{491},00\text{1}}{\$\text{59},\text{883},\text{645}}\\ =7.97\end{array}$

Hence, the inventory turnover ratio for 2015 is 7.97

• The current ratio is a liquidity ratio that measures the ability of a corporation to pay short-term or due obligations within one year. It allows investors to understand how a firm can significantly increase the current assets on its balance sheet to meet its current debt and other payables.

The formula to calculate the current ratio is:

$\text{Current Ratio}=\frac{\text{Current Assets}}{\text{Current Liabilities}}$

Calculate current ratio for 2016:

Total current assets for 2016 are $176,363,659.

Total current liabilities for 2016 are $119,045,766.

$\begin{array}{c}\text{Current Ratio}=\frac{\text{\$176},\text{363},\text{659}}{\text{\$119},0\text{45},\text{766}}\\ =1.48\end{array}$

Hence, the current ratio for 2016 is 1.48.

Calculate current ratio for 2015:

Total current assets for 2015 are $150,634,643.

Total current liabilities for 2015 are $120,995,274.

$\begin{array}{c}\text{Current Ratio}=\frac{\text{\$15}0,\text{634},\text{643}}{\text{\$12}0,\text{995},\text{274}}\\ =1.24\end{array}$

Hence, the current ratio for 2015 is 1.24.

• The quick ratio is an indicator of the short-term liquidity position of a company and measures the ability of a company with its most liquid assets to fulfill its short-term obligations. Since it shows the ability of the company to instantly use its near-cash assets (assets that can be swiftly converted to cash) to pay down its current liabilities, it is also called the acid test ratio.

The formula to calculate the quick ratio is:

$\text{Quick Ratio}=\frac{\text{Cash + AR}}{\text{Current Liabilities}}$

Calculate quick ratio for 2016:

Cash for 2016 is $79,919,778.

Accounts receivable for 2016 is $56,778,465.

Total current liabilities for 2016 are $119,045,766.

$\begin{array}{c}\text{Quick Ratio}=\frac{\text{\$79},\text{919},\text{778}+\text{\$56},\text{778},\text{465}}{\text{\$119},0\text{45},\text{766}}\\ =1.15\end{array}$

Hence, the quick ratio for 2016 is 1.15.

The formula to calculate the quick ratio is:

$\text{Quick Ratio}=\frac{\text{Cash + AR}}{\text{Current Liabilities}}$

Calculate quick ratio for 2015:

Cash for 2015 is $3,456,227.

Accounts receivable for 2015 is $87,294,771.

Total current liabilities for 2015 are $120,995,274.

$\begin{array}{c}\text{Quick Ratio}=\frac{\text{\$3},\text{456},\text{227}+\text{\$87},\text{294},\text{771}}{\text{\$12}0,\text{995},\text{274}}\\ =0.75\end{array}$

Hence, the quick ratio for 2015 is 0.75.

Cash Flow Ratios

The operating cash flow ratio calculates the appropriateness of the funds generated by a company from operating activities to pay its current liabilities. This is determined by dividing the cash flow from operations by total business's current liabilities.

The formula to calculate cash flow from operations ratio is:

$\text{Operating cash flow ratio}=\frac{\text{Cash flow operations}}{\text{Current liabilties}}$

For 2016:

Cash flow from operations for 2016 is $108,601,489.

Current liabilities for 2016 are $119,045,766.

Calculate cash flow from operations ratio for 2016:

$\begin{array}{c}\text{Cash flow from operations ratio}=\frac{\text{\$1}0\text{8},\text{6}0\text{1},\text{489}}{\text{\$119},0\text{45},\text{766}}\\ =0.91\end{array}$

Hence, the cash flow from operations ratio for 2016 is 0.91.

For 2015:

Cash flow from operations for 2015 is $32,106,800.

Current liabilities for 2015 are $120,995,274.

Calculate cash flow from operations ratio for 2015:

$\begin{array}{c}\text{Cash flow from operations ratio}=\frac{\text{\$32},\text{1}0\text{6},\text{8}00}{\text{\$12}0,\text{995},\text{274}}\\ =0.27\end{array}$

Hence, the cash flow from operations ratio for 2016 is 0.27.

• Free cash flow is the cash that a company produces from its activities, minus the cost of asset spending.

Profitability Ratios:

Gross margin is the difference divided by sales between income and cost of sold products (COGS). The gross margin ratio is a percentage which results from dividing the amount of the gross profit of a business by the amount of its net sales.

The formula to calculate gross margin ratio is:

$\text{Gross margin ratio}=\frac{\text{Gross profit}}{\text{Net sales}}$

For 2016:

Gross margin for 2016 is $168,876,983.

Net sales for 2016 are $667,534,771.

$\begin{array}{c}\text{Gross margin ratio}=\frac{\text{\$168},\text{876},\text{983}}{\text{\$667},\text{534},\text{771}}\times 100\\ =25.3\%\end{array}$

Hence, the gross margin ratio for 2016 is 25.3%.

For 2015:

Gross margin for 2015 is $161,285,464.

Net sales for 2015 are $638,776,465.

$\begin{array}{c}\text{Gross margin ratio}=\frac{\text{\$161},\text{285},\text{464}}{\text{\$638},\text{776},\text{465}}\times 100\\ =25.2\%\end{array}$

Hence, the gross margin ratio for 2015 is 25.2%.

• Return on assets is a profitability ratio which provides how much profit a firm can generate from its assets. It is calculated by dividing a company’s net income by total assets.

The formula to calculate return on assets ratio is:

$\text{Return on assets ratio}=\frac{\text{Net income}}{\text{Total assets}}$

For 2016:

Net income for 2016 is $41,049,969.

Total assets for 2016 are $276,984,468.

$\begin{array}{c}\text{Return on assets ratio}=\frac{\text{\$41},0\text{49},\text{969}}{\text{\$276},\text{984},\text{468}}\\ =14.8\%\end{array}$

Hence, the return on assets ratio for 2016 is 14.8%.

For 2015:

Net income for 2015 is $16,442,546.

Total assets for 2015 are $246,521,945.

$\begin{array}{c}\text{Return on assets ratio}=\frac{\text{\$16},\text{442},\text{546}}{\text{\$246},\text{521},\text{945}}\\ =6.7\%\end{array}$

Hence, the return on assets ratio for 2015 is 6.7%.

• Return on equity (ROE) is a calculation of financial performance measured by the division of net income by equity of the shareholders.

The formula to calculate return on equity ratio is:

$\text{Return on equity ratio}=\frac{\text{Net income}}{\text{Shareholder's equity}}$

For 2016:

Net income for 2016 is $41,049,969.

Shareholder’s equity for 2016 is $125,941,468.

$\begin{array}{c}\text{Return on equity ratio}=\frac{\text{\$41},0\text{49},\text{969}}{\$\text{125},\text{941},\text{468}}\\ =32.6\%\end{array}$

Hence, the return on assets ratio for 2016 is 32.6%.

For 2015:

Net income for 2015 is $16,442,546.

Shareholder’s equity for 2015 is $87,641,369.

$\begin{array}{c}\text{Return on equity ratio}=\frac{\text{\$16},\text{442},\text{546}}{\$\text{87},\text{641},\text{369}}\\ =18.8\%\end{array}$

Hence, the return on assets ratio for 2015 is 18.8%.

• Earnings per share or EPS are a significant financial measure which shows a company's profitability. This is determined by dividing the net income of the company with the total number of outstanding shares

The formula to calculate earnings per share is:

$\text{EPS}=\frac{\text{Net income}}{\text{No}\text{. of outstanding shares}}$

For 2016:

Net income for 2016 is $41,049,969.

Number of outstanding shares for 2016 is 25,689,554.

$\begin{array}{c}\text{EPS}=\frac{\text{\$41},0\text{49},\text{969}}{\text{25},\text{689},\text{554}}\\ =1.6\end{array}$

Hence, the earning per share for 2016 is 1.6.

For 2015:

Net income for 2015 is $16,442,546.

Number of outstanding shares for 2015 is 22,763,554.

$\begin{array}{c}\text{EPS}=\frac{\text{\$16},\text{442},\text{546}}{\text{22},\text{763},\text{554}}\\ =0.722\end{array}$

Hence, the earning per share for 2015 is 0.722.

Conclusion:

An overview of the financial ratio of Incorporation, BPP's liquidity reveals a company that is progressing on all metrics very well. Both the receivables turnover and the inventory turnover ratios are slightly higher than the industry average and substantially increased from 2015 to 2016. The current ratio is lower than the industry average, but from 2015 to 2016 both the current ratio and the rapid ratio have changed and the rapid ratio is now higher than the industry average.

The cash flow of Incorporation, BPP compared to current liabilities has slightly increased from 2015 to 2016 while both cash flow levels remain smaller than the industry average. The key explanation for improving cash flow is the substantial reduction in receivables and inventory; over the last year, the business employed much improved methods of handling these assets.

From 2015 to 2016, the Incorporation, BPP ratios have improved considerably as regards profitability. Nonetheless, asset returns are still smaller than the industry average while equity returns are not significantly higher than the industry average.

Contributing factors provide the comparatively small gross profit rate that is significantly below the industry average at 25.3 per cent in 2016. Operating expenses dropped from 2015 to 2016, and the emphasis will now be on raising the percentage of the gross margin to reduce operating costs.