NASEEJ COMPANY PROJECT Fatima Juma 201000499 Wafa Radhi

  • Slides: 12
Download presentation
NASEEJ COMPANY PROJECT Fatima Juma 201000499 Wafa Radhi 201000168 Mariam Alshamlan 20900030

NASEEJ COMPANY PROJECT Fatima Juma 201000499 Wafa Radhi 201000168 Mariam Alshamlan 20900030

MAIN POINTS Optimal Debt to Equity Optimal Rent Required At Required Return Market Research

MAIN POINTS Optimal Debt to Equity Optimal Rent Required At Required Return Market Research Mortgage Amortization Financial Instruments Five Years Financial Model Conclusion

DEBT-TO-EQUITY Cost Legal 3, 350, 000 45, 000. 00 Commission 0. 02 67, 000.

DEBT-TO-EQUITY Cost Legal 3, 350, 000 45, 000. 00 Commission 0. 02 67, 000. 00 Title Transfer Fees 0. 02 67, 000. 00 Debt to equity Debt Equity Debt-to-equity Ratio 3, 529, 000. 00 2, 117, 400. 000 1, 411, 600. 00 1. 5

COMMERCIAL SPACE Super Market

COMMERCIAL SPACE Super Market

RENTAL INCOME

RENTAL INCOME

MARKET RESEARCH Apartments Budaiya Amwaj Seef District bedroom No: 2 Bedrooms 700 -900 500

MARKET RESEARCH Apartments Budaiya Amwaj Seef District bedroom No: 2 Bedrooms 700 -900 500 -700 300 -350 3 Bedrooms 400 - 450 900 -1000 800 -850 4 Bedrooms 600 -650 1100 -1300 900 -1100

DEBT INTEREST RATE Ithmar Loan Amount BD 2, 117, 400. 000 Interest Rate 0.

DEBT INTEREST RATE Ithmar Loan Amount BD 2, 117, 400. 000 Interest Rate 0. 0050 Months Payments 300 BD 7, 509. 781 NBB Loan Amount BHD 2, 117, 400. 000 Interest Rate 0. 0058 Months Payments 300 BHD 7, 586. 862

FINANCIAL ANALYSIS Net Operating Income Annual Revenue Security Cleaning Maintenance Annual BHD BHD Insurance,

FINANCIAL ANALYSIS Net Operating Income Annual Revenue Security Cleaning Maintenance Annual BHD BHD Insurance, fees & general expenses BHD 9, 600 100% Occupied NOI BHD 298, 500 BHD 217, 905 326, 100 7, 200 6, 000 4, 800 Assumptions of 70%-80% Occupation 73% Occupied

Sensitivity Analysis Scenario 1 Worse Case 0% BHD - Scenario 2 Base Case 3%

Sensitivity Analysis Scenario 1 Worse Case 0% BHD - Scenario 2 Base Case 3% BHD Scenario 3 Best Case 6% BHD 13, 074. 300 6, 537. 150 Worse Case 0% Year 1 2 3 4 5 Occupy Growth 0% 0% 0% BHD 217, 905 NOI BHD 217, 905 Base Case 3% Year Occupy Growth NOI Best Case 6% Year Occupy Growth NOI BHD 217, 905 1 73% BHD 159, 071 1 73% BHD 217, 905 2 76% BHD 226, 860 BHD 217, 905 3 79% BHD 235, 815 2 79% BHD 159, 071 BHD 235, 815 BHD 4 82% BHD 244, 770 3 85% 4 91% 5 85% BHD 253, 725 5 97% 253, 725 BHD 271, 635 BHD 289, 545

5 YEARS CASH FLOW PROJECTION Year 0 Starting Balance Equity Revenue Debt Interest Principle

5 YEARS CASH FLOW PROJECTION Year 0 Starting Balance Equity Revenue Debt Interest Principle Cost Ending Balance Free Cash Flow Terminal Sale Price BHD - Year 1 BHD - Year 2 Year 3 Year 4 Year 5 Total BHD BHD 41, 353. 626 150, 496. 253 268, 593. 880 395, 646. 507 BHD 1, 411, 600. 000 BHD 159, 071. 000 BHD 2, 117, 400. 000 BHD 10, 404. 490 BHD 79, 712. 884 BHD 226, 860. 000 BHD 10, 005. 010 BHD 80, 112. 363 BHD 235, 815. 000 BHD 9, 603. 529 BHD 80, 513. 844 BHD 244, 770. 000 BHD 9, 200. 036 BHD 80, 917. 337 BHD 3, 529, 000 - 27, 600. 000 BHD BHD 41, 353. 626 BHD 27, 600. 000 BHD 150, 496. 253 BHD 27, 600. 000 BHD 268, 593. 880 BHD BHD 27, 600. 000 - 3, 667, 000 BHD BHD 395, 646. 507 531, 654. 135 BHD 3, 520, 000 BHD 4, 051, 654. 135 BHD 253, 725. 000 BHD 8, 794. 521 BHD 81, 322. 851 BHD 1, 120, 241. 000 BHD 48, 007. 586 BHD 402, 579. 279

FINAL ANALYSIS IRR NPV Revenue Interest Cost Income ROI 29% BHD 1, 070, 248.

FINAL ANALYSIS IRR NPV Revenue Interest Cost Income ROI 29% BHD 1, 070, 248. 995 4, 640, 241 48, 008 -3, 667, 000 925, 233. 4 65. 55

CONCLUSION HIGH IRR, NPV AND ROI MEANS THAT IT IS SUCCESSFUL PROJECT.

CONCLUSION HIGH IRR, NPV AND ROI MEANS THAT IT IS SUCCESSFUL PROJECT.