PCP FINANCIAL planning, Budgeting and control

Complete all questions below: 1. Prepare a report by Analyzing the Financial statements and doing a trend analysis. The report will be used in Financial planning process. 2. Calculate 10 ratios and compare them with market benchmark stating your observation. 3. State and discuss the matters to consider and the basis of their calculation while preparing Financial budget for a Cafe or a clothing retail shop. 2018 2019 Statement of Comprehensive Income, Jan to Dec (IN USD '000) 2017 Sales Cash 1,200 Credit 11,800 Total Sales 13,000 1,480 14,320 15,800 1,800 17,200 19,000 Cost of goods sold 11,240 12,832 14,800 Gross profit 1,760 2,968 4,200 Operating expenses: General, admin, and selling expenses Depreciation Interest expenses (on borrowings) Profit before tax (PBT) 180 1,100 600 (120) 1,450 1,400 1,580 (1,462) 1,100 166 340 2,594 Tax @ 30% (36) (439) 778 Profit after tax (PAT) (84) (1,023) 1,816 2017 2018 2019 11,900 12,500 1.470 Statement of Balance Sheet as of date (USD"000) Assets Fixed assets (net of depreciation) Current assets Cash and cash equivalents Accounts receivable Inventories Total 400 3,000 3,200 18,500 1,000 15,000 15,000 43,500 1,060 21,000 22,500 46,030 Equity & Liabilities Equity share capital (shares of USD 10 each) Reserve & Surplus Long-Term Borrowings Current Liabilities Total 7,176 1,364 7,360 2,600 18,500 9,412 4,448 12,360 17,280 43,500 12,292 11,876 4,062 17,800 46,030 Sector Average 2:1 1:1 5 times 45 days 13% 25% 25% INDUSTRY AVERAGE OF KEY RATIOS Ratio Current Ratio Acid test ratio (quick ratio) Receivable turnover ratio Receivable days Long-term debt to total debt Debt to Equity ratio Gross profit ratio Net profit ratio Return on equity Return on total assets Total asset turnover ratio Fixed asset turnover ratio Current asset turnover ratio Interest coverage ratio (times interest earned) Working capital turnover ratio Return on fixed assets 15% 17% 8% 1.3 1.5 2 8 5 13%