{ "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-09T18:27:04-04:00", "answer_date": "2024-06-09 18:27:04", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "2533773", "url": "\/study-help\/questions\/please-include-on-excel-spreadsheet-how-you-arrived-to-solution-2533773", "question_creation_date_js": "2024-06-09T18:27:04-04:00", "question_creation_date": "Jun 09, 2024 06:27 PM", "meta_title": "[Solved] Please include on Excel spreadsheet how y | SolutionInn", "meta_description": "Answer of - Please include on Excel spreadsheet how you arrived to solution. Holland Auto Parts is considering a merger with Workm | SolutionInn", "meta_keywords": "include,excel,spreadsheet,arrived,solution,holland,auto,parts,merger,workman,car,s", "question_title_h1": "Please include on Excel spreadsheet how you arrived to solution. Holland Auto Parts is considering a merger with Workman Car Parts. Workman's market-determined beta is", "question_title": "Please include on Excel spreadsheet how you arrived to solution. Holland Auto", "question_title_for_js_snippet": "Please include on Excel spreadsheet how you arrived to solution Holland Auto Parts is considering a merger with Workman Car Parts Workman's market determined beta is 0 9, and the firm currently is financed with 20 debt, at an interest rate of 8 , and its tax rate is 25 If Holland acquires Workman, it will increase the debt to 60 , at an interest rate of 9 , and the tax rate will increase to 35 The risk free rate is 6 and the market risk premium is 4 What will Workman's required rate of return on equity be after it is acquired Calculate the current required return to Workman's equity r K r RF b(RP M ) 6 (0 9)4 9 6 Calculate Workman's unlevered cost of equity r sU w d r d w s r s 0 20(8 ) 0 80(9 6 ) 9 28 Calculate Workman's levered cost of equity at the new capital structure with the new cost of debt r sL r sU (r sU r d )(D S) 9 28 (9 28 9 ) (0 6 0 4) 9 7 ", "question_description": "

Please include on Excel spreadsheet how you arrived to solution. <\/p>

<\/p>

Holland Auto Parts is considering a merger with Workman Car Parts. Workman's market-determined beta is 0.9, and the firm currently is financed with 20% debt, at an interest rate of 8%, and its tax rate is 25%. If Holland acquires Workman, it will increase the debt to 60%, at an interest rate of 9%, and the tax rate will increase to 35%. The risk-free rate is 6% and the market risk premium is 4%. What will Workman's required rate of return on equity be after it is acquired?<\/span><\/p>

<\/p>

<\/p>

Calculate the current required return to Workman's equity: r<\/span>K<\/sub> = r<\/span>RF<\/sub> + b(RP<\/span>M<\/sub>) = 6% + (0.9)4% = 9.6%. Calculate Workman's unlevered cost of equity: r<\/span>sU<\/sub> = w<\/span>d<\/sub>r<\/span>d<\/sub> + w<\/span>s<\/sub>r<\/span>s<\/sub> = 0.20(8%) + 0.80(9.6%) = 9.28%. Calculate Workman's levered cost of equity at the new capital structure with the new cost of debt: r<\/span>sL<\/sub> = r<\/span>sU<\/sub> + (r<\/span>sU<\/sub> r<\/span>d<\/sub>)(D\/S) = 9.28% + (9.28% 9%)\/(0.6\/0.4) = <\/span>9.7%<\/strong>.<\/span><\/p>", "transcribed_text": "", "related_book": { "title": "The Changing Geography Of Banking And Finance", "isbn": "1441947205, 978-1441947208", "edition": "1st Edition", "authors": "Pietro Alessandrini ,Michele Fratianni ,Alberto Zazzaro", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/2024\/03\/66050c9f889e3_94366050c9f62f22.jpg", "uri": "\/textbooks\/the-changing-geography-of-banking-and-finance-1st-edition-978-1441947208-260622", "see_more_uri": "" }, "free_related_book": { "isbn": "B00019NLK6", "uri": "\/textbooks\/thomas-and-friends-thomas-lures-1-b00019nlk6-122913", "name": "Thomas And Friends Thomas Lures 1", "edition": "" }, "question_posted": "2024-06-09 18:27:04", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/use-the-differential-equation-approach-to-find-vct-for-t-5", "description": "Use the differential equation approach to find vC(t) for t > 0 in the circuit in figure. 6 kn 3 vc); 100 12V (+1", "stars": 3 }, { "url": "\/government-data-indicate-that-the-mean-hourly-wage-for-manufacturing", "description": "Government data indicate that the mean hourly wage for manufacturing workers in the United States is $18.50 (Statistical Abstract of the United States: 2012). Suppose the distribution of...", "stars": 3 }, { "url": "\/study-help\/business-statistics-in-practice\/8-for-which-one-of-the-following-situations-would-a-1983521", "description": "=+8. For which one of the following situations would a Wilcoxon signed-rank test be appropriate?", "stars": 3 }, { "url": "\/consider-the-data-in-the-excel-file-nuclear-power-use", "description": "Consider the data in the Excel file Nuclear Power. Use simple linear regression to forecast the data. What would be the forecasts for the next 3 years?", "stars": 3 }, { "url": "\/study-help\/questions\/at-t0-you-purchase-a-4year-5-percent-regular-coupon-9884810", "description": "At t=0, you purchase a 4-year, 5 percent regular coupon bond (paid annually) that is priced to yield 6 percent per year continuously compounded. The face value of the bond is $1,000. The bond issuer...", "stars": 3 }, { "url": "\/study-help\/questions\/audiophonics-limited-manufactures-and-sells-highquality-and-durable-ear-buds-4502917", "description": "Audiophonics Limited manufactures and sells high-quality and durable ear buds for use with personal electronics that are custom moulded to each customer's ear. Cost data for the product follow:...", "stars": 3 }, { "url": "\/study-help\/questions\/while-the-operational-experience-of-basic-branch-service-members-is-5295482", "description": "While the operational experience of basic branch service members is critical to moving the work of CDIDs forward, the process expertise provided by __________ is critical. A. Joint Staff and General...", "stars": 3 }, { "url": "\/study-help\/questions\/in-independent-random-samples-of-15-men-and-15-women-5350103", "description": "In independent random samples of 15 men and 15 women, the numbers of minutes spent in front of an electronic device are given by the back-to-back stemplot below: Men Women H 12 35 8 13 4 14 15 2367...", "stars": 3 }, { "url": "\/study-help\/questions\/professional-skepticism-case-i-was-a-senior-working-on-a-5605891", "description": "Professional Skepticism Case I was a senior working on a public company audit engagement. As part of our risk assessment, we evaluated the compensation and performance management process of a...", "stars": 3 }, { "url": "\/study-help\/questions\/employee-demographics-company-a-has-40-employees-30-work-in-2162968", "description": "Employee Demographics Company A has 4 0 employees: 3 0 work in Sales, the rest in Customer Service. Company B has 3 6 employees: 1 8 work in Customer Service, the rest in Sales. Question Arrange the...", "stars": 3 }, { "url": "\/study-help\/questions\/renovation-nation-pty-ltd-company-sold-bathroom-and-kitchen-products-3569226", "description": "Renovation Nation Pty Ltd (Company) sold bathroom and kitchen products. Due to financial difficulties Tristan, an administrator, has been appointed to take control of the company. At the time of his...", "stars": 3 }, { "url": "\/study-help\/questions\/budgets-are-essential-to-good-financial-planning-can-a-budget-5069247", "description": "Budgets are essential to good financial planning. Can a budget guarantee good financial results? Why or why not", "stars": 3 }, { "url": "\/study-help\/cost-accounting-\/activitybased-costing-and-pricing-black-west-owns-and-manages-a-1554057", "description": "(Activity-based costing and pricing) Black West owns and manages a com mercial cold-storage warehouse. He stores a vast variety of perishable goods for his customers. Historically, he has charged...", "stars": 3 }, { "url": "\/study-help\/cost-accounting-\/decision-making-ethics-essay-as-the-chief-executive-officer-of-1554055", "description": "(Decision making; ethics: essay) As the chief executive officer of a large cor poration, you have decided after discussion with production and accounting personnel to implement activity-based...", "stars": 3 }, { "url": "\/study-help\/cost-accounting-\/essay-companies-that-want-to-be-more-globally-competitive-can-1554056", "description": "(Essay) Companies that want to be more globally competitive can consider the implementation of activity-based management (ABM). Such companies have often used other initiatives that involve higher...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/afn-equation-broussard-skateboards-sales-are-expected-to-increase-by-2533772", "next": "\/study-help\/questions\/a-farmer-in-georgia-has-a-100acre-farm-on-which-2533774" }, "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": "Please include on Excel spreadsheet how you arrived to solution. Holland Auto", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/please-include-on-excel-spreadsheet-how-you-arrived-to-solution-2533773" } ], "skill_details": { "skill_id": "13", "skill_name": "Finance", "parent_id": "1" } }} }