Function SLN FORMULA multiply, subtract, add cell reference

BE7.3 - Using Excel to Calculate the Simple Payback Period and IRR Required: Provide input into cells shaded in yellow in this template. PROBLEM Ava just graduated from college. Since she is starting her own business, it's time to upgrade from her clunker to a reliable vehicle. Ava has the option to purchase a new car for her business at a cost, Input the required mathematical formulas or functions with cell estimating that it would help her bring in additional annual net references to the Problem area or work area as indicated. operating cash flows. Information pertaining to the proposed Derationg cash flows. Information pertaing to the proposed payback period. 12 . Simple payback period Determine the annual depreciat Annual depreciation Determine the after-tax annual cash flows. After-tax cash flows List the cash flows by year and determine the IRR for this investment