Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It needs to be done in excel and show formulas as well. Fab Lab Capital Budgeting Case The Engineering Department at Great Lakes Community College,
It needs to be done in excel and show formulas as well.
Fab Lab Capital Budgeting Case The Engineering Department at Great Lakes Community College, a taxpayer funded institution, is considering a new Fabrication Lab (Fab Lab) on campus. The cost of designing the Fab Lab and the equipment installation is estimated at $500,000. The equipment would include a 3-D printer and other fabrication machinery. The Engineering Department manager believes that the new Fab Lab would increase enrollment which would increase cash in-flows each year by $145,000. The additional annual costs related to the Fab Lab are estimated at $20,000 for labor (lab technician), $5,000 for repairs & maintenance, $20,000 for supplies and $10,000 for utilities. In order to increase enrollment, the college would need to make the community aware of the new Fab Lab. To do this, the manager is budgeting for $15,000 for marketing over the first three years of the project. It is estimated that the Fab Lab would have a useful life of 15 years and at the end of the life, all of the equipment could be sold for $25,000. Your group works in the Financial Services Office at Great Lakes Community College. The College President, Dr. Salas, has asked you to analyze the project and prepare a memo explaining your results. The college uses a 15% discount rate. You are to: 1. Calculate net cash in-flows for the Fab Lab for each year 2. Calculate Accounting Rate of Return, Payback Period and Net Present Value for the Fab Lab 3. Prepare a brief memo explaining your results and discussing other items to consider when making capital budgeting decisions. Fab Lab Capital Budgeting Case The Engineering Department at Great Lakes Community College, a taxpayer funded institution, is considering a new Fabrication Lab (Fab Lab) on campus. The cost of designing the Fab Lab and the equipment installation is estimated at $500,000. The equipment would include a 3-D printer and other fabrication machinery. The Engineering Department manager believes that the new Fab Lab would increase enrollment which would increase cash in-flows each year by $145,000. The additional annual costs related to the Fab Lab are estimated at $20,000 for labor (lab technician), $5,000 for repairs & maintenance, $20,000 for supplies and $10,000 for utilities. In order to increase enrollment, the college would need to make the community aware of the new Fab Lab. To do this, the manager is budgeting for $15,000 for marketing over the first three years of the project. It is estimated that the Fab Lab would have a useful life of 15 years and at the end of the life, all of the equipment could be sold for $25,000. Your group works in the Financial Services Office at Great Lakes Community College. The College President, Dr. Salas, has asked you to analyze the project and prepare a memo explaining your results. The college uses a 15% discount rate. You are to: 1. Calculate net cash in-flows for the Fab Lab for each year 2. Calculate Accounting Rate of Return, Payback Period and Net Present Value for the Fab Lab 3. Prepare a brief memo explaining your results and discussing other items to consider when making capital budgeting decisionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started