Fill This Form To Receive Instant Help
Homework answers / question archive / Given the financial information for Megan Avenue Corporation as follow:- Income Statement for the year ended 31 December 2020 Sales 45,998 Cost of Good Sold (17,889) Gross Profit 28,109 Operating expenses Selling , general and administrative expenses (16,426) Depreciation expenses (1,976) (18,402) Operating Income 9,707 Interest expenses (483) Profit before tax 9,224 Income tax expenses (2,126) Profit after Tax 7,098 Balance Sheet as at 31 December 2020 Cash 21,675 Account receivable 4,466 Inventory 3,100 Other current assets 3,745 Total Current assets 32,986 Gross Plant and Equipment 26,674 Accumulated depreciation (12,041) Net plant and Equipment 14,633 Long term investment 13,625 Goodwill, Trademark & Other intangible assets 30,779 Total Assets 92,023 Accounts payable 9,634 Short-term notes payable 22,740 Total Current liabilities 32,374 Long term debt 29,329 Total Liabilities 61,703 Common stock (par value) 1,760 Paid-in capital 13,154 Retained earnigs 63,408 Treasury stock (48,002) Total stockholder equity 30,320 Total Liabilities and Equity 92,023 Required Calculate the ratio Gross profit margin Profit margin Current ration Acid test ratio Day in receivables Account receivable turnover Day in inventory Inventory turnover Return on investment Return on equity
Given the financial information for Megan Avenue Corporation as follow:-
Income Statement for the year ended 31 December 2020
Sales |
45,998 |
|
Cost of Good Sold |
(17,889) |
|
Gross Profit |
28,109 |
|
Operating expenses |
||
Selling , general and administrative expenses |
(16,426) |
|
Depreciation expenses |
(1,976) |
(18,402) |
Operating Income |
9,707 |
|
Interest expenses |
(483) |
|
Profit before tax |
9,224 |
|
Income tax expenses |
(2,126) |
|
Profit after Tax |
7,098 |
Balance Sheet as at 31 December 2020
Cash |
21,675 |
|
Account receivable |
4,466 |
|
Inventory |
3,100 |
|
Other current assets |
3,745 |
|
Total Current assets |
32,986 |
|
Gross Plant and Equipment |
26,674 |
|
Accumulated depreciation |
(12,041) |
|
Net plant and Equipment |
14,633 |
|
Long term investment |
13,625 |
|
Goodwill, Trademark & Other intangible assets |
30,779 |
|
Total Assets |
92,023 |
|
Accounts payable |
9,634 |
|
Short-term notes payable |
22,740 |
|
Total Current liabilities |
32,374 |
|
Long term debt |
29,329 |
|
Total Liabilities |
61,703 |
|
Common stock (par value) |
1,760 |
|
Paid-in capital |
13,154 |
|
Retained earnigs |
63,408 |
|
Treasury stock |
(48,002) |
|
Total stockholder equity |
30,320 |
|
Total Liabilities and Equity |
92,023 |
Required
Calculate the ratio
1) Gross profit margin= Gross profit/sales *100
Where :
Gross profit=$28,109
Sales=$45,998
Gross profit margin=$28,109/$45,998*100=61.109%
2)profit margin = profit after tax /sales *100
Where:
Profit after tax=$7,098
Sales =$45,998
Profit margin=$7,098/$45,998*100=15.43%
3) current ratio= current assets/current liabilities
Where :
Current assets= $32,986
Current liabilities=$32,374
Current ratio= $32,986/32,374=1.018x
4)acid test ratio or quick ratio= total current assets- inventory- other current assets/current liabilities
Acid test ratio= $32,986-3,100-3745/$32,374
Acid test ratio= $26,161/$32,374
Acid test ratio=0.80 x
5) Days in receivables= accounts receivables/sales*365 days
Where :
Accounts receivables= $4,466
Sales = $45,998
Days in receivables= $4,466/$45,998*365=35.43 days
6) Accounts receivables turnover = Sales/accounts receivables
Where:
Sales = $45,998
Accounts receivables= $4,466
Accounts receivables turnover= $45,998/$4,466=10.29 times
7)Days in inventory= inventory/cost of goods sold *365
Where:
Inventory=$3,100
Cost of goods sold=$17,889
Days in inventory= $3,100/$17,889*365
Days in inventory= 63.25 days
8) inventory turnover = cost of goods sold / inventory
Where :
Cost of goods sold=$17,889
Inventory=3,100
Inventory turnover= $17,889/$3,100=5.77 times
9)Return on investment= Profit after tax /Total assets*100
Where:
Profit after tax=$7,098
Total assets=$92,023
Return on investment (ROI)=$7,098/$92,023*100
Return on investment (ROI)=7.71%
10) Return on equity (ROE)= profit after tax/total equity*100
Where:
Profit after tax:$7,098
Total equity=$30,320
Return on equity(ROE)= $7,098/$30,320*100
Return on equity (ROE)= 23.41%