Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assessing unconventional projects
When it comes to some non conventional capital expenditure budgeting, I find it little daunting to relate to Excel functions. To highlight my predicament, please allow me to share following scenario with you: In cases where you spend money to improve the business (in our case we are planning to spend money to convert CAD files to new software), there are no tangible cash in-flows associated. We have the option to tender the project once to have the job completed at an investment cost of $ 2.0 million. An alternative option is to have the project completed in next 5 years (there is no urgency to convert all files) by spending a uniform amount of money each year, say, $ 50,000. So again there is an out-flow of cash costing us $ 2.5 million all up. I am struggling to find the right method to evaluate these both options to find the project with the better value. How do you calculate options using Excel functions where no cash inflows are expected? Regards AK -- khwaja ------------------------------------------------------------------------ khwaja's Profile: http://www.excelforum.com/member.php...o&userid=30956 View this thread: http://www.excelforum.com/showthread...hreadid=506242 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assessing unconventional projects
khwaja -
Please explain why this is a "predicament" for you. It looks to me like a very straightforward use of net present value using Excel's NPV worksheet function. - Mike www.mikemiddleton.com "khwaja" wrote in message ... When it comes to some non conventional capital expenditure budgeting, I find it little daunting to relate to Excel functions. To highlight my predicament, please allow me to share following scenario with you: In cases where you spend money to improve the business (in our case we are planning to spend money to convert CAD files to new software), there are no tangible cash in-flows associated. We have the option to tender the project once to have the job completed at an investment cost of $ 2.0 million. An alternative option is to have the project completed in next 5 years (there is no urgency to convert all files) by spending a uniform amount of money each year, say, $ 50,000. So again there is an out-flow of cash costing us $ 2.5 million all up. I am struggling to find the right method to evaluate these both options to find the project with the better value. How do you calculate options using Excel functions where no cash inflows are expected? Regards AK -- khwaja ------------------------------------------------------------------------ khwaja's Profile: http://www.excelforum.com/member.php...o&userid=30956 View this thread: http://www.excelforum.com/showthread...hreadid=506242 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open saved projects automatically? | Excel Discussion (Misc queries) | |||
Planning & Tracking Home-work projects for kids. | Excel Discussion (Misc queries) | |||
how do I set up cashflow budgets for different projects | New Users to Excel | |||
How do I use the To-Do List for Projects Template in Excel? | Excel Discussion (Misc queries) | |||
I need a template for at a glance viewing 2005 projects for staff. | Charts and Charting in Excel |