A five-year project has an initial fixed asset investment of $290,000, an initial NWC investment of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A five-year project has an initial fixed asset investment of $290,000, an initial NWC investment of $25,000, and an annual OCF of -$35,000. The fixed asset is fully depreciated over the life of the project and has no salvage value. If the required return is 11 percent, what is this project's equivalent annual cost, or EAC? Initial fixed asset investment Initial NWC investment Annual OCF Required return *Depreciation staight-line over life NPV EAC Cash flows Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 $ Sheet1 67 67 97 $ Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. $ 67 67 67 66 6 $ $ $ $ 290,000 25,000 (35,000) 11% $ 5 (315,000) 35,000 35,000 35,000 35,000 10,000 $ 429,520.11 A five-year project has an initial fixed asset investment of $290,000, an initial NWC investment of $25,000, and an annual OCF of -$35,000. The fixed asset is fully depreciated over the life of the project and has no salvage value. If the required return is 11 percent, what is this project's equivalent annual cost, or EAC? Initial fixed asset investment Initial NWC investment Annual OCF Required return *Depreciation staight-line over life NPV EAC Cash flows Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 $ Sheet1 67 67 97 $ Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. $ 67 67 67 66 6 $ $ $ $ 290,000 25,000 (35,000) 11% $ 5 (315,000) 35,000 35,000 35,000 35,000 10,000 $ 429,520.11
Expert Answer:
Answer rating: 100% (QA)
Answer NOTE Calculate the free cash flows Particulars 2 Initial invest... View the full answer
Related Book For
Elementary Statistics Picturing the World
ISBN: 978-0321911216
6th edition
Authors: Ron Larson, Betsy Farber
Posted Date:
Students also viewed these finance questions
-
A binomial experiment is listed. Determine whether you can use a normal distribution to approximate the distribution of x, the number of people who reply yes. If you can, find the mean and standard...
-
1. Determine whether you can develop a more accurate estimate of overhead costs. 2. Wagner is now preparing a bid for an important order that may involve a considerable amount of repeat business. The...
-
A certain medical device will result in an estimated $15,000 reduction in hospital labor expenses during its first year of operation. Labor expenses (and thus savings) are projected to increase at a...
-
Explain fully the role played by unplanned investment in inventories in determining equilibrium in the Keynesian model. Use the examples of AD > GDP and AD < GDP to illustrate your answer.
-
What is [OH] in a 0.00032 M solution of H2SO4? (Hint: assume both H+ ions ionize.)
-
Williams Manufacturing uses scrap metal to produce various tools, such as drill bits, hammer heads, saw blades, and nails. The CEO has asked you to analyze the saw blades division to determine asset...
-
A project has been selected for implementation. The net cash flow (NCF) profile associated with the project is shown below. MARR is 10 percent/year. a. What is the annual worth of this investment? b....
-
Talbot Industries is considering an expansion project. The necessary equipment could be purchased for $9 million, and the project would also require an initial $3 million investment in net operating...
-
A manufacturing company reports the following information. Raw materials inventory, ending Raw materials used Current Year $ 169,500 2,160,000 1 Year Ago 2 Years Ago $ 190,500 2,522,000 $ 197,500...
-
The bar codes above represent locations in a warehouse. How many units would be left in each location? If you picked 250 units from location 00000113774360000 If you picked 250 units from location 00...
-
A manufactuer of a new product for whiting teeth would like to investigate the effects of package design and label information on consumers perceptions of the product and their intentions to buy it....
-
Calculate the time dilation experienced by an observer on the surface of the Earth due to General Relativistic effects using: where Delta t is the time interval for the observer at the surface, Delta...
-
What are the principal types of tax allowance? Should extractive industries benefit from tax allowances or incentives beyond those available to other sectors? What do you understand by recoverable...
-
15. In some jurisdictions, there are "pretrial conterences, where the judge con before trial. Observational data suggest that pretrial conferences promote set fers with the opposing lawyers to settle...
-
a. How do taxes impact financial planning for a client? Income taxes of a taxpayer's income and therefore, an extremely important part of the financial planning process. Any financial plan that does...
-
Briefly Explain and Indicate the type of ruling or decision that has been made by the Commissioner and the extent to which it is binding on the taxpayers involved.? The following tax rulings were...
-
Question 1 An industrial cold room has four 200 mm thick walls made of concrete. The walls are insulated on the outside with a layer of foam 60 mm thick. Cladding with a thickness of 15 mm protects...
-
1A. If the researcher is concerned about the number of variables, the nature of the analysis, and completion rates, then, he/she is at which stage of the sampling design process (Figure 11.1 in the...
-
Find the probability of being dealt a full house (three of one kind and two of another kind). You are dealt a hand of five cards from a standard deck of 52 playing cards.
-
P = 0.0691 The P-value for a hypothesis test is shown. Use the P-value to decide whether to reject H0 when the level of significance is (a) = 0.01, (b) = 0.05, (c) = 0.10.
-
The tuition costs (in thousands of dollars) for 25 universities are listed. Use technology to find the first, second, and third quartiles. What do you observe? a. Enter the data. b. Calculate the...
-
Prove that the direct product of two representations is a representation, and that the character of the direct product is the product of characters for the representations.
-
Determine the irrep content for the equivalent reducible \(S_{3}\) representations \(\Gamma^{(4)}\) and \(\Gamma^{(5)}\) of Fig. 2.4 . Data from Fig. 2.4 F(1) (2) 1 (3) (4) r(5) (6) 1 0 0 0 0 0 0 1 0...
-
Use cosets to show that a finite group with an order that is a prime number can have no proper subgroups. Show that a finite group with order equal to a prime number is isomorphic to a cyclic group....
Study smarter with the SolutionInn App