Please fill out the tables for Sep, Jan, Oct, Feb, Nov, Mar, Dec & April w/ the cash inflows and outflows
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: 55% of the sales price, paid equally over the first three months of construction Labor: 27% 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: 4% of the sales price, paid at completion of the house Housing starts from the previous year (2013): Sep. 18, Oct. 19, Nov. 15, and Dec. 6 Projected housing starts for Jan. of the following year (2015): 14 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 Data Table Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr $ 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. 14 11 16 25 35 31 26 Cash Out Flows Aug Sep Oct. Nov. Dec. Raw Materials $ 25 23 16 11 8 Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Print Done Net Cash Flow $ Negative Cash Flow? (Yes/No) 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: 55% of the sales price, paid equally over the first three months of construction Labor: 27% 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: 4% of the sales price, paid at completion of the house Housing starts from the previous year (2013): Sep. 18, Oct. 19, Nov. 15, and Dec. 6 Projected housing starts for Jan. of the following year (2015): 14 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 Data Table Actual and Projected Housing Starts Projected Cash Flows by Month Revenue from Sale of Homes Jan Feb Mar Apr $ 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. 14 11 16 25 35 31 26 Cash Out Flows Aug Sep Oct. Nov. Dec. Raw Materials $ 25 23 16 11 8 Labor Costs $ Fees and Licenses $ Legal and Title Transfer Costs $ Print Done Net Cash Flow $ Negative Cash Flow? (Yes/No)
