Fill in the yellow blanks.

Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF A 8 AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V 11 Y APA == 4. Wao Text General y Svvv 27. O v Paste B TU A = = = Marge & Centar Insert Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter Find & Select Y Analyze Data H1 fix A B C D E F G H j M N 0 P Q R R S T 2 Name: 2015 2016 2017 2018 2019 2020 1/1/15 Rate SQ FT LAR Expires Year 1 Year 6 Year 2 Years Year 4 Year 5 Base Rent Schedulestarting January 1, 2015 $18,000.00 $18,000.00 $18,000.00 $19,350.00 $19,350.00 $22,750.00 900 900 1,700 1,700 1,300 1,300 1,100 2,100 1,200 1,700 1,800 1,500 2,000 2,000 10,000 10,000 12/31/13 1281/16 12/31/17 6/30/10 12/31/15 5/30/15 $16.50 $14,850.00 $17.00 $28,900.00 $17.50 $20.000.00 $ $17.00 $18,700.00 $16.50 $19,000.00 $15.50 $32.850.00 $20.00 $ $40,000.00 $177,850,00 $36,000.00 $40,000.00 $36,000.00 $40,000.00 $37,350,09 $43,000.00 $38,700.00 $43,000.00 $38,700.CO $43,000.00 $5,502.62 $183,452.62 S 6 7 Tenant Market Rate by Year 9 100 Tenant 10 101 Tenant 11 102 Tenant 12 103 Tenant 13 200 Tenant 14 205 Tenant F 15 220 Tenant 16 Torals 17 18 Other pass through 19 Patential Gross Income 20 21 Vacancy Loss 22 Collection Lou 23 Total vacancy and Collection Loss 24 25 Effective Gross Income 26 27 28 29 30 31 32 33 34 35 36 37 EGI Summary ($9,172.63) $5,503.58) 1514.676.21) $160,776.41 Rentroll 210 210(Year) 100 205 200 103 101 102 + Ready A + 100% % 3 DEC 1 tv X A a 18 Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF A 8 AO FC ... FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) v 11 Y = = = Y 9. Wrap Text Date Svvv AP A v - WAS Paste = = +E $ % 9 Insert Delete Merga & Centar Format Conditional Format Formatting as Table Cell Styles Sort & Filter Find & Select Analyze Data fx 5 years A B C D E F H 2 Assumptions 4500 Finance Building GLA 10,000 square feet S Proposed Acquisition Date 01/01/15 6 Holding Period 5 years 3 7 SEE RENTROLL ALONG WITH ASSUMPTIONS OLLOW 1 Market Occupancy reported at 15.00% and sad stablefar halding period 2 Merket Rates are assumed as follows and all lesses are assumed to berrade at the then current market rent, 1st for 3 years with an increase of $1.50 for years 4 and 5 Years 1.3 Years 4.5 2015 $20.00 $21.50 2016 $20.00 $21.50 2017 $20.50 $22.00 2018 $21.00 $22.50 2019 $21.50 $23.00 2020 $21.50 $23.00 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 3 NI Terentsare expected to renew at the current market rent schedule for five year terms 4 Suite 210 is currently vacan, however, it is sumed it will be leazed effective 1/1/2015 for five years at the market rate. Year 1 $20.00 Year 2 $20.00 Year 3 $20.00 Year 4 $21.50 Year 5 $21.50 5 5 Market Credit luss is 3% for the holding period 6 Recoverable Expense Incomels estimated at $5,502.52 per year for 2015 and is anticiparc ta grow 2% per year 34 35 36 37 EGI Summary Rentroll 210 210(Year) / 100 205 200 103 101 102 + RE Ready A 3 DEC 1 tv A A O 18 Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave IF A 8 AOFC FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V v 1 11 VA APA == sy, Wyo Text General y E~ yu O Paste BTU 111 A == Merga & Centar Delete $ % Conditional Format Formatting as Table Cell Styles Insert Format Sort Filter Find & Select Y Analyze Data A25 fx E F G H j K M N P 1 2 3 B C 4500 Finance Building Rentroll Information Effective June 1, 2014 Current Base Rate Current Monthy Annual Rent Current Month Base Rent Current Monthy Additional Rent Current Monthy Total Rent 4 Sulte Tenant SQ FT Leased Commence Expire B Rent Increases 5 6 7 100 201 202 103 200 205 210 Tenant A Tenants Tenant Tenant llam Tenant E Tenant F VACANT Totals 900 1,700 1,300 1,100 1.200 1.800 2,000 10,000 900 1,700 1,300 1,100 1,200 1,800 01/01/10 01/01/11 02/01/12 07/01/11 03/01/10 07/01/10 12/31/15 12/31/16 12/31/17 06/10/16 12/31/15 06/30/15 $16.50 $17.00 $17.50 $17.00 $16.50 $16.50 $0.00 $14,850.00 $28.900.00 $22,750.00 $18,700.00 $:9,800.00 $ $29,700.00 $0.00 $134,700.00 $1,287.50 $ $2.408.33 $1.895.83 $1,55833 $1,650.00 $2,475,00 $0 on $11,225.00 $59.13 $90.45 $52.51 $58.52 $78.84 $118.27 $0.00 $457.73 $1,796.63 $2.498.78 $ $1,948.34 $1,616.6 $1.728.84 $2,593.22 $0.00 $11,682.73 W 1-3 $15.00 W44-5 16.50 Yrs 3 $15.50 Y:45 17.00 Yr 1-3 $16.00 Yrs 4-5 17.50 Yr 1-3 $15.50 Yrs 4-517.00 Yrs 1 3 $15.00 Yrs 4-516.50 Yr 1-3 $15.00 Yrs 4-5 16.50 8.000 80.00% B 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 21 32 33 34 35 36 EGI Summary Rentroll 210 210(Year! ) 100 205 200 103 101 102 + Ready A 3 DEC 0 1 tv o A A Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF A 8 AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V 11 VA AP == 4. Wao Text Accounting y O v Paste BIU A = == $ % 9 Merga & Centar Conditional Format Formatting as Tabla Format Cell Styles Insert Sort Filter Find & Select Y Analyze Data D22 x fx 43000 3 C A D E F F I J K L M N 0 P Q R S T U V w X Unit Leasing Assumptions Market Rent Information S Suite Commencement Expiration Term Tyears! Area (sq.ft.) 7 8 210 1/1/15 12/31/19 9 5 2,000 Rate Schedule Start 1/1/15 1/1/10 1/1/17 1/1/18 1/1/19 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $22.CO $21.00 $22.50 $250 $23.00 $21.50 $23.00 Year 1 Year 2 Year 3 Year 4 Year 5 End 12/31/15 12/31/10 12/31/17 12/31/18 12/31/19 Rate/psil $20.00 $20.00 $20.00 $21.50 $21.50 Calender Year Annual Rent 2015 40,000.00 2016 40,000.00 2017 40,000.00 2018 43,000.00 2019 43,000.00 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv A A O Insert 2 Wed Dec 1 9:49 AM U Excel File Edit View Format Tools Data Window Help ... AutoSave OFF AO FC ... FIN 4500 Project Part 1 Student Worksheet-1 Home Insert Draw Page Layout Formulas Data Review View Tell me - X Calibri (Body) v 11 AP == 9. Wrao Text Currency Paste BIU A Conditional Format == Cell + $% Merge & Center Formatting as Tabla Styles Share Comments V Y a Y SvLIvy y - v Insert Format Sort Filter Find & Select Y Analyze Data D40 fx 38700 fr A C D E F 6 I J K L M N 0 P Q R S T U V w X Calender Year Annual Rent Jan-June July-DA 2015 $32.850.00 $16.50 Last 6 months of Contract $20.00 1A $18.25 Jan-June July Dec 2016 $20.00 16 $20.00 za $20.00 2 $36,000.00 Jan-June July-Dec 2017 $20.00 2b $20.00 3 3a $36,000.00 $20.00 Jan-June July-DA 2018 $20.00 3 3b $A $21.50 4 $20.75 $27.350.00 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 32 39 40 41 42 43 44 45 46 47 48 49 50 51 52 lan - June July Dec $21.50 41 $21.50 5a $ 321.30 $21.50 2019 $38,700.00 Jan June July - Dec 2020 $21.50 56 $21.50 $38,700.00 $21.50 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC DO 1 tv A A O Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF AO FC ... U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X a V Calibri (Body) 11 VA APA = = = 2. Wao Text Currency y SvLIvy y O v Paste BTU A = = + Marge & Center Conditional Format Formatting as Tabla Cell Styles Format Insert Sort Filter Find & Select Y Analyze Data D1B A C D E F . H I J K L M N 0 P Q R S T U V w X Unit Leasing Assumptions Market Rent Information S Suite Commencement Expiration Term Cyears! Area (sq.ft.) 7 8 200 1/1/16 12/31/20 5 1,200 Rate Schedule Start 1/1/16 1/1/17 1/1/18 1/1/19 1/1/20 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $22.CO $21.00 $22.50 $250 $23.00 $21.50 $23.00 Rate/psil Year 1 Year 2 Year 3 Year 4 Year 5 End 12/31/16 12/31/17 12/31/18 12/31/19 12/30/20 Calender Year Annual Rent 2016 2017 2018 2019 2020 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv A A O Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) V 11 AI == 24. Wao Text General y SvLIvy y O Paste . CA A A == + Merga & Centar $ % 9 Conditional Format Formatting as Table Format Cell Styles Insert Sort Filter Find & Select Y Analyze Data B9 . x fr Rate Schedule A C D E F . H I L M N 0 P Q R S T U V w X Unit Leasing Assumptions Market Rent Information S Suite Commencement Expiration Term years! Area/sq.ft. 7 103 7/1/16 6/33/21 5 1.100 Rate Schedule Start 7/1/16 7/1/12 7/1/18 7/1/19 7/1/20 2015 2016 2017 2018 2019 2020 2021 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $ $22.CO . $21.00 $22.50 $21.50 $23.00 $21.50 $23.co $21.50 $23.00 Rate/psil Year 1 Year 2 Year 3 Year 4 Year 5 End 5/30/17 6/30/12 6/30/19 5/30,20 6/30/2 Last 6 months of Contract Calender Year Annual Rent Jan-June July-DA 2016 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Jan-June July Dec 2017 Jan June July-Dec 2018 Jan-June 2019 Jan - June July Dec 2020 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv A A O Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V v 11 VA APA = = = 4. Wao Text Currency y SvLIvy - v Paste BIU A = = + Merga & Centar $ % 9 Conditional Format Formatting as Tabla Cell Styles Insert Format Sort Filter Find & Select Y Analyze Data D22 A C D E F H I J K L M N 0 P Q R S T U V w X 101 S Suite Commencement Expiration Term (years) Area (sq.ft.) 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.53 $22.CO $21.00 $22.50 $21.50 $23.00 $21.50 $23.00 Rate Schedule Start End Rate/pu Year 1 Year 2 Year 3 Year 4 Years Calender Year Annual Rent 2017 2018 2019 2020 2021 INote 2020 Ends Hold Period. Caluculate 2021 but it donat transfer to Income Statement 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv 17 o A Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave IF A 8 AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X a V Calibri (Body) 11 VA APA == s 24. Wao Text Y General SvLIvy y - v Paste BIU CA = == Merge & Centar $ % 9 Conditional Format Formatting as Tabla Format Cell Styles Insert Sort Filter Find & Select Y Analyze Data H18 A C E E F H I J K L M N 0 P Q R S T U V w X 102 S 3 Suite Commencement Expiration Term (years) Area (sq.ft.) 7 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $22.Co $21 00 $22.50 $21.50 $23.00 $21.50 $23.00 Rate Schedule Start End Rate/pu Year 1 Year 2 Year 3 Year 4 Years Calender Year Annual Rent 2018 2019 2020 2021 2022 Note 2020 Ends Hold Period, Caluculate 2021 but it does not transfer to Income Statement 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 + Ready A 3 DEC 1 tv o A Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF A 8 AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V 11 Y APA == 4. Wao Text General y Svvv 27. O v Paste B TU A = = = Marge & Centar Insert Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter Find & Select Y Analyze Data H1 fix A B C D E F G H j M N 0 P Q R R S T 2 Name: 2015 2016 2017 2018 2019 2020 1/1/15 Rate SQ FT LAR Expires Year 1 Year 6 Year 2 Years Year 4 Year 5 Base Rent Schedulestarting January 1, 2015 $18,000.00 $18,000.00 $18,000.00 $19,350.00 $19,350.00 $22,750.00 900 900 1,700 1,700 1,300 1,300 1,100 2,100 1,200 1,700 1,800 1,500 2,000 2,000 10,000 10,000 12/31/13 1281/16 12/31/17 6/30/10 12/31/15 5/30/15 $16.50 $14,850.00 $17.00 $28,900.00 $17.50 $20.000.00 $ $17.00 $18,700.00 $16.50 $19,000.00 $15.50 $32.850.00 $20.00 $ $40,000.00 $177,850,00 $36,000.00 $40,000.00 $36,000.00 $40,000.00 $37,350,09 $43,000.00 $38,700.00 $43,000.00 $38,700.CO $43,000.00 $5,502.62 $183,452.62 S 6 7 Tenant Market Rate by Year 9 100 Tenant 10 101 Tenant 11 102 Tenant 12 103 Tenant 13 200 Tenant 14 205 Tenant F 15 220 Tenant 16 Torals 17 18 Other pass through 19 Patential Gross Income 20 21 Vacancy Loss 22 Collection Lou 23 Total vacancy and Collection Loss 24 25 Effective Gross Income 26 27 28 29 30 31 32 33 34 35 36 37 EGI Summary ($9,172.63) $5,503.58) 1514.676.21) $160,776.41 Rentroll 210 210(Year) 100 205 200 103 101 102 + Ready A + 100% % 3 DEC 1 tv X A a 18 Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF A 8 AO FC ... FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) v 11 Y = = = Y 9. Wrap Text Date Svvv AP A v - WAS Paste = = +E $ % 9 Insert Delete Merga & Centar Format Conditional Format Formatting as Table Cell Styles Sort & Filter Find & Select Analyze Data fx 5 years A B C D E F H 2 Assumptions 4500 Finance Building GLA 10,000 square feet S Proposed Acquisition Date 01/01/15 6 Holding Period 5 years 3 7 SEE RENTROLL ALONG WITH ASSUMPTIONS OLLOW 1 Market Occupancy reported at 15.00% and sad stablefar halding period 2 Merket Rates are assumed as follows and all lesses are assumed to berrade at the then current market rent, 1st for 3 years with an increase of $1.50 for years 4 and 5 Years 1.3 Years 4.5 2015 $20.00 $21.50 2016 $20.00 $21.50 2017 $20.50 $22.00 2018 $21.00 $22.50 2019 $21.50 $23.00 2020 $21.50 $23.00 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 3 NI Terentsare expected to renew at the current market rent schedule for five year terms 4 Suite 210 is currently vacan, however, it is sumed it will be leazed effective 1/1/2015 for five years at the market rate. Year 1 $20.00 Year 2 $20.00 Year 3 $20.00 Year 4 $21.50 Year 5 $21.50 5 5 Market Credit luss is 3% for the holding period 6 Recoverable Expense Incomels estimated at $5,502.52 per year for 2015 and is anticiparc ta grow 2% per year 34 35 36 37 EGI Summary Rentroll 210 210(Year) / 100 205 200 103 101 102 + RE Ready A 3 DEC 1 tv A A O 18 Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave IF A 8 AOFC FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V v 1 11 VA APA == sy, Wyo Text General y E~ yu O Paste BTU 111 A == Merga & Centar Delete $ % Conditional Format Formatting as Table Cell Styles Insert Format Sort Filter Find & Select Y Analyze Data A25 fx E F G H j K M N P 1 2 3 B C 4500 Finance Building Rentroll Information Effective June 1, 2014 Current Base Rate Current Monthy Annual Rent Current Month Base Rent Current Monthy Additional Rent Current Monthy Total Rent 4 Sulte Tenant SQ FT Leased Commence Expire B Rent Increases 5 6 7 100 201 202 103 200 205 210 Tenant A Tenants Tenant Tenant llam Tenant E Tenant F VACANT Totals 900 1,700 1,300 1,100 1.200 1.800 2,000 10,000 900 1,700 1,300 1,100 1,200 1,800 01/01/10 01/01/11 02/01/12 07/01/11 03/01/10 07/01/10 12/31/15 12/31/16 12/31/17 06/10/16 12/31/15 06/30/15 $16.50 $17.00 $17.50 $17.00 $16.50 $16.50 $0.00 $14,850.00 $28.900.00 $22,750.00 $18,700.00 $:9,800.00 $ $29,700.00 $0.00 $134,700.00 $1,287.50 $ $2.408.33 $1.895.83 $1,55833 $1,650.00 $2,475,00 $0 on $11,225.00 $59.13 $90.45 $52.51 $58.52 $78.84 $118.27 $0.00 $457.73 $1,796.63 $2.498.78 $ $1,948.34 $1,616.6 $1.728.84 $2,593.22 $0.00 $11,682.73 W 1-3 $15.00 W44-5 16.50 Yrs 3 $15.50 Y:45 17.00 Yr 1-3 $16.00 Yrs 4-5 17.50 Yr 1-3 $15.50 Yrs 4-517.00 Yrs 1 3 $15.00 Yrs 4-516.50 Yr 1-3 $15.00 Yrs 4-5 16.50 8.000 80.00% B 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 21 32 33 34 35 36 EGI Summary Rentroll 210 210(Year! ) 100 205 200 103 101 102 + Ready A 3 DEC 0 1 tv o A A Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF A 8 AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V 11 VA AP == 4. Wao Text Accounting y O v Paste BIU A = == $ % 9 Merga & Centar Conditional Format Formatting as Tabla Format Cell Styles Insert Sort Filter Find & Select Y Analyze Data D22 x fx 43000 3 C A D E F F I J K L M N 0 P Q R S T U V w X Unit Leasing Assumptions Market Rent Information S Suite Commencement Expiration Term Tyears! Area (sq.ft.) 7 8 210 1/1/15 12/31/19 9 5 2,000 Rate Schedule Start 1/1/15 1/1/10 1/1/17 1/1/18 1/1/19 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $22.CO $21.00 $22.50 $250 $23.00 $21.50 $23.00 Year 1 Year 2 Year 3 Year 4 Year 5 End 12/31/15 12/31/10 12/31/17 12/31/18 12/31/19 Rate/psil $20.00 $20.00 $20.00 $21.50 $21.50 Calender Year Annual Rent 2015 40,000.00 2016 40,000.00 2017 40,000.00 2018 43,000.00 2019 43,000.00 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv A A O Insert 2 Wed Dec 1 9:49 AM U Excel File Edit View Format Tools Data Window Help ... AutoSave OFF AO FC ... FIN 4500 Project Part 1 Student Worksheet-1 Home Insert Draw Page Layout Formulas Data Review View Tell me - X Calibri (Body) v 11 AP == 9. Wrao Text Currency Paste BIU A Conditional Format == Cell + $% Merge & Center Formatting as Tabla Styles Share Comments V Y a Y SvLIvy y - v Insert Format Sort Filter Find & Select Y Analyze Data D40 fx 38700 fr A C D E F 6 I J K L M N 0 P Q R S T U V w X Calender Year Annual Rent Jan-June July-DA 2015 $32.850.00 $16.50 Last 6 months of Contract $20.00 1A $18.25 Jan-June July Dec 2016 $20.00 16 $20.00 za $20.00 2 $36,000.00 Jan-June July-Dec 2017 $20.00 2b $20.00 3 3a $36,000.00 $20.00 Jan-June July-DA 2018 $20.00 3 3b $A $21.50 4 $20.75 $27.350.00 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 32 39 40 41 42 43 44 45 46 47 48 49 50 51 52 lan - June July Dec $21.50 41 $21.50 5a $ 321.30 $21.50 2019 $38,700.00 Jan June July - Dec 2020 $21.50 56 $21.50 $38,700.00 $21.50 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC DO 1 tv A A O Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF AO FC ... U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X a V Calibri (Body) 11 VA APA = = = 2. Wao Text Currency y SvLIvy y O v Paste BTU A = = + Marge & Center Conditional Format Formatting as Tabla Cell Styles Format Insert Sort Filter Find & Select Y Analyze Data D1B A C D E F . H I J K L M N 0 P Q R S T U V w X Unit Leasing Assumptions Market Rent Information S Suite Commencement Expiration Term Cyears! Area (sq.ft.) 7 8 200 1/1/16 12/31/20 5 1,200 Rate Schedule Start 1/1/16 1/1/17 1/1/18 1/1/19 1/1/20 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $22.CO $21.00 $22.50 $250 $23.00 $21.50 $23.00 Rate/psil Year 1 Year 2 Year 3 Year 4 Year 5 End 12/31/16 12/31/17 12/31/18 12/31/19 12/30/20 Calender Year Annual Rent 2016 2017 2018 2019 2020 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv A A O Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) V 11 AI == 24. Wao Text General y SvLIvy y O Paste . CA A A == + Merga & Centar $ % 9 Conditional Format Formatting as Table Format Cell Styles Insert Sort Filter Find & Select Y Analyze Data B9 . x fr Rate Schedule A C D E F . H I L M N 0 P Q R S T U V w X Unit Leasing Assumptions Market Rent Information S Suite Commencement Expiration Term years! Area/sq.ft. 7 103 7/1/16 6/33/21 5 1.100 Rate Schedule Start 7/1/16 7/1/12 7/1/18 7/1/19 7/1/20 2015 2016 2017 2018 2019 2020 2021 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $ $22.CO . $21.00 $22.50 $21.50 $23.00 $21.50 $23.co $21.50 $23.00 Rate/psil Year 1 Year 2 Year 3 Year 4 Year 5 End 5/30/17 6/30/12 6/30/19 5/30,20 6/30/2 Last 6 months of Contract Calender Year Annual Rent Jan-June July-DA 2016 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Jan-June July Dec 2017 Jan June July-Dec 2018 Jan-June 2019 Jan - June July Dec 2020 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv A A O Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave OFF AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) V v 11 VA APA = = = 4. Wao Text Currency y SvLIvy - v Paste BIU A = = + Merga & Centar $ % 9 Conditional Format Formatting as Tabla Cell Styles Insert Format Sort Filter Find & Select Y Analyze Data D22 A C D E F H I J K L M N 0 P Q R S T U V w X 101 S Suite Commencement Expiration Term (years) Area (sq.ft.) 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.53 $22.CO $21.00 $22.50 $21.50 $23.00 $21.50 $23.00 Rate Schedule Start End Rate/pu Year 1 Year 2 Year 3 Year 4 Years Calender Year Annual Rent 2017 2018 2019 2020 2021 INote 2020 Ends Hold Period. Caluculate 2021 but it donat transfer to Income Statement 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 Ready A 3 DEC 1 tv 17 o A Excel File Edit View Insert Format Tools Data Window Help 2 Wed Dec 1 9:49 AM ... AutoSave IF A 8 AOFC U FIN 4500 Project Part 1 Student Worksheet-1 Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X a V Calibri (Body) 11 VA APA == s 24. Wao Text Y General SvLIvy y - v Paste BIU CA = == Merge & Centar $ % 9 Conditional Format Formatting as Tabla Format Cell Styles Insert Sort Filter Find & Select Y Analyze Data H18 A C E E F H I J K L M N 0 P Q R S T U V w X 102 S 3 Suite Commencement Expiration Term (years) Area (sq.ft.) 7 2015 2016 2017 2018 2019 2020 Years 1-3 Years 4-5 $20.00 $21.50 $20.00 $21.50 $20.50 $22.Co $21 00 $22.50 $21.50 $23.00 $21.50 $23.00 Rate Schedule Start End Rate/pu Year 1 Year 2 Year 3 Year 4 Years Calender Year Annual Rent 2018 2019 2020 2021 2022 Note 2020 Ends Hold Period, Caluculate 2021 but it does not transfer to Income Statement 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 EGI Summary Rentroll 210 210(Year) 100 205 200 103 101 102 + Ready A 3 DEC 1 tv o A