Hello everyone. I have developed a home purchase calculator spreadsheet that assists with determining the particular date that an individual would be able to purchase a home based on basic inputs, such as monthly takehome amount, the desired total home purchase price, and the desired down payment percentage.
Additional information that is displayed is the loan information to determine the monthly mortgage payments based on the total home purchase price, which will assist the individual in determining if the desired home is within the budget of the individual.
Monthly takehome amounts along with asset totals (investment total and bank savings total) can be inputted for up to two people in case the individual plans to team up with another person to purchase a home. Totals are shown combining the monthly takehome amounts and the total assets of both individuals in a separate table.
I hope everyone finds this tutorial and spreadsheet helpful!