Determine and to tally the total expenses

Assignment Help Finance Basics
Reference no: EM131317229

Research the property you selected in your Local Real Estate Opportunities activity.

Using the newspaper listing from your exploration, either go online to the real estate agency that is listing the property or contact the real estate agent to do the following:

Obtain the current asking price.

Ask whether the seller would entertain an offer below the offering price, and if so, what would be a reasonable offer.

Obtain at least three comps for the property in which you are interested. Note. A comp is a property that has recently been sold and is similar to the property you are considering in terms of location, size, and characteristics. Determine the actual selling price for the three comps.  

Using the comps, the judgment of the real estate agent, and your personal judgment estimate the amount for which you could purchase the property.

Using mortageprofessor.com or another mortgage calculator, calculate your monthly financing costs (your mortgage) assuming closing costs of 5%, a down payment of 30%, and a 30-year fixed rate mortgage with an interest rate of 6%. Input this financing cost on the attached spreadsheet.

Estimate the current operation costs, including the following:

Insurance

Utilities

Electricity

Gas

Water and sewer

Telephone

Internet

Property taxes

Association dues

Maintenance costs

Refuse removal

Lawn and grounds costs

Other expenses associated with operating or living in the property

Input these costs on the attached spreadsheet.

Complete a Microsoft® Excel® spreadsheet to determine and to tally the total expenses associated with this property.  And, compute the following using the spreadsheet. Be sure to provide a narrative summary right on the spreadsheet as to the following questions.

How much would you have to charge in rent to break even each month, assuming the residence is occupied for the entire year?

How much rent you would have to charge to earn a 10% profit.

How much rent you would have to charge to earn a 20% profit.

Reference no: EM131317229

Questions Cloud

What kinds of columns used in the design of the parthenon : What kinds of columns were used in the design of the Parthenon? Which artist used memories of his or her childhood in North Carolina to create a collage
The cost of the preferred stock : A firm has issued 8 percent preferred stock, which sold for $100 per share par value. The cost of issuing and selling the stock was $5 per share. The firm's marginal tax rate is 40 percent. The cost of the preferred stock is
Rate of return to the swiss investor : The exchange rate at that time was 1.420 Swiss francs per dollar. Today, at maturity, the investor receives $10,000 and the exchange rate is 1.324 Swiss francs per dollar. What is the rate of return to the Swiss investor?
What is the after-tax cost of new debt : Dorky Duke Co. is issuing a $1,000 par value bond that pays 8.5% interest annually. Investors are expected to pay $1,100 for the 12-year bond. Porky will pay $50 per bond in flotation costs. What is the after-tax cost of new debt if the firm is in th..
Determine and to tally the total expenses : Complete a Microsoft® Excel® spreadsheet to determine and to tally the total expenses associated with this property.  And, compute the following using the spreadsheet. Be sure to provide a narrative summary right on the spreadsheet as to the follo..
Identify any areas where the business may be at disadvantage : Create and deliver your product or service to your customers. Assess each activity's contribution to competitive advantage through cost or differentiation. Identify any areas where the business may be at a competitive disadvantage.
Show the minimum number of prime implicants needed : For each Karmaugh map in figure 3.16, show the minimum number of prime implicants needed to cover all the 1s in the function. Indicate any hazards that are present if only the prime implicants that you identified are used.
Second opinion and hires dan as a consultant : Upon seeing such a high IRR, the mayor of Detroit seeks a second opinion and hires Dan as a consultant. Dan is an aquarium expert and believes that Detroit's aquarium will only generate $1 million in cash flows for the first three years in operation,..
Mp fixed operating costs : Maxine's Pumps or MP sells bilge pumps for $355 each. Each pump costss $255 to produce, and MP's fixed operating costs equal $700,000. What is MP's operating income (NOI) when 10,000 pumps are sold?

Reviews

Write a Review

Finance Basics Questions & Answers

  What should be the average beta of the new stocks added

What should be the average beta of the new stocks added to the portfolio? Round your answer to two decimal places.

  Financial measurements in manufacturing

The PQ Piston Plant makes two sizes of pistons for reciprocating engines. Their plant has 4-machines. Currently, the demand for their products is 100 'p" pistons every week,

  What premium and cost-sharing subsidies will be available

what premium and cost-sharing subsidies will be available to individuals?

  Determine the maturity risk premium for the thirty-year bond

If inflation is expected to average 1.5 percentage points over both the next ten years and thirty years, determine the maturity risk premium for the thirty-year bond over the ten-year bond.

  Te cash is available in 2 days on average 1 calculate the

float measurement. on a typical day abc company writes checks totaling 3000. these checks clear in 7 days.

  Management of it computers

Currently the spot exchange rate is FF100/$ and the three months money market interest rate is 7% per annum in the US ,and 6% per annum in France. The management of IT computers decided to use the money hedge to deal with this France account paya..

  Unique challenges to communicating with groups

Analyze how communication in groups differs from individual communication. Are there unique challenges to communicating with groups? Provide examples. Use at least one resource to support your key points. Response should be 250-300 words.

  Compute the effective annual percentage rate of the loan

Interest for the entire 2-year period must be prepaid; that is, the loan’s total interest payments must be made at the same time the loan is granted. Mucklup is required to repay the entire $200,000 principal balance at the end of the 2-year period. ..

  Office plus sells its main product ergonomic mouse pads for

office plus sells its main product ergonomic mouse pads for 12 each. its variable cost is 5.20 per pad. fixed costs are

  Integration of key worldwide money market interest rates

Write a review of the article " Integration of Key Worldwide Money Market Interest Rates and the Federal Funds Rate: An Empirical Investigation."

  Relationship between the price of bonds

Explain why there is an inverse relationship between the price of bonds and the relevant interest rate.  Explain the effect of each of the following upon interest rates and upon the price of bonds:

  What would be the expected return for a self-financing

Rank all six firms by their market values. How does this ranking order the cost of capital? What would be the expected return for a self-financing portfolio that went long on the firm with the largest market value and shorted the firm with the lowest..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd