Objective: To create a document for a business project, perform various financial analyses, and provide a comprehensive report based on the assumed data (excel based)

Project Type: Godrej Properties Limited.

Required Calculations:

1. Free Cash Flows to the Firm (FCFF).
2. Free Cash Flows to Equity (FCFE).
3. Perform Break-Even Analysis.
4. Net Present Value (NPV) and Internal Rate of Return (IRR) for both the project and equity.
5. Determine the Weighted Average Cost of Capital (WACC).

Cost of Debt and Cost of Equity using the Capital Asset Pricing Model (CAPM).

1. Show calculations for Debt Service Coverage Ratio (DSCR), Loan Life Coverage Ratio (LLCR), and Project Life Coverage Ratio (PLCR).
2. Present Capital Expenditures (Capex).

Assumptions:

• Debt should represent approximately 75% of the project's capital, and equity should constitute around 25%.
• The project's expected life is 10 years.
• Debt is to be repaid by the 7th year.

Deliverables:

Based on the data you are required to calculate the following
1. Free Cash Flows to the Firm (FCFF).
2. Free Cash Flows to Equity (FCFE) Before Tax
3. Free Cash Flows to Equity (FCFE) Afrer Tax
4. Perform Break-Even Analysis for the implementation company
5. Perform Break-Even Analysis for the project owner
6. Net Present Value (NPV) project
7. Net Present Value (NPV) equity.
8. Internal Rate of Return Project
9. Internal Rate of Return Equity
10. Weighted Average Cost of Capital (WACC) using the Capital Asset Pricing Model (CAPM)
11. Cost of Debt using the Capital Asset Pricing Model (CAPM)
12. Cost of Equity using the Capital Asset Pricing Model (CAPM)
13. Debt Service Coverage Ratio (DSCR)
14. Loan Life Coverage Ratio (LLCR),
15. Project Life Coverage Ratio (PLCR).
16. Present Capital Expenditures (Capex).

Excel Document: Create well-structured Excel spreadsheet that includes all relevant data and calculations. Each calculation should be clearly labelled and explained in comments if necessary.

Financial Report: Prepare detailed financial report summarizing the results of your analysis. The report should include charts, tables, and explanations of key findings.

Assumption Documentation: Clearly state any assumptions you make in your analysis. Assumptions should be realistic and justifiable.

Narrative Analysis: Write brief narrative analysis of your findings, including any insights or recommendations.