# Our organisation needs to complete a project in excel programming

The project is based on Visual Basics Applications in financing sector.

Pathak Consultancy

1. Create 25 projects with uniformly distributed first costs ranging from \$50,000 to \$250,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. This can be done in Excel using the PMT function. Use this same process 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.

3. Now from the ranked list, use an initial capital budget of \$550,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 remaining cash flows 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.

( 0 comentários ) Kalamazoo, United States

ID do Projeto: #15129596

## Concedido a:

ReneRondon

Hello. I bid for this project because I have already finished the assignment and have the solved file with those 3 ranking methods in Excel Habilidades y experiencia relevante The file is well organized and clear, Mais

\$35 USD em 1 dia
(11 Comentários)
2.8

## 14 freelancers estão ofertando em média \$75 para esse trabalho

\$200 USD in 3 dias
(565 Comentários)
8.2
schoudhary1553

Hello Sir, I can help you with your excel programming project. I have delivered more than 260 projects with 100% client satisfaction. Please give me chance to work on this project. Relevant Skills and Experience I Mais

\$180 USD in 3 dias
(238 Comentários)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia Mais

\$180 USD in 3 dias
(188 Comentários)
6.7
\$25 USD em 1 dia
(78 Comentários)
6.4
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Ma Mais

\$30 USD em 1 dia
(58 Comentários)
5.2
\$25 USD em 1 dia
(25 Comentários)
5.0
Valuesolutions

Hello, how are you? I hope you have a bright day/evening from your side. I have read the details provided, but please contact me so that we can discuss more on the project. Relevant Skills and Experience Excel, Progra Mais

\$126 USD em 1 dia
(10 Comentários)
3.8

Hi, I've already made 1/3 of your project (until, step 4). If you want I can send it to you to check it out (no commitment) I estimate to spend more 2H on it. So my offer is 15 USD x 2H = 30 USD. Habilidades e Exper Mais

\$35 USD em 1 dia
(2 Comentários)
3.0
VirtualBrainInc

I have briefly checked the description on OB, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. Relevant Skills and Experience organiz Mais

\$25 USD em 1 dia
(2 Comentários)
0.0
jduddy9

Looks like a school project. I've done similar stuff in the past. I always hold my work to a higher standard and can help you with this

\$66 USD in 4 dias
(0 Comentários)
0.0
\$25 USD in 10 dias
(0 Comentários)
0.0
RTinkess31

A proposal has not yet been provided

\$66 USD in 5 dias
(0 Comentários)
0.0
nirodha1994

A proposal has not yet been provided

\$25 USD em 1 dia
(0 Comentários)
0.0