Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. The purchase price, the amount of the single cash inflow Click the icon to see the Worked Solution (Formula Solution). Click the icon to
. The purchase price, the amount of the single cash inflow Click the icon to see the Worked Solution (Formula Solution). Click the icon to see the Worked Solution (Financial Calculator Solution). Click the icon to see the Worked Solution (Spreadsheet Solution). The present value of Investment A is \$ (Round to the nearest cent.) The present value of Investment B is $[ (Round to the nearest cent.) The present value of Investment C is $ (Round to the nearest cent.) The present value of Investment D is $ (Round to the nearest cent.) Which purchase recommendations would you make, assuming that Tom can earn 10% on his investments? (Select the best answer below.) A. Investment D B. Investments A and C C. Investment B D. Investments B and C Review Worked Solution (Spreadsheet Solution) Excel offers a mathematical function that makes the calculation of present values easy. The format of that function is PV(rate,nper,pmt,fv,type). The terms inside the parentheses are inputs that Excel requires to calculate the present value. The terms "rate" and "nper" refer to the interest rate and the number of time periods respectively. The term "fv" represents the lump sum (or future value) that you will receive in the future. The term "pmt" refers to the annual payment that an annuity offers. The term "type" is an input that lets Excel know whether the annuity being valued is an ordinary annuity (in which case the input value for "type" is 0 or omitted) or an annuity due (in which case the correct input value for "type" is 1). For now, we will ignore the two inputs, "pmt" and "type," and enter a value of zero. The present value of Investment A is computed as follows: The present value of Investment B is computed as follows: Worked Solution (Financial Calculator Solution) When solving for the present value of a single cash flow using a financial calculator, you will need to input the values of N,I,PMT, and FV. Make sure you enter a zero for PMT, which is not used in the problem. Since compounding is annual, the periods per year setting on your calculator should be set at 1,P/Y=1. On many calculators, the present value will be preceded by a minus sign for a cash outflow. If a minus sign appears on your calculator, ignore it here. The present value of Investment A is computed as follows: The present value of Investment B is computed as follows: Review Worked Solution (Formula Solution) In order to decide which investments that Tom Alexander should take, all cash flows must be in the same time period, so you need to find the present value of each cash flow today before you can compare these values with the quoted purchase price for each investment. The present value, PV, of some future amount, FVn, to be received n periods from now, assuming an interest rate (or opportunity cost) of r, is calculated as follows: PV=(1+r)nFVn Substituting FVn=$6,735,r=0.10, and n=3 into the present value equation yields: PV=(1+0.10)3$6,735=$5,060.11 Thus, the value of Investment A today is $5,060.11. The present value of Investment B is: PV=(1+0.10)18$698=$125.54 The present value of Investment C is: PV=(1+0.10)8$2,061=$961.47 Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started