80.2K

Verified Solution

Link Copied!

. . . d. (Define and explain the importance of verification in financial planning and () prepare verification workings for: Gross and net profits Gross and net profit margins Total current assets, current liabilities and net current assets The quarterly movement in the Selma Cooke capital account Note: In the first part of d' requirement, you are required to write about the importance of information verification in financial planning and this should be done using Word' document with no more than 100 words. In the second part of d requirement, you are required to show the use of formulae (in your prepared spreadsheet) that detect and avoid errors in the calculations of the specified financial outcomes. 15% . Assignment Data Kiara is a small UK organisation. The business is a sole trader organisation owned by Miss Kiara Gill and produces a small range of synthetic products used by larger home and office furniture suppliers. The company financial management office is preparing the business plan for the year ending 30th September 2022 and, to this end, the following expected quarterly financial data has been gathered from the business functional managers: Q2 31 Mar 22 E Q1 31st Dec 21 E 60,000 33.900 01 30th Sep 22 E 71,800 33,000 Sales Q3 30th Jun 22 E 107,000 38,000 44,100 80,000 5,500 80,000 35,000 Purchases Other operating expenses 19,300 28.900 Fixed assets Inventory Accounts receivable 72,000 6,000 6,100 (5.000) 2,800 21,000 72,500 6,200 7,000 (4.100) 3,000 22,000 24,200 77,500 5,200 7,500 1,900 5,000 22.000 7,000 1,300 3,000 Bank (Overdraft) Accounts payable Long-term loans 25,000 Other data: At 30 September 2021: The inventory valuation is 4,500 The Miss Kiara capital account balance is 62,000 It is expected that, for the year to 30 September 2022, Miss Kara will withdraw 5,000 per month from the business for personal use (l.e. drawings) . . . d. (Define and explain the importance of verification in financial planning and () prepare verification workings for: Gross and net profits Gross and net profit margins Total current assets, current liabilities and net current assets The quarterly movement in the Selma Cooke capital account Note: In the first part of d' requirement, you are required to write about the importance of information verification in financial planning and this should be done using Word' document with no more than 100 words. In the second part of d requirement, you are required to show the use of formulae (in your prepared spreadsheet) that detect and avoid errors in the calculations of the specified financial outcomes. 15% . Assignment Data Kiara is a small UK organisation. The business is a sole trader organisation owned by Miss Kiara Gill and produces a small range of synthetic products used by larger home and office furniture suppliers. The company financial management office is preparing the business plan for the year ending 30th September 2022 and, to this end, the following expected quarterly financial data has been gathered from the business functional managers: Q2 31 Mar 22 E Q1 31st Dec 21 E 60,000 33.900 01 30th Sep 22 E 71,800 33,000 Sales Q3 30th Jun 22 E 107,000 38,000 44,100 80,000 5,500 80,000 35,000 Purchases Other operating expenses 19,300 28.900 Fixed assets Inventory Accounts receivable 72,000 6,000 6,100 (5.000) 2,800 21,000 72,500 6,200 7,000 (4.100) 3,000 22,000 24,200 77,500 5,200 7,500 1,900 5,000 22.000 7,000 1,300 3,000 Bank (Overdraft) Accounts payable Long-term loans 25,000 Other data: At 30 September 2021: The inventory valuation is 4,500 The Miss Kiara capital account balance is 62,000 It is expected that, for the year to 30 September 2022, Miss Kara will withdraw 5,000 per month from the business for personal use (l.e. drawings)

Answer & Explanation Solved by verified expert

See Answer