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

  As your companys risk manager you are looking for

as your companys risk manager you are looking for protection against adverse interest rate changes in five years. using

  What is standard deviation of stock i and ii respectively

The probability of a recession has increased to 30% and the probability for a normal state of economy is now 40%. The market risk premium has increased by 1% as well. What is the standard deviation of Stock I and II respectively?

  If you require an effective annual interest ratenot a

you are considering a 10-year 1000 par value bond. its coupon rate is 9 and interest is paid semiannually. if you

  The firm is considering two financing options a 7-year

xyz corporation is experiencing an average collection period of 120 days. the industry average is about 75 days. the

  There is something exciting about being a part of an

there is something exciting about being a part of an initial public offering. who can forget martha stewart banging the

  Which alternative would offer hankla higher expected return

Assume that the market's required return in five years is forecasted to be 11 percent. Which alternative would offer Hankla a higher expected return (or yield) over the five-year investment horizon?

  What is the estimation of a put choice

What is the estimation of a put choice if the time to lapse is 3 months, hazard free rate is 8%, activity cost is Rs.60 and the stock cost is Rs.70?Insight : Use put-call equality hypothesis

  Calculated value of the investment

FIN 540 - Basic Financial Tools: A Review. You plan to analyze the value of a potential investment by calculating the sum of the present values of its expected cash flows. Which of the following would lower the calculated value of the investment

  What is one-year interest rate

If the unbiased expectations theory of the term structure of interest rates holds, what is the 1-year interest rate expected one year from now, E(2r1)?

  The consolidated ?nancial statements present fairly

In our opinion, the consolidated ?nancial statements present fairly, in all material respects, the ?nancial position of R&R and its subsidiaries as of December 31, 2009, and the results of their operations and their cash ?ows for the ?scal year ended..

  What are some of the government requirements imposed on a

what are some of the government requirements imposed on a public corporation that are not imposed on a private closely

  What is the value of the fund today

Your brother who is 6 years old, just received a trust fund that will be worth $24,000 when he is 21 years old. If the fund earns 0.11 interest compounded annually, what is the value of the fund today?

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