# Thread: Days of Future Printed (2003 / 2007)

1. ## 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. ## 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. ## 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>

4. ## Re: Days of Future Printed (2003 / 2007)

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

5. ## 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. ## 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 I’ve 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
•