Find the monthly cash flows and total cash

Reference no: EM131518038

Question: Determine the monthly cash flows and total cash generated at the end of each month and just before the payment is received for the construction of a house with the following budget and schedule. 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 a 10% retention. Final payment is expected one month after completion of the project and includes 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 a 10% retention from the subcontractor's payment. The construction company pays weekly for labor. Often costs will be paid throughout the month that costs are incurred. The projected monthly material, labor, subcontractor, and other costs follow. The construction company will add a 10% profit and overhead markup to these costs when billing the owner. Solve this problem using a spreadsheet.

1669_Item 1.png

2444_Item 2.png

Reference no: EM131518038

Questions Cloud

Marginal analysis to make his decision : Describe how Shawn can use marginal analysis to make his decision.

Evaluate the maximum amount of cash invested by the company : The construction company in Problem 2 decides to act as the owner on the project. The construction company plans to sell the project for $1,250,000.

Understanding of the basic law of supply and demand : Please assist with an understanding of the basic law of supply and demand and how the U.S. economy and American businesses interact to create this symbiotic.

Historical context on union-management relations : Analyze the impact of historical context on union-management relations. How does historical context provide clues as to the direction of union/management.

Find the monthly cash flows and total cash : Determine the monthly cash flows and total cash generated at the end of each month and just before the payment is received for the construction of a house.

Discuss and illustrate the individual pressures faced : Essay: Ethical Analysis- Discuss and illustrate the individual pressures faced and how the issues were handled or delegated to another position.

What is the nominal interest rate : Suppose the real interest rate is 5% per year and the expected inflation rate is 4%. What is the nominal interest rate?

Information on the consumer price index : Use an internet search or the University Library to locate information on the Consumer Price Index (CPI).

What does this second option look like : There is another contract available, though, where the client agrees to give the gym a sum of money, F, out of which the gym would then pay clients f dollars.

User Account

All Pages