E) G10 Question 2: The Al-Majid Construction Management Company constructs and operates different communities in certain parts of UAE. The past few years have been difficult ones for Al-Majid facility management company. The demand for Al-Majid Construction Management has been light and the company has been unable to maintain full occupancy. However, Al-Majid Construction management has recently broken ground for the construction of a new community and has more new construction planned over the next 4 years (2022 through 2025). The chief financial officer (CFO) at Al-Majid Construction Management Company, has projected Al-Majid's net cash flows over the next 4 years as shown in the table below, Al-Majid will have negative cash flow for the next few years. With only $1 million in cash reserves, it appears that AL-Majid will need to take out some loans in order to meet its financial obligations. The main Objective is to Mmaximize cash-balance position in 2025, considering the below Financial Parameters: calculate the ending balance of 2022 and 2023. . Long Term 5-Year (LT) Loan: 5% interest rate. Short Term 1-Year (ST) Loan: 7% interest rate. 2022 long term loan of 6m & short term loans of 2 m . 2023 long term loan 5m Year Projected Net Cash Flow (Millions of AED) 2022 -8 2023 -2 2024 -4 2025 3 Note: You need to present the how you calculate the ending balance for each Year using the below formula: Ending Balance = Starting Balance + Cash Flow + Loans - Interest Payments - Loan Payments