3.7: Cash Flow: Activity: Anubis
3.7: Cash Flow: Activity: Anubis
3.7: Cash Flow: Activity: Anubis
Read the case study information below and answer the questions that follow.
ANUBIS
Tom has forecasted the following monthly cash outflows for January through March 2018:
● Heating and lighting: $4000.
● Wages: $50 000.
● Packaging: $15 000.
● Delivery charges: 5 % of sales revenue.
● Cost of goods sold: $220 000.
Additional information:
● Opening balance on 1 January 2018: $8000.
● Sales revenue: $300 000 each month.
● Rent of $2000 paid quarterly: first payment in January 2018.
● Receipt of a tax refund in February 2018: $3000.
QUESTIONS: 10 MARKS, 30 MINUTES
1. Outline two appropriate external short-term sources of finance for Anubis other than loans
from family and friends.
[2 marks]
External and short-term sources of finance
Bank Overdraft
Trade credit _ delay payment bills
Debt- factoring - taking checks immediately but pay more later
Short term bank loan
2. Using the information above, prepare a fully labelled cash-flow forecast for Anubis from
January to March 2018.
[5 marks]
2018
Cash Received
Expenditure
General Operation
Rent 2000 - -
Product
3. Comment on the predicted cash flow for Anubis for 2018. [3 marks]
All in all, the cash flow forecast is not looking good for Anubis. Even though the forecast
covers the first three months of 2018, looking closely we can notice that the closing balance
worsens each month from 2000 to 1000 and flunked at -3000, which is considered a negative
in the month of March. Anubis faces lower gross profit due to the fact they have a lower
retail prices of phone cases than their wage costs which is quite high. With the problem that
the market is increasingly competitive, Anubis most likely would not be able to generate any
additional sales revenue to offset the lower gross profit margin. Due to all this, we can say
that the situation with Anubis is incredibly dire.