Find the present value of additional sales and compare it to the equipment cost

Please answer questions 1 (15 points) , 3 (15 points) , 4 (20 points) and 5 (30 points) from the case “Developing financial insights: Using A Future Value (FV) and A Present Value (PV) Approach”. No need to use the tables at the end of the case if you are comfortable with Excel Functions.
Submit only an Excel file. Work on each question in a separate worksheet of the same Excel file. Name the sheets Q1, Q2, etc. Clearly indicate where you have the answer to each part. Show calculations. All values in the file should be linked to information from the question.
Some Hints:
Question 3. Present value of savings for the 3 cases should be calculated for this question.
Question 4. Find the present value of additional sales and compare it to the equipment cost. For the taxable entity, make sure you add the depreciation to calculate free-cash flow.
Question 5. The first part is calculating the NPV, which will turn out to be negative. For the additional cash flow problem, think of the question as an annuity. The value found from the annuity is going to be after-tax cash flow, which can then be used to find the before tax cash flow, which is more important to find. For the last question, you have to think of something that is not easily quantifiable (i.e., hard to calculate the monetary value of it and hard to include in NPV calculations), but can make even negative NPV projects acceptable to companies (this may seem contrary to what you have learned so far). One example is safety of travel (in the sense of not coming in contact with anyone else from outside the company. This is more true at times of pandemic.). The question is how do you put a monetary value on the safety of travel. It is expected that the submitted answer will not include this particular example of non-monetary considerations since this is given out.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.