FORMULA MUST INCLUDE PV FUNCTION ON EXCEL FOR IT TO COUNT. No handwritten answers.

A company is considering a $142.000 investment in marhineru with tha fallo...in mat cash flows. The PV(rate, nper, pmt, [fv], [type]) Description Returns the present value of an investment: the total amount that a series of future payments is worth now Example =PV(0.08/12,1220,500,0) rate is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR nper is the total number of payment periods in an investment pmt is the payment made each period and cannot change over the life of the investment [fv] is the future value, or a cash balance you want to attain after the last payment is made [type] is a logical value: payment at the beginning of the period =1; payment at the end of the period =0 or omitted s ques Learn more about PV Give feedback