Real Estate Accounting

Another Nerd Enterprises, Inc. Property

Chapter One renamed

leave a comment »

I’ve re-named the chapter to “How to get into a home you can’t afford”.

This is really about what happened to many people who got themselves into situations where they just didn’t know better. We show you how the balloon payment works as well as the neg am loan. People got in way over their heads, which was fine as long as property values kept going up. When that stopped, people got into trouble and then.. foreclosures. The banks have themselves to thank for not doing a better job of informing lenders of the risks on some of these fancy financing options they offered. Of course the borrowers could have done more due diligence!

In the chapter I walk you through how the numbers work and I show you a few difference scenarios. When I am finished there will be a place where you can click to watch a video tutorial on how to set up your effective interest table in Microsoft Excel so that you can calculate your own payments. I use this to demonstrate what people were really getting into financially when they took these financing options. If people in the past had shown you the numbers the way I am showing you now, there is a good chance many people would not have gotten into these situations and we may have been able to avoid this mess we’re in. Of course if you have the money, now is a great time to buy, but no more 100% financing, balloon payments, or negative amortization loans!

In the first video tutorial I walk you through a Microsoft Excel Tutorial on how to set up your effective interest table.

  • This lets you calculate you interest and payments for the entire term of the loan.
  • I show you how to set up the table.
  • How to write simple formulas in excel – nothing more complicated than addition, subtraction, multiplication, and division.
  • We will also show you how to format the table to look nice, which makes it easier to read and understand.
  • Finally we will demonstrate how to use the powerful goal seek command to calculate the monthly payment.

In the last section of this chapter we illustrate the following using a link to an interactive video tutorial embedded right in your E-book:

  • How to set up your books in QuickBooks as an individual home buyer.
  • How to record the purchase of your home – we’ll look at a sample purchasers final settlement statement and book the entry in QuickBooks.
  • How to calculate your monthly payments (a review of the previous video)
  • How to record your payments in QuickBooks.
  • An analysis of the Mortgage Payable and Interest expense.

It’s a GREAT first chapter walking you through the basic financial part of buying a home. Can’t wait to release this!!


Written by Seth David

November 18, 2009 at 10:31 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: