Luma Lights (LL) manufactures decorative lamps for hotels. LL has received several large orders and the owner expects the business to make a profit this year. However, most hotel customers pay 60 days after delivery, while LL must pay its employees and electricity bills every month.
Define the term cash flow.
Explain why LL might be profitable but still experience cash-flow problems.
Nuru Bakes (NB) is an established bakery. The owner is considering buying a new oven to increase production capacity. The oven would be paid for immediately, but the extra bread and cakes would not be sold until later in the year.
Explain the relationship between investment, profit and cash flow for NB if it buys the new oven.
Bloom & Bean (BB) is a small cafe. BB sells to individual customers for cash and also supplies cakes to a local office on one-month trade credit. The owner has prepared the following data for March.
Table 1: Selected cash-flow data for BB for March, figures in USD
Item | Amount (USD) |
|---|---|
Opening cash balance on 1 March | 1800 |
Cash sales in March | 11600 |
Credit sales made in March, payable in April | 4000 |
Cash received in March from February credit sales | 3200 |
Wages paid in March | 5200 |
Rent paid in March | 2400 |
Ingredients paid for in March | 4300 |
Utilities paid in March | 700 |
Loan repayment paid in March | 1000 |
Calculate BB’s total cash inflows for March. Show all your working.
Calculate BB’s closing cash balance for March. Show all your working.
Comment on why BB’s profit for March may differ from its March cash flow.
Riverbean Cafe (RC) is a small coffee shop near a university. Sales are high during term time but fall sharply during holidays. RC’s manager is preparing a monthly cash-flow forecast before deciding whether to hire another barista.
Describe two advantages for RC of preparing a cash-flow forecast.
Kaito Cycles (KC) sells bicycles online. KC’s cash-flow forecast predicts positive closing balances for the next six months. The forecast assumes that sales will grow because of a social media campaign and that suppliers will not increase prices.
Explain two limitations of KC’s cash-flow forecast.
MobiMend (MM) repairs mobile phones. MM is worried about a possible cash shortage in June and July. It is considering offering an early-payment discount to business customers. The discount is forecast to increase July cash receipts by 3000, but it will reduce July profit by 600.
Table 3: MM’s cash-flow forecast before the early-payment discount, figures in USD
| Item | June | July |
|---|---|---|
| Opening cash balance | 900 | to be calculated |
| Cash inflows | 18000 | 20000 |
| Materials paid | 8000 | 9000 |
| Wages paid | 7000 | 7000 |
| Rent paid | 2500 | 2500 |
| Loan repayment paid | 1200 | 1200 |
| Marketing paid | 1800 | 1800 |
Item | June (USD) | July (USD) |
|---|---|---|
Opening cash balance | 900 | to be calculated |
Cash inflows | 18,000 | 20,000 |
Materials paid | 8,000 | 9,000 |
Wages paid | 7,000 | 7,000 |
Rent paid | 2,500 | 2,500 |
Loan repayment paid | 1,200 | 1,200 |
Marketing paid | 1,800 | 1,800 |
Discount: extra July cash receipts | — | 3,000 |
Discount: July profit effect | — | -600 |
Calculate MM’s forecast closing cash balance at the end of July before introducing the early-payment discount. Show all your working.
Calculate MM’s forecast closing cash balance at the end of July if it introduces the early-payment discount.
Comment on the suitability of the early-payment discount for MM.
Harbour Bikes (HB) rents bicycles to tourists. Demand is seasonal and HB expects a weak September. A supplier offers to defer of HB’s September cash payments until October with no extra charge.
Table 5: HB’s cash-flow forecast before the supplier deferral, figures in USD
Item | August (USD) | September (USD) | October (USD) |
|---|---|---|---|
Opening cash balance on 1 August | 3,000 | to be calculated | to be calculated |
Total cash inflows | 15,000 | 12,000 | 18,000 |
Total cash outflows before supplier deferral | 17,000 | 16,000 | 14,000 |
Calculate HB’s closing cash balance at the end of October before the supplier deferral. Show all your working.
Calculate HB’s September and October closing cash balances if it accepts the supplier deferral. Show all your working.
Comment on whether the supplier deferral is useful for HB.
BluePatch Repairs (BPR) repairs smartphones and tablets. BPR’s founder prepared a cash-flow forecast before opening a second shop. The forecast assumes that the new shop will attract the same number of customers as the first shop and that customers will pay immediately by card.
Explain two reasons why BPR’s cash-flow forecast may be unreliable.
FreshFit (FF) prepares healthy meal kits. FF’s opening cash balance on 1 May is 2000. Customers pay 75% of sales revenue in the month of sale and 25% one month later. There were no credit sales outstanding from April.
Table 2: Forecasted data for FF for May to July, figures in USD
| Item | May | June | July |
|---|---|---|---|
| Forecast sales revenue | 12000 | 14000 | 16000 |
| Food purchases, paid in the same month | 40% of sales revenue | 40% of sales revenue | 40% of sales revenue |
| Wages | 3000 | 3000 | 3000 |
| Online advertising | 800 | 800 | 800 |
| Kitchen rent | 2400 | 0 | 0 |
| Equipment purchase | 0 | 4000 | 0 |
Item | May (USD) | June (USD) | July (USD) |
|---|---|---|---|
Forecast sales revenue | 12000 | 14000 | 16000 |
Food purchases, paid in the same month | 40% of sales revenue | 40% of sales revenue | 40% of sales revenue |
Opening cash balance on 1 May | 2000 | ||
Sales receipts in month of sale | 75% of sales revenue | 75% of sales revenue | 75% of sales revenue |
Wages | 3000 | 3000 | 3000 |
Online advertising | 800 | 800 | 800 |
Kitchen rent | 2400 | 0 | 0 |
Equipment purchase | 0 | 4000 | 0 |
Sales receipts one month later | 25% of previous month's sales revenue | 25% of previous month's sales revenue | 25% of previous month's sales revenue |
Credit sales outstanding from April | 0 | ||
Food purchase payment timing | Same month | Same month | Same month |
Opening cash date | 1 May |
Using Table 2, prepare a monthly cash-flow forecast for FF for May to July. Show all your working.
EcoPrint (EP) prints sustainable packaging. EP is considering buying a new printer for cash in April. The printer is expected to improve future revenue, but the cash payment is immediate.
Table 4: Forecasted data for EP, figures in USD
Item | April (USD) | May (USD) |
|---|---|---|
Opening cash balance | 7500 | to be calculated |
Cash receipts from customers | 18000 | 24000 |
Operating cash payments | 16000 | 17500 |
Cash purchase of new printer | 10000 | 0 |
Depreciation charge on new printer | 500 | 500 |
Calculate EP’s closing cash balance for April if it buys the new printer. Show all your working.
Calculate EP’s forecast operating profit for April, treating cash receipts from customers as revenue and operating cash payments as operating expenses, assuming the printer purchase is not treated as an expense and depreciation is included. Show all your working.
Comment on the relationship between EP’s investment, profit and cash flow in April.
Mara Events (ME) organizes weddings and corporate dinners. ME pays venues, florists and caterers before each event, but many customers pay the final invoice after the event. The owner is worried that ME may not have enough cash to pay suppliers during a busy month.
Analyse two strategies ME could use to deal with its cash-flow problem.
Altair Farm Shop (AFS) sells fruit, vegetables and homemade jams. Cash inflows are high in summer when tourists visit, but AFS has low cash inflows in winter while still paying rent, insurance and some permanent staff. The owner is considering either arranging an overdraft or cutting winter staff hours.
Analyse the suitability of an overdraft and cutting staff hours as strategies for AFS to deal with its cash-flow problem.
Solace Fitness (SF) operates one successful gym. SF plans to open a second gym by paying a large deposit on premises, buying exercise machines and launching a marketing campaign before opening. The finance director forecasts that membership revenue and profit will increase after six months.
Analyse the relationship between investment, profit and cash flow for SF’s planned second gym.
Nimbus Events (NE) organizes conferences. NE expects a cash-flow problem in November because several venue deposits must be paid before customers pay the final invoices. NE is considering two strategies:
Table 7: NE’s forecast for November before either strategy, figures in USD
| Item | November |
|---|---|
| Opening cash balance | 4000 |
| Cash inflows | 38000 |
| Venue deposits paid | 18000 |
| Freelance wages paid | 14000 |
| Insurance paid | 6000 |
| Equipment deposit paid | 7000 |
Section | Item | Amount / USD |
|---|---|---|
November forecast | Opening cash balance | 4000 |
November forecast | Cash inflows | 38000 |
November forecast | Venue deposits paid | 18000 |
November forecast | Freelance wages paid | 14000 |
November forecast | Insurance paid | 6000 |
November forecast | Equipment deposit paid | 7000 |
Strategy A | Earlier customer deposits | +6000 |
Strategy A | December sales reduction | -2000 |
Strategy B | Equipment deposit delayed | +7000 |
Strategy B | December supplier interest | -400 |
Calculate NE’s November closing cash balance if it uses Strategy A. Show all your working.
Calculate NE’s November closing cash balance if it uses Strategy B. Show all your working.
Comment on which strategy is more suitable for improving NE’s immediate November cash flow. In your answer, consider the stated December consequences.
Seabright Swim School (SSS) provides swimming lessons for children and adults. It rents swimming pools from local schools and leisure centres. SSS has recently won several profitable contracts to teach swimming in local primary schools. However, the schools pay SSS 60 days after each block of lessons has ended, while SSS must pay instructors weekly and pool rental monthly.
Elena, the owner of SSS, has prepared a cash-flow forecast showing negative closing balances in March and April, even though SSS is forecast to make a profit for the year. Elena is considering two main approaches. The first is to improve cash inflows by requiring schools to pay a deposit before lessons start and by reducing the credit period offered to schools. The second is to reduce cash outflows by cancelling some low-attendance classes, hiring fewer assistant instructors and delaying the replacement of safety equipment. A bank has also offered SSS an overdraft facility, but the interest rate is high.
Evaluate whether SSS should focus on improving cash inflows rather than reducing cash outflows to solve its cash-flow problem.
Oak & Loom (OL) manufactures wooden furniture for hotels and restaurants. OL has a reputation for high-quality handmade tables and chairs. Demand has increased, and several customers have complained about long delivery times. The owner, Mara, is considering buying a computer-controlled cutting machine. The machine would be paid for immediately and would require staff training, but it should reduce waste and allow OL to complete more orders later in the year.
Mara’s accountant has prepared a six-month cash-flow forecast for OL if the machine is bought now. The forecast suggests that OL’s closing cash balance would become negative soon after the purchase, but cash inflows would improve in later months if more orders are completed. Some managers want to buy the machine now to increase future profit. Others think OL should delay the investment until after its busiest sales period or arrange finance rather than paying for the machine immediately.
Month | Opening balance (£) | Total cash inflows (£) | Total cash outflows (£) | Net cash flow (£) | Closing balance (£) |
|---|---|---|---|---|---|
Month 1 | £20,000 | £30,000 | £70,000 | -£40,000 | -£20,000 |
Month 2 | -£20,000 | £32,000 | £28,000 | £4,000 | -£16,000 |
Month 3 | -£16,000 | £34,000 | £29,000 | £5,000 | -£11,000 |
Month 4 | -£11,000 | £44,000 | £30,000 | £14,000 | £3,000 |
Month 5 | £3,000 | £48,000 | £31,000 | £17,000 | £20,000 |
Month 6 | £20,000 | £52,000 | £32,000 | £20,000 | £40,000 |
Evaluate whether OL should buy the computer-controlled cutting machine now.
AeroPods (AP) manufactures wireless earphones. AP’s opening cash balance on 1 January is 12000. AP receives 60% of sales revenue in the month of sale and 40% one month later. There were no credit sales outstanding from December. A bank loan is received in January and interest is paid monthly from February.
Table 6: Forecasted data for AP for January to April, figures in USD
| Item | January | February | March | April |
|---|---|---|---|---|
| Unit sales | 800 | 900 | 1100 | 1200 |
| Selling price per unit | 30 | 30 | 30 | 30 |
| Component purchases, paid in same month | 45% of sales revenue | 45% of sales revenue | 45% of sales revenue | 45% of sales revenue |
| Salaries | 9000 | 9000 | 9000 | 9000 |
| Rent | 6000 | 0 | 0 | 6000 |
| Marketing launch payment | 0 | 5000 | 0 | 0 |
| Bank loan received | 15000 | 0 | 0 | 0 |
| Interest paid | 0 | 600 | 600 | 600 |
Item | January | February | March | April |
|---|---|---|---|---|
Opening cash balance (USD) | 12000 | — | — | — |
Unit sales (units) | 800 | 900 | 1100 | 1200 |
Selling price per unit (USD) | 30 | 30 | 30 | 30 |
Sales receipts | 60% now; 40% next month | 60% now; 40% next month | 60% now; 40% next month | 60% now; 40% next month |
Component purchases | 45% of sales revenue | 45% of sales revenue | 45% of sales revenue | 45% of sales revenue |
Salaries (USD) | 9000 | 9000 | 9000 | 9000 |
Rent (USD) | 6000 | 0 | 0 | 6000 |
Marketing launch payment (USD) | 0 | 5000 | 0 | 0 |
Bank loan received (USD) | 15000 | 0 | 0 | 0 |
Interest paid (USD) | 0 | 600 | 600 | 600 |
Using Table 6, prepare a monthly cash-flow forecast for AP for January to April. Show all your working.
VeloWare (VW) supplies cycling accessories to retailers. VW is profitable, but most retailers buy on credit and pay in the following quarter. VW is considering debt factoring to improve short-term cash flow.
Table 8: Forecasted data for VW for quarter 2, figures in USD
Item | Amount (USD) |
|---|---|
Opening cash balance on 1 April | 5000 |
Sales revenue in quarter 2 | 100000 |
Percentage of sales paid in cash during quarter 2 | 20% |
Percentage of sales on credit, payable in quarter 3 | 80% |
Cost of sales, paid during quarter 2 | 45000 |
Wages and rent, paid during quarter 2 | 25000 |
Existing payables due during quarter 2 | 12000 |
Percentage of quarter 2 credit invoices the factor will buy immediately | 70% |
Percentage of invoice value paid immediately by the factor | 90% |
Calculate VW’s forecast profit for quarter 2 before using debt factoring. Show all your working.
Calculate VW’s forecast closing cash balance for quarter 2 if it does not use debt factoring. Show all your working.
Calculate the immediate cash received from debt factoring and VW’s revised quarter 2 closing cash balance. Show all your working.
Tidal Threads (TT) is a small online business that prints customized sports shirts for schools. TT is profitable, but many schools pay one month after delivery. TT’s owner, Amira, is considering buying a digital embroidery machine in September to increase future sales and improve profit margins. The machine would be paid for immediately in cash. TT has an overdraft limit of $4000.
Table 1: TT’s cash-flow forecast before buying the embroidery machine, figures in USD
| Item | September | October | November |
|---|---|---|---|
| Opening cash balance | 6000 | to be calculated | to be calculated |
| Cash sales | 9000 | 11000 | 14000 |
| Cash received from previous month’s credit sales | 7000 | 8000 | 9000 |
| Wages | 7000 | 7500 | 8000 |
| Fabric and printing materials | 6000 | 7000 | 8500 |
| Rent and utilities | 3000 | 3000 | 3000 |
| Existing loan repayment | 1000 | 1000 | 1000 |
Table 2: Forecast effects if TT buys the embroidery machine in September
| Item | September | October | November |
|---|---|---|---|
| Cash payment for machine | 12000 | 0 | 0 |
| Additional cash sales from embroidery | 0 | 3000 | 5000 |
| Additional materials and maintenance cash outflows | 0 | 1200 | 1600 |
| Additional forecast profit from embroidery | 0 | 1800 | 3400 |
Item | Sep (USD) | Oct (USD) | Nov (USD) |
|---|---|---|---|
Open bal. before machine | 6000 | 5000 | 5500 |
Close bal. before machine | 5000 | 5500 | 8000 |
Machine payment | 12000 | 0 | 0 |
Extra sales from embroidery | 0 | 3000 | 5000 |
Extra materials & maint. | 0 | 1200 | 1600 |
Extra forecast profit | 0 | 1800 | 3400 |
Cash received from previous month's credit sales | 7000 | 8000 | 9000 |
Existing loan repayment | 1000 | 1000 | 1000 |
Overdraft limit | 4000 | 4000 | 4000 |
Evaluate whether TT should buy the embroidery machine in September.
HelioPack (HP) manufactures reusable insulated boxes for restaurants that deliver meals. HP’s products are popular because many restaurants want to reduce single-use packaging. HP’s profit margin is expected to improve as output increases. However, most restaurant chains pay 90 days after delivery, while HP’s suppliers of recycled materials demand payment before delivery because HP is still a relatively new business.
HP’s finance director has prepared a cash-flow forecast showing that HP is likely to have negative closing balances during the next quarter. HP is considering three strategies to deal with the cash-flow problem:
The marketing director is worried that some restaurants are price sensitive and may choose cheaper packaging suppliers. The operations manager is worried that reducing inventory could delay orders and damage HP’s reputation for reliable delivery.
Month | Opening balance ($000) | Cash inflows ($000) | Cash outflows ($000) | Net cash flow ($000) | Closing balance ($000) |
|---|---|---|---|---|---|
Month 1 | 30 | 70 | 120 | -50 | -20 |
Month 2 | -20 | 85 | 130 | -45 | -65 |
Month 3 | -65 | 100 | 140 | -40 | -105 |
Recommend the most suitable strategy for HP to manage its forecast cash-flow problem while supporting growth.
SunTrail Kayaks (SK) rents kayaks and offers guided tours on a large lake. Demand is seasonal: April is usually busy, but February and March are quieter. SK must pay insurance and staff costs before the main tourist season begins. The owner, Dev, is worried about a cash shortage and is considering several strategies.
Table 1: SK’s cash-flow forecast before any strategy, figures in USD
| Item | February | March | April |
|---|---|---|---|
| Opening cash balance | 2500 | to be calculated | to be calculated |
| Cash inflows from customers | 10000 | 12000 | 26000 |
| Insurance payment | 6000 | 0 | 0 |
| Staff wages | 7000 | 7500 | 9000 |
| Maintenance of kayaks | 4000 | 3000 | 5000 |
| Rent and utilities | 2500 | 2500 | 2500 |
| Marketing costs | 1500 | 2500 | 3500 |
Table 2: Cash-flow strategies being considered by SK
| Strategy | Forecast effect |
|---|---|
| A: Arrange a short-term overdraft | Overdraft limit of $8000; interest of $300 paid in April |
| B: Require customers to pay deposits earlier | March cash inflows increase by $5000; April cash inflows decrease by $2000 because some customers cancel |
| C: Reduce March marketing | March outflows decrease by $1500; April cash inflows are forecast to decrease by $4000 |
Item | February (USD) | March (USD) | April (USD) | Strategy note |
|---|---|---|---|---|
Opening cash balance | 2,500 | -8,500 | -12,000 | |
Cash inflows (total) | 10,000 | 12,000 | 26,000 | |
Cash outflows (total) | 21,000 | 15,500 | 20,000 | |
Net cash flow | -11,000 | -3,500 | 6,000 | |
Closing cash balance | -8,500 | -12,000 | -6,000 | |
Strategy A: overdraft | Limit 8,000; Apr interest 300 | |||
Strategy B: earlier deposits | Mar inflow +5,000; Apr inflow -2,000 | |||
Strategy C: cut marketing | Mar outflows -1,500; Apr inflow -4,000 |
Discuss which strategy, or combination of strategies, SK should use to deal with its cash-flow problem.
Read the resources and answer the questions that follow.
CLK prepares healthy lunches using surplus food and delivers them by electric cargo bicycle to offices. It operates as a social enterprise: paid corporate lunch contracts subsidize free meals and cycle-maintenance training for unemployed young people. Most corporate customers pay 60 days after delivery, but CLK pays riders, trainers and food suppliers weekly. The director says that CLK is forecast to make a profit this year, but she is worried about liquidity.
CLK’s forecast for the next six months shows rising sales revenue and a forecast annual operating profit. However, closing cash balances are expected to become negative in the months before large credit customers pay. The forecast also includes a planned cash purchase of refrigerated storage to reduce food waste.
“The issue is not whether the lunch contracts are popular. It is whether cash arrives in time to pay wages, insurance and bicycle maintenance.”
CLK has 84 000 followers across social-media platforms after a video about its free community meals was shared by local schools and cycling groups.
Item | M1 / £000 | M2 / £000 | M3 / £000 | M4 / £000 | M5 / £000 | M6 / £000 |
|---|---|---|---|---|---|---|
Opening balance | 15 | 6 | -22 | -12 | 1 | 16 |
Corporate receipts | 0 | 0 | 20 | 24 | 28 | 32 |
Donation receipts | 3 | 2 | 4 | 3 | 3 | 2 |
Total inflows | 3 | 2 | 24 | 27 | 31 | 34 |
Wages & training | 7 | 7 | 8 | 8 | 9 | 9 |
Supplier payments | 4 | 4 | 5 | 5 | 6 | 6 |
Insurance & maintenance | 1 | 1 | 1 | 1 | 1 | 1 |
Storage purchase | 0 | 18 | 0 | 0 | 0 | 0 |
Total outflows | 12 | 30 | 14 | 14 | 16 | 16 |
Net cash flow | -9 | -28 | 10 | 13 | 15 | 18 |
Closing balance | 6 | -22 | -12 | 1 | 16 | 34 |
Using Resource 1 and Resource 3, describe one difference between profit and cash flow for CLK.
Using Resource 2 and other relevant information from the stimulus, explain two possible cash-flow problems facing CLK.
Using all the resources provided and your knowledge of business management tools and theories, recommend a plan of action for CLK to improve cash flow while protecting its social mission.
Read the resources and answer the questions that follow.
HHL provides commercial laundry services to hotels and restaurants while employing and training adults who have recently experienced homelessness. HHL pays wages every two weeks and buys eco-friendly detergent in advance. Many hotel customers pay invoices after 45 days. Demand is seasonal: cash receipts are high during the tourist season but fall sharply in the off-season. HHL’s board wants to avoid measures that would reduce trainees’ hours unless there is no alternative.
HHL’s forecast for the next four months shows a large off-season cash shortage. Three possible responses are being considered: requiring hotel deposits, negotiating longer payment terms with the detergent supplier, and arranging a short-term overdraft.
“Our purpose is to provide stable employment and training. A cash-flow solution that damages trust with hotels, suppliers or trainees could weaken the whole enterprise.”
HHL has 23 500 followers on a local community platform; a recent post about trainees gaining permanent work received the highest engagement rate of the year.
Item | M1 ($) | M2 ($) | M3 ($) | M4 ($) | Note |
|---|---|---|---|---|---|
Opening cash balance | 5,000 | 21,000 | 33,000 | 7,000 | Starting cash |
Cash receipts | 60,000 | 56,000 | 20,000 | 16,000 | Tourist season off-season; 45-day credit |
Wages | -24,000 | -24,000 | -24,000 | -24,000 | Fortnightly pay |
Detergent purchases | -11,000 | -11,000 | -12,000 | -12,000 | Bought in advance |
Other operating outflows | -9,000 | -9,000 | -10,000 | -10,000 | Rent, utilities, transport |
Net cash flow | 16,000 | 12,000 | -26,000 | -30,000 | Shortfall in months 3-4 |
Closing balance | 21,000 | 33,000 | 7,000 | -23,000 | Negative by month 4 |
Require hotel deposits | — | — | — | — | Cash inflow earlier |
Negotiate longer supplier terms | — | — | — | — | Delay detergent payment |
Arrange short-term overdraft | — | — | — | — | Temporary finance for gap |
Using Resource 2, outline two strategies HHL could use to deal with its cash-flow problem.
Using Resource 1 and Resource 3, explain two stakeholder issues HHL should consider when choosing a cash-flow strategy.
Using all the resources provided and your knowledge of business management tools and theories, recommend a plan of action for HHL to overcome the forecast cash-flow shortage.
OrthoMend Supplies (OMS) manufactures specialist braces and supports for private physiotherapy clinics. OMS is forecast to make a profit in quarter 3, but most clinics buy on credit and pay after 60 days. OMS must pay for materials and wages before receiving much of the cash from sales. The finance director is concerned about insolvency risk and has identified three possible strategies.
Table 1: OMS forecast for quarter 3 before any strategy, figures in USD
| Item | Amount |
|---|---|
| Opening cash balance on 1 July | 9000 |
| Sales revenue in quarter 3 | 180000 |
| Percentage of sales received in cash during quarter 3 | 35% |
| Percentage of sales on credit, payable in quarter 4 | 65% |
| Cash received in quarter 3 from quarter 2 credit sales | 42000 |
| Materials paid in quarter 3 | 78000 |
| Wages paid in quarter 3 | 52000 |
| Rent and utilities paid in quarter 3 | 15000 |
| Loan repayment and interest paid in quarter 3 | 12000 |
| Forecast net profit for quarter 3 | 21000 |
Table 2: Strategies being considered by OMS
| Strategy | Forecast effect in quarter 3 | Possible consequence |
|---|---|---|
| A: Use debt factoring for quarter 3 credit sales | Factor pays 85% of quarter 3 credit sales immediately | OMS loses 15% of the value of factored debts and some clinics may dislike being contacted by the factor |
| B: Offer a 4% early-payment discount to clinics | 40% of Q3 credit sales ($117,000), equal to $46,800, is received in quarter 3 instead of quarter 4 | Profit falls because of the discount |
| C: Negotiate delayed payment to materials suppliers | Quarter 3 cash outflows fall by $25000 | Suppliers may charge higher prices or reduce future trade credit |
Section | Item / strategy | Value (USD or %) | Notes |
|---|---|---|---|
Forecast Q3 before any strategy | Opening cash balance on 1 July | $9,000 | Cash available at the start of quarter 3 |
Forecast Q3 before any strategy | Sales revenue in quarter 3 | $180,000 | Total quarter 3 sales |
Forecast Q3 before any strategy | Received in cash during quarter 3 | 35% | Percentage of quarter 3 sales received immediately |
Forecast Q3 before any strategy | On credit, payable in quarter 4 | 65% | Percentage of quarter 3 sales received in quarter 4 |
Forecast Q3 before any strategy | Cash received in quarter 3 from quarter 2 credit sales | $42,000 | Collection of earlier credit sales |
Forecast Q3 before any strategy | Materials paid in quarter 3 | $78,000 | Quarter 3 cash outflow |
Forecast Q3 before any strategy | Wages paid in quarter 3 | $52,000 | Quarter 3 cash outflow |
Forecast Q3 before any strategy | Rent and utilities paid in quarter 3 | $15,000 | Quarter 3 cash outflow |
Forecast Q3 before any strategy | Loan repayment and interest paid in quarter 3 | $12,000 | Quarter 3 cash outflow |
Forecast Q3 before any strategy | Forecast net profit for quarter 3 | $21,000 | Forecast accounting profit for the quarter |
Strategies being considered | A: Use debt factoring for quarter 3 credit sales | 85% | Factor pays 85% of quarter 3 credit sales immediately; OMS loses 15% of factored debts |
Strategies being considered | B: Offer a 4% early-payment discount | 40% of Q3 credit sales | Q3 credit sales are $117,000; 40% ($46,800) is received in Q3 instead of Q4 |
Strategies being considered | C: Negotiate delayed payment to materials suppliers | $25,000 | Quarter 3 cash outflows fall by this amount; suppliers may charge higher prices or reduce future trade credit |
Recommend the most suitable strategy for OMS to deal with its cash-flow problem.
Read the resources and answer the questions that follow.
RGS refurbishes used solar lamps and sells them at low prices to families without reliable electricity. Surpluses fund free lamp repairs for rural schools. RGS has been offered a discounted automated testing machine and a small electric van. The operations manager believes the investment would increase output and reduce faulty returns within one year. The finance manager is concerned that paying for both assets now could create a cash-flow shortage before higher sales are received.
RGS’s forecast compares the next nine months if it buys the testing machine and van immediately with an alternative of leasing the van and delaying the testing machine purchase. The forecast shows the timing of asset payments, expected cash receipts from lamp sales, expected grant receipts and monthly closing cash balances.
“The free repair service matters because a broken lamp can stop evening classes. But if RGS cannot buy replacement parts on time, the service will fail.”
A campaign showing pupils studying under repaired lamps reached 410 000 views in one week and generated many comments asking how to donate.
Scenario | Month | Sales cash receipts / £000 | Grant cash receipts / £000 | Asset/lease outflow / £000 | Operating cash outflow / £000 | Net cash flow / £000 | Closing cash / £000 |
|---|---|---|---|---|---|---|---|
Buy now | Opening | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 30.0 |
Buy now | M1 | 16.0 | 0.0 | 40.0 | 14.0 | -38.0 | -8.0 |
Buy now | M2 | 17.0 | 10.0 | 0.0 | 14.0 | 13.0 | 5.0 |
Buy now | M3 | 18.0 | 0.0 | 0.0 | 14.0 | 4.0 | 9.0 |
Buy now | M4 | 24.0 | 0.0 | 0.0 | 14.0 | 10.0 | 19.0 |
Buy now | M5 | 24.0 | 0.0 | 0.0 | 14.0 | 10.0 | 29.0 |
Buy now | M6 | 24.0 | 5.0 | 0.0 | 14.0 | 15.0 | 44.0 |
Buy now | M7 | 25.0 | 0.0 | 0.0 | 14.0 | 11.0 | 55.0 |
Buy now | M8 | 25.0 | 0.0 | 0.0 | 14.0 | 11.0 | 66.0 |
Buy now | M9 | 25.0 | 0.0 | 0.0 | 14.0 | 11.0 | 77.0 |
Lease/delay | Opening | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 30.0 |
Lease/delay | M1 | 16.0 | 0.0 | 1.5 | 14.0 | 0.5 | 30.5 |
Lease/delay | M2 | 17.0 | 10.0 | 1.5 | 14.0 | 11.5 | 42.0 |
Lease/delay | M3 | 18.0 | 0.0 | 1.5 | 14.0 | 2.5 | 44.5 |
Lease/delay | M4 | 18.0 | 0.0 | 1.5 | 14.0 | 2.5 | 47.0 |
Lease/delay | M5 | 18.0 | 0.0 | 1.5 | 14.0 | 2.5 | 49.5 |
Lease/delay | M6 | 18.0 | 5.0 | 29.5 | 14.0 | -20.5 | 29.0 |
Lease/delay | M7 | 24.0 | 0.0 | 1.5 | 14.0 | 8.5 | 37.5 |
Lease/delay | M8 | 24.0 | 0.0 | 1.5 | 14.0 | 8.5 | 46.0 |
Lease/delay | M9 | 24.0 | 0.0 | 1.5 | 14.0 | 8.5 | 54.5 |
Using Resource 1, outline two ways in which investment can affect cash flow for RGS.
Using Resource 2 and other relevant information from the stimulus, analyse the relationship between investment, profit and cash flow for RGS.
Using all the resources provided and your knowledge of business management tools and theories, recommend a plan of action for RGS’s proposed investment.