Hi,

Can I please get help with this case study?

5-36. Bikini Bottom Construction Company (BBCC) manufactures various types of high- quality punching and deep-drawing press tools for kitchen appliance manufacturers. Pearl, the finance manager of BBCC, has submitted a justification to support the application for a short-term loan from the Queensville Interstate Bank (QIB) to finance increased sales. The consolidated income statement and balance sheet of BBCC, submitted with the justification to QIB, follow. BBCC Income Statement for 2017 and 2018 (000 dollars) 2017 2018 Sales $40,909 $45,000 8e Cost of Goods Sold 20,909 23,000 Templates Gross Profit 20,000 22,000 Bogi Excel. 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 (@ 25%) 1,446 1,397 Net Income (NI) SASO 4,336 4, 191 Dividends Paid (@ 20%) no mh 694 671 BBCC Balance Sheet as of End of 2017 and 2018 (000 dollars) 090. 2017 2018 Assets: Cash $ 2,000 $ 1,800 Accounts Receivable (net) 6,000 ne gr 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 Land 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 tial Concepts in FinanceYou 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) echomeval iii. Net profit margin (8 percent) iv. Return on assets (10 percent) V . Return on equity (20 percent) des vi. Current ratio (1.5) 206. 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) ST 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. 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? 5-37. Refer to the following financial statements of Bongo Comics Group. Bongo Comic Group Income Statements (In 000's, except EPS) 2016 2017 2018 Net Sales $ 2, 100 $ 3,051 $ 3,814 Cost of Goods Sold 681 995 1,040 Gross Profit 1,419 2,056 2,774 Selling and Admin. Expenses 310 705 964 Operating Profit 809 1,351 1,810 Interest Expense 11 75 94See BBCC Case on pages 110 and 111 in your text {problem 5-36) On page 111 complete items: a i xii. ALSO, construct a Common Sized Income Statement for the two years presented.. Complete part c (Discuss the nancial strengths and weaknesses of BBCC). NOTE: your "discussion" may NOT contain the words , "I think\" or \"I feel\". Yournal statement is your recommendation to approve or reject the loan. Begin this statement with : "Based upon I) u my analysis this loan should be (not be) made. I recommend this because