In cell E54, enter an HLookup formula based on the Year to determine the real estate tax rate using the table in the Taxcast sheet. (Do not enter the hardcoded tax rate.)

You multiply the real estate tax rate per square foot (found by the HLookup) to the residential square footage. The commercial units will pay their own share of taxes. Copy your formula to Years 2 to 10.

A B C D E F G H I J K L M N 1 2022 (Year 1) Rental Assumptions 2022 Operating Expense Assumptions Extra Credit # of Units Expense RSF per Unit 830 995 4 10 Taxes 2 3 3 4 5 6 7 7 8 8 Unit Type 1 Bedroom 2 Bedroom 3 Bedroom Small Commercial Large Commercial Total Rent/Month $1,600 $2,200 $2,800 $3,200 $4400 $14,200 Total RSF by Unit Type 3,320 9,950 8,850 3,600 2,100 27820 6 1,475 1,200 Insurance Repairs & Maintenance Utilities legal Legal 3 1 24 Mort Purchase Price Down Payment Rat Down Payment Loan Amount Annual Interest Rat Loan Term (years) Monthly Debt Payn Annual Debt Payme 2.100 2022 Expense Rate Per $30453 $1.3767 Residential RSF / year $8,000 $400 Residential Unit / year $1,440 $120 Residential Unit/month $5,760 $0.40 Per Common SF / month $4,000 $4,000 Year $3,200 $3,200 Year .. $15,600 $150 Day of Cleaning $35,520 5% Dollar of Base Rent/year $900 $900 Year $59,904 $12 Hour $45,200 Monthly Rent Every 2 Years $3,500 5% Total Lease Base Rent % $13,910 $0.50 RSF 9 10 12 11 Number of months/ year Residential Rent Increase Commercial Rent Increase Common Area Sq. Footage Vacancy & Collection Loss & 12 Accounting Janitorial Cleaning Management Fees Elevator Maint. Security Brokerage Fee - Residential Brokerage Fee - Commercial Capital Reserves 2% 10% 1200 4.5% Annually Every 5 Years SF Annually 13 14 15 16 Income Unite Unit Type 2022 2022 2024 2025 2026 2027 2028 2029 2030 2031 21,622 19,976 27 467 29,731 21,198 29,148 29,148 49.140 37,097 *** 21,198 29.148 22,946 31 550 31 550 23 40,155 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 23 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Unit 1A 1 Bedroom Unit 1 2 Bedroom Unit 1C 2 Bedroom Unit 1D 3 Bedroom Unit 2A 1 Bedroom Unit 2B 2 Bedroom Unit 2C 2 Bedroom Unit 2D 3 Bedroom . Unit 3A 1 Bedroom . Unit 3B 2 Bedroom Unit 3C 2 Bedroom Unit 3D 3 Bedroom Unit 4A 1 Bedroom Unit 4B 2 Bedroom Unit 4C 2 Bedroom Unit 4D 3 Bedroom . Unit SA 2 Bedroom Unit 5B 2 Bedroom Unit 5C 3 Bedroom Unit 5D 3 Bedroom . Unit G1 Large Commercial Unit G2 Small Commercial Unit G3 Small Commercial Unit G4 Small Commercial Total Base Rent 19,200 26400 26,400 33,600 19,200 26,400 26,400 33,600 . 19,200 26,400 26,400 33,600 19,200 26,400 26,400 33,600 26,400 26,400 33,600 33,600 52,800 38,400 38,400 38,400 $710,400 19 584 26,928 26,928 34,272 19,584 26,928 26,928 22 34,272 . 19,584 26,928 26,928 34,272 19,584 26,928 26,928 34,272 26,928 26,928 34,272 34,272 52,800 38,400 38400 38,400 $721,248 27,467 34,957 19,976 27,467 27,467 34,957 19,976 27,467 27,467 34,957 19,976 27.467 27,467 34,957 27.467 27,467 34,957 34,957 52,800 38,400 38,400 38 400 $732,313 20,375 28,016 28,016 35,657 20,375 28,016 28,016 35,657 20,375 28,016 28,016 35,657 20,375 28,016 28,016 35,657 . 28,016 28,016 35,657 35,657 52,800 38,400 38400 38400 $743,599 20,783 28,576 28,576 36,370 20,783 see 28,576 28,576 36,370 20,783 28,576 28,576 36,370 20,783 28,576 28,576 36,370 28,576 28,576 36,370 36,370 52800 38,400 38 400 38,400 $755,111 29,148 37,097 21,198 29,148 29,148 37,097 21,198 29,148 29,148 37,097 29,148 29,148 37,097 37,097 55,440 40,320 40,320 40,320 29,731 37,839 21,622 ce 29,731 29,731 37839 21,622 29,731 29,731 37839 21,622 29,731 29,731 37839 29,731 29,731 37,839 37,839 55,440 40,320 40,320 40,320 $787,230 22,055 30,325 30,325 ser 38,596 22,055 SAN 30,325 30,325 wan 38,596 22,055 30,325 30,325 38,596 22,055 30,325 30,325 38,596 30,325 30,325 38,596 38,596 55,440 40,320 40,320 40,320 $799,447 22.496 30,932 30,932 23 39.368 22496 ware 30,932 30,932 39,368 22,496 30,932 30,932 39,368 22496 30,932 30,932 39,368 30,932 30,932 39,368 39,368 55,440 . 40,320 40,320 40,320 $811,908 22,946 31,550 werd 31,550 . 40,155 22,946 31,550 31,550 40,155 22,946 31,550 31,550 40,155 31,550 31,550 40,155 40,155 ... 55,440 40,320 40,320 40,320 $824,618 $775,253 2% Percentage Rent Potential Gross Rent 10400 $720,800 10600 $731,848 11000 $743,313 10900 $754,499 10960 $766,071 11600 $786,853 11900 $799, 130 12000 $811,447 12000 $823,908 12000 $836,618 Less: Vacancy & Collection Loss Effective Gross Rent $32,436 $688,364 $32,933 $698,915 $37,076 $33449 $709,864 $33,952 $720,547 $34,473 $731,598 $35408 $751,445 $35,961 $763,170 $36,515 $774,932 $37,648 $798,970 $786,832 52 Expenses 2022 2022 2024 2025 2026 2027 2028 2029 2030 2031 53 54 55 56 57 Use Hookup 3% Taxes Insurance 3% Repairs & Maintenance Utilities $8,000 $1440 $5,760 $8,240 $1483 $5,933 $8,487 $1,528 $6,111 $8,742 $1,574 $6,294 $9,004 $1,621 $6483 $9,274 $1,669 $6,677 $9,552 $1,719 $6,878 $9.839 $1,771 $7,084 $10,134 $1,824 $7,297 $10,438 $1879 $7,515 D F F H K I M N R TAXCAST 2 Income and Property Tax Schedule 3 2022-2034 4 subject to change 5 6 2024 7 9 Income Tax Rate (per $100,000 carnes Property Tax Rate Iper Sq. Ft. 2022 7,844 S 1.3767 2023 7,962 S 1.3836 8,081 $ 1.3905 2025 2,202 $ 1.3975 2026 8,325 $ 1.4044 2027 8,450 S 1.4115 2028 10,050 $ 1.7500 2029 10,251 $ 1.7575 2030 10,459 $ 1.7852 2031 10,665 $ 1.8030 2032 10,878 $ 1.8211 2033 11,096 $ 1.8393 2034 11,318 1.8577 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 A B C D E F G H I J K L M N 1 2022 (Year 1) Rental Assumptions 2022 Operating Expense Assumptions Extra Credit # of Units Expense RSF per Unit 830 995 4 10 Taxes 2 3 3 4 5 6 7 7 8 8 Unit Type 1 Bedroom 2 Bedroom 3 Bedroom Small Commercial Large Commercial Total Rent/Month $1,600 $2,200 $2,800 $3,200 $4400 $14,200 Total RSF by Unit Type 3,320 9,950 8,850 3,600 2,100 27820 6 1,475 1,200 Insurance Repairs & Maintenance Utilities legal Legal 3 1 24 Mort Purchase Price Down Payment Rat Down Payment Loan Amount Annual Interest Rat Loan Term (years) Monthly Debt Payn Annual Debt Payme 2.100 2022 Expense Rate Per $30453 $1.3767 Residential RSF / year $8,000 $400 Residential Unit / year $1,440 $120 Residential Unit/month $5,760 $0.40 Per Common SF / month $4,000 $4,000 Year $3,200 $3,200 Year .. $15,600 $150 Day of Cleaning $35,520 5% Dollar of Base Rent/year $900 $900 Year $59,904 $12 Hour $45,200 Monthly Rent Every 2 Years $3,500 5% Total Lease Base Rent % $13,910 $0.50 RSF 9 10 12 11 Number of months/ year Residential Rent Increase Commercial Rent Increase Common Area Sq. Footage Vacancy & Collection Loss & 12 Accounting Janitorial Cleaning Management Fees Elevator Maint. Security Brokerage Fee - Residential Brokerage Fee - Commercial Capital Reserves 2% 10% 1200 4.5% Annually Every 5 Years SF Annually 13 14 15 16 Income Unite Unit Type 2022 2022 2024 2025 2026 2027 2028 2029 2030 2031 21,622 19,976 27 467 29,731 21,198 29,148 29,148 49.140 37,097 *** 21,198 29.148 22,946 31 550 31 550 23 40,155 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 23 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Unit 1A 1 Bedroom Unit 1 2 Bedroom Unit 1C 2 Bedroom Unit 1D 3 Bedroom Unit 2A 1 Bedroom Unit 2B 2 Bedroom Unit 2C 2 Bedroom Unit 2D 3 Bedroom . Unit 3A 1 Bedroom . Unit 3B 2 Bedroom Unit 3C 2 Bedroom Unit 3D 3 Bedroom Unit 4A 1 Bedroom Unit 4B 2 Bedroom Unit 4C 2 Bedroom Unit 4D 3 Bedroom . Unit SA 2 Bedroom Unit 5B 2 Bedroom Unit 5C 3 Bedroom Unit 5D 3 Bedroom . Unit G1 Large Commercial Unit G2 Small Commercial Unit G3 Small Commercial Unit G4 Small Commercial Total Base Rent 19,200 26400 26,400 33,600 19,200 26,400 26,400 33,600 . 19,200 26,400 26,400 33,600 19,200 26,400 26,400 33,600 26,400 26,400 33,600 33,600 52,800 38,400 38,400 38,400 $710,400 19 584 26,928 26,928 34,272 19,584 26,928 26,928 22 34,272 . 19,584 26,928 26,928 34,272 19,584 26,928 26,928 34,272 26,928 26,928 34,272 34,272 52,800 38,400 38400 38,400 $721,248 27,467 34,957 19,976 27,467 27,467 34,957 19,976 27,467 27,467 34,957 19,976 27.467 27,467 34,957 27.467 27,467 34,957 34,957 52,800 38,400 38,400 38 400 $732,313 20,375 28,016 28,016 35,657 20,375 28,016 28,016 35,657 20,375 28,016 28,016 35,657 20,375 28,016 28,016 35,657 . 28,016 28,016 35,657 35,657 52,800 38,400 38400 38400 $743,599 20,783 28,576 28,576 36,370 20,783 see 28,576 28,576 36,370 20,783 28,576 28,576 36,370 20,783 28,576 28,576 36,370 28,576 28,576 36,370 36,370 52800 38,400 38 400 38,400 $755,111 29,148 37,097 21,198 29,148 29,148 37,097 21,198 29,148 29,148 37,097 29,148 29,148 37,097 37,097 55,440 40,320 40,320 40,320 29,731 37,839 21,622 ce 29,731 29,731 37839 21,622 29,731 29,731 37839 21,622 29,731 29,731 37839 29,731 29,731 37,839 37,839 55,440 40,320 40,320 40,320 $787,230 22,055 30,325 30,325 ser 38,596 22,055 SAN 30,325 30,325 wan 38,596 22,055 30,325 30,325 38,596 22,055 30,325 30,325 38,596 30,325 30,325 38,596 38,596 55,440 40,320 40,320 40,320 $799,447 22.496 30,932 30,932 23 39.368 22496 ware 30,932 30,932 39,368 22,496 30,932 30,932 39,368 22496 30,932 30,932 39,368 30,932 30,932 39,368 39,368 55,440 . 40,320 40,320 40,320 $811,908 22,946 31,550 werd 31,550 . 40,155 22,946 31,550 31,550 40,155 22,946 31,550 31,550 40,155 31,550 31,550 40,155 40,155 ... 55,440 40,320 40,320 40,320 $824,618 $775,253 2% Percentage Rent Potential Gross Rent 10400 $720,800 10600 $731,848 11000 $743,313 10900 $754,499 10960 $766,071 11600 $786,853 11900 $799, 130 12000 $811,447 12000 $823,908 12000 $836,618 Less: Vacancy & Collection Loss Effective Gross Rent $32,436 $688,364 $32,933 $698,915 $37,076 $33449 $709,864 $33,952 $720,547 $34,473 $731,598 $35408 $751,445 $35,961 $763,170 $36,515 $774,932 $37,648 $798,970 $786,832 52 Expenses 2022 2022 2024 2025 2026 2027 2028 2029 2030 2031 53 54 55 56 57 Use Hookup 3% Taxes Insurance 3% Repairs & Maintenance Utilities $8,000 $1440 $5,760 $8,240 $1483 $5,933 $8,487 $1,528 $6,111 $8,742 $1,574 $6,294 $9,004 $1,621 $6483 $9,274 $1,669 $6,677 $9,552 $1,719 $6,878 $9.839 $1,771 $7,084 $10,134 $1,824 $7,297 $10,438 $1879 $7,515 D F F H K I M N R TAXCAST 2 Income and Property Tax Schedule 3 2022-2034 4 subject to change 5 6 2024 7 9 Income Tax Rate (per $100,000 carnes Property Tax Rate Iper Sq. Ft. 2022 7,844 S 1.3767 2023 7,962 S 1.3836 8,081 $ 1.3905 2025 2,202 $ 1.3975 2026 8,325 $ 1.4044 2027 8,450 S 1.4115 2028 10,050 $ 1.7500 2029 10,251 $ 1.7575 2030 10,459 $ 1.7852 2031 10,665 $ 1.8030 2032 10,878 $ 1.8211 2033 11,096 $ 1.8393 2034 11,318 1.8577 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