Esfandairi 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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/664933b81deda_399664933b756fd6.jpg)
Transcribed Image Text:
Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $1.645 million in annual sales, with costs of $610,000. The tax rate is 21 percent and the required return is 12 percent. Suppose the project requires an initial investment in net working capital of $250,000, and the fixed asset will have a market value of $180,000 at the end of the project. What is the project's Year O net cash flow? Year 1? Year 2? Year 3? What is the NPV? Input area: Asset investment $2,180,000 Estimated annual sales $1,645,000 Costs $610,000 Tax rate 21% Required return 12% Initial investment in NWC $250,000 Fixed asset value at end $180,000 MACRS percentages Year 1 Year 2 Year 3 0.3333 0.4445 0.1481 (Use cells A6 to B16 from the given information to complete this question. You must use the built-in Excel function to answer this question. Taxes on the salvage value should be negative for a tax liability and positive for a tax Output area: Sales Costs Depreciation BEBT 9 Taxes O Net income 1 Fixed asset book value 2 in three years 3 Aftertax salvage value 4 Sell equipment 5 Taxes 6 Aftertax salvage value -7 Capital spending $8 Net working capital 39 OCF 0 Total cash flow 1 NPV 2 Year O Year 1 Year 2 Year 3 Esfandairi Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $1.645 million in annual sales, with costs of $610,000. The tax rate is 21 percent and the required return is 12 percent. Suppose the project requires an initial investment in net working capital of $250,000, and the fixed asset will have a market value of $180,000 at the end of the project. What is the project's Year O net cash flow? Year 1? Year 2? Year 3? What is the NPV? Input area: Asset investment $2,180,000 Estimated annual sales $1,645,000 Costs $610,000 Tax rate 21% Required return 12% Initial investment in NWC $250,000 Fixed asset value at end $180,000 MACRS percentages Year 1 Year 2 Year 3 0.3333 0.4445 0.1481 (Use cells A6 to B16 from the given information to complete this question. You must use the built-in Excel function to answer this question. Taxes on the salvage value should be negative for a tax liability and positive for a tax Output area: Sales Costs Depreciation BEBT 9 Taxes O Net income 1 Fixed asset book value 2 in three years 3 Aftertax salvage value 4 Sell equipment 5 Taxes 6 Aftertax salvage value -7 Capital spending $8 Net working capital 39 OCF 0 Total cash flow 1 NPV 2 Year O Year 1 Year 2 Year 3
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
State Newtons second law of motion. What are the limitations on the use of Newtons second law? Explain.
-
Rondelli Company entered into an agreement to lease 12 computers from Estes Electronics Inc. The present value of the lease payments is $186,300. Assuming that this is a capital lease, what entry...
-
The cranks of a two-cylinder uncoupled inside cylinder locomotive are at right angles and are 300 mm long. The distance between the centre lines of the cylinders is 650 mm. The wheel centre lines are...
-
discuss the fundamental attribution error and its impact on perceptions;
-
Charlotte Concrete Inc. has two production departments. Blending had 1,000 units in process at the beginning of the period, two-fifths complete. During the period 7,800 units were received from...
-
Solve both good hand writing 9. Eliminate the parameter and write the corresponding rectangular equation, then graph the equation. * =-2+ 3 rose y =-5+3 sin 10. Find the the arc length of the curve...
-
Today is September 16, Year 2. You, CPA, work for Garcia & Garcia LLP, a medium-sized firm located in Montreal. Jules Garcia calls you into his office. "CPA, I have a very special engagement for you....
-
Every group for this assignment is required to select a COMPANY listed on the ASX but does not include a - Bank - Another type of Financial Services Company, OR a - Trust You are required to write a...
-
b) From the below calculation, what is the price of a 1.5-yr T-note, face value $100 paying a coupon rate of 10% p.a? c) What is the forward interest rate for a 1-yr loan starting 6 months from now ?...
-
How is this done in excel and also on a financial calculator? Assume the market value of Exxon Mobil's equity, preferred stock, and debt are $10 million, $6 million, and $14 million, respectively....
-
Q1)In the following, compute the Net Present Value (NPVs) of the three projects for each of the possible cash flows. Particulars Project Education (Rs. 000s) Project Oil & Gas (Rs 000 s) Project...
-
BigCo estimates the following production in cases for the next 4 months. Cases Jan5,000 Feb6,000 Mar 7,000 Apr 8,000 BigCo uses 20 lbs of direct material per case at a cost of $1.50 per pound.A...
-
what ways do distributed leadership structures and networked leadership models redefine traditional notions of hierarchical authority and individual agency, and how can entities leverage distributed...
-
Calculate the standardized test statistic. The standardized test statistic is ? (Round to two decimal places as needed.)
-
A manufacturer can sell product 1 at a profit of $20 per unit and product 2 at a profit of $40 per unit. Three units of raw material are needed to manufacture one unit of product 1, and six units of...
-
Describe the constraints on providing useful information. LO9
-
Discuss the three principles that are used to measure and record business transactions. LO10
-
Identify the four assumptions that underlie accounting. LO9
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App