You are a contractor for a client. Listed as Cost below you find your projected cost...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a contractor for a client. Listed as "Cost" below you find your projected cost expenditures for this project. Using the assumptions listed below, calculate the Total Cumulative Cash Flow. To do this, develop a table and submit the table as a separate assignment submission on Canvas (see Assignment description on Canvas). Then copy the required values (i.e. the ones highlighted with bold font) into the input fields in the table below. You need to do both!! Also: You may round your dollar values to full dollars. (Enter dollar values without a $; but don't forget to include the - sign, if you enter a negative value for the Total Cumulative Cash Flow. Do not enter - signs for the other cash outs! A negative "cash out" would be a cash in. ;-)) The table below shows the suggested structure for your cash flow calculation. Assumptions: 1. Your mark-up is 8% of the cost. 2. Payments are billed to the client at the end of the month and received 1 month(s) later. 3. Costs are paid for in the month they incur. 4. For each month, the client retains 15% of the billed amount (i.e. the Total Worth). 40% of these retentions are then paid back by the owner at the end of the project (i.e. in month 5). The remaining 60% of the retention are paid back by the owner in month 6. 5. A finance charge applies to all negative captims. The monthly interest rate is 1.4%. Finance charges are billed for at the end of the month (and should there be recorded as positive values in the cash flow, ie. the last row). The charges will be paid for in the month after they incur (i.e. after they were billed). Finance charges will not be billed back to the client. Month 2 23400 Cost 70000 27700 14800 (0) (0) Mark-up (8%) Total Worth (Monthly value billod to the ollent) Retention (15%) Monthly Cach in Cumulative Cash in Monthly Cach Out Cumulative Cash Out Total Cumulative Cash Flow Finanoe oharge bill (1.4) You are a contractor for a client. Listed as "Cost" below you find your projected cost expenditures for this project. Using the assumptions listed below, calculate the Total Cumulative Cash Flow. To do this, develop a table and submit the table as a separate assignment submission on Canvas (see Assignment description on Canvas). Then copy the required values (i.e. the ones highlighted with bold font) into the input fields in the table below. You need to do both!! Also: You may round your dollar values to full dollars. (Enter dollar values without a $; but don't forget to include the - sign, if you enter a negative value for the Total Cumulative Cash Flow. Do not enter - signs for the other cash outs! A negative "cash out" would be a cash in. ;-)) The table below shows the suggested structure for your cash flow calculation. Assumptions: 1. Your mark-up is 8% of the cost. 2. Payments are billed to the client at the end of the month and received 1 month(s) later. 3. Costs are paid for in the month they incur. 4. For each month, the client retains 15% of the billed amount (i.e. the Total Worth). 40% of these retentions are then paid back by the owner at the end of the project (i.e. in month 5). The remaining 60% of the retention are paid back by the owner in month 6. 5. A finance charge applies to all negative captims. The monthly interest rate is 1.4%. Finance charges are billed for at the end of the month (and should there be recorded as positive values in the cash flow, ie. the last row). The charges will be paid for in the month after they incur (i.e. after they were billed). Finance charges will not be billed back to the client. Month 2 23400 Cost 70000 27700 14800 (0) (0) Mark-up (8%) Total Worth (Monthly value billod to the ollent) Retention (15%) Monthly Cach in Cumulative Cash in Monthly Cach Out Cumulative Cash Out Total Cumulative Cash Flow Finanoe oharge bill (1.4)
Expert Answer:
Answer rating: 100% (QA)
1 2 3 4 5 6 Cost 70000 23400 27700 14800 0 0 Mark up 5600 18... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
4. Assume you are a contractor and you've been hired to build a house. Your direct labor costs are $57,000. Your materials will cost $83,500. What do you think you should charge for the job? and Why?...
-
Find these values without using your calculator. Then verify your answers with your calculator. a. b. c. sin tan cos(sin ) sin sin 17 Sin Sin
-
1- Suppose we have production function F(k,n) = Akan where k denotes the capital stock, n denotes the number of hours worked, a = .25, and A = 100, (a) why do we assume k 0? (b) Show that F (k,n) >...
-
Izmir A.S. issued convertible bonds at their face value of 100,000 lira on December 31, 2020. The bonds have a 10-year life with interest of 10 percent payable annually. At the date of issue, the...
-
For each of the following functions f: R R, determine whether f is invertible, and, if so, determine f-1. (a) f = {(x, y)|2x + 3y = 7} (b) f = {(x, y)\ax + by = c,b f 0} (c) f = {(x,y)\y =x3} (d) f...
-
Why are the atomic masses listed in the periodic table not whole numbers?
-
Using only the factor formulas given in Table 2.6, derive Equation 7.6 starting with Equation 7.3. TABLE 2.6 Summary of Discrete Compounding Interest Factors. To Find Given Factor Symbol Name P F...
-
Claire Company produces Tablets and Books. Total overhead costs traditionally have been allocated on the basis of direct labor hours. After implementing activity-based costing, managers determined...
-
If V f(xz, y/z), prove that zV =xVx-yVy. =
-
Macon Machines Company began operations on November 1, 2024. The main operating goal of the company is to sell high end robots. Customers may pay using cash or if appropriate, credit is extended to...
-
How does the escalating susceptibility of cyberspace to various forms of attacks manifest, and what strategies does the Department of Homeland Security propose to bolster online safety measures for...
-
How do interdisciplinary approaches, such as ecological economics, institutional economics, and behavioral finance, enrich our understanding of complex socio-economic systems by integrating insights...
-
The company is associated with one other company. Maximum's share of the limit is $375,000. The associated company has no AAII for either of 2021 or 2022. Required: A. Determine Maximum's 2022 small...
-
How do advanced theories of globalization, such as the global production network (GPN) framework, network theory, and world-systems theory, provide insights into the evolving dynamics of global...
-
Based on your Daily Spending Diary, describe actions that you might take to identify and achieve various financial and investment goals.
-
what is one benefit and a drawback of The central bank finances itself from the earnings on its assets and turns the balance over to the government?
-
A company looks to maximize its profits. (a) The demand function relates the price of a product and the quantity sold. Suppose that the company sells 1000 units when the price is 10 dollars, and...
-
The electric field due to a line charge is given by where l is a constant. Show that E is solenoidal. Show that it is also conservative. E =
-
Show the effect of time on problem-solving and give practical examples of each of the different timescales.
-
As a project manager in a development activity for a new range of computer software, discuss how uncertainty may be handled.
-
Surely it would be better for project managers simply to deal directly with suppliers? Under what circumstances would such an arrangement be beneficial and when would it be inappropriate?
-
A project developed in PL/1 is expected to take 30 months. Assuming the same ratios as those shown in the table below, compare the duration, level of effort, and software size between a project...
-
What is the difference between tabular output and zoned output?
-
Develop a questionnaire for mass employee distribution based on your findings from the previous interviews. Why are we completing the analysis with an anonymous survey?
Study smarter with the SolutionInn App