Excel Project

School: Academy of Healing Arts Massage and Facial Skin Care           Price: $20.00 USD

Document Description

IMPORTANT: You are required to present clear, easy-to-understand, and easy-to-find answers. You need to follow the instructions below when presenting your project for project that can be graded. Failure to follow instructions may result in unclear or unorganized answers, which will lower grade for the project.
1- Present only one Excel Workbook (only one Excel File) for the entire project
2- Name your file using your first and last name as the following example: John_Doe_FIN301_B_ Project
3- Each answer to each question should be in separate sheet in your Excel workbook. For that, you need to create a separate sheet for each answer and name it with the question number.

4- Show your work and how the answer was obtained by formulating your cells.

Written By

Studypool Tutor
Academy of Healing Arts Massage and Facial Skin Care
A1 12problem234567891011121314151617181920212223242526272829303132333435363738394041424344BCDEFGH10/19/2017 4:06Chapter 12. Solution to End-of-Chapter Comprehensive/Spreadsheet ProblemProblem 12-11You must analyze a potential new product--a caulking compound that Cory Mateials' R&D people developed for use in theresidential construction industry. Cory's marketing manager thinks they can sell 115,000 tubes per year at a price of $3.25each for 3 years, after which the product will be obsolete. The required equipment would cost $150,000, plus another $25,000for shipping and installation. Current assets (receivables and inventories) would increase by $35,000, while current liabilities(accounts payable and accruals) would rise by $15,000. Variable costs would be 60 percent of sales revenues, fixed costs(exclusive of depreciation) would be $70,000 per year, and the fixed assets would be depreciated under MACRS with a 3-year life.(Refer to Appendix 12A for MACRS depreciation rates.) When production ceases after 3 years, the equipment should have amarekt value of $15,000. Cory's tax rate is 40 percent, and it uses a 10 percent WACC for average-risk projects.a. Find the required Year 0 investment, the annual after-tax operaing cash flows, and the terminal year cash flow, and thencalculate the project's NPV, IRR, MIRR, and payback. Assume at this point that the project is of average risk.Key Output:NPV =IRR =
lock_open Buy Document

Reviews from Students

Studypool Student
"AMAZING as always!"
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors