4. Cash flow forecasting. Regional Homes Construction Company has a very seasonal business that puts a high priority on cash flow management. Prepare a cash flow forecast for the coming year by month for Regional Construction on a spreadsheet based on the following information: It takes four months to complete a house. All houses are custom built, and the company receives payment the month following completion. The average sales price per home is $445.000. The average cost to build a home is: Raw materials: 54% of the sales price, paid equally over the first three months of construction Labor 29% of the sales price, paid equally over the four months of construction Fees and permits: 6% of the sales price, paid the month before construction begins Legal fees and title transfer. 2% of the sales price, paid at completion of the house Housing starts from the previous year (2013): Sep. 19, Oct. 18, Nov. 14, and Dec. 7 Projected housing starts for Jan. of the following year (2015): 13 What is the total cash flow in and out for 2014, and in which months does Regional Construction Company have negative cash flow? Complete the table with the cash inflows and cash outflows below: (Round the dollar amounts to the nearest dollar.) Sep Oct Noy Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr Cash Out Flows Raw Materials $ $ Labor Costs Fees and Licenses $ $ Legal and Title Transfer Costs $ Net Cash Flow Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Huuuuu Sep Oct Nov Dec Jan Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Feb Mar Apr $ Raw Materials $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ $ Net Cash Flow Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Sep Oct Nov Dec Jan Feb Mar Apr $ $ Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs $ S $ $ Net Cash Flow $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) (Round the dollar amounts to the nearest dollar.) Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr $ Cash Out Flows Raw Materials $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Net Cash Flow $ $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Jan Feb Mar Apr May Jun Jul Aug $ Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs Net Cash Flow Negative Cash Flow? (Yes/No) $ $ $ (Round the dollar amounts to the nearest dollar.) (Round the dollar amounts to the nearest dollar.) Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr $ Cash Out Flows Raw Materials $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Net Cash Flow $ $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) May Jun Jul Aug Sep Oct Nov Dec $ Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs Net Cash Flow Negative Cash Flow? (Yes/No) $ $ 5 $ 5 (Round the dollar amounts to the nearest dollar.) May Jun Jul Aug Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs $ $ $ $ Net Cash Flow $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) May Jun Jul Aug Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials $ S Labor Costs $ $ Fees and Licenses Legal and Title Transfer Costs Net Cash Flow Negative Cash Flow? (Yes/No) $ $ (Round the dollar amounts to the nearest dollar) May Jun Jul Aug Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Sep Oct Nov Dec $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Net Cash Flow $ $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Regional Homes Construction Company Projected Cash Flows Total Revenue from Sale of Homes Cash Out Flows Raw Materials $ Labor Costs Fees and Licenses Legal and Title Transfer Costs ME $ $ Net Cash Flow $ 1: Data Table Click on the icon in order to copy its contents into a spreadsheet. Projected Housing Starts for the Coming Year, 2014 Jan. Feb. Mar, Apr. May Jun. Jul. Sep. Oct. Nov. Dec. Aug. 22 12 11 19 22 31 32 29 23 16 11 6 4. Cash flow forecasting. Regional Homes Construction Company has a very seasonal business that puts a high priority on cash flow management. Prepare a cash flow forecast for the coming year by month for Regional Construction on a spreadsheet based on the following information: It takes four months to complete a house. All houses are custom built, and the company receives payment the month following completion. The average sales price per home is $445.000. The average cost to build a home is: Raw materials: 54% of the sales price, paid equally over the first three months of construction Labor 29% of the sales price, paid equally over the four months of construction Fees and permits: 6% of the sales price, paid the month before construction begins Legal fees and title transfer. 2% of the sales price, paid at completion of the house Housing starts from the previous year (2013): Sep. 19, Oct. 18, Nov. 14, and Dec. 7 Projected housing starts for Jan. of the following year (2015): 13 What is the total cash flow in and out for 2014, and in which months does Regional Construction Company have negative cash flow? Complete the table with the cash inflows and cash outflows below: (Round the dollar amounts to the nearest dollar.) Sep Oct Noy Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr Cash Out Flows Raw Materials $ $ Labor Costs Fees and Licenses $ $ Legal and Title Transfer Costs $ Net Cash Flow Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Huuuuu Sep Oct Nov Dec Jan Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Feb Mar Apr $ Raw Materials $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ $ Net Cash Flow Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Sep Oct Nov Dec Jan Feb Mar Apr $ $ Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs $ S $ $ Net Cash Flow $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) (Round the dollar amounts to the nearest dollar.) Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr $ Cash Out Flows Raw Materials $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Net Cash Flow $ $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Jan Feb Mar Apr May Jun Jul Aug $ Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs Net Cash Flow Negative Cash Flow? (Yes/No) $ $ $ (Round the dollar amounts to the nearest dollar.) (Round the dollar amounts to the nearest dollar.) Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr $ Cash Out Flows Raw Materials $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Net Cash Flow $ $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) May Jun Jul Aug Sep Oct Nov Dec $ Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs Net Cash Flow Negative Cash Flow? (Yes/No) $ $ 5 $ 5 (Round the dollar amounts to the nearest dollar.) May Jun Jul Aug Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Labor Costs Fees and Licenses Legal and Title Transfer Costs $ $ $ $ Net Cash Flow $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) May Jun Jul Aug Sep Oct Nov Dec Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials $ S Labor Costs $ $ Fees and Licenses Legal and Title Transfer Costs Net Cash Flow Negative Cash Flow? (Yes/No) $ $ (Round the dollar amounts to the nearest dollar) May Jun Jul Aug Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Cash Out Flows Raw Materials Sep Oct Nov Dec $ Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Net Cash Flow $ $ Negative Cash Flow? (Yes/No) (Round the dollar amounts to the nearest dollar.) Regional Homes Construction Company Projected Cash Flows Total Revenue from Sale of Homes Cash Out Flows Raw Materials $ Labor Costs Fees and Licenses Legal and Title Transfer Costs ME $ $ Net Cash Flow $ 1: Data Table Click on the icon in order to copy its contents into a spreadsheet. Projected Housing Starts for the Coming Year, 2014 Jan. Feb. Mar, Apr. May Jun. Jul. Sep. Oct. Nov. Dec. Aug. 22 12 11 19 22 31 32 29 23 16 11 6