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 ^^ Specific solution on excel file with specific formula, please ^^ 1. You

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!