QUESTION 1 (20) Required: Use the information given below to prepare the following for Altech Limited...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
QUESTION 1 (20) Required: Use the information given below to prepare the following for Altech Limited for July and August 2021: (4) (16) 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand. Information: Extract of Statement of Comprehensive Income for the month ended 30 June 2021 R Sales 200 000 Cost of sales 100 000 Rent income 8 000 Advertising Salaries and wages 4 000 10 000 Rates and taxes 1 200 Electricity Other operating expenses 3 000 9 000 Additional information: 1. The business uses a fixed mark-up of 100% on cost. 2. Sales are expected to increase by 10% each month. 3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts. 4. Closing Inventories are kept at a constant level. 50% of purchases are for cash. Creditors are paid one month after purchase. 5. In terms of the lease agreement, the rental income will increase by 10% per annum with effect from 01 July 2021. Rent is received monthly. 6. Advertising is paid monthly and is estimated to be the same percentage of sales as for June 2021. 7. Salaries and wages will increase by 10% with effect from 01 July 2021. 8. Rates and taxes will be paid in one instalment for the year during July 2021. Rates to be paid will amount to R6 000. 9. Other operating expenses are expected to increase by R500 every month. These expenses are paid for in the month in which they are incurred. 10. Electricity is expected to increase by 12% from 1 August 2021 due to tariff increases 11. The balance in the bank on 30 June 2021 is estimated to be R40 000 (favourable). QUESTION 1 (20) Required: Use the information given below to prepare the following for Altech Limited for July and August 2021: (4) (16) 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand. Information: Extract of Statement of Comprehensive Income for the month ended 30 June 2021 R Sales 200 000 Cost of sales 100 000 Rent income 8 000 Advertising Salaries and wages 4 000 10 000 Rates and taxes 1 200 Electricity Other operating expenses 3 000 9 000 Additional information: 1. The business uses a fixed mark-up of 100% on cost. 2. Sales are expected to increase by 10% each month. 3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts. 4. Closing Inventories are kept at a constant level. 50% of purchases are for cash. Creditors are paid one month after purchase. 5. In terms of the lease agreement, the rental income will increase by 10% per annum with effect from 01 July 2021. Rent is received monthly. 6. Advertising is paid monthly and is estimated to be the same percentage of sales as for June 2021. 7. Salaries and wages will increase by 10% with effect from 01 July 2021. 8. Rates and taxes will be paid in one instalment for the year during July 2021. Rates to be paid will amount to R6 000. 9. Other operating expenses are expected to increase by R500 every month. These expenses are paid for in the month in which they are incurred. 10. Electricity is expected to increase by 12% from 1 August 2021 due to tariff increases 11. The balance in the bank on 30 June 2021 is estimated to be R40 000 (favourable).
Expert Answer:
Answer rating: 100% (QA)
Cash Budget For the Month of July and August Description July August Beginning Balance 40000 165500 ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
The adjacency matrices for a graph is give as follows: (a) Use the adjacency matrices to construct the corresponding multi-staged bipartite graph. (b) Use the graphical method to find all directed...
-
Clairpointe Accessories manufactures products for food preparation at several different manufacturing sites. The following costs and other data apply to unit production from the year just ending:...
-
Q2) Design the combinational circuit that has 4 inputs(A0, A1,A2,A3). The input Ao will be connected to its only output Z if the selector lines are "high", Al will be connected to output if selector...
-
Verify that the functions are probability density functions for a continuous random variable X over the given interval. Determine the specified probability. f(x) = xe over [0, ), P(1 X 3)
-
Exponential smoothing with trend, with a smoothing constant of = 0.2 and a trend smoothing constant of = 0.3, is being used to forecast values in a time series. At this point, the last two values...
-
Find the trigonometric Fourier series coefficients for the waveform infigure. v(t). 1 2 3 4
-
Suppose a company can replace the packing material it currently uses with a biodegradable packing material. The company believes this move to biodegradable packing materials will be well received by...
-
Infosys Technologies, introduced in Chapter 1, regularly provides investors with a performance measure called economic value-added (EVA). Originally pioneered by GE, EVA measures the profitability of...
-
3. You purchased a 3 year coupon bond one year ago. Its par value is $1,000 and coupon rate is 6%, paid annually. At the time you purchased the bond, its yield to maturity was 6.5%. Suppose you sell...
-
Windemere Limited is a Canadian-controlled private corporation founded 12 years ago by Mr. White who holds all of the shares which he purchased at that time from the company for $1,000. As of...
-
A class of eight students has SAT scores of 1112, 1168, 1210,1300, 919, 825, 1210, 917. What is the average SAT score? Werethere any students who received the same score? If so, what werethe scores?...
-
Events occur according to a Poisson process of rate .Every time an event occurs, we will get a prize and we must decide whether to stop or not, our goal being to stop at the last event that occurs...
-
Jessica paid estimate tax payments for 2019 as follows: Date of Payment 4/15/2019 6/15/2019 9/15/2019 1/15/2020 Federal $2,000 $2,000 $2,000 $2,000 State $ 300 $ 400 $0 $ 300 Prepare Jessica's 2019...
-
Find the slope-intercept form of the line with the given slope and y-intercept. 9 3 Slope = 2 y-intercept = 5 What is the equation of the line? (Simplify your answer. Type your answer in...
-
Interest income on loans and securities$12,000 Interest paid on deposits10,000 Non-interest income2,500 Total non-interest expense3,500 Provision for loan loss500 Security gains 250 Income taxes210...
-
The following C program is to be compiled by a compiler targeting the ARMv8-A architecture: long long int a = 10; long long int b = 29; long long int c =30; long long int d =0; void main() { d =...
-
Rio Inc. had 423,500 shares of common stock outstanding throughout the year. Net income for the year was $1,218,000. Rio Inc. had 3 potentially dilutive securities. Potentially Dilutive Security...
-
1) Predict the organicproduct formed when BzCl reacts with cyclohexanol. BzCl = benzoylchloride. 2) Provide the majororganic product of the reaction below. 3) Draw the structureof the product formed...
-
Allister Company uses both debt capital and equity capital to fund new projects. The before-tax cost of debt capital is 12 percent. The cost of equity capital is 10 percent. Allister's effective tax...
-
Use an Internet search engine to identify three companies or agencies that use present worth analysis to make business decisions as evidenced in their annual reports.
-
Use the Internet to access ConocoPhillips's most recent annual report. a. What evidence do you find that ConocoPhillips continues to rely on present worth analysis in its corporate decision making?...
Study smarter with the SolutionInn App