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

  Computing the percentage returns

Assume a stock had the initial price of= $65.3 per share, paid the dividend of $4 per share in the year, and had the ending share price of=$107.67. Compute the percentage returns?

  Draw the graphs of the payo

Hold one put option P100 and two call option C120; short one put option P80 and one call optionC150 .

  Find the dividend yield

After this time, growth is expected to return to the long-run constant rate of 8 percent. The required return on ABC stock is 13 percent.  What should the dividend yield (1/P0) be today? (hint you need to calculate the price before you can find the..

  What is the companys earnings expected growth rate

What is the company's earnings expected growth rate? (If you solve this problem with algebra round intermediate calculations to 6 decimal places, in all cases round your final answer to two decimal places, e.g. 8.72%.)

  Explain the fact that their roe is about 12 percent

It is widely known that grocery chains have low profit margins-on average, they earn about 1 percent on sales. How would you explain the fact that their ROE is about 12 percent? Does this seem logical?

  What is the maximum increase in sales that can be sustained

the most recent financial statement for throwing copper co. are shown hereincome statementbalance

  What price is the minimum that should be accepted

What price is the minimum that should be accepted? What implications are there for the company, in both the short term and the long term, of accepting this special order?

  Did these assets change in value on the firm financial state

A U.S. firm has total assets valued at €125,000 located in Germany. This valuation did not change from last year. Last year, the exchange rate was €1.1 = $1. Today, the exchange rate is €0.8 = $1. By what amount did these assets change in value on th..

  If you deposit money today in an account that pays 7

if you deposit money today in an account that pays 7 annual interest how long will it take to double your money? round

  Develop a three- to four-page analysis of the techniques

in this assignment you will compare and evaluate risk management techniques from experts in the field. go to the

  How much must the donor contribute today to fully fund

If the scholarship is invested to earn an annual real return of 5 percent, how much must the donor contribute today to fully fund the scholarship?

  Examine the data from 5 years ago. according to the expectat

On the same set of axes, draw the yield curve at each of the three given times. Label each curve in part a with its general shape (downward-sloping, upward-sloping, flat). Describe the general interest rate expectation existing at each of the three t..

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