Please include all formulas and formatting used in instructions or an excel file to compare.

Step Instructions Points Possible Open exploring_e07_grader_h1_Apartment.xlsx and save it as exploring_e07_grader_h1_Apartment_LastFirst. 2 In cell G8 in the Summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell F8). Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensure that the function you use displays that result 5 In cell H8, insert a nested logical function to display the required pet deposit for each unit. If the unit has two or more bedrooms (C8) AND was remodeled less than 10 years ago (cell H3), the deposit is $275 (cell H4); if not, the deposit is $200 (cell H5). Use relative and mixed references correctly. The pet deposit for Unit 101 is $200. 5 In cell 18, enter a nested logical function to display Need to Remodel if the apartment is unoccupied (No) AND was last remodeled more than 10 years ago (H3). For all other apartments, display No Change. Although Unit 101 was last remodeled over 10 years ago, the recommendation is No Change because the unit is occupied. 5 Copy the functions in the range H8:18 to the range H9:157. In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00. In the Database sheet, enter conditions in the criteria range for unoccupied two- and three- bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4. Apply an advanced filter based on the criteria range (A2:H4). Filter the existing database (range A15:H65) in place. Nine apartments meet the advanced filter conditions. In cell C8, use the DCOUNTA database function to calculate the number of apartments that need to be remodeled based on the advanced filter you created. 18 In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format. 19 In cell 14 insert a financial function to calculate the present value of the total monthly rent you will collect for the 8 units for 30 years. Use the number of periods and monthly rate in the Summary Calculations section and the cell references in the What If section. The result should be a positive value. 20 In the Loan sheet, set 0.5" left and right margins and repeat row 10 on all pages. 21 Save and close the workbook, and submit the file as directed. Total Points 100 Search Engine Enter Unit # to see rent Rental Price 101 Constants for Formulas Comparison Date 1/1/2018 No. of Years Since Remodel 10 Pet Deposit 2 bedroom newer $275 Pet Deposit other $200 Years Since Remodel Pet Deposit Recommendation # Bed 1 Occupied Yes Yes No $ mt Unit # 101 102 103 104 105 106 107 108 109 110 201 202 203 204 205 206 207 nomst nom Apartment Complex Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Rental Price $ 950 $ 950 1,100 1,100 1,500 $ 1,500 1,100 1,100 1,500 1,500 875 875 995 995 1,050 1,050 995 995 1,050 1,050 875 875 $ 900 900 Yes No Yes No Yes No Yes Yes Yes Yes No Yes No Yes Yes No Yes No No No Yes Last Remodel 4/1/2004 3/1/2013 11/15/2005 10/1/2015 10/1/2015 6/15/2004 11/1/2015 8/15/2009 8/15/2009 10/4/2006 4/13/2016 3/1/2013 4/1/2004 4/1/2010 8/15/2011 7/1/2005 8/1/2015 8/1/2015 8/1/2015 11/4/2006 4/15/2008 5/1/2015 5/5/2010 5/5/2010 208 209 210 301 302 303 304 1 No No 1 1 1 1 $ $ $ $ mmmst in m 301 302 303 304 305 306 307 308 No Yes No Yes Yes No No No Yes No Yes 401 402 403 1 2 3 1 2 $ $ $ $ $ No 404 405 406 407 408 501 502 503 504 505 Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living 2 2 1 $ $ $ $ $ 875 875 900 900 1,200 1,200 1,200 1,200 875 950 1,200 875 950 1,200 975 975 875 875 875 875 1,100 1,100 1,100 1,500 1,500 1,200 1,200 2,000 2,000 2,000 Yes Yes Yes lm stim mlm st in 4/15/2008 5/1/2015 5/5/2010 5/5/2010 10/4/2006 6/15/2018 6/30/2008 9/30/2007 7/1/2005 8/1/2015 5/5/2010 10/4/2006 6/15/2018 4/1/2004 3/1/2013 11/15/2005 10/1/2015 8/1/2015 8/1/2015 7/2/2003 7/2/2003 10/10/2010 10/10/2010 8/15/2004 11/1/2000 8/15/2004 12/1/2003 11/30/2000 3/30/2002 3/30/2002 NO 1 1 506 No Yes No Yes No Yes Yes No Yes No 1 507 601 602 603 604 605 606 607 $ 3 $ $ Yes $ No Criteria Range Years Since Remodel Unit # Apartment Complex # Bed Rental Price Occupied Last Remodel Recommendation Database Statistics No. of Apts. to Remodel Value of Lost Rent Year of Oldest Remodel List of Rental Property # Bed 1 VW 8000 on w Unit # 101 102 103 104 105 106 107 108 109 110 201 202 203 Summary Apartment Complex Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Database Loan NA w WNNW WNN Rental Price Occupied 950 Yes 950 Yes 1,100 No 1,100 Yes 1,500 No 1,500 Yes 1,100 No 1,100 Yes 1,500 1,500 875 Yes 875 Yes 995 Yes Last Remodel 4/1/2004 3/1/2013 11/15/2005 10/1/2015 10/1/2015 6/15/2004 11/1/2015 8/15/2009 8/15/2009 10/4/2006 4/13/2016 3/1/2013 4/1/2004 Years Since Remodel Recommendation 13.75 No Change 4.83 No Change 12.13 Need to Remodel 2.25 No Change 2.25 No Change 13.54 No Change 2.17 No Change 8.38 No Change 8.38 No Change 11.24 No Change 1.72 No Change 4.83 No Change 13.75 No Change No Yes 2 + B E 203 204 205 206 Yes No Yes No 207 Yes Yes No 208 209 210 301 Yes 302 303 304 305 306 307 Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Oak Tree Living Database Loan No No No Yes No Yes Yes No No 995 995 1,050 1,050 995 995 1,050 1,050 875 875 900 900 1,200 1,200 1,200 1,200 875 950 1,200 875 950 1,200 975 975 875 875 875 875 1,100 1,100 1,100 1,500 308 401 402 403 404 405 406 4/1/2004 4/1/2010 8/15/2011 7/1/2005 8/1/2015 8/1/2015 8/1/2015 11/4/2006 4/15/2008 5/1/2015 5/5/2010 5/5/2010 10/4/2006 6/15/2018 6/30/2008 9/30/2007 7/1/2005 8/1/2015 5/5/2010 10/4/2006 6/15/2018 4/1/2004 3/1/2013 11/15/2005 10/1/2015 8/1/2015 8/1/2015 7/2/2003 7/2/2003 10/10/2010 10/10/2010 8/15/2004 H 13.75 No Change 7.75 No Change 6.38 No Change 12.50 Need to Remodel 2.42 No Change 2.42 No Change 2.42 No Change 11.16 No Change 9.71 No Change 2.67 No Change 7.66 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 9.50 No Change 10.25 Need to Remodel 12.50 Need to Remodel 2.42 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 13.75 Need to Remodel 4.83 No Change 12.13 No Change 2.25 No Change 2.42 No Change 2.42 No Change 14.50 No Change 14.50 Need to Remodel 7.23 No Change 7.23 No Change 13.38 No Change No 407 408 501 Yes No Yes No Yes Yes Yes No No Yes No Yes No Yes 502 54 503 504 505 506 507 601 Summary 59 Dead B No No 302 303 304 305 306 Yes No Yes Yes No No 307 308 401 402 No Yes 403 404 405 D 875 900 900 1,200 1,200 1,200 1,200 875 950 1,200 875 950 1,200 975 975 875 875 875 875 1,100 1,100 1,100 406 407 Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living No Yes No Yes Yes F 5/1/2015 5/5/2010 5/5/2010 10/4/2006 6/15/2018 6/30/2008 9/30/2007 7/1/2005 8/1/2015 5/5/2010 10/4/2006 6/15/2018 4/1/2004 3/1/2013 11/15/2005 10/1/2015 8/1/2015 8/1/2015 7/2/2003 7/2/2003 10/10/2010 10/10/2010 8/15/2004 11/1/2000 8/15/2004 12/1/2003 11/30/2000 3/30/2002 3/30/2002 wwwNNNNNNNNNNNNN G H 2.67 No Change 7.66 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 9.50 No Change 10.25 Need to Remodel 12.50 Need to Remodel 2.42 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 13.75 Need to Remodel 4.83 No Change 12.13 No Change 2.25 No Change 2.42 No Change 2.42 No Change 14.50 No Change 14.50 Need to Remodel 7.23 No Change 7.23 No Change 13.38 No Change 17.17 No Change 13.38 Need to Remodel 14.08 No Change 17.09 Need to Remodel 15.75 No Change 15.75 Need to Remodel 408 501 502 503 Yes No No 504 505 506 507 601 602 603 604 Yes No Yes No Yes Yes 1,500 1,500 1,200 1,200 2,000 2,000 2,000 605 No Yes No Yes No 606 607 Summary Database Loan . Ready D 1 Input Area 2 Complex Cost 3 Down Payment 4 # of Pmts per Year 5 Years 6 APR 7 1st Payment Date $2,000 $ 1,850,000.00 $ 750,000.00 12 G What If Collect Monthly Rent # of Units in Complex PV of Future Rent Summary Calculations Loan Amount No. Periods Monthly Rate Monthly Payment Total Interest Paid 30 4.75% 3/1/2018 Payment Date Principal Payment Ending Balance Payment # Beginning Balance Interest Paid 28 30 Summary Database Loan Ready 7 1st Payment Date 3/1/2018 Payment Date Principal Payment Ending Balance Payment # Beginning Balance Interest Paid 12 13 14 15 16 19 37 Summary Database Loan Ready Step Instructions Points Possible Open exploring_e07_grader_h1_Apartment.xlsx and save it as exploring_e07_grader_h1_Apartment_LastFirst. 2 In cell G8 in the Summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell F8). Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensure that the function you use displays that result 5 In cell H8, insert a nested logical function to display the required pet deposit for each unit. If the unit has two or more bedrooms (C8) AND was remodeled less than 10 years ago (cell H3), the deposit is $275 (cell H4); if not, the deposit is $200 (cell H5). Use relative and mixed references correctly. The pet deposit for Unit 101 is $200. 5 In cell 18, enter a nested logical function to display Need to Remodel if the apartment is unoccupied (No) AND was last remodeled more than 10 years ago (H3). For all other apartments, display No Change. Although Unit 101 was last remodeled over 10 years ago, the recommendation is No Change because the unit is occupied. 5 Copy the functions in the range H8:18 to the range H9:157. In cell B3 insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apartment number referenced in cell B2. With 101 entered in cell B2, the lookup function displays $950.00. In the Database sheet, enter conditions in the criteria range for unoccupied two- and three- bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4. Apply an advanced filter based on the criteria range (A2:H4). Filter the existing database (range A15:H65) in place. Nine apartments meet the advanced filter conditions. In cell C8, use the DCOUNTA database function to calculate the number of apartments that need to be remodeled based on the advanced filter you created. 18 In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format. 19 In cell 14 insert a financial function to calculate the present value of the total monthly rent you will collect for the 8 units for 30 years. Use the number of periods and monthly rate in the Summary Calculations section and the cell references in the What If section. The result should be a positive value. 20 In the Loan sheet, set 0.5" left and right margins and repeat row 10 on all pages. 21 Save and close the workbook, and submit the file as directed. Total Points 100 Search Engine Enter Unit # to see rent Rental Price 101 Constants for Formulas Comparison Date 1/1/2018 No. of Years Since Remodel 10 Pet Deposit 2 bedroom newer $275 Pet Deposit other $200 Years Since Remodel Pet Deposit Recommendation # Bed 1 Occupied Yes Yes No $ mt Unit # 101 102 103 104 105 106 107 108 109 110 201 202 203 204 205 206 207 nomst nom Apartment Complex Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Rental Price $ 950 $ 950 1,100 1,100 1,500 $ 1,500 1,100 1,100 1,500 1,500 875 875 995 995 1,050 1,050 995 995 1,050 1,050 875 875 $ 900 900 Yes No Yes No Yes No Yes Yes Yes Yes No Yes No Yes Yes No Yes No No No Yes Last Remodel 4/1/2004 3/1/2013 11/15/2005 10/1/2015 10/1/2015 6/15/2004 11/1/2015 8/15/2009 8/15/2009 10/4/2006 4/13/2016 3/1/2013 4/1/2004 4/1/2010 8/15/2011 7/1/2005 8/1/2015 8/1/2015 8/1/2015 11/4/2006 4/15/2008 5/1/2015 5/5/2010 5/5/2010 208 209 210 301 302 303 304 1 No No 1 1 1 1 $ $ $ $ mmmst in m 301 302 303 304 305 306 307 308 No Yes No Yes Yes No No No Yes No Yes 401 402 403 1 2 3 1 2 $ $ $ $ $ No 404 405 406 407 408 501 502 503 504 505 Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living 2 2 1 $ $ $ $ $ 875 875 900 900 1,200 1,200 1,200 1,200 875 950 1,200 875 950 1,200 975 975 875 875 875 875 1,100 1,100 1,100 1,500 1,500 1,200 1,200 2,000 2,000 2,000 Yes Yes Yes lm stim mlm st in 4/15/2008 5/1/2015 5/5/2010 5/5/2010 10/4/2006 6/15/2018 6/30/2008 9/30/2007 7/1/2005 8/1/2015 5/5/2010 10/4/2006 6/15/2018 4/1/2004 3/1/2013 11/15/2005 10/1/2015 8/1/2015 8/1/2015 7/2/2003 7/2/2003 10/10/2010 10/10/2010 8/15/2004 11/1/2000 8/15/2004 12/1/2003 11/30/2000 3/30/2002 3/30/2002 NO 1 1 506 No Yes No Yes No Yes Yes No Yes No 1 507 601 602 603 604 605 606 607 $ 3 $ $ Yes $ No Criteria Range Years Since Remodel Unit # Apartment Complex # Bed Rental Price Occupied Last Remodel Recommendation Database Statistics No. of Apts. to Remodel Value of Lost Rent Year of Oldest Remodel List of Rental Property # Bed 1 VW 8000 on w Unit # 101 102 103 104 105 106 107 108 109 110 201 202 203 Summary Apartment Complex Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Database Loan NA w WNNW WNN Rental Price Occupied 950 Yes 950 Yes 1,100 No 1,100 Yes 1,500 No 1,500 Yes 1,100 No 1,100 Yes 1,500 1,500 875 Yes 875 Yes 995 Yes Last Remodel 4/1/2004 3/1/2013 11/15/2005 10/1/2015 10/1/2015 6/15/2004 11/1/2015 8/15/2009 8/15/2009 10/4/2006 4/13/2016 3/1/2013 4/1/2004 Years Since Remodel Recommendation 13.75 No Change 4.83 No Change 12.13 Need to Remodel 2.25 No Change 2.25 No Change 13.54 No Change 2.17 No Change 8.38 No Change 8.38 No Change 11.24 No Change 1.72 No Change 4.83 No Change 13.75 No Change No Yes 2 + B E 203 204 205 206 Yes No Yes No 207 Yes Yes No 208 209 210 301 Yes 302 303 304 305 306 307 Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Rolling Meadows Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Oak Tree Living Database Loan No No No Yes No Yes Yes No No 995 995 1,050 1,050 995 995 1,050 1,050 875 875 900 900 1,200 1,200 1,200 1,200 875 950 1,200 875 950 1,200 975 975 875 875 875 875 1,100 1,100 1,100 1,500 308 401 402 403 404 405 406 4/1/2004 4/1/2010 8/15/2011 7/1/2005 8/1/2015 8/1/2015 8/1/2015 11/4/2006 4/15/2008 5/1/2015 5/5/2010 5/5/2010 10/4/2006 6/15/2018 6/30/2008 9/30/2007 7/1/2005 8/1/2015 5/5/2010 10/4/2006 6/15/2018 4/1/2004 3/1/2013 11/15/2005 10/1/2015 8/1/2015 8/1/2015 7/2/2003 7/2/2003 10/10/2010 10/10/2010 8/15/2004 H 13.75 No Change 7.75 No Change 6.38 No Change 12.50 Need to Remodel 2.42 No Change 2.42 No Change 2.42 No Change 11.16 No Change 9.71 No Change 2.67 No Change 7.66 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 9.50 No Change 10.25 Need to Remodel 12.50 Need to Remodel 2.42 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 13.75 Need to Remodel 4.83 No Change 12.13 No Change 2.25 No Change 2.42 No Change 2.42 No Change 14.50 No Change 14.50 Need to Remodel 7.23 No Change 7.23 No Change 13.38 No Change No 407 408 501 Yes No Yes No Yes Yes Yes No No Yes No Yes No Yes 502 54 503 504 505 506 507 601 Summary 59 Dead B No No 302 303 304 305 306 Yes No Yes Yes No No 307 308 401 402 No Yes 403 404 405 D 875 900 900 1,200 1,200 1,200 1,200 875 950 1,200 875 950 1,200 975 975 875 875 875 875 1,100 1,100 1,100 406 407 Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Lakeview Apartments Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Mountaintop View Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Sunset Valley Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living Oak Tree Living No Yes No Yes Yes F 5/1/2015 5/5/2010 5/5/2010 10/4/2006 6/15/2018 6/30/2008 9/30/2007 7/1/2005 8/1/2015 5/5/2010 10/4/2006 6/15/2018 4/1/2004 3/1/2013 11/15/2005 10/1/2015 8/1/2015 8/1/2015 7/2/2003 7/2/2003 10/10/2010 10/10/2010 8/15/2004 11/1/2000 8/15/2004 12/1/2003 11/30/2000 3/30/2002 3/30/2002 wwwNNNNNNNNNNNNN G H 2.67 No Change 7.66 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 9.50 No Change 10.25 Need to Remodel 12.50 Need to Remodel 2.42 No Change 7.66 No Change 11.24 Need to Remodel 0.46 No Change 13.75 Need to Remodel 4.83 No Change 12.13 No Change 2.25 No Change 2.42 No Change 2.42 No Change 14.50 No Change 14.50 Need to Remodel 7.23 No Change 7.23 No Change 13.38 No Change 17.17 No Change 13.38 Need to Remodel 14.08 No Change 17.09 Need to Remodel 15.75 No Change 15.75 Need to Remodel 408 501 502 503 Yes No No 504 505 506 507 601 602 603 604 Yes No Yes No Yes Yes 1,500 1,500 1,200 1,200 2,000 2,000 2,000 605 No Yes No Yes No 606 607 Summary Database Loan . Ready D 1 Input Area 2 Complex Cost 3 Down Payment 4 # of Pmts per Year 5 Years 6 APR 7 1st Payment Date $2,000 $ 1,850,000.00 $ 750,000.00 12 G What If Collect Monthly Rent # of Units in Complex PV of Future Rent Summary Calculations Loan Amount No. Periods Monthly Rate Monthly Payment Total Interest Paid 30 4.75% 3/1/2018 Payment Date Principal Payment Ending Balance Payment # Beginning Balance Interest Paid 28 30 Summary Database Loan Ready 7 1st Payment Date 3/1/2018 Payment Date Principal Payment Ending Balance Payment # Beginning Balance Interest Paid 12 13 14 15 16 19 37 Summary Database Loan Ready