Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started