The Best Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated here. The
corporate tax rate is 40 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year. All net working capital is recovered at the end of the project.
Year 0 Year 1 Year 2 Year 3 Year 4
Investment $ 43,000
Sales revenue $ 22,000 $ 22,500 $ 23,000 $ 20,000
Operating costs 4,600 4,700 4,800 4,000
Depreciation 10,750 10,750 10,750 10,750
Net working capital spending 490 540 590 490 ?
Compute the incremental net income of the investment for each year. (Do not round intermediate calculations.)
Year 1 Year 2 Year 3 Year 4
Net income $ $ $ $
b.
Compute the incremental cash flows of the investment for each year. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.)
Year 0 Year 1 Year 2 Year 3 Year 4
Cash flow $ $ $ $ $
c.
Suppose the appropriate discount rate is 11 percent. What is the NPV of the project? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))
NPV $
Year 0 Year 1 Year 2 Year 3 Year 4
Investment $ 43,000
Sales revenue $ 22,000 $ 22,500 $ 23,000 $ 20,000
Operating costs 4,600 4,700 4,800 4,000
Depreciation 10,750 10,750 10,750 10,750
Net working capital spending 490 540 590 490 ?
Compute the incremental net income of the investment for each year. (Do not round intermediate calculations.)
Year 1 Year 2 Year 3 Year 4
Net income $ $ $ $
b.
Compute the incremental cash flows of the investment for each year. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.)
Year 0 Year 1 Year 2 Year 3 Year 4
Cash flow $ $ $ $ $
c.
Suppose the appropriate discount rate is 11 percent. What is the NPV of the project? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))
NPV $
2 answers:
Answer:
The solution is presented in the attached excel sheets.
Explanation:
Part a
For the first part the for the calculation of increment, the income is calculated as follows
The income is calculated using following
Gross Income=Sales Revenue-Operating Cost-Depreciation
Net Income is given as Gross Income-Tax Rate *Gross Income
Now the increment is given by finding the difference between two year's income.
Part b
The incremental cash flow is calculated as indicated in the attached sheet.
Part c
The present value at 11 percent is calculated as using the formula indicated in the attached sheets.
You might be interested in