Jack moved to Singapore and considering living in Singapore for 7-10 yrs. Given the low interest...

 

Transcribed Image Text:

Jack moved to Singapore and considering living in Singapore for 7-10 yrs. Given the low interest rates, she considers buying a condo and starts comparing her options. She is interested in a place which is priced at $500,000. The agent has offered his two choices for financing the purchase. With 20% down, she can take out a loan at 1.5% annual percent rate (APR) to be paid over next ten years. Alternately, she can rent a similar apartment for the next ten years at $3500 per month, with an option to buy it for $180,000 at the end of the lease term. Jack studies the propertyguru prices and expects the value of the house to appreciate at an annual rate of 2%. Although not sure, she thinks a fair personal discount rate for his situation is 8% per year. She reasons that it is the target rate of return for his retirement account. After all, any extra money goes into that account with that target return rate. a. What will be Jack's monthly payment under the buy option? b. Should she buy or rent the condo? c. What other concerns would you raise with leasing - do a sensitivity analysis to answer this question. Use Excel sheet and your favorite add-ins to solve this question. Also submit a one-page report explaining your decision. Jack moved to Singapore and considering living in Singapore for 7-10 yrs. Given the low interest rates, she considers buying a condo and starts comparing her options. She is interested in a place which is priced at $500,000. The agent has offered his two choices for financing the purchase. With 20% down, she can take out a loan at 1.5% annual percent rate (APR) to be paid over next ten years. Alternately, she can rent a similar apartment for the next ten years at $3500 per month, with an option to buy it for $180,000 at the end of the lease term. Jack studies the propertyguru prices and expects the value of the house to appreciate at an annual rate of 2%. Although not sure, she thinks a fair personal discount rate for his situation is 8% per year. She reasons that it is the target rate of return for his retirement account. After all, any extra money goes into that account with that target return rate. a. What will be Jack's monthly payment under the buy option? b. Should she buy or rent the condo? c. What other concerns would you raise with leasing - do a sensitivity analysis to answer this question. Use Excel sheet and your favorite add-ins to solve this question. Also submit a one-page report explaining your decision.

Answer rating: 100% (QA)

Answer To solve this problem we can use the Excel financial functions to calculate the monthly payme... View the full answer