Question
Calculate the expected return (IRR) for each option using these additional assumptions. Clue: Use the IRR function in MS Excel. Annualize IRRs using compounding. Legal
Calculate the expected return (IRR) for each option using these additional assumptions. Clue: Use the IRR function in MS Excel. Annualize IRRs using compounding.
Legal Actions Option The duration of the foreclosure process is three months. The legal and administrative costs associated with the foreclosure are $50,000 due at the end of the foreclosure (i.e., three months from today). The duration of the subsequent sale process is nine months. The legal and administrative costs associated with the subsequent sale are 5% of the sale price, due at sale (i.e., twelve months from today). The proceeds from the sale (one year from today) are $953,931.10, which is $1,004,138, less a 5% sales commission. No significant costs are associated with the environmental liabilities of the property. There are no cash flows from the deficiency judgement, and the cash flows before the eventual sale of the property (i.e., rents, maintenance, and capital expenditures) are zero. Determine the cashflows and their timeline, and calculate the IRR:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66a10cec62b52_63566a10cebdcc67.jpg)
Discounted Payoff Option The current value of the property is $982,259. An LTV of 75% yields a book value for the new loan of $736,694.61. The completion of the discounted payoff takes three months. Determine the cashflows and their timeline, and calculate the IRR:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66a10ced3e454_63666a10cecbb4e2.jpg)
Loan Sale Option The buyer is willing to pay up to 80% LTV based on the value of Burton managing the property. The current value of the property is $982,259 implying a loan sale at a price of $785,807.58. The completion of the loan sale takes six months. Determine the cashflows and their timeline, and calculate the IRR:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66a10cede6505_63766a10ced8189f.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started