Determine the monthly cash flows and total cash generated

Assignment Help Finance Basics
Reference no: EM131136588

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 aspreadsheet. 

Reference no: EM131136588

Questions Cloud

Difference between the cash flow and the deductibility : Calculate the annual difference between the cash flow and the deductibility for tax purposes of the purchase of $10,000 of office furniture. The furniture is depreciated using the half-year convention and the 200% declining-balance method. The furnit..
Calculate the annual difference between the cash flow : Calculate the annual difference between the cash flow and the deductibility for tax purposes of the purchase of a $20,000 truck. The truck is depreciated using the half-year convention and the 200% declining-balance method. The truck is purchased out..
Determine the marginal tax rate for a corporation whose fede : Determine the marginal tax rate for a corporation whose federal tax rate is 39% and whose state tax rate is 7.25%.
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.

Reviews

Write a Review

Finance Basics Questions & Answers

  Information to complete financial statements

The new accounting clerks are beginning to gather information to complete financial statements. The accountants will first need to understand what type of information will be needed from the source documents and how these documents tie to financia..

  Swann company manufactures sleeping bags a heavy-duty

swann company manufactures sleeping bags. a heavy-duty zipper is one part the company orders from an outside supplier.

  What is a family limited partnership

Please explain a "defined value clause" and state how this can reduce (or increase) taxes.

  What information from your daily spending records could help

1. What information from your daily spending records could help you achieve your financial goals? 2. Based on your observations of our society and the economy , what types of stocks might you consider for investing now or in the near future?

  Prepare a table that shows the assets-liabilities

Marketing strategy 1 What are the main products ( two paragraphs)

  Major tax implication of a pre-death or post-death

Discuss one major tax implication of a pre-death or post-death situation, how it can be addressed, and the rules for minimizing tax when possible. Further discuss whether the tax deferred savings and in some cases tax deductions for contributions ..

  What is the required return on okefenokee stock

The treasurer estimates that the beta of the stock is currently 1.5 and that the expected risk premium on the market is 6%. The Treasury bill rate is 4%. Assume for simplicity that Okefenokee debt is risk-free and the company does not pay tax.

  Which of the over four choices would you pick

Which of the over four choices would you pick?

  What is the total amount of interest that was paid

Assume that your aunt sold her house on December 31 and that she took a mortgage in the amount of $10,000 as part of the payment. The mortgage has a quoted (or nominal) interest rate of 10 percent, but it calls for payments every 6 months, beginning ..

  What is the real rate of return on these bonds

Bonds outstanding that pay a 5% semiannual coupon, have a 5.5% yield-to-maturity, and a face value of $1,000. The current rate of inflation is 4%. What is the real rate of return on these bonds?

  What is a sensitivity analysis

Does your firm use any budgeting software or do you to keep track of your budget? If you do not have a budget will you develop one based on the information you got from this class?

  One year ago peyton purchased 3600 shares of broncos stock

one year ago peyton purchased 3600 shares of broncos stock for 101124. today he sold those shares for 26.60 a share.

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