QUESTION ONE Jogena Company Ltd. is being considered by Adwen Na Nsa Community Bank for a credit facility to enable the company add on to its current line of business. As a pre-requisite the company needs to provide a projected cash budget statement for the period January 2012 to June 2012. The information below is provided. Projected Sales Are As Follows: Sales (GHC'000) Month November 2011 150 December 2011 160 January 2012 February 2012 180 195 March 2012 210 April 2012 May 2012 220 250 June 2012 280 July 2012 280 Of the company's sales 40% are for cash and 60% are on credit. Out of the credit sales 50% is paid in the month immediately after the sales and the other half is paid in the second month after the sales. Staff remunerations for a particular month are 45% of the previous month's gross sales figure. These are paid for in cash and in the month which they relate to. Material costs are 20% of the relative month's sales. Total Non-Current Assets at cost is gh¢ 200.0M with expected life span of 20 years. The company has renovated some extra space at the factory which it rents out at ghc200,000 monthly, although it continues to pay its landlord at the same old rate of gh¢150,000 per month. The Rent income is received 2 months in arrears. Other overhead expenses are gh¢20,000 monthly. Advance Corporate Tax of GHC48,000 and interim dividends of ghc66,000 will be respectively paid in March And April 2012. Cash at the end of December 2011 Is GHC100,000 and the monthly minimum cash balance is ghc300,000.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Prepare A Projected Cash Budget Statement for the period January to June 2012

QUESTION ONE
Jogena Company Ltd. is being considered by Adwen Na Nsa Community Bank for a credit facility
to enable the company add on to its current line of business.
As a pre-requisite the company needs to provide a projected cash budget statement for the
period January 2012 to June 2012. The information below is provided.
Projected Sales Are As Follows:
Sales (GHC'000)
Month
November 2011
150
December 2011
160
January 2012
February 2012
180
195
March 2012
210
April 2012
May 2012
220
250
June 2012
280
July 2012
280
Of the company's sales 40% are for cash and 60% are on credit. Out of the credit sales 50% is
paid in the month immediately after the sales and the other half is paid in the second month
after the sales.
Staff remunerations for a particular month are 45% of the previous month's gross sales figure.
These are paid for in cash and in the month which they relate to. Material costs are 20% of the
relative month's sales.
Total Non-Current Assets at cost is gh¢ 200.0M with expected life span of 20 years. The
company has renovated some extra space at the factory which it rents out at gh¢200,000
monthly, although it continues to pay its landlord at the same old rate of gh¢150,000 per
month. The Rent income is received 2 months in arrears.
Other overhead expenses are gh¢20,000 monthly. Advance Corporate Tax of GHC48,000 and
interim dividends of ghc66,000 will be respectively paid in March And April 2012.
Cash at the end of December 2011 Is GHC100,000 and the monthly minimum cash balance is
ghc300,000.
33
Transcribed Image Text:QUESTION ONE Jogena Company Ltd. is being considered by Adwen Na Nsa Community Bank for a credit facility to enable the company add on to its current line of business. As a pre-requisite the company needs to provide a projected cash budget statement for the period January 2012 to June 2012. The information below is provided. Projected Sales Are As Follows: Sales (GHC'000) Month November 2011 150 December 2011 160 January 2012 February 2012 180 195 March 2012 210 April 2012 May 2012 220 250 June 2012 280 July 2012 280 Of the company's sales 40% are for cash and 60% are on credit. Out of the credit sales 50% is paid in the month immediately after the sales and the other half is paid in the second month after the sales. Staff remunerations for a particular month are 45% of the previous month's gross sales figure. These are paid for in cash and in the month which they relate to. Material costs are 20% of the relative month's sales. Total Non-Current Assets at cost is gh¢ 200.0M with expected life span of 20 years. The company has renovated some extra space at the factory which it rents out at gh¢200,000 monthly, although it continues to pay its landlord at the same old rate of gh¢150,000 per month. The Rent income is received 2 months in arrears. Other overhead expenses are gh¢20,000 monthly. Advance Corporate Tax of GHC48,000 and interim dividends of ghc66,000 will be respectively paid in March And April 2012. Cash at the end of December 2011 Is GHC100,000 and the monthly minimum cash balance is ghc300,000. 33
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education