Preview

Kevin

Good Essays
Open Document
Open Document
1227 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Kevin
Homework4
2013年3月16日 上午 10:42

(二選一) 4.2.Perform a financial analysis for a project using the format provided in Figure4-5. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in years 2, 3, and 4. Use a 9 percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet (or use the business case financials template provided on the companion Web site) to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis. 4.7. Create a weighted scoring model to determine grades for a course. Final grades are based on three exams worth 20 percent, 15 percent, and 25 percent, respectively; homework is worth 15 percent; and a group project is worth 25 percent. Enter scores for three students. Assume Student 1 earns 100 percent (or 100) on every item. Assume Student 2 earns 70 percent on each of the exams, 80 percent on the homework, and 95 percent on the group project. Assume Student 3 earns 90 percent on Exam 1, 80 percent on Exam 2, 75 percent on Exam 3, 80 percent on the homework, and 70 percent on the group project. You can use the weighted scoring model template, create your own spreadsheet, or make the matrix by hand. (選 3 Tasks) Running Case Note: Additional running cases are provided in Appendix C and on the companion Web site. Template files are also available on the companion Web site. Manage Your Health, Inc. (MYH) is a Fortune 500 company that provides a variety of health care services across the globe. MYH has more than 20,000 full-time employees and more than 5,000 part-time employees. MYH recently updated its strategic plan, and key goals include reduce internal costs, increasing cross-selling of

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Mr. Doe

    • 686 Words
    • 3 Pages

    * 3. Identify a preliminary set of tangible and intangible costs you think would occur for this project and the system it describes. What intangible benefits do you anticipate for the system?…

    • 686 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1) Using pertinent information from the case text, prepare a capital budgeting analysis of the wind turbine project using the payback and net presentation value or internal rate of return models.…

    • 446 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Project B: In this one, there are no annual cash inflows, just the one inflow of $200,000 in year 5. So you need to find the present value of $200,000 five years from now at 11%. You don't use the annuity table for this one, you use the present value of $1 table. The factor this table gives is 0.593. So the present value of $200,000 five years from now at 11% is $200,000 * 0.593 = $118,600. Net present value = $118,600 - $100,000 = $18,600 The payback period for this project is five years. It's not until the cash inflow of $200,000 in year 5 that the project recovers its original…

    • 315 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Davis, Michaels and Company

    • 2595 Words
    • 10 Pages

    Davis, Michaels, and Company is a financial consulting firm in San Francisco run by Tom Davis and Gene Michaels. Tom and Gene worked together at Steel, Robbins, Hernandez, and Associates after graduating college. When Tom saved up enough money he left Steel and asked Gene to be his partner to open Davis, Michaels, and Company. The firm provides consulting services for income tax planning, insurance planning, investment planning, and estate planning for small, family owned businesses. Their company is successful and is in need of another consultant besides Tom and Gene. Tom is planning on hiring a college graduate that majored in finance but that is months away and they need a temporary employee immediately. He has decided to have his secretary Janet be in charge of some financial analysis obligations in the mean time. Tom wants to make sure that Janet can handle this responsibility so he has given her a short test of 10 questions on discounted cash flow analysis. The questions are based on a real client who has $10,000 to invest and has a goal of accumulating enough money in 5 years to pay for his daughter’s first year of college.…

    • 2595 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    Project Manegement

    • 252 Words
    • 2 Pages

    5. Provide an original example of how you could use a weighted scoring model applied to a project and the criteria you would use.…

    • 252 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1. At 18% Rate of Return for the first problem, the 3T company could choose to fund either project because (Project 1) shows a positive NPV of $119,689 and (Project 2) shows a positive NPV of $176,525. If they want to choose the project with the highest NPV to fund, then they should choose (Project 2) with the NPV of $176,525…

    • 180 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Capital Budgeting Case

    • 306 Words
    • 2 Pages

    Write a paper of no more 1,050 words that defines, analyzes, and interprets the answers to items (c) and (d). Present the rationale behind each item and why it supports your decision stated in item (e). Also, attempt to describe the relationship between NPV and IRR. (Hint. The key factor is the discount rate used.) In addition to the paper, a Micosoft® Excel® spreadsheet showing your projections and calculations must be shown and…

    • 306 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Excel Word

    • 1789 Words
    • 8 Pages

    Your supervisor in the Finance department at Med Supply Online Warehouse has asked you to create a worksheet that will project the annual gross margin, expenses, total expenses, operating income, income taxes, and net income for the next six years based on a table of assumptions he has provided you with. In Part 1 of this project, you will create the worksheet. In Part 2, you will create a chart to present the data. And in Part 3, you will use Goal Seek to analyze a sales scenario.…

    • 1789 Words
    • 8 Pages
    Good Essays
  • Good Essays

    The Investment Detective

    • 439 Words
    • 2 Pages

    1. What analytical criteria can we use to rank the projects? How do you define each criterion? Please evaluate each project using all investment criteria we learned during the class.…

    • 439 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Misis

    • 4042 Words
    • 10 Pages

    Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. Themachine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost ofcapital for such an investment is 12%.[A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine.Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the endof the year, and do not consider taxes. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. Themachine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost ofcapital for such an investment is 12%.[A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine.Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the endof the year, and do not consider taxes. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. Themachine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost ofcapital for such an investment is 12%.[A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine.Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the endof the year, and do not consider taxes. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. Themachine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost ofcapital for…

    • 4042 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Cacaqu

    • 4183 Words
    • 17 Pages

    This course provides essential tools that anybody interested in business should know. We will analyze theory and practice of the major financial decisions made by corporations. The goal of the class is to teach you 1) how to value firms and project opportunities using methods drawn from the theory of corporate finance 2) to develop an appreciation of how financing decisions impact project and firm value and 3) how to develop effective ways to visualize and communicate spreadsheet analyses. By definition, the course is designed to be “hands-on”.…

    • 4183 Words
    • 17 Pages
    Satisfactory Essays
  • Better Essays

    Directions: Answer the following problems IN DETAIL. Your analysis must be typed and should be free of grammatical errors and “slang” terms.” Wherever appropriate, make sure you supplement your discussion with graphical analysis and equations. The graphs may be hand drawn, but please make sure they are neat. There are no restrictions or requirements on working in groups. The one exception is that each person must hand in his/her OWN work. In economic terms, there are no input restrictions; however, the output MUST be yours.…

    • 1829 Words
    • 8 Pages
    Better Essays
  • Good Essays

    Gitman IM Ch09

    • 3453 Words
    • 63 Pages

    d. One weakness of the payback method is that it disregards expected future cash flows as in the…

    • 3453 Words
    • 63 Pages
    Good Essays
  • Good Essays

    3. Compute the internal rate of return (IRR) and payback period for each project. How should these…

    • 787 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    (Note: Page numbers refer to in Q1 – Q15 refer to the prescribed textbook: Bob Hughes and Mike Cotterell,…

    • 453 Words
    • 2 Pages
    Satisfactory Essays

Related Topics