Calculate the key financial ratios for dcg

Assignment Help Financial Accounting

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).

Reference no: EM132652312

Questions Cloud

About analyzing your target population : How would you go about analyzing your target population? What types of resources could you use? Select and identify a target population.

What are the ears on two loans : What are the EARs on these two loans? What are the APRs?

How does the transaction get entered into a journal : Question - How does the following transaction get entered into a journal, and which journal does it get entered into

Identify could use to audit sun construction revenue : For each of the assertions of occurrence, completeness and accuracy, identify a procedure(s) you could use to audit Sun Construction's revenue.

Calculate the key financial ratios for dcg : 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.

List key characteristics of an effective transfer pricing : Question - List THREE key characteristics of an effective transfer pricing policy, AND using these and any other relevant factors

Demand forecasting results in estimate of future demand : Demand forecasting results in an estimate of future demand and gives an organization a basis for planning and making sound business decisions

What is the main accounting policy issue : What is the main accounting policy issue(s) that need to be resolved in relation to the alleged underpayment of wages

Determine john has arrived at the appropriate conclusion : Based on the results of the testing of controls outlined above, determine whether John has arrived at the appropriate conclusion?

User Account

All Pages