Company X desires to develop, construct, and sell an Office Building.

Accordingly, you are kindly requested to develop the feasibility study, financial statements and charts for 5 years that should include the following: CAPEX breakdown Required loans details & repayments Cash flow, Income statement. Financial Ratios (GPM, NPM, Project IRR, Equity IRR, NPV, PI and BCR).

You may assume the following: The Office Building is planned to be sold on the first 2 years equally (calculate the average selling price / m2 that will achieve 25-30% GPM) Collection will be on equal instalments over 4 years. Revenue / Cost Recognition will be the year of finishing the construction.

Unit 5,000 m m % 60% m 3,000 Areas Land Gross Area Footprint Land Net Area Parking Area (% of The Land) Parking Area Landscaping Area Number Of Floors BUA (Built-up area) 25% m 1,250 m 750 3 m 9,000 Development Costs Land Purchase cost/m2 EGP /m EGP /ma m 5,500 15,000 EGP /m 1200 Construction Cost Parking Cost (Per m2) Landscaping Cost (Per m2) Project Management (% of construction Cost) Design Cost%% of construction Cost) EGP / m2 900 5% 750 3% 450 Overheads Progress 1st Year 2 nd Year 3rd Year G&A Expenses (% of Revenue) 6% Land Cost 50% 50% 0% 25% 50% 25% Financials 0% 0% 100% Interest Rate 13% Construction Cost Parking Cost Landscaping Cost Project Management Design Cost 0% 50% 50% 70% 25% 50% 25% Debt WAOC 20% 75% 25% 0% Unit 5,000 m m % 60% m 3,000 Areas Land Gross Area Footprint Land Net Area Parking Area (% of The Land) Parking Area Landscaping Area Number Of Floors BUA (Built-up area) 25% m 1,250 m 750 3 m 9,000 Development Costs Land Purchase cost/m2 EGP /m EGP /ma m 5,500 15,000 EGP /m 1200 Construction Cost Parking Cost (Per m2) Landscaping Cost (Per m2) Project Management (% of construction Cost) Design Cost%% of construction Cost) EGP / m2 900 5% 750 3% 450 Overheads Progress 1st Year 2 nd Year 3rd Year G&A Expenses (% of Revenue) 6% Land Cost 50% 50% 0% 25% 50% 25% Financials 0% 0% 100% Interest Rate 13% Construction Cost Parking Cost Landscaping Cost Project Management Design Cost 0% 50% 50% 70% 25% 50% 25% Debt WAOC 20% 75% 25% 0%