You have purchased a multi-tenant office building for $15,000,000. Your acquisition costs associated with this purchase...

You have purchased a multi-tenant office building for $15,000,000. Your acquisition costs associated with this purchase are $25,000. The estimated land value is $3,000,000, of which you estimate the depreciable land portion at $1,000,000. You estimate the 7-year property at a value of $2,000,000. You have arranged a 70% LTV, 7-year mortgage at a 5.25% interest rate with 2 points and a 25 year amortization period. Your projected NOI in the next two years is $1,200,000 and 1,250,000 which includes projected CAPEX (above line) of $100,000 and $102,000. Your marginal tax rate is 43.4%.

What is your debt service for Year 1 and Year 2?

What is your BTCF for Year 1 and Year 2?

What is your interest expense for Year 1 and Year 2?

What is your land depreciation for Year 1 and Year 2?

What is your 7-year depreciation for Year 1 and Year 2?

What is your building depreciation for Year 1 and Year 2?

What is your amortized finance cost for Year 1 and Year 2?

What is your taxable income for Year 1 and Year 2?

What is your tax due for Year 1 and Year 2?

What is your ATCF for Year 1 and Year 2?

Solutions

Expert Solution

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You are considering the acquisition of a small office building. The purchase price is $775,000. Seventy-five...

You are considering the acquisition of a small office building. The purchase price is $775,000. Seventy-five percent of the purchase price can be borrowed with a 30-year, 7.50% mortgage. Up-front financing costs will total 3.00% of the loan amount. The expected cash flows assuming a 5-year holding period are as follows: Year NOI 1 $48,492 2 $53,768 3 $59,282 4 $65,043 5 $71,058 The cash flow from the sale of the property is expected to be $1,000,000. What is the...

You are considering the purchase of a parking deck close to your office building. The parking...

You are considering the purchase of a parking deck close to your office building. The parking deck is a 15-year old structure with an estimated remaining service life of 25 years. The tenants have recently signed long-term leases, which leads you to believe that the current rental income of $250,000 per year will remain constant for the first five years. Then the rental income will increase by 10% for every five-year interval over the remaining asset life. Thus, the annual...

You are considering the purchase of a parking deck close to your office building. The parking...

You are considering the purchase of a parking deck close to your office building. The parking deck is a 15-year old structure with an estimated remaining service life of 25 years. The tenants have recently signed long-term leases, which leads you to believe that the current rental income of$250,000 per year will remain constant for the first five years. Then the rental income will increase by 10% for every five-year interval over the remaining asset life. Thus, the annual rental...

Hart Company sells and delivers office furniture across Western Canada. The costs associated with the acquisition...

Hart Company sells and delivers office furniture across Western Canada. The costs associated with the acquisition and annual operation of a delivery truck are given below: Insurance$3,593 Licences$205 Taxes (vehicle)$122 Garage rent for parking (per truck)$1,220 Depreciation ($25,500 ÷ 5 years)$5,100 Gasoline, oil, tires, and repairs$0.20/km 3. Assume that the company decides to use the truck during the second year. Near year-end, an order is received from a customer over 1,000 kilometres away. What costs from the previous list are relevant in a decision between...

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....

A governmental entity is the recipient of a bequest of a multi-story office building that the...

A governmental entity is the recipient of a bequest of a multi-story office building that the government intends to use as a new city hall. The building has a historical cost of $850,000; a book value in the hands of the benefactor of $700,000; and a fair value of $1,050,000. The city should recognize on its governmental fund financial statements, donations revenue of a) $-0-. b) $700,000. c) $850,000. d) $1,050,000 Explanation to why answer is d A governmental entity...

A government is the recipient of a bequest of a multi-story office building that the government...

A government is the recipient of a bequest of a multi-story office building that the government intends to use as a new city hall. The building has a historical cost of $850,000; a book value in the hands of the benefactor of $700,000; and a fair value of $1,050,000. The city should recognize on its governmental fund financial statements donations revenue of $-0-. $700,000. $850,000. $1,050,000 Explanation to the answer please

You are field manager for the general contractor on a multi-story office building under construction. The...

You are field manager for the general contractor on a multi-story office building under construction. The project has risen all 15 floors above the foundation. The roof is on and the exterior façade of the structure, consisting of alternating blue glass ribbon windows and red granite panels, has “dried in” the project many weeks ago. On the third, seventh and fifteenth floors, the executive offices located on the corners of the building have blue glass doors that lead outside to...

You want to purchase an office building in Brooklyn. The property contains 32,100 square feet of...

You want to purchase an office building in Brooklyn. The property contains 32,100 square feet of rentable space and is currently occupied by multiple tenants each with differing maturities on their respective leases. No lease is currently shorter than 1 year. The annual rent in the 1st year of ownership is $37.50/sq ft. The vacancy rate is 5.5%. You expect to incur collection losses (from tenant default) on 1.5% of the square feet during your first year. 1. What is...

Adjusting Journal Entry using Activity based method: Purchased Machinery $10,000. Costs associated with the purchase are:...

Adjusting Journal Entry using Activity based method: Purchased Machinery $10,000. Costs associated with the purchase are: freight-in costs of $300, and construction of specialized platform to hold the machine, $500. All amounts are paid with cash. Estimated useful life is 20,000 machine hours, with a $1,000 Salvage Value.

Subjects