Hello,
I need a professional accounting tutor to solve the following case 5 questions. Kindly clearly use the formula and show each and every working in excel. Plus also explain the methodology and qualitative answer in Ms word for all five questions.
NiseFood Corporation is analyzing the possibility to acquire KradFood Corp. Kradfood earnings have been under pressure in recent years, due to the change in consumer preferences. Consumers are now more willing to pay an extra price for healthier food, and are reducing the consumption of fast food. Nisefood Corp is exposed to the growing segment of the food industry, while Kradfood is focused on un-healthy food. Nisefood expects to improve Kradfood distribution channel, using its existing distribution network, restructuring production facilities from un-healthy food to healthy food and to reduce operating costs in the process. Nisefood will give Kradfood some machinery that is not in used, but is on sale for 1m eur, which is its fair market price. It will be fully depreciated during the following 4 years (2023-2026) and then sold it’s salvage value of €100,000. There is enough room to grow the acquired company (Kradfoods) sales by 11% per year during the next 5 years, and then reduce the growth rate to 5.5% per year until year 10. Growth at perpetuity is estimated to be 5%. However, the acquisition will place several outlets for both brands that are close by in intense competition (derived from Kradfood better competitive capabilities after the acquisition), and Nisefood sales will be reduced by 1% from its actual level (2022) in years 2023, 2024 and 2025. The impact is null from that date onwards. Managers at Nisefood forecast that the EBITDA Margin will also improve by 2.75% of sales from the level today (12.31%) thanks to the synergies in the distribution channel and the manufacturing operating efficiencies. The acquirer expects Kradfoods NWK to be reduced by 0.25% of sales (per year) from 2022 level in years 2023 to 2024 and then to grow at 0.05% (per year) as percentage of sales from 2025 onwards (2025 included). The depreciation expense will be stable as percentage of sales during the forecast period, at a ratio similar to 2022. Capital Expenditure will increase by 0.35% per year as a percentage of sales during the first three years (2023 to 2026), but will come back to the 2021 level as a percentage of sales from 2027 onwards. The tax rate is expected to be 21% Please find the P&L and Balance Sheet of Kradfoods Corp in the Excel attached, save time and use that information for your calculations. Nisefoods Corp will change the leverage of the acquired company. The new capital structure will be 40% debt to total debt plus equity (D/V) Please find the relevant information to calculate the discount rate (WACC): Kradfoods Corp is placing a bond today in the market at a price of €100.15, and a coupon of 5.46% annual, maturity ten years (end 2032). Assume that the YTM of its debt in the 40% D/V ratio is going to be the same than that of this bond. The risk free rate (German Govt 10 years) yield to maturity is 1,78%. The levered beta of Kradfoods Corp is not known but we have data from a universe of “comparable companies “ shown in the Excel. The Equity Risk Premium is 4.29% Nisefoods Dividend Payout ratio is 45%. Management expects to increase the payout ratio to 55% after the acquisition. Nisefoods Inc business size (sales) are similar to Kradfoods Corp, but more profitable. It has grown in the past through debt issuance and retained earnings. Nisefoods Balance Sheet leverage is in line with the target D/V that it is proposing Kradfoods Corp BS. Nicefoods management owns 20% of the company, and has an incentive program linked to economic value creation during long term periods (6 years). The stock options, if granted, would increase their stake to 25% of the company in 5 years. Using the information given above please: 1- Calculate the projected FCF . Please explain why you include or not the use of excess capacity, cannibalization expenses. If included please show the impact at a different line . 2- Value KradFoods Corp using a DCF analysis (WACC). What is its’ EV? What is the Value of its’ Equity? 3- Please also value KradFoods Corp using for the terminal value a Market Multiple EV/EBIT 17.5x. (use the Ebit in the TV year to derive the EV) 4- Explain why the valuation using DFC (WACC) and DCF (WACC) & EV/EBIT is different. When would you use the valuation using the “exit multiple” EV/EBIT? When would you use the WACC for the derivation of the TV? 5- Please describe the impact of the change in the dividend policy from the point of view of signaling and agency problem. Make any assumptions you need to make to support your comment. Would you recommend then a different dividend policy? Why? Please work all your calculations in the Excel given, and answer the questions above both quantitatively and qualitatively (if you think there is room to make comments). P&L KradFoods Corp P&L StatementEXHIBIT 1 (million euros) 202020212022 SalesNet sales$6,545$6,728$7,001 Initial InventoryBeginning inventory850865922 PurchasesPurchases3,3383,4313,571 Final InventoryEnding inventory865922975 COGSTotal cost of goods sold$3,323$3,374$3,518 Gross MarginGROSS PROFIT$3,222$3,354$3,483 Operating Expenses2,1142,3632,621 EBITDAOperating expense (b)1,1089918620.1231952578 Depreciation192187180 EBIT916804682 Interest ExpenseInterest expense121133142 Profit Before Tax (PBT)Net income before taxes$795$671$540 Tax (30%)Provision for income taxes239201162 Net IncomeNet income$557$470$378 Dividends Paid334.03281.70227.0160% Retained Earnings222.684187.80151.3440% Purchases as % sales51.0%51.0%51.0% Operating Expenses % sales32.3%35.1%37.4% EBITDA Margin16.9%14.7%12.3% EBIT Margin14.0%11.9%9.7% Net Income Margin8.5%7.0%5.4% Capital expenditure201192187 Capital expenditure as % sales3.1%2.9%2.7% Nisefood Corp P&L StatementEXHIBIT 1 (million euros) 2022 SalesNet sales$8,000 &A Page &P Balancesheet KradFoods Corp Balance Sheet (M euros) 202020212022 Cash584634773 Acc. Receivable3,9284,4534,600 Inventory865922975 Current Assets5,3776,0096,348 Fixed Assets1,8701,8051,741 Total Assets7,2477,8148,089 Banks (debt)2,0272,4362,741 Acc. Payable992951749 Deferred Taxes40209 Current Liabilities3,0593,4073,499 Long Term Debt2,0102,0412,072 Total Liabilities5,0695,4485,571 Shareholders equity2,1782,3662,517 Total Liabilities & Net Worth7,2477,8148,089 4,825 0.6892525639 &A Page &P Comparable Cos Universe of Comparable Companies in the Food Industry % Sales in IndustryBook ValueEquity Market CapitalizationDebtEVEBITDANet IncomeLevered Beta Burger Corp82.00%10,08025,2004,80030,0003,6502,0161.25 Small Mac Co65.00%10,66732,0008,00040,0004,0501,9201.67 Fingers Corp67.00%10,64118,090- 018,0901,9902,7142.30 Shrimper Corp81.00%1,7523,6803704,0509208002.70 Clairon Corp10.00%2,6677,2003,80011,0001,2008642.00 Cod Corp87.00%5,5387,2006,80014,0009251,1521.40 Myfish Corp78.00%9,4296,6006,40013,0001,1002011.87 Azuzena Corp56.00%10,81811,9003,59015,4901,7001,5991.67