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
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 solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
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...
this is financial Accounting. please provide the working details i can get it. thank you. Vulture...
this is financial Accounting. please provide the working details i can get it. thank you. Vulture Demolition Ltd has five employees and needs to calculate its Long Service Leave (LSL) expense for the year ended 30 June 2019. Employees are entitled to 15 weeks LSL after 12 years of service. If employees leave the business after 10 years but before 12 years they are entitled to be paid out their accumulated LSL. Employees who leave prior to 10 years service...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT