Complete the following numbered problems using an Excel spreadsheet. Each person is responsible for their own response to the questions. –1. Consider the following cash flow data for two competing investment projects:n A B 0 $-1,500,000 $-1,250,000 1 $800,000 $600,000 2 $1,350,000 $1,250,000 At i=10%, which of the two projects would be a better choice? 2. Consider the following cash flow for a given project: n Cash Flow0 $-5,0001 $1,0002 $1,2503 $2,0004 $2,2505 $3,0006 $3,250 (a) Find the conventional payback period for the project.(b) Find the discounted-payback period for the project, assuming i = 12%. 3. Consider the following set of investment projects, each with a four-year investment life: n A B C D 0 $-2,000 $-4,000 $0 $-7,5001 $-4,000 $5,000 $-1,000 $1,5002 $2,000 $-4,000 $2,000 $2,0003 $2,000 $5,000 $3,000 $2,5004 $3,000 $5,000 $4,000 $3,000 Compute the net future worth of each project at i=7%. 4. Consider the following investment projects, all with a three-year investment life:n A B C D 0 $-5,000 $-4,000 -$7,500 $-6,0001 $750 $3,000 $1,750 $1,0002 $1,000 $5,000 $2,750 $1,0003 $4,000 $5,000 $3,750 $5,500 Compute the net present worth of each project at i=6%. 5. B&C Manufacturing is planning on purchasing a new assembly machine for $32,500 to automate one of its current manufacturing operations. It will cost an additional $2,500 to have the new machine installed. With the new machine, B&C expects to save $10,000 in annual operating and maintenance costs. The machine will last 5 years with an expected salvage value of $3,500. How long will it take to recover the investment (plus installation cost)?– All of the text in this assignment needs to be set in 10 or 12-point size. Please resist the temptation to mix and match point sizes. If you doubt your applications intentions, just select all of your text and insure that it is in 10 or 12-point size. The right and left side can be set for ½” (0.5) margins. Set the top and bottom margins to one (1”). The only text that ends up on the outside of the one-inch margin is the page number. Remember to do your spelling and grammar checking before turning your assignments in. When doing the spelling/grammar checking keep in mind that some words such as mush and must, woods and words, or here and cow, will not be caught by either check. To correct these problems, you will need to proofread your work. Any homework that has more than one page needs to have page numbers on it. Please place your page numbers on the bottom of the page. In MS Excel, use the footer selection and place the page number the or of the page. List each problem’s number on the left, placing a blank cell above it.For this assignment,you may state the problem either exactly as it appears in the book or you may summarize the all the values, terms and percentages. This is to help insure that you use the correct values in your calculations. You will need to break long text up between cells so that you will stay with-in the printing boundaries of the page. Skip one cell and write the word “Given:” Follow that with what is known from the problem. If the problem has multiple parts, place the letter of each part before the “Given”. If the problem has a table, then reproduce the table. Show your work in solving the problemEach problem is tied directly back to a specific area covered in the chapter, if you are having difficulties with a problem, be sure to re-read that section.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]