U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 04-29-2009, 08:40 PM
 
Location: Denver
690 posts, read 1,898,384 times
Reputation: 353

Advertisements

I might be completely out of luck with this question, but I thought I'd ask anyway. I have to create a lot of loan amortizations at work, so I'm trying to think of a way to automate them to save myself time.

I'm trying to create a Macro in Excel to do it right now. I have a table that the Macro can go to to look up all the interest rates, the principal balances, the starting dates, the ending dates and the payments. The problem I'm running into with that is, for instance, some loan amortizations I need will have a start date of 3/1/08 that I want to amortize to 5/1/09. But others will have different start dates. In fact, very few of them have the same start dates. I can't figure out how to create a Macro in Excel that will look up that start date and amortize every single month up to 5/1/09, because for almost every single loan, that will be a different number of months between the start date and 5/1/09. I hope that makes sense.

If no one can help me with Excel Macros, can someone answer a question about Access Macros? I've looked around, but I can't find anything written in plain English that tells me how to use an Access Macro to retrieve info from a query, and then make calculations off that info.

I know I should probably take some classes in this to know what I'm doing, but I don't have time right now. Any help to get me pointed in the right direction would be appreciated.
Reply With Quote Quick reply to this message

 
Old 04-29-2009, 09:25 PM
 
16,308 posts, read 25,264,005 times
Reputation: 8302
There is no need to invent the wheel, it has already been invented.

Excel Amortization : Excel Amortization Schedule
Reply With Quote Quick reply to this message
 
Old 04-30-2009, 02:32 PM
 
28,617 posts, read 40,594,929 times
Reputation: 37291
Excellent site. Bookmarked it. Thanks!
Reply With Quote Quick reply to this message
 
Old 04-30-2009, 07:54 PM
 
Location: Denver
690 posts, read 1,898,384 times
Reputation: 353
Thank you! One issue I have is that most of the loans I have to amortize are adjustable rates, so I wouldn't be able to use amortizations for simple interest. I think these formulas will come in handy, though.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Similar Threads
Follow City-Data.com founder on our Forum or

All times are GMT -6. The time now is 06:40 PM.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top