Your Tasks: Part A (using the excel file provided on the Moodle] 1) Calculate the GST exclusive and GST inclusive sales price for each boardroom webcam. 2) Calculate interest expense, and depreciation expense, on the separate sheets included in the Excel file on Moodle. Don't forget to include these expenses in your P&L in the next step. 3) Produce a projected profit and loss statement for the financial year ending 30-June-2021 for each of the two scenarios. 4) Calculate on the P&L sheet, the tax payable for Banana Industries Pty Ltd [a 'base-rate' entity), and Net Profit After Tax, for each of the two scenarios. Note: For interest, depreciation, and the P&L generally, calculations to the nearest whole dollar are acceptable. For the price calculations in part A[1], and the tax/NPAT calculations at the end of the P&L, cents may be necessary. Part B (create your report in MS Word) 1) Advise your client on which scenario should be selected. Explain and justify why you would advise this selection (approx. 150 words). 2) Comment on any variances between the scenarios (approx. 150 words). 3) Explain the difference between straight-line depreciation and reducing balance depreciation to your client. Reference any materials cited (approx. 150 words). 4) Prepare break-even analysis on the scenario you recommended in part B[1] above: a. Calculate the break even analysis mathematically. b. Show the break even analysis graphically. C. Explain break-even analysis and why it is an important tool for business. (References required) (approx. 250 words). 5) Produce a Pie Graph showing the break-up of all expenses in the under the scenario recommended in part B[1] above. Comment on the pie graph (approx. 100 words). 6) From your analysis provide your recommendation to the client with supporting evidence (hints: consider contribution margins, NP and GP analysis, and the current economic outlook). Your Tasks: Part A (using the excel file provided on the Moodle] 1) Calculate the GST exclusive and GST inclusive sales price for each boardroom webcam. 2) Calculate interest expense, and depreciation expense, on the separate sheets included in the Excel file on Moodle. Don't forget to include these expenses in your P&L in the next step. 3) Produce a projected profit and loss statement for the financial year ending 30-June-2021 for each of the two scenarios. 4) Calculate on the P&L sheet, the tax payable for Banana Industries Pty Ltd [a 'base-rate' entity), and Net Profit After Tax, for each of the two scenarios. Note: For interest, depreciation, and the P&L generally, calculations to the nearest whole dollar are acceptable. For the price calculations in part A[1], and the tax/NPAT calculations at the end of the P&L, cents may be necessary. Part B (create your report in MS Word) 1) Advise your client on which scenario should be selected. Explain and justify why you would advise this selection (approx. 150 words). 2) Comment on any variances between the scenarios (approx. 150 words). 3) Explain the difference between straight-line depreciation and reducing balance depreciation to your client. Reference any materials cited (approx. 150 words). 4) Prepare break-even analysis on the scenario you recommended in part B[1] above: a. Calculate the break even analysis mathematically. b. Show the break even analysis graphically. C. Explain break-even analysis and why it is an important tool for business. (References required) (approx. 250 words). 5) Produce a Pie Graph showing the break-up of all expenses in the under the scenario recommended in part B[1] above. Comment on the pie graph (approx. 100 words). 6) From your analysis provide your recommendation to the client with supporting evidence (hints: consider contribution margins, NP and GP analysis, and the current economic outlook)
