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.
-
Let the Poisson random variable U be the number of calls for technical assistance received by a computer company during the firm's nine normal workday hours. Suppose the average number of calls per...
-
For your senior project, you would like to build a cyclotron that will accelerate protons to 10% of the speed of light. The largest vacuum chamber you can find is 50 cm in diameter. What magnetic...
-
Based on your experiences in college, draw and label a conceptual model that shows the factors that lead to your satisfaction (or dissatisfaction) with a course?
-
Calculating Rates of Return although appealing to more refined tastes, art as a collectible has not always performed so profitably. During 2003, Sothebys sold the Edgar Degas bronze sculpture Petite...
-
This has to do with linear programming. Creatine L-Glutamine BCAAs Cost (grams) (grams) (grams) ($) Xtendo 0 2.5 7 0.80 (Scivation) RecoverMode 3 3 5 1.20 (Evolution Nutrition) Strongevity 3 1 0 1.00...
-
Castergourd Home Products makes two types of butcher-block tables: the Beefeater and the Deutschlander. The two tables are made in the same facility and require the same amount of labor and...
-
AS24,000 bond redeemable at par on January 21, 2009 s purchased on Apri 26, 2001 Interest n 84% payable sem annuly and the yeld in 97% compounded semi annualy (a) What is the cash price of the bond?...
-
What security will he most likely be able to sell at the day? 2. At what price will the bank buy that security from him? 3. At what price will he be able to sell it to the bank? 4. At what...
-
Use the CAPM to find the required return for asset X and Y. Asset X: Year 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Cash Flow $1,000 $1,500 $1,400 $1,700 $1,900 $1,600 $1,700 $2,000 $2,100...
-
The data in the table below was estimated using returns for the period 2001 to 2011. E(r) MICROSOFT, factor BCOCA-COLA, factor BCHEVRON, factor BGE, factor THML 4.1% 1.3% -0.15 0.15 -0.4 -0.26 TM-Tf...
-
Evaluate the Laplacian of 4. Evaluate 1/(x+2y+z) 3rd 3rdy - 2ydr for the contour (0,0) (1,0) (1,1) (1,2) (2, 2) (2,0) (1,0) (1,-1) (0,-1) (0,0)
-
Below you'll find data for two enterprises. Please calculate the value of shares from new issue using EV/ EBITDA. The value of cash and equivalents in the company serving as the benchmark of...
-
2.(4 pt) In 1984, how did FCC try to create a competitive environment for long distance market? 3. (4 pt) In the past, voice and data networks are two separated networks. List four advantages...
-
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...
-
The treatment of outflows on account of dividend and interest is highly debatable as to their activity classification. Give a serious thought to the issue and express your opinion about the best...
-
Consider the same setting as Problem 18, but suppose instead 80% of the shareholders redeem their shares, and no warrants are exercised. Data from problem 18 a. What is the amount of cash per share...
-
Reliance Industries Ltd. is the biggest private sector company in India. The following fact sheet about the company and its peer group, as extracted from Capitaline Plus database is reproduced in the...
Study smarter with the SolutionInn App