What is the maximum amount of cash invested by the company

Assignment Help Finance Basics
Reference no: EM131136585

Set up a spreadsheet to solve Problem 1.
In Problem 1, 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 a 5% 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 5% retention from the subcontractor's payment. The construction company pays for labor weekly. The projected monthly material, labor, and subcontractor costs as well as the amount the construction company will bill the project's owner each month are shown in the following table. 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. 

1184_x.jpg

What is the maximum amount of cash invested by the company during the completion of the project?

Reference no: EM131136585

Questions Cloud

Determine the amount of federal income tax that is due : Using the tax rates for the year 2006, determine the amount of federal income tax that is due for a C corporation that has a taxable income of $356,000.
Determine the monthly cash flows and total cash generated : 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. Often costs will be paid throughout the month that cost..
What is the maximum amount of cash invested by the company : Determine the monthly cash flows and total cash generated by the project at the end of each month and just before the payment is received. What is the maximum amount of cash invested by the company during the completion of the project?
What is the maximum amount of cash invested by the company : 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 ..
What is the maximum amount of cash invested by the company : 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 ..
Determine the break even volume of work for a company : Determine the break-even volume of work for a company with a fixed overhead of $63,000, a contribution margin ratio of 11.0%, and a required level of profit of $60,000.
Determine the break even volume of work for a company : Determine the break-even volume of work for a company with a fixed overhead of $138,000, a contribution margin ratio of 8.9%, and a required level of profit of $100,000.
Identify top criteria you used to select an appropriate hris : Identify the top five criteria you used to select an appropriate HRIS package for the organization you selected for your Course Project. Justify how these criteria would help the succession planning process for your chosen organization. (Caterpilla..
Determine the break even volume of work for a company : Determine the break-even volume of work for a company with a fixed overhead of $250,000 and a contribution margin ratio of 11.3%.

Reviews

Write a Review

Finance Basics Questions & Answers

  Catola shoes an athletic shoe and clothing manufacturer is

1.catola shoes an athletic shoe and clothing manufacturer is considering a move into the fashion clothing business

  Find the mean value of the expansions

For the most likely and pessimistic estimates, the expansion will be needed in 8 and 15 years, respectively. The expansion will cost $4.2 million. Use interest rate of 8%.

  Amount of the loan payment in year

Home Repair, LLC just took out a $52,000, 10 year, 8%, interest only loan from the bank. Interest only payments are made annually. The entire principle due in year 10. What is the amount of the loan payment in year 10?

  Finance related important questions

Under the GASB Statement No. 34 reporting model for governmental entities, fund financial statements include separate sets of financial statements for:

  Concepts in strategic management and business policy

Resources: Riordan Virtual Organization, Concepts in Strategic Management and Business Policy, and Competitive Advantages Paper

  Social security taxes during this period

Social Security taxes during this period?

  Consider the given scenario brett a sales representative at

consider the given scenario. brett a sales representative at a store selling sports equipment received an offer to join

  What will be the new level of total reserves

If interest rates do not change, what will be the new level of total reserves? What must you assume to make this calculation? If interest rates do change, which way are they likely to move?

  What is the best option for ben from a strictly financial

What is the best option for Ben from a strictly FINANCIAL standpoint?

  On april 1 1998 which earns 85 compounded quarterly how

mehmet deposits 3350.00 in an account on april 1 1998 which earns 8.5 compounded quarterly. how much is in the account

  Zhao automotive issues fixed-rate debt at a rate of 700

zhao automotive issues fixed-rate debt at a rate of 7.00. zhao agrees to an interest rate swap in which it pays libor

  What will be its uae dirham profit from speculation

Abu Dhabi Islamic Bank has the capacity to borrow AED 50,000. If Abu Dhabi Bank's forecast is correct, what will be its UAE dirham profit from speculation over the thirty days period?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd