Reference no: EM132652312
Using the Income Statement Forecast Template for JB Hi-Fi (uploaded under the Lecture Slides), make an Formulate a forecasted income statement for Decmil Group Limited (DCG). excel income statement forecast template for DCG.
Question (a) In the excel template, recast/standardize DCG's income statement for FY2018, FY2019 and FY2020 (Ensure that you have the same revenue/expense items as in JBH's income statement forecast). Follow the exact same format as was used for JB Hi-Fi. Download the annual report/required information from DatAnalysis Premium.
Question (b) Following the Income Statement Forecast Template for JB Hi-Fi, calculate the key financial ratios for FY2018, FY2019 and FY2020 for DCG. Follow the exact same format as was used for JB Hi-Fi.
Question (c) Forecast key income statement items, beginning with sales forecast (As the purpose of this exercise is to make your income statement forecast template work). You need to use assumptions for the key line items for FY2021, FY2022 and FY2023. Please explicitly mention these assumptions. If needed, you may use hypothetical data for balance sheet items (if needed to complete the forecasted income statement). Again, follow the exact same format as was used for JB Hi-Fi.
Question (d) Calculate and complete DCG's income statement forecast for the next three years (i.e, FY2021, FY2022 and FY2023).