Question

In: Finance

Please show details of solving. Thank you. Ann buys a property that costs $1,000,000. She finances...

Please show details of solving. Thank you.

Ann buys a property that costs $1,000,000.

She finances the purchase with a 80% LTV mortgage.

She gets a 20 year interest only fixed rate mortgage at an annual interest rate of 5%, with annual compounding and annual payments.

Ann must pay 1.5 points upfront in mortgage closing costs (as a % of the loan amount).

The loan has a 5/4/3/2/1 prepayment penalty structure (she must pay a 5% penalty if she prepays at any time in the first year, 4% penalty in the second year etc).

Suppose Ann will sell the property in 3 years, after her 3rd year’s mortgage payment and pay off the balance when she sells.

What is Ann’s annualized IRR for the loan?

Solutions

Expert Solution

Cost of the property = $1,000,000
LTV = 80%
Therefore, loan value = $800,000

Cash flow in year 0 =
Inflow in form of loan = $800,000
Outflow in the form of mortgage closing cost = 1.5% of loan amount = ($12,000)
Inflow - Outflow = $788,000

Cash flow in years 1 and 2 = Annual loan payment =

Therefore,
Year 1 cash outflow = ($64,194.07)
Year 2 cash outflow = ($64,194.07)

Cash flow in year 3 = Annual payment on loan + repayment of outstanding loan + penalty of 3% on outstanding loan
--> Annual payment on loan = $64,194.07 (calculated above)
--> Outstanding loan amount = $723,728.20 (calculated below in the amortization table)
--> Penalty of 3% on outstanding loan = $21,711.85
Therefore, total outflow in year 3 = ($809,634.11)

==> Annualized IRR for the loan =

Therefore, the Annualized IRR for the loan is 6.46%

--> Amortization table:


Related Solutions

Please show details of solving. Thank you RES 3200 Bob buys a property that costs $5,000,000....
Please show details of solving. Thank you RES 3200 Bob buys a property that costs $5,000,000. Year NOI 1 $300,000 2 $315,000 3 $330,000 Bob will own the property for two years. The NOI from the property for years 1-3 is to the right: Bob will sell the property at the end of year 2 at a cap rate that is 50 basis points lower than the cap rate at which he bought the property. Assume Bob finances his purchase...
Bob buys a property that costs $1,000,000. The property is projected to generate NOI as follows:...
Bob buys a property that costs $1,000,000. The property is projected to generate NOI as follows: Year NOI 1 $100,000 2 $105,000 3 $110,000 Bob will own the property for two years. Bob will sell the property at the end of year 2 at a cap rate that is 250 basis points lower than the cap rate at which he bought the property. Assume Bob finances his purchase with a 50% LTV Fixed Rate IO loan at an annual rate...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully...
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully amortizing fixed rate mortgage at 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. How much is Ann’s monthly payment? A. $3,819.32 B. $2,666.67 C. $3,333.33 D. $4,774.15
"Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully...
"Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully amortizing fixed rate mortgage with 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. The mortgage has a 2% prepayment penalty if the borrower prepays in the first 5 years. Suppose Ann makes the required monthly payment for 3 years and prepays after her final monthly payment at the end of 3 years. What is the annualized IRR on...
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully...
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully amortizing fixed rate mortgage with 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. The mortgage has a 2% prepayment penalty if the borrower prepays in the first 5 years. Suppose Ann makes the required monthly payment for 3 years and prepays after her final monthly payment at the end of 3 years. What is the annualized IRR on...
What is the importance of atomic structure? Please explain in details thank you
What is the importance of atomic structure? Please explain in details thank you
Using Excel! Professor McGonagall buys a home for $129,000 and puts $15000 down.  She finances the rest...
Using Excel! Professor McGonagall buys a home for $129,000 and puts $15000 down.  She finances the rest for 30 years at 4.25% If she refinances after 5 years at 3.9%, how much will she save assuming she keeps paying the original amount?
Can you please show me the work on how you get your answer please (thank you...
Can you please show me the work on how you get your answer please (thank you in advance kings and queens of chegg) Problem 1: The following selected information is provided about a manufacturing company: Raw material purchases800,000 Direct labor 415,000 Overhead applied730,000 Actual overhead745,000 Selling and administrative salaries500,000 Other selling and administrative expenses185,000 Sales revenue5,000,000 Inventory data: January 1 December 31Raw material 75,000 100,000Work in process 105,000 140,000Finished goods 120,000 125,000Calculate the cost of goods sold. Assume that under/over...
PLEASE PROVE DETAILS - THANK YOU Stillwater Manufacturing, Inc. was formed on January 1 by issuing...
PLEASE PROVE DETAILS - THANK YOU Stillwater Manufacturing, Inc. was formed on January 1 by issuing 100,000 shares of $1 par value stock for $250,000. On that same date, Stillwater Manufacturing, Inc. acquired a piece of machinery and a truck as part of one purchase for $200,000 cash. The machine had a list price of $161,000 and the truck had a list price of $69,000. Freight cost amount to $1,300 for the machinery only. There was no delivery charge associated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT