Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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 304 September 2022 and, to this end, the following expected quarterly financial data has been gathered from the business functional managers: Q1 Q2 Q3 04 31st Dec 21 31 Mar 22 30th Jun 22 30th Sep 22 E E Sales 60,000 80,000 107,000 71,800 Purchases 33,900 35,000 38,000 33,000 Other operating expenses 19,300 28,900 44,100 24,200 Fixed assets 72,000 72,500 80,000 77,500 Inventory 6,000 6,200 5,500 5,200 Accounts receivable 6,100 7,000 7,000 7,500 Bank (Overdraft) (5,000) (4,100) 1,300 1,900 Accounts payable 2,800 3,000 3,000 5,000 Long-term loans 21,000 22,000 25,000 22,000 Other data: At 304 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 30th September 2022, Miss Kiara will withdraw 5,000 per month from the business for personal use (i.e. drawings) f. Create a worksheet named Bank' and create an appropriate chart that will show quarterly closing bank balances (for each quarter) 10% 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 304 September 2022 and, to this end, the following expected quarterly financial data has been gathered from the business functional managers: Q1 Q2 Q3 04 31st Dec 21 31 Mar 22 30th Jun 22 30th Sep 22 E E Sales 60,000 80,000 107,000 71,800 Purchases 33,900 35,000 38,000 33,000 Other operating expenses 19,300 28,900 44,100 24,200 Fixed assets 72,000 72,500 80,000 77,500 Inventory 6,000 6,200 5,500 5,200 Accounts receivable 6,100 7,000 7,000 7,500 Bank (Overdraft) (5,000) (4,100) 1,300 1,900 Accounts payable 2,800 3,000 3,000 5,000 Long-term loans 21,000 22,000 25,000 22,000 Other data: At 304 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 30th September 2022, Miss Kiara will withdraw 5,000 per month from the business for personal use (i.e. drawings) f. Create a worksheet named Bank' and create an appropriate chart that will show quarterly closing bank balances (for each quarter) 10%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Asset Allocation And International Investments

Authors: G. Gregoriou

1st Edition

023001917X,0230626513

More Books

Students also viewed these Finance questions

Question

Types of curriculum ?

Answered: 1 week ago

Question

Curriculum analysis: main points explain?

Answered: 1 week ago

Question

Advantages of team teaching ?

Answered: 1 week ago

Question

Describe the ethics of marketing.

Answered: 1 week ago

Question

ASCII stand for?

Answered: 1 week ago