Question
Part 2. Computational Analysis Using the provided Financial Statements, provide what is asked. Dilshad WLL Income Statement for the Year Ended March 2018 Particulars BD
Part 2. Computational Analysis Using the provided Financial Statements, provide what is asked.
Dilshad WLL Income Statement for the Year Ended March 2018 | |||
Particulars | BD | BD | |
Sales Revenue | 6900000 | ||
Less: Cost of Goods Sold | 4900000 | ||
Gross Profit | 2000000 | ||
Less: Operating Expenses |
|
| |
| Selling Expenses | 600000 |
|
General and Administrative Expenses | 490000 |
| |
Depreciation Expenses | 100000 |
| |
Total Operating Expenses | 1190000 | ||
EBIT | 810000 | ||
Less: Interest Expense | 740000 | ||
Net Profit Before Tax | 70000 | ||
Less Tax (40%) | ? | ||
Net Profit after Tax | ? | ||
Less : Preferred Stock Dividends |
| ? | |
Net Profit |
| ? |
BALANCE SHEET of XYZ | |||||||
LIABILITIES | 2018 | 2017 | ASSETS | 2018 | 2017 | ||
Shareholders Equity |
|
| Gross Fixed Assets (at Cost) | 2060000 | 1700000 | ||
| Preferred Stock (1500 Shares, 1.60 Dividend) | 50000 | 50000 | Less: Accumulated depreciation | 500000 | 350000 | |
Common stock (100000 Shares @4BD par) | 900000 | 900000 | Net Fixed Assets | 1560000 | 1350000 | ||
Current Assets |
|
| |||||
Retained Earnings | 300000 | 280000 |
| Cash | 35000 | 30000 | |
Total Stockholders Equity | 1340000 | 1320000 | Sundry Debtors | 695000 | 740000 | ||
Long Term Debts | 1180000 | 700000 | Inventories | 810000 | 770000 | ||
Current Liabilities |
|
| Total Current Assets | 1540000 | 1540000 | ||
| Sundry Creditors | 300000 | 400000 |
|
|
| |
Notes Payable | 200000 | 350000 |
|
| |||
Accruals | 80000 | 120000 |
|
| |||
Total Current Liabilities | 580000 | 870000 |
|
| |||
TOTAL LIABILITIES | 3100000 | 2890000 | TOTAL ASSETS | 3100000 | 2890000 |
Requirements;
1. Calculate the preferred stock dividends and the net profit. Then use this information to compute the ratios asked in question 2 below.
2. Calculate the firms 2018 financial ratios to fill in the table given below. Show the calculation for each of the ratio calculated.(
Ratio | Actual (2018) |
Current Ratio | ? |
Quick Ratio | ? |
Acid Test Ratio / Cash Ratio | ? |
Inventory Turnover (Times) | ? |
Average Collection period | ? |
Total Asset Turnover | ? |
Debt Ratio (Debt to Total Liabilities) | ? |
Debt to Equity Ratio | ? |
Net Profit Ratio | ? |
Gross Profit Ratio | ? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started