Prepare a cash budget for the next quarter

Assignment Help Financial Management

Reference no: EM131527440

Please answer in EXCEL..

(A) You have been asked to prepare a cash budget for the next quarter, January through March, for ABC Fashions Ltd, showing monthly cash inflows, cash outflows and monthly cash surplus/ deficit.

They have provided you with the following information:

Sales are expected to be: Rs.400,000 in January, Rs.400,000 in February, and Rs.600,000 in March.

50% of sales are in cash. 50% of Sales are on credit and money in received in the next month.

The estimated purchases are: Rs.380,000 in January, Rs360,000 in February, and Rs.450,000 in March.

Payments for purchases will be made after a lag of one month ie Dec purchases are paid in Jan.

Outstanding on account of purchases in December last are Rs.350,000.

The rent per month is Rs.10,000 and the misc office expenses per month is Rs.25,000.

Salaries and other expenses, payable in cash, are expected to be: Rs.25,000 in January, Rs.20,000 in February, and Rs.30,000 in March.

They plan to buy furniture worth Rs.40,000 on cash payment in January..

The current cash balance with ABC Ltd is Rs 30,000. They always want to keep Rs 30,000 as reserve with themselves to meet any contingency.

(B) Looking at cash budget above how much money should ABC borrow in Jan so that it can function smoothly

(C) How much cash would ABC Ltd have by end of March considering both reserve of Rs 30,000 and borrowings done in (B) above and net monthly cash surplus & deficit

(D) Suppose of March credit sale collections which were to be received in April - due to 1 big large customer going bankrupt 60% of credit sales of March will become bad and thus only 40% of credit sales of March will be collected in April. Suppose in April all other expenses are same as in March. No capital expenditure is being planned etc. And of course March purchases will be paid in April. What will be cash situation in April.

Reference no: EM131527440

Questions Cloud

Term paper-website migration project : Tony's Chips has recently been sold to a new independent company. The new company has hired you to manage a project that will move the old Website.

How important were regional differences in social aspects : How important were the regional differences in the social aspects of republicanism

Changes to the business continuity plan : Make a summary of the article and explain how the topic might impact an organization's cloud solution.

Early child development and services : What are some ways in which effective means of emotional expression is used to engage with a client experiencing a problem?

Prepare a cash budget for the next quarter : If the shop’s taxrate is 35 percent and its discount rate is 8 percent, should Massey buy and install the machine press? cash outflows and monthly cash surplus/

Identify it as an asset a liability or stockholders equity : For each account listed in Exercise, indicate whether its normal balance is a debit or a credit.

Can and wan for a university with three campuses : Implement a LAN, CAN and WAN for a University with three Campuses. The campus locations are Washington, DC, Vienna, VA and Phoenix, AZ.

What are your companys main products or services : Provide a brief overview of your company (one to two paragraphs at most). What industry is it in? What are its main products or services?

Balanced scorecard to improve efficiency : Evaluate how Apple® could use a balanced scorecard to improve efficiency.

User Account

All Pages