Cash payment

Dahmbogan international Ltd (Bogan) is deciding whether to replace an existing machine which it uses to produce vaccuum cleaners. The old machine can be used for 5 more years and would generate cash inflows of $6000 per year. it would cost Bogan $2000 in wages to run the machine. Alternatively, it can be sold now for $12,000 which is its carrying amount recorded in the books (there is no gain or loss). The new machine would cost $180,000 as a one off cash payment. Because of its increased efficiency, the new machine would generate cash inflows of $48,000 per year for the next 5 years and would cost $3000 per year to run. These are not incremental cash flows. After 5 years of operation it can be sold for $5000. Bogan requires an 8% return on similar investments. ignore depreciation and taxes for this question.
Required: a) Draw a timeline showing the cash inflows and outflows relating to this investment. You may use Excel tools to do this or use another program such as MS Paint and then copy paste your image into the space provided.
b) Calculate the NPV of purchasing the new machine. Use the space provided. You can use any approach you like (i.e. by using an Excel function or by just showing the calculation).
c) Calculate the i RR of this project. Use the i RR Excel function to complete this task. You wil have to do a bit of research on how to do this. Try this website but please ignore step 6: Icu late-irr -in -exce I
d) What is the payback period of this project?
e) Should Bogan accept or reject the project? Explain why.