Big City Courier

Objective

This paper sets out to investigate the existing cash flow problems faced by Big City Courier (BCC) and endeavors to propose feasible recommendations to ease the situation.

Trend Analysis

Before zooming in directly on the cash flows of BCC, it would be good to start off with a trend analysis on the firm and determine how well it has managed its operations. Firstly, BCC’s sales have increased by 296% year on year from 1995 to 1996. While taking into consideration that the sales figure for 1995 was based only on 8 months, the substantial increase in sales is nonetheless a positive improvement for the firm. More importantly, through the same period, the firm’s expenses have only increased by 193% year on year, thus indicating that sales are increasing at a faster rate than expenses which is good. Hence this led to the firm experiencing a positive net profit of $26,836 in 1996 as compared to the net loss of $17,789 in 1995.

Given that we are only given the first quarter income statement for 1997, it would be difficult to do any major trend comparison year over year. Nevertheless, sales for 1997 have maintained an increasing trend, increasing by 61%, from $24,330 in January 1997 to $39,114 in March 1997. BCC however posted a net loss of $2,451 in January 1997 but recovered subsequently to post a net profit of $4,408 and $6,326 in February and March 1997 respectively.

To better understand the situation in BCC, it would also be necessary to look at the breakdown of the percentage of expenses relative to sales. We find that the total expenses in 1995 for BCC was 123% that of its total sales and this contributed to the net loss for that period. Similarly, the firm experienced a net profit in 1996 because it managed to keep its total expenses to only 91% in relation to its total sales. As we were given a clearer breakdown of expenses for 1997, a common-sized income statement was thus prepared and presented below to reflect the proportion of expenses to sales for that period.

As seen from the table, BCC has been consistent in controlling its biggest expense, drivers’ commissions, keeping it at a consistent 63% every month. But it appears that BCC’s total expenses tend to fluctuate from the range of 84% to 110%. However, due to a lack of data especially for the years 1995 and 1996, it is hard to determine whether this fluctuation is a one time off event or a persistent problem. We can see that the main reason for high total expenses in January 1997 was due to the automobile repairs and expenses which accounted for 11% of total expenses where it was only 1% in each of the 2 subsequent months. There might be a need to explore the rationale behind this large automobile repairs expense for that period.

Moving on, the table above shows the trend statement for BCC’s balance sheet. As a balance sheet is a measure at a certain point in time, it would assumingly be acceptable to lump the quarterly figures in 1997 with the yearly figures of 1995 and 1996. From the table, it can be seen that BCC’s accounts receivable in March 1997 was 336% larger than they were in 1995, a substantial increase over the years. In contrast, BCC has not been active in increasing its investments in fixed assets over the years.

Join now!

It can also be seen that BCC has been increasing its debt structure over the years. The most alarming increase lies in its sales tax payable which is an astonishing 806% larger they were in 1995. This will definitely be of legitimate concern as BCC currently has no cash on hand and there might be difficulty in paying off this large amount of payables when they are due. Another concern is in the firm’s capital holding. The firm has been showing a decrease in capital over the years and while increasing its liabilities, it is evident that the overall ...

This is a preview of the whole essay