find the XNPV. (only asking dor XNPV because it is one wuestion)
Search ..1 LTE 11:52 AM Done Attachment ..Il T-Mobile LTE 11:54 AM Done Attachment Property Characteristics Purchase price Square feet Rent Vacancy Rate Rent Increase 2 units Medium condition (some deferred maintenance). $800,000 2000 2,900 per unit per month 10% 4% annual Expenses Tax Innrane Trash Removal Landscaping Pest Control RenairyReserve HCIDLA Fee Utilities Misc. ? 1.25% of purchase price annual) ? $0.50 per square foot (annual) $1,000.00 (annual) $1,000.00 (annual) $600.00 (annual) $6,000.00 (annual) in addition to the S60K above S250.00 (annual) $3,600.00 (annual) $1,200.00 (annual) Purchase Date 4/30/20 Future Sale Price $1.200,000 Cost of Sale 3% Date of sale 4.5 years (42 months) from now 12.00% Discount Rate XNPV ? XIRR? Done Attaci Property Characteristics Purchase price Square feet Rent Vacancy Rate Rent Increase 2 units Medium condition (some deferred maintenance). $800,000 2000 2.900 per unit per month 10% 4% annual Expenses Insurane Trash Removal Landscaping Pest Control Repairs/Reserve HCIDLA Fee Utilities Misc. ? 1.25% of purchase price (annual) ? S0.50 per square foot (annual) $1,000.00 (annual) $1,000.00 (annual) $600.00 (annual) $6,000.00 (annual) in addition to the S60K above $250.00 (annual) $3,600.00 (annual) $1,200.00 (annual) Purchase Date 4/30/20 Future Sale Price $1,200,000 Cost of Sale Date of sale 4.5 years (42 months) from now 12.00 Discount Rate XNPV ? XIRR? 4 Gmail ll LTE 12:04 PM This will result in a $60.00 Expert Q&A10.000 each mon t i Purchase date 4/30/20 Dates of CFS Rent Increase % Gross Income Vacancy Effective Income Expenses Tax Insuranc Trash Removal Landscaping Pest Control Repairs/Reserve HCIDLA Fee Utilities Misc. Net Operating Income (NOI) Purchase Price Selling Price Cost of Sale Net of all Cash Flows Net Present Value Internal Rate of Return Done Attaci Property Characteristics Purchase price Square feet Rent Vacancy Rate Rent Increase 2 units Medium condition (some deferred maintenance). $800,000 2000 2.900 per unit per month 10% 4% annual Expenses Insurane Trash Removal Landscaping Pest Control Repairs/Reserve HCIDLA Fee Utilities Misc. ? 1.25% of purchase price (annual) ? S0.50 per square foot (annual) $1,000.00 (annual) $1,000.00 (annual) $600.00 (annual) $6,000.00 (annual) in addition to the S60K above $250.00 (annual) $3,600.00 (annual) $1,200.00 (annual) Purchase Date 4/30/20 Future Sale Price $1,200,000 Cost of Sale Date of sale 4.5 years (42 months) from now 12.00 Discount Rate XNPV ? XIRR? Search ..1 LTE 11:52 AM Done Attachment ..Il T-Mobile LTE 11:54 AM Done Attachment Property Characteristics Purchase price Square feet Rent Vacancy Rate Rent Increase 2 units Medium condition (some deferred maintenance). $800,000 2000 2,900 per unit per month 10% 4% annual Expenses Tax Innrane Trash Removal Landscaping Pest Control RenairyReserve HCIDLA Fee Utilities Misc. ? 1.25% of purchase price annual) ? $0.50 per square foot (annual) $1,000.00 (annual) $1,000.00 (annual) $600.00 (annual) $6,000.00 (annual) in addition to the S60K above S250.00 (annual) $3,600.00 (annual) $1,200.00 (annual) Purchase Date 4/30/20 Future Sale Price $1.200,000 Cost of Sale 3% Date of sale 4.5 years (42 months) from now 12.00% Discount Rate XNPV ? XIRR? Done Attaci Property Characteristics Purchase price Square feet Rent Vacancy Rate Rent Increase 2 units Medium condition (some deferred maintenance). $800,000 2000 2.900 per unit per month 10% 4% annual Expenses Insurane Trash Removal Landscaping Pest Control Repairs/Reserve HCIDLA Fee Utilities Misc. ? 1.25% of purchase price (annual) ? S0.50 per square foot (annual) $1,000.00 (annual) $1,000.00 (annual) $600.00 (annual) $6,000.00 (annual) in addition to the S60K above $250.00 (annual) $3,600.00 (annual) $1,200.00 (annual) Purchase Date 4/30/20 Future Sale Price $1,200,000 Cost of Sale Date of sale 4.5 years (42 months) from now 12.00 Discount Rate XNPV ? XIRR? 4 Gmail ll LTE 12:04 PM This will result in a $60.00 Expert Q&A10.000 each mon t i Purchase date 4/30/20 Dates of CFS Rent Increase % Gross Income Vacancy Effective Income Expenses Tax Insuranc Trash Removal Landscaping Pest Control Repairs/Reserve HCIDLA Fee Utilities Misc. Net Operating Income (NOI) Purchase Price Selling Price Cost of Sale Net of all Cash Flows Net Present Value Internal Rate of Return Done Attaci Property Characteristics Purchase price Square feet Rent Vacancy Rate Rent Increase 2 units Medium condition (some deferred maintenance). $800,000 2000 2.900 per unit per month 10% 4% annual Expenses Insurane Trash Removal Landscaping Pest Control Repairs/Reserve HCIDLA Fee Utilities Misc. ? 1.25% of purchase price (annual) ? S0.50 per square foot (annual) $1,000.00 (annual) $1,000.00 (annual) $600.00 (annual) $6,000.00 (annual) in addition to the S60K above $250.00 (annual) $3,600.00 (annual) $1,200.00 (annual) Purchase Date 4/30/20 Future Sale Price $1,200,000 Cost of Sale Date of sale 4.5 years (42 months) from now 12.00 Discount Rate XNPV ? XIRR
