I am having to ask this question again because when it was answered, it was not formatted correctly. I need it done in excel where formulas are shown. I need the formula's to get credit.

Page 525 Montego Production Co. is considering an investment in new machinery for its factory. Various information about the proposed investment follows: Initial investment $860,000 Useful life 6 years Salvage value $ 20,000 Annual net income generated $ 66,000 Montego's cost of capital 11% Required: Help Montego evaluate this project by calculating each of the following: 1. Accounting rate of return. 2. Payback period. 3. Net present value. 4. Recalculate Montego's NPV assuming its cost of capital is 12 percent. 5. Based on your calculations of NPV, what would you estimate the project's internal rate of return to be? B E F H - J K L M N o D 1 Chapter 11 Leb, loosely based on PB 11-4, page 525 2 Enter formulas or descriptions in these fields 3 4 5 Given Data: 6 7 PB 11-4 part for ARR, Payback and IRR A. ARR, Accounting Rate of Return ARR = Calculation of cash flow needed for B thru D, you do need the salvage value 9 Initial Investment $860,000 10 Useful Life 6 Years 11 Annual Net Income $66,000 12 Cost of Capital 11% 13 (Use as Hurtle rate) 14 Salvage Value $60,000 15 16 Add'l data for NPV Calculation only 17 18 Working capital $20,000 19 20 21 22 23 Net Income Depreciation Cash Inflow Add back non cash expenditures (straight line) B. Payback Period Years C. Net Present Value (Calculate below 24 25 26 Discount Factor Present Value Years Cash flow 27 28 29 Totals actually always belong at the top since it's really what you want to see first Item NET PRESENT VALUE Initial Investment Annual Inflow Working Capital Working Capital Salvage Value 30 31 32 33