Question

Problem 8-2 Calculating Project NPV The Freeman Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated below. Thoe corporate tax rate is 38 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are pald in cash, and al cash flows occur at the end of the year. All net working capital is recovered at the end of the projoct Year 0 $ 39,000 Year 1 Year 2 Year 3 Year 4 Investment Sales revenue Operating costs Depreciation Net working capital spending $20,000 $20,500 $21,000 $18,000 4,200 4,300 4,400 3,600 9,750 9,750 9,750 9,750 450 500 550 450 a. Compute the incremental net income of the investment for each yoar. (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. A negative answer 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 12 percent. What is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please refer below spreadsheet for calculations and answer.

fSUM(C19:G19) In $ YEAR Sales Operationg cost Depreciation EBT Tax (38% Net Income Cash flow from Operations NWC spending Investment Net cash flow 20,000.00 20,500.00 21,000.0018,000.00 3,600.00 9,750.00 4,650.00 1,767.00 2,883.00 13,501.00 13,749.0013,997.0012,633.00 450.001,950.00 4 4,200.00 9,750.00 6,050.00 2,299.00 3,751.00 4,300.00 9,750.00 6,450.00 2,451.00 3,999.00 4,400.00 9,750.00 6,850.00 2,603.00 4,247.00 -450.00 39,000 39,450.00 500.00 550.00 13,547.0014,583.00 12 13 14 a 13,001.00 13,199.00 Incremental Net Income 3,751.00 248.00 248.00 1,364.00 16 b 17 18 C 19 20 21 Incremental Cash Flow 13,001.00 198.00 348.00 1,036.00 PVF( 12% Present Value of Net cash flows NPV of Investment 1.00000 0.89286 0.79719 10,522.2 1,590.4 0.71178 0.63552 39,450.0 11,608.0 9,642.5 9,267.8

Formula reference -

xfSUM(C19:G19) YEAR Sales 4200 9750 -D3-D4-DS D6 0.38 -D6-D7 Operationg cost 4300 4400 9750 -F3-F4-F5 -F6 0.38 -F6-F7 -F8+F5 3600 9750 -G3-G4-GS G6 0.38 reciation 9750 EBT Tax (38%) Net Income Cash flow from Operations NWC spending Investment Net cash flow E3-E4-ES -E6 0.38 -E6-E7 -G8+G5 10 550 -SUM(C10+D10+E10+F10) 39000 12 13 14 a 15 16 b 17 18 с 19 20 21 SUM(C9:C11 -SUM(D9:D11 -SUM(E9:E11) -SUM(F9:F11) -SUM(G9:G11) Incremental Net Income -F8-E8 G8-F8 Incremental Cash Floww -D12 -E12-D12 -F12-E12 -G12-F12 PVF( 12%) Present Value of Net cash flows l-C12 C18 NPV of Investment -1/(1+0.12)F2 -F12*F18 1/(1+0.12)AC2 1/(1+0.12) D2 D12 D18 1/(1+0.12)AE2 E12 E18 1/(1+0.12) G2 G12 G18 SUM(C19:G19)

Add a comment
Know the answer?
Add Answer to:
Problem 8-2 Calculating Project NPV The Freeman Manufacturing Company is considering a new investment. Financial projections...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
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