4120 Construction Accounting and Finance Term Project Prepare a cash flow projection for a construction company that currently has two projects under contract for the next year and anticipates picking up a third and fourth project during the year. The cash flow should be formatted as shown in Figure 14-1, 14-214-3, 14-4 and 9-5 of the textbook. For the first project, the project's owner is holding $24,200 in retention from this year's payments and will continue to hold a 5% retention on all payments during the next year. The construction company is holding $9.400 of retention on their subcontractors from this year's payments. The retention for this project is expected to be released in July. The estimated bill to the project's owner and construction costs for the first project are as follows: Month Dec Jan. Feb. March Total Bill to Owner ($) 126 800 52.900 88,000 25 700 293,400 Material ($) 25 500 9,900 16,600 5000 57000 Labor ($) Sub. (5) Other ($) 24.900 51.200 10.200 10,100 22.400 4.100 15,600 32,200 6,800 5.100 10.400 2.000 55,700 116 200 23 100 The second project started last December and the owner has yet to make a payment. The project's owner will holde 5% retention on this project and is expected to release the retention in August. The construction company will withhold retention from the payments to their subcontractors. The estimated bill to the project's owner and construction costs for the second project are as follows: Page 1 of 5 Costs Other Bill to Material Month Owner (5) (5) Dec 11 900 3400 Jan 33 300 30 300 Feb 42 200 1 100 March 44.60034700 April 70 000 21.500 Mey 32.2008,900 June 45,300 12 800 July 152004,600 Total 294 700 87300 Labor (5) Sub. (5) 37001400 9 400 4300 30.700 4900 14 500 6300 19.100 9500 8,800 3600 12 800 5,400 4100 1900 B3.100 37 300 (5) 1 300 4.000 4,400 5.400 7600 3,100 5,000 1700 32.500 The third project is expected to start in April. The project's owner will hold a 10% retention on the project and the construction company will withhold retention from the payments to their subcontractors. The retention for this project is expected to be released in October. The estimated bill to the project's owner and construction costs for the third project areas follows: Costs Bill to Material Month Owner ($) (5) April 36,300 6,400 May 50 800 9,400 June 61.800 10 800 July 36 1007 400 Total 185 000 34000 Labor ($) 9.400 12.400 15100 8.600 45.500 Sub (5) 6,300 7,600 10,300 6.000 30 200 Other (5) 4,000 5,500 6,500 3900 19900 The fourth project is expected to start in August. The project's owner will hold a 5% retention on the project and the construction company will withhold retention from the payments to their subcontractors. The retention for this project will not be released this year. The estimated bill to the project's owner and construction costs for the fourth project areas follow Page 2 of 5 Bill to Month Owner (5) Aug 19 000 Sept. 53200 Oct. 61600 Nov. 73.700 Dec. 115,400 Total 322 900 Materid (5) 4600 16500 16 100 19.900 32.700 89 800 Labor ($) Sub. (5) 5 300 2000 16200 8 ,700 21500 9,800 21300 11 800 33,400 17 000 97.700 50 200 Other (5) 1800 5,000 6.900 7,600 10 800 32.100 The company's fiscal and tax years start in January and end in December The company uses the percentage completion method of accounting Revenues are received before the end of the month after the month the company bills its clients, Labor costs are paid weekly. Material bills are paid in full when the payment is received from the owner. Subcontractor bills are paid-less retention-when payment is received from the owner. The retention withheld from the subcontractor payments is based on the same retention rate that is held by the project's owner and will be paid to the subcontractor when the owner releases the retention. Other costs are paid at the end of the month the costs are incurred, Include in the general overhead budget the following the budget for advertising is to be 0.5% of revenues. The budget for promotions is to include $1,000 in July for a company picnic, $200 in December for Christmas cards and gifts, and $1,300 in December for a company Christmas party The monthly fuel and maintenance cost for the company vehicles driven by the owner is estimated to be $225 per month. In April, the company plans on purchasing a new copier for $2,000. The new copier will be subject to the 200% declining balance depreciation method using the midyear convention and a five-year life. The company employs three workers the owner, an estimator, and a secretary/bookkeeper. The owner is paid $5,000 per month The estimator is paid $1700 per hour and works on average of twenty-five hours per week The secretary/receptionist is paid $14.50 per hour and works on average of forty-seven hours per week. All of the hourly employees are paid for fifty two weeks of work per year. Time-and-a-half must be paid to hourly employees for work over forty hours per week. The company contributes Page 3 ofs $160 per month per employee-including the owner-for health insurance They also deposit $0,50 in an employee's 401(k) account for every dollar the employee deposits. The maximum the company would deposit is 3% of an employee's wages. The company's owner is included in this match Historically, the employees have taken full advantage of this benefit. The current social security rate is 6,2% to $84.900 of wages per employee. The current Medicare rate is 1.45%. The company's FUTA rate is 0,8% on the first $7,000 of wages per employee and their SUTA rate is 2.5% on the first $9,000 of wages per employee The company is charged 0.45% of revenues, 0.65% of wages for hourly employees, and 15% of wages for salaried employees for general liability insurance. In January the company pays $25 for a business license. It is anticipated that office supplies will cost $150 per month. Rent for the office space is $450 per month and includes sewer and water, Office utilities are expected to run as follows: $150 per month for power in June, July, and August and $100 per month during the remaining months of the year, and $130 per month for natural gas during November, December, January, and February and $30 per month during the remaining months of the year. It is anticipated that the company will spend $50 per month for postage and $100 per month for janitorial services. The estimated telephone costs are $125 per month for telephone and long-distance Service and $100 per month to provide mobile phone service for the owner. In December the company plans on making a $1,500 charitable contribution to a local university. In April the company must pay $500 for their annual plan room membership. The company plans on spending $250 at the first of each quarter for accounting services to close the previous quarter's books and an additional $500 in April for tax services. The estimated cost of meals and entertainments is $50 per week Bank fees are $50 per month. Allow $75 per month for miscellaneous expenses Assume that all overhead costs-except labor-are paid at the end of the month they occur, Labor will be paid throughout the month that the costs occur. Also assume that all of the months are the same length-four and one-third weeks, In addition to the above costs, the company depreciation from previous year's purchases of office equipment is $4,000 per year. The company has Page 4 of 5 an outstanding loan with a payment of $575 per month. Of the monthly loan payments, $3,730 will be in the form of interest and the remaining will reduce the outstanding loan balance. The surplus cash from each month will be placed in a bank account earning a monthly interest rate of 0.45% Negative cash flows will be covered by funds in this bank account. At the beginning of the year the balance for the bank account will be $40,000 Inasmuch as the company is an S-corporation, the estimated income taxes for the year will be distributed to the company's owners at the end of the year. The disbursement will be based on a marginal tax rate is 27%. Ignore underbillings and overbillings Submit a copy of you worksheets and answer the following questions: Does the company have sufficient funds for the next year? If not, what changes can the company make to ensure that they have sufficient funds? Page 5 of 5 4120 Construction Accounting and Finance Term Project Prepare a cash flow projection for a construction company that currently has two projects under contract for the next year and anticipates picking up a third and fourth project during the year. The cash flow should be formatted as shown in Figure 14-1, 14-214-3, 14-4 and 9-5 of the textbook. For the first project, the project's owner is holding $24,200 in retention from this year's payments and will continue to hold a 5% retention on all payments during the next year. The construction company is holding $9.400 of retention on their subcontractors from this year's payments. The retention for this project is expected to be released in July. The estimated bill to the project's owner and construction costs for the first project are as follows: Month Dec Jan. Feb. March Total Bill to Owner ($) 126 800 52.900 88,000 25 700 293,400 Material ($) 25 500 9,900 16,600 5000 57000 Labor ($) Sub. (5) Other ($) 24.900 51.200 10.200 10,100 22.400 4.100 15,600 32,200 6,800 5.100 10.400 2.000 55,700 116 200 23 100 The second project started last December and the owner has yet to make a payment. The project's owner will holde 5% retention on this project and is expected to release the retention in August. The construction company will withhold retention from the payments to their subcontractors. The estimated bill to the project's owner and construction costs for the second project are as follows: Page 1 of 5 Costs Other Bill to Material Month Owner (5) (5) Dec 11 900 3400 Jan 33 300 30 300 Feb 42 200 1 100 March 44.60034700 April 70 000 21.500 Mey 32.2008,900 June 45,300 12 800 July 152004,600 Total 294 700 87300 Labor (5) Sub. (5) 37001400 9 400 4300 30.700 4900 14 500 6300 19.100 9500 8,800 3600 12 800 5,400 4100 1900 B3.100 37 300 (5) 1 300 4.000 4,400 5.400 7600 3,100 5,000 1700 32.500 The third project is expected to start in April. The project's owner will hold a 10% retention on the project and the construction company will withhold retention from the payments to their subcontractors. The retention for this project is expected to be released in October. The estimated bill to the project's owner and construction costs for the third project areas follows: Costs Bill to Material Month Owner ($) (5) April 36,300 6,400 May 50 800 9,400 June 61.800 10 800 July 36 1007 400 Total 185 000 34000 Labor ($) 9.400 12.400 15100 8.600 45.500 Sub (5) 6,300 7,600 10,300 6.000 30 200 Other (5) 4,000 5,500 6,500 3900 19900 The fourth project is expected to start in August. The project's owner will hold a 5% retention on the project and the construction company will withhold retention from the payments to their subcontractors. The retention for this project will not be released this year. The estimated bill to the project's owner and construction costs for the fourth project areas follow Page 2 of 5 Bill to Month Owner (5) Aug 19 000 Sept. 53200 Oct. 61600 Nov. 73.700 Dec. 115,400 Total 322 900 Materid (5) 4600 16500 16 100 19.900 32.700 89 800 Labor ($) Sub. (5) 5 300 2000 16200 8 ,700 21500 9,800 21300 11 800 33,400 17 000 97.700 50 200 Other (5) 1800 5,000 6.900 7,600 10 800 32.100 The company's fiscal and tax years start in January and end in December The company uses the percentage completion method of accounting Revenues are received before the end of the month after the month the company bills its clients, Labor costs are paid weekly. Material bills are paid in full when the payment is received from the owner. Subcontractor bills are paid-less retention-when payment is received from the owner. The retention withheld from the subcontractor payments is based on the same retention rate that is held by the project's owner and will be paid to the subcontractor when the owner releases the retention. Other costs are paid at the end of the month the costs are incurred, Include in the general overhead budget the following the budget for advertising is to be 0.5% of revenues. The budget for promotions is to include $1,000 in July for a company picnic, $200 in December for Christmas cards and gifts, and $1,300 in December for a company Christmas party The monthly fuel and maintenance cost for the company vehicles driven by the owner is estimated to be $225 per month. In April, the company plans on purchasing a new copier for $2,000. The new copier will be subject to the 200% declining balance depreciation method using the midyear convention and a five-year life. The company employs three workers the owner, an estimator, and a secretary/bookkeeper. The owner is paid $5,000 per month The estimator is paid $1700 per hour and works on average of twenty-five hours per week The secretary/receptionist is paid $14.50 per hour and works on average of forty-seven hours per week. All of the hourly employees are paid for fifty two weeks of work per year. Time-and-a-half must be paid to hourly employees for work over forty hours per week. The company contributes Page 3 ofs $160 per month per employee-including the owner-for health insurance They also deposit $0,50 in an employee's 401(k) account for every dollar the employee deposits. The maximum the company would deposit is 3% of an employee's wages. The company's owner is included in this match Historically, the employees have taken full advantage of this benefit. The current social security rate is 6,2% to $84.900 of wages per employee. The current Medicare rate is 1.45%. The company's FUTA rate is 0,8% on the first $7,000 of wages per employee and their SUTA rate is 2.5% on the first $9,000 of wages per employee The company is charged 0.45% of revenues, 0.65% of wages for hourly employees, and 15% of wages for salaried employees for general liability insurance. In January the company pays $25 for a business license. It is anticipated that office supplies will cost $150 per month. Rent for the office space is $450 per month and includes sewer and water, Office utilities are expected to run as follows: $150 per month for power in June, July, and August and $100 per month during the remaining months of the year, and $130 per month for natural gas during November, December, January, and February and $30 per month during the remaining months of the year. It is anticipated that the company will spend $50 per month for postage and $100 per month for janitorial services. The estimated telephone costs are $125 per month for telephone and long-distance Service and $100 per month to provide mobile phone service for the owner. In December the company plans on making a $1,500 charitable contribution to a local university. In April the company must pay $500 for their annual plan room membership. The company plans on spending $250 at the first of each quarter for accounting services to close the previous quarter's books and an additional $500 in April for tax services. The estimated cost of meals and entertainments is $50 per week Bank fees are $50 per month. Allow $75 per month for miscellaneous expenses Assume that all overhead costs-except labor-are paid at the end of the month they occur, Labor will be paid throughout the month that the costs occur. Also assume that all of the months are the same length-four and one-third weeks, In addition to the above costs, the company depreciation from previous year's purchases of office equipment is $4,000 per year. The company has Page 4 of 5 an outstanding loan with a payment of $575 per month. Of the monthly loan payments, $3,730 will be in the form of interest and the remaining will reduce the outstanding loan balance. The surplus cash from each month will be placed in a bank account earning a monthly interest rate of 0.45% Negative cash flows will be covered by funds in this bank account. At the beginning of the year the balance for the bank account will be $40,000 Inasmuch as the company is an S-corporation, the estimated income taxes for the year will be distributed to the company's owners at the end of the year. The disbursement will be based on a marginal tax rate is 27%. Ignore underbillings and overbillings Submit a copy of you worksheets and answer the following questions: Does the company have sufficient funds for the next year? If not, what changes can the company make to ensure that they have sufficient funds? Page 5 of 5