Question

6. The payback period Aa Aa The payback method helps firms establish and identify a maximum acceptable payback period that helps in their capital budgeting decisions. Consider the case of Cold Goose Metal Works Inc.: Cold Goose Metal Works Inc. is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Delta's expected future cash flows. To answer this question, Cold Goose's CFO has asked that you compute the project's payback period using the following expected net cash flows and assuming that the cash flows are received evenly throughout each year. Complete the following table and compute the project's conventional payback period. For full credit, complete the entire table Year 0 Year 1 Year 2 Year 3 Expected cash flow Cumulative cash flow 4,500,000 $1,800,000 $3,825,000 $1,575,000 Conventional payback period:

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E " ゴWrap Text ta copy." в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells AU178 Formula Bar AQ AR AS AT AV AW AX AY 162 163 164 ANS 2 165 166 167 168 169 170 DISCOUNTED PAYBACK PERIOD YEAR CFAT PV FACTOR @7% DISCOUNTED CASH FLOW DISCOUNTED CCFAT 0 2 3825000 0.8734 -4500000 1575000 0.8163 4500000 1682242.99 3340903.141285669.16 2817757.01 523146.13 1808815.28 1800000 0.9346 INVESTMENT WILL BE RECOVERED IN 2 ND YEAR 172 173 174 175 176 DISCOUNTED PBP-1 + CCFAT1/(CFAT2 DISCOUNTED PBP 1+2817757.01/3340903.14 PBP = 1.84341 YEARS PBP = 1.84 YEARS 178 179 180 | IRRnpv | RATION PBP ARR , external rate . MIRR NpV IRR REPLACEMENT S / HPR GMAM , EAC MACRS RATIOCASHBUDGET wacc BOND | EPS EBIT- REPLACEMENT- STats 14 > erences: JF17 福 130% 12:26 21-01-2019