Assessment Details:
- Use MS Office Excel to create a business plan 2024 to 2028 (P/L, B/S and CFS and key ratios eg ROE, debt coverage, interest coverage) stating assumptions.
- Devise a method to automate the change in financials and ratios for scenario: (1) Investment amount US$1Bn, (b) return on investment 10%, (c) 100% debt funding at 4% interest
- Devise a method to automate the change in financials and ratios for a chosen scenario decided by candidate
- MS Office PowerPoint presentation to present the business plan including waterfall on the changes from 2023 to 2024. Please also show supporting workings if any in MS Office Excel.