90.2K

Verified Solution

Link Copied!

please write answer to question a and b bold please separate from excel sheet

And X You Are Coox C Your X C You Are Cox 1d4b1b272673266dfa9aa1d622014c3/MyFiles/Downloads/Asagn 204 pdf Not the wox Rix Privacy 111 100% H cony TV yield ratio b) If your bank requires a minimum debt coverage ratio of 13, what is the maximum annual mortgage payment you can afford? Question 2 You are considering the purchase of an apartment complex Purchase price: $775,000 Holding period is four years Caprate is expected to be 7% in year 4 Selling expenses will be 5% of the sale price The 4-year Treasury bill rate is 3% and your risk premium for this project is 8% Year 1 2 3 + NOI $103.085 $108.361 $11.1.875 $119,636 5125.651 >) Calculate the NPV of this project assuming that you do not take any mortgages b) You take a 5620.000 mortgage. Your annual debt payment is 554.593. The outstanding loan balance at the end of year is $596.558. Calculate the NPV of this project And X You Are Coox C Your X C You Are Cox 1d4b1b272673266dfa9aa1d622014c3/MyFiles/Downloads/Asagn 204 pdf Not the wox Rix Privacy 111 100% H cony TV yield ratio b) If your bank requires a minimum debt coverage ratio of 13, what is the maximum annual mortgage payment you can afford? Question 2 You are considering the purchase of an apartment complex Purchase price: $775,000 Holding period is four years Caprate is expected to be 7% in year 4 Selling expenses will be 5% of the sale price The 4-year Treasury bill rate is 3% and your risk premium for this project is 8% Year 1 2 3 + NOI $103.085 $108.361 $11.1.875 $119,636 5125.651 >) Calculate the NPV of this project assuming that you do not take any mortgages b) You take a 5620.000 mortgage. Your annual debt payment is 554.593. The outstanding loan balance at the end of year is $596.558. Calculate the NPV of this project

Answer & Explanation Solved by verified expert

See Answer