Question

Given the following information, calculate the net operating income assuming below-line treatment of capital expenditures: Property:...

Given the following information, calculate the net operating income assuming below-line treatment of capital expenditures:

Property: 10 office units,

Contract rents per unit: $2,500 per month;

Vacancy and collection losses: 10%;

Operating expenses: $52,000;

Capital expenditures: 15%.

Can you teach me how to do this on excel?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Book1 - Excel Sign in o X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share Σ A

Add a comment
Know the answer?
Add Answer to:
Given the following information, calculate the net operating income assuming below-line treatment of capital expenditures: Property:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 32. Using the following information, determine the net operating income (NOI) for the first year of...

    32. Using the following information, determine the net operating income (NOI) for the first year of operations of the subject property assuming "below-line" treatment of capital expenditures. 15 1000 Subject Property Number of apartments Market Rent (per month) Vacancy and Collection Losses Operating Expenses Capital Expenditures 10% of PGI 5% of EGI 10% of EGI A. $135,000 B. $137,700 C. $153,900 D.$162,000

  • Using the following information, determine the net operating income (NOI) for the first year of operations...

    Using the following information, determine the net operating income (NOI) for the first year of operations of the subject property using "above-line" treatment of capital expenditures. Number of units:30 Market rent per unit per month: $1,000 Miscelaneous Income per year: $5,000 V&C Loss: 10% of PGI Operating Expenses: 20% of EGI CAPX: 10% of EGI $229.000 $245,800 5230.300 $302.500

  • Total property acquisition price $4,224,000 Property consists of eight office suites, 3 on the first floor,...

    Total property acquisition price $4,224,000 Property consists of eight office suites, 3 on the first floor, 5 on the second floor Contract rents: 2 suites at $7,200 per month, 1 at $14,400 per month, and 5 at $6,240 per month. It is anticipated that rents will increase annually at the rate of 3% per year It is anticipated that vacancy and collection loss will be 10% per year Operating expenses are 40% of effective gross income Capital expenditures are 5%...

  • #1 MULTIPLE CHOICE (no need to show work but please get right) 1. A property has a net operating income of $25,000 and the capitalization rate used in the market is 10%. What is the indicated value? a...

    #1 MULTIPLE CHOICE (no need to show work but please get right) 1. A property has a net operating income of $25,000 and the capitalization rate used in the market is 10%. What is the indicated value? a) $250,000 b) $300,000 c) $325,000 d) $2,500,000 2. A property sold for $555,000. The buyer anticipated that the potential gross income (PGI) would be $93,000, the vacancy would be 5%, and expenses would be 35% of the effective gross income (EGI) in...

  • Use the information provided below to estimate the market value of the office building that has been described. Type of...

    Use the information provided below to estimate the market value of the office building that has been described. Type of Property: Office Building Leasable Space: 100,000 square feet Average Rent: $20.00 per square foot per year Expected Rent Growth: 4.50% per year Vacancy and Collection Losses: 15.00% of potential gross income Other Income: $1.50 per square foot per year Expected Growth in Other Income: 3.00% per year Operating Expenses: 27.50% of effective gross income Capital Expenditures: 2.50% of effective gross...

  • Use the information provided below to estimate the market value of the office building that has...

    Use the information provided below to estimate the market value of the office building that has been described. Type of Property: Office Building Leasable Space: 100,000 square feet Average Rent: $20.00 per square foot per year Expected Rent Growth: 4.50% per year Vacancy and Collection Losses: 15.00% of potential gross income Other Income: $1.50 per square foot per year Expected Growth in Other Income: 3.00% per year Operating Expenses: 27.50% of effective gross income Capital Expenditures: 2.50% of effective gross...

  • I need help answering these two questions by Friday this week please! Use the information provided...

    I need help answering these two questions by Friday this week please! Use the information provided below to estimate the market value of the office building that has been described. Type of Property: Office Building Leasable Space: 75,000 square feet Average Rent: $20 per square foot per year Expected Rent Growth: 3% per year Vacancy and Collection Losses: 10% of potential gross income Other Income: $1.25 per square foot per year Expected Growth in Other Income: 3% per year Operating...

  • (e) The net operating income (loss) under absorption costing is less than the net operating income...

    (e) The net operating income (loss) under absorption costing is less than the net operating income (loss) under variable costing in Year 2 because (Select all that apply.):    3. Make a note of the absorption costing net operating income (loss) in Year 2.    At the end of Year 1, the company’s board of directors set a target for Year 2 of net operating income of $70,000 under absorption costing. If this target is met, a hefty bonus would...

  • The asking price for the property is $1.000.000 rents are estimated at $200,000 during the 1st...

    The asking price for the property is $1.000.000 rents are estimated at $200,000 during the 1st year and are expected to grow at 5 percent ner vear. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35 percent of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan for 70 percent of the purchase price can be obtained at 10 percent interest rate. The property is...

  • The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first...

    The asking price for the property is $1,000,000; rents are estimated at $200,000 during the first year and are expected to grow at 5 percent per year. Vacancies and collection losses are expected to be 10% of rents. Operating expenses will be 35 percent of effective gross income. Capital expenditures will be 5% of effective gross income. A 30-year fixed rate loan for 70 percent of the purchase price can be obtained at 10 percent interest rate. The operty is...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT