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

  • Thread starter Thread starter MHamernik
  • Start date Start date
  • Tags Tags
    Charges Finance
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 'Fermat's Last Theorem'

Fermat's Last Theorem has long been one of the most famous mathematical problems, and is now one of the most famous theorems. It simply states that the equation $$ a^n+b^n=c^n $$ has no solutions with positive integers if ##n>2.## It was named after Pierre de Fermat (1607-1665). The problem itself stems from the book Arithmetica by Diophantus of Alexandria. It gained popularity because Fermat noted in his copy "Cubum autem in duos cubos, aut quadratoquadratum in duos quadratoquadratos, et...
View full post »

Thread 'Useless continued fraction for 1'

I'm interested to know whether the equation $$1 = 2 - \frac{1}{2 - \frac{1}{2 - \cdots}}$$ is true or not. It can be shown easily that if the continued fraction converges, it cannot converge to anything else than 1. It seems that if the continued fraction converges, the convergence is very slow. The apparent slowness of the convergence makes it difficult to estimate the presence of true convergence numerically. At the moment I don't know whether this converges or not.
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
3K

Hot Threads

Recent Insights

Back
Top