{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-05T17:05:58-04:00", "answer_date": "2024-06-05 17:05:58", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "2304888", "url": "\/study-help\/questions\/details-of-mccormick-plant-proposal-as-you-know-from-project-2304888", "question_creation_date_js": "2024-06-05T17:05:58-04:00", "question_creation_date": "Jun 05, 2024 05:05 PM", "meta_title": "[Solved] Details of McCormick Plant Proposal As yo | SolutionInn", "meta_description": "Answer of - Details of McCormick Plant Proposal As you know from Project 4, McCormick & Company is considering building a new fact | SolutionInn", "meta_keywords": "details,mccormick,plant,proposal,project,4,company,building,new,factory,largo,maryland", "question_title_h1": "Details of McCormick Plant Proposal As you know from Project 4, McCormick & Company is considering building a new factory in Largo, Maryland. McCormick &", "question_title": "Details of McCormick Plant Proposal As you know from Project 4, McCormick", "question_title_for_js_snippet": "Details of McCormick Plant Proposal As you know from Project 4, McCormick Company is considering building a new factory in Largo, Maryland McCormick Company decided to offer $4,424,000 to obtain the land for this project The new factory will require an initial investment of $350 million to build the new plant and purchase equipment You have been asked to continue your work from project 4 with a full analysis of the proposed factory, including the start up costs, the projected net cash flows from operations, the tax impact of depreciation, and the cash flow impacts of changes in working capital The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven year class asset The correct depreciation table is included below The company will need to finance some of the cash to fund $17 million in accounts receivable and $14 million in Inventory starting at year zero The company expects vendors to give free credit on purchases of $15 million (accounts payable) The CFO wants you to consider the net cash outflows for working capital as well as the cash outflows for the plant, equipment, and land in year zero Note The $17 million for accounts receivable and the $14 million for Inventory are cash outflows The $15 million for accounts payable is a cash inflow The CFO has indicated that this net working capital will be recovered as a cash inflow in year 21 She also estimates that the company will be able to sell the factory, equipment, and land in year 21 for $40 million The company estimates that the cash flows from operations will be as shown in Table 2 Note Only the cash flows related to operations (years 1 20) will generate accounting profits and thus taxable income (or losses) Use the WACC that you recommended in question 5 of the Cost of Capital tab for the discount rate ( WACC IS 7 61 ) Questions 1 What will be the depreciation for tax purposes each year Complete Table 1 below to answer this question Note the total deprecation for tax purposes will be $350 million 2 Construct an after tax cash flow timeline for the proposed factory in Table 2 below Note The CFO estimates that operations for the company will be profitable on an on going basis As a result, any accounting loss on this specific project will provide a tax benefit for the company overall in the year of the loss 3 Calculate the NPV and IRR using the data from Table 2 Should the project be accepted The following questions will be used to assist in evaluating the proposed project's risk 4 The CFO is particularly concerned about the potential impact of future tax increases and that the expenses may have been systematically understated In order to undertake an objective evaluation of the project's risk, she asks you to make a second analysis with a less favorable set of assumptions She asks, What would happen to the NPV and IRR calculations if the cash outflow for expenses comes in 2 higher than estimated for the entire life of the project and if the tax rate increases to 50 (combined Federal and Maryland state rates) starting in year 4 Construct an after tax cash flow timeline for the proposed factory with these new assumptions in Table 3 below 5 Calculate the NPV and IRR using the data from Table 3 6 Considering all of your work in questions 1 through 5, should the project be accepted Discuss the risk and the potential reward of this project for McCormick I 'm posting same question 4th time , recent 3 answers were different from one another so please provide the answers with formula PART 1 2 4 are already solved , Just looking for help in PART 3,5, 6 Please only provide the answers in given tables (using excel formulas, and attach the excel formula sheet or provide answers on google sheets so that I can understand the formulas but answer must be in provided spaces ) Thanks", "question_description": "

Details of McCormick Plant Proposal<\/u><\/strong><\/p>

As you know from Project 4, McCormick & Company is considering building a new factory in Largo, Maryland. McCormick & Company decided to offer $4,424,000 to obtain the land for this project.The new factory will require an initial investment of $350 million to build the new plant and purchase equipment. <\/p>

You have been asked to continue your work from project 4 with a full analysis of the proposed factory, including the start-up costs, the projected net cash flows from operations, the tax impact of depreciation, and the cash flow impacts of changes in working capital.<\/p>

The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The correct depreciation table is included below.<\/p>

The company will need to finance some of the cash to fund $17 million in accounts receivable and $14 million in Inventory starting at year zero.The company expects vendors to give free credit on purchases of $15 million (accounts payable).The CFO wants you to consider the net cash outflows for working capital as well as the cash outflows for the plant, equipment, and land in year zero.<\/p>

Note:The $17 million for accounts receivable and the $14 million for Inventory are cash outflows.The $15 million for accounts payable is a cash inflow.<\/p>

The CFO has indicated that this net working capital will be recovered as a cash inflow in year 21.She also estimates that the company will be able to sell the factory, equipment, and land in year 21 for $40 million.<\/p>

The company estimates that the cash flows from operations will be as shown in Table 2.Note:Only the cash flows related to operations (years 1-20) will generate accounting profits and thus taxable income (or losses).<\/p>

Use the WACC that you recommended in question 5 of the Cost of Capital tab for the discount rate.( WACC IS 7.61%)<\/strong><\/p>

<\/p>

Questions:<\/u><\/strong><\/p>

1. What will be the depreciation for tax purposes each year? <\/strong>Complete Table 1 below to answer this question. Note: the total deprecation for tax purposes will be $350 million.<\/p>

2. Construct an after-tax cash flow timeline for the proposed factory <\/strong>in Table 2 below.Note: The CFO estimates that operations for the company will be profitable on an on-going basis.As a result, any accounting loss on this specific project will provide a tax benefit for the company overall in the year of the loss.<\/p>

<\/p>

3. Calculate the NPV and IRR <\/strong>using the data from Table 2<\/u><\/strong>. Should the project be accepted? <\/strong><\/p>

The following questions will be used to assist in evaluating the proposed project's risk.<\/p>

4. The CFO is particularly concerned about the potential impact of future tax increases and that the expenses may have been systematically understated.In order to undertake an objective evaluation of the project's risk, she asks you to make a second analysis with a less favorable set of assumptions.She asks, \"What would happen to the NPV and IRR calculations if the cash outflow for expenses comes in 2% higher than estimated for the entire life of the project and if the tax rate increases to 50% (combined Federal and Maryland state rates) starting in year 4?\"Construct an after-tax cash flow timeline for the proposed factory <\/strong>with these new assumptions in Table 3 below.<\/p>

5. Calculate the NPV and IRR <\/strong>using the data from Table 3. <\/u><\/strong><\/p>

6. Considering all of your work in questions 1 through 5, should the project be accepted?Discuss the risk and the potential reward of this project for McCormick.<\/strong><\/p>

I 'm posting same question 4th time , recent 3 answers were different from one another so please provide the answers with formula .<\/strong><\/p>

<\/p>

PART-1 -2-4 are already solved , Just looking for help in PART 3,5,& 6 . Please only provide the answers in given tables (using excel formulas, and attach the excel formula sheet or provide answers on google sheets so that I can understand the formulas but answer must be in provided spaces ).Thanks <\/u><\/strong><\/p>

<\/p>

<\/p>

<\/p>

", "transcribed_text": "", "related_book": { "title": "Entrepreneurship", "isbn": "1119563097, 9781119563099", "edition": "5th Edition", "authors": "Andrew Zacharakis, William D Bygrave", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/2021\/11\/6192073f58970_0626192073ecba87.jpg", "uri": "\/textbooks\/entrepreneurship-5th-edition-9781119563099", "see_more_uri": "" }, "free_related_book": { "isbn": "079238248X", "uri": "\/textbooks\/university-research-and-regional-innovation-a-spatial-econometric-analysis-of-academic-technology-transfers-1998th-edition-978-0792382485-285539", "name": "University Research And Regional Innovation A Spatial Econometric Analysis Of Academic Technology Transfers", "edition": "1998th Edition" }, "question_posted": "2024-06-05 17:05:58", "see_more_questions_link": "\/study-help\/questions\/business-banking-2021-September-12", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/rituals-can-provide-us-with-a-sense-of-order-and", "description": "Rituals can provide us with a sense of order and security. In a study of the drinking rituals of college students, the researchers found that drinking imposed order in students daily livesfrom the...", "stars": 3 }, { "url": "\/study-help\/financial-accounting-6th-edition\/we-compared-live-nation-entertainment-and-amc-networks-at-the", "description": "We compared Live Nation Entertainment and AMC Networks at the end of this chapter. What reasons were given for the differences of amounts held in their Cash accounts?", "stars": 3 }, { "url": "\/study-help\/psychology-2e\/in-what-ways-did-john-stuart-mill-contribute-to-the-1985116", "description": "In what ways did John Stuart Mill contribute to the development of applied psychology?", "stars": 3 }, { "url": "\/summer-tyme-inc-is-considering-a-new-threeyear-expansion-project", "description": "Summer Tyme, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $3.9 million. The fixed asset will be depreciated straight-line to zero over...", "stars": 3 }, { "url": "\/study-help\/questions\/this-is-literally-all-the-information-that-is-provided-indigo-9849658", "description": "This is literally all the information that is provided. Indigo Leasing Company agrees to lease equipment to Sweet Corporation on January 1, 2020. The following information relates to the lease...", "stars": 3 }, { "url": "\/study-help\/questions\/1-define-what-it-is-to-have-commission-earnings-2-455300", "description": "1) Define what it is to have commission earnings. 2) Discuss the implications of working strictly on a commission basis. 3) Would you rather work on a straight commission basis or a salary plus...", "stars": 3 }, { "url": "\/study-help\/questions\/not-yet-answered-marked-out-of-100-flag-question-question-4282353", "description": "Not yet answered Marked out of 1.00 Flag question Question text A chewing gum manufacturer would use: Select one: a.job costing b.process costing Question 2 Not yet answered Marked out of 1.00 Flag...", "stars": 3 }, { "url": "\/study-help\/questions\/product-case-study-after-an-incident-in-an-mlb-locker-1003024", "description": "PRODUCT Case Study After an incident in an MLB locker room, one player accused a teammate of attacking him and then left the team. The team immediately suspended the accused player. Both players have...", "stars": 3 }, { "url": "\/study-help\/questions\/why-is-it-a-good-idea-to-follow-up-your-1310863", "description": "Why is it a good idea to follow up your hypothesis test with a measure of effect size?", "stars": 3 }, { "url": "\/study-help\/questions\/consider-this-game-you-roll-a-fair-die-and-1002455", "description": "Consider this game - you roll a fair die, and if it falls 1 through 5, you win that many dollars (i.e. the number you rolled), but if it is six, you lose 14 dollars. Would you play the game? More...", "stars": 3 }, { "url": "\/study-help\/questions\/martin-ho-owns-the-following-farm-properties-land-the-acb-1003272", "description": "Martin Ho owns the following farm properties: Land The ACB is $435,000 and the FMV $584,000. Barn The barn has a UCC balance of $140,000, a capital cost of $165,000, and a FMV of $175,000. The...", "stars": 3 }, { "url": "\/study-help\/questions\/the-johnstown-axle-company-is-working-on-creating-its-finished-1311437", "description": "The Johnstown Axle Company is working on creating its Finished Goods Inventory Budget. They anticipate the following: Manufacturing Overhead and Direct Labor are allocated per hour and Direct...", "stars": 3 }, { "url": "\/study-help\/questions\/with-its-current-leverage-impi-corporation-will-have-net-income-7087452", "description": "With its current leverage, Impi Corporation will have net income next year of $4.5 million. If Impi's corporate tax rate is 35%, and it pays 8% interest on its debt, how much debt can Impi issue this...", "stars": 3 }, { "url": "\/study-help\/cost-accounting\/the-use-of-the-graphic-method-as-a-means-for-1554568", "description": "The use of the graphic method as a means for solving linear programming problems: 585 a Can be used when there are more than two restrictions (constraints) b Is limited to situations where there are...", "stars": 3 }, { "url": "\/study-help\/cost-accounting\/the-economic-order-quantity-formula-can-be-used-to-determine-1554566", "description": "The economic order quantity formula can be used to determine the optimum size of a: 585 Production run Purchase order a Yes No b Yes Yes C No Yes d No No", "stars": 3 }, { "url": "\/study-help\/cost-accounting\/siegal-company-has-correctly-computed-its-economic-order-quantity-as-1554567", "description": "Siegal Company has correctly computed its economic order quantity as 500 units; however, management feels it would rather order in quantities of 600 units. How should Siegals total annual...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/2-the-board-of-directors-of-xyz-manufacturing-co-are-2304887", "next": "\/study-help\/questions\/-2304889" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Finance", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-finance" }, { "name": "Details of McCormick Plant Proposal As you know from Project 4, McCormick", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/details-of-mccormick-plant-proposal-as-you-know-from-project-2304888" } ], "skill_details": { "skill_id": "13", "skill_name": "Finance", "parent_id": "1" } } "1" } }