Using Table 6.2 from page 161 in the book. Make whatever assumptions seem reasonable to you....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using Table 6.2 from page 161 in the book. Make whatever assumptions seem reasonable to you. What are the critical variables? Build a spreadsheet that you can use determine the NPV of the project as is and with the sensitivities that you create. 1 Capital investment and disposal 2 Change in working capital 3 Sales 4 Cost of goods sold 5 Other costs 6 Tax on income 7 Operating cash flow (3-4-5-6) 8 Net cash flow (1+2+7) Present value at 20% Net present value = 9 10 0 -10,000 1 0 -550 523 837 4,000 2,200 -1,400 -1,434 -2,600 -1,080 -12,600 -1,630 -12,600 -1,358 +3,520 (sum of 9) 0 0 2 0 -739 12,887 7,729 1,210 828 3,120 2,381 1,654 3 Period 0 -1,972 32,610 19,552 1,331 3,550 8,177 6,205 3,591 4 0 -1,629 48,901 29,345 1,464 5,778 12,314 10,685 5,153 5 0 1,307 35,834 21,492 1,611 3,902 8,829 10,136 4,074 6 0 1,581 19,717 11,830 1,772 1,586 4,529 6,110 2,046 >TABLE 6.2 IM&C's guano project-initial cash-flow analysis assuming straight-line depreciation ($ thousands). a Salvage value of $1,949 less tax of $507 on the difference between salvage value and ending book value. 7 1,442ª 2,002 0 0 0 3,444 961 Using Table 6.2 from page 161 in the book. Make whatever assumptions seem reasonable to you. What are the critical variables? Build a spreadsheet that you can use determine the NPV of the project as is and with the sensitivities that you create. 1 Capital investment and disposal 2 Change in working capital 3 Sales 4 Cost of goods sold 5 Other costs 6 Tax on income 7 Operating cash flow (3-4-5-6) 8 Net cash flow (1+2+7) Present value at 20% Net present value = 9 10 0 -10,000 1 0 -550 523 837 4,000 2,200 -1,400 -1,434 -2,600 -1,080 -12,600 -1,630 -12,600 -1,358 +3,520 (sum of 9) 0 0 2 0 -739 12,887 7,729 1,210 828 3,120 2,381 1,654 3 Period 0 -1,972 32,610 19,552 1,331 3,550 8,177 6,205 3,591 4 0 -1,629 48,901 29,345 1,464 5,778 12,314 10,685 5,153 5 0 1,307 35,834 21,492 1,611 3,902 8,829 10,136 4,074 6 0 1,581 19,717 11,830 1,772 1,586 4,529 6,110 2,046 >TABLE 6.2 IM&C's guano project-initial cash-flow analysis assuming straight-line depreciation ($ thousands). a Salvage value of $1,949 less tax of $507 on the difference between salvage value and ending book value. 7 1,442ª 2,002 0 0 0 3,444 961
Expert Answer:
Answer rating: 100% (QA)
Critical Variables The following are critical variables in the NPV calculation for IMCs guano projec... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Use the spreadsheet for the guano project in Chapter 6 to undertake a sensitivity analysis of the project Make whatever assumptions seem reasonable to you What are the critical variables What should...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
Approximately 8.33% of men are colorblind. You survey men from a large population until you find one who is colorblind. a. Explain in words what X is in this situation and what values it can take. b....
-
Mr. Norman is going to set up a new business in Singapore on 1 January 20X8. He will invest $150,000 in the business on that date and has made the following estimates and policy decisions: 1....
-
What is the standing requirement in the law of search and seizure? What is its purpose?
-
According to an article in the Economist magazine, in 2023, the legal minimum wage in Venezuela was 130 bolivars per month, and the inflation rate during 2023 was expected to be 500 percent. How many...
-
The Delta Company uses the completed-contract method of accounting for long-term construction contracts. The company started business in 2005 and prepared the following income statements: The company...
-
a) Explain the difference between quantum Mechanics and Classical Mechanics b) Explain the Bohr's form of quantization of Energy [4 mks] [3 mks] c) Calculate the penetration distance for a very small...
-
What are the triads using roman numerals and figured bass numbers for this excerpt? 30-3. Use Roman numerals and figured bass numbers to identify triads in these works. a. Schubert, "Death and the...
-
Q#4. The dynamical system problem after mathematically modeling resulted into the following linear second order ordinary differential equation. Find the solution of the problem dr dr +r = 0 1n 0....
-
This case has all the ingredients for generating considerable student interest and provoking a lively, interesting class discussion with divergent opinions among class members. The case presents...
-
Xerox's internal benchmarking strategy has paid off by examining the operations of its various country divisions. For example, Xerox Europe, a $6 billion subsidiary of Xerox Corp., formed teams to...
-
A particular type of radio wave has a frequency of 2.56 108 s-1. Calculate the wavelength of this radiation in meters. Enter your answer with no units
-
In our everyday life, and with the domination of social media in our life's aspects, publicity become almost everything for most individuals and businesses , Do you agree.
-
Why are taxes necessary? Taxation is essential to the functioning of the modern state. To pay for the things that we need to live our daily lives, such as water, roads, security, and education, the...
-
Company ABC manufactures components for use in the production of one of its finished products. When 12,000 units are produced, the total cost per unit is $35, broken down as follows: Direct materials...
-
What services are provided by the provincial and territorial governments?
-
LilyMac Studios, a national chain of photography studios, is considering opening up a chain of coffee shop/art galleries. While the existing operations of the firm have a beta of 1.17, the new chain...
-
Suppose that the 2016 actual and 2017 projected financial statements for AFS are initially shown as follows. In these tables, sales are projected to rise by 14 percent in the coming year, and the...
-
You own $25,000 in subordinated debt of Local Crossings, Inc. which declared bankruptcy on May 15, 2018. Local Crossings' balance sheet at the time of the bankruptcy filing is listed below. The...
-
Figure \(\mathrm{P} 10. 16\) represents two stroboscopic pictures (taken at the same flash rate) of a block moving along a ramp that exerts a frictional force on the block. In one sketch, the block...
-
You keep a chalkboard eraser pressed against the chalkboard by using your finger to exert a horizontal force on the back of the eraser. (a) Which type of force (call it force A) keeps the eraser from...
-
In Figure P10.18, all surfaces experience friction. Is the magnitude of the horizontal component of the force exerted by \(A\) on \(B\) greater than, equal to, or less than the magnitude of the...
Study smarter with the SolutionInn App