Calculating Returns to Equity Holders - Accounting & Finance Assignment Help

Assignment Task

Task 

Section A

Consider the Excel spreadsheet model: “ALT_INV_SEM1_2022_PROBLEM6.xlsx”. This spreadsheet corrects the limitations of the spreadsheet. 

A simple LBO model 
1. All cashflows are in $Millions and occur at the end of the year 
2. Cost of the target is 50M and the target is ungeared 3.

Funded by: 
i. Senior Debt (70%) 
ii. Mazzanine Debt (20%) 
iii. Equity (10%) 
Interest rate on senior debt is 12% p.a reducing 
Mezannine debt is 15% 
pa interest only plus 15% 
ownership share of business at the end of 4 years 
Corporate Tax Rate = 36% 
Cashflow forecasts 
EBIT = 11.5M in Year 1, growing at 2% pa 
Depreciation = 2M pa 
Investment expenditure = 2M pa 
Business (geared) sold at the end of Year 4 at an exit PE multiple of 7 times Year 4 Profit-After-Tax

Required: 
(i) Alter the EBIT values in the spreadsheet and produce a table that gives the IRR to equity holders (with no fees), the IRR to equity-holders (with fees), the DPI ratio (assuming no fees) and the DPI ratio (with fees). 
(ii) Using at least 3 fixed EBIT values, vary the proportions of the LBO that are funded by senior debt, mezzanine debt and equity and produce a table that gives the IRR to equity holders (with no fees), the IRR to equity-holders (with fees), the DPI ratio (assuming no fees) and the DPI ratio (with fees). NOTE: You will have at least 3 tables for this part, one for each EBIT value that you choose. 
(iii) Comment critically on your results. 
(iv) Comment critically on the limitations of this spreadsheet model, including a comment on the limitations of the IRR method for calculating returns to equity-holders.

This Accounting & Finance Assignment has been solved by our Accounting & Finance Expert at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.