Lantana Landscapes has provided the following Schedule of receipts from Accounts Receivable. All sales are on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lantana Landscapes has provided the following Schedule of receipts from Accounts Receivable. All sales are on credit and collected 50% in month of Sale, 30% in the month following the sale and the balance in the 2nd month following the sale. Credit Sales November 2021 December 2021 January 2022 February 2022 March 2022 Totals $200,000 $240,000 $288,000 $285,600 $250,000 Lantana Landscapes Schedule of Receipts from Accounts Receivable for Quarter ending 31 March 2022. Jan-20 $40,000 $72,000 $144,000 Jan-22 256,000 Lantana Landscapes has also provided the following additional information: Proceeds from sale of Bobcat Payment to suppliers Depreciation on Equipment. Payment of Wages Payment of December 2021 BAS Other Cash Purchases Cash Purchase of Excavator The Bank Balance at the end of December 2021 is expected to be $104,000. 52,000 17,000 50,000 12,000 150,000 Feb-20 $48,000 $86,400 $142,800 277,200 Feb-22 24,000 70,000 21,000 70,000 128,000 22,000 Mar-20 $57,600 $85,680 $125,000 268,280 Mar-22 96,000 21,000 70,000 14,000 Required: Prepare a cash budget on a monthly basis for Lantana Landscapes for the quarter ending March 2022. (14 Marks) Lantana Landscapes has provided the following Schedule of receipts from Accounts Receivable. All sales are on credit and collected 50% in month of Sale, 30% in the month following the sale and the balance in the 2nd month following the sale. Credit Sales November 2021 December 2021 January 2022 February 2022 March 2022 Totals $200,000 $240,000 $288,000 $285,600 $250,000 Lantana Landscapes Schedule of Receipts from Accounts Receivable for Quarter ending 31 March 2022. Jan-20 $40,000 $72,000 $144,000 Jan-22 256,000 Lantana Landscapes has also provided the following additional information: Proceeds from sale of Bobcat Payment to suppliers Depreciation on Equipment. Payment of Wages Payment of December 2021 BAS Other Cash Purchases Cash Purchase of Excavator The Bank Balance at the end of December 2021 is expected to be $104,000. 52,000 17,000 50,000 12,000 150,000 Feb-20 $48,000 $86,400 $142,800 277,200 Feb-22 24,000 70,000 21,000 70,000 128,000 22,000 Mar-20 $57,600 $85,680 $125,000 268,280 Mar-22 96,000 21,000 70,000 14,000 Required: Prepare a cash budget on a monthly basis for Lantana Landscapes for the quarter ending March 2022. (14 Marks)
Expert Answer:
Answer rating: 100% (QA)
A cash budget is a forecast of revenues and expenditures expected during a given period The purpose of preparing a cash budget is to determine the cas... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date:
Students also viewed these accounting questions
-
Information for 2016: 1. Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April: 3,500 units. The unit sales price is $50. All sales are on credit and collections are...
-
Define the following terms: Developed land Easement Improvement
-
Sandra Bowen is the practice manager for a smaller medical practice with two physicians and support. She started with the practice as a medical assistant and was promoted to practice manager a little...
-
If you can't find similar ratios to class-covered ones, use financial formulas to calculate them manually. Choose up to two of the following: Operating Margin EBITDA Margin Payout Ratio 3. Analysis...
-
In developing an EFE Matrix, would it be advantageous to arrange your opportunities according to the highest weight, and do likewise for your threats? Explain.
-
The transition metals form a class of compounds called metal carbonyls, an example of which is the tetrahedral complex Ni(CO) 4 . Given the following thermodynamic data (at 298 K): (a) Calculate the...
-
Defendant Monty J. Person began working for Garage Solutions, LLC, in March 2015. Three months into his employment, Person was sent by the owner of Garage Solutions, Mark Fontenot, to Rexburg, Idaho,...
-
Washington, Inc., makes three models of motorized carts for vacation resorts, X-10, X-20, and X-40. Washington manufactures the carts in two assembly departments: Department A and Department B. All...
-
which of these items are included in the calculation of an asset's adjusted basis? add costs necessary to prepare the asset for use in the business, start with the asset's original basis, subtract...
-
1. Name at least three ways that Shu could automate her asset management. Suggest at least one option for retirement savings, general savings, and general convenience. 2. What major factors should...
-
How did the newly formed Republic of Texas settle land claims? How did it deal with citizenship claims? How did these new laws impact already established communities living in Texas?
-
In the spot market, $ 1 is currently equal to 0 . 6 2 1 1 . Assume the expected inflation rate in the U . K . is 2 . 6 percent while it is 4 . 3 percent in the U . S . What is the expected exchange...
-
A thin metal structure is experiencing plane stress. It has Young's modulus 75.6 GPa and Poisson's ratio 0.32. The axial stress is 45.4 MPa and the hoop stress is 83.7 MPa. What is the axial strain...
-
Now having some knowledge of perfect competition and how/why it's generally experienced only in commodity markets, and that's not an absolute, discuss why the market for housing -though competitive-...
-
Low Crop Prices Drag Farm Towns Down with Them: Low wheat, corn, and soybean prices mean another bad year for many Midwest farmers. In response to the above newspaper headline, what government action...
-
Q1. Consider the domestic airline industry in Australia. Briefly describe and define the market structure. Provide arguments and suggestive evidence in support of your claims. Your discussion could...
-
Activity 2 ARITHMETIC SEQUENCE VS. GEOMETRIC SEQUENCE Directions; Write A if the given set is an example of arithmetic sequence and Gif the given example illustrates an example of geometric sequence....
-
Wal-Mart is the second largest retailer in the world. The data file on the disk holds monthly data on Wal-Marts revenue, along with several possibly related economic variables. a) Using computer...
-
What is the purpose of an unadjusted trial balance?
-
Using the information provided in BE22-15, prepare the operating activities section of the statement of cash flows using the direct method. In BE22-15 Simons Products, Inc. reported the following...
-
Kimm-Mills Incorporated (KMI) acquired a piece of equipment at a total cost of $ 5,400,000. KMI uses the straight- line method of depreciation for financial reporting purposes and an accelerated...
-
What is the adverse selection problem?
-
Automobile insurance companies charge lower rates to married individuals than they do to unmarried individuals. What economic reason is there for such a practice? Is it fair?
-
An advanced degree is required to teach at most colleges. In what sense is this a form of restricting entry through licensure?
Study smarter with the SolutionInn App