Prepare a Cash Flow statement for March 14 based on the excel attached

1. Prepare a Cash Flow statement for March 14 based on the excel attached

2. Calculate the following ratios based on the balance sheet, income statement and cash flow prepared in question 1.above (for March 14):

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

\begin{tabular}{llrr} Balance Sheet (INR Cr) & Units & Mar-13 & Mar-14 \\ \hline Assets & & & \\ \hline Fixed Assets & & & \\ \hline Gross Block & INR Cr & 9,237 & 9,237 \\ Less: Accumulated Depreciation & INR Cr & 439 & 878 \\ \hline Net Block & INR Cr & 8,798 & 8,359 \\ \hline Capital Work-in-Progress & INR Cr & & \\ \hline Working Capital & & & \\ \hline Receivables & INR Cr & 360 & 353 \\ O\&M Expenses & INR Cr & 23 & 24 \\ Maintenance Spares & INR Cr & 92 & 98 \\ Cash & INR Cr & 267 & 679 \end{tabular} Total Assets \begin{tabular}{lll} INR Cr & 9,540 & 9,514 \\ \hline \end{tabular} \begin{tabular}{llrr} \hline Liabilities and Stockholders' Equity & & & \\ \hline Equity Share Capital & INR Cr & 2,771 & 2,771 \\ Retained Earnings & INR Cr & 593 & 1,213 \\ \hline Total Net Worth & INR Cr & 3,364 & 3,984 \\ \hline Debt & & & \\ \hline Project Debt & INR Cr & 5,819 & 5,173 \\ Working Capital Loan & INR Cr & 357 & 357 \\ \hline Total Debt & INR Cr & 6,176 & 5,529 \\ \hline \end{tabular} Total Liabilities and Stockholders' Equity INR Cr 9,5409,514 \begin{tabular}{llr} \hline Income Statement (INR Cr) & Units & Mar-14 \\ Saleable Units & & 4,570 \\ \hline Revenues & & \\ \hline Gross Revenues & INR Cr & 2,116 \\ Less: Environment Cess & INR Cr & 5 \\ \hline Net Revenues & INR Cr & 2,121 \\ Growth (\%) & & 1.9% \\ \hline \end{tabular} Expenses