Financial Management:

Question: Work on a language school project: All must be done in Excel. And then prepare an article on MS-Word with your comments.

Part 1: Analysis of profit The specific requirement of this section is to set up the following tables:

1. Prepare the project data sheet (parameters)

2. Sales revenue

3. Operating costs

4. Loan schedule

5. Investment schedule

6. Depreciation schedule

7. The income statement

Part 2: Analysis of financial performance

1. Report a cash flow with point of view of total investment (TIP)

2. Report a cash flow with an investor perspective (Equity)

Note: Calculation of the criteria for evaluating the effectiveness of projects for different views: NPV, IRR, B/C, PP, DSCR (Debt Service Coverage Ratio).

Part 3: Risk analysis

1. One-way sensitivity analysis of the NPV of total investment perspective in part 2 with the risk variables respectively.

2. Two-way sensitivity analysis of the NPV of total investment perspective with two risk variables.

3. Analyze situations with 3 scenarios: good, expected and worse.