Question: Please show the Excel cell reference. Thank you in advance :) ill leave a thumbs up AB 1 Capital Investment Decisions and the Time Value
Please show the Excel cell reference. Thank you in advance :) ill leave a thumbs up 

AB 1 Capital Investment Decisions and the Time Value of Money 2 Fund future cash flows Samantha wants to take the next four years off work to travel around the world. She estimates her annual cash needs at $30,000 (if she needs more, she'll work odd jobs). Samantha believes she can invest her savings at 8% until she depletes 4 her funds Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction 7 tab you will be marked wrong. 8 9 Requirements 10 1 How much money does Samantha need now to fund her travels. a. Use a single Excel formula function PV and be sure to enter any payment amount with a minus sign or parenthesis. 2 After checking with a number of banks, Samantha learns she'll be able to invest her funds only at 6%. How much does she need now to fund her travels? a. Use a single Excel formula function PV and be sure to enter any payment amount with a minus sign or parenthesis. 14 11 12 13 1 1. How much money does Samantha need now to fund her travels. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 2 from the instruction tab you will be marked wrong. 4 Money needed now to fund her travels 5 2. After checking with a number of banks, Samantha learns she'll be able to invest her funds only 6 at 6%. How much does she need now to fund her travels? (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste 7 from the instruction tab you will be marked wrong. 9 Money needed now to fund her travels
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
