August (actual) September (actual) October (forecast) November (forecast) December (forecast) January(forecast) February (forecast) March (forecast) April (forecast) GHC 000 400,000 500,000 600,000 700,000 800,000 800,000 700,000 600,000 500,000. B. 25% of the grants are collected during the month of the grant, 50o ase collected in the month following the grant, and 25% ate collected on the second month following the grant. Payment of Local Purchase Order is issued to Afran Ltd. for supply of for C. cement and iron rods. The purchases are 50% of the capital grant and are paid by one month prior to the capital grant. Wages and salaries are 24% of the capital grants and are paid in the D. same month as the capital grant. E. SSF contribution of GHC 4.000.000 is paid each month. Additionally. Maintenance of Motor Vehicles costs of GHC 8,000,000 per month will be incurred for October and November, GHC 20,000,000 for December and January; and GHC 8,000,000 for February and March. F. Training and development expenses of GHC 10,000,000 each are expected to be paid in October and January. A capital expenditure of GHC 100,000,000 will occur in October and the Ministry has a Mortgage payment of GHC 5.000,000 due each of the six months. G. The cash balance at the end of September is GHC 125, 000,000 and the Ministry wants to maintain a minimum balance of GHC 60,000,000 at all times. The Ministry will borrow the amounts necessary to ensure that the minimum balance is achieved. If the cash balance is above the minimum and there is still a loan balance from the previous months, excess funds will be applied to the loan balance until it is eliminated.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%
Prepare a cash budget for the ministry for six months period ending 31st March
August (actual)
September (actual)
October (forecast)
November (forecast)
December (forecast)
January(forecast)
February (forecast)
March (forecast)
April (forecast)
GHC 000
400,000
500,000
600,000
700,000
800,000
800,000
700,000
600,000
500,000.
Transcribed Image Text:August (actual) September (actual) October (forecast) November (forecast) December (forecast) January(forecast) February (forecast) March (forecast) April (forecast) GHC 000 400,000 500,000 600,000 700,000 800,000 800,000 700,000 600,000 500,000.
B. 25% of the grants are collected during the month of the grant, 50o ase
collected in the month following the grant, and 25% ate collected on
the second month following the grant.
Payment of Local Purchase Order is issued to Afran Ltd. for supply of
for
C.
cement and iron rods. The purchases are 50% of the capital grant and
are paid by one month prior to the capital grant.
Wages and salaries are 24% of the capital grants and are paid in the
D.
same month as the capital grant.
E. SSF contribution of GHC 4.000.000 is paid each month. Additionally.
Maintenance of Motor Vehicles costs of GHC 8,000,000 per month
will be incurred for October and November, GHC 20,000,000 for
December and January; and GHC 8,000,000 for February and March.
F. Training and development expenses of GHC 10,000,000 each are
expected to be paid in October and January. A capital expenditure of
GHC 100,000,000 will occur in October and the Ministry has a
Mortgage payment of GHC 5.000,000 due each of the six months.
G. The cash balance at the end of September is GHC 125, 000,000 and
the Ministry wants to maintain a minimum balance of GHC
60,000,000 at all times. The Ministry will borrow the amounts
necessary to ensure that the minimum balance is achieved. If the cash
balance is above the minimum and there is still a loan balance from
the previous months, excess funds will be applied to the loan balance
until it is eliminated.
Transcribed Image Text:B. 25% of the grants are collected during the month of the grant, 50o ase collected in the month following the grant, and 25% ate collected on the second month following the grant. Payment of Local Purchase Order is issued to Afran Ltd. for supply of for C. cement and iron rods. The purchases are 50% of the capital grant and are paid by one month prior to the capital grant. Wages and salaries are 24% of the capital grants and are paid in the D. same month as the capital grant. E. SSF contribution of GHC 4.000.000 is paid each month. Additionally. Maintenance of Motor Vehicles costs of GHC 8,000,000 per month will be incurred for October and November, GHC 20,000,000 for December and January; and GHC 8,000,000 for February and March. F. Training and development expenses of GHC 10,000,000 each are expected to be paid in October and January. A capital expenditure of GHC 100,000,000 will occur in October and the Ministry has a Mortgage payment of GHC 5.000,000 due each of the six months. G. The cash balance at the end of September is GHC 125, 000,000 and the Ministry wants to maintain a minimum balance of GHC 60,000,000 at all times. The Ministry will borrow the amounts necessary to ensure that the minimum balance is achieved. If the cash balance is above the minimum and there is still a loan balance from the previous months, excess funds will be applied to the loan balance until it is eliminated.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cash Budget
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education