Student Housing Köln - Daldrup

1 Student Housing K lnDeveloped by:Inu Pradhan (Nepal)Suman Salike (Nepal)Tobias K hner (Germany)Business by: Inu; Suman; TobiasIntroductionMarket by: Inu; Suman; Tobias It is extremely difficult to find accommodation in Cologne. There are currently more than 84,000 students studying in Cologne and only 4,600 rooms available in Student dormitories-with very long wait lists! It is almost impossible to find a room once the semester starts and the international office can only be of little assistance. You should definitely try to secure a room with the help of friends and acquaintance before you arrive in Germany. Do not expect to be able to find a room at the last minute!

2 IntroductionMarket : University of Cologne International OfficeIntroductionSHKDevl. by: Inu; Suman; TobiasApprox. 84,000 students in CologneUniversity of Cologne fourth University in Europe biggest in Germany44,000 students with approximately 5,900 international students in university of Cologne18,000 students with 2,500 international students in University of Applied ScienceIntroductionMarket : WikipediaSHKDevl. by: Inu; Suman; TobiasBasic IdeaK lnerStudentenwerkoffers only 4,600 placesRest accommodated in private apartmentsEconomic and sufficient accommodation lackingStudents forced to leave their studiesIdea of a Student dormitory as businessIntroductionMarket by: Inu; Suman; TobiasIntroductionMarket AnalysisSHKDevl.

3 By: Inu; Suman; TobiasSource: Factsand Figures University of CologneLocation of the University, FH and Student dormitoriesIntroductionMarket AU801 AU601 AU540 AU299 AU235 AU112 AU55 AU302 AURodenkirchenM ngersdorf356 AUUniversit FH. Medien280 Musik330 = AccommodationUnitsFH. GWZ(seeIWZ)SHKDevl. by: Inu; Suman; TobiasDormitoryAmongthe84 studentdormitoriesfromtheStudentenwerk K ln, only3 arelocatedon theright sideof theRhineand neartheFH (IWZ)Source: K lner StudentenwerkIntroductionMarket by: Inu; Suman; TobiasSingle apartments: Area 14-22 m / 192-256 24-33 m / 237-304 : K lner StudentenwerkComparisionIntroductionMark et comparision of Studentenwerk appartments per sq.

4 M (Euro/ m2)RentAreaSHKDevl. by: Inu; Suman; TobiasWG (single room in shared flat, 2-7 person):Area 15-33 m / 142-389 Euro. Source: K lner StudentenwerkIntroductionMarket comparision of Studentenwerk dtEfferenLindenthalS dS per sq. M (Euro/ m2)RentAreaSHKDevl. by: Inu; Suman; TobiasPrivate rents:Area of 14-28 m / 208-367 : comparision of private stadt S lzAltstadt EhrenfeldInnerstadtLindenthalM lheimZollstockMean3673532803303303403102 50208282316282522251614 LocationRent per (Euro/m2) RentAreaSHKDevl. by: Inu; Suman; TobiasIntroductionMarket by: Inu; Suman; TobiasOurobjectives: Good and economiclivingcondition Enrichtheofferof accommodation Market competetive Contributionto thestate/ socialbenefitIntroductionMarket by: Inu; Suman; TobiasLocationLocation of our dormitory is in K ln-DeutzSource: m landforconstructionin K ln-DeutzIntroductionMarket by: Inu; Suman; TobiasOur site is within walking distance to the FH K ln (IWZ) FH-K ln500 mLines 3+4400 mStadtgarten50 mSource: by: Inu; Suman; TobiasLocationTram stop: Suevenstrasse400mLines 3+4 (6 Min.)

5 To Neumarkt)DeutzerStadtgarten (50m)Fachhochschule K ln IWZ (500m)Also near:Kunsthochschule f r Medien (1500m)Fachhochschule K ln GWZ (2000m)IntroductionMarket by: Inu; Suman; TobiasCopyof theReal EstateLand Register, Liegenschaftskataster: Gebr der-Coblenz-StrasseSiteIntroductionMarke t : KadasteramtK lnSHKDevl. by: Inu; Suman; TobiasSiteGebr der-Coblenz-Strasse3200 m undevelopedareaLivingspacefor184 studentsIntroductionMarket Estate:SHKDevl. by: Inu; Suman; TobiasType BType AIntroductionMarket number of rooms: 184 ModulesSHKDevl. by: Inu; Suman; TobiasModulesType A (WG):Accommodation units of 18m +5m =23m Type B (Single):Accommodation units of 25m Source: NeuffertBauentwurfslehre 36 by: Inu; Suman; TobiasLegalformOrganizational form: Gesellschaftmitbeschr nkterHaftung(GmbH) reducing of risks trough limited liability for each partner flexible framework structure easy foundation procedure also recommended from our reliable advisorIntroductionMarket by: Inu; Suman; TobiasInvestment AnalysisIntroductionMarket by: Inu; Suman; TobiasInvestmentCostIntroductionMarket ( Euro)1 Area of land 3,200 Cost of Land / m 300 Cost of Land 960,0002 Plinth area of building1,400No.

6 Of story6 Total Floor area 8,400 Floor area cost /m 990 Cost of building8,316,0003 Cost of landscaping41,5804 Cost of furniture / ,7405 Unexpected Cost @ % Cost 83,1606 Cash @ % ,580 Total cost9,567,060 SHKDevl. by: Inu; Suman; TobiasSource: investment costs ( )9,567,06040% equity capital ( )3,826,82460% credit capital ( )5,740,236 FinancingSHKDevl. by: Inu; Suman; TobiasFinancingSource: by: Inu; Suman; TobiasDebt & Interest01,0002,0003,0004,0005,0006,0001 357911131517192123252729 YearsAmount ( Thousand Euro)Remaining DebtInterestInstalmentInterest rate % ,5 Running time [years]30 FinancingCostIntroductionMarket installment: 191,314 EuroSHKDevl. by: Inu; Suman; year ( ) ( )1 Land960,000002 Building8,316,00050166,3203 Landscaping41,580104,1584 Furniture/ ,7401012,4745 Unseen cost83,160108,3166 Cash41,58000 Total9,567,060191,268 IntroductionMarket by: Inu; Suman; TobiasPersonnelCostStaffEmpl.

7 TypeGross Costs[ /year]Caretakerfull-time36,000 Cleaner / Helpertemporary9,600 Total45,600 IntroductionMarket by: Inu; Suman; TobiasRunningCostItemUnitAmountCosts/ UnitCosts[Unit/year][ /Unit][ /year]HeatingLitre33, ,510 ElectricitykWh158, ,436 Freshwaterm36, ,074 Waste disposal5,000 Telephone600 Insurances16,632 Loss by vandalizing 5,000 Fund for replacement5,000 Internet8,000 Miscellaneous2,000 Total93,252 IntroductionMarket by: Inu; Suman; TobiasTotalCostperYearIntroductionMarket cost per year0100200300400500600700 YearCost ( Thousand Euro)Financing315,7305,1294,6284,1273,62 63,0252,5242,0231,5220,9 Running93,2593,2593,2593,2593,2593,2593, 2593,2593,2593,25 Personell45,6045,6045,6045,6045,6045,604 5,6045,6045,6045,60 Depreciation191,2191,2191,2191,2191,2191 ,2191,2191,2191,2191,212345678910 SHKDevl.

8 By: Inu; Suman; TobiasPricedeterminationOur main objective is to provide service for s why we try to keep the rent as low as possible. IntroductionMarket : K lner StudentenwerkPrice comparision of Studentenwerk dtEfferenLindenthalNeustadtS lzDeutzMeanType per sq. m (Euro/ m2)RentAreaSHKDevl. by: Inu; Suman; TobiasPricedetermination Price competitive with dormitories of Studentenwerk Far cheaper than private apartmentsIntroductionMarket comparision of Studentenwerk ndersdorfLindenthalS lzUnicenterZollstockDeutzMeanType per sq. m (Euro/ m2)Source: K lner StudentenwerkRentAreaSHKDevl. by: Inu; Suman; TobiasTurnoverDescriptionType AType BType AType BType AType BAvail. Rooms (in u.)929292929292 Utili.

9 Of cap. (in %)808090909898 Rented rooms (in u.)737382829090 turnover3. for Utility First year 80%. Second year 90%. Third year and onward 98%.IntroductionMarket by: Inu; Suman; TobiasCost/ Turnover The cost gradually decreases from first year onward Turnover less than cost in initial 2 years, but constantly above cost after third year onward From the 6 thyear onward we will start earning profitCost, Turnover & Profit-200-10001002003004005006007001234 5678910 YearsAmount ( Thousand Euro)TurnoverCostProfit before taxIntroductionMarket by: Inu; Suman; TobiasCash Flow/ Dividend Cash flow is never negative Repayment credit is constant for 30 years From the 6 thyear onward , shareholder starts to earn dividendsProfit, Cash Flow & Dividend-200-150-100-5005010015020025030 012345678910 YearsAmount ( Thousand Euro)Profit after taxCash flowRepayment CreditDividendIntroductionMarket by: Inu; Suman; TobiasProfit Profit from seventh year onward Profit increases constantly All debts and interests are paid within 30 years After 50 years the building can still be usedIntroductionMarket made by Shareholders by: Inu; Suman; TobiasConclusionIntroductionMarket by: Inu; Suman.

10 TobiasConclusionIntroductionMarket reached our self settled goals and got a win-win situation where all partners of our project will benefit: all students of K ln, especially all intern. students the Student Housing K lnitself the StudentenwerkK ln the Municipality of K ln the KfWas our financing partner you as our investment partner of confidence and finally us as creative directors Thank You for your attentionHope we convinced contact is in your hands now SHKDevl. by: Inu; Suman; TobiasKaufwerte f r Baulandnachausgew hlten Baulandarten und L ndern 2005 BaulandinsgesamtBaureifesLandRohbau-land SonstigesBaulandDurchschnittlicher Kaufwert in EUR /m2 Baden-W rttemberg156,46188,7444,4873,04 Bayern156,96221,8466,0263,72 Berlin115,47401,5416,57-Brandenburg50,51 53,4429,4848,57 Bremen137,15138,01-127,59 Hamburg383,33392,93-173,11 Hessen114,72125,7959,4154,87 Mecklenburg-Vorpommern25,5953,208,993,96 Niedersachsen55,4966,6423,2335,71 Nordrhein-Westfalen97,60125,1738,2233,21 Rheinland-Pfalz75,2697,3615,5036,56 Saarland50,6972,2214,4326,12 Sachsen23,7851,6411,515,80 Sachsen-Anhalt27,8335,4212,2817,45 Schleswig-Holstein66,58101,3818,7428,37T h ringen34,5341,988,0013,18 Deutschland85.