Question

QUESTION M.C.Q (Please answer this question as soon as possible)
You are expecting to receive $100,000 at the end of year 4 and another $100,000 at the end of year 6. What is the present value of the receivables if the interest rate is 5%? $161,005.30
$164,736.38
$154,457.98
$156,891.79
$165,324.49

Answer 1

H299 fi -SUM(H293:H298) D Year Cashflow PVCF PV@5% 0.952380952 0.907029478 0.863837599 0.822702475 0.783526166 0.746215397 Present Value 100,000.00 $ $ $ $ $ $ $ 82,270.25 297 100,000.00 298 299 74,621.54 156,891.79 300 301 302

H299 fc =SUM(H293:H298) 291 Year Cashflow 294 295 PV@5% =1/1.05 =G293/1.05 =G294/1.05 =G295/1.05 =G296/1.05 =G297/1.05 Present Value PVCF =F293*G293 =F294*G294 =F295*G295 =F296*G296 =F297*G297 =F298*G298 =SUM(H293:H298) 296 100000 297 298 100000 299 300 301 303 304