Capital Budgeting

H

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,601
Office Version
  1. 2021
Platform
  1. Windows
I need to do a Capital Budgeting Excercise using Excel to find if it is better to lease Computer Software or the Purchase the Software outright.

The Purchase price is 150,000 plus annual maintenace costs of 18000. We anticipate the useful life to be 5 years with no residual/salvage value

The Rental option is 18000 per annuam over 5 years

It would be appreciated if anyone can assist in setting up a spreadsheet showing the Values as well as the Net Present Value

Howard
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
Howard

Maybe I'm missing something but surely the rental option is obviously the best deal.

I mean there's no purchase involved, so no initial outlay of 150,000 and even if you still need to pay for annual maintence that's only going to be 180,000 whereas the purchase option will be 240,000 ie the initial purchase plus 90,000 maintenance.
 
Upvote 0
Hi Norie

The figures I put on the Board are fictitious as the actual figures are confidential.

I just wanted to know how to set up the comparison Purchase vs Rental on Excel using Present Value of Cash Outflow and determing the NPV.

Regards

Howard
 
Upvote 0
Hi Roy

Thanks for your reply.

What i am looking for is doing a Capital Budgeting Excercise what to Rent Computer Software is to Purchase this outright Calculating the Present Value of cash Outflows and then calculating the NPV.

It is a lot different from the example on the Website you kindly provided.

I have not done a Capital Budgeting excercise for Several Years now and am a bit rusty on this.

Hope you can assist be by uploading an example Purchase Vs Rental Option



Regards

Howard
 
Upvote 0
Hi Roy

Thanks for the help

This is great. I will adapt this to my needs. I have taken out my old textboks to refresh my memory on Capital Budgeting. The template has also brought back old memories.

Regards

Howard
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Calculating the total interest paid on a car lease
Replies
4
Views
387
Domenic
D
D
  • Solved
Count total award value per unique supplier
Replies
4
Views
124
Fluff
Fluff
C
  • Question Question
Adding new code to existing macro to account for locked/unlocked cells
Replies
1
Views
424
DanteAmor
DanteAmor
M
  • Question Question
How to see if my loan payment is within budget with true or false statement
Replies
6
Views
771
6StringJazzer
6StringJazzer
A
  • Question Question
Looking for the right formula
Replies
7
Views
850
Adimm
A

Forum statistics

Threads
1,224,627
Messages
6,179,964
Members
452,950
Latest member
bwilliknits

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top