Question

investedent pajecl that tequte a cod Nau s00,c00 The fn plana a capthal chuchuk det equihy and set debt to finante this preject The fetUtently bave net inie me 43, s00poao Ta uadertate the inveshen prafect hee ophiens Bea's CansideahanOphen A ond Ophen B The itm ton arieptather Opian A or Ophin B bul nat beth tach project aphan wil last Syats have ho refoin gor all inveshilent preject is 81 The cach ate cnder the salvage value at the end The tem panye sequited tak ef OPHOR B i&rcco 173jocc Fubure lash s Year 2 Yore 3 Year Years 52.000 5s,oce S7,e.co 43500 47.000 64,000 S3,0c0 54,000 36c00 Requiced ay Determine the dicidend acual, ay by applying the teaidual theety by Cakolabe the dividend payot rahia Ddenkyy tahich pacject shocld the tempany arcept baued PEicd the base Piae fe payback it maximusn 3.5 years d Tdeabty hich peject feell the cempany aceept bued of Net Pres ent Yalue (NPY Methed offtensidenoy belh rde thcds which opten the be paid out share helket phoy shoeld cheate

Answer 1

Part (a) and (b)

Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last two rows highlighted in yellow contain your answer. All financials are in $.

Parameter	Linkage	Option A	Option B
Cost	A	178,000	187,000
Equity funded proportion	B	40%	40%
Equity required	C = A x B	71,200	74,800
Net income	D	3,500,000	3,500,000
Part (a): Residual dividend	E = D - C	3,322,000	3,313,000
Part (b): Dividend payout ratio	F = E / D	94.91%	94.66%

For part (c), (d) and (e), i am first providing the answers. Details workings along with the snapshot is available towards the end of the solution.

Part (c)

Based on payback period, the company should choose option B (shown as option 2) in the table below, as it has payback period of 3.31 years less than the cutoff value of 3.5 years.

Part (d)

Based on NPV, the company should choose option B (shown as option 2) in the table below, as it has higher NPV than option A.

Part (e)

Considering both the methods, the company should choose option B. This has higher NPV and meets the payback criterion of the firm as well.

Please see the table below. The rows highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used.

AR AS AU AQ AT AV AW |87 Option 1 88 Cash flows 89 Cumulative cash flows (178,000) (178,000) 52,000 57,000 40,000 55,000 43,500 (86,000) (138,000) (31,000) 26,000 69,500 |90 Payback period 91 Discount rate =AU186-AU189/AV188 3.54 8% 92 NPV 93 94 Option 2 95 Cash flows 96 Cumulative cash flows 97 Payback period 98 Discount rate 99 NPV =NPV(AR191,AS188:AW188)+AR188 18,781.50 (187,000) (187,000) 64,000 (76,000) =AU186-AU196/AV195 47,000 59,000 54,000 36,000 (140,000) (17,000) 37,000 73,000 3.31 8% =NPV(AR198,AS195:AW195)+AR195 22,416.91