Q3a: Based on Figure 3 information produce a cash flow forecast for Amna's business. Q3b: Identify those months where there may be a financial issue. For each month, analyse the issue and make recommendation(s) to solve these. Figure 3 Complete a cash flow forecast for January to June from the following information for Amna's business: • A business starts with £13,000 in the bank. • It will take out a loan of £11,000 in March. • It will pay back the loan at £900 per month beginning in April. • It will sublet its premises and receive £7,000 in January and in April. • In March it will sell a van for £5000 and buy a new one costing £10,000. • Its overheads will be £9,000 from January to March and then increase to £12,000 per month. • It will pay £6,000 per month in wages. • In April it will pay a tax bill of £9,000. Its sales and purchases are as follows: Jan Feb March April May June £ £ £ £ £ £ Sales 5000 6700 6000 6400 7000 7000 Purchases 5000 2300 3200 2400 5500 4400
Q3a: Based on Figure 3 information produce a cash flow forecast for Amna's business. Q3b: Identify those months where there may be a financial issue. For each month, analyse the issue and make recommendation(s) to solve these. Figure 3 Complete a cash flow forecast for January to June from the following information for Amna's business: • A business starts with £13,000 in the bank. • It will take out a loan of £11,000 in March. • It will pay back the loan at £900 per month beginning in April. • It will sublet its premises and receive £7,000 in January and in April. • In March it will sell a van for £5000 and buy a new one costing £10,000. • Its overheads will be £9,000 from January to March and then increase to £12,000 per month. • It will pay £6,000 per month in wages. • In April it will pay a tax bill of £9,000. Its sales and purchases are as follows: Jan Feb March April May June £ £ £ £ £ £ Sales 5000 6700 6000 6400 7000 7000 Purchases 5000 2300 3200 2400 5500 4400
Chapter6: Managing Cash Flow
Section: Chapter Questions
Problem 12SEP
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,