Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I got the answers for 1 and 2, but I am confused on what I am supposed to do for questions 3 to 6. I

I got the answers for 1 and 2, but I am confused on what I am supposed to do for questions 3 to 6. I know that the NPV you need the discount rate, but I do not sure what the discount rate would be.

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

Details of McCormick Plant Proposal As you know from Project 4, McCormick & Company is considering a project that requires an initial investment of $350 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $14 million. You have been asked to refine your work to include the correct tax impact of depreciation, and the cash flow impact of working capital on the capital budget evaluation. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The correct depreciation table is included at the right. The company will need to finance some of the cash to fund $17 million in receivables and $14 million in Inventory starting at year zero. The company expects vendors to give free credit on purchases of $15 million (accounts Payable). Add the net cash outflow for working capital to the cash outflow for the plant, equipment and land in year zero. The $17 million for receivables and the $14 million for Inventory are cash outflows. The $15 million for receivables is a cash inflow. Assume that this net working capital is recovered as a cash inflow in year 21. The company still estimates revenues and expenses the same as it did in Project 4. See Table 2 at the right. The company now estimates that it can sell the land in year 21 for $40 million. It will also recover the cash spent on working capital in year 21. $350 Year WNA Table 1 MACRS Depreciation 7 Year class 14.29% 24.49% 17.49% 4 12.49% 8.93% 61 8.92% 8.93% 4.46% Depreciation $50.02 $85.72 $61.22 $43.72 $31.26 $31.22 $31.26 $15.61 00 A E Year Table 2 Cash from Cash outflow, Revenue in expenses in Depreciation in Taxable Income Tax in Millions After tax Cash Flow In $Millions $Millions $Millions in $ Millions 27.5% rate SMillions $1,800 $1,728 $50.02 $21.99 $6.05 $65.95 $1,900 $1,824 $85.72 $9.72 $2.67 $78.67 $2,000 $1,920 $61.22 $18.79 $5.17 $74.83 $2,100 $2,016 $43.72 $40.29 $11.08 $72.92 $2,200 $2,112 $31.26 $56.75 $15.60 $72.40 $2,300 $2,208 $31.22 $60.78 $16.71 $75.29 $2,400 $2,304 $31.26 $64.75 $17.80 $78.201 $2,500 $2,400 $15.61 $84.39 $23.21 $76.79 $2,600 $2,496 $0.00 $104.00 $28.60 $75.40 $2,700 $2,592 $0.00 $108.00 $29.70 $78.30 $2,600 $2,496 $0.00 $104.00 $28.60 $75.40 $2,500 $2,400 $0.00 $100.00 $27.50 $72.50 13 $2,400 $2,304 $0.00 $96.00 $26.40 $69.60 $2,200 $2,112 $0.00 $88.00 $24.20 $63.80 $2,000 $1,920 $0.00 $80.00 $22.00 $58.00 16 $1,800 $1,7281 $0.00 $72.00 $19.80 $52.20 17 $1,500 $1,440 $0.00 $60.00 $16.50 $43.50 18 $1,200 $1,152 $0.00 $48.00 $13.20 $34.80 191 $800 $768 $0.00 $32.00 $8.80 $23.201 $400 $384 $0.00 $16.00 $4.40 $11.601 16000 VALAWN 14 Year 60 Malu Table 3 D Tax in Millions Cash from Cash outflow, 27.5% rate in Revenue in expenses in Depreciation in Taxable income years 1, 2, 3 and After tax Cash Flow In $Millions $Millions $Millions in $ Millions 50% there after Millions $1,800 $1,762.56 $50.02 $12.57 $3.46 $40.90 $1,860.48 $85.72 $46.20 $12.70 $52.22 $2,000 $1,958.40 $61.22 $19.62 $5.39 $46.99 $2,100 $2,056.32 $43.72 $0.04 $0.02 $43.70 $2,200 $2,154.24 $31.26 $14.50 $7.25 $38.51 $2,300 $2,252.16 $31.22 $16.62 $8.31 $39.53 $2,400 $2,350.08 $31.26 $18.67 $9.33 $40.59 $2,500 $2,448.00 $15.61 $36.39 $18.20 $33.81 $2,600 $2,545.92 $0.00 $54.08 $27.04 $27.04 $2,700 $2,643.84 $0.00 $56.16 $28.08 $28.08 $2,600 $2,545.92 $0.00 $54.08 $27.04 $27.04 $2,500 $2,448.00 $0.00 $52.00 $26.00 $26.00 $2,400 $2,350.08 $0.00 $49.92 $24.96 $24.96 $2,200 $2,154.24 $0.00 $45.76 $22.88 $22.88 $2,000 $1,958.40 $0.00 $41.60 $20.80 $20.80 $1,800 $1,762.56 $0.00 $37.44 $18.72 $18.72 $1,500 $1,468.80 $0.00 $31.20 $15.60 $15.60 $1,200 $1,175.04 $0.00 $24.96 $12.48 $12.48 $800 $783.36 $0.00 $16.64 $8.32 $8.32 $400 $391.68 $0.00 $8.32 $4.16 $4.16

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions