Set up a spreadsheet similar to Figure 12-11 to solve Problem 4. FIGURE 12-11 The housing contract
Question:
Set up a spreadsheet similar to Figure 12-11 to solve Problem 4.
FIGURE 12-11
The housing contract from Problem 3 continues on into the next year, with the last housing start occurring in April, as shown in the following table. Determine the monthly cash flows and total cash generated by the project at the end of each month and just before each payment is received from the projects owner for the remaining months in the year.
What is the maximum amount of cash invested by the company during this year?
Transcribed Image Text:
Before Payment Is Received 5,800 6,700 20,200 9.500 9,500 (17.100 20,200) 20,200 20,200 0,200 8,400 5,800 4,800 17.100() 9.50 (20,200 (8,400 5,800 4,800 9.500)(20,200 (5,800 28Cash Flow 19,200 (64.900) (154,100(179,500 202,100) (172,300) (110,900) End of Month 5,800 3,000 3,600 2,300 7.500 2,300 41Tvp 3,600 2,300 (5,800) 7.500 2,300 3,000 Tvpe 1 5,800 6,700 5,800 Tvpe 2 19.200)( (19,200) 58 Cash Flow 25,200 44,400) 50,700 (49,700) (23,100 10 12 33|33|2| 2237|33 122 5566 er 22 333 2333 7779 1225566 888 1 (2 (1 (4 (4 (4 17 20 20 20 8889566 2 8999 5556 233 779-12 2 5556 445 8777 1-2 5666 E Pa 22889 5666 3 899 556 556 6 122 112 1222 111 1122 122112 1122 ㄒㄒㄒㄒㄒㄒㄒㄒㄒㄒ ㄒㄒㄒㄒㄒㄒㄒㄒㄒㄒㄒㄒㄒ-as iT_T TTT TTTT TTTT TTT TTTT TTT T- 0 12345 6 7 8 9 10 1 345678 1 22 22 23 22 222 2333 33 34 35 373 3042 3456 789 5555 455 555 Monthly Starts by Type MONTH Jan. Feb. March April TYPE 1 4 2 TYPE 2 2 2
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 45% (11 reviews)
Before Payment is Received Starts Dec Jan Feb March April May June July Aug Sept Sept Type 1 2000 Type ...View the full answer
Answered By
Neeraj Sharma
Hello,
I am Neeraj Sharma. I am in teaching field since 2008, a very early time of my age. Teaching has always been a passion for me from my childhood. I think knowledge sharing play a very essential role in the development of nations and it is must for growth of humans. After completing my graduation, I started teaching math in Institutes and currently I am teaching in a university. The reason of choosing math was simple. Math is the subjuct without which every other subject is incomplete and it actually play role in our real life. Every science invention and all the facilities which we see around us is the result of mathematical calculations. I would love to share my knowledge of mathematics which will definitely counter the fear of calculations.
0.00
0 Reviews
10+ Question Solved
Related Book For
Construction accounting and financial management
ISBN: 978-0135017111
2nd Edition
Authors: Steven j. Peterson
Question Posted:
Students also viewed these Finance questions
-
The housing contract from Problem 3 continues on into the next year, with the last housing start occurring in April, as shown in the following table. Determine the monthly cash flows and total cash...
-
Set up a spreadsheet similar to Figure 12-11 to solve Problem 3. FIGURE 12-11 A construction company is bidding on a contract to build homes for a developer. The project consists of two types of...
-
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...
-
Write a static method lg() that takes an int argument n and returns the largest integer not larger than the base-2 logarithm of n. Do not use the Math library.
-
A disabled tanker leaks kerosene (n = 1.20) into the Persian Gulf, creating a large slick on top of the water (n = 1.30). (a) If you are looking straight down from an airplane, while the Sun is...
-
Sulphur trioxide is produced according to the reaction \[ \mathrm{SO}_{2}(\mathrm{~g})+\frac{1}{2} \mathrm{O}_{2}(\mathrm{~g}) ightarrow \mathrm{SO}_{3} \] Given that \[ \begin{aligned} & \Delta...
-
Could genetic algorithms be used to play complex games such as chess and checkers? Explain your answer.
-
An analysis of comparative balance sheets, the current years income statement, and the general ledger accounts of Gygi Corp. uncovered the following items. Assume all items involve cash unless there...
-
Ruby Ltd provides a defined benefit superannuation plan for its senior managers. The following information is available in relation to the plan. Present value of the defined benefit obligation 1 July...
-
Ann Carter, Chief Financial Officer of Consolidated Electric Company (Con El), must make a recommendation to Con Els board of directors regarding the firms dividend policy. Con El owns two...
-
Set up a spreadsheet to solve Problem 2. In Problem 2, A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction...
-
Set up a spreadsheet to solve Problem 5. In Problem 5, the construction company in Problem 1 decides to act as the owner on the project. The construction company will be paid $500,000 for the project...
-
What is the relevance of Houses pathgoal theory to managers?
-
Find the limit (if it exists) as \(n ightarrow \infty\) for each of the sequences in Problems 43-56. \(\lim _{n ightarrow \infty} \frac{15+9 n-6 n^{2}}{2 n^{2}-4 n+1}\)
-
Suppose the number (in millions) of bacteria present in a culture at time \(t\) is given by the formula \[N(t)=2 t^{2}-200 t+1,000\] Use this formula in Problems 57-60. Find the instantaneous rate of...
-
Evaluate the integrals given in Problems 41-46. \(\int_{1}^{5}(1+6 x) d x\)
-
Suppose the circle in Figure 18.6 has radius 1. Table 18.1 shows the approximate areas of inscribed polygons. Figure 18. 6 Table 18. 1 What is the limit of the approximate area? A3 As A A12
-
The total accumulated cost and revenue (in millions of dollars) for a piece of business machinery is \[C^{\prime}(t)=\frac{t}{20} \quad \text { and } \quad R^{\prime}(t)=-e^{(-t)}\] where \(t\) is...
-
a. Outline the kinds of information you would expect to see in a company's significant accounting policies note to the financial statements. b. How should a company decide what to include in that...
-
Wimot Trucking Corporation uses the units-of-production depreciation method because units-of-production best measures wear and tear on the trucks. Consider these facts about one Mack truck in the...
-
When members of minority cultures feel that they have to behave in ways similar to the majority culture, this is called _________. (a) biculturalism (b) symbolic leadership (c) the glass ceiling...
-
The risk-free rate of return, rRF, is 11 percent; the required rate of return on the market, rM, 14 percent; and Upton Companys stock has a beta coefficient of 1.5. a. If the dividend expected during...
-
Define each of the following terms: a. Option; call option; put option b. Exercise value; strike price c. Black-Scholes Option Pricing Model
-
Define each of the following terms: a. Option; call option; put option b. Exercise value; strike price c. Black-Scholes Option Pricing Model
-
Consider a hedonic pricing model for educational attainment. Would isoprofit curves for the firm be upward or downward sloping? Explain. Question 2 (Mandatory) (3 points) Listen For workers, would...
-
6. Determine the sum of the measures of the interior angles of this polygon.
-
Consider the perfectly competitive Corn industry. It is initially in long run equilibrium at quantity Q0 and price P0. a) Draw a supply and demand diagram for the Corn market showing this...
Study smarter with the SolutionInn App