Question

Q: Construct a cashflow table and calculate NPV. Assumptions are as follow 1.   Inflation: 10% per...

Q: Construct a cashflow table and calculate NPV.
Assumptions are as follow
1.   Inflation: 10% per year.
2.   Capital Expenditure: $8 million for machinery; $5 million for market value of factory; $2.4 million for warehouse extension (we assume that it is eventually needed or that electric motor project and surplus capacity cannot be used in the interim). We assume salvage value of $3 million in real terms less tax at 35%.
3.   Working Capital: We assume inventory in year t is 9.1% of expected revenues in year (t + 1). We also assume that receivables less payables, in year t, is equal to 5% of revenues in year t.
4.   Depreciation Tax Shield: Based on 35% tax rate and 5-year ACRS class. This is a simplifying and probably inaccurate assumption; i.e., not all the investment would fall in the 5-year class. Also, the factory is currently owned by the company and may already be partially depreciated. We assume the company can use tax shields as they arise.
5.   Revenues: Sales of 2,000 motors in 2017, 4,000 motors in 2018, and 10,000 motors thereafter. The unit price is assumed to decline from $4,000 (real) to $2,850 when competition enters in 2019. The latter is the figure at which new entrants’ investment in the project would have NPV = 0.
6.   Operating Costs: We assume direct labor costs decline progressively from $2,500 per unit in 2017, to $2,250 in 2018 and to $2,000 in real terms in 2019 and after.
7.   Other Costs: We assume true incremental costs are 10% of revenue.
8.   Tax: 35% of revenue less costs.
9.   Opportunity Cost of Capital: Assumed 20%.

How to calculate the capital expenditure in 2026? Could you please show me the steps?

As shown in the answer, capital expenditure in 2016 is -15400 while capital expenditure in 2026 is 5058 but I dont know how to get this answer.

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Q: Construct a cashflow table and calculate NPV. Assumptions are as follow 1.   Inflation: 10% per...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • free cash flow; wacc, npv. please show work 1-3. Free Cash Flow; WACC; NPV (3 questions)...

    free cash flow; wacc, npv. please show work 1-3. Free Cash Flow; WACC; NPV (3 questions) 2015 2016 2017 2018 2021 Revenue EBIT + After Tax Capital Expenditure Dep. & Amortization Net Working Capital Change Free Cash Flow 142343 152235 106364 452242252214 1577 1823 1088 437 575 622 144978 3214 1657 1026 2019 2020 M&A 186152 205309 36214314 2606 2395 1066 1045 213635 5835 3123 1087 0 3382 4808 6090 77854342 1689 1539 1044 903 1178 1758 Other information Your...

  • Question 1. Suppose 1 year T-Bills currently yield 7.00% and the future inflation rate is expected...

    Question 1. Suppose 1 year T-Bills currently yield 7.00% and the future inflation rate is expected to be constant at 3.20% per year. What is the real risk of return? Suppose the real risk-free rate is 2.50% and the future rate of inflation is expected to be constant at 4.10%. What rate of return would you expect on a 5 year treasury security, assuming the pure expectations theory is valid? Question 2. For 2015, Everyday Electronics reported $22.5 million of...

  • Chap 12- Handout 1 12.2 Analysis of an Expansion Project Fxed Asset Purchase + Investment in...

    Chap 12- Handout 1 12.2 Analysis of an Expansion Project Fxed Asset Purchase + Investment in NOWC SALES COGS DEP EBIT SALES COGS DEP SALES Opportunity Cost Total Initial Outiay NOPAT-EBIT NOPAT . EBIT(1M NOPAT-EBTan NOPAT DEP OCF NOPAT + DEP OCF NOPAT + DEP OCF Cthr OCF Recoup NOwc +ATSV Total Teminal CF FCF Timeline Terminal Year FCFs Total Terminal CF FCFo Total initial 0. You are to evaluate an expansion project for your firm. Last year, the firm...

  • free cash flow 1-3. Free Cash Flow; WACC; NPV (3 questions) 2016 2015 2017 2018 2019...

    free cash flow 1-3. Free Cash Flow; WACC; NPV (3 questions) 2016 2015 2017 2018 2019 2020 2021 M&A 1 2 Revenue 142343 152235 106364 144978 186152 205309 213635 EBIT+After Tax 4225 4522 2214 3214 3621 4314 5835 Capital Expenditure Dep. & Amortization Net Working Capital Change 1823 1088 1657 1577 2606 2395 3123 575 437 622 1026 1066 1045 1087 -4808 6090 1539 903 1689 1758 Free Cash Flow -4342 3382 7785 1044 1178 Other information Your Investment in...

  • 7. A potential project requires an initial investment of $100,000 and is expected to produce revenues...

    7. A potential project requires an initial investment of $100,000 and is expected to produce revenues less costs (R - C) of $26,000 per year for 5 years. Company A has substantial accumulated tax losses and is unlikely to pay taxes in the foreseeable future (Company A will also not benefit fronm depreciation deductions). Company B pays corporate taxes at a rate of 35% and can depreciate the investment for tax purposes using the 3-year MACRS tax depreciation schedule. Assume...

  • please help and show me how (all)each number was calculated in the TABLE according to problem...

    please help and show me how (all)each number was calculated in the TABLE according to problem given. (ex, how pre-tax profit, profit after tax, operating cashflow is being calculated?) if it too much, show as many as you can. thank you so much in advance From 1986 to the end of 2017, U.S. companies used a slight variation of the double-declining balance method, called Page 149 the modified accelerated cost recovery system (MACRS).8 But the 2017 Tax Cuts and Jobs...

  • Please first analyze cash flows for Project L. Then calculate NPV and IRR, and make your...

    Please first analyze cash flows for Project L. Then calculate NPV and IRR, and make your capital budgeting decision. To study the health-food market, Allied has done a market research in 2019. This market research costed Allied $10k. The research confirmed Allied's previous belief that the health-food industry has a huge potential and will be a highly profitable industry. Therefore, Allied is considering a new expansion project. Project L, which is a new health-food product that Allied is considering introducing...

  • Novo Nordisk A/S is a health care company engaging in the discovery, development, and manufacture of...

    Novo Nordisk A/S is a health care company engaging in the discovery, development, and manufacture of pharmaceutical products. Its specialty is diabetes care and its headquarters are in Bagsvaerd, Denmark. The company sells its products all over the world, including in the United States, Japan, China, Russia, India, and Europe. As a new member of the capital budgeting division of Novo Nordisk A/S, you have been asked to determine the net cash flows and NPV of a proposed new diabetes...

  • Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to...

    Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas. Over lunch, you and Mary meet to discuss next steps with the expansion project. “Do we have everything we need on sales and costs?” you ask. ”It must be time to compute the net present value (NPV) and internal rate of return (IRR) of the Apix expansion project.” “We have the data from James and Luke regarding projected...

  • PLEASE ANSWER ALL QUESTIONS C-D (Related to Checkpoint 121) Calculating project cash flows and NPV) You...

    PLEASE ANSWER ALL QUESTIONS C-D (Related to Checkpoint 121) Calculating project cash flows and NPV) You are considering expanding your product line that currently consists of skateboards to include gas powered skateboards, and you feel you can sell 8.000 of these per year for 10 years after which time this project is expected to shut down with solar powered skateboards taking over). The gas skateboards would sell for $110 each with variable costs of $35 for each one produced, and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT