ANALYZE REFRIGERATOR TOOLING INVESTMENT LIVIA MODEL AT PT LG ELECTRONICS INDONESIA

For a large firm like PT LG Electronics Indonesia (LGEIN), which has resulted in high manufacturing utilization, require a few percent reductions in component prices every year. The one of potential project for cost reduction is tooling investment. After Livia is produced and the expenditure of new tooling is made, it is continually faced with the problem that current method computing profits are conventional without considering the expenditure of tooling in the long run. Finally, a firm’s capital budgeting decisions is needed because it defines its strategic direction. Four primary methods in the capital budget to decide whether or not the project should be accepted are: discounted payback, net present value, internal rate of return and profitability index. In addition, we use sensitivity analysis to indicate which factor has significant interfere with the project. The results generated that discounted payback is just 2 year 6 months less life of the project for 3 years, NPV generated positive result $3,502,387, and an IRR of this project is 25% greater than required rate of return 10% and profitability index gets 1.8 greater than 1. In sensitivity analysis shows that the project’s NPV is very sensitive to changes in sales and COGS, and relatively insensitive to changes in either growth rate or rate of return. In a method of capital budgeting analysis, Livia project could be accepted with initial investment for $4,199,288 and still more detailed analysis is required to support the expenditure.


Background
The global company especially LG Electronics Indonesia (LGEIN) has grown substantially in the last few years that have resulted in high manufacturing utilization.Inflation in the customer price indices however has remained below the historical average.Perhaps this contradictory behavior is due to attempts of original equipment manufacturers to contain or even reduce product cost.It is not unusual, for instance, for a large firm to require a few percent reductions in component prices every year.If the firm doesn't meet their demands, the customer goes elsewhere.As such, the firm is witnessing continued pressure to reduce part costs.The part production cost is a function of material utilization, machine requirements, energy consumptions, cycle time, labor charges and production yields.Since product cost is based on multiple factors, there are several approaches towards cost reduction that can and should be pursued.The one of potential project for cost reduction is tooling investment.Examples of projects include investments in plant, and equipment (tooling, machinery), research and development projects, large advertising campaigns or any other project that requires a capital expenditure and generates a future cash flow.

Problem Description
The manufacturing industry is highly capital-intensive.It entails large, irreversible investment in plant and equipment (tooling, machinery).Typically, these investments are characterized by long lead times, long operating lives and matching pay off periods.
The production of a new product (model) or part has to take different steps in LGEIN before it is determined where to produce it.When launching a new refrigerator product for premium model (GN-M/B 492, 562, 602) on July 2007 which is named Livia, the Business Area, LG Electronics Indonesia, holds the main responsibility.Expansion into new products like Livia is relatively complex to make decision for investment and so, detailed analysis is necessary before the decision could be taken.Each new part for the plastic of injection surely requires the new mold so that by dozens expense for the investment of the mold.But not all new part of plastic injection uses the mold newly but there is some tooling which is delivering Korean.
After Livia was took over from LGECW (Korea) to LGEIN (Indonesia), it is continually faced with the problem of deciding whether new parts from new model should be imported or localized.Since the managers of the firm decided to localized, current accounting profits as conventionally computed, only compare price part by part (import to local) which one is the cheapest without considering the expenditure of tooling in the long-run.

OVERVIEW OF BASIC THEORIES Capital Budgeting Decision Rules
Four primary methods are used to rank projects and to decide whether or not they should be accepted for inclusion in the capital budget: (1) discounted payback, (2) net present value (NPV), (3) internal rate of return (IRR), and (4) profitability index (PI).

Discounted Payback
The discounted payback period, which is similar to the regular payback period except that the expected cash flows are discounted by the project's cost of capital.A project's cost of capital reflects the overall cost of capital to the firm and the differential risk between the firm's existing projects being evaluated.Thus, the discounted payback period is defined as the number of years required to recover the investment from discounted net cash flows.Instead of computing the length of time required to recover the original investment, some analyst compute the length of time required to generate cash flows until the present value turns from being negative to positive.If the life of the asset exceeds this break-even life, the asset will have a positive present value.The discounted payback period can be used to make independent investment decisions, since any investment with a discounted payback period less than its life will at least earn the required return.Both the payback and discounted payback methods for determining value of capital projects are inconsistent with our criteria.Although occasionally employed in industry as a thumbnail measure of a project's value, neither is consistent or fully acceptable for evaluating capital projects.

Net Present Value (NPV)
Net present value (NPV) method, which relies on discounted cash flow (DCF) methodology.To implement this approach, we proceed as follows: 1. Find the present value of each period's net cash flow, including both inflows and outflows, discounted at the project's cost of capital.2. Sum these discounted net cash flows; this sum is defined as the project's NPV. 3. If the NPV is positive, the project should be accepted.If the NPV is negative, it should be rejected.And if two projects are mutually exclusive, the one with the higher positive NPV should be chosen.The NPV is found using this equation: Where t = the time of the cash flow n = the total time of the project r = the discount rate C t = the net cash flow (the amount of cash) at time t C 0 = the capital outlay at the beginning of the investment time ( ) Cash outflows (expenditures on the project, such as the cost of buying equipment or building factories) are treated as negative cash flows.Inflows and outflows could occur on any time basis, quarterly and monthly, in which case t would represent quarters or months rather than years.

Internal Rate of Return (IRR)
The IRR is defined as that discount rate which equates the present value of a project's expected cash inflows to the present value of the project's expected costs or, equivalently, forces the NPV to equal zero: Notice that the IRR formula is simply the NPV formula, solved for the particular discount rate that forces the NPV to equal zero.Thus, the same basic equation is used for both methods, but in the NPV method the discount rate, k is specified and the NPV is found, whereas in the IRR method the NPV is specified to equal zero, and the value of IRR that forces this equality is determined.

Profitability Index
Another method used to evaluate projects is the profitability index (PI).The ratio is calculated as follows: Here CF t represents the expected future cash flows, and CF 0 represents the initial cost.The PI shows the relative profitability of any project, or the present value per dollar of initial cost.

Cash Flows Estimation
The most important, but also the most difficult, step in capital budgeting is estimating project's cash flows-the investment outlays and the annual net cash inflows after a project goes into operation.

Identifying the Relevant Cash Flows
The starting point in any capital budgeting analysis is identifying the relevant cash flows, defined as the specific set of cash flows that should considered in the decision at hand.Analysts often make errors in estimating cash flows, but two cardinal rules can avoid mistakes: (1) Capital budgeting decisions must be based on cash flows, not accounting income.(2) Only incremental cash flows are relevant.Recall that free cash flow is calculated as follows: =

Incremental Cash Flows
In evaluating a project, we focus on those cash flows that occur if and only if we accept the project.These cash flows, called incremental cash flows, represent the change in the firm's total cash flow that occurs as a direct result of accepting the project.As noted previously, in capital budgeting our concern is with those cash flows that result directly from the project, or projects incremental cash flows.Three special problems can occur when estimating incremental cash flows: 1. Sunk cost.Sunk costs are not incremental costs, so they should not be included in capital budgeting analysis.A sunk costs refers to an outlay that has already occurred (or been committed), so it is an outlay that is not affected by the accept/reject decision under consideration.
2. Opportunity costs.The second potential problem relates to opportunity costs.All relevant opportunity costs should be included in a capital budgeting analysis.For example if the company decides to use some land it owns for a new facility, the market value of that land should be included as a cost for the facility because the land could be sold.If the land were sold it would produce a positive cash flow to company.3. Effects on other projects.The third problem involves the effects of the project being considered on the firm's other projects.For example, Nike comes out with a new tennis shoe that competes with Nike's other shoes.In analyzing the sales for the new shoe, the incremental (new) sales the shoe is expected to generate should be considered.

Tax Effects (MACRS)
Taxes can have a major impact on cash flows, and in many cases tax effects can make or break a project.Therefore, it is critical that taxes be dealt with correctly in capital budgeting decisions.However as financial analysts, we encounter two problems: (1) the tax laws are extremely complex, and (2) these laws are subject to interpretation and to change.The financial staff can get assistance from the firm's accountants and tax lawyers, but even so, it is necessary for financial analysts to have a working knowledge of the current tax laws and their effects on cash flows.For tax purposes, Congress changes the permissible depreciation methods from time to time.
Prior to 1954 the straight line method was required for tax purposes, but in 1954 accelerated methods (double declining balance and sum-of-years'-digits) were permitted.Then, in 1981, the old accelerated methods were replaced by a simpler procedure known as the Accelerated Cost Recovery System (ACRS).The ACRS system was changed in 1986 as a part of the Tax Reform Act, and it was now called the Modified Accelerated Cost Recovery System (MACRS).
A major effect of the MACRS system has been to shorten the depreciable lives of assets, thus giving business larger tax deductions and thereby increasing their cash flows available for new investment.Table 1.describes the types of property that fit into the different class life groups, and Table 2. sets forth the MACRS recovery allowances (depreciation rates) for the various classes of investment property.

Sensitivity Analysis
Intuitively, we know that many of the variables that determine a project's cash flows could turn out to be different from the values used in the analysis.We also know that a change in a key input variable, such as units sold, will cause the NPV to change.Sensitivity analysis is a technique that indicates how much NPV will change in response to a given change in an input variable, other things held constant.Sensitivity analysis begins with a base-case situation, which is developed using the expected values for each input.In a sensitivity analysis, each variable is changed by several percentage points above and below the expected value, holding all other variables constant.Then a new NPV is calculated using each of these values.Finally, the set of NPVs is plotted to show how sensitive NPV is to changes in each variable.Intuitively, we know that many of the variables that determine a project's cash flows could turn out to be different from the values used in the analysis.We also know that a change in a key input variable, such as units sold, will cause the NPV to change.Sensitivity analysis is a technique that indicates how much NPV will change in response to a given change in an input variable, other things held constant.Sensitivity analysis begins with a base-case situation, which is developed using the expected values for each input.In a sensitivity analysis, each variable is changed by several percentage points above and below the expected value, holding all other variables constant.Then a new NPV is calculated using each of these values.Finally, the set of NPVs is plotted to show how sensitive NPV is to changes in each variable.

Required Rate of Return
We know that systematic risk is the only relevant risk-the rest can be diversified away, and the required rate of return equals the risk-free rate plus risk-premium.We can now put this element together to estimate required rates of return.The finance profession has had difficulty in developing a practical approach to measure the investor's required rates of return; however, financial managers often used a method called the capital asset pricing model (CAPM).The capital asset pricing model is an equation that equates the expected rate of return on a stock to the risk-free rate plus a risk-premium for the stock's systematic risk.Although not without its critics, the CAPM provides an intuitive approach for thinking about the return that investor should require on an investment, given the asset's systematic or market risk.Equation above provides the natural starting point for measuring the investor's required rate of return and sets up to use the CAPM.Rearranging this equation to solve for the risk premium Which simply says that the risk premium for a security ( rp k ), equals the security's expected return, k less the risk-free rate existing in the market.
In the same market, a security with a beta of 2 should provide a risk premium of 16 percent, or twice the 8 percent risk premium existing for the market a whole.Hence, in general, the appropriate required rate of return for the j th security, j k should be determined by ) ( Once sales have been forecasted, we must forecast future balance sheets and income statements.The most commonly used technique is the percent of sales method, which begins with the sales forecast, expressed as an annual growth rate in dollar sales revenues.Many items on the income statement and balance sheets are assumed to increase proportionally with sales, with their values for a particular year estimated as percentages of the forecasted sales for that year.The remaining items on the forecasted statements items that are not tied directly to sales-depend on the company's dividend policy and its relative use of debt and equity financing.

Forecast the Income Statement
In this section we explain how to forecast the income statement, and in the following section we forecast the balance sheet.Although we cover these topics in two separate sections, the forecasted financial statements are actually integrated with one another and with the previous year's statements.For example, the income statement item "depreciation" depends on net plant and equipment, which is a balance sheet item, and retained earnings, the forecasted net income, and the firm's dividend policy.

Forecast the Balance Sheet
Before going into the details of forecasting balance sheets, let's take a look at the big picture.First, a firm must have assets to support the sales as forecasted on the income statement, and if sales are growing, then assets typically must also grow.Second, if assets are to grow, then the firm must obtain funds to purchase the new assets.Third, the needed funds can come from internal sources, mainly as reinvested earnings, or externally, from the sale of short-term investments, from new loans (either notes payable or long-term bonds) from new stock issues or by increasing operating current liabilities, mainly accounts payable or accruals.Here are the steps: (1) determine the amount of new assets needed to support the forecasted sales, (2) determine the amount of internal funds that will be available and (3) plan to raise any required additional financing.

Financial Ratio Analysis
Financial ratio helps us identify some of the financial strengths and weakness of the firm.The ratios give us two ways of making meaningful comparison of a firm's financial data.1.We can examine the ratios across time to identify any trends.2. We can compare the firm's ratios with those of other firms.Mathematically, a financial ratio is nothing more than a ratio whose numerator and denominator are comprised of financial data.The objective in using a ratio when analyzing financial information is simply to standardize the information being analyzed so that comparisons can be made between ratios of different firms or possibly the same firm at different points in time.
In learning about ratios, we could simply study the different types or categories of ratios, or we could use ratios to answer some important questions about a firm's operations.We prefer the latter approach and choose the following four questions as a map in using financial ratios: 1.How liquid is the firm? 2. Is management generating adequate operating profits on the firm's assets?3. How is the firm financing its assets?4. Are the owners (stockholders) receiving an adequate return on their investment?

METHODOLOGY
For survival in the face of competition, for growth and development a firm needs a constant flow of ideas for new products and ways to make existing products better or at a lower cost.With imaginative executives and employees, many ideas for capital investment will be advanced.Since some ideas will be good ones, procedures must be established for screening projects.Moreover, a well managed firm will go to great lengths to develop good capital budgeting proposals e.g. a sales representative may report that customers are asking for a particular product which the company is not producing now, the sales manager will discuss the idea with the marketing research group to determine the market size for the proposed product.If a substantial market does exist, cost accountant and engineers will estimate production costs.If it is appears that the product can be produced and sold to yield a sufficient profit, the project will be undertaken.
Capital budgeting is a multi-faced activity.There are several sequential stages in the process.For typical investment of a large firm, the distinctive stages in the capital budgeting process are depicted in the form of a highly simplified flow chart, in Figure 1 & 2 :

ANALYSIS Data & Assumptions and Initial Investment
In this chapter, we illustrate all cash flow analysis by examining capital budgeting decision that faces LGEIN, refrigerator plant.LGEIN's research and development (R&D) department has been applying its expertise to develop a premium model of refrigerator.This project has now reached the stage where a decision on whether to go forward with production must be made.
LGEIN believes that monthly net sales would be 30,000 units and the refrigerator sales at $18,925,000.The firm would need a new tooling which could be made and ready for production after the "go" decision is made.The project would also require an initial investment equal to $4,199,288 and estimated economic life is three years.Net sales are projected to increase which is expected to average 10 percent per year over the 3-year life of the project.

Assumptions
This section provides the basic data used in the analysis.The inputs are really "assumptions".a. Exchange rate.
We are using IDR 9,050 covert to USD, which we obtain from middle Bank of Indonesia July 2007.This rates will used for next calculation.b.Inflation.
We are using 6.5% inflation get from December 2007 inflation c.Growth rate Estimated growth 10 percent for 3 years period of time project in net sales d.In the analysis we assume that 5,000 set/month for GN-M/B602, 10,000 set/month for GN-M/B562 and 15,000 set/month for GN-M/B492 can be sold at a price $724, $671, $573 each model.e.Some of the inputs in selling and administrative expense are known with near certainty, for example transportation, 5 percent from net sales, maintenance 2 percent from net sales, campaign 3 percent from net sales, SPG/SPM 2 percent from net sales are not likely to change.

Financial Statement Forecasting
In the following sections we explain the percent of sales method and use it to forecast LGEIN's financial statements.

Forecast the Income Statement
In this section we explain how to forecast the income statement, and in the following section we forecast the balance sheet.Although we cover these topics in two separate sections, the forecasted financial statements are actually integrated with one another and with the previous year's statements.For example, the income statement item "depreciation" depends on net plant and equipment, which is a balance sheet item, and retained earnings, the forecasted net income, and the firm's dividend policy.
1. Forecast sales Table 1 shows the forecasted income statement.Management forecasts that sales will be grow by 10 percent.Thus, forecasted sales, shown in Row 1, Column 3, is the product of $94,620,166(1.10)= $104,082,182.

Forecast earnings before interest and taxes (EBIT)
Table 1 shows that LGEIN's ratio of costs to sales for most recent years was 56 percent ($52,881,754/$94,620,166 = 0.56).Thus, to get a dollar of sales, LGEIN had to incur 56 cents of costs.Initially, we assume that the cost structure will remain unchanged.Later on, we explore the impact of changes in the cost structure, but for now we assume that forecasted costs will equal 56 percent of forecasted sales.The depreciation to tooling equipment we are using MACRS depreciation.

Depreciation
The tooling would fall into the MACRS 3-year class, and it would cost $4,199,288.
The depreciation amounts were obtained by multiplying each asset's depreciable basis by MACRS recovery allowance rates set forth in Forecast the Balance Sheet Before going into the details of forecasting balance sheets, let's take a look at the big picture.First, a firm must have assets to support the sales as forecasted on the income statement, and if sales are growing, then assets typically must also grow.Second, if assets are to grow, then the firm must obtain funds to purchase the new assets.Third, the needed funds can come from internal sources, mainly as reinvested earnings, or externally, from the sale of short-term investments, from new loans (either notes payable or long-term bonds) from new stock issues or by increasing operating current liabilities, mainly accounts payable or accruals.
1. Forecast operating assets As noted earlier, LGEIN assets must increase if sales are increase too.The firm's most recent ratio of accounts receivable to sales was 20 percent ($18,924,033/$94,620,166 = 0.20) and we believe this ratio should remain constant.Therefore, the forecasted accounts receivable in 2008, shown in The most recent inventory to sales ratio was $9,726,977/$94,620,166 = 0.1 = 10 percent.Assuming no change in LGEIN's inventory policy, the forecasted inventory is 0.1($104,082,182) = $10,699,675.Next we make the temporary assumption that tools and equipment will remain at their current level.

Forecast operating current liabilities
As noted earlier, operating current liabilities are called spontaneously generated funds because they increase automatically, as sales increase.
LGEIN's most recent ratio of foreign currency short-term borrowings to sales was $13,646,933/$94,620,166 = 0.14 = 14 percent.In its initial financial plan, LGEIN kept short-term borrowings at the 2007 level.

Raising the additional funds needed
Based on the forecasted balance sheet, LGEIN will needed $50,552,723 of operating assets to support is forecasted $94,620,166 of sales.We define specified sources of financing as the sum of forecasted levels of interdivision account.Based on its required assets and specified sources of financing, LGEIN's AFN is $61,936,604 -$60,766,417 = $1,170,187.Because the AFN is positive, LGEIN needs $1,170,187 of additional financing, and its initial financial policy is to obtain these funds as interdivision account.Therefore, we add $1,170,187 into interdivision account, bringing the forecasted total to $12,639,918 + $1,170,187 = $13,465,778.Determining Free Cash Flows The first step in analysis is to forecast the cash flows that will occur once production begins; these are set forth in Table 4.The operating cash flow estimates are based on information provided by LGEIN's various departments.Note that the sales price is projected to increase each year by 10 percent.
To compute LGEIN free cash flow, we must add back to earnings the depreciation expense for the equipment (a non-cash charge) and subtract the actual capital expenditure that will be paid for the equipment in year 0.
Working capital is also an important part of a cash flow analysis.It is defined as the amount of money needed to facilitate business operations and transactions, and is calculated as represent the additional investments required to support sales increase (10 percent of the next year's sales increase) during 2007-2008, and the recovery of the cumulative net working capital investment in 2009.For example, sales in 2008 are $9,462,017 over 2007 sales, so the addition to NWC in 2007 required to support 2008 sales is 0.1($9,462,017) = $946,202.The cumulative working capital investment is recovered when the project ends in 2009.Computing the amount of working capital gives us a quick analysis of the liquidity of the business over the future accounting period.The depreciation amounts were obtained by multiplying each asset depreciable basis by the MACRS recovery allowance rates set forth in Table 3.
The analysis also requires an estimation of the cash flows generated by salvage values.Table 3 summarizes this analysis.The indicated percentages are multiplied by the depreciable basis 0.33($4,199,288) = $1,385,765.Ending book value we obtain by subtracting initial investment $4,199,288 with tooling depreciation $839,858 equals to $2,813,523.Book value equals depreciable basis (initial investment) minus accumulated MACRS depreciation.For the tooling, accumulated depreciation equals $3,905,338, so book value equals $4,199,288 -$3,905,338 = $293,950.The tax computed as follows: Net cash flow from salvage equals salvage (market) value minus taxes.For the tooling, net salvage value = $209,964 -($27,129) = $237,094.Next in Table 4, we use the information developed in Table 1 to table 4.53 to find the projected cash flows over the project's life.Three periods are shown, from year 2007 to 2009.Taxable operating income (EBIT) we were obtained from Table 1 projected income statements for each year.When taxes (from Table 1) are subtracted, we are left with net operating profit after taxes, or NOPAT.Note, though, that we are seeking cash flows, not accounting income.Thus, depreciation must be added back.
LGEIN must purchase raw materials and replenish them each year as they are used.In investment NWC, we assume that LGEIN must have an amount of NWC on hand equal to 10 percent of the upcoming year's sales.For example, sales in 2007 is $18,924,003, so LGEIN must have 0.1($9,462,017) = $946,202 in NWC at year 2007.Recall that free cash is calculated as follows: = Net Operating Profit After Taxes (NOPAT) + depreciation -change in networking capital To calculate the risk-free rate, we need to get the data about inflation rate as shown in Table 5. Discounted Cash Flow Method Four primary methods are used to rank projects and to decide whether or not they should be accepted for inclusion in the capital budget: (1) discounted payback, (2) net present value (NPV), (3) internal rate of return (IRR), and (4) profitability index (PI).

Discounted payback
Discounted payback is almost the same as payback, but before we figure it, we first discount the free cash flows.Why?Because it is money we will get in the future, and will be less valuable than money today.An IRR of 25% means we make 25% profit per year on the money invested in the project.

Probability Index
The PI shows the relative profitability of any project, or the present value of benefits per present value dollar of costs.The PI for project, based on 10% required rate of return is 1.8.For every dollar borrowed and invested we get back $1 8 cents.This project is acceptable if its PI is greater than 1.0.Therefore, this project would be accepted by the PI criterion.

Sensitivity Analysis
Sensitivity analysis begins with a base-case situation, which is developed using the expected values for each input.To illustrate, consider the data given back in Table 6, where projected cash flows for LGEIN were shown.This values used to develop the table, including sales price, required rate of return, cost of goods sold, growth rate, are all most likely, or basecase, values and the resulting $3,502,387 NPV shown in Table 10 is called the base-case NPV.Now we ask a series of "what if" questions:"what if sales price fall 15 percent below the most likely level.""What if the cost of goods sold falls?" In a sensitivity analysis, each variable is changed by several percentage points above and below the expected value, holding all variables constant.Then a new NPV is calculated using each of these values.Finally, the set of NPVs is plotted to show how sensitive NPV is to changes in each variable.Figure 3 shows the Livia's project sensitivity graph for four of the input variables.The table above the graph gives the NPVs that were used to construct the graph.The slopes of the lines in the graph show how sensitive NPV is to changes in each of the inputs: the steeper the slope, the more sensitive the NPV is to a change in the variable.From the figure and the table, we see that the project's NPV is very sensitive to changes in the sales price and COGS and not very sensitive to changes in either growth rate or rate of return.-30% -15% 0% 15% 30%

Rate of return
Growth rate

Financial Ratio Analysis
Financial ratio helps us identify some of the financial strengths and weakness of the firm.In addition to ratio analysis, we use ratios to compare related items from the financial statements.We will calculate the year 2007 to 2011 financial ratios for LGEIN, using data from balance sheets and income statements given in Table 3 and 4.4 we will also evaluate the ratios in relation to the industry averages that obtained from the risk management association (www.rmahq.org)for Electronic industry electrical equipment and household appliances.It can be grouped into the categories below:

Figure 1 .
Figure 1.The Distinctive Stages in The Capital Budgeting Process

Table 1 .
Major Classes and Asset Lives for MACRS

Table 2 .
MACRS recovery Allowance Percentages for Personal Property

Table 3 4
. Completing the income statement Earnings before taxes (EBT) are calculated by subtracting interest from EBIT, and then we deduct taxes.The tax is computed as follows:Thus, LGEIN's forecasted net income in 2007 is $3,836,297, by subtracting the EBT and taxes.

Table 1 .
Projected Income Statement

Table 2 .
Projected Balance Sheet

Table 3 .
Net Salvage Values in 2009

Table 4 .
Calculation of Free Cash Flow for LGEIN We shall use the term time value of money to describe the required rate of return that can be used to compute present values.Before we determine the required rate of return, we first need to know about Bank of Indonesia rate and inflation.Based on the Bank of Indonesia rate, we will use 8 percent by the end of 2007.

Table 5 .
Inflation Rate

Table 6 .
Calculation for DP illustration of Investment in New Tooling NPV) is the final running total number.Basically, NPV and discounted payback are the same idea, with slightly different answer.Discounted payback is a period of time, and NPV is the final dollar amount we get by adding all the discounted cash flows together.If the NPV is positive, then approve the project.It shows that we are making more money on the investment than we are spending on required rate of return.If NVP is negative, then do not approve the project because we are paying more in interest on the borrowed money than we are making from the project.

Table 7 .
Calculation for NPV illustration of Investment in New Tooling Internal Rate of Return IRR is the amount of profit we get by investing in a certain project.It is a percentage.IRR can be calculated with financial calculators and computers.As shown in Table8, IRR is 25%.The decision criterion is this: accept the project if IRR greater than or equal to the required rate of return.We reject the project if its IRR is less than this required rate of return.This accept-reject criterion can be stated as: IRR > required rate of return: Accept IRR < required rate of return: Reject Since the IRR project is 25%, we accept the project.

Table 8 .
Calculation for IRR illustration of Investment in New Tooling

Table 9 .
Calculation for PI illustration of Investment in New Tooling

Table 11 .
Table 11 summarizes LGEIN's financial ratios.As the table indicates, the company has many problems.LGEIN, Ratio Analysis PT