Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jun 2008
    Location
    Baltimore, Maryland, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Days of Future Printed (2003 / 2007)

    (With a nod to the Moody Blues)

    I know that the goal I am about to posit is possible. The question is, Is it practical?, as far as Word is concerned.

    Could a formula be constructed that would calculate various dates in the life of loan, one of up to a 30 year term? All calculations would be based on the same start date the day the loan settles. I would need to be able tweak it so as to calculate not only the maturity date, but also various dates along the way that the interest rate could change.

    I realize that because of calendar irregularities over successive years, this formula may need many compensatory components. If anyone has such a formula (one that could calculate the due date for a 30-year loan if the start date were populated via a field code, and that could possibly be modified to derive other dates), and would be willing to share, I would be greatly appreciative.

    Can such calculations be accomplished in Word, or would one need proprietary software akin to those used by lenders and banks?

    Thank you for any input.

    Kevin

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Days of Future Printed (2003 / 2007)

    Not sure you saw this, but assuming not, start here: <IMG SRC=http://www.wopr.com/w3timages/starpost.gif>Date Calculations in Word (2.70)

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Days of Future Printed (2003 / 2007)

    Hi Kevin,

    You can do loan calculations in Word, using field coding, but I'm not sure I'd recommend it for anything as complex as this. Still, if you want to have a go, see <!post=Post 365442 - Word Field Maths,365442>Post 365442 - Word Field Maths<!/post>
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Days of Future Printed (2003 / 2007)

    I'd use Excel - it has an extensive set of Financial Functions.

  5. #5
    Star Lounger
    Join Date
    Jun 2008
    Location
    Baltimore, Maryland, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Days of Future Printed (2003 / 2007)

    Jefferson -

    That's a lot of great information. I'll see if I can ,make sense of it... Thank you.

    Kevin

  6. #6
    Star Lounger
    Join Date
    Jun 2008
    Location
    Baltimore, Maryland, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Days of Future Printed (2003 / 2007)

    Paul and Hans -

    I assumed the task would be arduous - perhaps beyond my capacity and/or constitution. Unfortunately, as with most of the other projects about which Ive posted, this one is for a customized document used in conjunction with (and accessed through) a primary software program. Unfortunately, the program cannot interface with Excel, or any other program except Word. It may be possible to insert an Excel table into a Word document, but any information (field codes, formulas, etc.) enclosed in any kind of table will be inaccessible to the primary program, and data will not calculate or populate the document.

    I will peruse all of the information that has been provided. It is great to receive input from such knowledgeable and helpful people. Thank you to all.

    Kevin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •