Mortgages – Some Important Points You Need To Consider

There are many potential perils and pitfalls that a borrower can face when buying a home and taking out a mortgage. Many borrowers can fall foul of these perils due to misinformation or a misunderstanding.

Read on as we try to discover some common pitfalls facing the potential mortgage borrower.

Interest Only Mortgages

Interest only mortgages are becoming increasingly popular, especially with first time buyers looking to take that first step onto the property ladder. Although having an interest only mortgage will result in lower monthly repayments, it will not however pay off any capital owed on the mortgage.

Interest only mortgages do have there place in the market and can be extremely useful in times where money is very tight or when there is an investment vehicle in place to repay the outstanding mortgage balance at the end of the term. For most borrowers however, interest only mortgages do seem to be a false economy – no headway will ever be made into reducing the balance owed.

On the whole, an interest only mortgage should only usually be adopted on a short term basis before reverting to a Capital repayment type mortgage.

New Build Enticements

Land is a precious commodity in the UK, especially in our densely populated towns and cities. In recent times, property developers have looked to seize upon every available scrap of land in order to service the need for new homes – and of course, to make a quick buck.

The need to fill these new developments as soon as they are constructed is big one – building contractors will commonly offer special deals in order to entice prospective buyers. Such methods to entice customers will include paid up stamp duty and full or partial deposit payment.

It is important to remember in many walks of life that if a deal looks too good to be true, then it usually is – builders and developers will often factor these costs into the actual price of the house or flat.

Dont Move Home On The Weekend

This is one tip that you may have heard before however it is one that is often overlooked – Dont move home on the weekend! Moving home on a Saturday remains the most popular time with people generally reluctant to take time off work. It is the busiest time to move and also the most expensive with many removal firms and van hire companies increasing their prices accordingly.

Attempting to move house on your own can mean the stress and hassle increases ten fold – although removal firms may seem to charge very high fees, moving without their help can often mean repeated trips and lots of strained muscles.

Trust Your Own Judgement

The house buying process and securing a mortgage, to many is a very daunting prospect. It is very important to stand your ground when it comes to sticking to budget – it is typical to put in an offer below the asking price to negotiate the best price, with most sellers expecting you to do so.

By the same token, if you are selling a property, it is not common for the seller to accept the first offer they receive in pursuit of the best price. Holding out for your favoured price can often pay dividends – it is often worth trusting your own judgements.

Shop Around For Insurance

More often than not is pays to shop around for insurance policies. When taking out a mortgage, it is common for the lender or mortgage broker to peddle insurance policies that they will arrange on your behalf.

For them this means extra commission! Insurance policies such as buildings and contents insurance, life assurance and mortgage payment protection insurance to name just a few. These policies can often be arranged at a cheaper premium if you are prepared to shop around for yourself!

Look Before You Leap

Taking out a mortgage with friends or a partner is becoming an increasingly popular way of buying a home. It becomes important therefore that if you do decide to take this big step, you must be confident that you are going into it with someone you know and trust.

Relationships do however turn sour at times and if this becomes the case, then sorting out your financial predicament will be an unwanted hassle – It is important to establish at the very start exactly what should happen if things go wrong and keep a record of who has contributed what. A consultation with a solicitor could prove to be worthwhile also.

Honesty Is The Best Policy

It always pays to be honest – this becomes particularly relevant in the case of arranging a mortgage or insurance policy. Dishonest or inaccurate information could leave an insurance policy worthless and dishonestly could be seen as a fraudulent offence on a mortgage application form.

Service Desk Support Executive/ I.T.Help Desk( I.T) Freshers can apply

Designation	Service Desk Support Executive/ I.T.Help Desk( I.T) Freshers can apply
Job Description	1. Responsible for Service desk Delivery 2. Call logging / follow ups/ closures for various incidents related to various applications and OS. 3. Call escalation for the issues which are not of user end. 4. Support for various departments 5. Call logging / Assigning / Follow ups for Network, Server, Applications, CRM, Outlook related issues. 6. EOD pending tickets reports. 7. Daily MIS report. 8. Weekly Tracker 9. Service desk mails handling. 10. Vendor coordination 11. Provide First Level Support over Message Delivery System (Telephone, email) 12. Well verse with MS Office, Windows Operating System etc 13. Answer staff questions in person and via phone on all company supported applications. 14. Determine source of computer problems (hardware, software, user access, etc.). 15. Advise staff on appropriate action. 16. Serve as liaison between staff and the technology department to resolve issues. 17. Work one-on-one with staff on application projects. 18. Document resolutions for future reference. 19. Other duties as assigned. ADDITIONAL RESPONSIBILITIES 1. Perform hardware and software installations. 2. Provide on-the-job training to new department staff members. 3. Provide computer orientation to new company staff. KNOWLEDGE AND SKILL REQUIREMENTS 1. Good command over written & verbal communication 2. Accept requests for assistance or problem reports from users 3. Obtain necessary information from users to adequately describe the request or problem report 4. Directly respond to the request or problem if within own areas of expertise 5. Complete information on problem reports that were solved personally and close report in problem tracking system 6. Direct the request or problem to the most appropriate support area (e.g., Networks, Telecom, Software, dialer etc) 7. Liaison with user to ensure that requests or problem reports have been satisfactorily handled Reports 8. Good basic working knowledge of Microsoft Windows, Office and any other common desktop tools
Desired Profile	Freshers who want to make a career in the I.T. function can apply Good Verbal Communication Skills Good Working knowledge of Microsoft Windows SHOULD BE OPEN TO WORK IN SHIFTS / NIGHT SHIFTS   Graduation Not Required Functional Area: Information Technology   SALARY :  Rs.50,000 —— Rs. 80,000/- CTC per annum ( Per Month salary Rs. 4500  to Max Rs. 6900/- )
Experience	0 – 1 Years
Industry Type	BPO/ITES
Role	Fresher
Functional Area	IT-Support, Telecom, Hardware
Education	UG – Any Graduate – Any Specialization,Graduation Not Required PG – Any PG Course – Any Specialization,Post Graduation Not Required
Compensation:	Rupees 50,000 – 80,000
Location	Navi Mumbai
Keywords	service desk,service desk delivery, I.T.call coordinator,I.T help desk,freshers,good communication skills
Contact	Pritam D’souza Spanco Limited 7th Floor, Viswaroop IT Park Raghuleela Mall Compounds Opp. Vashi ailway Station, ASHI MUMBAI,Maharashtra,India 400001
Telephone	022-40823000
Website	http://www.respondez.com
Job Posted	08 May

Assistant Manager / Deputy Manager Corporate Hiring ( Support Level) – 1 Opening(s)

Spanco BPO offers world-class end-to-end business process outsourcing services that can help companies achieve improved business performance. We bring together state-of-the art infrastructure, advanced technology, best people, and process excellence, to deliver services that create a real value impact on our clients business. Our service portfolio includes inbound and outbound call management and back office operations support. By customizing our services to best suit our clients’ business requirements; we help our clients achieve maximized process productivity and profitability. Spanco BPO is committed towards maximizing the value creation for its clients. To achieve this, we are constantly identifying solutions and strategies that can help us extemporize on our service deliverance towards our clients. Headquartered in Mumbai, India, Spanco BPO is the domestic BPO business of Spanco BPO Ventures Ltd.

Designation	Assistant Manager / Deputy Manager Corporate Hiring ( Support Level) – 1 Opening(s)
Job Description	Establishes a recruiting strategy by analyzing job descriptions and management feedback, customizing processes as well as staying abreast of industry trends and local labor market conditions. Recruits, interviews, screens, completes reference checks and makes hiring decisions in collaboration with local management at the Agent and Supervisor level. May consult with hiring manager regarding potential candidates and assists them in their final decision at the Agent/Supervisor level. Finalizes offers in accordance with employment and compensation policies. Processes appropriate paperwork. Identifies creative sources for recruiting qualified candidates through a variety of continually expanding means to include database, internet, newspaper advertising, job fairs, professional organizations, community agencies, and colleges. Strategize with business unit to determine other possible sources Works with hiring manager to customize and conduct Behavioral Based interviews Acts as liaison between search firms and hiring managers Requires Excellent Communication skills and must be well versed with all the Empployment Job Portals, Professional Networking Sites, Ability to manage internal databank of potential candidates, sound coordination skills, strong skill sets verification ability, create / release Hiring Performance dahsboards, etc. Requires extensive working hours and the candidate must be willing to put in extra efforts. Will Report to National Head Resourcing and will also be responsible to assist in all Leadership Appointments at the Organization.
Desired Profile	A Graduate ( preferably MBA from a reputed Business School) with strong Communication skills and experience in large Organization. Must have Relevant / Strong Experience in Leadership Hiring ( Support Positions) with a large organization. Experience of Hiring in BPO outfit will definitely be an added advantage. Candidates with strong Experience from Search Firms will also have an advantage. Should be able to analyse the industrial trends, capture intelligence inputs, data benchmarking, ability to hold communication with applicants, and should be willing to manage this role on a PAN India basis.
Experience	4 – 5 Years
Industry Type	BPO/ITES
Role	Recruitment Mgr
Functional Area	HR / Administration, IR
Education	UG – Any Graduate – Any Specialization PG – MBA/PGDM – HR/Industrial Relations
Compensation:	Rupees 3,50,000 – 4,75,000
Location	Gurgaon
Keywords	Corporate Hiring, Talent Acquisition and Development
Contact	Gajendra Singh Saini Spanco Limited
Telephone	9811887078
Email	gajendras@spancobpo.com
Website	http://www.spancobpo.com
Job Posted	28 May

JAVA – Turing Softwares, Product Software Company, Coimbatore

Instituted in 1997 Develops System solutions for FORTUNE 500 clients. Division of Mettler Toledo Inc. (manufacturer of precision measuring and weighing devices) since 2003. Specializes in embedded development using WINDOWS tools (VC++, C#) and JAVA.

Designation	JAVA – Turing Softwares, Product Software Company, Coimbatore
Job Description	Understand embedded devices, design real-time solutions and create fail safe code
Desired Profile	Experienced Software Engineer, with 2+ years of development of software systems in JAVA.Experience in analyzing & designing software systems. Experience in using UML notation and tools. Development work on Embedded Systems, Networked systems, OOT systems. Strong Analytical and Problem Solving skills. Excellent communication skills.   Job Location : Coimbatore, Tamilnadu, South India.   Intrested candidates please forward your resume to our email id hrd.exec mt.com or contact 0422 4366679 / 4366680 – Extn : 112
Experience	2 – 6 Years
Industry Type	IT-Software/ Software Services
Role	Software Developer
Functional Area	System Programming
Education	UG – B.Tech/B.E. – Computers, Electronics/Telecomunication PG – M.Sc,M.Tech – Computers, Electronics/Telecomunication,MCA – Computers
Compensation:	Salary increments commensurate with performance in company
Location	Coimbatore
Keywords	JAVA, MNC, system solutions, product software, software engineer, senior software engineer, embedded systems
Contact	J. Prabha Turing Software Pvt Ltd
Telephone	91-422-4366679
Email	hrd.exec@mt.com
Website	http://www.turingsoft.com, http://www.mt.com
Job Posted	27 May

Senior Member Technical Staff(Linux/UNIX Kernel,File system)

NetApp creates innovative storage and data management solutions that help accelerate business breakthroughs and deliver outstanding cost efficiency. Our dedication to principles of simplicity, innovation, and customer success has made us one of the fastest-growing storage and data management providers today. Customers around the world choose us for our “go beyond” approach and broad portfolio of solutions for business applications, storage for virtual servers, disk-to-disk backup, and more. Our solutions provide nonstop availability of critical business data and simplify business processes so you can deploy new capabilities with confidence and get to revenue faster than ever before. You can rely on our industry-leading solutions to lower the cost of protecting your data, business, and reputation. We bring together the industry’s best partners and technology to deliver services that help you maximize what you are getting from your infrastructure. Our collaborative approach, working as one team with one goal, means that you get a solution that is just right for you—on time and on budget. To support your global business, we provide highly-responsive support in local languages. From London to Austin, from Bangalore to Tokyo, we’ll work with you to solve your problems and help you reach your goals. Discover our passion for helping companies around the world go further, faster at www.netapp.com.

Designation	Senior Member Technical Staff(Linux/UNIX Kernel,File system)
Job Description	Job Summary As a senior technical member of the Data Protection engineering team, responsible for architecting and implementing the next generation disk based data protection & compliance solutions for NetApp. The job presents unique opportunities to design & develop futuristic products and to work with the best of breed engineers in the storage industry. Essential Functions • Be a thought leader • Work as a member/lead of the team on projects involving existing and new data protection features • Participate in any/all phases of a product development cycle: from product definition and design, through implementation, debugging, unit testing and early customer support • Engage in technical communication with other parts of Network Appliance including product management, customer support and sales • Work collaboratively with other engineers and cross functional teams to achieve aggressive goals without compromising quality • Conduct performance and reliability analysis • Provide sustenance support including customer escalations • Take on ‘stretch’ assignments that influence the team, department and company’s bottom line
Desired Profile	Requirements • Strong communication skills, both written and oral, are essential. Communications will targeted at a wide variety of internal and external audiences • Must have in-depth knowledge and experience in OS (Unix) kernel, file system and storage • Must have competency and proven track record of delivering complex technical projects through leadership, meeting tight deadlines without sacrificing quality • Must have ability to translate product roadmap into technical deliverables • Must be proficient in computer architecture, data structures and programming practices • Must have full commitment to sound software engineering principles, practices and standards • Must have strong passion for new technologies • Must have demonstrated use of creative approach to problem solving • Expected and assumed: independence, drive, motivation, willingness to go above and beyond, flexibility, and cooperative spirit • Must have high level of proficiency in C language • Database development experience is highly desirable • Know-how of NDMP protocol is highly desirable • Experience in Object Oriented Programming in C++ is a plus • Knowledge of contemporary backup and recovery products, principles and techniques is a plus Responsibilities and Interaction • As a senior member in the team the person will be required to act as a mentor to an individual or group of highly motivated, technically brilliant engineers with varying experience level • Responsible for engineering tasks which may not always be well defined or structured • Apply experience and acquired knowledge in solving problems that are complex and require in-depth analysis • Demonstrate good judgment in solving problems, provide possible approaches. Identifying problems proactively • Work effectively with members in the management, across functions and external parties • Contribute actively to product roadmap and architecture. Established subject matter expert • Demonstrate results through leadership and influencing skills • Self-driven. Set priorities, operate and drive results independently Education and Experience• Minimum BE/B-Tech/BS CS/CE (M-Tech,MS, PhD. CS/CE preferred ) • Typically 8 to 12 years of relevant experience. Minimum of 3 years is required- Demonstrated ability to have completed multiple, complex technical projects.
Experience	7 – 12 Years
Industry Type	IT-Software/ Software Services
Role	Outside Technical Consultant
Functional Area	Application Programming, Maintenance
Education	UG – Any Graduate – Any Specialization PG – Any PG Course – Any Specialization
Location	Bengaluru/Bangalore
Keywords	System,kernel,unix
Contact	R Manjari
Job Posted	27 May

Network Administrator at NetApp in Bengaluru/Bangalore

NetApp creates innovative storage and data management solutions that help accelerate business breakthroughs and deliver outstanding cost efficiency. Our dedication to principles of simplicity, innovation, and customer success has made us one of the fastest-growing storage and data management providers today. Customers around the world choose us for our “go beyond” approach and broad portfolio of solutions for business applications, storage for virtual servers, disk-to-disk backup, and more. Our solutions provide nonstop availability of critical business data and simplify business processes so you can deploy new capabilities with confidence and get to revenue faster than ever before. You can rely on our industry-leading solutions to lower the cost of protecting your data, business, and reputation. We bring together the industry’s best partners and technology to deliver services that help you maximize what you are getting from your infrastructure. Our collaborative approach, working as one team with one goal, means that you get a solution that is just right for you—on time and on budget. To support your global business, we provide highly-responsive support in local languages. From London to Austin, from Bangalore to Tokyo, we’ll work with you to solve your problems and help you reach your goals. Discover our passion for helping companies around the world go further, faster at www.netapp.com.

Designation	Network Administrator
Job Description	Job Summary: As a Network Administrator you will work as part of a highly technical team of professionals who support the heterogeneous Network across sites with complex networks. You will utilize your strong technical background and related experience to positively contribute to the department’s goals and vision for advancing NetApp’s network systems infrastructure. To be successful you will need a strong technical orientation; be a creative problem solver; have excellent customer service skills; have a desire to advance in the field; and work well in a team-oriented environment. Essential Functions: The Network Administrator 3 works as part of Engineering Support team towards Design, Develop & manage the Networks in the Labs & Engineering Datacenters. The Network Administrator would also provide support for network servers in the Labs & Engineering Datacenters including general administration and management. The specific areas of responsibilities include: - Perform monitoring and maintenance of overall NetApp Engineering Lab network systems and applications. - Provide troubleshooting for assigned level, operating system upgrades, capacity planning and provisioning on a daily basis. - Update process documentation and team websites as required. - Provide analysis of performance while identifying issues and working with more experienced team members for resolution. - Manage load configurations and provide recommendations for improving performance. - Work with Senior team members on review of entire environment and executing initiatives to reduce failures, defects and improving overall performance. - Communicate with internal customers, peers, and managers regarding network systems administration issues. - Manage equipment tracking (e.g. consoles, cables etc.) - Perform change controls. - Provide instructions and guidance on best practices to junior members of the team. - Use scripting languages to automate tasks and gather data. - Communicate with internal customers, peers, and managers regarding network administration issues, and recommend solutions.
Desired Profile	Requirements: - Strong oral and written communication skills; including documentation. - Ability to work collaboratively within Engineering Support team to support deadlines; ability to work independently as well. - Ability to work collaboratively with the cross functional teams. - Ability to handle multiple complex tasks, with tight deadlines concurrently. - Strong interpersonal and leadership skills. - Demonstrated ability to perform well in a dynamic environment. - Advanced knowledge of networking systems. - Efficient user of Microsoft Office tools including Excel, Work, Outlook and Visio - Ability to follow and adhere to policies, procedures and standards relating to Systems management. - Ability to work a 24×7 on-call rotation schedule. Responsibility and Interaction: Responsibility: - The tasks this individual is responsible for are often non-routine and unstructured, requiring creative solutions. - This individual will apply attained experiences and knowledge in solving routine to moderately complex problems. - This individual will focus on the future expansions, Capacity Planning, etc. Interaction: - This individual must work effectively with Staff to Vice President level employees within the function, and the technical team on assigned projects. There may be communication with employees in other functions as required. - Limited management direction is provided to employee on new projects or assignments as well as review of activities and priorities. - The ideal candidate will be a proactive contributor and subject matter expert on team projects. - To be successful, this individual must demonstrate favorable results through coaching and influencing others Education & Experience:- A minimum of 5 years of experience is required; 6 to 8 years of experience is preferred. – A Bachelor of Sciences Degree in Electrical Engineering or Computer Sciences, or related technical field is required; or equivalent experience.- Demonstrated ability to have completed multiple, moderately complex technical tasks
Experience	3 – 8 Years
Industry Type	IT-Software/ Software Services
Role	Network Admin
Functional Area	Network Administration, Security
Education	UG – Any Graduate – Any Specialization PG – Any PG Course – Any Specialization
Location	Bengaluru/Bangalore
Keywords	network admin
Contact	R Manjari
Job Posted	17 May

Your Real Estate Business – A Facebook Secret Exposed

Getting your real estate business in front of a massive crowd can be expensive especially if you are using Google AdWords. Used incorrectly your Google AdWords campaign could be costing you $7 – $8 per click. But you do have an alternative and it’s much cheaper. Enter social media and in particular Facebook.
 
With over 350 million accounts, Facebook offers you an ever increasing audience to market your business in. On average, a Facebook user spends 21 minutes per visit on Facebook; triple the time spent on Google search.

Knowing this it’s imperitive that you start getting yourself in front of as many Facebook users as possible. The fastest way to do this is to start your own Facebook Fan Page. With over 8 million Facebook Fan pages starting daily there’s no time to waste.

Facebook Fan pages are the way of the future and here’s why:

1. A Blog On Heat

Blogs are great but their environment is a little closed. There’s no great viral effect without effective marketing. The average Facebook user has 100+ friends. When you add content via your Facebook page it appears on your friends pages as well. Once they share your information, your message goes viral.

Simply add the Facebook Connect widget to your blog and you’ll soon be giving your traffic a boost. Facebook also has a tool called Facebook Fanbox which you can also add to your blog.

So if people are logging into their Facebook account a couple of times a day they get to see your content. It’s difficult to get people logging into your blog more than once a day.

2. Getting Recommended

You know that the best sale is one that’s referred to you. Having a fan page can make this easier. Your recommendations go out to your friends and they can accept or ignore without the obligation felt via direct email. Fan pages offer a less obtrusive approach to getting recommended.

3. Don’t Market, Engage

Don’t fill your fan page with marketing hype. This is the quickest way to have people unsubcribe from you. Build a relationship first. Engage with them. On average it takes people 7 interactions before they buy from you. Keep your page social and watch your list grow.

4. The Money Is In The List

Most blogs have a capture form on their front page so the owner can build a list. Facebook Fan pages has the same feature. Now when people log into your page a few times a day, you also have the opportunity to add them to your personal email list.

Now the future of email marketing is always under the spotlight so it’s important to build your list within Facebook at the same time. A bit of a protective plan just in case email marketing goes pear shaped ove the next 10 years or so. And remember our Gen X & Y friends are not big email marketing users and prefer the instant messaging features of Facebook and other social media forums.

5. Taking it Away

Facebook fan pages also give you the option of creating time scarcity through your updates. This is not possible or less effective on blogs because of the long time delays.

But with your fan page you can create urgency by including a time countdown in your updates for an upcoming launch or display limited seating for a webinar etc.

This keeps your friends engaging with you as well as building excitement via your page.

I think you’d have to agree, having a Facebook Fan page is a great tool in building your profile using cost effective (cheap!) viral marketing.

Grab your today and stay ahead of the pack. You’ll be way ahead of the rest of the online community.

How to Set Up Your Real Estate Social Networking Plan

Jumping into the real estate social networking scene is like jumping into the middle of the ocean without GPS or a compass. Without a map, you won’t know which way to start paddling and no way to control how to get there. That is why having a Real Estate social networking plan should be a vital part of your real estate SEO strategy.
 
What kind of plan do you need? Your Real Estate social networking plan doesn’t need to be novel-length. But it should have the necessary ingredients to keep you on track to building a successful network and ultimately customers.

Here is a basic RealEstate social networking plan that you can start using today.

Determine Goals and Outcomes

Before you begin creating your plan, you need to know what you want to achieve. Are you looking to build a client base through Real Estate SEO efforts? Do you wish to network with other Real Estate professionals? Perhaps your goal is to establish your expertise in your real estate niche.

You will also need to determine where your intended audience will be. Will you be looking for networking contacts on Facebook? Are you looking to attract clients through YouTube? Or maybe get a following of Real Estate professionals on Twitter?

Set Up Your Website

If you have not already, you must get a web presence published. Your Real Estate social networking plan will have no “home base” without a website. It is best to set incorporate a blog feature in your website. Your blog and regular updates, articles, and features will be part of your pillar of expert content to where you will lead followers from social media.

Set Up Social Media Accounts

It’s time to get connected with social media communities. You should have researched which online communities will suit your Real Estate social networking goals. Set up your professional accounts. On Facebook, be sure yours is a business page where you can gather fans to follow your social media movements. Hook up to Twitter and other places that will reach your intended audience. Be sure to provide a link to your website in your profile with each account.

Get News Results

What do you have to say? It should be pertinent and timely, and be in the current interest of your intended followers. Set up Google Alerts on specific Real Estate SEO keywords. Also get your ear to the ground on social topics through WhosTalkin.com.

Engage

Each day, browse through your results and find a topic or two that is of current interest. Write a blog or an article. Post questions and links on your social media and engage conversation and response. Your Real Estate social networking depends on the quality of interest and engagement you can generate. Get involved!

Your real estate social networking plan should follow the above guidelines. Take a look at your plan and improve your Real Estate SEO through social media today.

Take advantage of the power of real estate SEO today through RealtyRanking.com’s helpful resources, services, and real estate social networking community.

Financial Analysis of the Deal: A Real Estate Investor’s Most Important Skill?

Rather than just give you my analysis spreadsheets, my objective with this article is to show you how to develop your own.  It is critical that you learn how to do so if you are to succeed at real estate and I want to encourage you to begin “playing” with Excel as soon as possible.  This will be far more beneficial to you than giving a cursory glance to someone else’s work because it is easy enough to understand.  Consider this a case of teaching you how to fish and feeding you for a lifetime rather than giving you a fish and feeding you for a day.

You see, chances are my spreadsheets would not even be suitable for you because I am likely using a different investment methodology.  Even if we are both using a similar technique there could be small differences based on our respective financing or some other aspect that means it doesn’t quite fit.

But more important than any of that is this:

I have found that the greatest benefit of developing your own analysis spreadsheet is that you become intimately familiar with the numbers.  By the time you’ve developed it and used it a few times you understand the numbers inside out and upside down and have a thorough understanding of what numbers are most important and what effect certain adjustments will have.

 

You should always use your spreadsheet but the funny thing is that once you’ve gone through this process you actually don’t need it as much because you have such a thorough understanding of what numbers will work for you and your market.  What could be more valuable to a real estate investor than that sort of innate knowledge?

The PMT Function in Excel

Before we get into it you need to familiarize yourself with the PMT function and it’s variants in Excel.  PMT stands for “payment” and is a variable in a set of functions related to loans.  The variables in this set of functions are:

•PMT – payment
•PV – present value
•Rate – interest rate
•Nper – number of periods
•FV – future value
•Type – payments due at start or end of periods

One thing to be aware of is that the interest rate must be for the same time period as the payment.  So if the payments are monthly you must remember to divide the annual interest rate by 12 when you put it in this equation.

Inputs and Outputs

In designing your spreadsheet you need to think about what inputs and outputs you will need to evaluate a deal.  This needn’t be very difficult.  You can just begin listing variables down the left-hand column and you will soon figure out what other information you need as you go.  Then you can drag and drop stuff to rearrange it later.

But as a primer here is a list of things that you could include as inputs:

•Property Address
•Value
•Price
•Closing Costs (can estimate as % price)
•Percent Finance
•Down Payment
•Amount Borrowed
•Term of Loan (years)
•Number of Repayments per year (needed for PMT function)
•Loan Interest Rate
•Management Fee
•Repair Costs
•Expected Rent
•Vacancy Rate

The output we are looking for is, of course, some form of return on investment.  I’m generally looking at cash-on-cash return (CCR) which is the return on the cash that I put into the deal (not the price of the property).

CCR = net annual cash flow / cash invested
If you have a private investor you would also include an analysis of their cash-on-cash return since the deal must work for them too.

Ultimately though, you can use this spreadsheet to adjust various inputs so that you CAN meet your desired return.  In other words, if your desired CCR is 30% you can adjust various inputs to determine what price you should offer on a property in order for it to be a viable investment.

You would probably also include some other key numbers in a tidy Evaluation Report such as:

 

•down payment

•closing costs

•total investment

•monthly income

•monthly expenses

•net cashflow

But once again the numbers you display will depend upon your investing methodology.  These are more typical of a cashflow investor than a flipper.

What-if Analysis

And finally, you can use your completed spreadsheet to run various what-if analyses.  For example, what if:

•you get a higher (or lower) LVR (loan-to-value) ratio loan?

•interest rates increase?

•your investor increases the down payment?

•you charge the tenant a greater option fee?

•you change the term of the loan?
•you reduce your management fees?
•you reduce your closing costs?
You can see what I’m getting at.  Once you have a working model you are armed with some very powerful information.

The Layout
I’ve included this screen capture of one of my spreadsheets just to give you some layout ideas.  Please do not try to model your spreadsheet exactly from this one.  This is for a very specific investing methodology and many of the fields will not make sense for your siutation.

However, I just wanted to show how I divide the spreadsheet into:

•input area at the top (where yellow fields are inputs and blue fields are calculated)
•brief “Deal Evaluation” report at the bottom with some of the key outputs I mentioned earlier (for a cashflow investment)
•a “What-If” tool in the top-right corner
Possible Spreadsheet Layout
I hope I’ve given you enough information to just start playing with a spreadsheet and figure this out for your situation.  If you have specific questions or difficulties just come back here and use the comment field below.  Either I or one of your fellow readers should be able to help you out.

Real Estate Investing Vs. The Stock Market – A good analysis

Today’s investment markets offer investors a wide variety of options. One of the most rewarding opportunities is real estate investing, which can produce a very good income stream. If you choose to become a real estate investor, you will enjoy several benefits not associated with other types of investment.

First of all, investing in real estate has the enormous benefit of financial leverage.  Even if you borrow the money for your real estate investing from a bank you can often get into a deal with a 10% down payment which means your returns are instantly magnified due to the fact that you are earning on the bank’s 90% contribution as well.  As an example, let’s assume you have $10,000 to invest and you get 10% return on your investment regardless of the vehicle.  If you put it into the stock market you will buy $10,000 worth of shares and after 12 months your investment is worth $11,000.  If you put that same money into real estate with a 90% loan you earn 10% on the full $100,000 investment and finish with $110,000.

 

So your $10,000 has been doubled in the real estate investment above whereas it only produced an extra $1,000 in the stock market.  Why?  Because your lender’s money has been working for you too.  This is the power of leverage and is one of the biggest advantages of real estate investing.  And yet there are even more reasons to become a real estate investor as you will see.

Another incredible reason to begin investing in real estate is the tax benefits. One of the best tax breaks of real estate investing is the REQUIRED depreciation by the IRS on the property.  This represents a “paper loss” when in most cases the property (including the land) is actually appreciating.  So in essence you pay taxes on a reported profit figure that is significantly lower than your actual earnings – very nice.

 

Perhaps an even better tax benefit is the 1031 exchange as defined by section 1031 of the Internal Revenue Code.  Essentially this allows investors to delay paying any capital gains taxes when a property is sold as long as the proceeds are reinvested in an appropriate property.  The government is basically encouraging investors to stay in the market with this fantastic incentive.

One final benefit of investing in real estate worth mentioning here is the flexibility of sale contracts.  Unlike the stock market you can get very creative with your offers.  You can exchange virtually anything for a property instead of cash which can mean greater returns and some spectacular win-win arrangements.

Next Page »