Compute the future cash flows

Assignment Help Financial Management
Reference no: EM13128010

Case Study

Koda Private Limited ("Koda"), a privately owned company, has been manufacturing electrical parts used in mobility vehicles for people with disabilities and the elderly for more than two decades. These parts are exported to various manufacturers worldwide but at present there are no local manufacturers of mobility vehicles in Singapore.

Retailers in Singapore normally import mobility vehicles and sell them at an average price of $4,000 each. Koda wants to manufacture mobility vehicles locally and believes that it can sell vehicles of equivalent quality locally at a discount of 30% to the current average retail price.

Although this is a completely new venture for Koda, it will be in addition to the company's core business. Koda's directors expect to develop the project for a period of four years and then sell it for $16 million to a private equity firm. The local government has been positive about the venture and has offered Koda a term loan of up to 100% of the investment funds required, at market rates. Currently Koda can borrow at 3.0% above the five-year government debt yield rate.

A feasibility study commissioned by the directors, at a cost of $250,000, has produced the following information assuming a base case scenario:

1. Initial cost of acquiring suitable premises will be $11 million, and plant and machinery used in the manufacture will cost $3 million. Acquiring the premises and installing the machinery is a quick process and manufacturing can commence almost immediately.

2. It is expected that in the first year 1,200 units will be manufactured and sold. Unit sales will grow by 50% in each of the next two years before falling to an annual growth rate of 10.0% for the final year. After the first year the selling price per unit is expected to increase by 5.0% per year.

3. In the first year, it is estimated that the total direct material, labour and variable overheads costs will be $1,200 per unit produced. After the first year, the direct costs are expected to increase by an annual rate of 8.0%.

4. Annual fixed overhead costs would be $1 million. The fixed overhead costs will increase by 5.0% per year after the first year.

5. Koda will need to make working capital available of 15.0% of the anticipated sales revenue for the year, at the beginning of each year. The working capital is expected to be recovered at the end of the fourth year when the project is sold.

The firm's marginal tax rate is 17.0% per year on taxable profits. Tax is payable in the same year as when the profits are earned. Tax allowable depreciation is available on the plant and machinery on a straight-line basis and will be fully depreciated. It is anticipated that the salvage value attributable to the plant and machinery after four years is $400,000. No tax allowable depreciation is available on the premises.

Koda uses 8.0% as its discount rate for new projects but feels that this rate may not be appropriate for this new type of investment. It intends to raise the fill amount of funds through debt finance and take advantage of the government's offer of a subsidised loan. Koda's target debt-to-equity ratio is 0.25.

Although no other companies produce mobility vehicles in Singapore, GP Industries Limited ("GPI"). a company listed in Singapore Exchange, produces electrical-powered vehicles using similar technology to that required for the mobility vehicles and has been identified as a comparable guideline firm. Its historical beta is estimated by Reuters to be 1.25. The five-year government debt yield is currently estimated at 3.5% and the market risk premium at 6.0%.

Question 1

Compute Koda's weighted average cost of capital (WACC).

Question 2

Compute the future cash flows associated with the manufacturing of mobility vehicles and the net present value (NPV) of the project by filling in the blanks in the table below. Advise whether Koda should invest in this venture.

i Forecasted Cash Flows

!

 

 

 

 

 

 

 

 

Year

 

 

 

 

 

 

 

 

 

 

 

Sales

 

 

 

 

 

Direct cost  Grosspnafit

 

 

 

 

 

 

 

Fixed overhead cost

 

 

 

 

Depreciation

 

 

 

 

EBIT

 

 

 

 

Tax (a) 17%

 

 

 

 

Net income / (loss)

 

 

 

 

 

 

 

 

 

Operating cash flow

 

 

 

 

 

 

 

 

 

Working capital (WC) required

 

 

 

 

Cash flow impact of WC

 

 

 

 

 

 

 

 

 

 

 

Feasibility study

 

 

 

 

 

Acquisition of premise Purchase of plant and machinery_

Disposal of plant and machinery (after-tax value)._

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Divestment of proj ect to PE firm

 

 

 

 

i

 

 

 

 

 

I
I

Forecasted cash flows

 

 

 

 

 

 

 

 

 

 

 

Discount rate

 

 

 

 

 

 

 

 

 

 

 

Netpresent value

 

 

 

 

 

Question 3

Apply sensitivity analysis to evaluate the effect on net present value for the following situations. Compute the NPV respectively for 3 scenarios:

Scenario I: Fixed overhead costs in per annum is 20% higher than expected and will increase by 5.0% per year after the first year.

Forecasted Cash Flows

 

 

 

 

 

 

 

 

 

 

 

Year

0

I

2

3

4

 

 

 

 

 

 

Sales

 

 

 

 

 

Direct cost

 

 

 

 

 

Gross profit

 

 

 

 

 

Fixed overhead cost     

 

 

 

 

 

Depreciation

 

 

 

 

 

EBIT

 

 

 

 

 

Tax @ 17%

 

 

 

 

 

Net income I (loss)

 

 

 

 

 

 

 

 

 

 

 

Operating cash flow

 

 

 

 

 

 

 

 

 

 

 

Working capital (WC) _nuked

 

 

 

 

 

Cash flow impact of WC

 

 

 

 

 

Feasibilitystudy Acquisition of premise

 

 

 

 

 

 

 

 

 

 

 

 

 

Purchase of plant and machinery

 

 

 

 

 

Disposal of plant and machinery (after-tax value)

 

 

 

 

 

Divestment of project to PE farm

 

 

 

 

 

 

 

 

 

 

 

Forecasted cash flows

 

 

 

 

 

 

 

 

 

 

 

Discount rate

 

 

 

 

 

 

 

 

 

 

 

Net present value

 

 

 

 

 

(ii) Scenario 2: Working capital required is 25.0% of the anticipated sales revenue for the year.

Forecasted Cash Flows

 

 

 

 

1
]

 

 

 

 

Year

0

1

2

3

4

 

 

 

 

 

 

Sales

 

 

 

 

 

Direct cost

 

 

 

 

 

Gross profit

 

 

 

 

 

Fixed overhead cost

 

 

 

 

 

Depreciation

 

 

 

 

 

EDIT

 

 

 

 

 

Tax c  17%

 

 

 

 

 

Net income / (loss)

 

 

 

 

 

 

 

 

 

 

 

°La:rating cash flow

 

 

 

 

 

 

 

 

 

 

Working capital (WC) required

 

 

 

 

 

Cash flow impact of WC

 

 

 

 

 

 

 

 

 

 

 

Feasibility study Asuisition of premise Purchase of plant and machinery

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Disposal of plant and machinery (after-tax value)

 

 

 

 

 

Divestment of project to PE firm

 

 

 

 

 

 

 

 

 

 

 

Forecasted cash flows

 

 

 

 

 

 

 

 

 

 

 

Discount rate

 

 

 

 

 

 

 

 

 

 

 

Net present value

 

 

 

 

 

(iii) Scenario 3: At the end of the fourth year, salvage value of plant and machinery is $100,000 and divestment of project to private equity firm is 10% lesser than originally anticipated.

Forecasted Cash Flows

 

 

 

 

 

 

 

 

 

 

 

Year

I

0

1

2

3

4

 

 

 

 

Sales

i

 

 

 

Direct cost

 

 

 

 

Gross_p_rofit

Fixed overhead cost

 

 

 

 

 

 

 

 

 

Depreciation

 

 

 

 

 

EBIT

 

 

 

 

 

Tax all%

 

 

 

 

Net income / (loss)

 

 

 

 

 

 

 

 

 

 

Operating cash flow

 

 

 

 

 

 

 

 

 

 

 

Working capital (WC) required

 

 

 

 

 

Cash flow impact of WC

 

 

 

 

 

 

 

 

 

 

 

Feasibility study

 

 

 

 

 

Asuisifion of premise

 

 

 

 

 

Purchase of plant and machinery

 

 

 

 

 

Disposal of plant and machinery (after-tax value)._

 

 

 

 

 

Divestment of project to PE firm

 

 

 

 

 

 

 

 

 

 

 

Forecasted cash flows

 

 

 

 

 

 

 

 

 

 

 

Discount rate

 

 

 

 

 

 

 

 

 

 

 

Net present value

 

 

 

 

 

Reference no: EM13128010

Questions Cloud

Retailers-consumers have right to complain to manufacturers : On the basis of these results, do you think retailers and consumers have a right to complain to the manufacturers? Why?
Derivatives and trigonometric functions : Differentiate the functions. y = (square root cos (square root x))
Illustrate what is the minimum transfer price : Top management of PFC International would like the Heating Division to transfer 15,000 heating units to another division within the company at a price of $29. The Heating Division is operating at full capacity. Illustrate what is the minimum transf..
Different measures for a balanced scorecard : Do you believe variance analysis is a good gauge for managers to keep controls over poor quality materials, excess material usage, excess labor usage, etc....? Also, why would different companies have different measures for a balanced scorecard?
Compute the future cash flows : Compute Koda's weighted average cost of capital WACC and compute the future cash flows associated with the manufacturing of mobility vehicles and the net present value (NPV) of the project by filling in the blanks in the table below. Advise whether..
Basic differenitation formulas : Use the definition of the derivative to find the derivatives of the following functions: Use the definition of the derivative to write out the derivative of h(x) where h(x)=f(x) + g(x). Can you rearrange the terms to write this in terms of the deri..
How fast does molecule of nitrogen travel : A molecule of N2 in air travels at about 1000 ft/sec. If the supersonic transport Concorde travels at 1500 miles/hour, how fast does it travel in ft/sec? (1 mile = 5280 ft)
Illustrate what was its budgeted markup percentage : Illustrate what was its budgeted markup percentage using a full cost approach?
Probability that sample mean for thirty days is in range : Suppose a simple random sample of 30 days is selected for observation. What is the probability that the sample mean for the 30 days will be between 300 and 340 books?

Reviews

Write a Review

Financial Management Questions & Answers

  What is the bond''s nominal yield to call

Calculate the YTM and YTC under those conditions, what is your stock's intrinsic value and what is the WACC - What is the bond's nominal yield to call?

  Determine the cost of equity based on capm

Determine the cost of equity based on CAPM? Compute the firm's WACC? Estimate the cash flow for each year of this project

  Weighted average cost of capital

Compute Western Communications' after-tax weighted average cost of capital

  Why should a firm invest its idle cash

Why should a firm invest its idle cash? How to invest the idle cash and what's credit management? What's the optimal credit policy?

  Capital budget methods

What is the project's NPV?

  Limiting the significant growth of a sole proprietorship

Short Answer and Short Problems,  Briefly discuss the most important factors limiting the significant growth of a sole proprietorship or partnership?

  Failure of financial institutions

Find an article about all of the problems that occurred due to the failure of financial institutions to obtain and retain notes and mortgages, leading to the inability of financial institutions to foreclose on property

  What is the current value of vandells stock

What is the current value of Vandell's stock and what profit or loss would Security Brokers incur if the issue were sold to the public at the following average price?

  Prepare the statement of comprehensive income

Prepare the statement of comprehensive income and changes in equity

  Prepare the financial statements

Prepare a three page paper that responds to the coca-cola research case questions Using the web, access the Coca-Cola Company's 2010 financial statements

  Report on a company providing a clear audit trail

Prepare report on providing a clear audit trail to your company.  Prepare a portfolio of analytical reference materials including the financial reports for at least five years. This is your analytical permanent file for the chosen company.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd