Use excel to solve the following problems from your textbook
First, you must enter the formulas to solve these problems. The following formula can be used to calculate the annual cash flow from a machine costing $50,000 that has a salvage price of $15,000, and the payback or discounted payback.
Payback=SUM(C4:H4)/G4 where C4:H4 represents cash flow in each year/period from 0-5 & G4 represents cost of machine ($50k)
Discounted Payback=NPV(rate in cell A6,-C7:-H7)/ABS(G7) where rate is rate used for discounting (10%), C7:H7 is cash flows for each period from 0-5 & G7 is net investment (-35k).
Average Accounting Return = (Net Income Before Tax + Depreciation)/Investment.
Net Present Value=NVP(F8B$1/12,-D11:L11)+B13*F9 where F8 is discount rate as entered by user & D11–L11 represents Cash Flow table columns B-K on page 306 with B13 being Initial Investment
.IRR =IRR(-D16:-L16)where D16–L16 are columns B-K representing Cash Flow table on Page 306. MIRR=MIRR(-D19:-L19,.2,.12 ) where D19–L19 are columns B-K representing Cash Flow table on Page 308 with .2 being reinvestment rate & .12 being required return inputted by user