Use the information given below to prepare the following for Altech Limited for July and August...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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 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) 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 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 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
-
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...
-
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...
-
Use the Western Environmental Inc. information given below to prepare a statement of cash flows for the year ended June 30, 2020, using the indirect method. a. A note is retired at carrying value. b....
-
Reisen Travel offers helicopter service from suburban towns to John F. Kennedy International Airport in New York City. Each of its 10 helicopters makes between 1,000 and 2,000 round-trips per year....
-
Everitt, as reported in Hand, Daly, Lunn, McConway, and Oserowski (1994), presented data on the amount of weight gained by 72 anorexic girls under one of three treatment conditions. The conditions...
-
Theres no reason for me to get excited about the choice between the weighted-average and FIFO methods in my process-costing system. I have long term contracts with my materials suppliers at fixed...
-
An article in the Wall Street Journal on the Indian economy noted that an estimated 263 million Indians55 percent of the countrys workforceeke out a living from farms. This makes any attempt at...
-
Boulware Company manufactures and sells electronic games. Each game costs $25 to produce, sells for $45, and carries a warranty that provides for free replacement if it fails during the two years...
-
18.A sine wave is travelling in a medium. The minimum distance between the two particles, always having same speed, is (1) (2)
-
Information related to Monty Corp. is presented below. 1. On April 5, purchased merchandise on account from Marigold Company for $39,000, terms 3/10, net/30, FOB shipping point. 2. On April 6, paid...
-
Required: You can structure your essay around the points you would like to highlight. Suggested points to include: Cue COVID-19. The crisis has only exacerbated the problems in many countries tax...
-
Who is liable if a client is purchasing a home and you as the buyers agent did not make additional options to them and something happens to the home?
-
Who is at the greatest risk of adverse effects resulting from the use of base metals? What precautions should be taken to reduce this risk? How can dental alloys cause an allergic reaction in...
-
Who do you believe was more influential in establishing the American political system in the 1 7 9 0 s ?
-
Question 6 (a) Jan.08.2024 Solve the utility maximization problem subject to px + qy = m, where 0
-
who is the under - appreciated hypochondriac that constitutional experts celebrate for his role in the Second Founding?
-
A rocket-powered sled moves along a track, eventually reaching a top speed of 241 m/s to the east. It then begins to slow down, reaching a complete stop after slowing down for 3.01 s. What was the...
-
At 31 December 20X9, the end of the annual reporting period, the accounts of Huron Company showed the following: a. Sales revenue for 20X9, $ 2,950,000, of which one- quarter was on credit. b....
-
Let us consider a call option with maturity \(T=1\) year and strike price \(\$ 11\). The current price of the stock share is \(\$ 10\), and the riskfree interest rate is \(10 \%\). The two possible...
-
Let us consider the PDE with terminal condition In order to apply the representation theorem, we observe that \(r=0\), \((x t)=\), and , so that the underlying stochastic process boils down to a...
-
Let us consider the same setting as Example 13.4: \(S_{0}=K=50\), \(r=01, \quad=04\), and time-to-maturity is \(T=5/12\) (here we take \(t=0)\). The calculation is as follows: This exact result may...
Study smarter with the SolutionInn App