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...
-
Caribou Coffees Cash Flow Statement Following is the current asset and current liability portion of the balance sheet for Caribou Coffee as of December 30, 2007, and December 31, 2006: Required 1....
-
The measured shaft torque on the turbomachine shown in Fig. P12.2 is \(-60 \mathrm{~N} \cdot \mathrm{m}\) when the absolute velocities are as indicated. Determine the mass flowrate. What is the...
-
Kumar Company has two producing departments and two support centers. The following budgeted data pertain to these four departments: Required: 1. Allocate the overhead costs of the support departments...
-
6. [5 points] Resolving ties by vertex id number, find topological sort of the following graph.
-
Brandywine Homecare, a not-for-profit business, had revenues of $12 million in 2007. Expenses other than depreciation totaled 75 percent of revenues, and depreciation expense was $1.5 million. All...
-
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...
-
Assume the same facts as in Problem 2-57. a. Given the nurserys operating prospects, what business forms might Paula and Mary consider and why? b. In light of their proposed use of debt and equity,...
-
STATISTICAL GUIDE The symbol for the chi-square test value is x. This is helpful to know, as p in the study below the authors report the value for x. Every value for has a p-value associated with...
-
Causes and Effects of thExplain why fixed assets are recorded at historical costs (also what is included/excluded in this cost) and not at fair market value. e Financial Crisis of 2008
-
where do i find the the independent auditing firm who issued the audit opinion on 10k?
-
Amy invested $2,560 for 275 days at a simple interest rate of 3.50% p.a. How much more or less interest would he have earned on the investment if his money was growing at a simple interest rate of...
-
is this true: Time 1: Sales = 500 and Cash 50 =+ long-term debt 100 + capital stock 100 + opening retained earnings 0 + net income 50 + current liabilities 100 - inventory 100 - fixed assets 200 Time...
-
Why does a knock-out call cost less than the corresponding vanilla call?
-
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
-
A consultant advises that a fund pays out $100,000 at the end of 5 years. Provided $12,000 is invested in the fund at the start of each year, beginning immediately and continuing up to and including...
-
Durco Automotive needs a $2 million balance in its contingency fund 3 years from now. The chief financial officer (CFO) wants to know how much to deposit now into Durco's high-yield investment...
-
3. Create a chart for gross margin less R&D and capital costs calculations. a. Calculate gross margin less R&D and capital costs for options A and B. b. Graph total gross margin less R&D and capital...
Study smarter with the SolutionInn App