The Lansford Office Equipment Co. is considering the purchase of a new machine that would increase the speed of

manufacturing electronic equipment and save money. The net cost of the new machine is $ 68,000. The annual cash flows have the following projections:

                      Year                 Amount

                       1                    $ 20,000

                       2                       28,000

                       3                       30,000

                       4                       14,000

                       5                        11,000

If the cost of capital is 10 percent, find the following:

A. The Net Present Value

B. The Internal Rate of Return

C. The Payback Period.

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Requirements:Moving Averages.  Use the below actual sales to calculate a

three-year average which will be used as the forecast for next periods (chapter 14, text).Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text).Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text).

Month Actual Sales

1 3050

2 2950

3 3670

4 2910

5 3340

6 4060

7 4750

8 5510

9 5280

10 5504

11 5810

12 6100

 

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"