What is the below values of the followings in the below table: 1- Overdraft end of the
Fantastic news! We've Found the answer you've been seeking!
Question:
What is the below values of the followings in the below table:
1- Overdraft end of the month
2- Interest on the overdraft balance (financially)
3- Interest on the overdraft balance
Overdraft calculation | |||||||
1 | 2 | 3 | 4 | 5 | Indirect | $ 5,000 | |
Direct cost (monthly) | $ 25,000 | $ 65,000 | $ 75,000 | $ 15,000 | Markup | 5% | |
Indirect cost (monthly) | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | Retainage | 10% | |
Subtotal | $ 30,000 | $ 70,000 | $ 80,000 | $ 20,000 | Actual payment (Retainage less) | 90% | |
Markup (monthly) | $ 1,500 | $ 3,500 | $ 4,000 | $ 1,000 | Interest rate | 1% | |
Total Billed | $ 31,500 | $ 73,500 | $ 84,000 | $ 21,000 | |||
Retainage withheld (monthly) | $ 3,150 | $ 7,350 | $ - | $ - | |||
Payment | $ 28,350 | $ 66,150 | $ 84,000 | $ 21,000 | |||
Progress Payment Received (monthly) | $ - | $ 28,350.0 | $ 66,150 | $ 84,000 | $ 31,500 | ||
Progress payment Received (cummulative) | $ - | $ 28,350.0 | $ 94,500 | $ 178,500 | $ 210,000 | ||
Total base cost to date (cummulative) | $ 30,000 | $ 100,000 | $ 180,000 | $ 200,000 | $ 200,000 | ||
Total amount billed to date (cummulative) | $ 31,500 | $ 105,000 | $ 189,000 | $ 210,000 | |||
Overdraft end of month | |||||||
Interest on overdraft balance (1% interest) | |||||||
Total amount financed (cumulative) |
Related Book For
Horngrens Accounting
ISBN: 978-0133855371
10th Canadian edition Volume 1
Authors: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo-Ann L. Johnston, Peter R. Norwood
Posted Date: