Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in all the blanks on the first picture. AutoSave OF Av .. FIN 4500 Project Part 2 Student Worksheet View Tell me Home Insert
Fill in all the blanks on the first picture.
AutoSave OF Av .. FIN 4500 Project Part 2 Student Worksheet View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Body) v 11 X [ G v A A Wrap Text General v FO) IN Analyze Data Paste B 1 7 Av = = = Y Merge & Center v $ %) Insert Delete Format Conditional Format Cell Formatting es Table Styles Sort & Filter Find & Select K34 fx A B C E F G H M N P Q R S T 4 5 6 2015 2016 2017 2011 2019 2020 7 SOFT Land Expires 4300 900 900 1,700 1,700 1,300 1,100 2,100 1,200 1,200 1,800 1,300 2,000 2,000 10,000 10,000 12/31/15 12/31/16 12/31/17 6/30/16 12/31/15 5/30/15 1/1/15 Rate Year 1 Yew 3 Year 4 Year 5 Year 6 Base Rent Schedulestarting January 1, 2015 $16.50 $14,850.00 $18,000.00 $18,000.00 $18,000.00 $19,350.00 $19,350.00 $ $ $17.00 $28,000.00 $28,000.00 $34 85000 $34,850,00 $34,850.00 $37,100.00 $ $17.50 $22.750.00 $22,750.00 $22,750.00 $27,300.00 $27,200.00 $27,200.00 $17.00 $18,700.00 $20,350.00 $22,000.00 $22,000.00 $22,825.00 $23,650.00 $16.50 $19,800.00 $24,000.00 $24.000.00 $24,000.00 $25,800.00 $25,800.00 $ $ $15.50 $32.850.00 $36.000.00 $36,000.00 $37,350.00 $ $38,700.00 $38,700.CO $20.00 $40,000.00 $40,000.00 $40,000.00 $ $43,000.00 $43,000.00 $43,000.00 $177,850.00 $190,000.00 $197,600.00 $206,500.00 $211,825.00 $215,200.00 $ $ $ $ $ $5,602.62 $5,714.67 $5,828.97 $ $ $5,945.53 $6,064.46 $6,185.75 $ $183,452.62 $195,714.67 $203,428.97 $212,445.55 $217,889.46 $221,385.75 $ 199,172.69) 1$9,795.73) () {$10,171.45 $10.622.28 (10,894,47 () ($ ($11,069.291 $5,503.58) $5,871.44) $6,102.8756,373,371 66,536,681 $ ($ $5,641.571 1 $14,576.21) $15,557.17) $16.274.32) $16.995.64 ($17,431.26) I ( $ $ ($ 17,710.26 $168,776.41 $180,057.50 $187,154.65 $195,449.90 $200,458.30 $203,674.80 $ $ Tenant 10 Market Rate by Year 11 100 Tenant 12 101 Tenant 13 102 Tenant 14 103 Tenant D 15 200 Tenant 16 205 Tenant F 17 220 Tenant 18 Totals 19 20 other pass throughs 21 Potential Gross Income 22 23 Vacancy Los 24 Collection los 25 Total vacancy and Collection Loss 26 27 Effective Gross Income 28 29 30 Expenses 31 Capex 32 33 NOU 34 35 Year > Selling Price 36 less selline expenses 37 Cashlaw from Sale 38 39 40 Castlaws 41 42 Property value in Year 43 44 45 46 42 EGI Summary 1$ 70,000.00) $71.400.00) $10.500.00) $12,500,00) $17,976.41 Yer2 Year 4 Year 5 Year 1 1 $87,976.41 Rontroll + Ready EN + 100% AutoSave OF A A FIN 4500 Project Part 2 Student Worksheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 X G v A Wrap Text General v v FO) IN Analyze Data Paste Av = = = Insert Y Merge & Center v Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter V Find Select V B52 fix H M A B C D E F 34 Part 2 Assumptions 35 36 7 7 Expenses for 2015 are $7.00 ps and praw at 2% per year 37 38 8 Capes Requirements are $5.00 per square foot for each less that rerews, to be paid in the first year of the extended period 39 Lease Rollover by year as follows: 40 2015 1.800 41 2016 2,100 42 2017 2.800 43 2018 1.300 44 2019 0 45 2020 3,800 46 47 9 The Terminal Cap Rent the end of years is expete to be 10.50% 48 49 10 Selling costs for investment Buildings are stimated at 5% of the sale price 50 51 11 Ta determine purchase price at building in Year o, identify the cashflows far the year hold period and discount at 9% 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 G7 68 69 20 71 72 23 74 75 76 77 EGI Summary Rentroll + Ready EN + 100% AutoSave OF AA FIN 4500 Project Part 2 Student Worksheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Callbel (Body) v 11 X G v A Wrap Text General XE v FO) IN Analyze Data Paste BIU B A = = = Insert Merge & Center Delete Format Y Y - $ %? Conditional Format Cell Formatting as Table Styles v Sort & Filter Find & Select E15 fx A F F G H J . M N 0 P Q Current Commence Current Monthy Annual Rent Current Monthy Additional Rent Expire Current Monthy Be Rent Current Monthy Tot Rent Be Rent increases 01/01/10 12/31/15 01/01/11 12/31/16 01/01/12 12/31/17 07/01/11 06/30/16 01/01/10 12/31/15 07/01/10 05/30/15 $16.50 $17.00 $17.50 $17.00 $16.50 $16.50 $0.00 $24.950.00 $28,900.00 $22,750.00 $28.700.00 $19,800.00 $29,700.00 $0.00 $134,700,00 $1,237.50 $2,408.33 $1,895.8L $1,559.33 $1,650,00 $2,475.00 $0.00 $11,225.00 $59.13 $90.45 $52.51 $59.52 $78.8! $11827 $0.00 $457.73 $1.296.63 $2,498.78 $1,948.34 $1,616.80 $1,728,84 $2,593.27 $0.00 $11,682.73 Yrs 1 3 $15.00 Yrs 4-516.50 Yr 1-3 $15 50 Yrs 4-517.00 Hrs 13 $16.00 Yrs 4-5 17.50 Yrs 13 $15.50 Yrs 4-5 17.00 Yr 1-3 $15.00 Yrs 4-516.50 Yrs 13 $15.00 Yrs 4-516.50 1 i 4500 Finance Building 2 Rentroll Information Effective June 1, 2014 3 Suite Tenant SQFT Lewed S G200 Tenant A 900 900 7101 Tenant 1,700 1,700 3 102 Tenant 1,300 1,300 9 203 Tenant 1.100 1.100 10 200 Tenant 1,200 1,200 11 205 Tenant F 1.800 1,800 12 210 Vacant 2.000 D 13 Totals 10,000 8,000 14 80.00% 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 41 42 43 EGI Summary Rentroll + Ready + 100% AutoSave OF Av .. FIN 4500 Project Part 2 Student Worksheet View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Body) v 11 X [ G v A A Wrap Text General v FO) IN Analyze Data Paste B 1 7 Av = = = Y Merge & Center v $ %) Insert Delete Format Conditional Format Cell Formatting es Table Styles Sort & Filter Find & Select K34 fx A B C E F G H M N P Q R S T 4 5 6 2015 2016 2017 2011 2019 2020 7 SOFT Land Expires 4300 900 900 1,700 1,700 1,300 1,100 2,100 1,200 1,200 1,800 1,300 2,000 2,000 10,000 10,000 12/31/15 12/31/16 12/31/17 6/30/16 12/31/15 5/30/15 1/1/15 Rate Year 1 Yew 3 Year 4 Year 5 Year 6 Base Rent Schedulestarting January 1, 2015 $16.50 $14,850.00 $18,000.00 $18,000.00 $18,000.00 $19,350.00 $19,350.00 $ $ $17.00 $28,000.00 $28,000.00 $34 85000 $34,850,00 $34,850.00 $37,100.00 $ $17.50 $22.750.00 $22,750.00 $22,750.00 $27,300.00 $27,200.00 $27,200.00 $17.00 $18,700.00 $20,350.00 $22,000.00 $22,000.00 $22,825.00 $23,650.00 $16.50 $19,800.00 $24,000.00 $24.000.00 $24,000.00 $25,800.00 $25,800.00 $ $ $15.50 $32.850.00 $36.000.00 $36,000.00 $37,350.00 $ $38,700.00 $38,700.CO $20.00 $40,000.00 $40,000.00 $40,000.00 $ $43,000.00 $43,000.00 $43,000.00 $177,850.00 $190,000.00 $197,600.00 $206,500.00 $211,825.00 $215,200.00 $ $ $ $ $ $5,602.62 $5,714.67 $5,828.97 $ $ $5,945.53 $6,064.46 $6,185.75 $ $183,452.62 $195,714.67 $203,428.97 $212,445.55 $217,889.46 $221,385.75 $ 199,172.69) 1$9,795.73) () {$10,171.45 $10.622.28 (10,894,47 () ($ ($11,069.291 $5,503.58) $5,871.44) $6,102.8756,373,371 66,536,681 $ ($ $5,641.571 1 $14,576.21) $15,557.17) $16.274.32) $16.995.64 ($17,431.26) I ( $ $ ($ 17,710.26 $168,776.41 $180,057.50 $187,154.65 $195,449.90 $200,458.30 $203,674.80 $ $ Tenant 10 Market Rate by Year 11 100 Tenant 12 101 Tenant 13 102 Tenant 14 103 Tenant D 15 200 Tenant 16 205 Tenant F 17 220 Tenant 18 Totals 19 20 other pass throughs 21 Potential Gross Income 22 23 Vacancy Los 24 Collection los 25 Total vacancy and Collection Loss 26 27 Effective Gross Income 28 29 30 Expenses 31 Capex 32 33 NOU 34 35 Year > Selling Price 36 less selline expenses 37 Cashlaw from Sale 38 39 40 Castlaws 41 42 Property value in Year 43 44 45 46 42 EGI Summary 1$ 70,000.00) $71.400.00) $10.500.00) $12,500,00) $17,976.41 Yer2 Year 4 Year 5 Year 1 1 $87,976.41 Rontroll + Ready EN + 100% AutoSave OF A A FIN 4500 Project Part 2 Student Worksheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 X G v A Wrap Text General v v FO) IN Analyze Data Paste Av = = = Insert Y Merge & Center v Delete Format Conditional Format Cell Formatting as Table Styles Sort Filter V Find Select V B52 fix H M A B C D E F 34 Part 2 Assumptions 35 36 7 7 Expenses for 2015 are $7.00 ps and praw at 2% per year 37 38 8 Capes Requirements are $5.00 per square foot for each less that rerews, to be paid in the first year of the extended period 39 Lease Rollover by year as follows: 40 2015 1.800 41 2016 2,100 42 2017 2.800 43 2018 1.300 44 2019 0 45 2020 3,800 46 47 9 The Terminal Cap Rent the end of years is expete to be 10.50% 48 49 10 Selling costs for investment Buildings are stimated at 5% of the sale price 50 51 11 Ta determine purchase price at building in Year o, identify the cashflows far the year hold period and discount at 9% 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 G7 68 69 20 71 72 23 74 75 76 77 EGI Summary Rentroll + Ready EN + 100% AutoSave OF AA FIN 4500 Project Part 2 Student Worksheet Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Callbel (Body) v 11 X G v A Wrap Text General XE v FO) IN Analyze Data Paste BIU B A = = = Insert Merge & Center Delete Format Y Y - $ %? Conditional Format Cell Formatting as Table Styles v Sort & Filter Find & Select E15 fx A F F G H J . M N 0 P Q Current Commence Current Monthy Annual Rent Current Monthy Additional Rent Expire Current Monthy Be Rent Current Monthy Tot Rent Be Rent increases 01/01/10 12/31/15 01/01/11 12/31/16 01/01/12 12/31/17 07/01/11 06/30/16 01/01/10 12/31/15 07/01/10 05/30/15 $16.50 $17.00 $17.50 $17.00 $16.50 $16.50 $0.00 $24.950.00 $28,900.00 $22,750.00 $28.700.00 $19,800.00 $29,700.00 $0.00 $134,700,00 $1,237.50 $2,408.33 $1,895.8L $1,559.33 $1,650,00 $2,475.00 $0.00 $11,225.00 $59.13 $90.45 $52.51 $59.52 $78.8! $11827 $0.00 $457.73 $1.296.63 $2,498.78 $1,948.34 $1,616.80 $1,728,84 $2,593.27 $0.00 $11,682.73 Yrs 1 3 $15.00 Yrs 4-516.50 Yr 1-3 $15 50 Yrs 4-517.00 Hrs 13 $16.00 Yrs 4-5 17.50 Yrs 13 $15.50 Yrs 4-5 17.00 Yr 1-3 $15.00 Yrs 4-516.50 Yrs 13 $15.00 Yrs 4-516.50 1 i 4500 Finance Building 2 Rentroll Information Effective June 1, 2014 3 Suite Tenant SQFT Lewed S G200 Tenant A 900 900 7101 Tenant 1,700 1,700 3 102 Tenant 1,300 1,300 9 203 Tenant 1.100 1.100 10 200 Tenant 1,200 1,200 11 205 Tenant F 1.800 1,800 12 210 Vacant 2.000 D 13 Totals 10,000 8,000 14 80.00% 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 41 42 43 EGI Summary Rentroll + Ready + 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started