You are a management accountant working for a company called BHP, which manufactures iron ore. BHP's...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a management accountant working for a company called BHP, which manufactures iron ore. BHP's investment to progress the development of ground-breaking technology to reduce carbon emissions from smelter. The following three years forecast, were prepared by your last management accountant but are incomplete and require some adjustments are as follows, BHP forecast statements of comprehensive income for the year ended 31 December, BHP forecast statements of comprehensive income for the year ended 31 December, Ress Less Less Less Net profie Less Revenue Cost of sales Gross profit Operating expenses 325 Profit from operations 285 interest 30 Profit after Tax taxation Dividend Retained profit Reserves BVT Reserves C/f SK SK SK SK 2016 2017 2018 2019 $1.560 1638 1720 1806 950 997 1047 1100 $610 $641 $673 $706 Inventories Receivables Cash and bank Total assets 255 77 178 68 110 128 238 325 325 325 Forecast statement of Financial position at 31st December 2016 Non-Current assets (net book value) Current assets (CA) 316 348 381 30 30 30 286 318 351 10 0 0 286 318 351 10 10 lo 286 318 351 238 524 841 524 841 1192 750 326 192 50 1318 Forecast statement of Financial position at 31st December 2016 Non-Current assets (net book value) Current assets (CA) Inventories Receivables Cash and bank Total assets Financing Ordinary share capital (ordinary shares of $1) Retained profits to 30 December 2015 Retentions for the year to 31 December 2016 10% loan note redeemable 2020 Current liabilities Trade payables Other payables (including tax and dividends) Total equity and liabilities 750 326 192 50 1318 A) Investment decision 500 128 110 300 1038 145 1318 The following information is not reflected in the forecasts Forecast statement of Financial position at 31st December 2016 SK 750 Non-Current assets (net book value) Current assets (CA) Inventories Receivables Cash and bank Total assets Financing Ordinary share capital (ordinary shares of $1) Retained profits to 30 December 2015 Retentions for the year to 31 December 2016 10% loan note redeemable 2020 Current labilities Trade payables Other payables (including tax and dividends) Total equity and liabilities 326 192 50 1318 500 128 110 300 1038 135 145 1318 The following information is not reflected in the forecasts A) Investment decision The company plans to purchase new machinery (for Smelting division) to the value of $500,000 during 2017, to be depreciated straight line for 10 years. The company charges a full year's depreciation in the first three years of the purchase of its assets. Tax allowable depreciation at 25% of the reducing balance is available on this expenditure. B) Dividend decision The company plans to continue paying dividends, growing at 25% per year in each of the following financial years. C) As a result of the investment in new machinery, revenue and cost of sales are expected to increase by 10% in each of the financial years ending 31st December 2017, 2018, and 2019. Operating expenses are expected to increase by 5% each year. D) Taxation has not yet been calculated beyond the current year. The company expects to continue to be liable for tax at a marginal rate of 30%. You can assume that tax is paid or refunded 12 months after the year-end. F) The ratios of receivables to sales and trade E) The ratios of receivables to sales and trade payables to cost of sales will remain the same for the next three years. F) Noncurrent assets comprise land and buildings, for which no depreciation is provided. Other assets used by the company, such as machinery and vehicles, are hired on operating leases. G) Inventory was purchased for $35000 at the beginning of 2017. The value of inventory after this purchase i.d. expected to remain at $ 361,000 for the foreseeable future. H) No decision has been made on the type of finance to be used for the expansion programme. The company's directors believe that they can raise new medium-term secured bonds if necessary. The company has drawn up new financial objectives, which include the following. 1. To earn a pre-tax return on the closing book value of shareholders' funds of 35% pa 2. To increase dividends per share by 25% per year 3. To have debt/equity ratios at or below 50% 4. To increase earnings per share by 10% per year. Required: 1.Revise the forecast statements of the comprehensive income statement and prepare a schedule of equity and debt 2. Calculate whether the company is likely to meet its stated financial objectives for these three years 3. Prepare cash flow forecasts for the years 2017,2018 and 2019 and estimates the number of funds that the company will need to raise to finance its operations. Note: The student must use MS Excel to prepare financial statements. Part 1: Considering the outcomes of the previous assessment task, you will be required to present the following to the management: • Areas/quarter of the financial budget that is not achievable. • Negotiations in the financial budget • Impact of these negotiations • Areas that need adjustment to make improvements in the team budget/financial plan . Cost variations and expenditure overruns for each quarter • Contingency plan • Ageing summaries, cash flow, petty cash, Goods and Services Tax (GST), and profit and loss statements based on the specified budget. You must prepare 8-10 presentation slides. Part 2: Scenario: After delivering the presentation, you are then required to engage in discussion with the CEO and Finance Manager of the company to negotiate the following: • Due to decreasing the budget for maintenance and repair cost, some of the machines have not been repaired during the first two quarters. You must negotiate with the Finance manager to increase the funds for maintenance and repair in the master budget/ financial plan by 20%. • To increase the overhead cost such as office supplies by 10%. Negotiate this with the CEO. • Come to a mutual agreement on the on financial budget/plan. The role of the CEO will be played by your of of the finance trainer/assessor and the role • Due to decreasing the budget for maintenance and repair cost, some of the machines have not been repaired during the first two quarters. You must negotiate with the Finance manager to increase the funds for maintenance and repair in the master budget/ financial plan by 20%. • To increase the overhead cost such as office supplies by 10%. Negotiate this with the CEO. • Come to a mutual agreement on the on financial budget/plan. The role of the CEO will be played by your trainer/assessor, and the role of the finance manager will be allocated to the student by your trainer/assessor. If there are an insufficient number of students in the class, then your trainer/assessor will take on multiple roles and switch roles based on requirements. During the discussion/Roleplay: The finance manager will agree to the change as it is an essential cost that must be incurred. Otherwise, this will lead to damage to the machinery. The CEO will obstruct to increase the overhead cost because this will decrease the company's overall profit and with the increased wages, it is not possible for the company to increase the overhead cost by 10%. Part 3: After the discussion with the finance manager and CEO, it has been agreed that the funds for maintenance and repair in the master budget/ financial plan will be increased by 20% for last two- quarters of the project. You are required to revise the budget and disseminate the details of the changes made in the budget to the team members. You are required to prepare the revised budget using MS Excel. You must follow the template Part 3: After the discussion with the finance manager and CEO, it has been agreed that the funds for maintenance and repair in the master budget/ financial plan will be increased by 20% for last two- quarters of the project. You are required to revise the budget and disseminate the details of the changes made in the budget to the team members. You are required to prepare the revised budget using MS Excel. You must follow the template provided below. Revised Master budget with profit projections Big Red Bicycle Pty Ltd Master Budget FY 2018/2019 REVENUE Commissions (2.5% sales) Direct wages fixed Sales Cost of Goods Sold Gross profit EXPENSES General & Administrative Expenses Accounting fees Legal fees Bank charges Office supplies Postage & printing Dues & subscriptions Telephone Repair & maintenance Payroll tax Marketing Expenses Advertising Employment Expenses Superannuation Wages & salaries Staff amenities Occupancy Costs Electricity Insurance Rates Rent Petty cash Water Waste removal TOTAL EXPENSES NET PROFIT (BEFORE INTEREST & TAX) Income Tax Expense (25% Net) NET PROFIT AFTER TAX Q3 Q4 Performance Checklist: Trainer/ Assessor to complete: Project This task is in continuation of part E of assessment task 3. To complete this task, you will require the financial statements prepared as part of assessment task 2. Considering those financial statements (cash flow forecast and forecasted income statement), you will be required to review and evaluate these financial management processes with the work team. Your trainer, along with another student, will form a team with you. Your team will have 3 team members. You will then be required to analyse the following: • Cash flow statement: o Identify how much cash flowed into the business in the fourth quarter. Deduce the source of finance most appropriate for this business, starting in quarter 3. o Identify how much cash the business had in its account at the end of the cash flow statement period. o Identify the quarter in which the business had the highest level of cash inflow. o Identify the quarter in which the business had the highest level of cash outflow. • Income statement o Evaluate the legal structure of this business. o Identify items that would be included under Financial Expenses. 。 Calculate the tax liabilities for this business in 2019. • Financial ratios O o Current ratio (working capital ratio) o Debt to equity ratio o Identify how much cash flowed into the business in the fourth quarter. Deduce the source of finance most appropriate for this business, starting in quarter 3. o Identify how much cash the business had in its account at the end of the cash flow statement period. o Identify the quarter in which the business had the highest level of cash inflow. o Identify the quarter in which the business had the highest level of cash outflow. • Income statement o Evaluate the legal structure of this business. o Identify items that would be included under Financial Expenses. o Calculate the tax liabilities for this business in 2019. • Financial ratios o Current ratio (working capital ratio) o Debt to equity ratio o Return on equity (ROE) O After analysing the financial management processes of the organisation, you will then be required to prepare a report for the board of directors (trainer/assessor) that must include the following: . • Outcomes of analysis of cash flow statement. • Outcomes of analysis of income statement. • Outcomes of financial rations. • Your recommendations for improvement in the existing process. • Implement the improvements in Contingency plan and attach to the report. Record-keeping requirements for the Australian Taxation Office (ATO) and for auditing purposes . existing process. • Implement the improvements in Contingency plan and attach to the report. • Record-keeping requirements for the Australian Taxation Office (ATO) and for auditing purposes Template for the report: Evaluation report of the financial management processes A cover sheet of the unit of competency Version control information Disclaimer and Acknowledgement An introduction to the project List of symbols and their explanations Table of contents The main body of the report covering the following topics: *Outcomes of analysis of cash flow statement. *Outcomes of analysis of income statement. *Outcomes of financial rations. Your recommendations for improvement in the existing process. • Implement the improvements in Contingency plan and attach to the report Record-keeping requirements for the Australian Taxation Office (ATO) and for auditing purposes Summary and review Glossary References | You are a management accountant working for a company called BHP, which manufactures iron ore. BHP's investment to progress the development of ground-breaking technology to reduce carbon emissions from smelter. The following three years forecast, were prepared by your last management accountant but are incomplete and require some adjustments are as follows, BHP forecast statements of comprehensive income for the year ended 31 December, BHP forecast statements of comprehensive income for the year ended 31 December, Ress Less Less Less Net profie Less Revenue Cost of sales Gross profit Operating expenses 325 Profit from operations 285 interest 30 Profit after Tax taxation Dividend Retained profit Reserves BVT Reserves C/f SK SK SK SK 2016 2017 2018 2019 $1.560 1638 1720 1806 950 997 1047 1100 $610 $641 $673 $706 Inventories Receivables Cash and bank Total assets 255 77 178 68 110 128 238 325 325 325 Forecast statement of Financial position at 31st December 2016 Non-Current assets (net book value) Current assets (CA) 316 348 381 30 30 30 286 318 351 10 0 0 286 318 351 10 10 lo 286 318 351 238 524 841 524 841 1192 750 326 192 50 1318 Forecast statement of Financial position at 31st December 2016 Non-Current assets (net book value) Current assets (CA) Inventories Receivables Cash and bank Total assets Financing Ordinary share capital (ordinary shares of $1) Retained profits to 30 December 2015 Retentions for the year to 31 December 2016 10% loan note redeemable 2020 Current liabilities Trade payables Other payables (including tax and dividends) Total equity and liabilities 750 326 192 50 1318 A) Investment decision 500 128 110 300 1038 145 1318 The following information is not reflected in the forecasts Forecast statement of Financial position at 31st December 2016 SK 750 Non-Current assets (net book value) Current assets (CA) Inventories Receivables Cash and bank Total assets Financing Ordinary share capital (ordinary shares of $1) Retained profits to 30 December 2015 Retentions for the year to 31 December 2016 10% loan note redeemable 2020 Current labilities Trade payables Other payables (including tax and dividends) Total equity and liabilities 326 192 50 1318 500 128 110 300 1038 135 145 1318 The following information is not reflected in the forecasts A) Investment decision The company plans to purchase new machinery (for Smelting division) to the value of $500,000 during 2017, to be depreciated straight line for 10 years. The company charges a full year's depreciation in the first three years of the purchase of its assets. Tax allowable depreciation at 25% of the reducing balance is available on this expenditure. B) Dividend decision The company plans to continue paying dividends, growing at 25% per year in each of the following financial years. C) As a result of the investment in new machinery, revenue and cost of sales are expected to increase by 10% in each of the financial years ending 31st December 2017, 2018, and 2019. Operating expenses are expected to increase by 5% each year. D) Taxation has not yet been calculated beyond the current year. The company expects to continue to be liable for tax at a marginal rate of 30%. You can assume that tax is paid or refunded 12 months after the year-end. F) The ratios of receivables to sales and trade E) The ratios of receivables to sales and trade payables to cost of sales will remain the same for the next three years. F) Noncurrent assets comprise land and buildings, for which no depreciation is provided. Other assets used by the company, such as machinery and vehicles, are hired on operating leases. G) Inventory was purchased for $35000 at the beginning of 2017. The value of inventory after this purchase i.d. expected to remain at $ 361,000 for the foreseeable future. H) No decision has been made on the type of finance to be used for the expansion programme. The company's directors believe that they can raise new medium-term secured bonds if necessary. The company has drawn up new financial objectives, which include the following. 1. To earn a pre-tax return on the closing book value of shareholders' funds of 35% pa 2. To increase dividends per share by 25% per year 3. To have debt/equity ratios at or below 50% 4. To increase earnings per share by 10% per year. Required: 1.Revise the forecast statements of the comprehensive income statement and prepare a schedule of equity and debt 2. Calculate whether the company is likely to meet its stated financial objectives for these three years 3. Prepare cash flow forecasts for the years 2017,2018 and 2019 and estimates the number of funds that the company will need to raise to finance its operations. Note: The student must use MS Excel to prepare financial statements. Part 1: Considering the outcomes of the previous assessment task, you will be required to present the following to the management: • Areas/quarter of the financial budget that is not achievable. • Negotiations in the financial budget • Impact of these negotiations • Areas that need adjustment to make improvements in the team budget/financial plan . Cost variations and expenditure overruns for each quarter • Contingency plan • Ageing summaries, cash flow, petty cash, Goods and Services Tax (GST), and profit and loss statements based on the specified budget. You must prepare 8-10 presentation slides. Part 2: Scenario: After delivering the presentation, you are then required to engage in discussion with the CEO and Finance Manager of the company to negotiate the following: • Due to decreasing the budget for maintenance and repair cost, some of the machines have not been repaired during the first two quarters. You must negotiate with the Finance manager to increase the funds for maintenance and repair in the master budget/ financial plan by 20%. • To increase the overhead cost such as office supplies by 10%. Negotiate this with the CEO. • Come to a mutual agreement on the on financial budget/plan. The role of the CEO will be played by your of of the finance trainer/assessor and the role • Due to decreasing the budget for maintenance and repair cost, some of the machines have not been repaired during the first two quarters. You must negotiate with the Finance manager to increase the funds for maintenance and repair in the master budget/ financial plan by 20%. • To increase the overhead cost such as office supplies by 10%. Negotiate this with the CEO. • Come to a mutual agreement on the on financial budget/plan. The role of the CEO will be played by your trainer/assessor, and the role of the finance manager will be allocated to the student by your trainer/assessor. If there are an insufficient number of students in the class, then your trainer/assessor will take on multiple roles and switch roles based on requirements. During the discussion/Roleplay: The finance manager will agree to the change as it is an essential cost that must be incurred. Otherwise, this will lead to damage to the machinery. The CEO will obstruct to increase the overhead cost because this will decrease the company's overall profit and with the increased wages, it is not possible for the company to increase the overhead cost by 10%. Part 3: After the discussion with the finance manager and CEO, it has been agreed that the funds for maintenance and repair in the master budget/ financial plan will be increased by 20% for last two- quarters of the project. You are required to revise the budget and disseminate the details of the changes made in the budget to the team members. You are required to prepare the revised budget using MS Excel. You must follow the template Part 3: After the discussion with the finance manager and CEO, it has been agreed that the funds for maintenance and repair in the master budget/ financial plan will be increased by 20% for last two- quarters of the project. You are required to revise the budget and disseminate the details of the changes made in the budget to the team members. You are required to prepare the revised budget using MS Excel. You must follow the template provided below. Revised Master budget with profit projections Big Red Bicycle Pty Ltd Master Budget FY 2018/2019 REVENUE Commissions (2.5% sales) Direct wages fixed Sales Cost of Goods Sold Gross profit EXPENSES General & Administrative Expenses Accounting fees Legal fees Bank charges Office supplies Postage & printing Dues & subscriptions Telephone Repair & maintenance Payroll tax Marketing Expenses Advertising Employment Expenses Superannuation Wages & salaries Staff amenities Occupancy Costs Electricity Insurance Rates Rent Petty cash Water Waste removal TOTAL EXPENSES NET PROFIT (BEFORE INTEREST & TAX) Income Tax Expense (25% Net) NET PROFIT AFTER TAX Q3 Q4 Performance Checklist: Trainer/ Assessor to complete: Project This task is in continuation of part E of assessment task 3. To complete this task, you will require the financial statements prepared as part of assessment task 2. Considering those financial statements (cash flow forecast and forecasted income statement), you will be required to review and evaluate these financial management processes with the work team. Your trainer, along with another student, will form a team with you. Your team will have 3 team members. You will then be required to analyse the following: • Cash flow statement: o Identify how much cash flowed into the business in the fourth quarter. Deduce the source of finance most appropriate for this business, starting in quarter 3. o Identify how much cash the business had in its account at the end of the cash flow statement period. o Identify the quarter in which the business had the highest level of cash inflow. o Identify the quarter in which the business had the highest level of cash outflow. • Income statement o Evaluate the legal structure of this business. o Identify items that would be included under Financial Expenses. 。 Calculate the tax liabilities for this business in 2019. • Financial ratios O o Current ratio (working capital ratio) o Debt to equity ratio o Identify how much cash flowed into the business in the fourth quarter. Deduce the source of finance most appropriate for this business, starting in quarter 3. o Identify how much cash the business had in its account at the end of the cash flow statement period. o Identify the quarter in which the business had the highest level of cash inflow. o Identify the quarter in which the business had the highest level of cash outflow. • Income statement o Evaluate the legal structure of this business. o Identify items that would be included under Financial Expenses. o Calculate the tax liabilities for this business in 2019. • Financial ratios o Current ratio (working capital ratio) o Debt to equity ratio o Return on equity (ROE) O After analysing the financial management processes of the organisation, you will then be required to prepare a report for the board of directors (trainer/assessor) that must include the following: . • Outcomes of analysis of cash flow statement. • Outcomes of analysis of income statement. • Outcomes of financial rations. • Your recommendations for improvement in the existing process. • Implement the improvements in Contingency plan and attach to the report. Record-keeping requirements for the Australian Taxation Office (ATO) and for auditing purposes . existing process. • Implement the improvements in Contingency plan and attach to the report. • Record-keeping requirements for the Australian Taxation Office (ATO) and for auditing purposes Template for the report: Evaluation report of the financial management processes A cover sheet of the unit of competency Version control information Disclaimer and Acknowledgement An introduction to the project List of symbols and their explanations Table of contents The main body of the report covering the following topics: *Outcomes of analysis of cash flow statement. *Outcomes of analysis of income statement. *Outcomes of financial rations. Your recommendations for improvement in the existing process. • Implement the improvements in Contingency plan and attach to the report Record-keeping requirements for the Australian Taxation Office (ATO) and for auditing purposes Summary and review Glossary References |
Expert Answer:
Answer rating: 100% (QA)
Less Less Less Less Less Less Income Statement Reve... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these accounting questions
-
You are a management accountant working in the Finance team at Miles private hospital. You have been assigned to assist the ENT (Ear, Nose and Throat) specialists that operate out of rented premises...
-
You are a management accountant for Time Treasures Company, whose company has recently signed an outsourcing agreement with Spotless, Inc., a janitorial service company. Spotless will provide all of...
-
You are a management accountant working in the controllers office. Rick Koch, a very powerful executive, approaches you in the parking lot and asks you to do him a favor. The favor involves...
-
DrinkOh Limited uses an application service provider to process its payroll. Its employees enter their hours using their smart phones. The payroll clerk collects the smart phone data and transmits it...
-
A U.S. pension fund wants to invest $1 million in foreign equity. Its board of trustees must decide whether to invest in a commingled index fund tracking the EAFE index or to give the money to an...
-
Check the fundamental theorem for gradients, using T = x2 + 4xy + 2yz3, the points a = (0, 0, 0), b = (1, 1, 1), and the three paths in Fig. 1.28:? (a) (0,0.0) ??? (1.0, 0) ??? (1, 1,0) ??? (1,...
-
Express the Henry's-law constants reported in Table 8.1 as \(H_{i, p c}\) and \(H_{i, c p}\). Dimensionless temperature, 0.9 0.8 0.7 0.6 K=1+ (0-1/2) 0.5 0.4 0.3 0.2 0.1 K = 1 0 0.2 0.4 0.6 0.8...
-
ParentCo owns all of the stock of DaughterCo, and the group files its Federal income tax returns on a consolidated basis. Both taxpayers are subject to the AMT this year due to active operations in...
-
A company is considering two mutually exclusive projects. Both require an initial cash outlay of Rs.20000 each, and have a life of five years. The company's required rate of return is 10% and pays...
-
The spring mechanism is used as a shock absorber for a load applied to the drawbar AB. Determine the force in each spring when the 50-kN force is applied. Each spring is originally unstretched and...
-
Staffing The hospital staff has a capacity of 180 beds. The Nutrition Services Department may currently schedule up to 35 FTE per week when at 75-85% capacity. The department has a policy of avoiding...
-
What Culture Is and What It Does to Us" from "A Practical Guide to Culture" in the resource list for this devotional. Navigate to the threaded discussion and respond to the following discussion...
-
An effective Human Service Professional (Wellness, empathy, acceptance, competence, etc.) Using the characteristics listed, some of the qualities you possess as an individual that will allow you to...
-
Anna is a new licensed clinical social worker who has worked for a university counseling center for two months. Thomas is a student who was referred to her at the beginning of the semester for...
-
Cultural humility refers to the attitude and practice of working with clients at the micro, mezzo, and macro levels with a presence of humility while learning, communicating, offering help, and...
-
Toby wants to calculate her COGS for a fertilizing job she did last week. She used 4 0 pounds of fertilizer that she bought in bulk ( $ 1 , 0 0 0 for 2 , 0 0 0 pounds ) . It took her employee 1 . 5...
-
Using the Internet and/or other sources, the company Equifax has both faced and addressed one of the ethical issue or peronal privacy and hacking. Describe the scenario and outcomes of that...
-
A 20-cm-square vertical plate is heated to a temperature of 30oC and submerged in glycerin at 10oC. Calculate the heat lost from both sides of the plate.
-
Tenneco, Inc., produces three models of tennis rackets: standard, deluxe, and pro. Following are the sales and cost information for 2011: Fixed manufacturing support costs are $800,000, and fixed...
-
What is the difference between flexible and capacity-related resources?
-
Under what two conditions are volumebased traditional product costing systems most likely to distort product costs? How do activity-based costing systems provide more accurate costs when these two...
-
In Fig. 1130, there is no explicit invariant that states that a Transaction cannot be linked to movements that are linked to the same account, because the structure of the model already demands is....
-
Apply the Account/Transaction pattern to the parallel financial transactions of the example shown in Figs. 1131 to 1135. As the bills may be paid forward, it may be necessary to use memo entries....
-
Look at Fig. 1119 and create a new discount strategy that gives a percentage of discount for sales with more than a certain number of products. Order | < > < > +nr: Natural = < > +date: Date...
Study smarter with the SolutionInn App