A townhouse, selling at Php6.5 M, requires a potential buyer to have a spot cash down...

Transcribed Image Text:

A townhouse, selling at Php6.5 M, requires a potential buyer to have a spot cash down payment of 5%. The 45% equity is to be paid monthly in 5 years both the interest and principal with 12% rate of interest. The remaining 50% will be paid monthly in 10 years as In-House Financing with the aforementioned interest. The construction of the said townhouse was loaned by the owner from Home Development Mutual Fund (PAGIBIG) in an amount equal to Php3.5M. (a) Calculate the monthly payment for the loan with 6% interest for 25 years (b) If the monthly expense of the owner is good for 12% of the monthly income, determine the NOI (c) Write the Income Statement, Balance Sheet Statement, and Cash Flow Statement of the deal (d) Once the potential buyer completes the payment in 15 years, the title of the property will be transferred to him/her. The documents to be facilitated are approximately 10% of the Selling price. What then is the net proceeds of the transaction. Please be mindful that the owner has to pay the remaining lump sum scheduled payments for the PAGIBIG to be cleared of any encumbrances affixed to the title. (e) If the owner decided to invest 10% of monthly income to an investment vehicle that returns 12% compounded annually, what then will be the total net proceeds of the transaction. A townhouse, selling at Php6.5 M, requires a potential buyer to have a spot cash down payment of 5%. The 45% equity is to be paid monthly in 5 years both the interest and principal with 12% rate of interest. The remaining 50% will be paid monthly in 10 years as In-House Financing with the aforementioned interest. The construction of the said townhouse was loaned by the owner from Home Development Mutual Fund (PAGIBIG) in an amount equal to Php3.5M. (a) Calculate the monthly payment for the loan with 6% interest for 25 years (b) If the monthly expense of the owner is good for 12% of the monthly income, determine the NOI (c) Write the Income Statement, Balance Sheet Statement, and Cash Flow Statement of the deal (d) Once the potential buyer completes the payment in 15 years, the title of the property will be transferred to him/her. The documents to be facilitated are approximately 10% of the Selling price. What then is the net proceeds of the transaction. Please be mindful that the owner has to pay the remaining lump sum scheduled payments for the PAGIBIG to be cleared of any encumbrances affixed to the title. (e) If the owner decided to invest 10% of monthly income to an investment vehicle that returns 12% compounded annually, what then will be the total net proceeds of the transaction.

Answer rating: 100% (QA)

a Monthly payment for PAGIBIG loan of Php35M at 6 interest for 25 years Using the PMT function in Excel PMT612 2512 3500000 Monthly payment is Php2565... View the full answer