Bowral Holiday Hobbies Ltd plans to sell toy cars over the internet and by mail order. Bowral Holiday Hobbies Ltd buys the toy cars for $24 and...

Q1 :

Bowral Holiday Hobbies Ltd plans to sell toy cars over the internet and by mail order. Bowral Holiday Hobbies Ltd buys the toy cars for $24 and sells them for $32. If payment by cheque accompanies the mail orders (estimated to be 50 per cent of sales), Bowral Holiday Hobbies Ltd gives a 10 per cent discount. If customers include a credit card number for internet or mail order sales (20 per cent of sales), customers receive a 5 per cent discount. The remaining collections are estimated to be:

• One month following 12%
• Two months following 8%
• Three months following 6%
• Uncollectable 4%

Bowral Holiday Hobbies Ltd has forecasted the following sales volumes:

• June 80 units
• July 120 units
• August 160 units
• September 105 units

Bowral Holiday Hobbies Ltd plans to pay its supplier 60 per cent in the month of purchase and 40 per cent in the month following. A 10 per cent discount is granted on payments made in the month of purchase. Bowral Holiday Hobbies Ltd has 40 toy cars on hand (purchased in May and to be paid for in June) and plans to maintain enough end-of-month inventory to meet 50 per cent of the next month's sales.

Required:

1. Prepare schedules for monthly budgeted cash receipts and cash disbursements for this venture.

2. How much is expected to be uncollected at the end of September?

3. Prepare a brief report for the Chief Financial Officer of Bowral Holiday Hobbies Ltd highlighting the strengths and weaknesses of this analysis.

Q2 :

Bowral Holiday Hobbies Ltd is considering purchasing equipment with a cost of $60,000 that will, if acquired, generate annual savings of $30,000 for six years, at which time it will have no further use or value. The company has a marginal tax rate of 40 per cent and requires a 10 per cent rate of return. It uses straight-line depreciation. Ignore inflation.

Required

1. What is the after-tax cash flow for each year?

2. What is the NPV of this investment?

3. What is the payback period?

4. Explain the advantages and disadvantages of the NPV and payback methods.