Prepare a cash budget for the next quarter

Assignment Help Finance Basics

Reference no: EM131935629

Question: (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: EM131935629

Questions Cloud

What is the cash flow from leasing relative to purchasing : Artisan's is considering leasing a new computer. The lease terms include five annual payments of $1,650 with the first payment occurring at the lease signing.

Develop spreadsheet model for the profit over next year : Draw an influence chart to help develop a spreadsheet model for the profit over the next year.

What types of competitive strategies are the most effective : If you were asked for some advice about how strategy can help a business develop and grow, what are the areas in which you would suggest that strategy.

What is the annual ocf for project : Rolston Music Company is considering the sale of a new sound board used in recording studios. If the tax rate is 30 percent, what is the annual OCF for project?

Prepare a cash budget for the next quarter : You have been asked to prepare a cash budget for the next quarter, January through March, for ABC Fashions Ltd, showing monthly cash inflows.

What is pretax cost of debt and aftertax cost of debt : What is the pretax cost of debt? What is the aftertax cost of debt? Which is more relevant, the pretax or the aftertax cost of debt?

Research the differences between excel and access : Research the differences between Excel and Access. Download an online article(s) that effectively explains the differences and/or the advantages to applications

How you would respond to the request at the meeting : You have been asked to make a short presentation at your company's annual capital budget meeting to present an analysis of the strengths and weaknesses.

What is the yield to maturity on each one : Ashly is considering the purchase of two bonds, each of which has a face value of $1,000. Bond A has a 6% coupon payable semi-annually with 10 years until.

User Account

All Pages