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
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...
Related questions
Question
- Calculate the following ratios based on the
balance sheet , income statement andcash 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 |
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: |
INR Cr | 439 | 878 | |
Net Block | INR Cr | 8,798 | 8,359 | |
Capital Work-in-Progress | INR Cr | - | - | |
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 |
||||
Equity Share Capital | INR Cr | 2,771 | 2,771 | |
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning