Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are the loan officer at QIB responsible for determining whether BBCCs business is strong enough to be able to repay the loan. Using the

You are the loan officer at QIB responsible for determining whether BBCCs business is strong enough to be able to repay the loan. Using the attached Income Statement and Balance Sheet, accomplish the following:

  1. Calculate the following profitability ratios for 2015 and 2016, 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 2016 as compared to 2015.Calculate the EVA and MVA for BBCC, assuming that the firms income tax rate is 40 percent, the weighted average rate of return expected by the suppliers of the firms capital is 10 percent, and the market price of the firms stock is $20. There are 1.2 million shares outstanding.
    1. Gross profit margin (50 percent)
    2. Operating profit margin (15 percent)
    3. Net profit margin (8 percent)
    4. Return on assets (10 percent)
    5. Return on equity (20 percent)
    6. Current ratio (1.5)
    7. Quick ratio (1.0)
    8. Debt to total asset ratio (0.5)
    9. Times interest earned (25)
    10. Average collection period (45 days)
    11. Inventory turnover (8)
    12. Total asset turnover (1.6)
  2. Determine the sources and uses of funds and prepare a statement of cash flows for 2016.
  3. Discuss the financial strengths and weaknesses of BBCC based on the financial condition as evident from the ratio analysis and the cash flow statement.
  4. Which ratios should you analyze more critically before recommending granting of the loan and what is your recommendation?image text in transcribed
Times New... BI U 14 A ab X, X A Styles Styles Pane A Aa A = = ES DE A FINA 3320: Corporate Finance Project 1: Financial Statement Analysis BBCC Income Statement for 2015 and 2016 (thousand dollars) 2015 2016 Sales $40,909 $45,000 Cost of Goods Sold $20,909 $23,000 Gross Profit $20,000 $22,000 Selling and Administrative Expenses $11,818 $13,000 Depreciation Expense $2,000 $3,000 Operating Income (EBIT) $6,182 $6,000 Interest Expense $400 $412 Earnings before Taxes (EBT) $5,782 $5,588 Income Taxes (@ 40%) $2,313 $2,235 Net Income (NI) $3,469 $3,353 Dividends Paid (@ 21.86%) $758 $733 BBCC Balance Sheet as of End of 2015 and 2016 (thousand dollars) 2015 2016 Assets: Cash $2,000 $1,800 Accounts Receivable (net) $6,000 $7,600 Inventory $5,000 $5,220 Plant and Equipment (gross) $26,000 $31,000 Less: Accumulated Depreciation $10,000 $13,000 Plant and Equipment (net) $16,000 $18,000 $1,000 $1,000 Liabilities: Accounts Payable $2,000 $2,600 Notes Payable $3,000 $3,300 Accrued Expenses $3,000 $3,100 Bonds Payable $4,000 $4,000 Stockholders' Equity: Common Stock $4,000 $4,000 Retained Earnings $14,000 $16,620 Land 148 words F English (United States) Focus Times New... BI U 14 A ab X, X A Styles Styles Pane A Aa A = = ES DE A FINA 3320: Corporate Finance Project 1: Financial Statement Analysis BBCC Income Statement for 2015 and 2016 (thousand dollars) 2015 2016 Sales $40,909 $45,000 Cost of Goods Sold $20,909 $23,000 Gross Profit $20,000 $22,000 Selling and Administrative Expenses $11,818 $13,000 Depreciation Expense $2,000 $3,000 Operating Income (EBIT) $6,182 $6,000 Interest Expense $400 $412 Earnings before Taxes (EBT) $5,782 $5,588 Income Taxes (@ 40%) $2,313 $2,235 Net Income (NI) $3,469 $3,353 Dividends Paid (@ 21.86%) $758 $733 BBCC Balance Sheet as of End of 2015 and 2016 (thousand dollars) 2015 2016 Assets: Cash $2,000 $1,800 Accounts Receivable (net) $6,000 $7,600 Inventory $5,000 $5,220 Plant and Equipment (gross) $26,000 $31,000 Less: Accumulated Depreciation $10,000 $13,000 Plant and Equipment (net) $16,000 $18,000 $1,000 $1,000 Liabilities: Accounts Payable $2,000 $2,600 Notes Payable $3,000 $3,300 Accrued Expenses $3,000 $3,100 Bonds Payable $4,000 $4,000 Stockholders' Equity: Common Stock $4,000 $4,000 Retained Earnings $14,000 $16,620 Land 148 words F English (United States) Focus

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Commodity Market Trading And Investment

Authors: Tom James

1st Edition

1137432802, 978-1137432803

More Books

Students also viewed these Finance questions