You are adding a machine to an existing factory that costs $4 million (this is both...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are adding a machine to an existing factory that costs $4 million (this is both an investment and a loan). - Years 1-4 $8 million production with a $1 million decrease each of the 4 yrs. - Years 5-7 = -4.5 million that that decreases by $1 million for each of the 3 years Create a table with: interest ranging from 0% o 50% increasing by 5% increments NPV for each of these %. Use NPV function. Tip: do not include the cost of machine in the function; add that amount to NPV. - Plot the NPV's for all %s. - What is the IRR (s)? Not only graphically, but solve for IRR(S) using Goal Seek for the problem. Cashflow: Year 0 -4 million 1 2 3 4 3.5 millior 2.5 millior 1.5 million .5 million 5 6 7 -.5 millior -1.5 millio -2.5 million You are adding a machine to an existing factory that costs $4 million (this is both an investment and a loan). - Years 1-4 $8 million production with a $1 million decrease each of the 4 yrs. - Years 5-7 = -4.5 million that that decreases by $1 million for each of the 3 years Create a table with: interest ranging from 0% o 50% increasing by 5% increments NPV for each of these %. Use NPV function. Tip: do not include the cost of machine in the function; add that amount to NPV. - Plot the NPV's for all %s. - What is the IRR (s)? Not only graphically, but solve for IRR(S) using Goal Seek for the problem. Cashflow: Year 0 -4 million 1 2 3 4 3.5 millior 2.5 millior 1.5 million .5 million 5 6 7 -.5 millior -1.5 millio -2.5 million
Expert Answer:
Answer rating: 100% (QA)
To calculate the Net Present Value NPV at different interest rates and determine the Internal Rate o... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these corporate finance questions
-
A children's story features a rabbit and a turtle who each live in a forest at the edge of a lake. The rabbit can hop at a speed that allows him to travel 67.5 km in 1.5 hours. The turtle can swim at...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Suppose a parent was earning $20,000 per year working at a local firm. The parent then decides to quit his job in order to care for his child, who was being watched by a babysitter for $10,000 per...
-
Refer to the data for Rocky Mountain Resort Inc. in P4-12B. Instructions (a) Prepare the closing journal entries. (b) Post the closing entries to the T accounts prepared in P4-12B. (c) Prepare a...
-
A study of 102 patients who had digestive-tract surgery found that those who chewed a stick of gum for 15 minutes at mealtimes ended up being discharged after an average of 4.4 days in the hospital,...
-
A merger is 'a business combination that results in the creation of a new reporting entity formed from the combining parties, in which the combining entities come together in a partnership for the...
-
The current organization structure of Blue Sky Company, a manufacturer of small sailboats, is presented below. a. What operational problems (for example. inefficiency, errors, fraud) do you think...
-
Transcribed image text: 4. ( 20 points). Your company has an 8 -unit housing project. The information of the project is showed below. The project deadline is 44 days. Consider the buffer between...
-
Several years after reengineering its production process, Dettling Corporation hired a new controller, Alana Metzgar. She developed an ABC system very similar to the one used by Dettling's chief...
-
. Problem 3-29 (LG 3-6) a. What is the duration of a two-year bond that pays an annual coupon of 11.4 percent and has a current yield to maturity of 13.4 percent? Use $1,000 as the face value. (Do...
-
Here is a proposed income statement of a children's clothing store: Kids 2 Klad Statement of Profit and Loss, December 31, 20X1 Revenues: Sale 1,300,000 Increase in market of land and building 50,000...
-
Suppose a pivate equity fund has the following capital distributions and capital drawdowns. The 2021 flows occur at time zero. Aggregated 2021 Aggregate distributions 0 Aggregate drawdowns 2022 0...
-
Refer to Roger Mfg. what is the total service costs allocated to the Assembly Department using the direct method?* Refer to Roger Mfg. If the company uses the step-down method of allocating service...
-
What are the mind boggling physiological components fundamental the body's pressure reaction, and how might a comprehension of these cycles illuminate progressed procedures for stress the executives?
-
Consider the following static game of complete information. Two restaurants, A and B, are deciding whether to open on Saturday. If only one of them opens, the one that opens earns 10 - c and the one...
-
148 149 146 BUDGETED INCOME STATEMENT 147 Budgeted Income Statement 150 151 152 Net sales 15:3 Cost of goods sold 154 Gross margin 155 Selling & administrative expenses 156 Net operating income 157...
-
Represent each of the following combination of units in the correct SI form using an appropriate prefix: (a) m/ms, (b) k m, (c) k s /mg, and (d) k m N.
-
Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-4. Ivan and Irene paid the following in 2012 (all by check or can otherwise be...
-
Mary paid $2,000 of state income taxes in 2012. The total sales tax she paid during 2012 was $5,500, which included $3,000 for the cost of a new car. How should Mary treat the taxes paid on her 2012...
-
Why may a focus on operating revenue be preferable to a focus on total revenue?
-
Which approach do you think is best for valuing a business: the DCF approach or the market multiple approach? Explain the rationale behind your answer. p7
-
Why is EVA a better measure of financial performance than are accounting measures such as net income or earnings per share?
Study smarter with the SolutionInn App