XYZ, Inc. is considering a 5-year project. The production will require net working capital investments each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
XYZ, Inc. is considering a 5-year project. The production will require net working capital investments each year equal to 15% of the projected sales. Total fixed costs are $1,350,000 per year, variable production costs are $210 per unit, and the units are priced at $345 each. The equipment needed to begin production has an intalled cost of $23,000,000. The equipment is qualified as seven-year MACRS property. The company is in the 35% marginal tax bracket and has a required rate of return on all its projects of 18%. Salvage value will be the same as the book value at the end of year 5. Please finish the project valuation and answer the following questions. All the colored cells need to be filled in. Input Area Year 1 2 3 4 6. 7 8 Projected unit sales 80,000 85,000 90,000 95,000 95,000 MACRS Rates 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% NWC/year (% of projected sales ) 15% Fixed costs $1,350,000 Variable cost per unit $210 Unit price $345 Equipment cost, year 0 $23,000,000 Tax Rate 35% Required return 18% 1. Please complete the cash flow estimation table. What are the projected cash flows for each year? (5 points) Year 1 3 4 Ending book value Depreciation Depreciation (Accum) Sales Variable costs Fixed costs Depreciation EBIT Таxes Net income NOPAT Change in NWC САРЕХ Salvage value Total cash flow 2. What is the NPV and IRR for this project? Shall the project be accepted? Why? (2 points) NPV = IRR = Type your answer here: XYZ, Inc. is considering a 5-year project. The production will require net working capital investments each year equal to 15% of the projected sales. Total fixed costs are $1,350,000 per year, variable production costs are $210 per unit, and the units are priced at $345 each. The equipment needed to begin production has an intalled cost of $23,000,000. The equipment is qualified as seven-year MACRS property. The company is in the 35% marginal tax bracket and has a required rate of return on all its projects of 18%. Salvage value will be the same as the book value at the end of year 5. Please finish the project valuation and answer the following questions. All the colored cells need to be filled in. Input Area Year 1 2 3 4 6. 7 8 Projected unit sales 80,000 85,000 90,000 95,000 95,000 MACRS Rates 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% NWC/year (% of projected sales ) 15% Fixed costs $1,350,000 Variable cost per unit $210 Unit price $345 Equipment cost, year 0 $23,000,000 Tax Rate 35% Required return 18% 1. Please complete the cash flow estimation table. What are the projected cash flows for each year? (5 points) Year 1 3 4 Ending book value Depreciation Depreciation (Accum) Sales Variable costs Fixed costs Depreciation EBIT Таxes Net income NOPAT Change in NWC САРЕХ Salvage value Total cash flow 2. What is the NPV and IRR for this project? Shall the project be accepted? Why? (2 points) NPV = IRR = Type your answer here:
Expert Answer:
Answer rating: 100% (QA)
Operating cash flow OCF each year income after tax depreciation ... View the full answer
Posted Date:
Students also viewed these finance questions
-
The following is the description of a cost: total fixed costs are $50 000 per month and the variable cost per unit is $10 when production is under 1000 units. The variable cost drops to $9 per unit...
-
An ice-cream shop wants to model the relationship between ice cream sales and temperature. They collect data on temperature (in Fahrenheit) and sales (in dollars) for twenty summer days. Let x be the...
-
Total fixed costs are $25,000 for Haag Inc. It has a contribution margin per unit of $15, and a contribution margin ratio of 25%. Compute the break-even sales in dollars.
-
Suppose n is divisible by 6. Let (,P) be the space = {1,...,n} with the uniform probability P, let A be the event consisting of all even numbers, and let B be the event of all numbers divisible by...
-
Two companies, the Lastin Company and the Firstin Company, are in the scrap metal warehousing business as arch competitors. They are about the same size, and in 20X1 coincidentally encountered...
-
Write chemical equations showing how you could prepare m-bromonitrobenzene as the principal organic product, starting with benzene and using any necessary organic or inorganic reagents. How could you...
-
Which of the following is not a means by which information improves decision making? a. increasing information overload b. reducing uncertainty c. providing feedback about the effectiveness of prior...
-
During the 2011 annual accounting period, BSP Company completed the following transactions: (a) On January 1, 2011, purchased a patent for $28,000 cash (estimated useful life, seven years). (b) On...
-
write-up on the remuneration committee of a selected public listed company in Malaysia. Your write-up should include recommendation(s) for improving the committee composition and structure of that...
-
From the tenth floor of her office building, Katherine Rally watches the swarms of New Yorkers fight their way through the streets infested with yellow cabs and the sidewalks littered with hot dog...
-
Estimate the duration of activity D using the PERT method, knowing that it has an optimistic time estimate of 3 days, a most likely estimate of 4 days, and a pessimistic estimate of 11 days. Draw a...
-
Derive the stopping rule for investments in education.
-
Some people claim that by increasing depreciation, firms may save corporate taxes. Do you agree? Why, or why not?
-
Give conditions for OWC to approximately be receivables plus inventory less payables.
-
Discuss how the wageschooling locus is determined in the labor market, and why it is upward sloping and concave.
-
Discuss why there is regression toward the mean in the correlation between the earnings of parents and children.
-
orrect Question 5 In cell E1 is the formula =A$1+$A2 If we copy the formula from E1 across to F1, the formula in cell F1 will be? -B$1+$A2 =A$1+$A2 -A$1+SA2 -B$1+$A3 0/2 pts
-
Which of the following streaming TV devices does not involve use of a remote controller? A) Google Chromecast B) Apple TV C) Amazon Fire TV D) Roku
-
From the following data, determine the total actual costs incurred for direct material, direct labor, and variable overhead. Direct material Price variance.. Quantity variance Direct labor.... Rate...
-
Marshfield Tax Company considers 8,000 direct labor hours or 400 tax returns its normal monthly capacity. Its standard variable overhead rate is \($4\) per direct labor hour. During the current...
-
Harrison Company manufactures product Q in its factory. Production of find Q requires 3 pounds of material T, costing \($7\) per pound and 2 hours of direct labor, costing \($10\) per hour. The...
Study smarter with the SolutionInn App