fill out the yellow spots

Homework - fill in all yellow cells Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates M11 fx A B CASE STUDY: ABC APARTMENTS Property Type Number of Units Buyer Purchase Price Purchase Date Buyer Mortgage Amount Mortgage Term Amortization (yeso) Interest Only Period Interest Rate (fixed) Seller Provided Operating Expenses Buyer Assumptions - 2016 and beyond 2016 Average Rent per month Annual Rent Increase (for 2017 and beyond) Annual Operating Expenses Increase Vacancy \& Collection Loss Sales Date Cap Rate at Sales Cost of Sales Discount Rate - for Net Present Value (NPV) Multifamily 100 $15,000,000 75% of the purchase price 20 years no 20 year $700,000 Conditional Format Formatting as Table Styles Format v Sort \& Filter Select Analyze Data Sensitivity Yes No Check for Updates Homework - fill in all yellow cells Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates M11 fx A B CASE STUDY: ABC APARTMENTS Property Type Number of Units Buyer Purchase Price Purchase Date Buyer Mortgage Amount Mortgage Term Amortization (yeso) Interest Only Period Interest Rate (fixed) Seller Provided Operating Expenses Buyer Assumptions - 2016 and beyond 2016 Average Rent per month Annual Rent Increase (for 2017 and beyond) Annual Operating Expenses Increase Vacancy \& Collection Loss Sales Date Cap Rate at Sales Cost of Sales Discount Rate - for Net Present Value (NPV) Multifamily 100 $15,000,000 75% of the purchase price 20 years no 20 year $700,000 Conditional Format Formatting as Table Styles Format v Sort \& Filter Select Analyze Data Sensitivity Yes No Check for Updates