Hello is anyone can help me to create daily weekly and monthly loan schedule in ms access

[Ganie]

Hello is anyone can help me to create daily weekly and monthly loan schedule in ms access.

im using excel sheet manually. is anyone can help to develop in ms access automatically.

Like
Daily payment schedule
Weekly Payment
Monthly Payment

Thank's. in advance.

 

[Pat Hartman]

Here is a recent thread that should help. You use the Pmt() function. It has several arguments. It is intended to work with the number of payments per year. I have never tried it with anything other than monthly = 12 or bi-weekly = 26 per year. Weekly would = 52, Daily makes no sense but it would b 365.

Can anyone help me out with my Loan Management Database project?

I am working on this loan Management form that records information of clients that borrows money and records their details in a database. it then has a Repayment Schedule query that list out the number of installments, the due date the outstanding balance, and the principal after the...

www.access-programmers.co.uk

 

[Ganie]

Here is a recent thread that should help. You use the Pmt() function. It has several arguments. It is intended to work with the number of payments per year. I have never tried it with anything other than monthly = 12 or bi-weekly = 26 per year. Weekly would = 52, Daily makes no sense but it would b 365.

Can anyone help me out with my Loan Management Database project?

I am working on this loan Management form that records information of clients that borrows money and records their details in a database. it then has a Repayment Schedule query that list out the number of installments, the due date the outstanding balance, and the principal after the...

www.access-programmers.co.uk

Hello Thank you,

But how can i execute this in access newbie here.
my excel table is like this.

 

[Ganie]

Hello Thank you,

But how can i execute this in access newbie here.
my excel table is like this.

Ongoing Balance

35830

Cash on Hand

10

S#

CustomerID

Name

Investor

Program

Credit Amount+Interest

Date Start

Due Date

Month

Duration

Principal

Interest

Savings

Weekly Pay

Status

1

80001

Customer 1

Investor 1

1 Week

1060

4-Jul-23

11-Jul-23

Jul.23

1 Weeks

1000

60

1060

Pending

2

80002

Customer 2

Investor 2

23 Weeks

16100

4-Jul-23

11-Jul-23

Jul.23

Week 1 (23 Weeks)

435

174

91

700

Pending

3

80003

Customer 3

Investor 3

Monthly

5500

4-Jul-23

4-Aug-23

Jul.23

1 Month

5000

500

5500

Pending

4

80004

Customer 4

Investor 1

4 Weeks

1960

4-Jul-23

11-Jul-23

Jul.23

Week 1 (4 Weeks)

375

112

487

Pending

5

80005

Customer 5

Investor 2

10 Weeks

11200

4-Jul-23

11-Jul-23

Jul.23

Week 1 (10 Weeks)

800

320

1120

Pending

7610

1166

8867

 

[Ganie]

PLease check my excel table maybe you can help me. or maybe someone is selling with the same. Thanks

 

[Pat Hartman]

Here's a sample. I posted code and arnelgp put it into a database. One or both should help. It is called an amortization schedule.

Creating an Amortisation Schedule in Access

Hi arnelgp, I have been able to add the first 2 columns i.e. Interest Paid and Principal Paid to the SQL script. However, the final column i.e. the Outstanding_Balance has failed me. Can you kindly assist with the final column i.e. Column Name: Outstanding_Balance Column Logic: For...

www.access-programmers.co.uk

 

[Ganie]

Here's a sample. I posted code and arnelgp put it into a database. One or both should help. It is called an amortization schedule.

Creating an Amortisation Schedule in Access

Hi arnelgp, I have been able to add the first 2 columns i.e. Interest Paid and Principal Paid to the SQL script. However, the final column i.e. the Outstanding_Balance has failed me. Can you kindly assist with the final column i.e. Column Name: Outstanding_Balance Column Logic: For...

www.access-programmers.co.uk

Hello,

I found this file with other thread but only limited up to 10 weeks (im getting this error)is anyone can help me to extend the weeks up to 24 weeks. Thank's in advance.

 

[Pat Hartman]

I guess you are using arnelgp's solution. I pointed out this error to him in the original thread. He hasn't been around much lately.

Are you getting the error for all variables or just some? See if you can substitute the code I posted instead.