Balance Sheet and P&L for Five Years (2016 to 2020) - Accounting Assignment Help

Assignment Task

Company you are valuing is D Mart in the Retailing sector.    

• Balance Sheet and P&L for five years (2016 to 2020) is given. These are historical numnbers and not projections.    
• Capex and Debt related historical information for the last five years is similarly given in labelled sheets.    
• D Mart and BSE 200 quotes from March 2017 to Feb 2020 is given in the Beta sheet.    
• The Assumptions sheet provides you with Revenue, Cost and Tax drivers.    

    
What is to be done?    

• Using the historical information and drivers provided, project Revenue, Costs and Tax for the next five years. Check if P&L reflects the projected values.    
• Build the Balance Sheet for the next five yeas.    
• Calcualte the Beta of the stock.    
• Build the Cashflows sheet for the next five years using the P&L, Working Capital, Capex and Debt projections.    
• Determine the Closing Cash and Cash Equivalent for each of the projected five years.    
• Using the Risk Free Interest Rate givne in the Cashflows sheet, compute the Cost of Equity using the CAPM model.    
• Compute the Free Cash Flows to Equity (FCFE) for the each of the five years. Extend the projections for the next 11 years using growth rates given for     
• Compute the Terminal Growth FCFE using the Terminal Growth Rate (%) given in the Cash Flows sheet.    
• Compute the Present Value of all Free Cash Flows using the Cost of Equity.    
• Determine Value per Equity Share given the number of shres shown in the Cash Flow sheet.    

This Accounting Assignment has been solved by our Accounting Experts 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 Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.