ASSIGNMENT DEADLINE IN 4 HOURS!!!!!

please help with these question!!!!!

4) Analyze the changes of both the projected sales and net income of 2019as compared to that of 2018 actual sales and net income. Should Mr. John Chan be worried about the projected financial situation?

5) Evaluate Brighton Foods cash position if nothing is done to tackle the current situation. Is it going to face any cash storage problem?

6) Discuss whether Mr. John Chans secret plan will actually help solve the companys problem or not. But what are the potential adverse consequences if his plan is actually carried out?

7) Based on the important findings collected by Mr. Tim Lee, suggest appropriate measures to improve Brighton Foods net income.

8) Based on the important findings collected by Mr. Tim Lee, suggest appropriate measures to improve Brighton Foods cash position.

9) With reference to the financial ratios indicated by Eastern Bank, calculate all the financial ratios for Brighton Food, using the 2019 projected figures, and then compare each of the ratio result to the Easter Banks financial ratio requirements table shown in page 3.

10) According to the answers in the Question (9), will Brighton Food be eligible to obtain a long-term bank from Eastern Bank?

11) If Brighton Food is currently not eligible as according to the projected financial result for the year of 2019, which measure(s) mentioned in the answers of Questions (7) and/or (8), if implemented, should be able to help the company become eligible in the coming months?

12) Suppose Brighton Food successfully obtains the loan from Eastern Bank after improving on the relevant aspects motioned in the answer of question (11). In which specific areas should this long-term financing be used in order to help improve the companys financial performance?

Brighton Food Co., Ltd. (Brighton Food) is a privately-owned limited company with several shareholders. It has been in the food business for many years. Mr. John Chan is the company's biggest shareholder holding 40% of the shares. He is also the company manager who takes care of the company's business operations. In the past few years, the business is blooming as both the sales and the net income have been growing steadily at around 10% per year. However, this situation has been changed a couple of months ago since another keen competing food company entered and competes keenly in the market. Since this new competitor opened, Brighton Food has gradually lost a considerable number of customers because this competitor not only offers attractive discounts, but also gives out delicate promotional gift items to its customers. Brighton Food is not able to catch up with such flexible market promotion initiatives. Mr. Chan is very worried that the annual sales and net income growths may not be able to reach 10% any more. In the middle of the year, he prepared the following projected income statement and balance sheet for the whole financial year of 2019 in order to foresee the final business results at the year end. 2018 actual 1.200.000 675,000 525,000 2019 projected 960,000 564,000 396,000 Brighton Food Co. Lad Income Statements in dollars) For the Year Ended 31 Dec Sales Cost of goods sold Gross profit Operating Expenses Salaries and Wages Depreciation Rent Insurance Bad debt Utilities Operating income Interest expense Income before income taxes Income taxes Net income Net earnings per share 180,000 5,000 93,000 22,000 20.000 34.000 150,000 5.000 96,000 24.000 14.400 36,000 354,000 171.000 13.200 157,800 55,600 102,200 2.04 325,400 70,600 10.800 59.800 17,600 42,200 0.84 2018 actual 2019 projected 100,000 240,000 190,000 55.000 585.000 60,000 220,000 211,000 55,000 546.000 Brighton Food Co., Lid. Balance Sheets (in dollars As at 31 Dec Assets Cash Accounts receivable Inventories Furniture and equipment Total assets Liabilities Accounts payable Long-term bankan Total liabilities Shareholders' Equity Common shares (@50.5 par) Paid-in capital in excess of par Retained earnings Total shareholders' equity Total liabilities and shareholders equity 140,000 110,000 108 800 90,000 198.800 250.000 25.000 100,000 210.000 335.000 $85.000 25,000 100,000 222 200 347,200 546.000 It has been a normal practice over the past few years that Brighton Food pays a special bonus to Mr. John Chan for rewarding his outstanding performance in managing the company to attain significant net income growth. However, there is, in fact, a condition for this bonus payment, which is that the net income growth must be maintained at 10% in each year. On the other hand, Brighton Food has borrowed a long-term loan from Western Bank and one of the essential terms in the loan agreement is that the return on assets ratio must be at least 10% in a year. Otherwise, Western Bank is entitled to demand for the full repayment immediately even though the bank loan is still not due Mr. John Chan also hires a financial consultant, Mr. Tim Lee, who is specialized in food business, to analyze the business situation of Brighton Food. After having studied the current business practices of the company, he comes up with the following important findings First, Brighton Food only purchases its goods, i.e. inventories, from one single supplier, i.e. the Apex Food Manufacturing Co., Ltd., but the cost prices are generally 5-10% higher than that of the other similar suppliers in the market. Secondly, the bulk purchasing policy of Brighton Food has put the company in a disadvantageous position. As a matter of fact, the inventory turnover rate of similar companies is 10-12 times per year. Thirdly, the average collection period of the accounts receivable of Brighton Food is 70 days while that of the other similar companies is normally 30 days. Moreover, a higher than average proportion of the accounts receivable becomes long overdue. As a result, they turn out to become uncollectible eventually, ie, bad debts. Fourthly, the company's cash is currently sitting in a bank current account, which bears no interest income at all. Fifthly, the long-term bank loan was borrowed two years ago with a fixed interest rate of 12% per annum. However, the prevailing bank loan interest rate has actually come down to a much lower level of 8% per annum recently. Lastly, as usual, Brighton Food is going to declare and pay a cash dividend of $15.000 (@$0.3 per share) to its shareholders soon after the first six months of business in a financial year. In fact, Mr. John Chan has connection with another bank, Eastern Bank, which may also lend money to Brighton Food. This can help the company to raise additional capital fund through debt financing. However, Eastern Bank will require its potential clients to meet a series of financial ratios based on their projected financial results of the current year in order to determine the eligibility for obtaining the long-term bank loan. Requirement Eastern Bank Financial Ratios (a) Current ratio (b) Quick ratio (c) Total assets to total liabilities ratio (d) Debt-to-equity ratio (e) Return on assets (f) Profit margin (8) Inventory turnover (h) Cost of goods sold percentage 25 S0.75 > 996 26% 25 times 545% Being uncertain whether Brighton Food will be able to obtain the loan from Eastern Bank or not and also being very worried about the forthcoming situation in the second half of the financial year, Mr. John Chan even once thought of an idea to secretly create some fictitious key buyer companies and then place large amount of purchase orders to Brighton Food on credit in December 2019 in order to boost the sales figure at the end of the year. However, such kind of purchases orders will be cancelled at last, without any actual payment, in January 2020 Analyze the changes of both the projected sales and net income of 2019 as compared to that of 2018 actual sales and net income. Should Mr. John Chan be worried about the projected financial situation? (12%) (5) Evaluate Brighton Food's cash position if nothing is done to tackle the current situation. Is it going to face any cash shortage problem? (Hint: consider the long-term loan from Western Bank] (12%) Discuss whether Mr. John Chan's secret plan will actually help solve the company's problem or not. But what are the potential adverse consequences if his plan is actually carried out? (6%) Based on the important findings collected by Mr. Tim Lee, suggest appropriate measures to improve Brighton Food's net income. (10%) (8) Based on the important findings collected by Mr. Tim measures to improve Brighton Food's cash position. Lee, suggest appropriate (6%) With reference to the financial ratios indicated by Eastern Bank, calculate all the financial ratios for Brighton Food, using the 2019 projected figures, and then compare each of the ratio results to the Easter Bank's financial ratio requirements table shown in page 3. (16%) (10) According to the answers in the Question (9), will Brighton Food be eligible to obtain a long-term bank loan from Eastern Bank? (4%) (11) If Brighton Food is currently not eligible as according to the projected financial results for the year of 2019, which measure(s) mentioned in the answers of Questions (7) and/or (8), if implemented, should be able to help the company become eligible in the coming months? (14%) (12) Suppose Brighton Food successfully obtains the loan from Eastern Bank after improving on the relevant aspects mentioned in the answers of Question (11). In which specific areas should this long-term financing resource be used in order to help improve the company's financial performance? (8%) - End