Business Analysis and Interpretation

Accounting calculation assignment: due on 19th 

ACC10707 Session 3, 2017 Assessment 3

Business Analysis and Interpretation

Due on 19th Friday before 11pm

1. Student Enterprises has the following business transaction estimates relating to the first quarter of 2018. (15 Marks)

$

Credit Sales 180960

Cash Sales 162624

Receipts from Accounts Receivable 145640

Wages 85020

Office Furniture 27176

Prepayments 7698

Administrative Expense 24816

Depreciation on Office Furniture 1554

Receipt of Loan 28500

Credit Purchases 95456

Payments of Accounts Payable 93104

Accrued Expense 986

Prepayments 1327

The cash balance at 1 January 2018 was $79 550.

Required

Prepare a cash budget for the quarter ending 31 March 2018.

2. Student Industries sells IT equipment, specialising in printers and faxes. The following statement reflects the contribution margin of each activity, and overall profit levels.

Required

a. Calculate the contribution margin ratios for each of the two areas of activity, and in total. (10 Marks)

b. Using the total contribution margin ratio, calculate the level of sales required to break even by item and in total. (5 Marks)

3. Student Industries is considering buying asmall industrial machine which costs $124 000 and is expected to earn annual net cash inflows of $54 600, $49 600, $44 600 and $39 700, before it wears out sufficiently to be unreliable and must be sold for an estimated $12 400.

Required

a. If funds earn 11 per cent, what is its NPV? (4 Marks)

b. If funds earn 15 per cent, what is its NPV? (4 Marks)

c. Advise management on your recommendation regarding purchase of the

machine subsequent to your NPV calculations. (3 Marks)

d. What advice would you give management if the required payback period was

two years? (4 Marks)

Show calculations for a, b and d.