5. Complete the overdraft calculation table on the next page (6 pts) and answer the...
90.2K
Verified Solution
Link Copied!
Question
Finance
5. Complete the overdraft calculation table on the next page (6 pts) and answer the following questions based on the following assumptions: Project lasts two months with retainage paid during month 4 Payment for Month 1 is received at the start of month 3 Payment for month 2 is received at the start of month 4 What is the percent markup? (2 pts) What is the percent of retainage? (2 pts) What is the total amount of this contract? (2pts) What is the maximum amount of money borrowed? (2pts) What is the total interest paid? (2 pts) Page 3 of 4 What is final markup on this project (2 pts) NOTE: If you leave a cell blank in the table, I will assume you do not know what belongs there! Month 3 Month 4 Description Direct Cost Month 1 $ 80,000 Month 2 $ 60,000 Indirect Cost $ 10,000 $ 10,000 Subtotal of Costs $ 90,000 $ 70,000 Markup $ 18,000 XXXXX Total Billed Retainage withheld $ 4,200 Payment Received Total Costs to Date (not including Interest) Total Amount Billed to date Total Amount Received to date Overdraft at end of month Interest on overdraft balance (1.0% per month) $0 $ 102,600 $192,000 Total Amount Financed
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!