(a) Anusha Berhad's sales pattern for the first quarter 2021 and projected revenues are as follows:MonthJanFebMarAprMaySales120,000 160,000 170,000 210,000 200,000(RM)Additional information:i.Historically, Anusha Berhad's sales were on cash basis.Anusha purchase raw material two month before the sales month and paid in cash equal to 60 percent of itssales.ii.iii.Fixed monthly rent of RM11,000.iv.A depreciation expense is RM400 per month.V.Dividend of RM3,000 will be received at the end of each quarter.vi.Wages and salaries are estimated RM15,000 per month.vii.Anusha decide to repay RM40,000 of their loan on April.viii.Interest on accumulated loan is at 9 percent annual interest and paid in the following month.ix.balance of RM20,000 per month.Ending cash balance for the budget period is RM20,000 and it would Ilike to maintain minimum desiredPrepare a monthly cash budget for the first quarter 2021 for Anusha Berhad.

(a) Anusha Berhad's sales pattern for the first quarter 2021 and projected revenues are as follows: Month Jan Feb Mar Apr Мay Sales 120,000 160,000 170,000 210,000 200,000 (RM) Additional information: i. Historically, Anusha Berhad's sales were on cash basis. Anusha purchase raw material two month before the sales month and paid in cash equal to 60 percent of its sales. ii. iii. Fixed monthly rent of RM11,000. iv. A depreciation expense is RM400 per month. Dividend of RM3,000 will be received at the end of each quarter. v. vi. Wages and salaries are estimated RM15,000 per month. vii. Anusha decide to repay RM40,000 of their loan on April. viii. Interest on accumulated loan is at 9 percent annual interest and paid in the following month. Ending cash balance for the budget period is RM20,000 and it would like to maintain minimum desired ix. balance of RM20,000 per month. Prepare a monthly cash budget for the first quarter 2021 for Anusha Berhad.

(a) Anusha Berhad's sales pattern for the first quarter 2021 and projected revenues are as follows: Month Jan Feb Mar Apr Мay Sales 120,000 160,000 170,000 210,000 200,000 (RM) Additional information: i. Historically, Anusha Berhad's sales were on cash basis. Anusha purchase raw material two month before the sales month and paid in cash equal to 60 percent of its sales. ii. iii. Fixed monthly rent of RM11,000. iv. A depreciation expense is RM400 per month. Dividend of RM3,000 will be received at the end of each quarter. v. vi. Wages and salaries are estimated RM15,000 per month. vii. Anusha decide to repay RM40,000 of their loan on April. viii. Interest on accumulated loan is at 9 percent annual interest and paid in the following month. Ending cash balance for the budget period is RM20,000 and it would like to maintain minimum desired ix. balance of RM20,000 per month. Prepare a monthly cash budget for the first quarter 2021 for Anusha Berhad.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Preparing a Short-Term Cash Forecast The Lyon Corporation is a merchandising company. Prepare a short-term cash forecast for July of Year 6 following the format of Exhibit 9A.4. Selected financial data from Lyon Corporation as of July 1 of Year 6 are reproduced below ($ thousands): Additional Information: Gross profit equals 20% of cost of goods sold. Lyon purchases all inventory on the second day of the month and receives it the following week. Lyon pays 75% of payables within the month of purchase and the balance in the following month. Lyons pays all remaining expenses in cash.
Gillstrap Promotions has projected the following values for the next three months: January February March Sales $352,000 $379,000 $444,328 Purchases on Trade Credit $218,000 $240,000 $260,000 Cash Expenses $88,000 $91,000 $94,000 Taxes, interest, and dividends $18,000 $20,000 $41,000 Capital Expenditures $50,000 0 $25,000 All sales are credit sales with 40% collected in the month of sale, 50% collected the following month, and the remainder collected in the second month after the sale. Credit purchases are paid in 30 days and all other items require immediate payment. Compute the net cash inflow for March.
Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.
Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?
Walton Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet Walton expects sales in January year 1 to total $260,000 and to Increase 15 percent per month in February and March All sales are on account. Walton expects to collect 67 percen of accounts receivable in the month of sale, 21 percent in the month following the sale, and 12 percent in the second month following the sole Required a. Prepare a sales budget for the first quarter of year 1 b. Determine the amount of sales revenue Walton will report on the year 1 first quarterly pro forma Income statement. c. Prepare a cash receipts schedule for the first quarter of year 1 d. Determine the amount of accounts receivable as of March 31, your 1 Complete this question by entering your answers In Use tabs below. Required A Required B Required C Required D Prepare a cash receipts schedule for the first quarter of year (out road…
Two articles A and B are manufactured in a department. Sales for the year 2021 were planned as follows: Product 1st 2nd 3rd 4th Quarter Quarter Quarter Quarter (Units) (Units) (Units) (Units) Product 50,000 60,000 65,000 75,000 A Product 25,000 22,500 20,000 19,000 B Selling price were sh. 40 per unit for A and sh. 20 per unit for B respectively. Average sales return is 5 % of sales. What is the annual sales budget for the year 2021? Select one: Sh 11,730,000 O Sh 11,143,500 Sh 9,500,000 O Sh 10,750,000
Accounting Question
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 33 29 26 23 21 21 a. Fifty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $23 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.) b. Suppose that from the start of the year the company stretches payables by paying 50% after one month and 30% after two months. (The remainder continue to be paid cash on delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment. (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)
Top Sdn Bhd had cash of RM13,000 on hand together with trade debtors outstanding balance of RM55,000 as at January 1. During the year, the company expected the following sales to customers by quarter, with collection terms of 50% in cash and 50% in credit receivable in the next quarter: First Second Third Fourth Sales (RM) 110,000 245,000 122,400 149,600 Direct materials purchases in metric tons (MT) costing RM 50.00 per MT payable in the same quarter are as follows: First Second Third Fourth Direct Materials Purchases (MT) 1,300 1,500 1,100 1,000 The production budget showed the following unit production by quarter with an average labour wage rate of RM40.00 payable in the same quarter: First Second Third Fourth Units to be produced 1,500 2,000 1,700 1,500 Top Sdu Bhd planned to pay dividends of RM10,000 per quarter during the year. In July, a new equipment costing RM60,000 will be purchased. An additional cost of RM16,000 was planned for its installation during the fourth quarter.…
NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33
The table contains the Sales estimates for the next year. The Purchases are 55% of Sales. Purchases are paid in the following month. The administrative expenses of $11,550 are paid each month Tax expenses of $16,458 are paid in March, June, September, and December each year. Rent expenses of $47,735 are paid in June and December. What is the cash outflow for March? Month Sales $ Month Sales $ Jan 87,400 July 21,931 Feb 89,751 Aug 78,038 Mar 78,038 Sep 87,400 Apr 21,931 Oct 78,038 May 87,400 Nov 89,751 June 89,751 Dec 21,931
The following sales and purchases are expected over the Four-month period from December to March Purchases Sales December OMR 30000 OMR 26000 January OMR 25000 OMR 30000 February OMR 24000 OMR 24000 March OMR 26000 OMR 28000 Additional Information: 1. Wages are paid each month of OMR 2000, which are paid in month that they are incurred 2. 30% of the Sales are on credit - and we allow one-month credit period - and 70% of the sales for immediate settlement 3. 40% of the Purchases are on credit - and 1 month credit period - and 60% of the purchases are for immediate settlement 4. The balance of cash as at 1 January was OMR 9000 If the company is preparing a budget from January to March, what will be the Closing balance of cash on March ? Select one: a. OMR 7800 b. OMR 7200 c. OMR 5800