Question

Please help with the case study comprehensive question for 5-36. Pictures Below.

You are the loan officer at QIB responsible for determining whether BBCC's business is strong enough to be able to repay the loan. To do so, accomplish the following: a. Calculate the following ratios for 2017 and 2018, compare with the industry averages shown in parentheses, and indicate if the company is doing better or worse than the industry and whether the performance is improving or deteriorating in 2018 as compared to 2017. i. Gross profit margin (50 percent) ii. Operating profit margin (15 percent) iii. Net profit margin (8 percent) iv. Return on assets (10 percent) V. Return on equity (20 percent) vi. Current ratio (1.5) vii. Quick ratio (1.0) viii. Debt to total asset ratio (0.5) ix. Times interest earned (25) X. Average collection period (45 days) xi. Inventory turnover (8) xii. Total asset turnover (1.6) b. Calculate the EVA and MVA for BBCC, assuming that the firm's income tax rate is 40 percent, the weighted average rate of return expected by the suppliers of the firm's capital is 10 percent, and the market price of the firm's stock is $20. There are 1.2 million shares outstanding. c. Discuss the financial strengths and weaknesses of BBCC. bonite d. Determine the sources and uses of funds and prepare a statement of cash flows for 2018. e. Compare and comment on the financial condition as evident from the ratio analysis and the cash flow statement. f. Which ratios should you analyze more critically before recommending granting of the loan and what is your recommendation? Refer to the following financial statements of Bongo Comics Group. 4.1

Answer 1

Those ratios which use average in calculation, ending total balance has been considered as no information was provided for 2016.

gross profit margin	(gross profit / sales)*100
	2017 ($)	2018 ($)
gross proft	20000	22000
sales	40909	45000
gross profit margin	48.9%	48.9%
On comparing with the industry (50%), it has declined. It has remained stable for both the periods
operating profit margin	(operating profit / sales)*100
	2017 ($)	2018 ($)
operating profit	6182	6000
sales	40909	45000
operating profit margin	15.1%	13.3%
On comparing with the industry (15%), it has remained stable for 2017 but declined for 2018. It's deteriorating in 2018.
net profit margin	(net income / sales)*100
	2017 ($)	2018 ($)
net income	4336	4191
sales	40909	45000
net profit margin	10.6%	9.3%
On comparing with the industry (8%), it is doing better. It's deteriorating in 2018.
return on assets	net income / ending total assets
	2017 ($)	2018 ($)
net income	4336	4191
ending total assets	30000	33620
return on assets	14.5%	12.5%
On comparing with the industry (10%), it is doing better. It's deteriorating in 2018.
return on equity	net income / shareholders equity
	2017 ($)	2018 ($)
net income	4336	4191
shareholders equity	18000	20620
return on equity	24.1%	20.3%
On comparing with the industry (20%), it is was better in 2017 but remained stable in 2018. It's deteriorating in 2018.
current ratio	current assets / current liabilities
	2017 ($)	2018 ($)
current assets:
cash	2000	1800
accounts receivable	6000	7600
inventory	5000	5220
total current assets	13000	14620
current liabilities:
accounts payable	2000	2600
notes payable	3000	3300
accrued expenses	3000	3100
total current liabilities	8000	9000
current ratio	1.6	1.6
On comparing with the industry (1.5), it is was better. It remained stable for both the periods.
quick ratio	acid-assets / current liabilities
	2017 ($)	2018 ($)
acid assets
cash	2000	1800
accounts receivable	6000	7600
total acid assets	8000	9400
total current liabilities	16000	18800
quick ratio	0.5	0.5
On comparing with the industry (1.5), it is was worse for both the periods. No changes in both the periods
debt to total assets	total debt / total assets
	2017 ($)	2018 ($)
debt:
notes payable	3000	3300
bonds payable	4000	4000
total debt	7000	7300
ending total assets	30000	33620
debt to total assets	0.2	0.2
On comparing with the industry (0.5), it was worse for both the periods. No changes in both the periods
times interest earned	EBIT / interest expense
	2017 ($)	2018 ($)
EBIT	6182	6000
interest expenses	400	412
times interest earned	15.5	14.6
On comparing with the industry (25), it was worse for both the periods. It's deteriorating in 2018.
average collection period	(ending accounts receivable / sales)*365
	2017 ($)	2018 ($)
ending accounts receivable	6000	7600
sales	40909	45000
average collection period	54	62
On comparing with the industry (45 days), it was worse for both the periods. It's deteriorating in 2018.
inventory turnover	cost of goods sold / ending inventory
	2017 ($)	2018 ($)
cost of goods sold	20909	23000
ending inventory	5000	5220
inventory turnover	4.2	4.4
On comparing with the industry (8), it was worse for both the periods. No significant change in 2018.
total assets turnover	sales / ending total assets
	2017 ($)	2018 ($)
sales	40909	45000
ending total assets	30000	33620
total assets turnover	1.4	1.3
On comparing with the industry (1.6), it was low for both the periods. No significant change in 2018.