Set up a spreadsheet similar to Figure 12-11 to solve Problem 3. FIGURE 12-11 A construction company
Question:
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 homes and is scheduled to begin in September. The expected monthly housing starts, the cash flow that occurs between the end of the previous month and receipt of payment from the owner, and the cash flow for the entire month are shown below. 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 the remaining months of the year?
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 Sept TYPE 1 TYPE 2 4 Nov Dec BEFORE PAYMENT Is RECEIVED (n) S) TYPE 1 -5,400 -8,200 -15,500 -4,400 -2,000 TYPE 1 -5,400 -1,800 7,300 2,200 3,000 9,500 END OF MONTH (n) ($) TYPE 2 -6,500 -2,400 9,300 2,800 3,400 11,900 MONTH TYPE 2 -6,500 -8,700 -19,800 -4,400 -1,700 0 4
Step by Step Answer:
Before Payment is Received Starts Sept Oct Nov Dec Sept Type 1 5400 8200 ...View the full answer
Construction accounting and financial management
ISBN: 978-0135017111
2nd Edition
Authors: Steven j. Peterson
Students also viewed these Finance questions
-
A construction company is bidding on a contract to build homes for a developer. The project consists of two types of homes and is scheduled to begin in September. The expected monthly housing starts,...
-
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...
-
A perfectly competitive industry consists of two types of firms: 100 firms of type A and 30 firms of type B. Each type A firm has a short-run supply curve sA(P) = 2P. Each type B firm has a short-run...
-
What levels of visibility may be assigned to an attribute or an operation?
-
The lens in a Newton's rings experiment (see Problem 75) has diameter 20 mm and radius of curvature R = 5.0 m. For = 589 nm in air, how many bright rings are produced with the setup? (a) In air (b)...
-
Anatolia Limited is trying to determine the value of its ending inventory at February 28, 2017, the companys year-end. The accountant counted everything that was in the warehouse as of February 28,...
-
Deferred Tax (Appendix) Thad Corporation has compiled its 2008 financial statements. Included in the Long-Term Liabilities category of the balance sheet are the following amounts: Required 1....
-
The following information relates to Ponte Manufacturing Companys workers compensation insurance premiums for 2016. On January 15, 2016, the company estimated its premium for workers compensation...
-
A video rental store will cost $650,000 to open. Assuming annual sales of $1 million, variable costs of 35%, fixed costs of $300,000, depreciation of $100,000, and a tax rate of 35%, calculate the...
-
The following cost information is presented for Phoenix Ltd. for the most recent period. Cost of direct material used in manufacturing..............................$62,000 Direct labour...
-
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...
-
The following information is available for Sano Instrument Manufacturing Company for 2008: Instructions 1. Prepare the 2008 statement of cost of goods manufactured. 2. Prepare the 2008...
-
The BASF Corporation is considering the production of a new carbon material to be used in the manufacturing of wide-body aircraft. To produce this material, an investment of $4 million in plant and...
-
You make the following deposits into an account that pays interest at 8 percent annually. Open the account today with a deposit of $10,000, then $10,000 for the first and second year, $12,000 for the...
-
Discuss the implications of thermodynamic limits on the scalability and energy efficiency of quantum computers, considering both heat generation and decoherence .
-
After testing of controls, the auditor has revised their opinion on control risk for an assertion downward. In what direction does this cause the auditor to revise the inherent risk, risk of material...
-
Sean was about to be promoted to a new position as "Product Department Manager" for the wholesale company "Pastries Unlimited". He often worked back late for no extra pay to complete special projects...
-
The following financial statement was prepared by employees of Walters Corporation. Note 1: New styles and rapidly changing consumer preferences resulted in a 71,500 loss on the disposal of...
-
When a company has a contract involving multiple performance obligations, how must the company recognize revenue?
-
Engineers, scientists, and information systems specialists are likely to become part of separate_________ subcultures in an organization. (a) ethnic (b) generational (c) functional (d) occupational
-
Investors require a 15 percent rate of return on Levine Companys stock (rs =15%). a. What will be Levines stock value if the previous dividend was D0 = $2 and if investors expect dividends to grow at...
-
Wayne-Martin Electric Inc. (WME) has just developed a solar panel capable of generating 200 percent more electricity than any solar panel currently on the market. As a result, WME is expected to...
-
Tausig Technologies Corporation (TTC) has been growing at a rate of 20 percent per year in recent years. This same growth rate is expected to last for another 2 years. a. If D0 = $1.60, rs = 10%, and...
-
The following data were taken from the financial statements of Gates Inc. for the current fiscal year. a . Ratio of fixed assets to long - term liabilities b . Ratio of liabilities to stockholders'...
-
Dowell Company produces a single product. Its income statements under absorption costing for its first two years of operation follow. \ table [ [ Sales ( $ 4 8 ner unit ) ] , [ ] , [ Cost of goods...
-
What is the amount of cash budgeted for Selling and Administrative expenses for the year? Select one: a . $ 8 5 3 , 8 0 0 b . $ 6 1 3 , 8 0 0 c . None of these options are correct. d . $ 7 9 5 , 0 0...
Study smarter with the SolutionInn App