Given the following cost expenditures for a commercial remodeling project, calculate the peak financial requirement (maximum...

Transcribed Image Text:

Given the following cost expenditures for a commercial remodeling project, calculate the peak financial requirement (maximum overdraft), the monthly overdrafts, and the financial requirements in each month by completing the table. Assume an 10% markup. Retainage is 7.5% for the first half of the project work schedule. The finance charge is 2% per month. Payments are billed at the end of the month and are received one month later. Draw the overdraft profile, total costs, and payment on the same figure in the space provided. (12 pts) Month 2 3 Direct Cost 9000 15000 12000 6000 Indirect Cost 2000 2000 2000 2000 month 1 (out) (in] 2 (in) (in) 4 (in) (in) direct cost indirect cost total cost markup total billed retainage withheld payment received total cost to date total billed to date total pald to date overdraft interest on overdraft total financed amount Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0 -$10,000 -$20,000 -$30,000 -$40,000 Given the following cost expenditures for a commercial remodeling project, calculate the peak financial requirement (maximum overdraft), the monthly overdrafts, and the financial requirements in each month by completing the table. Assume an 10% markup. Retainage is 7.5% for the first half of the project work schedule. The finance charge is 2% per month. Payments are billed at the end of the month and are received one month later. Draw the overdraft profile, total costs, and payment on the same figure in the space provided. (12 pts) Month 2 3 Direct Cost 9000 15000 12000 6000 Indirect Cost 2000 2000 2000 2000 month 1 (out) (in] 2 (in) (in) 4 (in) (in) direct cost indirect cost total cost markup total billed retainage withheld payment received total cost to date total billed to date total pald to date overdraft interest on overdraft total financed amount Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0 -$10,000 -$20,000 -$30,000 -$40,000

Answer rating: 100% (QA)

Month 1 2 3 4 5 Direct Cost 9000 15000 12000 6000 I... View the full answer