We apologize, but the forums are closed for new posts. Click Here To Join The Unemployables Facebook Group

Welcome, Guest. Please login or register.
June 23, 2021, 02:03:48 pm
Home Help Search Calendar Login Register

Welcome, Guest. Please login or register.
June 23, 2021, 02:03:48 pm
Home Help Search Calendar Login Register

Author Topic: Mortgage Pros!...Need Help With Spread Sheet  (Read 1815 times)

Offline 4EEM

  • Member
  • ****
  • Posts: 820
Mortgage Pros!...Need Help With Spread Sheet
« on: October 15, 2005, 01:48:43 pm »
I'm working a spread sheet that reflects property laddering over 30 years.  Having trouble with the amort tables.  Anyone up to it?

-Patrick
Patrick S. Lawson
Highland Lending, Inc.
Phone  (407) 877-0093
Fax      (866) 476-1133

Offline jimbojr

  • Member
  • **
  • Posts: 68
Re:Mortgage Pros!...Need Help With Spread Sheet
« Reply #1 on: October 17, 2005, 03:07:52 pm »
Hi.

I can probably help if you can better describe "laddering" as it relates to amortization.

Do you already have a spreadsheet that you're using? Let me take a look and I can make some suggestions and/or improvements.

Jimbo

Offline 4EEM

  • Member
  • ****
  • Posts: 820
Re:Mortgage Pros!...Need Help With Spread Sheet
« Reply #2 on: October 17, 2005, 03:14:30 pm »
What's your e-mail.  I will send it to you.

I'm trying to show net worth if an investor purchases a rental property and then drops all of the cash flow into an interest bearing savings account  @ 4.5% annual compounding monthly.  I factor in property appreciation at 3% and principal reduction (amortization).

Initally the investor puts 100K down.  Everytime the investors savings account reaches 100K they purchase another property using the assumption that it is just like the last.

Example:
Year 1 purchase million dollar rental 100K down
Year 3 purchase another million dollar rental 100K down
Year 5 purchase 2 million dollar rentals 100K down, etc.
Patrick S. Lawson
Highland Lending, Inc.
Phone  (407) 877-0093
Fax      (866) 476-1133

Offline jimbojr

  • Member
  • **
  • Posts: 68
Re:Mortgage Pros!...Need Help With Spread Sheet
« Reply #3 on: October 17, 2005, 03:44:20 pm »
I sent you a PM with my contact info. I'll take a look.

Jimbo

 




SMF 2.0.15 | SMF © 2017, Simple Machines