ZuoTi.Pro
Question

I want to you to do the spreadsheet in Excel if that’s possible.

I want to you to do the spreadsheet in Excel if that’s possible.
media%2Fbf3%2Fbf371e79-7ef3-47c0-9c47-d8
business   economics   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Steps: Write down the net cash flows of each alternative and calculate their net present value. This can be seen as below: Brush Alternative: Year Net Cash Flow 400000 PV -400000 55555.56 47153.64 39691.61 33076.34 -27223.33 22055.94 17504.71 13506.72 10004.98 16211.77 649561.05 0 2 55000 4 -45000 -40000 35000 6 -25000 -20000 35000 10 NPV>> Formula used Year Net Cash Flow PV B3+5000 B4+5000 -B5+5000 B6+5000 B7+5000 -B8+5000 B9+5000 B10+5000 -B11+5000+50000 B12/(1.08 A12 -82/( 1.08^А2) B3/(1.08 A3 B4/(1.084A4) B5/(1.08 A5 B6/(1.08 A6 -87/( 1.08*Α7) B8/(1.08 A8 B9/(1.08 A9 -810/( 1.08*Α 10) -811/( 1.08*Α11) 10 8 11 9 12 10 3NPV>> SUM(C2:C12

Thus, NPV of Brush alternative = (-)$649,561.05 Bead alternative: Since n-infinity, NPVー-400,000 + (-70000/0.08) NPV ()S1,275,000 Thus, NPV of Bead alternative-()S1,275,000 Since Brush has a lower NPV of costs, the producer should go ahead with the Brush Alternative.

0 0
Add a comment
Know the answer?
Add Answer to:
I want to you to do the spreadsheet in Excel if that’s possible.
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Excel spreadsheet I am clueless when it comes to excel. I need to make a spreadsheet...

    Excel spreadsheet I am clueless when it comes to excel. I need to make a spreadsheet where i can type in employee names, the number of tests they completed and the day they were completed. Im not sure what this spreadsheet would even look like. Any help would be appreciated

  • pls solve this mathematically use a time diagram if possible. please do not use excel spreadsheet...

    pls solve this mathematically use a time diagram if possible. please do not use excel spreadsheet 2. (10 points) An insurance policy requires premium payments of $15 at the begin- ning of each month for 20 years. Determine the discounted and accumulated values of these payments at j4 = 6%.

  • I need help with the following by 11:30pm if possible- thank you!! Spreadsheet, Using Excel: On...

    I need help with the following by 11:30pm if possible- thank you!! Spreadsheet, Using Excel: On a nursing unit there are several employees. Use a spreadsheet to enter the data below. Type of Employee Number Full Time Radiology Technician 24 Part Time Radiology Technician 22 Full Time Sonographer 20 Part Time Sonographer 16 Full Time MRI Technician 20 Part Time MRI Technician 12 Social Worker/Community Health 6 Laboratory/Phlebotomist 3 Registered Nurse 2 Pharmacist 1 Determine the total number of employees...

  • Due: November 4.2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to...

    Due: November 4.2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to calculate your answers b. All calculations must be done in Excel Do not calculate anything on your calculator and just enter the number into Excel (if you do this, you will not receive credit for this assignment). Do the calculation within the cell c. You must reference cells from your base case (Only input variables that change for each requirement.) d. Your spreadsheet should...

  • You are to create an Excel spreadsheet that calculates the issue price of a bond. Your...

    You are to create an Excel spreadsheet that calculates the issue price of a bond. Your spreadsheet should prompt the user for all relevant inputs, then calculate and clearly display the issue price. Email your completed spreadsheet to me. If you do this project with a colleague, please include both names on the spreadsheet.

  • You are to create an Excel spreadsheet that calculates the issue price of a bond. Pick...

    You are to create an Excel spreadsheet that calculates the issue price of a bond. Pick any bond! Your spreadsheet should prompt the user for all relevant inputs, then calculate and clearly display the issue price. Email your completed spreadsheet to me. If you do this project with a colleague, please include both names on the spreadsheet.

  • Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank...

    Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank you so much. Cooper Pharmaceuticals, a specialty pharmaceutical company, has made significant investments to develop several product lines of 3D printed drugs. However, with patents on some of its most popular brand-name drugs expiring in the near future, the company is expecting a significant financial hit. As a result, the Finance Department has determined that only two of the five product lines under...

  • Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank...

    Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank you so much. Cooper Pharmaceuticals, a specialty pharmaceutical company, has made significant investments to develop several product lines of 3D printed drugs. However, with patents on some of its most popular brand-name drugs expiring in the near future, the company is expecting a significant financial hit. As a result, the Finance Department has determined that only two of the five product lines under...

  • (Please show if possible on excel .I believe i'm close but want to double check) The...

    (Please show if possible on excel .I believe i'm close but want to double check) The Wall Street Journal reported that automobile crashes cost the United States $162 billion annually. The average cost per person for crashes in the Tampa, Florida, area was reported to be $1900. Suppose this average cost was based on a sample of 50 persons who had been involved in car crashes and that the population standard deviation is known to be $500. What is the...

  • I have an excel spreadsheet with 3columns filled as: column 1: time in sec Column 2...

    I have an excel spreadsheet with 3columns filled as: column 1: time in sec Column 2 : load in newtons Column 3: position in mm I imported the data to matlab And need to use matlab to calculate the engineering stress and strain and true stress and strain How do i use the imported spreadsheet data to calculate those Pleasssee help Note: each column has lots of data collection

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT