amortization schedule

J

Joe Schmoe

Anyone have any code for creating an amortization schedule (ie forms and
reports)?


Thanks in advance
 
S

Steve

I see you did not get any response. I provide help- with Access applications
for a reasonable fee. I have an MBA degree and have created several
amortization schedules. I could create one for you for a very modest fee.
Contact me if you are interested.

Steve
(e-mail address removed)
 
C

Chuck

I see you did not get any response. I provide help- with Access applications
for a reasonable fee. I have an MBA degree and have created several
amortization schedules. I could create one for you for a very modest fee.
Contact me if you are interested.

Steve
(e-mail address removed)
Click to expand...
P=(L*R/100/F)/(1-EXP(-T*LN(1+R/100/F)))
Where:
P=monthly payment
L=original loan
F=payments per year, 12 if payments are made monthly
R=interest rate, 5.123 for 5.123 percent
T=total payments to satisfy loan.

The code will work in any programming language that understands EXP as the
natural log e raised to variable x power and LN as natural log of a number.

If you can't write the code for the equation, do the work in Excel which has a
built in function.

Chuck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Auto populate value from one task to another in MS PROJECT 0
Amortization schedule with veriable payments 2
Special formulas Needed 0
need a vehicle loan amortization 3
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1
COPY ACCESS DATA FIELD TO EXCEL FIELD 0

Top