Compute the payback for each project

Assignment Help Corporate Finance
Reference no: EM13929377

Capital Budgeting Simulation

1. Generate 25 projects with uniformly distributed first costs ranging from 40,000 to 280,000; uniformly distributed lives from 2 - 10 years; and uniformly distributed rates of return (IRR) from 5 - 40%. With this information the yearly cash flow (which is the same each year) can be computed. As an example assume a project has been generated with a first cost of 75,325, a life of 6 years, and an IRR of 27.2%. The yearly cash flow can be computed by multiplying the first cost by: ((1+i)^n)i/((1+i^n)-1). This equation called the (A/P,i,n) is in the book. This can be done in Excel using the PMT function. For these numbers this gives a yearly cash flow of 26,820. This same process will then be used to generate 24 additional projects with varying first costs, lives, and yearly cash flows.

2. Compute the payback for each project and rank the projects generated in step one using payback, which is the length of time need to return the initial cost. This is equal to the first cost divided by the annual cash flow. The smaller the better.

3. From the ranked list, use an initial capital budget of $600,000 to buy as many projects as possible. Only whole projects can be purchased. Any unused cash will rollover to year two. Keep track of the projects purchased and continue to year two. For year two generate 30 projects, rank them, and purchase projects using the money that projects purchased in year one have provided through their yearly cash flows. Note that any project purchased will return the yearly cash flow every year through its life. For year three generate 35 projects, rank them and purchase using the same approach. Continue this process in year four with 40 projects and year five with 45 projects.

4. For the five year period several projects will have been purchased during each of the five years. Some of these projects with short lives are no longer returning any cash, and some of the projects with longer lives will still be returning cash. To compare the capital budgeting ranking methods we want to see how much wealth has been accumulated by the company during this period. The measure we will use will be to at the end of year five add up the money the projects will still return from the end of year five to the end of the projects' lives to get one value of the net wealth at the end of year five. For example a project bought in year 3 with a 7 year life will have 5 years of cash flows left. If each yearly cash flow is say 45,000, the value of the remaining life of this project would be 5 * 45,000 = 225,000. This process would need to be repeated for all projects that have cash flows remaining starting at the end of year five. This value will be used as the net wealth. This completes one cycle of the simulation for one ranking method. This will need to be completed for 30 cycles for this ranking method. Compute the average and standard deviation for the 30 cycles.

5. Complete this process (steps 1-4) for two additional ranking methods: Net present value (NPV) using i = 15% and Internal rate of return (IRR). The calculation of NPV can be found in the textbook or online. The IRR has already been computed for each project. Complete 30 cycles for each of these methods.

This assignment needs to be done in Excel using VBA. A VBA macro button needs to be placed on the initial sheet clearly visible when in the home (A1) location. This macro button will execute the simulation with no other input required from the user. The output should show the results for each of the ranking methods for each of the 30 cycles, and the average and standard deviation for each method.

Reference no: EM13929377

Questions Cloud

Find a business research article that used secondary data : What do you think is the best way to collect the information (personal surveys, online surveys, etc.) and why? How effective would it be to conduct a survey at a local mall? Explain your rationale.
Balance sheet and statement of cash flows : Prepare an income statement, balance sheet, and statement of cash flows for 2013.
Which types of jobs are best suited for flexibility : Which types of jobs are best suited for flexibility with regards to hours and office location? Which types of jobs are less likely to afford this type of flexibility? Explain
How do organizations encourage political activity : Did the group progress linearly from one step to another or did it experience periods of little progress punctuated by bursts of energy, as Gersick describes? Justify your response.
Compute the payback for each project : Compute the payback for each project and rank the projects generated in step one using payback, which is the length of time need to return the initial cost. This is equal to the first cost divided by the annual cash flow.
What are some of the statistics of lay-off downsizing : How and why has corporate downsizing been effected in the last 18-months? Why have so many employees been laid off? What are some of the statistics of lay-off/corporate downsizing? How important of a role has the HR function played in recession-dr..
What percentage return does each investor earn : If they both sell the stock for $40 after a year, what percentage return does each investor earn? In both cases, the value of the stock has risen the same. Why are the percentages returns different
Identify a company with a visible organizational culture : Identify a company with a visible organizational culture. What do you think are the company's values? How do you think this culture contributes to the performance of the organizations' employees? Explain.
Explain and give examples of how the particular outcomes : Explain and give examples of how the particular outcomes of a study can suggest if a particular threat is likely to have been present.

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Calculate its corporate cost of capital

what is the firm's optimal capital structure - Calculate its corporate cost of capital at each structure. Also note that data on component costs at alternative capital structuress are not reliable in real world situations.

  What is the npv of the project

Imagine you are considering acquiring a company. You have received their financial statements, and have learned that they have annual cash flows of - should you decide to sell the company at that time. If your discount rate is 15%.

  Restricted voting sharesnbsp in 1962 frank hughes

restricted voting shares.nbsp in 1962 frank hughes established hughes machine parts in rural ontario.nbsp in 1975 frank

  You are considering the start of a small business that

you are considering the start of a small business that sells generator gaskets. according to your market research you

  Dispose of toxic elements from recycled computers

Redo your analysis for a scenario in which CT incurs a cost of $0.20 per unit to dispose of the toxic elements from the recycled computers. What is your recommendation under these circumstances?

  1 missing trading ltd purchased a business delivery

1 missing trading ltd purchased a business delivery vehicle on the 1 of january 2009 for r120 000. calculate the

  Planning for risk management

Organization must balance performance aims & associated risks. By having a plan, Organization can be better prepared for dealing with risks when they occur.

  Characteristics of corporate governance mechanisms

You are required to: Critically discuss, with reference to contrasting views and theoretical perspectives in the literature, the nature and characteristics of corporate governance mechanisms that are effective in enabling corporate accountability ..

  1 conduct a dupont decomposition of lucents roe for the

1. conduct a dupont decomposition of lucents roe for the 1998 1999 and 2000 first december quarters. what factors

  Determine the nations gross domestic product

Determine the nations gross domestic product (GDP) and how would your answer change if the dollar amounts of imports and exports were reversed?

  Please select a public company in the aviation industry and

please select a public company in the aviation industry and answer the following questions after review the companys

  Your grandmother just died and left you 132500 in a trust

your grandmother just died and left you 132500 in a trust fund that pays 6.5 interest. you must spend the money on your

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