Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SALLAT Household Furnishings & Appliances is a family-owned business. You are the management accountant of the entity and have been given the task of preparing

image text in transcribed

SALLAT Household Furnishings & Appliances is a family-owned business. You are the management accountant of the entity and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following: i) i) Extracts from the sales and purchases budgets are as follows: Cash Sales Cash Purchases Month Sales On Account Purchases On Account May $75,000 $480,000 $390.000 June $135.000 $600,000 536,000 $360,000 July $86,800 $720,000 $61,700 $450,000 August $105 600 $640,000 $ $68,800 $400,000 September $112 500 $800,000 $77,250 $ $500,000 ii) HI) iv) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are seliled according to the following credil pallom, in accordance with the credit terms 5/30, n90 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale Accounts Payable are settled as follows, in accordance with the credit temns - 4/30, 160: 70% in the month in which the inventory is purchased 30% in the following month Computer equipment, which is estimated to cost $350,000, will be acquired in August. The manager has planned with the supplier to make a cash deposit of 50% of the amount upon signing of the agreement in August, with the balance to be settled in four equal monthly instalments, starting in Seplember 2022. A reasury bond purchased by the company with a face value of $560,000 is expected to mature on July 20, 2022. To meet the financial obligations of the business the management team has decided to liquidate the investment upon maturity. On that date, querterly interest compued al a rale oi 74 % per annut is also expecled to be collected. Fixed operating expenses, which accrue evenly throughout the year, are estimaled to be $1,812,000 per annum including cepreciation on non-current assets of 537,000 per month) and are settled monthly v] vi) vii) The management Sallal Household has negotialed with a tenant for rental of storage space beginning on July 1. The rental is expected to be 5840.000 per annum and will be paid over by the tenant quarterly in advance. Rental relating to the quarter under review becomes due on July 1. vii) Other operating experises are expected to be $432,000 per annum and will be settled monthly Continued.......... DER ix) Wages and salaries are expected to be $2,304,000 per annum and will be paid monthly In the month of August. fumiture & fixtures, which cost $455,000, will be sold to an cmployee ala luss of $20,000. Accumulalod deprecia.ion on the furniture & lixcurus al thal time is expected to be $305,000. The employee will be allowed to pay a deposit equal to 60% of the selling price in August with the balance settled in two equal amounts in September & October & As part of its investing activities, the management of Sallat Household Fumishings & Appliances is in the process of completing a major addition to the business property, which is estimated to cost $1,200.000. and which is being funded by external borrowing $420,000 of the principal, along with interest of $14,200 is due to be paid on July 15, 2022. The cash balance on September 30, 2022, is expected to be an overdraft of $147,500 XI) xii) ) Required: (b) Another leam member who is preparing the Budgeled Balance Sheet for the business lor the same quarter ending September 30, 2022, has asked you to fumish him with the figures for the expected trade receivables and peyables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? (2 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Financial Accounting Concepts

Authors: J.K.

7th Edition

B003NPRW7I

More Books

Students also viewed these Accounting questions