find the XIRR (only asking for this part so its one question) pls show work
..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? Search ..1 LTE 11:52 AM Done Attachment 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? ..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? Search ..1 LTE 11:52 AM Done Attachment 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
