Topic Six

Financial Planning and Forecasting

6.0 Introduction
 Financial planning, forecasting and budgeting are essential tools for managing a
company’s financial health and guiding strategic decision-making.
 They form a framework that enables businesses to make informed decisions, allocate
resources efficiently and achieve their financial and strategic objectives while
managing risks.

6.1 Financial Planning

Defined: The process of defining a company's financial goals and developing a roadmap
to achieve them. It involves aligning financial resources with the company's strategic
objectives.

Purpose: To provide a clear direction for financial activities.

To ensure the company remains solvent and financially stable.
To align financial resources with the broader corporate strategy.

Key Components:
i) Goal Setting - Establishing long-term and short-term financial objectives
(revenue growth, cost reduction or market expansion).
ii) Resource Allocation - Identifying how to allocate capital effectively among
projects, operations and investments.
iii) Risk Management - Identifying potential financial risks and developing strategies
to mitigate them.
iv) Scenario Analysis - Evaluating different business scenarios (economic downturn,
market growth) and their financial implications.

6.2 Financial Forecasting

Defined: A systematic process to estimate a company's future financial
performance based on historical data, market trends, strategic objectives
and assumptions about the company and external environment.

Purpose: To enable management anticipate F/performance and make informed

decisions.
Identifies potential funding needs or surpluses.
Supports strategic planning by providing data-driven insights.

Key Components:
i) Revenue Forecasting: Predicting future sales based on past trends, market
analysis and sales pipeline data.
ii) Expense Forecasting: Estimating future operating, capital and fixed costs.
iii) Profitability Forecasting: Anticipating net income based on expected revenues
and expenses.
iv) Cash Flow Forecasting: Estimating future inflows and outflows of cash to ensure
liquidity.
Techniques for Financial Planning and Forecasting:
 Qualitative Methods: Expert judgment, market research and scenario analysis.
 Quantitative Methods: Statistical models, trend analysis, and regression models.

6.3 Budgeting
Defined: The process of creating a detailed financial plan for allocating resources over
a specific period, typically a fiscal year. It involves setting spending limits,
revenue targets, and performance benchmarks.

Purpose: Providing a financial framework for achieving organizational goals.

Controlling costs and prevents overspending.
Facilitating coordination across departments and aligns their activities
with corporate objectives.

Key Components:
i) Operational Budget: Covers day-to-day expenses like salaries, utilities and
production costs.
ii) Capital Budget: Allocates funds for long-term investments (equipment,
infrastructure or acquisitions).
iii) Cash Budget: Tracks expected cash inflows and outflows to ensure liquidity.
iv) Master Budget: Combines all individual budgets into a comprehensive financial
plan.

Process:
1. Preparation: Gather historical data and input from departments.
2. Approval: Management reviews and approves the budget.
3. Monitoring: Track actual performance against the budget and adjust as needed.
4. Evaluation: Analyze variances to improve future budgeting.

Relationship Between Financial Planning, Forecasting and Budgeting

i) Financial Planning provides the big-picture of goals and strategies.
ii) Forecasting estimates future outcomes to inform planning and budgeting.
iii) Budgeting translates the plan and forecast into actionable, measurable financial
targets.

Example in Practice
A retail company may:
1. Plan to expand its market share by opening new stores and investing in e-
commerce over the next three years.
2. Forecast sales growth, considering historical sales, market trends and
competition.
3. Budget TZS10 million for store openings, TZS2 million for marketing and TZS1
million for technology upgrades in the upcoming fiscal year.

6.4 Steps in Financial Forecasting

 The following are the key steps involved financial forecasting:
1. Define Objectives and Scope
i) Determine the goal of the forecast (revenue, cash flow, expenses, profitability).
ii) Identify the time frame for the forecast (short-term, medium-term, or long-
term).
Example: A company may forecast monthly revenue for the next 12 months to
plan its cash flow.

2. Gather and Analyze Historical Data

i) Collect relevant financial data (income statements, balance sheets and cash flow
statements).
ii) Analyze trends, seasonal patterns and historical performance.
Example: Review past sales data to identify growth trends or cyclical patterns.

3. Identify Key Drivers and Assumptions

i) Determine the factors that influence financial performance, such as:
a. Revenue drivers (price, volume market demand).
b. Expense drivers (raw material costs, labor costs).
c. External factors (economic conditions, industry trends).
ii) Develop realistic assumptions based on market research and expert input.
Example: Assume a 5% increase in sales volume due to marketing campaigns.

4. Choose a Forecasting Method

Select a suitable forecasting technique:
a. Qualitative Methods: Use expert judgment, market analysis and scenario
planning when historical data is limited.
b. Quantitative Methods: Use statistical models, trend analysis, regression
analysis or time-series forecasting.
Example: Use time-series analysis to predict monthly sales based on past trends.

5. Develop Financial Models

i) Build a financial model that incorporates key drivers and assumptions.
ii) Typical models include:
a. Revenue Forecast Model: Projects sales based on price and volume
assumptions.
b. Expense Forecast Model: Estimates costs based on fixed and variable
expense patterns.
c. Cash Flow Model: Tracks cash inflows and outflows to ensure liquidity.
Example: Create a spreadsheet model linking revenue growth to marketing
expenses.

6. Generate the Forecast

Input the assumptions and data into the financial model to calculate forecasts for:
i) Revenue
ii) Expenses
iii) Profits
iv) Cash flows
 Example: Predict monthly revenue, operating costs and net profit for the next fiscal
year.

7. Validate and Test the Forecast

i) Review the forecast for accuracy and consistency.
ii) Conduct sensitivity analysis to evaluate how changes in key assumptions affect
the forecast.
Example: Test the impact of a 10% decline in market demand on revenue
projections.

8. Present and Communicate the Forecast

i) Share the forecast with stakeholders (management, investors) using clear charts,
graphs and summaries.
ii) Highlight key assumptions, potential risks and recommendations for action.
Example: Present a report showing expected revenue growth and potential cash
shortfalls.

9. Monitor and Update the Forecast

i) Regularly compare the forecast with actual performance to identify variances.
ii) Update the forecast as new data becomes available or conditions change.
Example: Revise the forecast mid-year if unexpected economic conditions arise.

6.5 Pro Forma Financial Statements Using the Percent-of-Sales Method

 Pro Forma Financial Statements are forward-looking statements that project a
company's financial position and performance for a specific future period.
 They are based on assumptions and estimates, often guided by historical data and
future expectations.
 The percent-of-sales method is a common approach to constructing pro forma
financial statements.
 It assumes that certain income statement and balance sheet items vary directly
with sales making it relatively straightforward to predict future financial
performance.
 It simplifies forecasting and is widely used, though its reliance on proportional
relationships may not always account for fixed costs or economies of scale.

6.5.1 Key Concepts in Percent-of-Sales Method

1. Sales as the Driver:
i) Sales are the primary driver of many financial items (cost of goods sold (COGS),
operating expenses and current assets).
ii) It assumes these items maintain a constant proportion of sales unless specified
otherwise.

2. Percentage Relationships:
Historical data is used to calculate each financial item's percentage relative to sales.
Example: If historical COGS is 60% of sales, this ratio is applied to projected sales in
the forecast period.
 3. Forecasting Changes
Fixed costs and other non-sales-dependent items (debt obligations, interest
expenses) are adjusted separately since they may not change with sales.

4. Balancing the Statements:

i) Adjustments are made to ensure the balance sheet balances (total assets =
total liabilities + equity).
ii) If there’s a shortfall, additional financing may be required, recorded as
external financing needed (EFN).

6.5.2 Steps in Preparing Pro Forma Financial Statements

1. Estimate Future Sales - Forecast sales for the desired period using historical
trends, growth rates, or market analysis.
2. Determine Historical Percentages - Calculate key items (COGS, operating
expenses, current assets, etc.) as a percentage of sales from past financial
statements.
3. Apply Percentages to Forecasted Sales - Use the historical percentages to
estimate future values for income statement and balance sheet items that vary
with sales.
4. Adjust Fixed Items - Update fixed expenses, long-term liabilities, and equity for
any known changes (planned debt repayments, new investments).
5. Reconcile the Balance Sheet - Ensure total assets equal total liabilities and
equity by adjusting retained earnings or adding external financing if needed.

Example Using Percent-of-Sales Method

1. Given the following historical Data (Base Year) for Alinda Investments whose
sales are projectec to grow by 10%:
Item Amount (TZS) % of Sales
Sales 1,000,000 100%
COGS 600,000 60%
Operating Expenses 200,000 20%
Current Assets 500,000 50%
Fixed Assets 300,000 30%
Liabilities 400,000 40%
Equity 400,000 40%
Prepare its Pro Forma Income Statement and Pro Forma Balance sheet
respectively.

2. GVM Company Ltd projects sales for the next year to be TZS1,000,000. Based on
the following historical data:
i) Cost of goods sold (COGS) is 60% of sales.
ii) Operating expenses are 20% of sales.
iii) The tax rate is 30%.
Prepare a Pro Forma Income Statement using the Percent-of-Sales method.
 3. Axels Bigirwa Company (ABC) expects a 20% increase in sales next year from
TZS 500,000 to TZS 600,000. Current assets and accounts payable are
directly proportional to sales. Given the following balance sheet
information:
Current Year Balance Sheet:
i) Current Assets: TZS 150,000
ii) Fixed Assets: TZS 200,000
iii) Accounts Payable: TZS 108,333
iv) Equity: TZS 250,000
Prepare a Pro Forma Balance Sheet for the next year
Key Considerations:
1. Fixed vs. Variable Costs: Separate items that do not vary with sales (rent) from
those that do (raw materials).
2. External Financing Needed (EFN): If projected liabilities and equity are
insufficient to fund projected assets, the EFN amount represents additional
capital required.
3. Assumptions: Clearly document assumptions used for growth rates, cost
percentages, and external influences.

6.6 CALCULATION OF EXTERNAL FUNDS NEEDED (EFN)

 The (EFN) is the additional financing a business requires to fund its operations or
growth when internally generated funds (retained earnings) and existing
liabilities are insufficient to cover the increase in assets.
 It is useful when a firm is forecasting growth in sales and projecting its future
F/needs.

Steps to Calculate EFN

1. Project Sales Growth - Forecast the expected sales increase.
2. Estimate Increase in Assets
i) Identify assets that will increase with sales (current assets - inventory or
accounts receivable).
ii) Calculate the increase using historical data (as a percentage of sales).
3. Estimate Increase in Liabilities:
i) Determine liabilities that grow with sales (accounts payable or accrued
expenses).
ii) Calculate the increase using historical percentages.
4. Determine Retained Earnings Contribution:
i) Calculate the expected net income based on the new sales level.
ii) Deduct dividends to estimate the portion of net income retained by the
business.
5. Calculate EFN:
Use the formula: EFN = Δ Assets − (Δ Liabilities +Retained Earnings)

Worked Examples Calculation of EFN

1. Given the following Historical Data of Bigirwa Co. Ltd:
Item Amount (TZS) % of Sales
 Sales 1,000,000 100%
Total Assets 800,000 80%
Total Liabilities 400,000 40%
Retained Earnings 100,000 10%
Assume net income is 10% of projected sales and the company pays 50% of net income
as dividends. Determine the EFN of the Co.

2. DEF Company has forecasted sales of TZS1,200,000 for next year. The current
year financial information includes:
i) Total sales: TZS 1,000,000
ii) Total Assets: TZS800,000, which are expected to grow proportionally
with sales.
iii) Total Liabilities: TZS300,000, which will grow proportionally with sales.
iv) Retained Earnings: TZS200,000.
v) Profit margin: 10%.
Determine the EFN if the company does not plan to issue new equity.

Key Assumptions:
i) The relationships between sales and assets/liabilities remain consistent.
ii) Dividends are paid at a fixed rate.
iii) Net income margin is stable.
Knowing the EFN, businesses can plan for financing needs (loans, equity or other funding
sources).

6.7 Interpretation of Results from Pro Forma Financial Statements

Pro forma financial statements provide a projected view of a company’s financial
performance and position based on assumptions about future sales, expenses, and
operational growth. Once the statements are prepared, their interpretation helps
decision-makers understand the potential impact of business strategies and make
informed choices.
Here’s how to interpret the results from pro forma financial statements:

1. Income Statement: Profitability Assessment

Key Points to Evaluate:
a) Revenue Growth:
i) Compare forecasted revenue with historical data.
ii) Assess whether the sales growth aligns with market potential or business
strategies.
Example: A projected 20% increase in revenue indicates optimism about
market expansion or increased demand.

b) Cost Efficiency:
i) Analyze the growth in expenses relative to revenue.
ii) Assess whether the cost of goods sold (COGS) and operating expenses are
proportional to sales or growing disproportionately.
Example: If COGS increases at a slower rate than sales, it may indicate
better efficiency or economies of scale.
c) Net Profit Margin:
i) Examine the projected profit margin to ensure profitability.
ii) A declining margin could signal rising costs or inefficiencies.

Insights:
i) A strong forecasted net income suggests robust profitability.
ii) An increase in operating costs without a proportional increase in revenue
may indicate the need for cost control.

2. Balance Sheet: Financial Position Key Points to Evaluate:

a) Asset Growth:
i) Compare the growth in total assets with the increase in sales.
ii) Assess whether the company’s asset base is sufficient to support
projected growth.
Example: A 20% increase in current assets alongside a 20% increase in
sales indicates alignment.
b) Liabilities and Equity:
i) Check the proportion of liabilities versus equity in financing asset growth.
ii) High reliance on liabilities may signal increasing financial risk.
c) Working Capital:
i) Evaluate changes in current assets and current liabilities to determine if
short-term liquidity is sufficient.
Example: An increase in accounts receivable suggests more sales on credit,
potentially impacting cash flow.

Interpretations:
 A balanced growth in assets and liabilities reflects financial stability.
 Excessive reliance on debt financing could indicate a higher financial risk.

3. Cash Flow Statement (if included) Key Points to Evaluate:

a) Operating Activities:
i) Ensure projected cash inflows from operations are sufficient to cover
outflows.
ii) A negative operating cash flow might require additional financing.
b) Investing and Financing Activities:
i) Evaluate major planned investments and how they will be financed.
ii) Example: A large capital expenditure may require external funding.

Interpretations:
 Positive cash flows signal good liquidity.
 Negative cash flows from operations could raise concerns about
sustainability.

4. External Financing Needed (EFN) Key Points to Evaluate:

a) Amount of EFN:
i) Assess the projected need for external funding to support growth.
 ii) A large EFN indicates a funding gap and necessitates identifying sources
of finance (debt, equity).
b) Sources of Financing:
i) Evaluate the cost and feasibility of raising additional funds.
ii) Example: If EFN is TZS20,000, management must decide whether to raise
funds through loans or equity issuance.

Interpretations:
 A low EFN suggests the business can grow with internally generated funds.
 A high EFN may indicate aggressive growth plans or inefficiencies in managing
assets and liabilities.

5. Overall Financial Health and Strategy Alignment

Key Points to Evaluate:
A. Feasibility:
i) Assess whether the projections are realistic and achievable based on
industry trends and historical performance.
ii) Unrealistic growth assumptions may lead to overly optimistic results.
B. Risk Management:
i) Identify potential risks (over-reliance on debt or cash flow shortfalls).
ii) Contingency planning may be required for pessimistic scenarios.
C. Alignment with Goals:
Check whether the pro forma results align with the company’s strategic goals
(expanding market share or increasing profitability).

Note: The interpretation of pro forma financial statements helps stakeholders to:
i) Evaluate profitability (via income statement),
ii) Assess financial stability (via balance sheet),
iii) Analyze cash flow adequacy (via cash flow statement),
iv) Identify funding gaps (EFN), and
v) Make informed decisions about investments, financing, and operational
strategies.

6.8 PREPARATION OF A CASH BUDGET

Cash budget
 A financial tool that estimates a company’s cash inflows and outflows over a
specific period, usually monthly or quarterly.
 Helps businesses monitor liquidity, plan for short-term financing needs and
avoid cash shortages.

Steps to Prepare a Cash Budget

1. Determine the Time Period - Define the period for the cash budget (monthly,
quarterly annually).
2. Estimate Cash Inflows - include all expected sources of cash:
i. Sales Revenue:
 a) Separate cash sales from credit sales.
b) Include collections from accounts receivable (based on payment
terms).
ii. Other Receipts - Loans, investments or miscellaneous income.

3. Estimate Cash Outflows - Include all expected cash payments:

i. Operating Expenses - Payments for raw materials, wages, rent, utilities,
and other operating costs.
ii. Capital Expenditures - Purchases of fixed assets like equipment or
property.
iii. Debt Payments - Loan repayments, interest payments, and dividend
payouts.
iv. Taxes - Include estimated taxes to be paid during the period.

4. Calculate Net Cash Flow - Subtract total cash outflows from total cash inflows
for each period:
 Net Cash Flow = Total Cash Inflows − Total Cash Outflows

5. Determine Beginning and Ending Cash Balances:

i) Add the net cash flow to the beginning cash balance to determine the
ending cash balance for the period
Ending Cash Balance = Beginning Cash Balance + Net Cash Flow
ii) Use the ending cash balance of one period as the beginning cash balance
for the next period.

6. Plan for Cash Deficits or Surpluses:

i) If a cash deficit is forecasted, plan for financing (e.g., loans, credit lines).
ii) If a surplus is forecasted, plan for investments or debt reduction.

Worked Examples of a Monthly Cash Budget

1. Boke Co. Limited has set the following Assumptions:
i) Sales are TZS 50,000 per month, 60% collected in the month of sale, 40% in
the following month.
ii) Other monthly income: TZS5,000.
iii) Monthly operating expenses: TZS30,000 (paid in cash).
iv) Equipment purchase: TZS10,000 (in Month 2).
v) Beginning cash balance: TZS15,000.

Required:
Prepare a monthly cash Budget for Boke Co. Ltd

Tips for Preparing an Effective Cash Budget

i) Be Realistic: Use accurate and reasonable estimates for inflows and
outflows.
ii) Consider Timing: Account for the delay in collections and payments.
iii) Plan for Contingencies: Include a buffer for unexpected expenses or income
shortfalls.
 iv) Monitor Regularly: Update the budget frequently to reflect changes in
financial conditions.
A well-prepared cash budget is essential for maintaining financial stability and
ensuring a business can meet its obligations while pursuing growth opportunities.

6.9 ESTABLISHMENT OF CASH SHORTAGE OR SURPLUS IN THE CASH BUDGET

 Identifying a cash surplus or shortage is critical to maintaining financial
stability.
 A surplus indicates excess cash that can be invested or used for other strategic
purposes,
 A shortage highlights the need for additional financing or cost management.

Steps to Determine Cash Shortage or Surplus

1. Calculate Net Cash Flow - Subtract total cash outflows from total cash inflows:
 Net Cash Flow = Total Cash Inflows − Total Cash Outflows

2. Update Cash Balances - Add the net cash flow to the beginning cash balance to
calculate the ending cash balance:
 Ending Cash Balance = Beginning Cash Balance + Net Cash Flow

3. Compare the Ending Cash Balance to the Desired Minimum Balance:

i) Establish a minimum cash balance threshold (e.g. TZS5,000) to ensure
sufficient liquidity.
ii) If the ending cash balance is below this threshold, a cash shortage exists.
iii) If the balance exceeds the threshold, it represents a surplus.

4. Adjust for Surplus or Shortage:

a) Surplus - Consider using the excess cash for investments, debt repayment,
or dividend payouts.
b) Shortage - Plan to cover the deficit using financing options such as loans,
equity issuance, or delaying non-essential expenditures.

Example of Cash Surplus or Shortage

1. Given the following info of Kajuna Expeditious:
i) Beginning cash balance: TZS10,000
ii) Minimum cash balance: TZS5,000
iii) Inflows and outflows as follows:
Cash Outflows
Month Cash Inflows (TZS)
(TZS)
1 30,000 25,000
2 20,000 30,000
3 15,000 25,000
Determine the Net Cash Flows, Ending Balances and interprete your answers

Sample Questions
 2. Ntake Company Co. Ltd expects the following cash inflows and outflows for the
next month:
i) Beginning cash balance: $5,000
ii) Cash inflows: $20,000
iii) Cash outflows: $18,000
iv) Minimum cash balance required: $7,000
Determine whether there is a cash surplus or shortage and the amount.

Addressing a Cash Shortage

1. Short-Term Solutions:
i) Draw on credit lines or overdraft facilities.
ii) Negotiate extended payment terms with suppliers.
iii) Delay non-essential capital expenditures.
2. Long-Term Solutions:
i) Improve cash collections (e.g., stricter credit policies).
ii) Increase revenue through pricing adjustments or sales initiatives.
iii) Reduce unnecessary operating expenses.

Utilizing a Cash Surplus

1. Reinvestment - Invest in profitable projects, marketing, or new equipment.
2. Debt Management -Pay off existing loans to reduce interest costs.
3. Shareholder Returns - Consider dividends or share buybacks to reward investors.

6.10 Short-Term Plans to Address Cash Shortage or Surplus

Managing cash shortages and surpluses effectively is crucial for maintaining liquidity
and ensuring the smooth operation of a business. The development of short-term
plans involves strategic financial actions tailored to cover deficits or utilize excess
funds efficiently.

1. Addressing a Cash Shortage

A cash shortage occurs when cash outflows exceed inflows, leading to a deficit. The
goal is to ensure liquidity without disrupting operations.

Short-Term Solutions for Cash Shortages

A. Increase Short-Term Borrowing:
i) Utilize credit lines or overdraft facilities.
ii) Arrange for short-term loans from financial institutions.
iii) It is a quick access to funds to meet immediate obligations.
B. Speed Up Accounts Receivable Collection:
i) Offer discounts for early payments (2% discount for payment within 10
days).
ii) Improve credit terms and tighten collection policies.
iii) Use invoice factoring to get immediate cash for accounts receivable.
C. Delay Non-Essential Expenditures:
i) Postpone discretionary spending, (marketing campaigns or capital
investments).
ii) Defer payment of non-critical expenses.
D. Negotiate Payment Terms with Suppliers:
i) Request extended payment terms to delay cash outflows.
ii) Collaborate with suppliers for flexible arrangements.
E. Liquidate Non-Essential Assets:
i) Sell unused or underperforming assets to generate cash.
ii) Leaseback arrangements for key assets like property or equipment.
F. Improve Inventory Management:
i) Reduce inventory levels by selling off excess stock.
ii) Adopt just-in-time (JIT) inventory practices to lower holding costs.

2. Addressing a Cash Surplus

A cash surplus occurs when cash inflows exceed outflows, resulting in excess funds.
The goal is to utilize the surplus effectively to maximize returns and strengthen the
company's financial position.

Short-Term Strategies for Cash Surpluses

A. Invest in Short-Term Marketable Securities
a) Invest surplus cash in highly liquid, low-risk instruments such as:
i) Treasury bills.
ii) Money market funds.
iii) Commercial paper.
b) Ensures idle cash generates returns while remaining accessible.
B. Pay Down High-Cost Debt:
i) Use surplus funds to repay loans or credit lines with high interest rates.
ii) Reduces interest expenses and improves net profitability.
C. Increase Inventory for Anticipated Demand:
i) Invest in additional inventory to prepare for seasonal spikes or increased
demand.
ii) Helps capitalize on future revenue opportunities.
D. Fund Strategic Initiatives:
i) Allocate surplus funds to short-term projects like marketing campaigns or
employee training programs.
ii) Supports growth and operational efficiency.
E. Distribute Dividends or Share Buybacks:
i) Return surplus funds to shareholders through dividend payments.
ii) Conduct share buybacks to improve shareholder value and reduce equity
dilution.
F. Build an Emergency Reserve:
i) Allocate surplus funds to an emergency or contingency fund.
ii) Enhances financial security for unforeseen events.

Examples of Short-Term Plans

Scenario: A company forecasts a cash deficit of TZS 20,000 due to delayed customer
payments.
Plan Negotiate extended payment terms with suppliers to free up
TZS10,000.
Offer a 2% discount for early payment, accelerating TZS15,000 in
 collections.
Use a TZS5,000 overdraft facility to close the remaining gap.

Scenario: A company projects a TZS50,000 surplus due to higher-than-

expected sales.
Plan: Invest TZS30,000 in short-term Treasury bills.
Allocate TZS10,000 to repay a portion of high-interest debt.
Use TZS10,000 for a targeted digital marketing campaign to boost
sales further.

Factors to Consider in Planning

1. Cost of Funds - Evaluate the cost of borrowing versus the return on surplus
investments.
2. Liquidity Requirements - Maintain adequate liquidity for unexpected expenses
or emergencies.
3. Alignment with Strategic Goals - Ensure that short-term plans complement long-
term objectives.
4. Risk Tolerance
- Choose low-risk instruments for surplus investment.
- Avoid high-risk actions during shortages.

6.11 INTERPRETING RESULTS FROM SHORT-TERM FINANCING PLANS

Once short-term financing plans are implemented to address cash shortages or
surpluses, their results should be carefully analyzed to determine their effectiveness.
This evaluation provides insight into the success of the strategies, highlights areas
for improvement, and supports better decision-making for future financial
management.

1. Evaluating Results for a Cash Shortage

When short-term plans are used to manage a cash shortage, the goal is to restore
liquidity without incurring excessive costs or disruptions.

Key Metrics and Indicators to Analyze:

A. Liquidity Improvement:
i) Example: The company’s cash balance before and after implementing
financing should show that obligations like payroll, supplier payments, and
operating expenses were met without delays.
ii) Interpretation: An increase in liquidity indicates the plan successfully
bridged the cash flow gap.
B. Cost of Financing:
i) Calculate the interest expense or fees associated with borrowing.
ii) Interpretation: If the cost of financing is within acceptable limits and did
not significantly reduce profitability, the plan is deemed efficient.

C. Impact on Creditworthiness:
i) Check whether the use of credit facilities or loans affected the company’s
credit rating.
 ii) Interpretation: Maintaining or improving the credit rating indicates prudent
use of financing.
D. Collections and Payment Timing:
i) Analyze whether accelerating collections or delaying payments disrupted
operations or supplier relationships.
ii) Interpretation: Minimal disruptions indicate the plan was executed
smoothly.

2. Evaluating Results for a Cash Surplus

When managing a cash surplus, the goal is to maximize returns or strategically utilize
excess funds without compromising liquidity.

Key Metrics and Indicators to Analyze:

A. Return on Investments:
i) Evaluate the returns generated from investing surplus funds in short-term
securities or marketable instruments.
ii) Interpretation: Higher returns than idle cash balances indicate successful
deployment of the surplus.
B. Debt Reduction:
i) Analyze the impact of surplus funds on interest savings if debt was repaid.
ii) Interpretation: A reduction in interest expense improves profitability and
financial health.
C. Strategic Growth:
i) Assess whether surplus funds allocated to projects like marketing
campaigns or inventory expansion led to measurable benefits (increased
sales or market share).
ii) Interpretation: Tangible growth outcomes confirm effective use of
surplus funds.
D. Shareholder Value:
i) If surplus funds were used for dividends or share buybacks, measure the
effect on shareholder satisfaction and stock price.
ii) Interpretation: Positive shareholder feedback or stock price appreciation
indicates success.

Example Interpretations
1. Addressing a Shortage
A Co. borrowed TZS20,000 at a 5% interest rate to cover cash flow gaps.

Result:
i) All obligations were met on time.
ii) Interest cost was TZS1,000, a manageable expense relative to the avoided
disruption.

Interpretation
The plan was effective in restoring liquidity without overburdening the
company.
2. Managing a Surplus
Company DG Invested TZS30,000 of surplus cash in a money market fund
yielding 4% annually.

Result:
i) Earned TZS1,200 in interest over the year.
ii) Maintained sufficient liquidity for unexpected expenses.

Interpretation:
The plan effectively utilized surplus funds to generate returns while
preserving liquidity.