Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated on a three-year MACRS schedule. The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The project requires an initial investment in net working capital of $300,000, and the fixed asset will have a market value of $210,000 at the end of the project. What is the project's Year 0 net cash flow? Year 1? Year 2? Year 3? The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? Asset investment $ Estimated annual sales $ Costs $ Net working capital $ Pretax salvage value $ Tax rate Project and asset life Required return MACRS percentages Year 1 Year 2 Year 3 2,900,000 2,190,000 815,000 300,000 210,000 21% 3 12% 0.3333 0.4445 0.1481 FILE Paste Clipboard A1 20 AE HOME Calibri B IU Net income NPV INSERT 21 22 Sales 23 Costs 24 Depreciation 25 EBT 26 Taxes 27 28 29 30 31 32 Aftertax salvage value 33 Sell equipment 34 Taxes 35 Aftertax cash flow 36 37 38 39 OCF 40 41 42 43 44 READY Attempt(s) I Net cash flow Fixed asset book value in three years Capital spending Net working capital Font Sheet1 11 PAGE LAYOUT A A D H C Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to calculate the NPV. Calculating NPV - Excel DATA FORMULAS Alignment Number E REVIEW F VIEW Conditional Format as Cell Formatting Table Styles Styles G Cells Editing 14 E | Sign In J + 60% Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.9 million. The fixed asset will be depreciated on a three-year MACRS schedule. The project is estimated to generate $2,190,000 in annual sales, with costs of $815,000. The project requires an initial investment in net working capital of $300,000, and the fixed asset will have a market value of $210,000 at the end of the project. What is the project's Year 0 net cash flow? Year 1? Year 2? Year 3? The tax rate is 21 percent. If the required return is 12 percent, what is the project's NPV? Asset investment $ Estimated annual sales $ Costs $ Net working capital $ Pretax salvage value $ Tax rate Project and asset life Required return MACRS percentages Year 1 Year 2 Year 3 2,900,000 2,190,000 815,000 300,000 210,000 21% 3 12% 0.3333 0.4445 0.1481 FILE Paste Clipboard A1 20 AE HOME Calibri B IU Net income NPV INSERT 21 22 Sales 23 Costs 24 Depreciation 25 EBT 26 Taxes 27 28 29 30 31 32 Aftertax salvage value 33 Sell equipment 34 Taxes 35 Aftertax cash flow 36 37 38 39 OCF 40 41 42 43 44 READY Attempt(s) I Net cash flow Fixed asset book value in three years Capital spending Net working capital Font Sheet1 11 PAGE LAYOUT A A D H C Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to calculate the NPV. Calculating NPV - Excel DATA FORMULAS Alignment Number E REVIEW F VIEW Conditional Format as Cell Formatting Table Styles Styles G Cells Editing 14 E | Sign In J + 60%
Expert Answer:
Answer rating: 100% (QA)
To calculate the net cash flows for each year and the projects NPV we need to follow these steps Step 1 Calculate Depreciation Expense We will use the MACRS depreciation method to calculate the deprec... View the full answer
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9781265553609
13th Edition
Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan
Posted Date:
Students also viewed these finance questions
-
In the previous problem, suppose the project requires an initial investment in net working capital of $275,000 and the fixed asset will have a market value of $325,000 at the end of the project. What...
-
Parker & Stone, Inc., is looking at setting up a new manufacturing plant in South Park to produce garden tools. The company bought some land six years ago for $5.2 million in anticipation of...
-
The yields of nine batches of a chemical process were measured and a sample mean of 2.843 and a sample standard deviation of 0.150 were obtained. The experimenter presented a confidence interval of...
-
Discuss whether or not a falling object increases in speed when its acceleration of fall decreases.
-
Two firms, Small and Large, compete by price. Each can choose either a low price or a high price. The following payoff table shows the profit (in thousands of dollars) each firm would earn in each of...
-
Two factors are thought to influence the deposition rate (seconds) for a pulse laser to deposit one monolayer of material. Initially, a \(2^{2}\) design was run with two factors: spot size \(50...
-
There has been a lot of discussion regarding the relationship between Scholastic Aptitude Test (SAT) scores and test-takers family income (New York Times, August 27, 2009). It is generally believed...
-
Assume that Tamarisk Company received the balance due from Carla Vista Co. on January 2 of the following year instead of December 13. Prepare the journal entry to record the receipt of payment on...
-
Which integral correctly computes the length of the curve x Aresec (e) in the interval of x values %2/3 ey dy Vey-1 cIn 2 dy Vey-1 c. 3 ey dy Vey-1 D. n- Vey-dy
-
Question 1 (20 points) Social media data usually takes the form of scattered data structured data unstructured data trend data
-
If a stock's beta falls to 50% of its initial level, is it possible? it is said that the expected return will also decrease by . Explain the answer. Two investors evaluated Generac Holdings (GNRC)...
-
You are looking at the bond quotes on your Bloomberg terminal. You see that the 5.875% coupon bond due on 2/15/31 has a price of 134-18 and a yield to maturity of 2.79%. The Face value of the bond is...
-
Describe how you could use social media (like LinkedIn) to make an existing professional contact more personal in nature while still maintaining your privacy.
-
Each day, Presto Pasta incurs total costs of $22,000 to process raw ingredients into spaghetti. The firm can then sell the spaghetti as is for total daily revenue of $84,000. Alternatively, Presto...
-
The year is 2030 and you are part of the first Mars research team whose space flight has just landed on the surface of Mars. After exiting the shuttle and taking a few steps, you bump into one of the...
-
Suppose the market is semistrong form efficient. Can you expect to earn excess returns if you make trades based on? a. Your brokers information about record earnings for a stock? b. Rumors about a...
-
In Problem 24, suppose the firm wishes to keep its debt-equity ratio constant. What is EFN now? Problem 24 The most recent financial statements for Crosby, Inc., follow. Sales for 2021 are projected...
-
Suppose you are still committed to owning a $275,000 Ferrari (see Problem 9). If you believe your mutual fund can achieve an annual rate of return of 11.2 percent and you want to buy the car in 9...
-
Wallace Driving Schools 2020 balance sheet showed net fixed assets of $2.3 million, and the 2021 balance sheet showed net fixed assets of $3.1 million. The companys 2021 income statement showed a...
-
Suppose a negatively charged ring is placed directly above the positively charged ring in Figure 28.7. If both rings spin in the same direction, is the magnetic interaction between them attractive or...
-
Does the direction of the electric field along the axis inside an electric dipole coincide with the direction of the electric dipole moment?
-
Suppose the square current loop in Figure 28.10 is replaced by a circular loop with a diameter equal to the width of the square loop and with the same current. Does the circular loop experience a...
Study smarter with the SolutionInn App