MHB Tracking Monthly Finance Charges for Overdue Invoices: A Spreadsheet Solution?

  • Thread starter Thread starter MHamernik
  • Start date Start date
  • Tags Tags
    Charges Finance
AI Thread Summary
A user seeks assistance in creating a spreadsheet to track monthly finance charges on 13 overdue invoices, detailing unpaid amounts, aging days, and interest rates. The goal is to calculate interest from the earliest invoice up to June 14, 2019. Responses suggest consulting an accounting firm for professional help, emphasizing the complexity of the math involved. The conversation reflects frustration with unhelpful replies and a desire for practical solutions. A clear call for relevant assistance is made, underscoring the need for effective financial tracking.
MHamernik
Messages
2
Reaction score
0
Need to set up a spread sheet that shows interest month by month on overdue payments from several unpaid (or underpaid) invoices.

I have 13 such invoices, their unpaid amounts, aging in days, and the interest rate.

Spread sheet to start from earliest invoice up until 06/14/2019. Thanks!
 
Mathematics news on Phys.org
MHamernik said:
Need to set up a spread sheet that shows interest month by month on
overdue payments from several unpaid (or underpaid) invoices.

I have 13 such invoices, their unpaid amounts, aging in days, and the interest rate.

Spread sheet to start from earliest invoice up until 06/14/2019.
Suggest you contact an accounting firm...
 
It's still a math problem ("Business Mathematics" topic is there for a reason), would appreciate it if you don't waste my time with stupid responses.
 
MHamernik said:
...would appreciate it if you don't waste my time with stupid responses.
Ok. Hope someone else here steps in and helps you. Good luck.
 

Thread 'What Exactly is Dirac’s Delta Function? - Insight'

Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...
View full post »

Thread 'Non-orthogonal bases'

Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
View full post »
Thread 'Imaginary Pythagoras'

Thread 'Imaginary Pythagoras'

I posted this in the Lame Math thread, but it's got me thinking. Is there any validity to this? Or is it really just a mathematical trick? Naively, I see that i2 + plus 12 does equal zero2. But does this have a meaning? I know one can treat the imaginary number line as just another axis like the reals, but does that mean this does represent a triangle in the complex plane with a hypotenuse of length zero? Ibix offered a rendering of the diagram using what I assume is matrix* notation...
View full post »

Similar threads

A Tale of Perseverance: Overcoming Challenges in Graduate School
2
Replies
71
Views
15K
Ten most overpaid jobs in America No scientists on the list
Replies
7
Views
31K
Mathematica This Week's Finds in Mathematical Physics (Week 236)
Replies
7
Views
3K
Mathematica This Week's Finds in Mathematical Physics (Week 236)
Replies
9
Views
4K

Hot Threads

Recent Insights

Back
Top