Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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)
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) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started