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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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