The Engineering Department at Great Lakes Community College, a taxpayer funded institution, is considering a new...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $650,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 $175,000. The additional annual costs related to the Fab Lab are estimated at $25,000 for labor (lab technician), $5,000 for repairs & maintenance, $21,000 for supplies and $7,500 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 a total of $24,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 $30,000. You work 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. Instructions: The calculations must be completed in Excel using formulas. It should be easy to follow and professional in appearance. All calculations should be show to hundredths (i.e., two decimal points). The brief memo is to be included in the Excel workbook in a textbox. The memo must be free of spelling, grammatical and punctuation errors. Extra Credit of 5 points for including the IRR of potential investment, subject to the 20-point limit for the semester. 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 $650,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 $175,000. The additional annual costs related to the Fab Lab are estimated at $25,000 for labor (lab technician), $5,000 for repairs & maintenance, $21,000 for supplies and $7,500 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 a total of $24,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 $30,000. You work 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. Instructions: The calculations must be completed in Excel using formulas. It should be easy to follow and professional in appearance. All calculations should be show to hundredths (i.e., two decimal points). The brief memo is to be included in the Excel workbook in a textbox. The memo must be free of spelling, grammatical and punctuation errors. Extra Credit of 5 points for including the IRR of potential investment, subject to the 20-point limit for the semester.
Expert Answer:
Answer rating: 100% (QA)
Sure I can help you with that Lets start by calculating the net cash inflows for each year and then ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Describe, in human terms, why delay and jitter are bad in real time (interactive) voice and video communications. Would these same problems apply to recorded voice and video stored and played back at...
-
Refer to Exercise 12.67. a. Determine a model to relate the probability of both hypertension and proteinuria in a pregnant woman to social class and smoking level. b. Predict the probability of both...
-
Use a series of two-dimensional (two-variable) graphs to illustrate the historical relationship among the following variables: value of the dollar, oil prices, interest rates, and stock prices. Give...
-
The assets, liabilities, stockholders equity, revenues, and expenses of Carter Design Studio, Inc., have the following balances at December 31, 2010, the end of its first year of operation. During...
-
Frontera Companys output for the current period results in a $ 20,000 unfavorable direct labor rate variance and a $10,000 unfavorable direct labor efficiency variance. Production for the current...
-
(9x+5) dx = Use C as the arbitrary constant.
-
Suppose that Sudbury Mechanical Drifters is proposing to invest $10.4 million in a new factory. It can depreciate this investment straight-line over 10 years. The tax rate is 35%, and the discount...
-
How does the maturity date affect the liquidity and marketability of a financial instrument? 8. How do investors or borrowers typically plan for or manage the maturity date of their financial...
-
The greatest common divisor or the highest common factor is the largest natural number that divides two numbers without leaving a remainder. Hope you remember GCD calculations used in algebra and...
-
How do interest rates affect the value of debentures? 12. What factors should investors consider when analyzing the risk and return of debentures? 13. How are debentures different from bonds and...
-
How does the maturity date impact the pricing and yield of a bond? 5. Can the maturity date be extended or shortened during the life of a financial instrument? 6. What are the consequences for an...
-
How does the credit rating of a company impact the pricing and demand for its debentures? 9. What are the risks associated with investing in debentures? 10. Can debentures be converted into equity...
-
The IMF has become, among other things, a bail-out specialist and an innovator in structuring deals. Discuss some of. Both Mark Copelovitch in his book The International Monetary Fund in the Global...
Study smarter with the SolutionInn App