StudentShare solutions

# Capital Budgeting: Cash Flow Estimation and Risk Analysis - Assignment Example

## Extract of sample Capital Budgeting: Cash Flow Estimation and Risk Analysis

NPV method has certain drawbacks and limitations. Different projects must be assessed at different discount rates because the risk for each project is generally different. The reliability of the NPV based investment appraisal can be as reliable as the discount rate itself. However, in practice, it is very unrealistic to determine different discount rate for different investment proposals. Whereas, IRR uses a single discount rate to evaluate every investment, due to which it is used extensively among the financial analysts. Following is the mathematical computation of the NPV, IRR and MIRR of the proposed investment Particulars Year Now 1 2 3 4 Sales - 250,000 257,500 265,225 273,182 Cost of sales - (125,000) (128,750) (132,613) (136,591) Depreciation Charges - (79,200) (108,000) (36,000) (16,800) Profit before tax - 45,801 20,752 96,616 119,795 Taxation - (18,320) (8,301) (38,646) (47,918) Profit after tax - 27,481 12,451 57,969 71,877 Depreciation Charges (added back) - 79,200 108,000 36,000 16,800 Rent forgone - (20,000) (20,000) (20,000) (20,000) Working Capital (30,000) (900) (927) (955) 32,782 Sale proceed from disposal of asset - - - - 25,000 Capital expenditure Invoice amount (200,000) - - - - Shipping charges (10,000) - - - - Installation charges (30,000) - - - - Net Cash flow (270,000) 85,781 99,524 73,014 126,459 Present value factor 1 0.9091 0.8264 0.7513 0.6830 Present Value (270,000) 77,982 82,251 54,857 86,373 Net present value 31,464 IRR 15% MIRR 13% As apparent from the above initial investment appraisal analysis, the project appears to be lucrative and feasible as the Net present value is positive and the Internal rate of return and the marginal rate of return is both higher than the cost of capital of the company. It is also of prime importance to perform a sensitivity analysis on any investment appraisal in order to analyze how sensitive is the profitability of the project is to the variables of the project. Sensitivity Analysis Unit Sales Variation Plus 10% Minus 10% NPV 106,379 7,266 Salvage Value Variation Plus 20% Minus 20% NPV 60,238 20,000 Cost of capital Variation Plus 30% Minus 30% NPV (91,978) 593,097 Following is the graphical representation of the sensitivity analysis Change in unit sales Change in sale proceeds on disposal Change in discount rate As apparent from the above analysis, the project is not so much sensitive to the change in the unit sales. However, the most sensitive variable in the investment appraisal of this project is the discount rate a variation in which is likely to result in drastic change in the net present value of the project. The following tabular information also presents the percentage change by which if all of the three variables under consideration increases or decreases, the NPV would be negative and the project would not br worthwhile taking. Unit Sales 13.76% Sales Proceeds 3.33 times Discount rate 19.00% In order to account for various probabilities, it is also advisable to undertake a probability analysis considering various scenarios. Worst Case Particulars Year Now 1 2 3 4 Sales - 144,000 148,320 152,770 157,353 Cost of sales - (90,000) (92,700) (95,481) (98,345) Depreciation Charges - (79,200) (108,000) (36,000) (16,800) Profit before tax - (25,199) (52,378) 21,292 42,211 Taxation - 10,080 20,951 (8,517) (16,885) Profit after tax ...Show more

## Summary

The following report presents the investment appraisal of new expansion plan of the company Target. For the purpose of initial evaluation, the NPV and IRR technique has been utilized. Investment appraisal through NPV method and IRR method are both very useful in order to financially attractive prospective of any investment decision…
Author : harbergene
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Capital Budgeting: Cash Flow Estimation and Risk Analysis"
with a personal 20% discount.
Grab the best paper

### Check these samples - they also fit your topic

CASH FLOW
The Home Depot There is an increase in the amount of cash and cash equivalents in 2011 of \$1,474M compared to 2010. The increase has come entirely from operating activities (6,651M) while investing and financing activities have contributed to decreases in cash and cash equivalents.
3 pages (750 words) Assignment
Capital Budgeting Individual Project
However, the decision taken by the stakeholders must have relevant information. Decision making is regarded as successful depending on its ability to sort through all of the data and information to find the appropriate data to make the best decision. Good information must make a difference in a decision and it must also be future oriented (Dayananda, 2002).
8 pages (2000 words) Assignment
Capital Budgeting
Based on what you have learned about capital budgeting, would this be a profitable investment over the next five years? Since all the techniques relevant to capital budgeting are indicative of viability of
2 pages (500 words) Assignment
Cash Flow
An accounting profit does not necessary mean a positive cash flow for the company, and since it is a project that spans five years, cash
1 pages (250 words) Assignment
Analysis of Cash Flow and Operating Activities
This may, however, be due to the typical characteristics of the industry and higher R&D requirements, which may be industry specific (Peterson & Fabozzi, 2012). Apart from this, mature companies have stable cash flows whereas the firms such as Apple, which are experiencing
1 pages (250 words) Assignment
Analysis of Cash Flow for a Small Business
According to Bodie et al (2004), it is the amount arrived at as a difference between income and expenses. Mils et al (2002) call the flow of cash into a business and out of a business, in a form of income and payment ‘cash flow’. Another
2 pages (500 words) Assignment
Capital budgeting, Risk, Return, CAPM
This gives the importance of purchasing the3 instrument via a loan which is more profitable to the company. b) In no case should Darth have leased the Death star for any case because leasing will always be expensive for
3 pages (750 words) Assignment
Cash flow schedule
It is also assumed that the income and expenses will be evenly spread over the contract period except in the case of temporary work on site and supervisory. The foreign exchange rate is expected to change for the three countries in which the contractor has suppliers.
4 pages (1000 words) Assignment
Cost of capital, weighted avareage cost, cash flow, marginal cost
This relationship also makes the investor be aware of their risk tolerance which improves on the investment approach. The relationship further explains that the risk takers will always ignore the risk involved and
2 pages (500 words) Assignment
The Challenges of Cash Flow
However, they realize after archiving their growth objective that they end up having a more complex cash flow problem. Some useful tips to help manage cash flaw are explained bellow (Jones,
2 pages (500 words) Assignment
Hire a pro to write