Consider a project to supply Detroit with 20,000 tons of machine screws annually
ID: 2644838 • Letter: C
Question
Consider a project to supply Detroit with 20,000 tons of machine screws annually for automobile production. You will need an initial $3,400,000 investment in threading equipment to get the project started; the project will last for four years. The accounting department estimates that annual fixed costs will be $800,000 and that variable costs should be $180 per ton; accounting will depreciate the initial fixed asset investment straight-line to zero over the four-year project life. It also estimates a salvage value of $620,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $300 per ton. The engineering department estimates you will need an initial net working capital investment of $340,000. You require a 11 percent return and face a marginal tax rate of 38 percent on this project.
What is the estimated OCF for this project?
What is the estimated NPV for this project? (Round your answer to 2 decimal places. (e.g., 32.16))
Suppose you believe that the accounting department
a-1What is the estimated OCF for this project?
Explanation / Answer
Normal Best Case Worst Case Initial cost 3400000 2890000 3910000 Working Capital 340000 339150 357000 Salvage Value 620000 713000 527000 Salvage Value After Tax 384400 442060 326740 Price 300 330 297 Year Capital & Working Capital Revenue (20,000 tons * $300) Variable Costs (20,000 tons * $180) Fixed Costs Depreciation (3400000/4) Pre-tax Income Tax @ 38% Net Income (Pre-tax Income - Tax) Operating Cashflow (Net Income + Depreciation) 0 (3,740,000) - - - - - - - (3,740,000) 1 - 6,000,000 (3,600,000) (800,000) (850,000) 750,000 (285,000) 465,000 1,315,000 2 - 6,000,000 (3,600,000) (800,000) (850,000) 750,000 (285,000) 465,000 1,315,000 3 - 6,000,000 (3,600,000) (800,000) (850,000) 750,000 (285,000) 465,000 1,315,000 4 724,400 6,000,000 (3,600,000) (800,000) (850,000) 750,000 (285,000) 465,000 2,039,400 Note 1: Working Capital requirement is considered outflow in year 0 and inflow in year 4 Note 2: Cash inflow year 4 for capital and working capital = Working capital inflow + Salvage value (net off tax) = 340000 + 620000*62% = $724,400 Best Case Year Capital & Working Capital Revenue (20,000 tons * $330) Variable Costs (20,000 tons * $180) Fixed Costs Depreciation (3400000/4) Pre-tax Income Tax @ 38% Net Income (Pre-tax Income - Tax) Operating Cashflow (Net Income + Depreciation) 0 (3,229,150) - - - - - - - (3,229,150) 1 - 6,600,000 (3,600,000) (800,000) (850,000) 1,350,000 (513,000) 837,000 1,687,000 2 - 6,600,000 (3,600,000) (800,000) (850,000) 1,350,000 (513,000) 837,000 1,687,000 3 - 6,600,000 (3,600,000) (800,000) (850,000) 1,350,000 (513,000) 837,000 1,687,000 4 781,210 6,600,000 (3,600,000) (800,000) (850,000) 1,350,000 (513,000) 837,000 2,468,210 Note 1: Cash inflow year 4 for capital and working capital = Working capital inflow + Salvage value (net off tax) = 339150 + 713000*62% = $781,210 Worst Case Year Capital & Working Capital Revenue (20,000 tons * $297) Variable Costs (20,000 tons * $180) Fixed Costs Depreciation (3400000/4) Pre-tax Income Tax @ 38% Net Income (Pre-tax Income - Tax) Operating Cashflow (Net Income + Depreciation) 0 (4,267,000) - - - - - - - (4,267,000) 1 - 5,940,000 (3,600,000) (800,000) (850,000) 690,000 (262,200) 427,800 1,277,800 2 - 5,940,000 (3,600,000) (800,000) (850,000) 690,000 (262,200) 427,800 1,277,800 3 - 5,940,000 (3,600,000) (800,000) (850,000) 690,000 (262,200) 427,800 1,277,800 4 683,740 5,940,000 (3,600,000) (800,000) (850,000) 690,000 (262,200) 427,800 1,961,540 Note 1: Cash inflow year 4 for capital and working capital = Working capital inflow + Salvage value (net off tax) = 357,000 + 527,000*62% = $683,740 Year Normal OCF Best Cash OCF Worst Cash OCF PV factor @ 11% Normal PV Best Cash PV Worst Cash PV 0 (3,740,000) (3,229,150) (4,267,000) 1 (3,740,000.000) (3,229,150.000) (4,267,000.000) 1 1,315,000 1,687,000 1,277,800 0.900900901 1,184,684.685 1,519,819.820 1,151,171.171 2 1,315,000 1,687,000 1,277,800 0.811622433 1,067,283.500 1,369,207.045 1,037,091.145 3 1,315,000 1,687,000 1,277,800 0.731191381 961,516.666 1,233,519.860 934,316.347 4 2,039,400 2,468,210 1,961,540 0.658730974 1,343,415.949 1,625,886.378 1,292,127.155 816,900.799 2,519,283.103 147,705.818
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.