Complete the boxes

Assumptions: You will not be paid until for your first billing until the third month (A3), pick closest answer. Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 13 Month 14 Month 15 Direct cost indirect cost subtotal markup (11%) total billed retainage withheld (10%) retainage billed $568,234 $1,248,647 $1,944,371 $2,340,606 $320,000 $320,000 $320,000 $320,000 $888,234 $1,568,647 $2,264,371 $2,660,606 $97,706 $172,551 $249,081 $292,667 $985,940 $1,741,198 $2,513,452 $2,953,273 $98,594 $174,120 $251,345 $295,327 $2,826,106 $320,000 $3,146,106 $346,0721 $3,492,178 $349,218 $3,341,069 $3,811,927 $320,000 $320,000 $3,661,069 $4,131,927 $402,7181 $454,5121 $4,063,787 $4,586,439 $406,379 $458,644 $4,199,206 $320,000 $4,519,206 $497,113 $5,016,319 $501,632 $3,909,971 $320,000 $4,229,971 $465,297 $4,695,268 $469,527 $2,809,180 $320,000 $3,129,180 $344,2101 $3,473,390 $347,339 $1,769,080 $320,000 $2,089,080 $229,799 $2,318,879 $231,888 $742,691 $320,000 $1,062,691 $116,896 $1,179,587 $117,959 $3,701,971 6 12 13 11 A11 14 A14 A3 A7 AS A9 A13 B6 A15 A12 B12 10 A10 B10 C10 D10 B C B15 Payment received Total amount billed to date Total cost to date Total amount paid to date Overdraft financing 1.5% each month C7 C12 C13 C11 D11 E11 012 013 016 C15 D15 E15 E10 E12 E13 E14 F14 F6 F10 F11 F12 513 515 Total Profit Total Billed Total Paid Total Financing Cost Assumptions: You will not be paid until for your first billing until the third month (A3), pick closest answer. Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 13 Month 14 Month 15 Direct cost indirect cost subtotal markup (11%) total billed retainage withheld (10%) retainage billed $568,234 $1,248,647 $1,944,371 $2,340,606 $320,000 $320,000 $320,000 $320,000 $888,234 $1,568,647 $2,264,371 $2,660,606 $97,706 $172,551 $249,081 $292,667 $985,940 $1,741,198 $2,513,452 $2,953,273 $98,594 $174,120 $251,345 $295,327 $2,826,106 $320,000 $3,146,106 $346,0721 $3,492,178 $349,218 $3,341,069 $3,811,927 $320,000 $320,000 $3,661,069 $4,131,927 $402,7181 $454,5121 $4,063,787 $4,586,439 $406,379 $458,644 $4,199,206 $320,000 $4,519,206 $497,113 $5,016,319 $501,632 $3,909,971 $320,000 $4,229,971 $465,297 $4,695,268 $469,527 $2,809,180 $320,000 $3,129,180 $344,2101 $3,473,390 $347,339 $1,769,080 $320,000 $2,089,080 $229,799 $2,318,879 $231,888 $742,691 $320,000 $1,062,691 $116,896 $1,179,587 $117,959 $3,701,971 6 12 13 11 A11 14 A14 A3 A7 AS A9 A13 B6 A15 A12 B12 10 A10 B10 C10 D10 B C B15 Payment received Total amount billed to date Total cost to date Total amount paid to date Overdraft financing 1.5% each month C7 C12 C13 C11 D11 E11 012 013 016 C15 D15 E15 E10 E12 E13 E14 F14 F6 F10 F11 F12 513 515 Total Profit Total Billed Total Paid Total Financing Cost