9. A construction company is negotiating on a construction project with a six-month duration. On the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
9. A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills one month after they are received. The owner also holds 10% retention. Final payment is expected one month after completion of the project and includes payment of the retention. The construction company pays material suppliers in full when it receives payment from the owner. The construction company pays subcontractors when it receives payment from the owner but withholds 10% from the subcontractor's payment. The construction company pays for labor weekly. The projected monthly material, labor, and subcontractor costs are shown in Table 2. Determine the monthly cash flows and the total cash generated by the project at the end of each month and just before each payment is received from the project's owner. What is the maximum amount of cash invested by the company during the completion of the project? (29 points) Table 2 - Data for Problem 9 Costs Month Materials ($) Labor ($) Sub. ($) Bill to Owner ($) 1 33,700 25,300 35,600 101,200 2 54,100 42,400 125,200 237,200 3 69,600 77,900 93,600 258,000 4 17,200 17,900 105,700 150,700 5 14,700 21,900 60,400 103,800 6 CO 11,600 12,700 35,600 64,100 Total 200,900 198,100 456,100 915,000 9. A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills one month after they are received. The owner also holds 10% retention. Final payment is expected one month after completion of the project and includes payment of the retention. The construction company pays material suppliers in full when it receives payment from the owner. The construction company pays subcontractors when it receives payment from the owner but withholds 10% from the subcontractor's payment. The construction company pays for labor weekly. The projected monthly material, labor, and subcontractor costs are shown in Table 2. Determine the monthly cash flows and the total cash generated by the project at the end of each month and just before each payment is received from the project's owner. What is the maximum amount of cash invested by the company during the completion of the project? (29 points) Table 2 - Data for Problem 9 Costs Month Materials ($) Labor ($) Sub. ($) Bill to Owner ($) 1 33,700 25,300 35,600 101,200 2 54,100 42,400 125,200 237,200 3 69,600 77,900 93,600 258,000 4 17,200 17,900 105,700 150,700 5 14,700 21,900 60,400 103,800 6 CO 11,600 12,700 35,600 64,100 Total 200,900 198,100 456,100 915,000
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
A ping pong ball is drawn at random from an urn consisting of balls numbered 4 through 9. A player wins $1.5 if the number on the ball is odd and loses $1.5 if the number is even. Let x be the amount...
-
Find Vo in the network in figure using super position. Vo 8 kN 3 kn 2 kn 2 mA 6 kn 12 v+ ww
-
Write a bottom-controlled Do While loop with an empty body that continues while the user enters "Yes" into the strContinue variable.
-
The Retained Earnings, Dividends, and Income Summary accounts for Lous Hair Salon, Inc., are shown in T account form below. The closing entries have been recorded for the year ended December 31,...
-
United Rental Company reported the following information related to its pension plan for the years 20112014. The fund is administered by a separate outside trustee. Instructions: 1. Prepare the...
-
Beverly Company has determined a standard variable overhead rate of $ 3 . 7 0 per direct labor hour and expects to incur 0 . 5 0 labor hours per unit produced. Last month, Beverly incurred 1 , 5 5 0...
-
XYZ Corporation is analyzing two projects, E and F: Year Project E Cash Flow ($) Project F Cash Flow ($) 0 -80,000 -90,000 1 25,000 30,000 2 35,000 40,000 3 45,000 50,000 4 55,000 60,000 IRR 19% 21%...
-
Jean, a knowledgeable person from another department, has asked you to perform a routine staff function to her specifications. You decide to: a. Perform the task to her specification without...
-
Compare and contrast the benefits and risks of firm level, industry level, and cross-industry trade portals.
-
Imagine you are a decision-maker about to allocate millions of dollars to-ward an SoS. The analysts have told you that the SoS configuration they recommend was developed using an agent-based model....
-
What is the purpose of undertaking tests of balances or overall results? What is the relationship between tests of transactions and tests of balances or overall results?
-
You are a knowledgeable supervisor. You buy supplies from Peter regularly. He is an excellent salesperson and very knowledgeable about your situation. You are placing your weekly order. You decide...
-
43% of small businesses are either not tracking inventory or using manual processes, such as spreadsheets or pen-and-paper. This creates a higher probability of creating double entries, difficulties...
-
What are multinational corporations (MNCs) and what economic roles do they play?
-
Horizontal analysis (Learning Objective 1) Prepare a horizontal analysis of the following comparative income statement of Enchanted Designs. Round percentage changes to the nearest one-tenth percent...
-
Trend analysis of working capital (Learning Objective 1) Compute the dollar amount of change and the percentage of change in Media Enterprises working capital each year during 2008 and 2009. Is this...
-
Compute trend percentages (Learning Objective 1) Compute trend percentages for Thousand Oaks Realtys net revenue and net income for the following five-year period using 2004 as the base year. Round...
Study smarter with the SolutionInn App