Assume you want to live in the house for 4 yrs and earn a 12% rate of return on your investment. How much can you pay to buy the house to achieve that target?

ng Tool Tools Help O Mode Delay Rent versus Own Analysis of a Personal Residence Property information Property ID Purchase price Rent including Insurance - Annual S Rental growth rate Property growth rate Home Insurance - Annual Premium $ Maintenance - Annual S Expense growth rate Marginal tax rate Property tax % of Property Value Selling expenses (commision, closing etc) Loan Information: Loan-to-value ratio Loan amount Interest rate Loan term (years) Payments (per year) 80.00% $160.000 6.00% 30 12 ABC-123-CLEV $200,000 $24,180 2.00% 2.0096 $1.500 $1,200 2.00% 22.00% 2.00% 6.50% Loan and Equity Calculations Annual debt service (payment) Annual loan constant Equity investment $11,511 7.1959 $40,000 ng Tool Tools Help O Mode Delay Rent versus Own Analysis of a Personal Residence Property information Property ID Purchase price Rent including Insurance - Annual S Rental growth rate Property growth rate Home Insurance - Annual Premium $ Maintenance - Annual S Expense growth rate Marginal tax rate Property tax % of Property Value Selling expenses (commision, closing etc) Loan Information: Loan-to-value ratio Loan amount Interest rate Loan term (years) Payments (per year) 80.00% $160.000 6.00% 30 12 ABC-123-CLEV $200,000 $24,180 2.00% 2.0096 $1.500 $1,200 2.00% 22.00% 2.00% 6.50% Loan and Equity Calculations Annual debt service (payment) Annual loan constant Equity investment $11,511 7.1959 $40,000