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

FIGURE 12-11

A construction company is bidding on a contract to build homes for a developer. The project consists of two types of homes and is scheduled to begin in September. The expected monthly housing starts, the cash flow that occurs between the end of the previous month and receipt of payment from the owner, and the cash flow for the entire month are shown below. 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 the remaining months of the year?

Transcribed Image Text:

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 Sept TYPE 1 TYPE 2 4 Nov Dec BEFORE PAYMENT Is RECEIVED (n) S) TYPE 1 -5,400 -8,200 -15,500 -4,400 -2,000 TYPE 1 -5,400 -1,800 7,300 2,200 3,000 9,500 END OF MONTH (n) ($) TYPE 2 -6,500 -2,400 9,300 2,800 3,400 11,900 MONTH TYPE 2 -6,500 -8,700 -19,800 -4,400 -1,700 0 4