Ask Financial Management Expert

Individual Case Study Assignment: Cash flow forecasts and projected financial statements

For the following Individual Case Study Assignment, you assume the role of someone who has been asked to provide a business report for a group of friends who have invested in an organisation, Fashion Clothing. They had heard you are taking a finance module and have asked for your advice.

The scenario
A group of friends have formed a new business called Fashion Clothing, an online and mail-order clothing business, in which they have invested £200,000 of their own capital.

They intend to manufacture and sell quality clothes. They have set up the business and are selling direct to the final consumer, using a combination of aggressive marketing across a range of different media and also with the use of an automated website that accepts online orders.

Sales for the next 6 months 1,350,000
Cost of the materials used up in sales 390,000
Labour costs for the 6 months 480,000
Other expenses for the 6 months, including marketing costs and £15,000 depreciation of tangible non-current assets 345,000
Materials purchased during the 6 months 520,000

To support this, they also have a department of telephone sales and support staff ready to help customers. The sales staff work in teams and receive a basic salary plus commission for each successful sale. By the start of July 20X5, they have spent £150,000 on tangible non-current assets, and they currently have the remaining £50,000 in their business bank account.

They provide you with the following forecasted figures for their first 6 months of trading:

Their projected cash receipts and payments are estimated to be as follows:

Month (20X5) Sales Receipts Payments for Materials Labour and Other Expenses
£ £ £
July 150,000 120,000 These payments are divided equally over each of the 6 months.
August 120,000 100,000
September 150,000 60,000
October 210,000 60,000
November 260,000 60,000
December 285,000 60,000
Totals 1,175,000 460,000

In addition to the above, they expect to have to pay a tax bill of £20,000 in December 20X5 and also plan to buy (and pay for) £30,000 additional tangible non-current assets in that same month. All transactions will go through their business bank account.

To complete this Individual Case Study Assignment:

Provide a Business Report (1,000 words for the main body of the report) for the friends who have invested in Fashion Clothing, commenting on the businessâ€TM prospects and including the following five financial statements:

1. An opening statement of financial position at the start of July 20X5.

2. A monthly cash flow forecast, showing the bank balance at the end of each of the 6 months and indicating what level of overdraft facilities the friends need to negotiate with their bank manager. Explain what additional expense they should take into account as a result of needing this financial assistance (overdraft).

3. A projected income statement for the first 6 months of trading.

4. A projected statement of financial position for Fashion Clothing at the end of its first 6 months of operations.

5. A projected statement of cash flows for the first 6 months of trading and using the indirect method.

Since none of the investors have a background in accounting and finance, you should also explain what each of these statements means as a part of your report.
Keep the following in mind:

1. Using a spreadsheet may help you to produce your cash flow forecast. Remember here that £150,000 of the initial £200,000 has already been spent. Hence, your opening bank balance should be £50,000. Your closing bank balance should be included in your statement of financial position as at 31.12.20X5.

2. Think carefully about the £15,000 depreciation charge when working out your monthly cash outflows for labour and other expenses.

3. Also think carefully about the figures for closing stocks (inventories), creditors (payables) and debtors (receivables).

4. Please remember that your qualitative analysis and explanation of your five statements are just as important as the calculations themselves. These, together with your presentation of a professional report, will contribute towards your grade for this assignment.

5. Please be sure to re-visit the Key Concept Overviews for Weeks 1 and 2, as well as Week 3. These should serve as a reminder of the accruals concept, plus the difference between a cash flow forecast and a statement of cash flows. They also include detailed numerical examples that should assist with your calculations for your financial statements.

Ideally a business report should be produced with a suitable structure and quality of discussion around the following key areas:

Executive summary

Table of contents

List of figures

1. Introduction

2. Main financial findings.
2.1 Summary of the first 6 months business operations
2.2 Financial accounting statements

3. Analysis
3.1 Initial analysis in context of the three financial statements.
3.2 Investigations to increase efficiency

4. Conclusion

5. References

ANNEX I: Statement of financial position Fashion Clothing â€" 01.07.20X5 and 31.12.20X5
ANNEX II: Income statement Fashion Clothing â€" 6 months to 31.12.20X5
ANNEX III: Statement of cash flows Fashion Clothing â€" 6 months to 31.12.20X5
ANNEX IV: Projected cash flow forecast for the first 6 months of trading

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92742120

Have any Question?


Related Questions in Financial Management

Assignment problems1 on the day harry was born his parents

Assignment Problems 1. On the day Harry was born, his parents put $1600 into an investment account that promises to pay a fixed interest rate of 5 percent per year. How much money will Harry have in this account when he ...

1 activities of a company that require the spending of cash

1) Activities of a company that require the spending of cash are known as: A) Uses of cash. B) Cash on hand. C) Cash receipts. D) Sources of cash. E) Cash collections. 2) Relationships determined from a firm's financial ...

Module discussion forumto prepare for this discussion

Module : Discussion Forum To prepare for this discussion, review "Basics of Speechwriting" and "Basics of Giving a Speech" in textbook Chapter 15. Then watch this video of Apple founder and CEO Steve Jobs giving the 2005 ...

Launching a new product linefor this portfolio project

Launching a New Product Line For this Portfolio Project Option, you will act as an employee in a large company that develops and distributes men's and women's personal care products. The company has developed a new produ ...

Question 1 discuss valuing bonds and how interest rates

Question : 1) Discuss valuing bonds and how interest rates affect their value. Also consider the importance of the yield-to-maturity (YTM). 2) Discuss common stocks and preferred stocks. Also, which common stock valuatio ...

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

You have owned and operated a successful brick-and-mortar

You have owned and operated a successful brick-and-mortar business for several years. Due to increased competition from other retailers, you have decided to expand your operations to sell your products via the Internet. ...

You will be conducting an interview with a market research

You will be conducting an interview with a market research professional or a company representative. Use the results of your research to make specific recommendations on how market research can be applied to the Marketpl ...

Question 1 what is marketing research what are the two

Question 1: What is marketing research? What are the two primary types of research? Question 2: What factors influence marketing research? Question 3: The role of statistics in business decision-making? Assignment : Sele ...

Chapter 74 for commercial banks what is meant by a managed

Chapter 7 4. For commercial banks, what is meant by a managed liability? What role do liquid assets play on the balance sheet of commercial banks? What role do money market instruments play in the asset and liability man ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As