Question: solve using Excel, please (don't copy from previous) FINAL PART B (TAKE HOME) (30 points) 1. The managers of a company are considering an investment

solve using Excel, please (don't copy from previous)

FINAL PART B (TAKE HOME) (30 points) 1. The managers of a company are considering an investment with the following estimated cash flows. MARR is 15% per year. Capital investment $30,000 Annual revenues $20,000 Annual expenses $5,000 Market value $1,000 Useful life 5 years solve using Excel The company is inclined to make the investment; however, the managers are nervous because all of the cash flows and the useful life are approximate values. The capital investment is known to be within 5%. Annual expenses are known to be within +10%. The annual revenue, market value, and useful life estimates are known to be within +20%. Analyze the sensitivity of PW to changes in each estimate individually. Based on your results, make a recommendation regarding whether or not they should proceed with this project. Graph your results for presentation to management

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

first problem you must use Excel and second problem you may use. FINAL PART B (TAKE HOME) (30 points) 1. The managers of a company are considering an investment with the following estimated cash...

result from excel shows (table and graph). FINAL PART B (TAKE HOME) (30 points) 1. The managers of a company are considering an investment with the following estimated cash flows. MARR is 15% per...

using Excel FINAL PART B (TAKE HOME) (30 points) 1. The managers of a company are considering an investment with the following estimated cash flows. MARR is 15% per year. Capital investment $30,000...

Part A: Qualitative Research (30 points) Section 1: Reading, Memo Writing and Categorizing (20 points) This portion of the assignment is designed to help you develop/employ key qualitative research...

HR Metrics: aSSIGNment 3 (15%) PROJECT SUMMARY This is a group project with a maximum of 3 students per group. You must sign up for a group through the group sign up page to receive a mark...

Please answer the questions 1 to 3 on the attached document regarding my accounting case study A1CPA Case Development Program Case No.97-12: A New Golf Ball at ~lson .I -~ A NEW GOLF BALL AT WILSON...

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

Location Income ($1,000) Urban 27 Rural 25 Suburban 25 Suburban 26 Rural 30 Urban 29 Rural 33 Urban 30 Suburban 32 Urban 34 Urban 35 Urban 40 Rural 30 Rural 33 Urban 42 Suburban 32 Urban 43 Urban 43...

Directions for Problem #4 in Excel The goal of this problem is to have you: Use Excel to generate the future value of each of the various investments made over the course of the 25 years. Use Excel...

On January 1, 2004, Holstein Enterprises issued bonds. Its accounting department prepared the amortization table below. Required A. What was the total face value of the bonds issued? B. At what price...

Surfactants (surface-acting agents) are compounds that lower the surface tension of a liquid, increasing the contact between the liquid and another substance. They enable the cleaning solution to wet...

Consider the following information: \ table [ [ State of , Probability of \ table [ [ Economy ] , [ Economy ] ] , . 1 5 , , Rate of , Return if , State Occurs ] , [ , Stock A , Stock B , , , , , ] ,...

In 2015, Fargo Corporation began construction work under a three-year contract. The contract price is $4,800,000. Fargo uses the percentage-of-completion method for financial accounting purposes. The...