Calculate the following ratios based on the balance sheet, income statement and cash flow prepared in question ROE Return on Capital Employed (post-tax) Net Profit Margin EBITDA Margin Effective Tax Rate Operating Cost Ratio Gross Profit Margin Total Asset Turnover Ratio Fixed Asset Turnover Ratio Receivables Turnover Ratio Leverage Ratio [Avg. Total Assets / Avg. Total Equity] FCF / EBITDA Interest Coverage Ratio Debt Service Coverage Ratio Basic EPS (Assume Face Value of each share is INR 10) Debt : Equity Ratio Income Statement (INR Cr)   Units Mar/14 Saleable Units          4,570 Revenues       Gross Revenues   INR Cr      2,116 Less: Environment Cess   INR Cr            5 Net Revenues   INR Cr      2,121 Growth (%)     -1.9%         Expenses       O&M Expenses (% of Project Costs)   INR Cr         146 YoY Escalation     5.72%         EBITDA   INR Cr      1,974 Margin (%)     93.1% Book Depreciation   INR Cr         439 Interest Expenses   INR Cr         786 Interest Income   INR Cr           16 Profit Before Tax   INR Cr         766 Margin (%)     36.1% Tax   INR Cr         146 Effective Tax Rate (%)     19.1% Profit After Tax   INR Cr         620 Margin (%)     29.2%   Balance Sheet (INR Cr)   Units Mar/13 Mar/14 Assets         Fixed Assets         Gross Block   INR Cr      9,237      9,237 Less: Accumulated Depreciation   INR Cr         439         878 Net Block   INR Cr      8,798      8,359 Capital Work-in-Progress   INR Cr           -             -   Working Capital         Receivables   INR Cr         360         353 O&M Expenses   INR Cr           23           24 Maintenance Spares   INR Cr           92           98 Cash   INR Cr         267         679           Total Assets   INR Cr      9,540      9,514           Liabilities and Stockholders' Equity         Equity Share Capital   INR Cr      2,771      2,771 Retained Earnings   INR Cr         593      1,213 Total Net Worth   INR Cr      3,364      3,984 Debt         Project Debt   INR Cr      5,819      5,173 Working Capital Loan   INR Cr         357         357 Total Debt   INR Cr      6,176      5,529           Total Liabilities and Stockholders' Equity   INR Cr      9,540      9,514

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
  1. Calculate the following ratios based on the balance sheet, income statement and cash flow prepared in question
  2. ROE
  3. Return on Capital Employed (post-tax)
  4. Net Profit Margin
  5. EBITDA Margin
  6. Effective Tax Rate
  7. Operating Cost Ratio
  8. Gross Profit Margin
  9. Total Asset Turnover Ratio
  10. Fixed Asset Turnover Ratio
  11. Receivables Turnover Ratio
  12. Leverage Ratio [Avg. Total Assets / Avg. Total Equity]
  13. FCF / EBITDA
  14. Interest Coverage Ratio
  15. Debt Service Coverage Ratio
  16. Basic EPS (Assume Face Value of each share is INR 10)
  17. Debt : Equity Ratio
Income Statement (INR Cr)   Units Mar/14
Saleable Units          4,570
Revenues      
Gross Revenues   INR Cr      2,116
Less: Environment Cess   INR Cr            5
Net Revenues   INR Cr      2,121
Growth (%)     -1.9%
       
Expenses      
O&M Expenses (% of Project Costs)   INR Cr         146
YoY Escalation     5.72%
       
EBITDA   INR Cr      1,974
Margin (%)     93.1%
Book Depreciation   INR Cr         439
Interest Expenses   INR Cr         786
Interest Income   INR Cr           16
Profit Before Tax   INR Cr         766
Margin (%)     36.1%
Tax   INR Cr         146
Effective Tax Rate (%)     19.1%
Profit After Tax   INR Cr         620
Margin (%)     29.2%

 

Balance Sheet (INR Cr)   Units Mar/13 Mar/14
Assets        
Fixed Assets        
Gross Block   INR Cr      9,237      9,237
Less: Accumulated Depreciation   INR Cr         439         878
Net Block   INR Cr      8,798      8,359
Capital Work-in-Progress   INR Cr           -             -  
Working Capital        
Receivables   INR Cr         360         353
O&M Expenses   INR Cr           23           24
Maintenance Spares   INR Cr           92           98
Cash   INR Cr         267         679
         
Total Assets   INR Cr      9,540      9,514
         
Liabilities and Stockholders' Equity        
Equity Share Capital   INR Cr      2,771      2,771
Retained Earnings   INR Cr         593      1,213
Total Net Worth   INR Cr      3,364      3,984
Debt        
Project Debt   INR Cr      5,819      5,173
Working Capital Loan   INR Cr         357         357
Total Debt   INR Cr      6,176      5,529
         
Total Liabilities and Stockholders' Equity   INR Cr      9,540      9,514
Expert Solution
steps

Step by step

Solved in 2 steps with 2 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, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education