Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please use the data from this sheet to fill in the missing values of the excel sheet and show excel formulas used to get values.
please use the data from this sheet to fill in the missing values of the excel sheet and show excel formulas used to get values. IT IS VERY IMPORTANT TO INCLUDE FORMULAS! thank you Problem: Year AZM Inc. is evaluating two mutually exclusive projects of making two types of SUVs: mini-SUV, and full- SUV. Assume the discount rate for both projects is 10 percent. The costs of investment and projected cash flows for both projects are given in the following table: AZM MINI-SUV AZM FULL-SUV 0 -$650,000 -$975,000 1 $330,000 490,000 2 $310,000 460,000 3 $260,000 410,000 Questions 1. What is the payback period of each project? Based on the payback period, which project should be taken? 2. What is the profitability index of each project? Based on the profitability index, which project should be taken? 3. What is the internal rate of return (IRR) of each project? Based on the IRR, which project should be taken? 4. What is the net present value (NPV) of each project? Based on the NPV, which project should be taken?? For additional reference, you can review Examples 3, 17, 19, and 20 in Chapter 20 Examples.xlsx posted on Blackboard for how to compute the payback period, profitability index, IRR and NPV. X Project 3 Format.xlsx File Edit Insert Format Help Calibri II BIUSA A Year 0 Mini Su Cash flows 4 FSUV Cash flows 10K 10 11 15 16 NENASARANNARRAREBRER Required return (used as the discount rate! Part 1 Mirisu Titial cash outlay Accumulated cash inflows Payback period 13 Full-SUV Initial cash outlay 14 Accumulated cash inflows Payback period Which project should be taken? 18 19 Part 2 20 Mini-SU Present value of cash inflows Present value of cash outflows Profitability index 2: Full Suv Present value of cash inflows Present value of cash outflows Profitability index Which project should be taken? Mini-US Internal rate of return (IRR) Full-SUV Internal rate of return URRI Which project should be blen? Part 4 > Minis Net present value INVI SUV Net prest value NPV Which protect should be taken
please use the data from this sheet to fill in the missing values of the excel sheet and show excel formulas used to get values. IT IS VERY IMPORTANT TO INCLUDE FORMULAS! thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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