Hi there,
I am a beginner at using Excel.
I have a scenario for all of you experienced Excel users out there and I
hope that someone can help me.
I need to assess the benefits and potential cost savings associated with
installing videoconferencing capabilities at each of a firm's six locations.
The cost to establish each video conference facility is $60,000.00 and each
facility will have an annual operating and support cost of $20,000.00. In the
first year the videoconferencing system will save approximately $400,000.00
in travel expenses.
The savings are expected to increase at a rate of 5 percent per year.
Now - I have been asked to develop a spreadsheet to analyze the costs and
savings over a three-year period.
What would be the most efficient way of developing a spreadsheet for the
company? Can I do it all on one spreadsheet or should I develop a workbook?
--
Thanks in adavnce,
Decorte