PLEASE USE EXCEL FUNCTIONS IN EXCEL AND DO NOT SOLVE USING PV FACTOR BUT USING EXCEL FORMULAS !!!!

hapter 10: Aplia Homework What information does the payback period provide? Payback period essentially provides the number of years it would take for a project to recover the initial Investment from its operating cash flows. As the model was criticized, the model evolved incorporating time value of money to create the discounted payback method. The models still reflected faulty ranking criteria but they provided important Information about liquidity and risk. risky than cash flows received in the near-term-which suggests that the payback period can Cash flows expected in the distant future are also serve as an indicator of project risk. Suppose ABC Telecom Inc.'s CFO is evaluating a project with the following cash inflows. She does not know the project's initial cost; however, she does know that the project's regular payback period is 2.5 years. Cash Flow $300,000 Year Year 1 Year 2 Year 3 475,000 500,000 450,000 Year 4 If the project's weighted average cost of capital (WACC) is 9%, what is its NPV? O $354,910 O $390,401 O $372,656 O $337,165 Which of the following statements indicate a disadvantage of using the discounted payback period for capital budgeting decisions? Check all that apply The discounted payback period does not take the time value of money into account. The discounted payback period does not take the project's entire life into account. The discounted payback period is calculated using net income instead of cash flows