Suria Borneo Sdn Bhd is attempting to estimate its needs for funds for the first quarter...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suria Borneo Sdn Bhd is attempting to estimate its needs for funds for the first quarter of the year 2021. The following information is provided. Actual Sales (2020) October November December a) b) c) d) e) f) RM120,000 January RM100,000 February RM110.000 March April Forecasted Sales (2021) RM120,000 RM130,000 20 percent of sales are collected in the month of sales, 50 percent one month following the sales and 30 percent second month following the sales. RM140.000 RM150,000 | Purchases of raw materials are equal to 60 percent of sales and are made one month before the anticipated sales. Payments for the purchases are made as follows: 50 percent in the month of purchase, 35 percent one month after purchase and 15 percent two months after purchase. A quarterly dividend of RM50,000 will be received in March. Other fixed expenses: Insurance Rent Depreciation RM4,000 RM5,000 RM10,000 Wages are 20 percent of the month's sales and are made in the month in which they incurred. Based on the above information, you are required to assist the company to prepare a cash budget for the first quarter of 2021. Determine whether the company requires any financing if the minimum cash balance is RM10,000. Suria Borneo Sdn Bhd is attempting to estimate its needs for funds for the first quarter of the year 2021. The following information is provided. Actual Sales (2020) October November December a) b) c) d) e) f) RM120,000 January RM100,000 February RM110.000 March April Forecasted Sales (2021) RM120,000 RM130,000 20 percent of sales are collected in the month of sales, 50 percent one month following the sales and 30 percent second month following the sales. RM140.000 RM150,000 | Purchases of raw materials are equal to 60 percent of sales and are made one month before the anticipated sales. Payments for the purchases are made as follows: 50 percent in the month of purchase, 35 percent one month after purchase and 15 percent two months after purchase. A quarterly dividend of RM50,000 will be received in March. Other fixed expenses: Insurance Rent Depreciation RM4,000 RM5,000 RM10,000 Wages are 20 percent of the month's sales and are made in the month in which they incurred. Based on the above information, you are required to assist the company to prepare a cash budget for the first quarter of 2021. Determine whether the company requires any financing if the minimum cash balance is RM10,000.
Expert Answer:
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
In its income statement for the first quarter of fiscal year 2018, The Gap, Inc., reported net sales of $3,783 million and cost of goods sold and occupancy expenses of $2,356 million, resulting in a...
-
Budgeted sales for the first quarter of the year for the Delta Company are as follows: Budgeted Sales January ........$400,000 February ....... 200,000 March......... 600,000 1. The Company normally...
-
A manufacturer has budgeted sales for the first quarter of the next year to be 30,000 units. The inventory in hand at the beginning of quarter is 5,000 units. The desired ending inventory is 10,000...
-
Bob Bristol just called to congratulate you on your excellent work on the various assignments at CII.He now wants you to do some capacity analysis for Meghan Willoughby, the Chief Purser. Meghan is...
-
Use the following information to prepare the July cash budget for Sanchez Co. It should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31. a....
-
Evaluate f( 3), f(0), and f(2) for the piecewise defined function. Then sketch the graph of the function. 3 f(x) 3 - x if x < 2 x if x 2x 2x 5 if x > 2
-
Identify three functions for an ATM system.
-
You are considering two independent projects, Project A and Project B. The initial cash outlay associated with Project A is $50,000 and the initial cash outlay associated with Project B is $70,000....
-
Oslo Company prepared the following contribution format income statement based on a sales volume of 1 , 0 0 0 units ( the relevant range of production is 5 0 0 units to 1 , 5 0 0 units ) : Sales $ 2...
-
The proposed rates were not in the range the CEO expected given the pricing analysis. The CEO has asked the pricing actuary to verify the total projected loss cost excluding potential large storm...
-
A tank contains 500 litres of water. A watering can which is 12.5 litres is filled eleven times from the tank to water a garden. How many litres of water is left in the tank?
-
Wade Retailers, a nationwide department store chain, currently processes all of its credit sales payments at its Chicago headquarters. The firm is considering the establishment of a lockbox...
-
On March 1, Year 1, a company issued 12% bonds, dated March 1, with a face amount of $720,000. . The bonds sold for $714,000 and mature on February 28, Year 21 (20 years). Interest is paid...
-
The market information: Current Stock Market Return 11.25% Current T-Bill Price $979.43 Historic T-Bill Average Return 2.80% Historic Stock Market Average Return 8.10% Stock Beta 1.54 What is the...
-
Last year, Hoopla Nets reported the simplified financial statements shown below (assuming no income taxes). The firm is forecasting a sales increase of 6 percent. Assets and expenses are proportional...
-
1. Your roommate asks to borrow $500 and agrees to pay it in 45 days with interest rate of 4%. How much interest will you earn? 2. The local school district you live in selling bonds for $2000 that...
-
Assume that, when there is no trade of the product, cotton is sold in the US domestic market for $0.84 per pound and $0.72 per pound on the world market. At these prices US supply is 9.6 billion...
-
You are a Loan Officer with an Investment Bank. Today you need to set your lending parameters. They are: LTV: 55% 10 Year T-Bill: TBD Rate Markup: 300 Basis Points Term: 30 Years Amortization: 30...
-
Certain item descriptions and amounts are missing from the monthly schedule of cost of goods manufactured and income statement of Maria Manufacturing Company. Fill in the blanks with the missing...
-
Columbia Enterprises reports the following information at December 31, 2016: Requirements 1. What is the actual manufacturing overhead of Columbia Enterprises? 2. What is the allocated manufacturing...
-
Prepare the balance sheet for Drought Design Studio as of December 31, 2016. The assets, liabilities, and equities of Drought Design Studio have the following balances at December 31, 2016. The...
-
Wallace and Hussain type estimators for the variance components of a one-way unbalanced panel data model. (a) Verify the \(E\left(\widehat{q}_{1} ight)\) and \(E\left(\widehat{q}_{2} ight)\)...
-
Using the Monte Carlo setup for the unbalanced one-way error component model considered by Baltagi and Chang (1994), compare the various estimators of the variance components and the regression...
-
Using the Harrison and Rubinfeld (1978) data published in Belsley, Kuh and Welsch (1980) and provided on the Springer website as Hedonic.xls, reproduce Table 9.1. Perform the Hausman test based on...
Study smarter with the SolutionInn App