Cost of goods sold :-   Sales - gross profit  = 1000000 - 400000  = 600000 Calculation of total expenses:- (Depreciation + advertisement exp. + Rent + salaries + commission + other exp. ) = (80000 + 60000 + 15000 + 56000 + 5000 + 7000) = 223000 Calculation of Gross profit margin:- Formula = sales - cost of goods sold = 1000000 - 600000 = 400000 Calculation of gross profit percentage margin:-Formula = (Gross profit margin / sales)*100 = (400000 / 1000000)*100 = 40% Calculation of net profit margin:- Formula = Gross profit - total expenses = 400000 - 223000 = 177000 Calculation of net profit percentage margin: - Formula = (Net profit / Net Sales)*100% = (117 000/ 1 000 000) *100 = %17.7 Calculation of Current Ratio: - Formula = Current Assets / Current Liabilities = 135 000/ 47 000 = 2.87 : 1 Calculation of Acid Test Ratio: - Formula = Liquid Assets / Current Liabilities Liquid Assets = Cash + Accounts Receivables = 100 000 + 20 000 =  120 000 Acid Test ratio = 120 000/ 47 000 = 2.55 : 1 Calculation of ROCE: Formula = Net Income / Shareholder’s equity = 177 000 / 225 000 = 0.79 Required : In addition to these calculations, please make analysis and interpretations of the data determined.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Cost of goods sold :-

 

Sales - gross profit  = 1000000 - 400000  = 600000

Calculation of total expenses:- (Depreciation + advertisement exp. + Rent + salaries + commission + other exp. ) = (80000 + 60000 + 15000 + 56000 + 5000 + 7000) = 223000

Calculation of Gross profit margin:- Formula = sales - cost of goods sold

= 1000000 - 600000

= 400000

Calculation of gross profit percentage margin:-Formula = (Gross profit margin / sales)*100

= (400000 / 1000000)*100

= 40%

Calculation of net profit margin:- Formula = Gross profit - total expenses

= 400000 - 223000

= 177000

Calculation of net profit percentage margin: - Formula = (Net profit / Net Sales)*100%

= (117 000/ 1 000 000) *100

= %17.7

Calculation of Current Ratio: - Formula = Current Assets / Current Liabilities

= 135 000/ 47 000

= 2.87 : 1

Calculation of Acid Test Ratio: - Formula = Liquid Assets / Current Liabilities

Liquid Assets = Cash + Accounts Receivables

= 100 000 + 20 000 =  120 000

Acid Test ratio = 120 000/ 47 000 = 2.55 : 1

Calculation of ROCE: Formula = Net Income / Shareholder’s equity

= 177 000 / 225 000

= 0.79

Required :

In addition to these calculations, please make analysis and interpretations of the data determined.

 

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education