A Finance Department of Everlasting Company is required to prepare a cash budget for the second...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A Finance Department of Everlasting Company is required to prepare a cash budget for the second quarter of 2022. The following are several information and assumptions in preparing the cash budget Month February March April May June July Total Sales (RM) Total Purchases (RM) 75,000 25,000 80,000 90,000 85,000 95,000 92,000 28.000 35,000 26,000 37,000 28,000 a) The customers make cash payment for 30 percent of sales value in the month of sale and the balance is made through credit sales. From the balance 40 percent will be collected a month after the sales and 60 percent will be collected two months after the sales. b) Payments are paid 50 percent in the month of purchase; 30 percent will be paid one month after the purchase and the balance will be paid two months after the purchase c) The company makes a monthly payment of RM20,000 for wages and RM15,000 for building rental. d) Rental payment on machines and equipment is RM30,000, received at the end of each quarter and the depreciation value is RM4,000 per month. e) Other monthly commitments are: i) Selling and administrative expenses : RM5,000 ii) Insurance premium RM3,000 1) The company receives a dividend of RM20,000 for the first month of each quarter. g) Opening cash balance is RM15,000 and a minimum cash balance of RM20,000 must be maintained at all times. h) Interest rate of 12 percent per annum will be charged if the company secures a loan from a bank. A Finance Department of Everlasting Company is required to prepare a cash budget for the second quarter of 2022. The following are several information and assumptions in preparing the cash budget Month February March April May June July Total Sales (RM) Total Purchases (RM) 75,000 25,000 80,000 90,000 85,000 95,000 92,000 28.000 35,000 26,000 37,000 28,000 a) The customers make cash payment for 30 percent of sales value in the month of sale and the balance is made through credit sales. From the balance 40 percent will be collected a month after the sales and 60 percent will be collected two months after the sales. b) Payments are paid 50 percent in the month of purchase; 30 percent will be paid one month after the purchase and the balance will be paid two months after the purchase c) The company makes a monthly payment of RM20,000 for wages and RM15,000 for building rental. d) Rental payment on machines and equipment is RM30,000, received at the end of each quarter and the depreciation value is RM4,000 per month. e) Other monthly commitments are: i) Selling and administrative expenses : RM5,000 ii) Insurance premium RM3,000 1) The company receives a dividend of RM20,000 for the first month of each quarter. g) Opening cash balance is RM15,000 and a minimum cash balance of RM20,000 must be maintained at all times. h) Interest rate of 12 percent per annum will be charged if the company secures a loan from a bank.
Expert Answer:
Answer rating: 100% (QA)
February Sales 75000 Credit sales 75000 x 07 52500 Collections 30 of sales in m... View the full answer
Related Book For
Essentials of Business Statistics
ISBN: 978-0078020537
5th edition
Authors: Bruce Bowerman, Richard Connell, Emily Murphree, Burdeane Or
Posted Date:
Students also viewed these accounting questions
-
Formulate a linear programming model for Problem 34 in Chapter 1 and solve using the computer. How does this solution differ from the solution to Problem 34 in Chapter 1?
-
Formulate the general linear programming model for the project network for installing an order processing system shown in Figure 8.14 and solve it.
-
For the linear programming model for Southern Sporting Goods Company, formulated in Problem 7 and solved graphically in Problem 8: a. Determine the sensitivity ranges for the objective function...
-
can you complete this concept map that reviews some key ideas about species and speciation logy with Lab Connecting the Concepts: Species and Speciation oncepts: Species and Speciation oncept map...
-
How could a bank improve the customer experience by managing customer touch points?
-
Evaluate the limit and justify each step by 2r? + 1 3. lim (3x + 2.x x + 1) 4. lim -2 * + 6.r --2 5. lim (x - 4)(x' + 5x - 1) 6. lim (f + 1)'(t + 3) 1+ 3x I+ 4x2 + 31 7. lim 8. lim Vut + 3u + 6 --2...
-
In 2015, the city of San Francisco enacted an ordinance that required health warnings on advertisements for certain sugar-sweetened beverages (SSBs) that read: WARNING: Drinking beverages with added...
-
1. For many decades, Porsche pursued a focused differentiation strategy. Using a clear strategic profile as a focused differentiator, Porsche was very successful and very profitable. More recently,...
-
There are essentially two aspects of data management: data definition and data manipulation. Data definition is operationalized by way of data definition languages (DDL). Data manipulation undergoes...
-
C&C Properties is an S corporation that owns two rental real estate undertakings: Carrot Plaza and Cantaloupe Place. Both properties produce an annual $10,000 operating loss. C&Cs Schedule K...
-
There is a 22% chance that the amount of oll in a prospective tield is 7 million barrols and a 78% chance of 15 million barrels. If the actual amount of ol is 7 million barrels, the present value of...
-
Which is the correct default route mapping within MVC? a. O b. O C. Controller -> View -> Model Model -> Controller -> View Model -> View -> Controller Od. Controller -> Model -> View
-
can be interpreted as the breakeven financing rate that leads to a profitable project. A. Discounted payback period B. Average accounting return C. Internal rate of return D. Net present value
-
Example.org uses servers on-premise to host its user accounts and rented storag applications. It is an example for akshi. 2024 akshis O Public cloud Private O Hybnakoud.goley N-2024 Reset cloud...
-
The process by which managers establish goals and specify how these goals are to be attained is: a. part of budgeting b. planning c. strategic management d. management by objectives e. organizing
-
Accounting for Asset Retirement Obligations - Comprehensive Information Step 1: Recognition of Asset Retirement Obligations (ARO) Asset Retirement Obligations (ARO) represent legal obligations...
-
Identify barriers to the implementation of evidence-based practice. What are two ways to address this problem?
-
You deposit $10,000 in a savings account that earns 7.5% simple interest per year. What is the minimum number of years you must wait to double your balance? Suppose instead that you deposit the...
-
Model: y = 0 + 1 x 1 + 2 x 2 + 3 x 3 + Sample size: n = 30 Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9981 0.9961 0.9952 387.1598 16 ANOVA...
-
To compare three brands of computer keyboards, four data entry specialists were randomly selected. Each specialist used all three keyboards to enter the same kind of text material for 10 minutes, and...
-
An airlines data indicate that 50 percent of people who begin the online process of booking a flight never complete the process and pay for the flight. To reduce this percentage, the airline is...
-
Describe the distinctive characteristic of weighted-average computations in assigning costs to units completed and closing work in progress.
-
Refer to requirement 2 of Exercise4.11. Required Prepare summary journal entries for the use of direct materials and conversion costs. Also prepare a journal entry to transfer out the cost of goods...
-
Le Roi du Plastique Sarl has two processes extrusion and thermo-assembly. Consider the June 2022 data for physical units in the thermo-assembly process of Le Roi du Plastique: opening work in...
Study smarter with the SolutionInn App