The following cash flow and costs projection is available for the last 6-months of 2022: Quarter...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following cash flow and costs projection is available for the last 6-months of 2022: Quarter 3 Quarter 4 Cash collection from customer RM35,500 RM37,500 Cash payment for supplier RM64,034 RM67,202 Direct labour costs RM16,110 RM16,965 Manufacturing overhead Selling and administrative expense RM106,432 RM106,508 RM9,630 RM9,750 Upon discussion with Mimi, you have drafted the following key cash transactions for your budgeting consideration: 1. The expected cash balance at the start of Quarter 3 is at RM300,000. 2. All direct labour costs, manufacturing overhead and selling and administrative expenses are expected to be paid in cash in the quarter incurred. 3. The machinery purchased at RM20,000 for the production of the Asian BBQ is expected to be paid as two-equal cash instalments in Quarter 3 and Quarter 4 respectively. 4. The company would like to maintain a minimum cash balance of RM100,000 every quarter. Any excess of cash will be used to repay borrowings and interests. Required: Show all workings on a Microsoft Excel spreadsheet. Marks are granted based on the correct answer, and, the relevant Excel cell-reference, formulae and/or functions used. Prepare the Cash Budget for the last 6-months of 2022. Show the ending cash balance for each quarter. The following cash flow and costs projection is available for the last 6-months of 2022: Quarter 3 Quarter 4 Cash collection from customer RM35,500 RM37,500 Cash payment for supplier RM64,034 RM67,202 Direct labour costs RM16,110 RM16,965 Manufacturing overhead Selling and administrative expense RM106,432 RM106,508 RM9,630 RM9,750 Upon discussion with Mimi, you have drafted the following key cash transactions for your budgeting consideration: 1. The expected cash balance at the start of Quarter 3 is at RM300,000. 2. All direct labour costs, manufacturing overhead and selling and administrative expenses are expected to be paid in cash in the quarter incurred. 3. The machinery purchased at RM20,000 for the production of the Asian BBQ is expected to be paid as two-equal cash instalments in Quarter 3 and Quarter 4 respectively. 4. The company would like to maintain a minimum cash balance of RM100,000 every quarter. Any excess of cash will be used to repay borrowings and interests. Required: Show all workings on a Microsoft Excel spreadsheet. Marks are granted based on the correct answer, and, the relevant Excel cell-reference, formulae and/or functions used. Prepare the Cash Budget for the last 6-months of 2022. Show the ending cash balance for each quarter.
Expert Answer:
Answer rating: 100% (QA)
Cash Budget For last 6 Months of 2022 Quarter Quarter Particulars 3 Opening Balance 300000 100... View the full answer
Related Book For
Engineering Economic Analysis
ISBN: 9780195168075
9th edition
Authors: Donald Newnan, Ted Eschanbach, Jerome Lavelle
Posted Date:
Students also viewed these accounting questions
-
The following cash flow transactions are said to be equivalent in terms of economic desirability at an interest rate of 12% compounded annually. Determine the unknown value A. 750 600 450 300 150 2...
-
(6) A storage tank of capacity 900 L is at temperature 30 C. Calculate the temperature of the tank after 2 hours, if the rate of charging from the collector is 100 W. Given that the rate of heat...
-
The following cash flow has no positive interstate. The project, which had a projected life of 5 years, was terminated early. Year Cash Flow 0...................................-$50...
-
A 4-ft-high, 3-ft-diameter cylindrical water tank whose top is open to the atmosphere is initially filled with water. Now the discharge plug near the bottom of the tank is pulled out, and a water jet...
-
What happens if a bankrupt lessee affirms the lease? What happens if the lease is rejected?
-
Mattel and Hasbro are the two biggest makers of games and toys in the world. Mattel sells nearly $6 billion of products each year while annual sales of Hasbro products exceed $4 billion. Compare the...
-
Which of the following is true regarding capital rationing decisions? a. Companies should always choose the investment with the shortest pay back period. b. Companies should always choose the...
-
From this case, identify: 1. The pressures, opportunities, and rationalizations that led James to commit his fraud. 2. The signs that could signal a possible fraud. 3. Controls or actions that could...
-
Problem 60: After deciding to buy a new mercedes benz c class sedan, you can either lease the car or purchase it on a three year loan. The car you wish to buy costs $35,000. The dealer has a special...
-
What Are Empirical/Research Articles? Describe the resource assigned to you including two examples of how this resource will support your successful completion of the capstone project?
-
what is the liquidity risk and how does it affect the bank ?
-
Why do you form a portfolio of assets? Does portfolio formation eliminate unsystematic risk? Explain
-
2. 'Assuming you have an existing portfolio which contains many risky assets, now you want to add a new risky asset to this portfolio, what properties/ features of this asset that is associated with...
-
What are the primary risks and vulnerabilities associated with the SWIFT network, as illustrated by high-profile cyber incidents, and what measures has SWIFT taken to enhance its security...
-
As of Jan. 2024, the 5-year Treasury was near 3.84% and the 10-year was near 3.87%. For comparison, in Jan. 2022 the 5-year Treasury was near 1.25%, and the 10 year was near 1.7%. Therefore, the...
-
How does SWIFT support the integration of emerging payment technologies and digital currencies within the traditional financial infrastructure, including the development of APIs, standards, and...
-
(5 points) Identify and explain an example of an ethical dilemma in the business field (you may choose one from the textbook, from real life, from a work of fiction). Part 2: (25 points) Expla
-
Study the pictures/images below. Obviously these was focus on LT sociology, anthropology and poltical science. Try to do some analysis by finding clues that are synonymous with the main concepts....
-
In Table 3-1 in the text, four plans were presented for the repayment of $5000 in 5 years with interest at 8%. Still another way to repay the $5000 would be to make four annual end-of-year payments...
-
Bill Jones's parents insisted that Bill buy himself a new sport shirt. Bill's father gave specific instructions, saying the shirt must be in "good taste, "that is, neither too wildly colored nor too...
-
Five mutually exclusive investment alternatives have been proposed. Based on benefit-cost ratio analysis, and a MARR of 15%, which alternative should be selected? Year A B CDE F 0$200 $125 $100 $125...
-
a. The market capitalization of a firm with 100 percent stock equity is $10,000,000. Assume $8,000,000 of .10 debt is substituted for stock (the debt is given to the shareholders). The tax rate is...
-
a. Assume a one year investment of $10,000 returns $10,900 at time 1. What is the return on $1,000 of equity if $9,000 of .05 debt is used? Assume zero taxes. b. What is the IRR (after tax) on $1,000...
-
In deciding whether to drop its electronics product line, Amazon.com would consider a. the costs it could save by dropping the product line b. the revenues it would lose from dropping the product...
Study smarter with the SolutionInn App