Michael Razza purchased a 500,000 square foot farm in Wyoming on June 1, 2005. At the...

Michael Razza purchased a 500,000 square foot farm in Wyoming on June 1, 2005. At the time of purchase, the building had a Net Operating Income of $3,500,000. Mr Evans was able to obtain a loan with a 7% loan constant with a 30-year amortization schedule at the closing of the property. The Annual Debt Service (ADS) for this loan is $1,900,000.00. The loan has a maturity date of May 31, 2015. The loan does not contain a prepayment penalty.

What was the original amount of the loan at time of purchase?

Assume the original loan at purchase was 75% of the purchase price, how much equity did Michael put into the property at closing?

Assume that the loan has been in place for four (4) years, what is the loan balance at the end of Year 4?

Expert Solution

Loan constant = Annual debt service / Loan amount

7% = 1,900,000 / Loan amount, or Loan amount = 1,900,000 / 7% = $27,142,857

Since loan amount = 75% of purchase price, Michael put in 25% of the purchase price, where purchase price = loan amount / 75% = 27,142,857 / 75% = $36,190,476

Hence, Michael's equity contribution = 25% * 36,190,476 = $9,047,619

Loan amortization table can be built as below which shows loan balance at end of year 4 (month 48) is $25,616,560

Period	Opening balance	Interest payment	Principal repaid	Closing balance
1	27,142,857	129,974	28,359	27,114,498
2	27,114,498	129.838	28,495	27,086,003
3	27,086,003	129,702	28,631	27,057,372

48	25,652,058	122,836	35,498	25,616,560

Opening balance (from month 2) = prior period closing balance

Interest payment = interest rate (5.746229%) * opening balance

[Note: interest rate is solved for to arrive at a monthly payment of $158,333.33, which is annual debt service / 12 = 1,900,000 / 12]

Principal repaid = monthly payment ($158,333.33) - interest payment

Closing balance = opening balance - principal repaid

jeff jeffy answered 2 years ago

You are the owner of a 65,000 square foot office building. You purchased the building five...

You are the owner of a 65,000 square foot office building. You purchased the building five years ago for $11,500,000. During that entire time the building was triple net leased to a tenant who was also responsible for all maitenance and capital upkeep. The net rent the tenant paid was flat at $12.50 per square foot per year. You have just negotiated a lease extension which will raise the rent to $14.00 per square foot for the next 10 years....

1. Calculate the weighted unit cost per square foot for the project data shown below, and...

1. Calculate the weighted unit cost per square foot for the project data shown below, and determine the cost of a 30,000-sf project. 2. Determine the relationship between unit cost and size for the project data above, and use it to estimate the cost of a 25,000-sf project. 3. Use the time and location indices presented during Class10 to estimate the cost of a building that contains 48,000 sf of floor area. The building is to be constructed 3 years...

1) On January 1, 2005 Able Company purchased all of the stock of Baker Company. On...

1) On January 1, 2005 Able Company purchased all of the stock of Baker Company. On January 1, 2010, Able purchased a piece of equipment for $50,000. This equipment is expected to last 8 years with a 2000 salvage. On January 1, 2011 Able sold the equipment to Baker for $50,000. Baker believes the asset has 7 years of life remaining and a $1,000 salvage. On January 1, 2013 Baker sold the equipment to Cat Company for $30,000. Make all...

Balls & Bats, Inc. purchased equipment on January 1, 2005 at a cost of $100,000. Estimated...

Balls & Bats, Inc. purchased equipment on January 1, 2005 at a cost of $100,000. Estimated useful life is 4 years with a salvage value of $10,000. 1. Prepare two different depreciation schedules for the equipment, one using double-declining balance method and the other using the straight line method. 2. Which method would result in the greatest net income for the year ending Dec 31, 2005 3. How would taxes affect management's choice between these two methods for the financial...

On January 1, 2005 Able Company purchased all of the stock of Baker Company. On January...

On January 1, 2005 Able Company purchased all of the stock of Baker Company. On January 1, 2010, Able purchased a piece of equipment for $50,000. This equipment is expected to last 8 years with a 2000 salvage. On January 1, 2011 Able sold the equipment to Baker for $50,000. Baker believes the asset has 7 years of life remaining and a $1,000 salvage. On January 1, 2013 Baker sold the equipment to Cat Company for $30,000. REQUIRED: A) PREPARE...

The Square Foot Grill, Inc. issued $187,000 of 10-year, 5 percent bonds on January 1, 2018,...

The Square Foot Grill, Inc. issued $187,000 of 10-year, 5 percent bonds on January 1, 2018, at 102. interest is payable in cash annually on December 31. The straight-line method is used for amortization. Required Use a financial statements model like the one shown below to demonstrate how (1) the January 1, 2018, bond issue and (2) the December 31, 2018, recognition of interest expense, including the amortization of the premium and the cash payment, affects the company’s financial statements....

A tornado struck the only manufacturing plant of Toledo Farm Implements (TFI) on June 1. All...

A tornado struck the only manufacturing plant of Toledo Farm Implements (TFI) on June 1. All work-in-process inventory was destroyed, but a few records were salvaged from the wreckage and from the company’s headquarters. If acceptable documentation is provided, the loss will be covered by insurance. The insurable value of work-in-process inventory consists of direct materials, direct labor, and applied overhead. The following information about the plant appears on the April financial statements at the company’s downtown headquarters. Materials inventory,...

Miller, Inc. manufactures construction equipment and farm machinery tires. For the month of June, year 1,...

Miller, Inc. manufactures construction equipment and farm machinery tires. For the month of June, year 1, Miller expects to produce 2,500 tires and sell the same number at $1,000 per tire. Budgeted selling and administrative costs for the tires (all fixed) are expected to equal to $50,000. The standard costs per tire are as follows: Direct materials 100 pounds @ $2/pound $200 Direct labor 20 DLH @ $9/DLH 180 Variable overhead 4.5 MH @$10/MH 45 Fixed overhead 4.5 MH @$50/MH...

NH CableSource purchased a depreciable asset on January 1, 2013 at a cost of $500,000. The...

NH CableSource purchased a depreciable asset on January 1, 2013 at a cost of $500,000. The asset is expected to have a salvage value of $75,000 at the end of its five-year useful life. The asset will produce 100000 parts at 25000 year 1, 20,000 year 2, 15,000 year 3, 20,000 year 4, 20,000 in year 5. Show the depreciation entry for year 3 using the straightline method of Depreciation. What is the book value at the end of year...

Caprio Inc. sells $500,000 of 10% bonds on June 1, 2015. The bonds pay interest on...

Caprio Inc. sells $500,000 of 10% bonds on June 1, 2015. The bonds pay interest on December 1 and June 1. The due date of the bonds is June 1, 2020. The bonds yield 8%. On October 1, 2016, Caprio buys back $200,000 (face value) of bonds for $210,000 in cash (not including accrued interest which was paid separately – also in cash). Provide the following: Show EXCEL FORMULAS a. The present value of the bond payable is $ ______________________...

Question