Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show the formula from excel if you can. Thanks Question 1 : A company has the opportunity to expand its business operations by acquiring

Please show the formula from excel if you can. Thanks

Question 1 :

A company has the opportunity to expand its business operations by acquiring new plant and equipment. The plant and equipment will cost $80,000 and have a useful life of 6 years. At the end of the period the plant and equipment will have a salvage value of $10,000. The Tax Office allows the company to depreciate this equipment at 25% per annum using the prime cost method (straight line). The tax rate is 30%, and is paid in the year of income. An additional working capital investment of $20,000 is also required and will be recouped in the final year of the project. Additional gross operating revenues from the investment are expected to be: Year 1 = $20,000; Year 2 = $38,000; Year 3 = $44,000; Year 4 = $36,000; Year 5 = $26,000; and Year 6 = $14,000. The company requires a rate of return on their investments of 12%.

Required: What is the Net Present Value of this investment opportunity?

Question 2:

Gormley Products Pty Ltd is considering the introduction of a new product to add to its existing product line. The company expects a reasonable level of sales for the next 5 years after this period the product sales are expected to be zero. Specialised equipment will need to be purchased to produce the new product at a cost of $110,000. Additional working capital of $17,600 will need to be introduced over the life of the product. Working capital will be recovered at the end of the product's life. Salvage value of the equipment at the end of Year 5 is $11,000.

Year

1

2

3

4

5

Pre Tax Net CASH Flows

$20,000

$24,000

$37,000

$59,000

$81,000

Additional information:

The tax office allows depreciation of the prime cost at a rate of 25% (Straight Line).

The tax rate is 30%.

The company uses an after-tax cost of capital of 12.5%.

Required:

After determining the Annual Net After-Tax Cash Flows, calculate the INTERNAL RATE OF RETURN (IRR) for this project.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

CISA Certified Information Systems Auditor All In One Exam Guide

Authors: Peter H. Gregory

4th Edition

1260458806, 978-1260458800

More Books

Students also viewed these Accounting questions

Question

6. Are my sources reliable?

Answered: 1 week ago

Question

5. Are my sources compelling?

Answered: 1 week ago