Question

In: Finance

A property was purchased by an investor. The property is expected to produce $120,000 of annual...

A property was purchased by an investor. The property is expected to produce $120,000 of annual net operating income in year 1; increasing $10,000 every year thereafter. The owner intends to sell the property at the end of year 5. a. Assuming the bank requires a 1.2 debt coverage service ratio based on the expected first year NOI, what is the maximum monthly mortgage payment? b. Assuming the mortgage has a 6% annual interest rate, amortizes over 30 years, with monthly payments. What is the principal amount of mortgage? (Note, you will need to use the information above to identify the “I”, “N” and “PMT” in order to solve for “PV”.) c. Based on the above scenario, what is the expected NOI for purposes of computing the value of the asset at the time of sale?

Solutions

Expert Solution

EXCEL FORMULA:

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

2. A property was purchased by an investor. The property is expected to produce $120,000 of...
2. A property was purchased by an investor. The property is expected to produce $120,000 of annual net operating income in year 1; increasing $10,000 every year thereafter. The owner intends to sell the property at the end of year 5. a. Assuming the bank requires a 1.2 debt coverage service ratio based on the expected first year NOI, what is the maximum monthly mortgage payment? b. Assuming the mortgage has a 6% annual interest rate, amortizes over 30 years,...
ompany B considers investing in a machine that costs €120,000. The machine is expected to produce...
ompany B considers investing in a machine that costs €120,000. The machine is expected to produce revenues of €100,000 per year. The cost of materials and labor needed to generate these revenues will total €25,000 per year and other cash expenses will be €25,000 per year, for the next five years. The machine will be depreciated on a straight-line basis over five years with a zero salvage value and is estimated to be sold for €20,000 Euros at the end...
You purchased a rental property that generates $50,000 during the first year. The property will produce...
You purchased a rental property that generates $50,000 during the first year. The property will produce an additional 49 cash flows growing at a rate of 4 percent per year. If the interest rate is 8 percent compounded yearly and rental payments are made at the beginning of each year, what should the value of this property be?
On January 1st 2016 the Hail Company purchased a tractor for $120,000. This tractor is expected...
On January 1st 2016 the Hail Company purchased a tractor for $120,000. This tractor is expected to last 12 years and have a $2400 salvage value Hail expects to drive the tractor 470400 miles .   In 2016 Hail drove the tractor 80,000 miles; in 2017 Hail drove the tractor 127,000 miles Part 1: fill in the following table 2016 2017 2016 2017 dep exp dep exp book value book value straight line depreciation double declining depreciation units of activity depreciation...
Electronics Inc. purchased a machine for $140,000. They borrow $120,000 from the bank at annual 4%...
Electronics Inc. purchased a machine for $140,000. They borrow $120,000 from the bank at annual 4% nominal rate. The loan agreement requires monthly repayments over the next 6 years. How much is the monthly repayment amount? a. 1,650 b. 2,065 c. 1,907 d. 1,877
Deer and Doe purchased $120,000 of equipment six years ago. The equipment is 7-year MACRS property....
Deer and Doe purchased $120,000 of equipment six years ago. The equipment is 7-year MACRS property. The firm is selling this equipment today for $24,500. What is the after-tax cash flow from this sale if the tax rate is 35 percent? Year                     1           2           3           4          5          6          7          8 Percent            14.29    24.49    17.49    12.49     8.93     8.93     8.93     4.45 a. $27,455.40 b. $25,785.40 c. $15,925.00 d. $21,544.60 e. $18,209.60
A widget machine your company has just purchased for $120,000 has an expected salvage value of...
A widget machine your company has just purchased for $120,000 has an expected salvage value of $25,000. It has an expected life of 8 years. Develop a sum-of-the-years-digits depreciation schedule with half year convention. Please show book value at the beginning of each year in your depreciation schedule. Remember to show all of your work.
Sam is a property investor. He purchased a small commercial building in Sydney for $2,000,000. Sam...
Sam is a property investor. He purchased a small commercial building in Sydney for $2,000,000. Sam had to take out a loan from the ANZ Bank to purchase this property and Sam is charged interest on that loan. In order to rent the property, he met William, who is an experienced real estate agent. Sam and William agreed that an upfront lump-sum payment of $8,100 as a management fee is to be paid to William. With reference to the relevant...
Sam is a property investor. He purchased a small commercial building in Sydney for $2,000,000. Sam...
Sam is a property investor. He purchased a small commercial building in Sydney for $2,000,000. Sam had to take out a loan from the ANZ Bank to purchase this property and Sam is charged interest on that loan. In order to rent the property, he met William, who is an experienced real estate agent. Sam and William agreed that an upfront lump-sum payment of $8,100 as a management fee is to be paid to William. With reference to the relevant...
A property that can be purchased for $1.7 million has an expected first year NOI of...
A property that can be purchased for $1.7 million has an expected first year NOI of $190,000. An investor is considering two loan alternatives: LOAN A: A 70% loan-to-value ratio, with interest at 7.5% per annum. The loan will require level monthly payments to amortize the principle over 20 years. LOAN B: An 80% loan-to-value ratio, with interest at 8% per annum. This loan will require level monthly payments to amortize the principal over 25 years. Fore each loan, determine:...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT