The directors of Kingston & Co. were concerned about the company's cash flow. They requested their...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The directors of Kingston & Co. were concerned about the company's cash flow. They requested their accountant to prepare a cash budget for the three months ending 30 June 2020. The expected purchases and sales for the first half of year 2020 are as follows: . . . Month January February March April May June Purchases (RM) 125,500 145,500 130,550 135,000 155,500 115,500 Sales (RM) 185,000 165,000 185,000 275,000 295,000 245,000 Credit sales accounted for 75 percent of the total sales, the remaining 25 percent are cash sales. 50 percent of the credit sales will be collected one month after the sales and 48 percent will be collected two months after sales. The balance 2 percent of the credit sales are never collected. The firm has an opportunity to receive RM1,500 as a royalty every month. 40 percent of the purchase price is paid in cash. 35 percent of purchase price will be paid one month later and the remaining balance within two months later. A tax payment of RM13,500 and interest payment of RM18,000 are due in June. No principal repayments or retirements are due during these months. The firm pays rent of RM8,000 per month. An administrative expense is budgeted at RM10,000 per month. A new equipment costing RM32,000 will be bought and paid in April. Cash dividends of RM3,500, RM4,000 and RM4,500 will be paid in April, May and June respectively. The firm forecasts that a total of RM12,000 bonus payment to employees in June. The firm has a beginning cash balance of RM35,000 in April and must maintain a minimum cash balance of RM50,000. Interest on accumulated loan is at 18 percent annual interest and paid in the following month. Prepare a cash budget for the months of April, May and June 2020 The directors of Kingston & Co. were concerned about the company's cash flow. They requested their accountant to prepare a cash budget for the three months ending 30 June 2020. The expected purchases and sales for the first half of year 2020 are as follows: . . . Month January February March April May June Purchases (RM) 125,500 145,500 130,550 135,000 155,500 115,500 Sales (RM) 185,000 165,000 185,000 275,000 295,000 245,000 Credit sales accounted for 75 percent of the total sales, the remaining 25 percent are cash sales. 50 percent of the credit sales will be collected one month after the sales and 48 percent will be collected two months after sales. The balance 2 percent of the credit sales are never collected. The firm has an opportunity to receive RM1,500 as a royalty every month. 40 percent of the purchase price is paid in cash. 35 percent of purchase price will be paid one month later and the remaining balance within two months later. A tax payment of RM13,500 and interest payment of RM18,000 are due in June. No principal repayments or retirements are due during these months. The firm pays rent of RM8,000 per month. An administrative expense is budgeted at RM10,000 per month. A new equipment costing RM32,000 will be bought and paid in April. Cash dividends of RM3,500, RM4,000 and RM4,500 will be paid in April, May and June respectively. The firm forecasts that a total of RM12,000 bonus payment to employees in June. The firm has a beginning cash balance of RM35,000 in April and must maintain a minimum cash balance of RM50,000. Interest on accumulated loan is at 18 percent annual interest and paid in the following month. Prepare a cash budget for the months of April, May and June 2020
Expert Answer:
Answer rating: 100% (QA)
In this case the cash budget for Kingston Co projects the anticipated cash receipts and cash disbursements for each monthApril May and June of the year 2020 It incorporates various factors such as sal... View the full answer
Related Book For
Accounting For Cambridge International AS And A Level
ISBN: 9780198399711
1st Edition
Authors: Jacqueline Halls Bryan, Peter Hailstone
Posted Date:
Students also viewed these accounting questions
-
Need help completing form 1120- schedule k 10-3 Assessment Problems i 2 Part 2 of 3 10 points Skipped eBook Print References ! Sales revenue Cost of goods sold Salary to owners Jack and Jill Employee...
-
Need help completing form 1120- schedule k Required information [The following information applies to the questions displayed below.] Jack and Jill are owners of UpAHill, an S Corporation. They own...
-
Schedule M1 of Form 1120 is used to reconcile financial net income with taxable income reported on the corporations income tax return as follows: net income per books + additions subtractions =...
-
Mango Designs began selling its custom furniture on June 1, 2020. At the end of the month, the special journals showed the following results. Other information you will need is as follows: ? Interest...
-
Compute the amount of cash and cash equivalents on Steen Wash Companys balance sheet if, on the balance sheet date, it has currency and coins on hand of $250, deposits in checking accounts of $1,500,...
-
The file contains the state cigarette tax ($) for each state as of December 31, 2009. a. Construct an ordered array. b. Plot a percentage histogram. c. What conclusions can you reach about the...
-
How many accounts are involved in recording the sale of merchandise on credit?
-
This problem continues the Draper Consulting, Inc., situation from Problem 15-35 of Chapter 15. Draper is going to manufacture billing software. During its first month of manufacturing, Draper...
-
Using your degree, you plan to make enough money so that you can retire in only 20 years. Then, you plan to head south with all of the other retirees to Naples, Florida. You have found a house that...
-
Based on the attached case details address the following in at least 1. External environment (threats and opportunities) 2. Internal capabilities 3. Recommended business-level strategy to follow Case...
-
public class Square{ int sideLength; public Square(int sidelength) { } public int getSideLength(){ return sideLength; } public static void main(String args[]) { Square s1= new Square (5);...
-
How is issuing additional stock of $5 billion to raise capital for major expansions for the company will affect the balance sheet, statement of cash flow, retained earnings and income statement? What...
-
Q9: Find the equation of the tangent line to the curve y=2x+3 at the point (2, 3). Q10: Find relative maxima and minima of the function y = x-4x-3x+2.
-
If you had a stray $100 million to invest in wind, would you prefer to invest in onshore wind, or offshore? Why.
-
Assume that, to help build your nest-egg, you made two deposits of $100, one on January 1, 2014, and one on July 1, 2014, in a savings account that paid 10 percent compounded semi-annually. On...
-
a) Find slope of curve y=2x b) Find Derivative of y=2x(x-3) c) If x = sint, y = cost, determine d) Find f(x)=2x+1 at x=1 dy dx
-
2. (25 points) For the pin connected crank-slider shown, all measurements are in inches. 0 is the input. Y a. Plot 03 vs. 0. Make sure all angles are in degrees. b. Plot the distance, , vs. 0, and...
-
Sheldon and Leonard had a million-dollar idea. In order to make it happen, they have to do special research first. Only Kripke can help them in this matter. But Kripke is known to be the first-class...
-
Preparing a trial balance Prepare a trial balance dated 30 September 2014 for the business owned by Kimberley Watson based on the answer to Question 1.
-
A sole trader did not keep proper books of account. The following information is available about 2014. What were the business's purchases for 2014? A. $166,000 B. $205,000 C. $214,000 D. $223,000...
-
Explain what these terms mean. a. Uncredited banking b. Standing order
-
In April 2023, HMRC issues a notice requiring an individual to submit a tax return for the year 2022-23. The return is submitted electronically to HMRC on 8 December 2023. (a) State the date by which...
-
Calculate the personal savings allowance available in 2023-24 to a taxpayer with taxable income for the year (i.e. net income less any available personal allowance) of: (a) 20,000 (b) 37,701 (c)...
-
Calculate the 2023-24 income tax liability of a non-Scottish taxpayer with taxable income (i.e. income remaining after deducting any available personal allowance) of: (a) 11,730 (b) 15,280 (c) 30,000...
Study smarter with the SolutionInn App