An office complex has the following operating expenses in year one janitorial $12,500 insurance $13,500 maintenance

An office complex has the following operating expenses in year one

janitorial $12,500

insurance $13,500

maintenance $14,050

property taxes $8,651

landscaping $8,248

The following tenants have agreed to reimburse for CAM expenses according to the following lease terms

Office 1 (4,800 sq ft) Up to $2.55 psf

Office 2 (4,600 sq ft) Up to $2.70 psf

Office 3 (4,300 sq ft) Up to $2.90 psf

Office 4 (3,000 sq ft) Up to $3.15 psf

Deli (1,500 sq ft) Up to $1.50 psf

Please show me your work to answer these questions, highlight your answers.

What is the Op Ex for year one?
What will each tenant reimburse in year one?
At the end of year one, what will be the unreimbursed amount?

Can you teach me how to work this out in excel?

Expert Solution

ekkarill92 answered 1 year ago

Revenues $300,000 Less operating expenses: Rent $169,000 Insurance 15,000 Depreciation 46,000 Maintenance 20,000 250,000 Net operating...

Revenues $300,000 Less operating expenses: Rent $169,000 Insurance 15,000 Depreciation 46,000 Maintenance 20,000 250,000 Net operating income $ 50,000 1. A company has estimated the annual revenues and expenses for a project it is considering (listed above) that will cost a total of $500,000, have a ten-year useful life, and has a salvage value of $40,000. The company requires a payback period of 5 years or less. Using the information above, what is the expected annual cash flow for this...

A firm purchased a three-year insurance policy for $13,500 on July 1, 2019. The $13,500 was...

A firm purchased a three-year insurance policy for $13,500 on July 1, 2019. The $13,500 was debited to the Prepaid Insurance account. On December 1, 2019, a firm signed a contract with a local radio station for advertising that will extend over a two-year period. The firm paid $36,000 in advance and debited the amount to Prepaid Advertising. Prepare end-of-month adjusting entries for each of the above situations.

Explain & Show Work: Georgia Office Supplies recently reported $12,500 of sales, $7,250 of operating costs...

Explain & Show Work: Georgia Office Supplies recently reported $12,500 of sales, $7,250 of operating costs other than depreciation, and $1,250 of depreciation. The company had no amortization charges and no non-operating income. It had $8,000 of bonds outstanding that carry a 7.5% interest rate, and its federal-plus-state income tax rate was 40%. The firm had 1000 shares outstanding a) How much was the firm's taxable income, or earnings before taxes (EBT)? b) What is the firm’s EPS assuming a...

Georgia Office Supplies recently reported $12,500 of sales, $7,250 of operating costs other than depreciation, and...

Georgia Office Supplies recently reported $12,500 of sales, $7,250 of operating costs other than depreciation, and $1,250 of depreciation. The company had no amortization charges and no non-operating income. It had $8,000 of bonds outstanding that carry a 7.5% interest rate, and its federal-plus-state income tax rate was 40%. The firm had 1,000 shares outstanding. 1) How much was the firm's taxable income, or earnings before taxes (EBT)? EBT = $12,500 - $7,250 - $1,250 - (.075 x $8,000) =...

Which one of the following accounts is closed at year-end? Multiple Choice Prepaid insurance Office supplies...

Which one of the following accounts is closed at year-end? Multiple Choice Prepaid insurance Office supplies expense Accumulated Depreciation Unearned revenue

The ACME company has purchased some office furniture costing $13,500 and is expected to have a...

The ACME company has purchased some office furniture costing $13,500 and is expected to have a salvage value of $2,000 at the end of 7 years. (a) Compute the depreciation for each of the years of its life using: (i) SYD, (ii) DDB, and (iii) MACRS method (life for furniture in MACRS is 7 years) (b) Compute the NPV of the depreciation schedule for each of the three methods using i = 10%. (c) Considering the NPV values, which method...

Kennedy Company reports the following costs and expenses in May. Factory utilities $ 13,500 Direct labor...

Kennedy Company reports the following costs and expenses in May. Factory utilities $ 13,500 Direct labor $79,100 Depreciation on factory Sales salaries 48,400 equipment 12,650 Property taxes on factory Depreciation, delivery trucks 3,800 building 2,500 Indirect factory labor 48,900 Electrical upgrade, factory 1,300 Indirect materials 70,800 Factory repairs 2,000 Direct materials used 157,600 Advertising 23,000 Factory manager's salary 8,000 Property taxes, home office 2,640 Instructions From the information, prepare schedules to determine the total amount of: Manufacturing overhead. Product costs...

Littleton Medical Center (LMC) has three service departments(accounting, HR, and Janitorial/maintenance) and two patient units:...

Littleton Medical Center (LMC) has three service departments (accounting, HR, and Janitorial/maintenance) and two patient units: hospital and an outpatient clinic. The following table summarizes the Operations of LMC for the last fiscal year.Service DeptService Dept CostHR$1,750,000Accounting$1,450,000Janitorial/Maintenance$2,500,000These Department Costs are allocated to the two patient units (hospital and clinic). The following table summarized the allocation based used to allocate each service department and the utilization of each allocation base. Service Departments Patient UnitsService Depts HR Acctg Jan/Maint Clinic Hospital Allocation...

Wildhorse Company has other operating expenses of $338400. There has been a decrease in prepaid expenses...

Wildhorse Company has other operating expenses of $338400. There has been a decrease in prepaid expenses of $15000 during the year, and accrued liabilities are $22600 larger than in the prior period. Using the direct method of reporting cash flows from operating activities, what were Wildhorse's cash payments for operating expenses?

In the current year, Riflebird Company had operating income of $220,000, operating expenses of $175,000, and...

In the current year, Riflebird Company had operating income of $220,000, operating expenses of $175,000, and a long-term capital loss of $10,000. How do Riflebird Company and Roger, the sole owner of Riflebird, report this information on their respective Federal income tax returns for the current year under the following assumptions? If an amount is zero, enter "0". a. Riflebird Company is a proprietorship (Roger did not make any withdrawals from the business). Roger reports $ net operating profit and...

Question