Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ITECH Technology is in a process of preparing a monthly cash budget for the upcoming 6- months starting from January to June. Below is the

image text in transcribed

ITECH Technology is in a process of preparing a monthly cash budget for the upcoming 6- months starting from January to June. Below is the projection of sales for ITECH Technology for 8-months of 2018 January February March June 200,000 350,000 300,000 450,000 500,000 400,000 April May The company's sales are highly seasonal peaking in the months of April and May. The purchase generally is equal 60 percent of sales, purchases are all made one month in advance of the anticipated sales. Ten percent of the payment to suppliers was made during the month of purchase, 60 percent in following month and the remaining 30 percent two months after the purchase. For example, for January purchases, 10 percent will be paid in January, 60 percent in February, and 30 percent in March. All sales are made on credit. 25 percent of the collections are made in the following one month after sales, and the remaining during the third month following sales. Besides these, ITECH has certain expenses that have to be paid on a monthly basis. Rent of warehouse is RM 20,000; the interest expense id RM 10,000; the salary is RM 5,000. ITECH company also expects to pay RM 25,000 at the end of March and RM 25,000 at the end of June as tax prepayments. ITECH tries to maintain a security balance, in cash, of RM 5,000. If this amount is below the figure mentioned, ITECH can borrow at 1 percent month Assuming ITECH will need to repay any accrual interest in June, create the cash budget for January-June 2017. The cash balance for January 1, 2017, is RM 45,000; the sales for November is RM 240.000, and in December the sales was RM 300,000. The expected sales in July are RM 350,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For Executives Managing For Value Creation

Authors: Gabriel Hawawini, Claude Viallet

6th Edition

1473749247, 9781473749245

More Books

Students also viewed these Finance questions

Question

What was the influence of the strength of the treatment?

Answered: 1 week ago