Real estate – Pro forma & Brokers assumptions

Real estate – Pro forma & Brokers assumptions

1. Use the brokers assumptions provided in the spreadsheet to construct a<br />
pro forma for 6 years<br />
<br />
? 2. Calculate the net sale proceed at the end of year 5. Include your<br />
calculation of broker commissions and other sale costs of $10,000.<br />
<br />
? 3. Calculate the effective cost of borrowed funds for the 5 year holding<br />
period. Combine the cash flows on both loans. Remember to adjust for the<br />
origination and assumption fees.<br />
<br />
? 4. You will purchase this property at a price that will produce a leveraged<br />
IRR of 14% [Required Discount Rate]. What price would you offer to get<br />
the 14% IRR on equity?<br />
<br />
Lastly, Ultimately, using all above, Complete the attached Answer Sheet.(excel)<br />
<br />
<br />
<br />
I will upload 4 files including detailed order description.<br />
<br />
1. PDF file: Order description <br />
2. Excel file: Answer sheet<br />
3. Word/PPT file: Reference<br />
——————————————————————–<br />
4. You don’t need to use any references.<br />
<br />
5. Just fill in the all the blank box in the excel file. <br />
<br />
6. since this is the assignment using excel spreadsheet, you need to use equations on the excel formula window instead of just simply input the answers which is actually derived from the equations. Don’t just put a simple number in the box. I need equations from the answers. (ex) assuming that we have an answer of “4” then express 4 by using excel format“=2+2” or whatever , don’t simply put the number ”4” <br />
<br />
Again, 4 (x), =2+2 (o)
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂