Please explain and help me to solve my problems, thanks!
The following is the statement of financial position and income statement of PT ABC as of December 31, 2018: PT ABC Financial Position Report as of December 31, 2018 Current assets Cash 20.000.000 Liabilities Short-term Liabilities Bank 25.000.000 Trade payables 85.000.000 Obligations 35.000.000 Inventory 40.000.000 Long-term Liabilities Prepaid expenses 20.000.000 + Mr A’s debt 25.000.000 Total Current assets: 140.000.000 Mr B’s debt 35.000.000 Mr C’s debt 55.000.000 + Total Liabilities 200.000.000 Fixed Assets Fixed Assets (Net) 100.000.000 Equity Capital 20.000.000 Retained earning 20.000.000 + Total Equity 40.000.000 Total Asset 240.000.000 Total Liabilities & Equity 240.000.000 PT ABC Income Statements As of December 31, 2018 Income 100.000.000 Cost of goods 30.000.000 Gross Income 70.000.000 Admission & Operational costs Salary expense 15.000.000 Equipment costs 5.000.000 Utility costs 7.500.000 Building maintenance costs 12.500.000 Vehicle maintenance costs 7.000.000 Depreciation fee 2.000.000 Interest Cost 1.000.000 Total Adm & Operational costs 50.000.000 Net Income 20.000.000 The questions are Based on the financial statements above, make the following analysis: 1. Explain the condition of PT ABC based on liquidity, profitability, and solvency (choose only 3 ratios each). a. Liquidity Ratio (Current Ratio, Quick Ratio, Cash Ratio), b. Profitability Ratio (ROA, GPM,NPM, ROE), c. Solvency ratio choose 3 2. PT ABC got a project with an investment of 250 million based on the calculation of 5-year projections (to = 15%), is the investment feasible? Calculate using NPV, IRR and Payback Period. For the 5 year projection of PT ABC as follows: a. Revenues increase by 15% per year b. Principal/ main Expenses increase by 5% annually. c. Admin and operational costs go up 7% per year d. Depreciation and interest costs are assumed to be a fixed value per year Note: When calculating discounted cash flow, what is used as annual cash flow is EBITDA. 3. Based on the cash flow projection, calculate how much risk the project has with the following probabilities: 2019 (45%), 2020 (55%). 2021 (50%), 2022 (35%), 2023. (40%) 4. Suppose it is known that each loan interest from Mr. A (7%), Mr. B (10%), Mr. C (12%) what is the cost of capital from PT ABC? (tax assumption: 25%) If the loan interest rate is 12.5%, is the cost of the fund already efficient?