Please answer question 3 ASAP

200,000 700.000 900,000 500,000 am munes Equity Share capital Retained earnings Total equity Long-term borrowings Current liabilities Trade and other payables Short-term borrowings Total current liabilities Total liabilities Total equity and liabilities 170.000 150,000 320.000 820.000 1,720,000 In 2013, management expects revenue to increase by 10%. With cutbacks in different segments of their business activities, ROR is expected to improve to 12%. Cost of sales as a percentage of revenue is expected to improve and decline to 20%. Management also expects improvements in the working capital accounts. The company's objective is to lower trade receivables to $370,000, with inventory levels expected to reach $280,000. Questions 1. Calculate the company's return on total assets for 2012. 2. How much cash will be provided by internal operations in 2013, in particular by the following? Retained earnings Inventories Trade receivables Scanned by Cams Overview of Financial Management 3. How much will management have to raise from external activities (shareholders and lenders) to proceed with an $800,000 investment in non-current assets? FINANCIAL SPREADSHEETS: EXCEL You can download financial spreadsheets from the Companion Website for this b- at www.bergeron7e.nelson.com. Use the spreadsheets to perform most finan calculations (simple or complicated) in this text. In fact, most calculations done this text and the Instructor's Manual were done with the help of these spreadshe The spreadsheets allow you more time for analyzing financial statements eliminating some "number crunching." The Companion Website includes Read Notes that explain how to use the spreadsheets. As we go through the chapters of text, some brief comments will be made regarding the application and the typ analysis that can be done with these spreadsheets. The spreadsheets are divided into two parts: (1) Financial Statement Analysis (2) Decision-Making Tools. 200,000 700.000 900,000 500,000 am munes Equity Share capital Retained earnings Total equity Long-term borrowings Current liabilities Trade and other payables Short-term borrowings Total current liabilities Total liabilities Total equity and liabilities 170.000 150,000 320.000 820.000 1,720,000 In 2013, management expects revenue to increase by 10%. With cutbacks in different segments of their business activities, ROR is expected to improve to 12%. Cost of sales as a percentage of revenue is expected to improve and decline to 20%. Management also expects improvements in the working capital accounts. The company's objective is to lower trade receivables to $370,000, with inventory levels expected to reach $280,000. Questions 1. Calculate the company's return on total assets for 2012. 2. How much cash will be provided by internal operations in 2013, in particular by the following? Retained earnings Inventories Trade receivables Scanned by Cams Overview of Financial Management 3. How much will management have to raise from external activities (shareholders and lenders) to proceed with an $800,000 investment in non-current assets? FINANCIAL SPREADSHEETS: EXCEL You can download financial spreadsheets from the Companion Website for this b- at www.bergeron7e.nelson.com. Use the spreadsheets to perform most finan calculations (simple or complicated) in this text. In fact, most calculations done this text and the Instructor's Manual were done with the help of these spreadshe The spreadsheets allow you more time for analyzing financial statements eliminating some "number crunching." The Companion Website includes Read Notes that explain how to use the spreadsheets. As we go through the chapters of text, some brief comments will be made regarding the application and the typ analysis that can be done with these spreadsheets. The spreadsheets are divided into two parts: (1) Financial Statement Analysis (2) Decision-Making Tools