Capital Budgeting Simulation Analysis

1512 words - 7 pages

New Heritage Doll Company
Capital Budgeting Simulation Analysis

Xiaomeng Jin (Emma)
Chuzhao Yin (Lavana)
Shuo Tang (Candy)
Cost of Capital Simulation

Capital Simulation Scenarios:
Constant EBITDA with high carryover
a. Fixed budget: 4.7 M per year
b. EBITDA percent 12%
c. Carryover 30%
For year 1
...view middle of the document...

What’s more, these three programs are low risk, medium risk and high risk respectively, so by choosing them, we can balance the risk.

What was your APV for the company after year 1? Cash flow?

After year one, the APV is 320.01 M.
Cash Flow of 2010 |
Cash Flow from Operations | 23.35 |
Cash Flow From Investments | -15.52 |
Cash Flow from Financing | -7.63 |
Total Cash Flow | 0.2 |

How did you rank order the projects?
What we used to rank the projects at the first step is NPV. We consider high NPV as the most important indicator. However, besides NPV, we also care about the cost. The lower cost the better. Actually, we have run this simulation for many times as we used different rank principles each time. For example, in some runs we ranked the projects by payback period presuming that the lower payback period the better. In other runs we presumed that high EBITDA is more important. However, after several runs we find out that the most important thing is the NPV and the second important factor is the cost. With a relatively high NPV and relatively low cost, we can get the best pay back.
What decision rule did you observe?
Suppose this was the only year in the simulation? What is the optimal allocation of the budget?
Is NPV/APV the right decision rule when there is a binding budget constraint? What happens?
How did the choices you made in year 1 affect your decisions in later years?
Due to the scenario which was around 4.7 M budget in the first year with a high carryover, there were two different relative ideal choices we could take if this were a one year simulation. The first choice was taking Toddler Doll Accessory Line which cost 2.14 M, New Doll Film/DVD costing 1.05M and opened one new retail stores in the year1 to run out of our budget. The second choice was just adopt New Doll Film/DVD which had the highest NPV with the lowest and then put the money left to the later years using ours 30% carryover.
If we take choice 2, here is the result. In the second year, we will have 5.74M budget remaining and after investing them into three low cost projects, Retail Store Expansion in Northeast, Expansion of Mail-order Catalog Business to Asia and Tween Book Series, we still have 4.74M left to put it into Dolls of the World' Initiative which had relative low cost and high NPV than any others. After that, with ours low fixed budget and new high cost project coming out, the options for us was still limited, so that our scheme was picked low cost projects as many as possible ,as the year 5 comes to the end, decreased the budget remaining in each year and run out of the money in year5.
While, if we take choice 1, an aggressive investment, the result is as follow. We run out of our budget since the very beginning of five round despite ours high carryover, and continued our investment mission as we did in choice 2, we were surprised that we had a much better APV than in choice 2.(630 in choice1 VS 531 in choice 2). By...

Other Essays Like Capital Budgeting Simulation Analysis

Budgeting Essay

2415 words - 10 pages In conclusion, it can be argued that traditional budgeting does not always effectively provide solution for controlling and planning needs of an enterprise. This essay has undertaken a critical analysis which took into account various alternative methods of traditional budgeting under the pressures of capital market. It has provided arguments and evidence which argue for and against the claim of traditional budgeting being a rigid tool. To

Capital Budgeting Fundamentals Essay

4179 words - 17 pages      49 Valuation and Capital Budgeting Part I, HEC-ULg 2013-2014 – Marie Lambert Let’s test the concepts!! Valuation and Capital Budgeting Part I, HEC-ULg 2013-2014 – Marie Lambert 50 Cash flow – Concept #1 • The General Milk Company is currently evaluating the NPV of establishing a line of chocolate milk. As part of the evaluation the company had paid a consulting firm $100,000 to perform a test-marketing analysis. The

Risk Analysis on Investment Decision (Silicon Arts Inc)

1234 words - 5 pages Running head: CAPITAL BUDGETING Risk Analysis on Investment Decision Risk Analysis on Investment Decision Silicon Arts, Incorporated (SAI) is a manufacturer of circuits that are used in the manufacture of electronic equipment items. During their initial years in operation, there was an increase in the industry followed by a 40% decline. In order to remain competitive and stay profitable, SAI controlled expenses. Current

Bus401 Final Paper

1881 words - 8 pages Final Project BUS401: Principles of Finance Instructor Grant Magnuson April 29, 2013 Final Project When a project is presented as being considered for investment by an organization, it is of the utmost importance that the financial feasibility of the project be reviewed and presented prior to the final decision on investment being made. Serious financial ramifications can be felt from poor decision making when it comes to capital budgeting

Mba 540 Week 3 Risk Analysis

1349 words - 6 pages communication market. An analysis of the two capital project proposals by internal and external valuation techniques and risks associated with the proposed investment decision will be evaluated so the management and board of directors may make an informed decision. A part of the decision making process is to assess capital budgeting and spending associated with each proposal. The capital budgeting process will involve examining the cash flow

Caledonia Products

756 words - 4 pages stock is combined along with additional stocks in the portfolio. According to CAPM, for capital budgeting purposes the relevant risk is systematic risk. For some shareholders, the project contribution-to-firm measure will be the relevant risk. Whenever there is a possibility of bankruptcy, the contribution-to-firm risk would be a more measurable risk. Simulation is the influence of imitating the performance for whatever project is being

Medical Associates

574 words - 3 pages capital cost of capital = proportion of debt X after tax cost proportion of equity X cost of equity. 0.5X 10% X ( 1- 0.4) + 0.5 X 15.85 = 10.93% 5. Describe the four steps of capital budgeting analysis The four steps of capital budgeting analysis are: 1. Estimate the project’s expected cash flow, which consist of the following: a. The capital outlay, or cost b. The operating cash flows c. The terminal (ending) cash flow

Guillermo Furniture Store Analysis

1594 words - 7 pages uillermo Furniture Store Analysis Week one individual paper was centered on Guillermo Furniture Store location, the production of work and the company finance. Week three individual paper will state three alternative measures for Guillermo Furniture Store working capital policy by weighting the average cost of capital, and by implementing multiple valuation techniques toward reducing the business risk. Business within Guillermo Furniture

Guillermo Furniture Analysis

1652 words - 7 pages . Alternatives The Guillermo Furniture Store simulation poses future success of the company may be in jeopardy unless it considers an Analysis of Different Alternatives. Guillermo Navallez must scrutinize the available options to recover the quality of his business practices. Analysis of Different Alternatives is a synopsis of how decisions can be made to implement sound business practices that have proven to extend the financial state of a

Shouldice Hospital

659 words - 3 pages Introduction Capital budgeting is very important in decision making for the financial manager of any firm. Most new projects take time in developing because of the research analysis required in opening a new addition to the company. The cash flow is a huge factor in making the decision of a project. For instance, capital expenditures require firms to outlay large sums of funds to initialize the project. Second, firms will need to formulate

Yum Finance

1004 words - 5 pages Added- 317,190 * Earnings Before Interest and Taxes= 1,557,000 * Investor Supplied Capital= 6,189,000 * Cost of Capital= 0.09 * Capital Budgeting * NPV Project A= $788.20 * NPV Project B= $1,004.03 * Cost Volume Profit Analysis= 389,250 * Fixed Operating Costs: 1,557,000 * Variable Cost per customer: 4 * Product Sales per customer: 8 Sources (n.d.). Retrieved December 8, 2015

Related Papers

Financial Ratios, Growth Analysis, Cost Of Capital, Capital Structure, & Capital Budgeting Analysis For Starbucks Corp

1706 words - 7 pages Running head: Financial Analysis of Starbucks University of Houston-Victoria School of Business Administration FIN6352 – Financial Management Dr. Omar M. Al Nasser August 11th, 2013 Financial Ratios, Growth Analysis, Cost of Capital, Capital Structure, & Capital Budgeting Analysis For Starbucks Corp. Table of Contents Executive Summary……….………………………………………………………….………..3 Capital

Capital Budgeting Essay

1072 words - 5 pages Capital Budgeting The Capital Budgeting simulation asks the user to decide between two mutually exclusive capital investment proposals. In the following discussion, an analysis of the risks associated with the investment decision will be presented. Furthermore, a mitigation plan for each risk discussed will be included in the following discussion. In what long-lived assets should the firm invest (Ross 2005)? This question concerns the left

Capital Budgeting Practice In Bd Essay

2354 words - 10 pages project future cash flows. The company also uses scenario analysis to incorporate risk and for some very complex projects, it uses simulation analysis with the help of parent company in UK. However, Reckitt Benckiser Bangladesh Ltd is a well established company and it does not take large projects very often. Those capital budgeting techniques are normally used in evaluating large projects and in case of acquisition of an existing company. Company

Capital Budjeting Essay

1760 words - 8 pages capital budgeting requests. The better methods use time value of money concepts. Older methods, like the payback period, have the deficiency of not using time value techniques and will eventually fall by the wayside and be replaced in companies by the newer, superior methods of evaluation. Very Important: A capital budgeting analysis conducts a test to see if the benefits (i.e., cash inflows) are large enough to repay the company for three