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

  Individual rehabilitation services (irs)

Individual Rehabilitation Services (IRS), Determine the minimum federal income tax liability and the taxes owed at the time of filing based on the following data:

  Financial statement analysis

Prepare income statements and vertical common-size balance sheets for both companies - Prepare ratio analyses

  Financial decision-making techniques

Complete a project that helps you apply theoretical knowledge of financial planning to practical applications. It is a proven fact that learning by doing is more effective than reading theory.

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Monitor expenditure and compare with financial plan

Report and monitor expenditure and compare with financial plans so that recommendations are developed for key stakeholders.

  Requirement for a code of ethics in the civil service

Requirement for a Code of Ethics in the Civil Service

  Change in bond price as the market yield changes

What is the Modified Duration of this bond when the market yield is at YTM and explain why and when Modified Duration under-predicts and over-predicts the change in bond price as the market yield changes.

  International finance problem

International Finance Problem

  Evaluate the required monthly mortgage payment

Evaluate the required monthly mortgage payment for Mr. Davidson and construct the 2014~2018 amortization table for Mr. Davidson.

  Financial analysis for managers

ou will also be expected to carry out horizontal analysis on the Income Statement using (2010 as base) and vertical common size analysis on the Statement of Financial Position (Balance Sheet) for 2 year.

  Draw up balance sheet and income statement

Draw up balance sheet and income statement.

  What is the firms cost of preferred stock

What sources of capital should be included when you estimate XYZ's WACC? and Should the component costs be estimated on a before or after-tax basis? Why?

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