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 Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter2: Financial Statements, Cash Flow,and Taxes
Section: Chapter Questions
Problem 1Q: Define each of the following terms: Annual report; balance sheet; income statement Common...
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 Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning