1. What is the value for the total financing cost?
| | A. | $1,003,596.17 |
| | B. | $94,521.89 |
| | C. | $618,019.37 |
| | D. | $559,311.71 |
2. What is the value for cell E7?
| | A. | $27,019,708 |
| | B. | $7,803,524 |
| | C. | $6,342,319 |
| | D. | $129,853 |
3. What was the total profit on the project? (Original profit - cost of financing)
| | A. | $3,668,620.00 |
| | B. | $2,665,023.83 |
| | C. | $3,840,000 |
| | D. | $618,019.37 |
4. What is the value for cell D8?
| | A. | $17,643,884 |
| | B. | $4,199,206 |
| | C. | $12,341,817 |
| | D. | $14,174,884 |
5. What is the value of cell A3
| | A. | $887,346 |
| | B. | $568,234 |
| | C. | $497,542 |
| | D. | $1,361,279 |
6. What is the value for cell F9?
| | A. | $514,397.47 |
| | B. | $74,391.58 |
| | C. | $7,645.20 |
| | D. | $131,512.47 |
Show transcribed image text
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 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 $2,826,106 $3,341,069 $3,811,927 $4,199,206 $3,909,971 $2,809,180 $1,769,080 $742,691 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $888,234 $1,568,647 $2,264,371 $2,660,606 $3,146,106 $3,661,069 $4,131,927 $4,519,206 $4,229,971 $3,129,180 $2,089,080 $1,062,691 $97,706 $172,551 $249,081 $292,667 $346,072 $402,718 $454,5121 $497,113 $465,297 $344,210) $229,799 $116,896 $985,940 $1,741,198 $2,513,452 $2,953,273 $3,492,178 $4,063,787 $4,586,439 $5,016,319 $4,695,268 $3,473,390 $2,318,879 $1,179,587| $98,594 $174,120 $251,345| $295,327 $349,218 $406,379 $458,644 $501,632 $469,527 $347,339 $231,888 S117,959 3 5 7 10 15 1 $0 B1 4 4. A4 6 A6 8 A8 9 A9 A3 $3,701,971 13 A13 B13 A5 A B AZ 11 A11 B11 12 A12 B12 C12 A15 B15 B3 B4 B5 B6 B7 B8 B9 2 $0 B2 C2 D2 E2 14 A14 B14 C14 D14 C C3 C4 C5 C6 C7 Payment received Total amount billed to date Total cost to date Total amount paid to date Overdraft financing 1.5% each month C8 C9 A10 B10 C10 010 E10 C1 D1 D D4 15 D6 D7 09 D3 E3 D12 C11 011 E11 D8 E8 C13 D13 E13 C15 D15 E15 E E1 E4 E5 E6 E7 E9 E12 E14 F14 F F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F15 XX XX Total Profit Total Billed Total Paid Total Financing Cost XX 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 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 $2,826,106 $3,341,069 $3,811,927 $4,199,206 $3,909,971 $2,809,180 $1,769,080 $742,691 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $320,000 $888,234 $1,568,647 $2,264,371 $2,660,606 $3,146,106 $3,661,069 $4,131,927 $4,519,206 $4,229,971 $3,129,180 $2,089,080 $1,062,691 $97,706 $172,551 $249,081 $292,667 $346,072 $402,718 $454,5121 $497,113 $465,297 $344,210) $229,799 $116,896 $985,940 $1,741,198 $2,513,452 $2,953,273 $3,492,178 $4,063,787 $4,586,439 $5,016,319 $4,695,268 $3,473,390 $2,318,879 $1,179,587| $98,594 $174,120 $251,345| $295,327 $349,218 $406,379 $458,644 $501,632 $469,527 $347,339 $231,888 S117,959 3 5 7 10 15 1 $0 B1 4 4. A4 6 A6 8 A8 9 A9 A3 $3,701,971 13 A13 B13 A5 A B AZ 11 A11 B11 12 A12 B12 C12 A15 B15 B3 B4 B5 B6 B7 B8 B9 2 $0 B2 C2 D2 E2 14 A14 B14 C14 D14 C C3 C4 C5 C6 C7 Payment received Total amount billed to date Total cost to date Total amount paid to date Overdraft financing 1.5% each month C8 C9 A10 B10 C10 010 E10 C1 D1 D D4 15 D6 D7 09 D3 E3 D12 C11 011 E11 D8 E8 C13 D13 E13 C15 D15 E15 E E1 E4 E5 E6 E7 E9 E12 E14 F14 F F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F15 XX XX Total Profit Total Billed Total Paid Total Financing Cost XX
