Question

In: Accounting

Own or rent analysis. Linda wants to purchase a property at the beginning of 2019 and...

Own or rent analysis. Linda wants to purchase a property at the beginning of 2019 and plans to sell at the end of 2019. The loan payment is by annual and is fully amortizing FRM. The information for analysis is as below:

Property purchase price at the beginning of 2019

$200,000

LTV Ratio

80%

Annual Interest rate

6%

Loan term

30 years

Annual rent

$15,000

Property sell price at the end of 2019

$235,000

Annual insurance

$500

Annual maintenance

$500

Marginal tax rate

28%

Property tax rate

1.50% based on the purchase price at the beginning of 2019

Annual discount rate

12%

Selling expense

6% of sell price at the end of 2019

No sales tax

Please answer the question of whether Linda needs to make the purchase by calculating the cost of owning, benefit of owning, the NPV and IRR of this purchase.

Solutions

Expert Solution

Purchase Price of Machine 200000
Loan to Value of Machine 80%
Loan Availment 160000
Principal Inception 40000
Annual Interest Rate 6%
Annual Discount Rate 12%
Loan Repayment Installment By-annually 80000
Interest for First Six Month 4800
Interest for Next Six Month 2400
Present Value of Loan and Interest Repayment at Half yearly @12% 80000
Present Value of Loan and Interest Repayment at year end @ 12% 73571
Present Value of Loan and Interest Repayment at Half yearly @15% 78884
Present Value of Loan and Interest Repayment at year end @ 15% 71652
Present Value of Loan and Interest Repayment at Half yearly @20% 77091
Present Value of Loan and Interest Repayment at year end @ 20% 68667
Present Value of Loan and Interest Repayment at Half yearly @25% 75378
Present Value of Loan and Interest Repayment at year end @ 25% 65920
Sale Value 235000
Annual Rent 15000
Total Receipt at year end 250000
Selling Expense 6% of Sale Value 14100
Annual Maintenance 500
Annual Insurance 500
Property Tax (1.5% of opening value of property) 3000
Interest Expense 7200
Purchase price of property 200000
Profit for the year 24700
Tax @ 28% 6916
Profit after tax 17784
Cash Realisation at year end 224984
Present value of cash realization at year end @ 12% 200879
Present value of cash Outflow @ 12% 193571
Net Present Value @12% 7307
ROI @ 12% 18.27%
Present value of cash realization at year end @ 15% 195638
Present value of cash Outflow @ 15% 190536
Net Present Value @15% 5102
Present value of cash realization at year end @ 20% 187487
Present value of cash Outflow @ 20% 185758
Net Present Value @20% 1729
Present value of cash realization at year end @ 25% 179987
Present value of cash Outflow @ 25% 181298
Net Present Value @25% -1311
IRR 22.84389803
20%+[NPV @ 20%/(NPV @ 20% LESS NPV @ 25%) *5
We should go for buy option

Related Solutions

Rent vs Own You are considering an option to purchase or rent a single residential property....
Rent vs Own You are considering an option to purchase or rent a single residential property. You can rent it for $4,000 per month and the owner would be responsible for maintenance, property insurance, and property taxes. Alternatively, you can purchase this property for $300,000 and finance it with an 80% mortgage at 7% interest, 25 year - fixed. The loan can be prepaid at any time with no penalty. You have done research in the market and found that...
Emma has not yet decided whether she wants to rent or buy a property here in...
Emma has not yet decided whether she wants to rent or buy a property here in Oxford and she is asking your team to help her make this financial decision. Her monthly budget is $1,500 to cover any housing expenses including rent or owners’ costs (example: mortgage, hazard insurance, property taxes, and Home Owner Association fees). A good start of the analysis is by applying financial concepts such as the “time value of money.” Emma’s contract is for three years...
PART A A student wants to purchase an investment property that can generate sufficient cash flow...
PART A A student wants to purchase an investment property that can generate sufficient cash flow (net rental income) to pay her monthly living expenses. The cash flow is calculated by taking the rent received in a month and subtracting all of the expenses associated with the property for that month. The expenses are: landlord insurance property taxes repair cost management fees Write a program to calculate the net income and determine if it’s sufficient to pay the living expenses....
Tina wants to purchase an annuity that should be paid 30 times at the beginning of each year.
Tina wants to purchase an annuity that should be paid 30 times at the beginning of each year. The nominal APR is 6% ,compound monthly and 3% annual inflation rate. If the present value is $60000.Find the first and last payment.    
Linda Peddler owns a bicycle factory. She could either rent or buy a machine to increase...
Linda Peddler owns a bicycle factory. She could either rent or buy a machine to increase her factory’s production capacity. She can rent the machine for its expected life of 10 years for 120 payments of $1,000, due at the end of each month. The appropriate annual discount rate for the payments is 6.40%. At what price should Ms. Peddler be indifferent between renting and purchasing the machine? How does your answer to item a change if the annual discount...
Tom wants to purchase a property for $300,000. He can borrow a 80% LTV fixed-rate loan,...
Tom wants to purchase a property for $300,000. He can borrow a 80% LTV fixed-rate loan, with 4.5% annual interest rate and a 3% origination fee. Or, he can borrow a 90% LTV fixed-rate loan, with 5.5% annual interest rate, and a 3% origination fee. Both loans have a 30 year amortization period. If he plans to prepay the loan at the end of 3rd year, what will be the incremental cost of borrowing for him to to borrow the...
You are considering an option to rent or to purchase a single-family house. You can rent...
You are considering an option to rent or to purchase a single-family house. You can rent it for $1,500 per month. If you rent the property, the current owner will be responsible for maintenance, property insurance and taxes. Your second option is to purchase the property for $125,000. You have enough money for a 20% down payment, and would need to finance the other 80% with a fixed-rate mortgage at a four percent interest rate. Assume that the mortgage would...
Investment Analysis To finance the purchase of a multifamily property 12 years ago, your investment group...
Investment Analysis To finance the purchase of a multifamily property 12 years ago, your investment group took a 40-year fixed-rate mortgage (FRM) at an annual interest rate of 3.8%. You are making a payment of $10,000 per month for this mortgage. A) What is the initial loan amount? (5 points) B) Suppose this loan is a conventional loan that required an initial 80% LTV. What was the purchase price of the property? (5 points) C)How much of the next (i.e....
Suppose you own a house where you live and a condo for rent. The monthly rent...
Suppose you own a house where you live and a condo for rent. The monthly rent is $1,600 and you will get it at the end of each month. Yet you have to pay maintenance fees and insurance premium. They are $600 per month in total. The property tax is proportional to the (present) value of the property. The tax rate is 0.1% per month and you pay the tax every month on the last day of each month with...
Assume a property has 200,000 SF. The existing rent is $70 SF/Yr. The market level rent...
Assume a property has 200,000 SF. The existing rent is $70 SF/Yr. The market level rent is $77 SF/Yr. Operating expenses are $40 SF/Yr. Assume the existing lease has a month to month term, and a 3.5% cap rate for this property. What is the delta between the value based on the existing rent versus the value based on the market level?     $40 million $20 million $38 million None of the above
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT