TO ALL EXCEL EXPERT !!!

To All Dear Excel Experts,

 

I am Attaching Here One File, in That Interest is to be Calculated.

Well, Put The Best Formuls in Your Knowledge, so That Lesser labour is required.

While Calculating, Pls Keep in Mind That This is Just Example, , Data is Huge, Number of Invoice & Number of Part Payments.

Do Calculate at Your Best & Attach Here.


Attached File : 33834 1077535 interest calculation.xls downloaded: 358 times
Replies (3)

No One Solved Yet ???

I did not understand a few thing there, tho I have tried, you just have to put formula for calculating interest

Hope it helps

Dear OG, 

 

You Have Just Put Formula,

You Have Considered Only Date of Payment Against Date of Invoice.

But Not Considered Payments Installments.

Because Here Payments Camed in Part Part.

so In This Case Interest is to be Calculated Accordingly.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details