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 'Trigonometry problem of interest'

Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
View full post »

Thread 'Six Pencil Puzzle'

Is it possible to arrange six pencils such that each one touches the other five? If so, how? This is an adaption of a Martin Gardner puzzle only I changed it from cigarettes to pencils and left out the clues because PF folks don’t need clues. From the book “My Best Mathematical and Logic Puzzles”. Dover, 1994.
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