4/each financial question needs to be solved completely and also writes the how to reach the answer with it

B2. Amna Plc has the following plans for the next few months. 000 Sales revenue: Month September October November December January February March 60,000 90,000 100,000 70,000 80,000 100,000 90,000 All sales will be made on credit. Half of the trade receivables are expected to be paid within the month of sale and qualify for a 5 percent cash discount for paying earlier. The remainder is expected to be collected in the following month. 000 50,000 60.000 Raw material purchases: Month September October November December January February March 30,000 30,000 70.000 80,000 40.000 Amna Plc plans to pay its trade payables (in full) in the month following that of the purchase. 000 Wages and salaries: Month September October November December January February March 13,000 17,000 21,000 12,000 14,000 13,000 14,000 All employees are paid in full in the month in which the wage or salary is earned. Rent of 3m each quarter is payable in March, June, September and December . Other cash overheads of 2m will be paid every month. Three new plants due for delivery in August September and October will be paid for in November December and March at a cost of 60m, 145m, and 25m. respectively Amna Plc plans to have 3m in the bank on 1 October. Required: (1) Prepare a cash budget for the months of October to March (inclusive) showing all monthly cash surpluses (deficits) and cumulative cash balances for Amna Plc. (ii) Briefly discuss any areas where cash flow might be a problem if any. Suggest how Amna Plo's cash budget could be revised to avoid having (deficits) if any. Present Value Tables Present value of 1. ie. (1+0) where r = discount rate n=number of periods untill payment Discount rates (0) 5% 6% 3% 7% Periods (n) 1% 10.990 2 0.980 0.971 0.961 5 0.951 6 0.942 7 0.933 0.923 9 0.914 10 0.905 11 0.896 12 0.887 13 0.879 14 0.870 15 0.861 COU AUNE 2% 0.980 0.961 0.942 0.924 0.906 0.888 0.871 0.853 0.837 0.820 0.804 0.788 0.773 0.758 0.743 0.971 0.943 0.915 0.888 0.863 0.837 0.813 0.789 0.766 0.744 0.722 0.701 0.681 0.661 0.642 4% 0.962 0.925 0.889 0.855 0.822 0.790 0.760 0.731 0.703 0.676 0.650 0.625 0.601 0.577 0.555 0.952 0.907 0.864 0.823 0.784 0.746 0.711 0.677 0.845 0.614 0.585 0.557 0.530 0.505 0.481 0.943 0.890 0.840 0.792 0.747 0.705 0.665 0.627 0.592 0.558 0.527 0.497 0.469 0.442 0.417 0.935 0.873 0.816 0.763 0.713 0.666 0.623 0.582 0.544 0.508 0.475 0.444 0.415 0.388 0.362 8% 9% 2.926 0.917 0.857 0.842 5.794 0.772 2.735 0.708 9.681 0.650 0.630 0.596 0.583 0.547 2.540 0.502 0.500 0.460 2.463 0.422 0.429 0.388 0.397 0.356 2.368 0.326 9.340 0.299 1.315 0.275 10% 0.909 0.826 0.751 0.683 0.621 0.564 0.513 0.467 0.424 0.386 0.350 0.319 0.290 0.263 0.239 11% 12% 13% 14% 15% 16% 17% 20% 5 6 7 8 9 10 11 12 13 14 15 0.901 0.812 0.731 0.659 0.593 0.535 0.482 0.434 0.391 0.352 0.317 0.286 0.258 0.232 0 209 0.893 0.797 0.712 0.636 0.567 0.507 0.452 0.404 0.361 0.322 0.287 0.257 0.229 0.205 0.183 0.885 0.783 0.693 0.613 0.543 0.480 0.425 0.376 0.333 0.295 0.261 0.231 0.204 0.181 0.160 0.877 0.769 0.675 0.592 0.519 0.456 0.400 0.351 0.308 0.270 0237 0.208 0.182 0.150 0.140 0.870 0.756 0.658 0.572 0.497 0.432 0.376 0.327 0.284 0.247 0.215 0.187 0.163 0.141 0.123 0.862 0.743 0.641 0.552 0.476 0.410 0.354 0.305 0.263 0.227 0.195 0.168 0.145 0.125 0.108 0.855 0.731 0.624 0.534 0.456 0.390 0.333 0.285 0.243 0.208 0.178 0.152 0.130 0.111 0.095 18% 19% 0.847 0.840 0.718 0.706 0.609 0.593 0.516 0.499 0.437 0.419 0.370 0.352 0.314 0.296 0.266 0.249 0.225 0.209 0.191 0.176 0.162 0.148 0.137 0.124 0.116 0.104 0.099 0.088 0.084 0.074 0.833 0.694 0.579 0.482 0.402 0.335 0.279 0.233 0.194 0.162 0.135 0.112 0.093 0.078 0.065