I want to purchase a house in Florida. The current value is $350,000. I would like to put 25% down and make the purchase in 5 years. Houses in the area are appreciating at 6% per year. The forecasted mortgage rate at the time of purchase is 3.75% for 30 years. Future cost of the house? Down payment? Mortgage amount? Monthly payments to get down payment, if I can invest at 15%? Monthly payment of the mortgage? Copy and Paste Special the first 6 months of the amortization table from the worksheet. What is the reduction in principal in month 1? If you made an additional payment per year (1/12 more per month or made biweekly payments), How much interest would you save?
