Set up a spreadsheet similar to Figure 12-11 to solve Problem 4.

FIGURE 12-11

The housing contract from Problem 3 continues on into the next year, with the last housing start occurring in April, as shown in the following table. Determine the monthly cash flows and total cash generated by the project at the end of each month and just before each payment is received from the projects owner for the remaining months in the year.

What is the maximum amount of cash invested by the company during this year?

Before Payment Is Received 5,800 6,700 20,200 9.500 9,500 (17.100 20,200) 20,200 20,200 0,200 8,400 5,800 4,800 17.100() 9.50 (20,200 (8,400 5,800 4,800 9.500)(20,200 (5,800 28Cash Flow 19,200 (64.900) (154,100(179,500 202,100) (172,300) (110,900) End of Month 5,800 3,000 3,600 2,300 7.500 2,300 41Tvp 3,600 2,300 (5,800) 7.500 2,300 3,000 Tvpe 1 5,800 6,700 5,800 Tvpe 2 19.200)( (19,200) 58 Cash Flow 25,200 44,400) 50,700 (49,700) (23,100 10 12 33|33|2| 2237|33 122 5566 er 22 333 2333 7779 1225566 888 1 (2 (1 (4 (4 (4 17 20 20 20 8889566 2 8999 5556 233 779-12 2 5556 445 8777 1-2 5666 E Pa 22889 5666 3 899 556 556 6 122 112 1222 111 1122 122112 1122 -as iT_T TTT TTTT TTTT TTT TTTT TTT T- 0 12345 6 7 8 9 10 1 345678 1 22 22 23 22 222 2333 33 34 35 373 3042 3456 789 5555 455 555 Monthly Starts by Type MONTH Jan. Feb. March April TYPE 1 4 2 TYPE 2 2 2