Assume that a potential buyer is interested in purchasing a home worth (US dollars) USD150,000. The buyer approaches an Islamic financial institution for the purchase of the property and puts down 20% of the price (USD30,000). The financial institution provides the other 80% of the price (USD120,000). This agreement results in 20% of the home belonging to the client and the remaining 80% to the financial institution. The next step is to determine the fair rental value for the property based on the estimates of other properties in the same neighbourhood. A fair rental value of USD1,000 per month is determined. As such, the client pays USD 800 as rent for the 80% share of the financial institution at the start of the contract. The two parties then agree on a period of financing of 15 years, that is 180 months (12 × 15 = 180). Based on the rental value and the financing period, the financial institution then determines the fixed monthly payments the client would have to make to own the house by paying the required rental amount each month and an equal monthly amount to repurchase the bank’s share. Prepare an excel spreadsheet of the monthly payments
Assume that a potential buyer is interested in purchasing a home worth (US dollars) USD150,000. The buyer approaches an Islamic financial institution for the purchase of the property and puts down 20% of the price (USD30,000). The financial institution provides the other 80% of the price (USD120,000). This agreement results in 20% of the home belonging to the client and the remaining 80% to the financial institution. The next step is to determine the fair rental value for the property based on the estimates of other properties in the same neighbourhood. A fair rental value of USD1,000 per month is determined. As such, the client pays USD 800 as rent for the 80% share of the financial institution at the start of the contract. The two parties then agree on a period of financing of 15 years, that is 180 months (12 × 15 = 180). Based on the rental value and the financing period, the financial institution then determines the fixed monthly payments the client would have to make to own the house by paying the required rental amount each
month and an equal monthly amount to repurchase the bank’s share. Prepare an
excel spreadsheet of the monthly payments
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)