Question: Specific solution on excel file with specific formula, please ^^ 1. You have managed to save $65,000 for a down payment including $5,000 for closing
Specific solution on excel file with specific formula, please ^^ 
1. You have managed to save $65,000 for a down payment including $5,000 for closing and moving costs on your first home The price of your new home is $295,000 and you will apply $60,000 towards the down payment. You are currently paying $1,500 per month in rent. If you amortize your mortgage over 25 years and secure a 5 year lock-ed in rate of 3.2%, monthly payments, and budget 1% of the purchase price for property taxes, what is the net savings per month of paying PIT versus Rent? A. $234.98 B. $43.67 C. $17.79 D. (122.35) | 2. The HBP has benefited many Canadians in acquiring their first home. You plan to use the maximum amount and contribute monthly to your RSP starting today. If you expect to earn 8% in a mutual fund, how much do you need to contribute to your RSP each month if you want to buy your home in 3 years from today. A. $723.67 B. $612.66 C. $616.74 D. $555.37 1. You have managed to save $65,000 for a down payment including $5,000 for closing and moving costs on your first home The price of your new home is $295,000 and you will apply $60,000 towards the down payment. You are currently paying $1,500 per month in rent. If you amortize your mortgage over 25 years and secure a 5 year lock-ed in rate of 3.2%, monthly payments, and budget 1% of the purchase price for property taxes, what is the net savings per month of paying PIT versus Rent? A. $234.98 B. $43.67 C. $17.79 D. (122.35) | 2. The HBP has benefited many Canadians in acquiring their first home. You plan to use the maximum amount and contribute monthly to your RSP starting today. If you expect to earn 8% in a mutual fund, how much do you need to contribute to your RSP each month if you want to buy your home in 3 years from today. A. $723.67 B. $612.66 C. $616.74 D. $555.37
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
