Ask Question, Ask an Expert


Ask Basic Finance Expert

Excel Inc Limited Steel Division is considering the proposal to buy new machine to produce a new product for the potential 3 year contract. New machine will cost= $1.12 million. Machine has the approximate life of 3 years for accounting & taxation purposes. Contract won’t continue beyond 3 years and equipment approximate salvage value at the ending of 3 years= $105,000. Tax rate is 28 percent and is payable in year following the year in which profit is earned. Investment allowance of 30% on outlay is available. Cost of capital is 13.25%pa. In addition net working capital= $72,000 is needed immediately for present assets to support project. Suppose that this amount is recovered at the ending of three year life of project. New product will be charged $53,000 of allocated head office administration costs each year although head office won’t actually incur any extra costs to manage the project. This is in accordance with firm’s policy of allocating all corporate overhead costs to divisions. Extra marketing and administration cash outflows of $43,500 per year will be incurred by Steel Division for project. The amount of $59,000 has been spent on the pilot study and market research for new product. Projections given here are based on this work. Projected sales for new product= 32,000 units at $135 per unit per year. Cash operating expenses are approximate to be 73% of sales (excludes marketing and administration, and head office items). Except for initial outlays, suppose cash flows occur at the ending of each year (unless otherwise stated). Suppose prime cost depreciation for tax purposes. Any losses should be carried forward and offset by income in given year.


(i) Create the table illustrating your computationa of net cash flow after tax.

(ii) Compute NPV. Is the project acceptable? Describe why or why not?

(iii) prepare a brief report describing your computations of applicable net cash flows after tax, justifying your choice of cash flows. Make sure to mention clearly any suppositions made (implicit and explicit).

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M914211

Have any Question? 

Related Questions in Basic Finance

A firm is expected to pay a dividend of 355 next year and

A firm is expected to pay a dividend of $3.55 next year and $3.85 the following year. Financial analysts believe the stock will be at their price target of $120 in two years. Compute the value of this stock with a requir ...

What are cash inflows and outflows what are the

What are cash inflows and outflows? What are the formulas?

Chief officeryou are the chief financial officer cfo at a

Chief officer You are the chief financial officer (CFO) at a community hospital. One of the comments that has come back from patient surveys is the need for a commercial 24-hour pharmacy within the hospital. In this way, ...

Global interaction among yield curves assume that the yield

Global Interaction among Yield Curves : Assume that the yield curves in the United States, France, and Japan are flat. If the U.S. yield curve suddenly becomes positively sloped, do you think the yield curves in France a ...

Estimating cash flowsassume that your company is

Estimating Cash Flows Assume that your company is considering the replacement of an automated milling machine with one of the new machines offered by three different manufacturers. Each of the three machines under consid ...

Jack and jill corporations year-end 2009 balance sheet

Jack and Jill Corporation's year-end 2009 balance sheet lists current assets of $259,000, fixed assets of $809,000, current liabilities of $186,000, and long-term debt of $291,000. What is Jack and Jill's total stockhold ...

We covered many important topics during this class

We covered many important topics during this class. Understanding spending and income, cutting expenses, saving and investing money, building an emergency fund, improving credit, getting out of debt, protecting your asse ...

Suppose that lilymac photography has annual sales of 232000

Suppose that LilyMac Photography has annual sales of $232,000, cost of goods sold of $167,000, average inventories of $4,700, average accounts receivable of $25,400, and an average accounts payable balance of $7,200. Ass ...

A company is planning to open 100 new outlets that are

A company is planning to open 100 new outlets that are expected to generate, in total, $15 million in free cash flows per year, with a growth rate of 3% in perpetuity. If the company's WACC is 10%, what is the NPV of thi ...

Assignment- tvm- tth classbullsubmit using assignment tab

Assignment- TVM- T/Th class • Submit using Assignment tab in eLearning by uploading your completed excel file. • Open a new (fresh) excel workbook to perform you calculations. • You are allowed only one submission, so pl ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate