Cash flow forecasting. Regional Homes Construction Company has a very seasonal business that puts a high...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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) $ $ $ $ $ $ Jan Oct Feb Nov Mar Dec Apr (..... Data Table Click on the icon in order to copy its contents into a spreadsheet. Projected Housing Starts for the Coming Year, 2014 Jan. 14 Feb. 11 Mar. Apr. May Jun. 16 35 31 25 Print Jul. 26 Aug. 25 Done Sep. 23 Oct. 16 Νον. Dec. 11 8 X 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 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) $ $ $ $ $ $ Jan Oct Feb Nov Mar Dec Apr (..... Data Table Click on the icon in order to copy its contents into a spreadsheet. Projected Housing Starts for the Coming Year, 2014 Jan. 14 Feb. 11 Mar. Apr. May Jun. 16 35 31 25 Print Jul. 26 Aug. 25 Done Sep. 23 Oct. 16 Νον. Dec. 11 8 X
Expert Answer:
Answer rating: 100% (QA)
In 2014 Regional Construction Company has the following cash flow January 6210 F... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A&R Construction Company has been very successful over the past five years and now has decided that it needs to construct a building to house all of its equipment. The companys controller has...
-
5. You have decided to use the discounted cash flow approach to value AFC. Based on the riskiness of the new business you believe a 30 percent discount rate is appropriate. What is the forecasted...
-
Housing Construction Company (HCC) has agreed to build a housing project for the city of New York. On January 1st, 2006 the company and the city agreed on the following terms: the construction should...
-
Three partners. Ankamah, Kofi and David share profit and losses in the ratio 5: 3:2 for the year ending 31/12/2016. The profit generated from either business is $600,000. Partners' contributions are...
-
Their partnership agreement requires Harry, Draco, and Hermione to provide capital when and as required by the partnership in the ratio 1 : 1.35 : 0.85, respectively. a. The total initial capital...
-
Supplement A Analyzing LIFO and FIFO When Inventory Quantities Decline Based on an Actual Note In a recent annual report, General Electric reported the following in its inventory note: It also...
-
Dr. Walter Sullivan was one of several plastic surgeons in Las Vegas visited by Julie Jones. Jones, an exotic dancer, sought plastic surgery to improve her ability to make money in her profession....
-
Inventoriable Costs Presented below is a list of items that may or may not be reported as inventory in a companys December 31 balance sheet. 1. Goods sold on an installment basis (bad debts can be...
-
Question-1: For the Euclidean space of RK define a new metric as follows: K d(x,y)=xy; |P i=1 1/p for p1
-
Suppose that a customer were to purchase from Colonial Originals a furniture kit that has a catalog price of $99.95 and a shipping weight of 26.5 pounds. a. Using Table 3-3, determine the total cost...
-
The Information Technology Department is considering purchasing five large format network printers to deploy throughout City Hall. The IT Manager has requested assistance from the Purchasing...
-
Simplify the expression by first factoring each numerator and denominator. x 4 x+x-6 3x + 5x 2 4x + 12 - -
-
What is your assessment of contemporary world economic performance using conventional macroeconomic indicators? (You will need to access data from the most recent World Economic Outlook available on...
-
Consider the Cobb-Douglas production function Q = 6 L^ K^ and cost function C = 3L + 12K. a. Optimize labor usage in the short run if the firm has 9 units of capital and the product price is $3. b....
-
Indicate whether you agree with the following statements in italics, and explain your answer: (a) Markets A and B are identical in all respects (demand, costs, number of firms, etc.). If the same...
-
Let P (1,3,-1), a. Find the distance from P to the plane y = 7. b. Find the distance from P to the plane 2x - 3y + z = 3. Do this by finding a vector from the plane to the point, then finding the...
-
In the featured case Gonzales v. Raich , two California women challenged the federal government's ability to regulate their cultivation and consumption of medical marijuana. The Supreme Court ruled...
-
A regular deposit of $100 is made at the beginning of each year for 20 years. Simple interest is calculated at i% per year for the 20 years. At the end of the 20-year period, the total interest in...
-
The president of ChemTech is trying to decide whether to start a new product line or purchase a small company. It is not financially possible to do both. To make the product for a 3-year period will...
-
International Potash got a $50 million loan amortized over a 10-year period at 10% per year interest. The loan agreement stipulates that the loan will be repaid in 10 equal annual payments with...
-
Standby power for water utility pumps and other electrical devices is provided by diesel-powered generators. As an alternative, the utility can use natural gas to power the generators, but it will be...
-
Which of Chaterjis criticisms of MVO is/are valid? A. Only Criticism 1 B. Only Criticism 2 C. Both Criticism 1 and Criticism 2 Investment adviser Carl Monteo determines client asset allocations using...
-
Which of the characteristics put forth by Chaterji to describe the factor-based approach is/are correct? A. Only Characteristic 1 B. Only Characteristic 2 C. Both Characteristic 1 and Characteristic...
-
The change in the annual spending rate, in conjunction with the boards expectations regarding future enrollment and the need for endowment support, could justify that KUEs target weight for: A....
Study smarter with the SolutionInn App