USA Amortization schedule and credits received

Joined
Jan 26, 2023
Messages
1
Reaction score
0
Country
United States
Hi

I am setting up a liability amortization schedule. The issue is that this amortization schedule works for credits that are received fully, but I have partial credits that are being received, causing my LT balance to be incorrect.

Theoretically, there should be no LT piece for these partial credits that are received throughout the period of the contract.

Please help

TypeTotalJuly 2022june 2025TotalSTLTExpensed
Usage$ 27,850,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 773,611.11$ 27,850,000.00$ 9,283,333.33$ 13,925,000.00$ 4,641,666.67
Credits$ (27,850,000.00)$ (2,286,500.00)$ (2,286,500.00)$ (2,286,500.00)$ (2,286,500.00)$ (2,299,250.00)$ (2,299,250.00)$ (2,299,250.00)$ (2,299,250.00)$ (2,376,750.00)$ (2,376,750.00)$ (2,376,750.00)$ (2,376,750.00)$(27,850,000.00)$ (9,171,500.00)$(14,105,500.00)$ (4,573,000.00)
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,451
Reaction score
334
Country
United States
Your question is insufficient in detail for us to discern the issue. Sorry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
11,647
Messages
27,603
Members
21,428
Latest member
dataanalyticsinsingapore

Latest Threads

Top