Required: Use the information given below to prepare the following for Altech Limited for July and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required: Use the information given below to prepare the following for Altech Limited for July and August 2021: 1.1 Debtors Collection Schedule (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 Sales 200 000 Cost of sales 100 000 Rent income 8 000 Advertising Salaries and wages 4 000 10 000 1 200 3 000 9 000 Rates and taxes Electricity Other operating expenses 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 2 (20) INFORMATION: Vista Limited intends purchasing a new machine and has a choice between the following two machines: Equipment A Equipment B Initial cost R220 000 R240 000 Expected useful life Scrap value Expected net cash inflows: 5 years 5 years Nil Nil R R End of: Year 1 55 000 70 000 Year 2 60 000 70 000 Year 3 62 000 70 000 Year 4 60 000 70 000 Year 5 70 000 70 000 The company estimates that its cost of capital is 12%. Required: 2.1 Calculate the Payback Period of both equipment. (Answers must be expressed in years, months and days). (4) 2.2 Calculate the Accounting Rate of Return (on initial investment) for both equipment A and B. (Answers must be expressed to 2 decimal places). (5) 2.3 Calculate the Net Present Value of each equipment. (Round off amounts to the nearest Rand.) (6) 2.4 Calculate the Internal Rate of Return of Equipment B. (5) Required: Use the information given below to prepare the following for Altech Limited for July and August 2021: 1.1 Debtors Collection Schedule (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 Sales 200 000 Cost of sales 100 000 Rent income 8 000 Advertising Salaries and wages 4 000 10 000 1 200 3 000 9 000 Rates and taxes Electricity Other operating expenses 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 2 (20) INFORMATION: Vista Limited intends purchasing a new machine and has a choice between the following two machines: Equipment A Equipment B Initial cost R220 000 R240 000 Expected useful life Scrap value Expected net cash inflows: 5 years 5 years Nil Nil R R End of: Year 1 55 000 70 000 Year 2 60 000 70 000 Year 3 62 000 70 000 Year 4 60 000 70 000 Year 5 70 000 70 000 The company estimates that its cost of capital is 12%. Required: 2.1 Calculate the Payback Period of both equipment. (Answers must be expressed in years, months and days). (4) 2.2 Calculate the Accounting Rate of Return (on initial investment) for both equipment A and B. (Answers must be expressed to 2 decimal places). (5) 2.3 Calculate the Net Present Value of each equipment. (Round off amounts to the nearest Rand.) (6) 2.4 Calculate the Internal Rate of Return of Equipment B. (5)
Expert Answer:
Answer rating: 100% (QA)
Question1 11 Debtors Collection Schedule July August Sales 220000 242000 Cash Sales 30 66000 72600 C... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Required Use the VicWest Inc. information given below to prepare a statement of cash flows for the year ended June 30, 2014, using the indirect method. a. A note is retired at carrying value. b. The...
-
For each parabola described, use the information given to find the location of the missing feature. It may help to draw a sketch. a. If the focus is (1, 4), and the directrix is y = - 3, where is the...
-
Pioneers International has just released its management forecasts for 2020 and 2021. Income Statement Revenues COGS Gross Profit G&A Expenses Depreciation Operating Profits Interest Expense EBT Taxes...
-
Find the inverse of each of the given matrices by the method of Example 1 of this section. Data from Example 1 Find the inverse of the matrix First, we interchange the elements on the principal...
-
Reconsider Prob. 27.9-4. Use the linear regression procedure in the forecasting area of your IOR Tutorial to generate the linear regression line. On the resulting graph that shows this line and the...
-
Find i2(t) in the circuit infigure. iz(1) 2 2 cos400f A 10 mH 625 F 403 25 mH
-
On 30 June 2025 the following information appeared in the accounting records of Ndung and Mkoka. Balance of Accounts Receivable Control account, \($7450\) Total of schedule of accounts receivable,...
-
Apple Inc. is the number one online music retailer through its iTunes music store. Apple sells iTunes gift cards in $15, $25, and $50 increments. Assume Apple sells $21 million in iTunes gift cards...
-
_____ redirects a user from a legitimate website to a malicious website by changing hosts files on a DNS server. A. Exploitation framework B. ARP poisoning C. DDoS DNS attack D. DNS...
-
Given two arrays each of length n, arr1, and arr2, in one operation, any two elements of an array can be swapped. This can occur any number of times. Find the maximum possible sum of i*(arr2[1]-...
-
(A) Zzzz Worst Company currently has total assets of $3.2 million, of which current assets comprise $0.2 million. Sales are $10 million annually, and the before-tax net profit margin (the firm...
-
Most Beagles have shoulder heights between 36 and 41 centimeters. The following compound inequality relates the estimated shoulder height (in centimeters) of a dog to the internal dimension of the...
-
How to calculate the 5yr returns? BOND Shares National Munt Bond Schwab US TIPS Vanguard Emerg Met Bond Blackrock ESG Bond Shares 1-3 Year Treasury BOND TOTAL MUB SCHF SOMA BIAAX SHY [$117.05]]...
-
Fun Buy purchases merchandise inventory by the crate; each crate of inventory is a unit. The fiscal year of Fun Buy ends each February 28. Assume you are dealing with a single Fun Buy store in...
-
The following function computes an integer square root by the rather dubious process of making a series of random guesses until it happens to guess correctly. int isqrt(int x) // Compute the integer...
-
For each of the transactions listed below, work out the changes for the transaction and record these changes in the T-accounts. After finishing the transactions, calculate and show the account...
-
Calculate div D at point P (-2,3,5) if: a. D (10xyza, +5xza, +(22-5xy);] b. D=5z ap+10pza: div D: = div D div D aDx aDy aD + + ax y az 1 a pap (pDp) + DDz + (r D) +- 1 pad 1 2 r sin 030 z (sin 0 De)...
-
Suppose that you are part of a virtual team and must persuade other team members on an important matter (such as switching suppliers or altering the project deadline). Assuming that you cannot visit...
-
From the following figures, compile accounts receivable ledger and accounts payable ledger control accounts for the month, and ascertain what the net balances of the respective ledgers should be on...
-
Why may some people consider this to be incorrect? That is, why is the fact that the control account is kept in the General Ledger not enough to justify saying that the control account is part of the...
-
The financial year of The Better Trading Company ended on 30 November 2014. You have been asked to prepare a Total Accounts Receivable Account and a Total Accounts Payable Account in order to produce...
Study smarter with the SolutionInn App