Financial management/mba



Yüklə 241,5 Kb.
tarix10.02.2023
ölçüsü241,5 Kb.
#100563
ADM Final Exam - Ulugbekov Sardor




Course Title: Accounting for Decision Making
Time – 3 Hours Marks – 100
Term: Final Examination
Instructions:
Answer all the question in Section A and any 3 questions from Section B.

Exam taker: ULUGBEKOV SARDORBEK ULUGBEKOVICH

Section A Case Study Total: (40 marks)


Question 1



KMC Ltd. Statement Of Financial Position

For December 31, 2017 And 2018





2017

2018

Cash

$ 9,000

$ 5000

Accounts receivable

$ 12,500

$ 16,000

Inventories

$ 29,000

$ 45,500

Total Current Assets

$ 50,500

$ 62,000




Land

$ 20,000

$ 26,000

Building and equipment

$ 70,000

$ 100,000

Less : depreciation to date

$ (28,000)

$ (38,000)

Total Non-Current Assets

$ 62,000

$ 88,000

Total Assets

$ 112,500

$ 150,000




Accounts Payable

$ 10,500

$ 22,000

Short-term loan

$ 17,000

$ 47,000

Total Current Liabilities

$ 27,500

$ 69,000




Long-term debt

$ 28,750

$ 22,950

Ordinary Shares

$ 31,500

$ 31,500

Retained earnings

$ 24,750

$ 26,550

Total Liabilities And Equity

$ 112,500

$ 150,000




KMC Ltd. Statement Of Financial Performance


For The Years Ended December 31, 2017 And 2018


2017

2018

Sales (all credit)

$ 125,000

$ 160,000

Cost of sales

$ 75,000

$ 96,000

Gross Profit

$ 50,000

$ 64,000

Cash Expenses

$ 33,500

$ 37,000

Depreciation

$ 4,500

$ 10,000

Total Expenses

$ 38,000

$ 47,000

Profit before interest and taxes

$ 12,000

$ 17,000

Interest expenses

$ 3,000

$ 6,100

Profit before tax

$ 9,000

$ 10,900

Taxes

$ 4,500

$ 5,450

Profit for the year

$ 4,500

$ 5,450



REQUIRED:



  1. Based on the above financial statements, complete the following table.

Show workings. (25 marks)



Industry Ratios for 2018











Industry

KMC

KMC




Average

2017

2018

Current ratio

1.80

 =50500/27500=1.83

=62000/69000=0.89

Acid-test ratio/Quick ratio

0.70

 =(50500-29000)/27500=0.78

=(62000 -45500)/69000=0.23

Receivable collection period

37 days

=125000/112500=1.1

=160000/150000=1.06

Age of inventory

146 days

=29000/75000*365=141

=45500/96000*365=172 

Debt ratio

58%

=112500/112500*100=100

=150000/150000*100=100

Times interest earned

3.80

=



Net operating profit margin

10%

=4500/125000*100=3.6

=5450/160000*100=3.4

Total asset turnover

1.14

=125000/112500=1.1

=160000/150000=1.06

Return on assets

11.40%

=4500/112500*100=4

=5450/150000*100=3.63

Return on equity

9.50%

=4500/9000*100=50

=5450/500*100=1090

b) Using the ratios calculated and the industry averages, comment on the following:-


(15 marks)

(i) The liquidity position of the firm. On this ratio the position of KMC2017 is 1.83 which is higher than that of Average Industry, but KMC2018 with 0.89 is lower than the position of Average Industry.



  1. Management’s ability to generate adequate profit on the firm’s asset.

  2. T`he firm’s financing of the assets. The firm`s total assets divide into two big parts which includes tatal current and non-current asstes in 2017 and 2018. The firm`s total current assets are in all $ 50 500 in 2017 and also $ 62 000 in 2018. It is clear that the amount of the financing of the firm`s total current assets in 2017 are lower than that of the firm`s in 2018.

On the other hand the firm`s total non-current assets in the two years too are more than the total current asset, with $ 62 000 in 2017 and with $ 88 000 in 2018.
Total assets of the firm in 2017 is $ 112 500 and $ 150 000.

  1. The return received by the shareholders. The amount of equity both KMC2017 and KMC2018 are much higher than the Average Industry with 9.5%. it is actually good for the company and its strategies of managers.

SECTION B - Answer any THREE (3) Questions (Total: 60 marks)


Question 4
Maju Bhd. makes uniforms for several large customers. They have received an order to produce 1,000 uniforms. The order will take 3,500 metres of material that costs $10 per metre and will require 1,500 direct labour hours and 625 machine hours. The following are the expected annual total costs and expected total labour and machine hours for Maju Bhd.

Direct labour cost : $279,000


Direct labour hours : 31,000 hours
Direct materials : $210,000
Overheads : $124,000
Machine hours : 20,000 hours
REQUIRED:-
From the above information, calculate the following:-



  1. The overhead absorption rate given that the process is labour intensive. (3 marks)

(b) The total costs to Maju Bhd. of fulfilling the order. (9 marks)


(c) The cost of the order if Maju Bhd. choses to use machine time as the basis for allocating overheads. (5 marks)





  1. The company’s normal practice is to add a mark-up of 20% to total cost. Determine the selling price by using labour hours as a basis of absorbing overheads. (3 marks)

Order – 1 000
Direct material – 3 500 * $ 10 = $ 35 000
Direct labour hours – 1 500
Machine hours – 625
Total
Direct labour cost – 279 000
Direct labour hours – 31 000 hours
Direct materials – 210 000
Overheads – 124 000
Machine hours – 20 000 hours



  1. Manufacturing overhead rate = 279 000 / 31 000 = $ 9 per

Machine hours overhead rate = 124 000 / 20 000 = 6.2 per hour

  1. Total cost: direct material cost + direct labour cost + direct labour hour + allocate manufactured overhead = 35 000 + (1 500 * 9) + (625 * 6.2) = 52 375

  2. Allocate manufactured overhead = 13.95 * 625 = 8 718,75

Total: 52 375 + 8 718,75 = 61 093,75

  1. Selling price: total cost (1+mark up) = 61 093,75 *(1+0.2) = 73 312,75

Question 5

The managers of TMC Bhd. are currently considering two mutually exclusive investment projects (only one can be accepted). Both projects are concerned with the purchase of a new truck. The following data is available for both trucks.




MODEL MODEL
HITECH NAPTUNE
$ $

Purchase of cost (immediate outlay) (285,000) (165,000)


Expected net cash flow
Year 1 120,000 80,000
Year 2 90,000 78,000
Year 3 80,000 50,000
Year 4 65,000 40,000
Year 5 60,000 35,000

TMC Bhd. has a cost of capital of 12% and has laid down the following criteria for all project selection:



  1. The payback period must be less than three years.

  2. The net present value must be positive when discounted by the cost of capital.

  3. The profitability index must be more than 1.

The present value of $1 at 12% is as follows:-




YEAR 0 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
1 0.8929 0.7972 0.7118 0.6355 0.5674
REQUIRED:-



  1. For each truck, calculate the following:

(i) The Payback Period for each truck. (4 marks)


If all cash flow for the year is $ 285 000, then assume monthly cash flow = $ 285 000 / 12 month = $ 23 750 per month
Straight line depreciation applies $ 285 000 / 5 years = $ 57 000 per year
Project HITECH

YEARS NET CASH FLOW


0 $ 285 000
1 $ 120 000
2 $ 90 000
3 $ 80 000
4 $ 65 000
5 $ 60 000



  • 2 years we have recovered $ 210 000 of the required $ 285 000

  • Balance to reqover is $ 285 000 - $ 210 000 = $ 75 000

Therefore
PAYBACK PERIOD = 2 + ($ 75 000 / ($ 80 000 + $ 65 000 + $ 60 000)) = 2.36 YEARS
Project NAPTUNE
YEARS NET CASH FLOW
0 $ 165 000
1 $ 80 000
2 $ 78 000
3 $ 50 000
4 $ 40 000
5 $ 35 000



  • 2 years we have recovered $ 158 000 of the required $ 165 000

  • Balance to reqover is $ 165 000 - $ 158 000 = $ 7 000

Therefore
PAYBACK PERIOD = 2 + ($ 7 000 / ($ 50 000 + $ 40 000 + $ 35 000)) = 2.056 YEARS
(ii) The Net Present Value for each truck. (8 marks)
Net Present Value for Project HITECH
YEARS NET CASH FLOW
0 $ 285 000
1 $ 120 000
2 $ 90 000
3 $ 80 000
4 $ 65 000
5 $ 60 000
The company`s cost of capital is 12 %
NPV = - 285 000 (year 0) + 120 000 / 1 (year 1) + 90 000 / 1.12*1.12 (year 2) + 80 000 / 1.12*1.12*1.12 (year 3) + 65 000 / 1.12*1.12*1.12*1.12 (year 4) + 60 000 / 1.12*1.12*1.12*1.12*1.12 ( year 5) = - 285 000 + 107 142.8 + 71 747.4 + 56 942.4 + 41 308.6 + 34 045.6 = $ 26 186.8

Net Present Value for Project NAPTUNE


YEARS NET CASH FLOW
0 $ 165 000
1 $ 80 000
2 $ 78 000
3 $ 50 000
4 $ 40 000
5 $ 35 000
The company`s cost of capital is 12 %
NPV = - 165 000 (year 0) + 80 000 /1 (year 1) + 78 000 /1.12*1.12 (year 2) + 50 000 /1.12*1.12*1.12 (year 3) + 40 000 / 1.12*1.12*1.12*1.12 (year 4) + 35 000 / 1.12*1.12*1.12*1.12*1.12 (year 5) = - 165 000 + 80 000 + 62 181.1 + 35 589 + 25 420.7 + 19 859.9 = $ 58 057

(iii) The Profitability Index for each truck. (4 marks)


Profitability Index for Project HITECH
PI = (107 142.8 + 71 747.4 + 56 942.4 + 41 308.6 + 34 045.6) / 285 000 = 311 186.8 / 285 000 = 1.091

Profitability Index for Project NAPTUNE


PI = (80 000 + 62 181.1 + 35 589 + 25 420.7 + 19 859.9) / 165 000 = 223 057 / 165 000 = 1.351

(b) State which, if either, of the two trucks the directors of TMC Bhd. should select. Justify your answer. (4 marks)


I think that the Project NAPTUNE is profitable for getting firm`s stability revenue in the future, because of the fact that in two points the activity of Project NAPTUNE is higher than that of Project HITECH.

Question 6
Lotus Ltd manufactures standard laptops, which it sells for $1,300 each. Next year the company plans to make and sell 25,000 units. The company’s costs are as follows:-


MANUFACTURING
Variable materials : $800 per unit
Variable labour : $50 per unit
Other variable costs : $15 per unit
Fixed costs : $4,800,000 per year


ADMINISTRATION & SELLING
Variable : $12 per unit
Fixed : $3,150,000 per year


REQUIRED:-

(a) Calculate the expected profit for next year. (4 marks)


(b) Calculate the break-even point for next year, expressed both in units and sales value. (4 marks)
(c) Calculate the margin of safety for next year, expressed both in units and sales value. (4 marks)
(d) Explain the significance of the margin of safety using the results in part c.
(4 marks)

(e) The firm is considering spending an extra $500,000 on advertising; this is expected to increase the sales volume by 5%. Based on profits, do you feel that it is a good move? Show calculations. (4 marks)


Sales – 25 000
Price – $ 1 300
Variable materials - $ 800 per unit
Variable labour - $ 50 per unit
Other variable costs - $ 15 per unit
Fixed costs - $ 4 800 000 per year

Variable - $ 12 per unit


Fixed - $ 3 150 000 per year



  1. profit for the year:

direct cost = 800 + 50 + 15 = 865
fixed cost = 4 800 000 / 25 000 = 192
manufactured overhead cost = 12 + (3 150 000 / 25 000) = 138
total manufactured cost = 865 + 138 = 1 003
fixed cost = 1 003 + 192 = 1 195
profit = (1 300 * 25 000) - (1 195 * 25 000) = 2 625 000

contributing margin per unit


price – variable manufacturing cost = 1 300 (800 + 50 +15) = 435

break in point in units = fixed cost / contributing margin per unit = (4 800 000 + 3 150 000) / 435 = 18 275,8 = 18 276


contribution margin ratio
(price – variable manufacturing cost) / price = (1 300 – 865) / 1 300 = 0.33
Break even in sales:
7 950 000 / 0.33 = 24 090 909


--



Yüklə 241,5 Kb.

Dostları ilə paylaş:




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©www.genderi.org 2024
rəhbərliyinə müraciət

    Ana səhifə